Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
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.
Find more posts tagged with
Comments
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 ::
DD
QLException occured in TDbSchemaGroupCfg
DD:Exception Message: ORA-00960: ambiguous column naming in select list
DD:Vendor Error Code: 960
DD
QL 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:ERROR
oUpdate() failed for group [MHR_CONT_CONTENT].
DD: -- Failed
DD:ERROR:WriteTuple failure to consumer[0]
DD:Rollback batch...
marcussteiner
please attach the config file
