Is it possible to specify the schema name in the datadeploy config. file? Below is a snippet from the config file which results in an exception during deployment:
<dbschema>
<group name="metadata_root" table="DMIS.TEST_METADATA" root-group="yes">
<attrmap>
<column name="MIS_MET_DOK_PATH" data-type="CHAR(254)" value-from-field="path" allows-null="no"/>
<column name="IW_STATE" data-type="CHAR(20)" value-from-field="state" allows-null="no"/>
<column name="MIS_MET_PORTLETAD" data-type="CHAR(40)" value-from-field="TeamSite/Metadata/System/PortletName" allows-null="no" is-url="no"/>
<column name="MIS_MET_DOK_DIR" data-type="CHAR(254)" value-from-field="TeamSite/Metadata/System/DocumentPath" allows-null="no" is-url="no"/>
<column name="MIS_MET_HAZIRLAYAN" data-type="INTEGER" value-from-field="TeamSite/Metadata/System/Author" allows-null="no" is-url="no"/>
<column name="MIS_MET_KUL_GRUP" data-type="CHAR(10)" value-from-field="TeamSite/Metadata/System/UserGroup" allows-null="no" is-url="no"/>
<column name="MIS_MET_EXP_TARIH" data-type="CHAR(10)" value-from-field="TeamSite/Metadata/Yayýndan Kaldýrýlma Tarihi" allows-null="no" is-url="no"/>
<column name="MIS_MET_YAYIN_TS" data-type="TIMESTAMP" value-from-field="TeamSite/Metadata/System/SubmitTimeStamp" allows-null="no" is-url="no"/>
<column name="MIS_MET_ANAHTR_KEL" data-type="VARCHAR(150)" value-from-field="TeamSite/Metadata/Anahtar Kelimeler" allows-null="no" is-url="no"/>
<column name="MIS_MET_DOK_BASLIK" data-type="VARCHAR(100)" value-from-field="TeamSite/Metadata/Baþlýk" allows-null="no" is-url="no"/>
<column name="MIS_MET_DOK_OZET" data-type="VARCHAR(255)" value-from-field="TeamSite/Metadata/Özet" allows-null="yes" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="MIS_MET_DOK_PATH"/>
</primary-key>
</keys>
</group>
</dbschema>
The specific error message is:
RowsExistForPath
ELECT COUNT(*) FROM DMIS.TEST_METADATA WHERE MIS_MET_DOK_PATH = ?
TTableSchemaHelper not found in cache for [DMIS.TEST_METADATA]. Creating new.
SELECT NAME, COLTYPE, LENGTH, NULLS FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = ?
ERROR:Unable to create TTableSchemaHelper object for [DMIS.TEST_METADATA].
ERROR:Exception occured: null
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGr
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:11
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1061)
If I specify the table name simply as TEST_METADATA and not DMIS.TEST_METADATA, there is no problem...
Thanks...
