Unable to create TTableSchemaHelper object

mmb

Hi

OD 7.3.1 Linux

Attempting to test a deployment to LSDS using Publish Livesite Content workflow.

The OpenDeploy of files works fine.

The DataDeploy component is failing after successfully connecting to schema and creating/updating other tables.

This is the error:

DBD: TDbSchemaGroupCfg:RowsExistForTupleELECT COUNT(*) FROM iw_asset WHERE ast_id IN ( ? )
DBD: TTableSchemaHelper not found in cache for [iw_asset]. Creating new.
DBD: ERROR:Unable to create TTableSchemaHelper object for [iw_asset].
DBD: ERROR:Exception occured: null
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForTuple(TDbSchemaGroupCfg.java:2212)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForTuple(TDbSchemaCfg.java:1065)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDbSchemaCfg.java:1044)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:421)
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:1083)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:637)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:594)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:539)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:290)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:181)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:601)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)

The whole thing then rolls back and reports Completed with Error via the workflow.

Anyone any idea as to why/what the TTableSchemaHelper object is meant to do?

Any clues on how to debug this further?

thanks

jagadesh

Hi OD 7.3.1 Linux Attempting to test a deployment to LSDS using Publish Livesite Content workflow. The OpenDeploy of files works fine. The DataDeploy component is failing after successfully connecting to schema and creating/updating other tables. This is the error: DBD: TDbSchemaGroupCfg:RowsExistForTupleELECT COUNT(*) FROM iw_asset WHERE ast_id IN ( ? ) DBD: TTableSchemaHelper not found in cache for [iw_asset]. Creating new. DBD: ERROR:Unable to create TTableSchemaHelper object for [iw_asset]. DBD: ERROR:Exception occured: null DBD: ERROR: java.lang.NullPointerException at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForTuple(TDbSchemaGroupCfg.java:2212) at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForTuple(TDbSchemaCfg.java:1065) at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDbSchemaCfg.java:1044) at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:421) 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:1083) at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:637) at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:594) at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:539) at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:290) at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:181) at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:601) at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203) The whole thing then rolls back and reports Completed with Error via the workflow. Anyone any idea as to why/what the TTableSchemaHelper object is meant to do? Any clues on how to debug this further? thanks

It seems access issue or space issue.
Can you please clarify the below questions
1. Environment details?
2. Have you tried using root/administrator?
3. Is relevant space available in your Teamsite environment?

To debug further on this issue, you can use tuple pre processor class(either exisintg one with configuration change in datadeploy config file or new class with config change)