Re: Error connecting to the database DBMPPri.

From: onedbguru <onedbguru_at_yahoo.com>
Date: Thu, 16 Feb 2012 19:01:53 -0800 (PST)
Message-ID: <21a28ae9-46f8-4bf7-856a-5b9f36a734c0_at_e27g2000vbu.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.

This probably has something to do with the other error message you posted a few days ago.. you need to start at the beginning and work your way forward. Received on Thu Feb 16 2012 - 21:01:53 CST