| Author |
Message
|
| EricCox |
 Posted: Thu Jun 07, 2012 5:57 am Post subject: Encountering PK Violation even after the PK has been removed |
 |
|
Master
Joined: 08 Apr 2011
Posts: 292
|
To all,
On WMB 6.0.0.9 using Data Direct Oracle 5.3 Driver going against Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Here is the scenario:
1.) Remove PK From Tablex
2.) Call SPROC(INSERT to Tablex) from Broker Message Flow Compute Node
3.) Broker Call to SPROC fails indicating PK Violation on removed PK
Oracle believes the PK has been removed. However, when CALLDB'ing the SPROC in Broker I still encounter the PK Violation when trying to INSERT the row.
Has anyone seen this before.
I reboot the Broker after the PK has been removed...to no avail. It still doesn't work.
Am I missing a command?
I'm going to run EXEC from SQLPlus manually to call the SPROC and see if I still encounter the issue.
Thanks for any input.
Eric |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Thu Jun 07, 2012 10:44 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
did you commit removing the PK?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| EricCox |
| Posted: Fri Jun 08, 2012 7:04 am Post subject: Exactly |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
That's what I need the DBA to do.
It is a problem with the DB. I thought Broker might be caching schema information. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Jun 08, 2012 7:28 am Post subject: Re: Exactly |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| EricCox wrote: |
| Broker ... caching schema information. |
A neat feature ! This would be really cool.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jun 08, 2012 7:32 am Post subject: Re: Exactly |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| EricCox wrote: |
| Broker ... caching schema information. |
A neat feature ! This would be really cool. |
This is a job for...... RFE Man!!!! 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| EricCox |
| Posted: Fri Jun 08, 2012 7:55 am Post subject: Who's that |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jun 08, 2012 8:29 am Post subject: Re: Who's that |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| EricCox wrote: |
| Who is RFE man? |
He's the new super hero that stalks IBM making sure popular enhancements make it onto the development radar.
More formally, an RFE is the new way of making your suggestions for product enhancements. Unlike the old methods, this is public, transperent and the more support your RFE gets from the community the more likely IBM is to think "wow, maybe we should build this".
Full details are here: https://www.ibm.com/developerworks/rfe/
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
