Updated DD script - fails

Hi all,

OD/DD Version: 6.1.1.0.0

We have a datadeployment script which deployes an entire dcr into a MSSQL database.
Now we have updated the dct and the dd script to also deploy a new dct item. The column to which the new dct item needs to be deployed to has always existed in the table.
If we remove the new in the the deployment again runs fine. But when we try to run a deployment with the new it fails.

The first error in the log file shows:

ERROR Smiley Frustrated

QLException while selecting rows from table: [TDS Driver]Column 'USER' not found.
We are suspecting this error to be caused by the fact that TTableSchemaHelper objects for the table is loaded from the cache.

We tried to reboot the server to flush the cache but apparently there should be a different approach to flushing the cache, which we have missed.

Our next step was to delete the IWDELTRACKER and IWOW_IDMAPS tables from the database. Now we have ended up with the following error:
DBD: ERROR:Exception occured: null
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.BuildUpdateWhereClauseEx(TDbSchemaUpdateHelper.java:1075)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.UpdateOneRow(TDbSchemaUpdateHelper.java:824)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.DoUpdate(TDbSchemaUpdateHelper.java:728)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:832)
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:441)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
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:1002)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:502)
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:547)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

We thought these tables should get created automatically but that is not the case I presume. Can anyone pinpoint in the direction of having these tables recreated and also to flush the cache.

Regards
Victor

Find more posts tagged with

Comments

mridul

Please try setting the attribute schema-helper-cleanup-interval for the element. Please refer to /dtd/conf/ddcfg.dtd for more details.

Test005-ListeGroupes-3.pdf

Victor2

Hi mridul,

Thanks for your suggestion. I could not from the dtd figure out what values to pass for the attribute :-).

I solved the problem though. After updating the DD script, as i mentioned the deployment startet failing, and there after I deleted the IW tables.
The tables where not being created because the deployment was failing! The reason the deployment was failing was that the new column which data was being deployed to was named user. Unfortunetely user is a reserved word in T-SQL. Inorder to make a select of such a column one either has to use [] or "" around user (eg. select [user] from tblUser). This I could not get DataDeploy to do, tried [] and "".

<column name="[user] and also tried "user"" data-type="VARCHAR(10)" value-from-element="news/0/username/0" allows-null="yes" is-url="no"/>

Then the log file was reporting Error selecting "User" etc.

So the solution is to rename the column :-).

crosstab_Sample1.rptdesign