Issue: ORA-01480 Trailing null missing from STR bind value

chulett · Post by **chulett** » Sun Jul 27, 2008 3:26 pm

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.

Rama_gg002 · Post by **Rama_gg002** » Sun Jul 27, 2008 3:42 pm

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

chulett · Post by **chulett** » Sun Jul 27, 2008 8:24 pm

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.

chulett · Post by **chulett** » Mon Jul 28, 2008 9:13 am

Ok! Sounds like it is time to mark your post as Resolved.

Rama_gg002 · Post by **Rama_gg002** » Mon Jul 28, 2008 9:55 am

Hi Craig,

How to make it Resolved? I am new to this world.Any ways, thanks for your help

chulett · Post by **chulett** » Mon Jul 28, 2008 10:08 am

Like that! :wink:

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.