Patch for WLS 10.0 ORA-00001 Error Messages in Logs

While the message does not impact functionality, if you have to read the logs it becomes tedious to scroll past the following over and over:

<BEA-403302> <An unexpected SQL exception occured java.sql.SQLException: ORA-00001:
unique constraint (PORTAL.PK_LEASE) violated.
java.sql.SQLException: ORA-00001: unique constraint (PORTAL.PK_LEASE) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

Not to mention how the fun of having every person who hasn’t looked at your application before reporting it as a problem or insisting it is the root of a bug you are chasing (it isn’t).

If you have a support account, you can surpress this with the following WLP 10.2 patch:

VZGR | 9AS6D7D9

Tags: WLS

This entry was posted on Monday, May 4th, 2009 at 11:41 am and is filed under WebLogic Portal. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Patch for WLS 10.0 ORA-00001 Error Messages in Logs”

Grosa says:

July 22, 2010 at 6:14 pm

Hi…your blog is awesome.

I’m searching for a fix to the pk_lease stuff, but i canot find VZGR | 9AS6D7D9 patch. Do you have the link for download.

Thanks.
Scott Nelson says:

July 23, 2010 at 11:30 am

You have to run SmartUpdate, select Private, then enter those characters as Patch and Password respectively.