EnvironmentSolaris 8
TeamSite 5.5.2 SP3
OD/DD 6.0.2
Deploying XML formated data to Oracle 8i DB
ProblemThe data deployment of XML formated data to database is getting failed ( see below log file )
ENG: 2005-08-09 04:46:18 PDT GMT-07:00 Proceed to execute the database deployment
DAS: Deployment : ea_xml-to-db
DAS: Database Vendor set to oracle
DAS: SQL datatype for column CREATEDATE is DATE
DAS: SQL datatype for column EXPIRATIONDATE is DATE
DAS: SQL datatype for column MODIFIEDDATE is DATE
DAS: [Tue Aug 09 04:46:18 PDT 2005] Begin executing ea_xml-to-db
DAS: Setting up consumer TDbAgent
DAS: Validating cached connection...
DAS: Cached connection OK
DAS: Connected to [cds125721.cadence.com:1521:teamsite]
DAS: SELECT * FROM USER_TABLES WHERE TABLE_NAME='AENET_METADATA_DEV'
DAS: Table <AENET_METADATA_DEV> exists.
DAS: Running deployment [ea_xml-to-db]
DAS: Xml source[/tmp/mergedXMLAENET]
DAS: TUPLE={EXPIRATIONDATE=2006-08-09, FILESIZE=17.3 KB, TITLE=Custom IC Design, DESCRIPTION=testednew, FORMAT=html, LANGUAGE=
English, ACCESSRIGHTS=Internal, BUSINESSFUNCTION=Sales, REGION=North America, CREATEDATE=2004-11-08, PUBLISHDATE=2005-08-09, D
ATATYPE=Breadcrumb, ZONETAG=Custom IC Design, PATH=web/platforms/cic/index.html}
DAS: TTableSchemaHelper object for [AENET_METADATA_DEV] found in cache.
DAS: SELECT PATH, APPROVER,AUTHOR,CHAPTITLE,CREATETIME,TO_CHAR(CREATEDATE,'YYYY-MM-DD HH:MI
S') AS CREATEDATE,DATASUBTYPE,DAT
ATYPE,DESCRIPTION,TO_CHAR(EXPIRATIONDATE,'YYYY-MM-DD HH:MI
S') AS EXPIRATIONDATE,FILETYPE,FORMAT,KEYWORD,LANGUAGE,TO_CHAR(MOD
IFIEDDATE,'YYYY-MM-DD HH:MI
S') AS MODIFIEDDATE,MODIFIEDTIME,NEXTCHAP,NEXTFILE,ORGANIZATIONNAME,OSVERSION,PAGECOUNT,PLATFORM,
PREVCHAP,PREVFILE,PRODUCT,PRODUCTX,PRODUCTY,PRODUCTVERSION,RELEASE,RIGHTSMANAGEMENT,SECTIONTITLE,SOLUTIONID,SUBTITLE,TITLE FRO
M AENET_METADATA_DEV WHERE PATH=?
DAS: TTableSchemaHelper object for [AENET_METADATA_DEV] found in cache.
DAS: WHERE clause parameter 1: web/platforms/cic/index.html
DAS: Column: PATH, field: PATH, Index: 1,Converting 'web/platforms/cic/index.html' to VARCHAR
DAS: Error occured in TDbAgent:elect()
DAS:
DAS: *******************************************************
DAS: SQLException occured in TDbAgentelect()
DAS: Exception Message: ORA-00904: invalid column name
DAS: Vendor Error Code: 904
DAS: SQL state: 42000
DAS: *******************************************************
DAS:
DAS: *******STACK TRACE*************
java.sql.SQLException: ORA-00904: invalid column name
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.TDbAgent.Select(TDbAgent.java:2481)
at com.interwoven.dd100.dd.TDbAgent.NarrowInsertUpdate(TDbAgent.java:2118)
at com.interwoven.dd100.dd.TDbAgent.WriteTuple(TDbAgent.java:3642)
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.DoOneXmlSource(TAgentClient.java:362)
at com.interwoven.dd100.dd.TAgentClient.DoXmlSource(TAgentClient.java:291)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:265)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:194)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:545)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DAS: Error occured in NarrowInsertUpdate: Select() returned null ResultSet
DAS: -- Failed
DAS: ERROR:WriteTuple failure to consumer[0]
DAS: ERROR:deployment [ea_xml-to-db] FAILED
DAS: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DAS: Rollback database [cds125721.cadence.com:1521:teamsite]...
DAS: Deployment[ea_xml-to-db] Table[AENET_METADATA_DEV]
DAS: -----------------------------------
DAS: Tuples inserted : 0
DAS: Tuples updated : 0
DAS: Tuples deleted : 0
DAS: Tuples failed : 0
DAS: Tuples rolled back : 0
DAS: Tuples skipped : 0
DAS: -----------------------------------
DAS: Started : Tue Aug 09 04:46:18 PDT 2005
DAS: Finished: Tue Aug 09 04:46:18 PDT 2005
DAS:
### IWDataDeploy FAILED ###
Can anybody let me know whats happening here and possible solution.
Thanks
