Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unusual Primary Key Constraint violation

476328Jun 20 2007 — edited Sep 5 2011
When using Apex collections from time to time this unique constraint error happens.

ORA-00001: unique constraint (FLOWS_030000.WWV_FLOW_COLLECTIONS_UK) violated

Now, I can't figure out why this constraint would be happening as we check for the existence of a collection before trying to create one, and the constraint relies on a number of values which we can't modify.

All of our collection operations are done using the following APEX_COLLECTION calls
COLLECTION_MEMBER_COUNT
COLLECTION_EXISTS
CREATE_OR_TRUNCATE_COLLECTION
ADD_MEMBER
DELETE_MEMBERS

As I don't modify any data inside of the collections using any methods other than these above API calls I'm a bit confused.

It's almost impossible for me to reproduce the error as it happens very rarely, in addition, most of the time performing the same action again after the constraint error has happened will succeed.

Any ideas what I might be doing that could cause this?

Thanks in advance,
Joe

Comments

495335
I've found some information that looks helpful, in the form of a blog entry found at:

http://forms.pjc.bean.over-blog.com/article-3234108.html

The entry mentions that the bean cannot be registered immediately within the WHEN_NEW_FORM_INSTANCE trigger, and shows how to delay this slightly using a timer.

Special thanks to Francois Degrelle for the blog entry linked above, and to Frank Nimphius, for the blog entry that pointed me there! :)

Eric Adamson
Lansing, Michigan
495335
I've discovered what my problem was, and it was silly. I had updated the archive_jini entry that appears in my webutil config, but in this case, I was not specifying that config when calling frmservlet, so the JAR was not being downloaded. (DOH!)

Eric
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 3 2011
Added on Jun 20 2007
#apex-discussions
17 comments
5,946 views