Error 500 On Realtimescreening
(Doc ID 2991513.1)
Last updated on DECEMBER 12, 2023
Applies to:
Oracle Financial Services Customer Screening - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
Steps to Reproduce the issue:
Post a request from postman to Real time screening
Actual Behavior:
Returning result as 500 internal server error
Expected Behavior:
Request should return with case details and matches without any error
Error Encountered in UmmService log:
[05-12-23 13:10:23,553 GMT PM] [DEBUG] [WEB] [UMM] [NA] [DBUTIL] ThreadId = 38, LogMessage = Query Execution started
[05-12-23 13:10:23,558 GMT PM] [ERROR] [WEB] [UMM] [NA] [LOGGER] ORA-00001: unique constraint (xxxx.N_REQUESTID_IDX) violated
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (xxxx.N_REQUESTID_IDX) violated
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
Error Encountered in managedserver.out:
Inside isPreflight..
Inside isPreflight..
Basic token authentication...
Basic token authentication...
Trying to Authenticate user for rest service.
Trying to Authenticate user for rest service.
Exception occured : java.util.concurrent.ExecutionException: java.lang.RuntimeException: Failed : HTTP error code : 500
<Dec 5, 2023 9:10:23,669 PM SGT> <Warning> <org.glassfish.jersey.server.ServerRuntime$Responder> <BEA-000000> <Attempt to release request processing resources has failed for a request.
java.lang.NullPointerException
at jsp_servlet.__error_page._jspService(__error_page.java:191)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:35)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
Truncated.
>
Changes
index N_REQUESTID_IDX on FCC_RTSCR_REQUEST_LOOKUP table was created as part of workaround for performance issue in 806
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |