Page 1 of 1
Posted: Sun Jul 27, 2008 3:26 pm
by chulett
Welcome. :D
A little confused here. Can you please explain the different between when you "compile and run it as a single job" versus the 10 server jobs run by the Sequence (no 'r') job? Is each job only processing 1/10 of the data in the latter case? Does only one job of the ten fail?
I'd also be curious about your job design, specifically what stage you are using for your Oracle load.
Posted: Sun Jul 27, 2008 3:42 pm
by Rama_gg002
chulett wrote:Welcome. :D
A little confused here. Can you please explain the different between when you "compile and run it as a single job" versus the 10 server jobs run by the Sequence (no 'r') job? Is each job only processing 1/10 of the data in the latter case? Does only one job of the ten fail?
I'd also be curious about your job design, specifically what stage you are using for your Oracle load.
This job failed when I ran it through the Sequencer which contain 10 such diffrent jobs and all of them ran to success except one job so I tried to run the failed job as standalone which worked fine with no changes(just compiled)
9 Jobs ran to success in this Sequencer and Only one job failing with the above said error.
Job design:
DRS stage to select the data from Oracle(Source), Transformer to add load date to the rows, DRS stage to insert the data into Oracle(Target)(It's just stright pull from Oracle and load to Oracle )
Thanks
Posted: Sun Jul 27, 2008 8:24 pm
by chulett
Interesting. This smells more of bug than problem with your job design, especially considering the ORA error:
ORA-01480: trailing null missing from STR bind value
Cause: A bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer.
Action: Terminate the string with a null character
Not really something you have control over. Have you been able to recreate this or was it a "one time" error? Meaning, if you run the
Sequence job (again, no "r" there) does it fail again?
Regardless, unless someone else has some insight into this, I'd suggest it is time to open up a case with your official support provider.
Posted: Mon Jul 28, 2008 9:13 am
by chulett
Ok! Sounds like it is time to mark your post as Resolved.
Posted: Mon Jul 28, 2008 9:55 am
by Rama_gg002
Hi Craig,
How to make it Resolved? I am new to this world.Any ways, thanks for your help
Posted: Mon Jul 28, 2008 10:08 am
by chulett
Like that!
There is a pair of buttons at the top of the screen that only show up if you started the thread, one to mark as
Resolved and the other
Wordaround. Once marked, you then have the option to undo that choice.