NullPointerException using DataDeploy

Bill Klish

TeamSite 6.5 SP1
Solaris 2.9
OpenDeploy 6.0.2

Attempting to deploy 2 level replicants into a table and am getting a strange error in the log. It is strange since the data is being written correctly into the database, but then this error is being thrown. What would cause this?

DD : Version mysql-connector-java-3.0.16-ga ( $Date: 2004/09/30 07:35:03 $, $Revision: 1.27.2.44 $ )
DD : Table [IWTEMP_b1979335] does not exist. Creating..
DD : CREATE TABLE IWTEMP_b1979335(ctyhocn VARCHAR(7) NOT NULL ,crsrmtype VARCHAR(6) NOT NULL ,sequence INT(11) NOT NULL ,amenity VARCHAR(30
) NOT NULL )
DD : Column CTYHOCN not found in array
DD : WARNING:Value for [CTYHOCN] exceeds column width [ 7 > -1]
DD : Column CRSRMTYPE not found in array
DD : WARNING:Value for [CRSRMTYPE] exceeds column width [ 6 > -1]
DD : Column SEQUENCE not found in array
DD : WARNING:Value for [SEQUENCE] exceeds column width [ 1 > -1]
DD : Column AMENITY not found in array
DD : WARNING:Value for [AMENITY] exceeds column width [ 6 > -1]
DD : Column CTYHOCN not found in array
DD : WARNING:Value for [CTYHOCN] exceeds column width [ 7 > -1]
DD : Column CRSRMTYPE not found in array
DD : WARNING:Value for [CRSRMTYPE] exceeds column width [ 6 > -1]
DD : Column SEQUENCE not found in array
DD : WARNING:Value for [SEQUENCE] exceeds column width [ 1 > -1]
DD : Column AMENITY not found in array
DD : WARNING:Value for [AMENITY] exceeds column width [ 9 > -1]
DD : Inserted 2 rows into IWTEMP_b1979335
DD : TTableSchemaHelper not found in cache for [IWTEMP_B1979335]. Creating new.
DD : ERROR:Unable to create TTableSchemaHelper object for [IWTEMP_B1979335].
DD : ERROR:Exception occured: null
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.BuildColumnListFromVector(TDbSchemaUtils.java:389)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmt(TDbSchemaGroupCfg.java:2302)
at com.interwoven.dd100.dd.TDbSchemaRowSort.BuildSortedRows(TDbSchemaRowSort.java:300)
at com.interwoven.dd100.dd.TDbSchemaRowSort.PerformSort(TDbSchemaRowSort.java:87)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.PerformSort(TDbSchemaUpdateHelper.java:137)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.GetOperationRequired(TDbSchemaUpdateHelper.java:157)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:818)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdateWithGroupTree(TDbSchemaCfg.java:953)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdate(TDbSchemaCfg.java:933)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:439)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:334)
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:974)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:581)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:538)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:483)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:261)
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.IWDataDeploy.run(IWDataDeploy.java:576)
DD : ERROR:WriteTuple failure to consumer[0]
DD : ERROR:Unable to process TeamSite source templatedata/EnhancedProperty/GuestRooms/data/LONCHCI, obtained from filelist=/opt/iw-home/OpenDe
ployNG/hilton/temp/108670_dd_files.txt

Bill Klish

I found the answer to this problem.

The database table we were deploying into had a foreign key index set on another table that was getting loaded later in the ddconfig. The error message being shown here doesn't tell me that. Anyway we can have a better error message for this?