Error 500 On Realtimescreening (Doc ID 2991513.1)

Last updated on DECEMBER 12, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.