TaskQueryService.queryAggregatedTasks fails with an ORA-00904 error after Patch 23751846 is applied on 11.1.1.7
(Doc ID 2222954.1)
Last updated on JANUARY 08, 2024
Applies to:
Oracle Business Process Management Suite - Version 11.1.1.7.0 and laterInformation in this document applies to any platform.
Symptoms
After applying the patch 23751846, a simple API application that calls
TaskQueryService.queryAggregatedTasks fails with an invalid SQL syntax error:
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "WFNTL"."TITLE":
invalid identifier.
Error stack:
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "WFNTL"."TITLE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
...
at com.sun.proxy.$Proxy249.executeQuery(Unknown Source)
at oracle.bpel.services.workflow.repos.driver.WFTask.getWFTaskStats(WFTask.java:5883)
at oracle.bpel.services.workflow.repos.driver.PersistencyService.getWFTaskStats(PersistencyService.java:1714)
at oracle.bpel.services.workflow.query.impl.TaskQueryService.queryAggregatedTasks(TaskQueryService.java:1003)
...
at oracle.bpel.services.workflow.query.ejb.TaskQueryServiceBean.queryAggregatedTasks(TaskQueryServiceBean.java:270)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
...
at com.sun.proxy.$Proxy249.executeQuery(Unknown Source)
at oracle.bpel.services.workflow.repos.driver.WFTask.getWFTaskStats(WFTask.java:5883)
at oracle.bpel.services.workflow.repos.driver.PersistencyService.getWFTaskStats(PersistencyService.java:1714)
at oracle.bpel.services.workflow.query.impl.TaskQueryService.queryAggregatedTasks(TaskQueryService.java:1003)
...
at oracle.bpel.services.workflow.query.ejb.TaskQueryServiceBean.queryAggregatedTasks(TaskQueryServiceBean.java:270)
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 |
Cause |
Solution |
References |