Insert not happening when the job is run through sequencer

sumesh.abraham · Post by **sumesh.abraham** » Tue Mar 04, 2008 8:56 am

Hi All,

I'm inserting records into an Oracle table using Oracle Enterprise stage and the Write method is Upsert. I've mentioned the Update SQL and Insert SQL statements correctly. When I run the job records are getting inserted into the table successfully. But when I run the job through sequencer, records are not getting inserted. The director log shows 0 records inserted, 0 records updated, 3 records rejected. The sequencer is getting finished successfully, but no records are getting inserted. What could be the issue here. I would appreciate if anyone can help me out in resolving this issue.

Thanks,
Sumesh

ArndW · Post by **ArndW** » Tue Mar 04, 2008 9:05 am

A job will not run differently when called directly or from a job sequence - unless you pass different parameter values. Could this be the case?

sumesh.abraham · Post by **sumesh.abraham** » Tue Mar 04, 2008 9:32 am

The paramters are correctly specified in the sequencer. Still I get the records not inserted into the table. What could be the cause?

ArndW · Post by **ArndW** » Tue Mar 04, 2008 10:07 am

Compare the director log entries for the parameters between the manual run and the job sequencer.

A job will not "know" that it was started from a job sequence so there should be absolutely no difference between runs.

Change your Oracle output stage to have a reject link and find out the reject reasons.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 5:08 pm

sumesh.abraham wrote:The paramters are correctly specified in the sequencer.

How can/did you prove this?