APAR status
Closed as unreproducible.
Error description
While processing events in the workflow the following error is observed in the workflow service db.log file: 2013-04-28 22:47:18,152 [WorkflowEventProcessorEventId44936880] ERROR com.ibm.ccd.common.db.Query - CWPCM0040E:The query failed : [ Dynamic Query [select count(distinct itm2.itm_id) from ita ita2, itm itm2, itm itm3, itx itx2 where itm2.itm_container_id = 3202 and itm2.itm_version_id <= 999999999 and itm2.itm_next_version_id >= 999999999 and itm3.itm_primary_key ='999903847' and ita2.ita_value_string = '0003400022510' and XMLEXISTS ('$xml/entry/s2098[(n5059 castable as xs:double and n5059=$itm_id)]' passing itx1.itx_entry_content as "xml", itm3.itm_id as "itm_id") and itm3.itm_container_id = 2672 and itm2.itm_id = itx2.itx_entry_id and itx2.itx_version_id <= 999999999 and itx2.itx_next_version_id >= 999999999 and itm3.itm_version_id <= 999999999 and itm3.itm_next_version_id >= 999999999 and ita2.ita_node_id = 4300 and ita2.ita_item_id = itm2.itm_id and ita2.ita_version_id <= 999999999 and ita2.ita_next_version_id >= 999999999] ], Exception:ORA-00904: "ITX1"."ITX_ENTRY_CONTENT": invalid identifier java.sql.SQLSyntaxErrorException: ORA-00904: "ITX1"."ITX_ENTRY_CONTENT": invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement. java:873) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleSt atement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt atement.java:1289) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement. java:1491) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleSta tementWrapper.java:406) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(Delegat ingStatement.java:188) at com.ibm.ccd.common.db.Query.execute(Query.java:1017) at com.ibm.ccd.common.db.Query.execute(Query.java:858) at com.ibm.ccd.common.db.Query.execute(Query.java:824) at com.ibm.ccd.common.db.Query.execute(Query.java:806) at com.ibm.ccd.search.ast.SearchDataSource.getCount(SearchDataSourc e.java:85) at com.ibm.ccd.search.query.SearchResultSet.size(SearchResultSet.ja va:175) at com.ibm.ccd.common.interpreter.operation.generated.GenSizeOperat ion.execute(GenSizeOperation.java:65)
Local fix
If this exception is thrown from a implementation script and if size() method is used for query result set, remove the method and alter the script logic, ensure to meet the business logic/requirement when script is altered.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Master Data Management Collaboration Server * * implementations are affected by this issue * **************************************************************** * PROBLEM DESCRIPTION: * * While processing events in the workflow the following error * * is observed in the workflow service db.log file: 2013-04-28 * * 22:47:18,152 [WorkflowEventProcessorEventId44936880] ERROR * * com.ibm.ccd.common.db.Query - CWPCM0040E:The query failed : * * [ Dynamic Query [select count(distinct itm2.itm_id) from ita * * ita2, itm itm2, itm itm3, itx itx2 where * * itm2.itm_container_id = 3202 and itm2.itm_version_id = * * 999999999 and itm3.itm_primary_key ='999903847' and * * ita2.ita_value_string = '0003400022510' and XMLEXISTS * * ('$xml/entry/s2098[(n5059 castable as xs:double and * * n5059=$itm_id)]' passing itx1.itx_entry_content as "xml", * * itm3.itm_id as "itm_id") and itm3.itm_container_id = 2672 * * and itm2.itm_id = itx2.itx_entry_id and itx2.itx_version_id * * = 999999999 and itm3.itm_version_id = 999999999 and * * ita2.ita_node_id = 4300 and ita2.ita_item_id = itm2.itm_id * * and ita2.ita_version_id = 999999999] ], Exception:ORA-00904: * * "ITX1"."ITX_ENTRY_CONTENT": invalid identifier * * java.sql.SQLSyntaxErrorException: ORA-00904: * * "ITX1"."ITX_ENTRY_CONTENT": invalid identifier at * * oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445 * * ) at * * oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396 * * ) at * * oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) * * at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) * * at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at * * oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at * * oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:19 * * 3) at * * oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatem * * ent. java:873) at * * oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Orac * * leSt atement.java:1167) at * * oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac * * leSt atement.java:1289) at * * oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatem * * ent. java:1491) at * * oracle.jdbc.driver.OracleStatementWrapper.executeQuery(Oracl * * eSta tementWrapper.java:406) at * * org.apache.commons.dbcp.DelegatingStatement.executeQuery(Del * * egat ingStatement.java:188) at * * com.ibm.ccd.common.db.Query.execute(Query.java:1017) at * * com.ibm.ccd.common.db.Query.execute(Query.java:858) at * * com.ibm.ccd.common.db.Query.execute(Query.java:824) at * * com.ibm.ccd.common.db.Query.execute(Query.java:806) at * * com.ibm.ccd.search.ast.SearchDataSource.getCount(SearchDataS * * ourc e.java:85) at * * com.ibm.ccd.search.query.SearchResultSet.size(SearchResultSe * * t.ja va:175) at * * com.ibm.ccd.common.interpreter.operation.generated.GenSizeOp * * erat ion.execute(GenSizeOperation.java:65) * **************************************************************** * RECOMMENDATION: * * IBM recommends that customers facing the issue reported by * * this APAR apply Master Data Management Collaboration Server * * version 10.1.0-FP008 to gain resolution to this problem * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
JR46521
Reported component name
MDM SERVER FOR
Reported component ID
5724V5100
Reported release
A00
Status
CLOSED UR3
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-04-30
Closed date
2014-02-18
Last modified date
2014-02-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
MDM SERVER FOR
Fixed component ID
5724V5100
Applicable component levels
RA10 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS2U2U","label":"InfoSphere Master Data Management Collaboration Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
18 February 2014