DSXchange

Hi All We are getting this error frequently during the job run. This is a windows based DataStage setup Error - Attempting to cleanup after Abort raised in the job DataStage continuously logs this error and fails after 50 warnings. For resolving it, I am making copy of job and it runs fine. However,...

Thanks Ray. I will check

The point of confusion to me is why it is making checkpointed call on most occasions and a normal call at few times.

There is no abort in the sequencer in any case

Thanks for your help

Hi Friends I am facing a issue with a sequencer. Sequencer design is as below Routine Activity---> Job Many a times the sequencer is making checkpointed run to routine. In this case it is not returning value to job and job is running with default parameter. RC_SEQ_J_G4211..JobControl (@Routine_MapVa...

The warning is coming in source stage.

Trying to get the DB maintenance details

Thanks

Sorry the previous post had smiles enabled

In the database this column is varchar2(8) and in the DataStage it is varchar(8). Does varchar and varchar2 cause any difference ?

Thanks for your response

1.This column is a Database column
2. In the database this column is varchar2(8) and in the DataStage it is varchar(8). Does varchar and varchar2 cause any difference ?

Hi Friends I am getting below warning messages in multiple jobs Implicit conversion from source type "string[max=24]" to result type "string[max=8]": Possible truncation of variable length string. These warnings were not coming earlier. We had a DB maintenance after which we are ...

Hi All

For this issue, we raised PMR with IBM.

IBM support suggested to disable the DATE/TIME Server locale to OFF in DataStage admin client.

This solved the issue

Thanks all for your help.

Hi Friends

Regarding the NLS, yes you are right.

We didn't had it enabled on old server however NLS is enabled on new server.

Is it possible that we can disable NLS now or is this option configurable only at the time of installation and can't be changed later on ?

Thanks all for your help

Yes. you all are right. Its not a DataStage Function. Its a server routine Below is the code Dimension f(23), v(23) datepart=Field(date," ", 1) timepart=Field(date," ", 2) * dy=OConv(IConv(datepart, "D-YMD[4,2,2]"),"DWB") * day=OConv(IConv(datepart, "D-YM...

Hi Friends We have migrated to a new server. After migration,We are facing a strange issue We are using below code to extract day of week from a date. ToChar('2014-10-01',"D") It is returning value as 3 in old server where same code is returning 4 on new server. The values of DataStage env...

Hello Friends I am getting this error while running the job from director >##E IIS-DSEE-TOSH-00205 13:52:28(006) <main_program> PATH search failure: >##E IIS-DSEE-TFOG-00006 13:52:28(007) <main_program> Error loading "orchoracle": Could not load "orchoracle": libclntsh.so.10.1: c...

Hello Friends We are facing a sql loader error in DataStage jobs SQL*Loader-951: Error calling once/load initialization ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist These jobs are doing a truncate & load. Also a pattern observed is this is happening ...

We are still getting the error.

We have the jobs scheduled through DataStage Scheduler

We are observing that when this job runs from Scheduler,it fails with the above error

When it is triggered manually,it runs successfully

Any ideas ?

Thank you all for your help

Hi Ray

yes...the job uses DRS stage to read from Oracle table and loads into Hash File