DSXchange

Can you check your OCI Stage genrated TO_DATE is it matching with "yyyy-mm-dd HH:MM:SS.SSS"....


Thanks,
Anupam

jojipjohn wrote: while importing definations for that column i have given it as varchar(1500)

Have you provided it manually... Use whatever metadata coming for column after improting from database.

Thanks,
Anupam

You can also try TO_DATE of oracle function by writing user-defined SQL insert statement in target stage....


Thanks,
Anupam

I guess currently no need of considering security issues...


Thanks,
Anupam

Try the following this will create file and write to0

* t.var is directory name
* Filename is name of file
* Logrec is log record

Openpath DirName to fvar then
write Logrec to fvar, FileName


Thanks,
Anupam

Berfore doing upgration take project level backup, Job level back, routine backup and parameter file backup...


Thanks,
Anupam

Try this also....

SELECT * FROM VOC WHERE NAME LIKE 'DSU.ExecSH'

any records?

if not copy the code of ExecSH from manager and create new routine and compile....

and execute the above query with new routine name start with DSU....


I hope this will help to catalog routine....


Thanks,
Anupam

Please try following...

SELECT * FROM VOC WHERE NAME LIKE 'DSX.EXECSH'

in TCL

Thanks,
Anupam

I think there is problem with your OS permission......
Please check with your administrator....


Thanks,
Anupam

Your job type is parallel and you posted your query in server jobs...


Thanks,
Anupam

Try to create same setup with small job in test enviroment and there you try to execute... It is working fine here and getting correct result.

Thanks,
Anupam

Is it happing to that 2333 row only ? with timestamp value "1998-01-31 00:00:00"

Thanks,
Anupam

For this you wont be even need to include the terminator stage. Just "check Automatically handle that fail". Make the 5 job activities independent. But i think it will show the status of sequence completed sucessfully at end. and i think siva dont want that status of sequence. and as he i...

Why dont you try to insert manually 1 row in target with this date format.... May be one of the way to check format of table...

Thanks,
Anupam

Link all jobs to sequencer stage, keep sequencer mode as all, link it to nested condition , place status of all job in trigger of nested condition "Jobname1.$jobstatus=DSJS.RUNFAILED or Jobname2.$jobstatus=DSJS.RUNFAILED...................." link that to terminator activity... Thanks, Anupam