Re: Error connecting to the database DBMPPri.
Date: Thu, 16 Feb 2012 09:04:27 -0800 (PST)
On Feb 15, 10:57 pm, Long Nguyen <longn..._at_gmail.com> wrote:
> Hi everyone,
> Our company has a batchjob called BJ_SMS that being run every 12PM.
> When it functions, the database belongs to yesterday will be transfer
> to a table that called "OLDDAY" and and the table TODAY will be left
> blank to be filled by the database that is spawned today. A couple of
> days ago, we had a problem with it. The error blow is what we came
> across with:
> Connecting to the database DBMPPri.
> ORA-00001: unique constraint (HSBUSER.SYS_C0011006) violated
> ORA-06512: at "HSBUSER.BJ_SMS", line 152
> ORA-06512: at line 5
> Process exited.
> Disconnecting from the database DBMPPri.
> Would you mind helping me to solve this problem? Thank you in advance.
Your job encountered a duplicate key and it would appear that no error handling was built into the job so it rolled over and died rather than just saving a message about the issue into an error logging table and continuing. You need to determine why a duplicate was encountered and then determine how this situation should be handled.
HTH -- Mark D Powell -- Received on Thu Feb 16 2012 - 11:04:27 CST