Article - CS201831
Error "ORA-00918: column ambiguously defined" in Integrity Lifecycle Manager when using filter "where Text contains"
Modified: 06-Oct-2020
Applies To
- PTC RV&S (formerly Integrity Lifecycle Manager) 10.3 to 11.1
Description
- Error in Integrity server log with turned on SQL Logging:
- <timestamp> INFO [mksis.IntegrityServer] SQL(5): SID620: SELECT /* <un-named> */TypeID/*Type*/ TypeID/*Type*/, Issues.ID, ProjectID/*Project*/ ProjectID/*Project*/ FROM Issues
LEFT JOIN (
SELECT /*+USE_NL(Issues IIMap)*/Value C1, LeftID ID1 FROM IIMap JOIN Text0 ON Text0.IssueID=IIMap.RightID WHERE Active=1 AND IIMap.FieldID = -19/*References*/ AND CONTAINS(Value, '"Anforderung"') > 0 AND Text0.FieldID=36
) J1 ON Issues.ID = J1.ID1
LEFT JOIN (
SELECT /*+CARDINALITY (T 10) NO_SEMIJOIN*/ ID, Ordering, SharedItemID, SharedCategory walkSharedCategory FROM TABLE(im.walkDocOrdered(?, NULL, 1, 0, 0, 0)) T
) JO ON Issues.ID = JO.ID WHERE ((((J1.C1/*_mks_BFA(References, "Shared Text")*/ is not null) AND (TypeID IN (5,8,11,14,28)))) AND ((Issues.ID IN (JO.ID)))) AND ((((TypeID/*Type*/ IN (3,25,20,6,2,38,26,7,34,36,10,5,35,17,8,11,4,13,22,23,1,29,12,16,37,19,18,9,27,14,39,21,28,15,40,24))))) AND (EXISTS(SELECT 1 FROM ProjectVisibility WHERE UserID=? AND VisibleProject=ProjectID) OR ProjectID IS NULL) ORDER BY Issues.ID [51921,29]: 13ms
<timestamp> INFO [mksis.IntegrityServer] SQL(5): SID620: SQLException: ORA-00918: column ambiguously defined
: error code=918, state=42000
<timestamp> DEBUG [mksis.IntegrityServer] DEBUG(0): state: 42000, code: 918
2015-03-19 08:28:05,468 DEBUG [mksis.IntegrityServer] DEBUG java.sql.SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at mks.frame.sql.jdbc.common.CancellablePreparedStatement.executeQuery(CancellablePreparedStatement.java:78)
at mks.frame.sql.jdbc.oracle.PreparedStatement.executeQuery(PreparedStatement.java:64)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:224)
at mks.frame.sql.jdbc.common.DelegatedPreparedStatement.executeQuery(DelegatedPreparedStatement.java:83)
at mks.frame.sql.jdbc.debug.PreparedStatement.executeQuery(PreparedStatement.java:52)
at mks.ci.server.engine.Expression$SQLGenerator.executeQuery(Expression.java:4086)
at mks.ci.server.engine.EngineIssue.internalGetIssues(EngineIssue.java:10222)
at mks.ci.server.engine.EngineIssue.getIssues1(EngineIssue.java:250)
at mks.ci.server.engine.EngineIssue.getIssues(EngineIssue.java:193)
at mks.ci.server.engine.EngineSQL.getIssues(EngineSQL.java:15332)
at mks.ci.server.engine.EngineSQL.getIssues(EngineSQL.java:15320)
at mks.ci.server.AgentImpl.getIssues(AgentImpl.java:1661)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.sapia.ubik.rmi.server.invocation.InvokeCommand.execute(InvokeCommand.java:185)
at mks.ubik.transport.beep.BeepServer$2.call(BeepServer.java:359)
at mks.ubik.transport.beep.RmiInvocationAction.call(RmiInvocationAction.java:152)
at mks.ubik.transport.beep.BeepServer.executeCommand(BeepServer.java:375)
at mks.ubik.transport.beep.BeepServer$1.call(BeepServer.java:313)
at mks.ubik.transport.beep.BeepServer$1.call(BeepServer.java:310)
at mks.ubik.transport.beep.RmiInvocationAction.call(RmiInvocationAction.java:152)
at mks.rmi.RmiAuthenticationHandler$1.run(RmiAuthenticationHandler.java:90)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at mks.rmi.RmiAuthenticationHandler.doAs(RmiAuthenticationHandler.java:95)
at mks.ubik.transport.beep.BeepTransportProvider.doAs(BeepTransportProvider.java:1130)
at mks.ubik.transport.beep.BeepTransportProvider.doAs(BeepTransportProvider.java:1106)
at mks.ubik.transport.beep.BeepServer.remoteExecuteCommand(BeepServer.java:328)
at mks.ubik.transport.beep.BeepServer.handleCommandMessage(BeepServer.java:280)
at mks.ubik.transport.beep.BeepServer.receiveMSG(BeepServer.java:171)
at org.beepcore.beep.core.ChannelImpl.run(ChannelImpl.java:385)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
<timestamp> INFO [mksis.IntegrityServer] SQL(0): SID620: SQL Rollback Total Time: 24ms
<timestamp> DEBUG [mksis.IntegrityServer] DEBUG mks.ci.exception.CIException: java.sql.SQLException: MKS131372: An unhandled database exception has occurred. Please contact your administrator.
The error supplied by the database is:
ORA-00918: column ambiguously defined
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at mks.frame.sql.jdbc.common.CancellablePreparedStatement.executeQuery(CancellablePreparedStatement.java:78)
at mks.frame.sql.jdbc.oracle.PreparedStatement.executeQuery(PreparedStatement.java:64)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:224)
at mks.frame.sql.jdbc.common.DelegatedPreparedStatement.executeQuery(DelegatedPreparedStatement.java:83)
at mks.frame.sql.jdbc.debug.PreparedStatement.executeQuery(PreparedStatement.java:52)
at mks.ci.server.engine.Expression$SQLGenerator.executeQuery(Expression.java:4086)
at mks.ci.server.engine.EngineIssue.internalGetIssues(EngineIssue.java:10222)
at mks.ci.server.engine.EngineIssue.getIssues1(EngineIssue.java:250)
at mks.ci.server.engine.EngineIssue.getIssues(EngineIssue.java:193)
at mks.ci.server.engine.EngineSQL.getIssues(EngineSQL.java:15332)
at mks.ci.server.engine.EngineSQL.getIssues(EngineSQL.java:15320)
at mks.ci.server.AgentImpl.getIssues(AgentImpl.java:1661)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.sapia.ubik.rmi.server.invocation.InvokeCommand.execute(InvokeCommand.java:185)
at mks.ubik.transport.beep.BeepServer$2.call(BeepServer.java:359)
at mks.ubik.transport.beep.RmiInvocationAction.call(RmiInvocationAction.java:152)
at mks.ubik.transport.beep.BeepServer.executeCommand(BeepServer.java:375)
at mks.ubik.transport.beep.BeepServer$1.call(BeepServer.java:313)
at mks.ubik.transport.beep.BeepServer$1.call(BeepServer.java:310)
at mks.ubik.transport.beep.RmiInvocationAction.call(RmiInvocationAction.java:152)
at mks.rmi.RmiAuthenticationHandler$1.run(RmiAuthenticationHandler.java:90)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at mks.rmi.RmiAuthenticationHandler.doAs(RmiAuthenticationHandler.java:95)
at mks.ubik.transport.beep.BeepTransportProvider.doAs(BeepTransportProvider.java:1130)
at mks.ubik.transport.beep.BeepTransportProvider.doAs(BeepTransportProvider.java:1106)
at mks.ubik.transport.beep.BeepServer.remoteExecuteCommand(BeepServer.java:328)
at mks.ubik.transport.beep.BeepServer.handleCommandMessage(BeepServer.java:280)
at mks.ubik.transport.beep.BeepServer.receiveMSG(BeepServer.java:171)
at org.beepcore.beep.core.ChannelImpl.run(ChannelImpl.java:385)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
- <timestamp> INFO [mksis.IntegrityServer] SQL(5): SID620: SELECT /* <un-named> */TypeID/*Type*/ TypeID/*Type*/, Issues.ID, ProjectID/*Project*/ ProjectID/*Project*/ FROM Issues
- Error ORA-00918: column ambiguously defined when trying to run particular reports with "asOf" date
This is a printer-friendly version of Article 201831 and may be out of date. For the latest version click CS201831