Cannot Insert On Database After Installing Patch OHMPI 2.0.11
Last updated on NOVEMBER 02, 2017
Applies to:Oracle Healthcare Master Person Index - Version 2.0.9 and later
Information in this document applies to any platform.
After applying the OHMPI 2.0.11 patch, can no longer insert data on OHMPI DB using web services and MIDM. The problem is associated with the primary key that starts over 0, ignoring the records already saved.
The log displays the following error:
, stack trace=
It reproduces with any operation that triggers a insert operation. Example: Audit operation when open details from "record details" search in MIDM. For example:
1) The MIDM can not perform any operation which triggers auditing.
2) The web service can not insert data. Only MIDM operations can generate audit logs, the web service does not create audit logs. The unique constraint violation on PK_SBYN_AUDIT could be only resulted from MIDM operations.
This issue started after applying new patch 2.0.11.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms