When Clicking on Workflow Routing Tab in Home Page Gets Application Error or a Blank New Window With Close Button (Doc ID 2671202.1)

Last updated on JULY 09, 2024

Applies to:

Symptoms

Actual Behavior
When clicking on Workflow Routing Tab in Home Page, a blank new window with Close button is shown.

Error
Application Error
This feature did not perform as expected. Please contact your Agile Administrator.

stderr.log display following error messages :

java.sql.SQLSyntaxErrorException: ORA-00904: "C"."CHANGE_ID": invalid identifier

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)

...

Caused by: Error : 904, Position : 505, Sql = SELECT A.ID,A.CLASS,A.SUBCLASS, A.FLAGS, NULL, NULL, NULL, A.OUTBOUND_NUMBER , A.OUTBOUND_NUMBER, A.DESCRIPTION, A.STATUS, A.WORKFLOW_ID, A.SUBCLASS, TO_Char(A.ROUTED_DATE, 'YYYY-MM-DD HH24:MI:SS'),A.CREATE_USER, A.CREATE_USER , 0, 0 , A.OUTBOUND_NUMBER FROM OUTBOUND_P2P3 A WHERE ((NVL(A.DELETE_FLAG, 0) = 0) AND ( A.ROUTED_DATE > TO_DATE('02/16/2020 11:38:48','MM/dd/yyyy HH24:MI:ss') OR A.ROUTED_DATE IS NULL ) AND (A.ORIGINATOR IN (704) AND ( A.STATUS = C.STATE AND C.STATE_CODE = 0 AND A.ID = C.CHANGE_ID AND ( A.STATUSTYPE = 2) AND ( A.STATUSTYPE = 3)))) ORDER BY 19, OriginalSql = SELECT A.ID,A.CLASS,A.SUBCLASS, A.FLAGS, NULL, NULL, NULL, A.OUTBOUND_NUMBER , A.OUTBOUND_NUMBER, A.DESCRIPTION, A.STATUS, A.WORKFLOW_ID, A.SUBCLASS, TO_Char(A.ROUTED_DATE, 'YYYY-MM-DD HH24:MI:SS'),A.CREATE_USER, A.CREATE_USER , 0, 0 , A.OUTBOUND_NUMBER FROM OUTBOUND_P2P3 A WHERE ((NVL(A.DELETE_FLAG, 0) = 0) AND ( A.ROUTED_DATE > TO_DATE('02/16/2020 11:38:48','MM/dd/yyyy HH24:MI:ss') OR A.ROUTED_DATE IS NULL ) AND (A.ORIGINATOR IN (704) AND ( A.STATUS = C.STATE AND C.STATE_CODE = 0 AND A.ID = C.CHANGE_ID AND ( A.STATUSTYPE = 2) AND ( A.STATUSTYPE = 3)))) ORDER BY 19, Error Msg = ORA-00904: "C"."CHANGE_ID": invalid identifier

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 87 more

...

java.lang.IllegalStateException: Cannot forward a response that is already committed
at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:128)
at com.agile.ui.web.action.ActionServlet.forward(ActionServlet.java:1630)
at com.agile.ui.web.action.ActionServlet.forward(ActionServlet.java:1576)
at com.agile.ui.web.action.ActionServlet.handleException(ActionServlet.java:1106)
at com.agile.ui.pcm.PCMServlet.handleException(PCMServlet.java:1161)
at com.agile.ui.web.action.ActionServlet.handleRequest(ActionServlet.java:924)
at com.agile.ui.web.action.ActionServlet.doPost(ActionServlet.java:433)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
...

Steps
The issue can be reproduced at will with the following steps:
1. Login to Web Client
2. Click Workflow Routing tab

Changes

Cause

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