Re: Error connecting to the database DBMPPri.

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 16 Feb 2012 09:04:27 -0800 (PST)
Message-ID: <23e01443-88f0-4719-9158-8b2de7a8703b_at_h6g2000yqk.googlegroups.com>

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