ORA-00960 ambiguous column naming in select list

marcussteiner

when getting this error when doing updates with datadeploy check your dbschema and make sure that the case is the same for your defined keys like <primary-key> and the coloumn name in your <attrmap> definition.

sandy123

Do you mean that column names in DB tables and deployment descriptors should be same.

I am also facing the same problem . Could you please explain in more detail.
The exception which i am getting is ::

DDQLException occured in TDbSchemaGroupCfg
DD:Exception Message: ORA-00960: ambiguous column naming in select list

DD:Vendor Error Code: 960
DDQL state: 42000
DD:*******************************************************
DD:
DD:*******STACK TRACE*************
java.sql.SQLException: ORA-00960: ambiguous column naming in select list

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.SelectCurrentRowsUsingPath(TDbSchemaUpdateHelper.java:418)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.SelectCurrentRows(TDbSchemaUpdateHelper.java:228)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.GetOperationRequired(TDbSchemaUpdateHelper.java:154)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:818)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoUpdate(TDbSchemaGroupCfg.java:852)
at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:448)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:454)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:333)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:962)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:464)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:512)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:534)
DD:ERRORoUpdate() failed for group [MHR_CONT_CONTENT].
DD: -- Failed
DD:ERROR:WriteTuple failure to consumer[0]
DD:Rollback batch...