warnings continue after stopped job

kjaouhari · Post by **kjaouhari** » Tue Nov 21, 2006 2:43 pm

Hello all ,

I run a simple job with 2 stage oracle, I have an error when executing the job the error message is : constraint violation of primary_key.

Then I stop the job in director, the job is stopped and I reset it , but warnings continue to log. I think the sql query continue to run may be ...

Do you have similar problem ?

thank

chulett · Post by **chulett** » Tue Nov 21, 2006 2:50 pm

Could be... stopping the job doesn't always kill the Oracle query - that can take a DBA sometimes. Or you may just have a ton of messages queued up and it is still playing 'catch-up' actually writing them out.

dsscholar · Post by **dsscholar** » Tue Nov 21, 2006 2:54 pm

Did you check Director to see whether the PID for this particular job is still available or not. If you find it, ask your DBA to kill the query, that should solve your problem.

DeepakCorning · Post by **DeepakCorning** » Tue Nov 21, 2006 3:10 pm

The job may have stopped but the job will keep on showing the warnings til the end (last warning).

If you do not want to continue then you will have to rename the job so that the PID changes. But I think the log will remain the DS folder as it may not delete it as it is still writing.

kjaouhari · Post by **kjaouhari** » Tue Nov 21, 2006 3:12 pm

Yes I ask to my DBA to kill the session, but warnings continue I hope it was just warnigs queued ...

ray.wurlod · Post by **ray.wurlod** » Tue Nov 21, 2006 3:52 pm

It IS warnings queued. You should test with ten rows, not ten crore!

chulett · Post by **chulett** » Tue Nov 21, 2006 3:55 pm

Also not an issue if you do not run with unlimited warnings... i.e. the limit set to 'No limit' = bad.

kjaouhari · Post by **kjaouhari** » Wed Nov 22, 2006 3:00 am

No in fact I have started the job with limit of 10 rows ...

chulett · Post by **chulett** » Wed Nov 22, 2006 8:30 am

Well then, just how many warnings did these 10 rows produce?

More of an informational post than anything else.