DSXchange

Hi Ray, By searching thru the forum for similar problem posted earlier, I understand that IsValid() function is only available in parallel job not server job. I have also downloaded the IsValid() function for server job which you have posted earlier and encountered the following error while compilin...

I am new in Datastage, thought that Datastage is so powerful that it can understand Oracle specific syntax as well... :oops: Alright, let me explain what exactly that i wanted to do with the regular expression in details. I have a Datastage job with a Transformer having a single input and 2 outputs....

Hi, Has anyone tried using Oracle regular expression in transformer stage constraints? I am trying to use it to do data filtering i.e. data which do not fulfill the condition will be rejected and stored in Reject Table. The regular expression that I am using is as below: REGEXP_LIKE(SUBSTR(COLUMN_NA...

Yes this command will call logica_inp_inss job.
Parameter is included in the command.
No error message.

this is a cron command. the 12 14 * * * is the time the script is used to run datastage job cron command is 12 14 * * * su - dsadmin -c "./dsprod01/LOGICA_TRANS/daily/script.sh" >> /dsprod01/LOGICA_TRANS/daily/aaa.log Content of the script is su - dsadm -c "/ardent/Ascential/DataStage...

Hi all,

Can anyone tell me why is my command is not running the job? please help

12 14 * * * su - dsadmin -c "./dsprod01/LOGICA_TRANS/daily/script.sh" >> /dsprod01/LOGICA_TRANS/daily/aaa.log

That was your first problem - I never run Server jobs with the warning limit set to 'no limit'. Never. Your log is at the very least HUGE and at worst case corrupted. :!: As Ken noted, you also stand an excellent chance of something like that filling up the disk where DataStage is installed to disa...

Define "can't view the logs". What happens when you try - an error, a hang, what? If I had to guess I would wonder if they are large and will take some time to view. Did you run your job with 'unlimited' warnings? As noted - You set the timeout via the Administrator. It's at the bottom of...

The cause of this error found. It was the Table index was corrupted. MJobLoadSubDimToSubTracking..TRNSF_SUBSCRIPTION: ORA-01502: index 'CI_STAGING.SUB_TRKG_PK' or partition of such index is in unusable state Sigh !!! but i wonder why i can't view the logs. As you mention previously... where do i set...

hi i was trying to run my job. It gave me this error after a few hours. i couldn't go to the log to check. Just keep on hitting the error. Any suggestions ? Wat does the DSR_EXECJOB Action = 5 means ?

Hi everyone, I need your kind assistance on the following errors. Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project CIPREPAID2 (Subroutine failed to complete successfully (30107)) I've tried restarting the DataStage. I've tried recreate the index and re...

hi all, Thanks a lot for the advice. Its actually an error caused by the job which creates the hash file. It was not compiled. So i recompile it and its fine now. But its kind of weird, the job was compiled and running fine previously. How on earth did the job status became "Not Compiled" ...

hi all thanks for ur kind assistance, I've able to delete the hash file. I rerun the job hoping that i would run without abort but it didnt and it shows this error DJobFlushLogicaPrepaidDailyBalanceHash4%rel50.1.0..LOG_PRE_DAILY_BAL_DUP_HASH_FROM4.in: DSD.UVOpen Unable to open file LOG_PRE_DAILY_BAL...

hi chulett, "Is the hashed file in an 'account' or pathed into a directory? How did you try to delete the file? Has the job ever worked and is just now having this problem? Describe your job - are you using the hashed file as a reference lookup? If yes, it must exist first and have been created...

hi, thanks for the help but i'm just a regular member. i cant read the whole message u replied. please help. i did tried to delete the hash file. but it reply there's no such hash file.