Re: Error connecting to the database DBMPPri.
From: joel garry <joel-garry_at_home.com>
Date: Thu, 16 Feb 2012 08:38:40 -0800 (PST)
Message-ID: <8f231587-b2da-49c0-bdc7-89a2b3fd6522_at_ir9g2000pbc.googlegroups.com>
On Feb 15, 7: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.
Date: Thu, 16 Feb 2012 08:38:40 -0800 (PST)
Message-ID: <8f231587-b2da-49c0-bdc7-89a2b3fd6522_at_ir9g2000pbc.googlegroups.com>
On Feb 15, 7: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 group is not here to do your work for you. You are expected to understand what your work is. Here is a primer about this group: http://dbaoracle.net/readme-cdos.htm#subj6 Sorry I haven't gotten around to fixing all the broken links yet.
You should look at line 152 of your blow job. I'll bet someone walked in on someone else who wasn't supposed to be there.
jg
-- _at_home.com is bogus. http://www.theregister.co.uk/2012/02/10/oracle_advanced_analytics/Received on Thu Feb 16 2012 - 10:38:40 CST