Env: TS 6.7.1 SP1 Win 2K3 EE
OD/DD 6.1.1
DB: Oracle 9i (AIX)
I'm starting to think I need glasses! I am getting an "invalid identifier" error when doing deployments.
DBD: SELECT
ELECT TITLE,PAGE_ID,KO_COUNCL_ID,KO_LANG_ID,ABSTRACT,URL,FILE_NAME,FILE_SIZE,FILE_TYPE,TO_CHAR(ACTIVATION_DATE,'YYYY-MM-DD') AS ACTIVATION_DATE,CONTENT_CREATOR,TO_CHAR(ARCHIVE_DATE,'YYYY-MM-DD') AS ARCHIVE_DATE,EXECUTIVE_SUMMARY_URL,STUDY_THUMBNAIL_URL,CONTENT_SPONSOR,URL_DISPLAY,CONTENT_META_DATA_ID FROM KO_CONTENT_META_DATA WHERE CONTENT_META_DATA_ID = ? ORDER BY KO_CONTENT_META_DATA.CONTENT_META_DATA_ID
DBD: Recurse select: pIndex = 0, value = 4
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupInfoNode
DBD: Exception Message: ORA-00904: "KO_LANG_ID": invalid identifier
DBD: Vendor Error Code: 904
DBD: SQL state: 42000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: ORA-00904: "KO_LANG_ID": invalid identifier
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
at com.interwoven.dd100.dd.TDbSchemaGroupInfoNode.BuildTuples(TDbSchemaGroupInfoNode.java:161)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.PrepareForDelete(TDbSchemaGroupInfo.java:83)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.PrepareForRecurseSelect(TDbSchemaGroupInfo.java:70)
at com.interwoven.dd100.dd.TDbSchemaCfg.BuildGroupInfoForRecurseSelect(TDbSchemaCfg.java:723)
at com.interwoven.dd100.dd.TDbSchemaCfg.BuildGroupInfoWithRootPrimaryKeys(TDbSchemaCfg.java:1917)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdate(TDbSchemaCfg.java:917)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:441)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TTuplePreProcessor.WriteTuple(TTuplePreProcessor.java:40)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1008)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:609)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:566)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:511)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:289)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DBD: ERROR:Exception occured: null
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaCfg.BuildGroupInfoWithRootPrimaryKeys(TDbSchemaCfg.java:1919)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdate(TDbSchemaCfg.java:917)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:441)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TTuplePreProcessor.WriteTuple(TTuplePreProcessor.java:40)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1008)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:609)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:566)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:511)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:289)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
I know that this error suggests that I'm using an invalid column name, but this exact same configuration file (from the TS 5.5.2/OD 5.6 AIX machine I'm upgrading from to the same DB) works without a flaw. I've done a dump of that table:
desc KO_CONTENT_META_DATA;
Name Null Type
------------------------------ -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CONTENT_META_DATA_ID NOT NULL NUMBER(5)
TITLE VARCHAR2 (255)
ABSTRACT VARCHAR2(4000)
URL NOT NULL VARCHAR2(255)
FILE_NAME NOT NULL VARCHAR2(255)
FILE_SIZE VARCHAR2(15)
FILE_TYPE VARCHAR2(15)
CONTENT_TYPE_ID NUMBER(2)
CONTENT_OWNER VARCHAR2(50)
CONTENT_OWNER_EMAIL VARCHAR2(150)
ACTIVATION_DATE DATE
ARCHIVE_DATE DATE
ARCHIVE_COMMENTS VARCHAR2(255)
ARCHIVE_USER VARCHAR2(10)
BUSINESS_UNIT VARCHAR2(50)
COMMUNITY VARCHAR2(60)
COMPANY VARCHAR2(60)
CONTENT_CREATOR VARCHAR2(50)
CONTENT_SPONSOR VARCHAR2(50)
COUNTRY VARCHAR2(50)
CREATION_DATE DATE
CUSTOMER VARCHAR2(50)
CUSTOMER_TYPE VARCHAR2(25)
EXPIRATION_DATE DATE
KEYWORDS VARCHAR2(100)
LANGUAGE VARCHAR2(10)
NOTES VARCHAR2(100)
PRODUCT_LINE VARCHAR2(75)
REVISION_DATE DATE
SEARCH_SUMMARY VARCHAR2(255)
SECURITY_LEVEL VARCHAR2(10)
SUBJECT VARCHAR2(255)
TARGET_AUDIENCE VARCHAR2(25)
SEQUENCE NUMBER(5)
EXECUTIVE_SUMMARY_URL VARCHAR2(255)
STUDY_THUMBNAIL_URL VARCHAR2(255)
URL_DISPLAY CHAR(1)
KO_LANG_ID NUMBER(5)
KO_COUNCL_ID NUMBER(5)
KO_TOOL_ID VARCHAR2(20)
PAGE_ID VARCHAR2(50)
to ensure that my DBA didn't change the table without my knowing. Here is the schema section of my config file:
[html]
data-type="VARCHAR2(255)"
value-from-field="TeamSite/Metadata/title"
allows-null="yes"
is-url="no"/>
data-type="VARCHAR2(255)"
value-from-field="TeamSite/Metadata/page_id"
allows-null="yes"
is-url="no"/>
data-type="NUMBER"
value-from-field="TeamSite/Metadata/councl_id"
allows-null="yes"
is-url="no"/>
data-type="NUMBER"
value-from-field="TeamSite/Metadata/ko_lang_id"
allows-null="yes"
is-url="no"/>
data-type="VARCHAR2(20)"
value-from-field="TeamSite/Metadata/study_tool"
allows-null="yes"
is-url="no"/>
data-type="VARCHAR2(255)"
value-from-field="TeamSite/Metadata/abstract"
allows-null="yes"
is-url="no"/>
data-type="VARCHAR2(255)"
value-from-callout="iwov:dd:java:com.cokenet.datadeploy.GetPath"
allows-null="no"
is-url="no"/>
data-type="VARCHAR2(255)"
value-from-callout="iwov:dd:java:com.cokenet.datadeploy.GetFilename"
allows-null="no"
is-url="no"/>
data-type="VARCHAR2(15)"
value-from-field="FileSize"
allows-null="yes"
is-url="no"/>
data-type="VARCHAR2(15)"
value-from-field="TeamSite/Metadata/file_type"
allows-null="yes"
is-url="no"/>
data-type="DATE"
value-from-field="TeamSite/Metadata/activation_date"
allows-null="yes"
is-url="no"
data-format="yyyy-MM-dd" />
data-type="VARCHAR2(50)"
value-from-field="TeamSite/Metadata/content_creator"
allows-null="yes"
is-url="no"/>
data-type="DATE"
value-from-field="TeamSite/Metadata/archive_date"
allows-null="yes"
is-url="no"
data-format="yyyy-MM-dd" />
data-type="NUMBER"
value-from-callout="iwov:dd:java
W_IW.SWGetContentID"
allows-null="no"
is-url="no"/>
data-type="VARCHAR2(15)"
value-from-field="TeamSite/Metadata/executive_summary_url"
allows-null="yes"
is-url="no"/>
data-type="VARCHAR2(15)"
value-from-field="TeamSite/Metadata/study_thumbnail_url"
allows-null="yes"
is-url="no"/>
data-type="VARCHAR2(50)"
value-from-field="TeamSite/Metadata/council_name"
allows-null="yes"
is-url="no"/>
data-type="VARCHAR2(1)"
value-from-field="TeamSite/Metadata/view_study_link"
allows-null="yes"
is-url="no"/>
[/html]
I'm about to pull the little hair I have left out!!! Anyone have any suggestions or see anything I'm not seeing?? I've also attached the full dd config file.
TIA
