TTableSchemaHelper not found in cache

Hi All,

We are getting below datadeploy error.
=====================================================
DBD: ERROR Smiley Very Happy

epth of mapped value-from-field should be one level greater than the list-field its being mapped from.
DBD: TUPLE={TeamSite/Metadata/document_live_date=29-05-2008 00:00, IWOV_PROC_FLAG=true, state=Original, TeamSite/Metadata/document_retire_date=29-05-2010 23:
59, TeamSite/Metadata/modified_date=13-06-2008 13:31, TeamSite/Templating/PrimaryPT=default.tpl, TeamSite/Templating/PrimaryDocumentType=content/beta_generic
, TeamSite/Metadata/author=mpanda, TeamSite/Templating/Encoding=, TeamSite/Metadata/creation_date=09-06-2008 13:56
, TeamSite/Templating/PrimaryDCR=advancednoresults, TeamSite/Metadata/id=448867533, TeamSite/Metadata/document_size=2224, TeamSite/Metadata/content_type=beta
_generic, path=xhtml/advancednoresults.html}
DBD: TTableSchemaHelper not found in cache for [bt_document]. Creating new.
DBD: ERROR:Unable to create TTableSchemaHelper object for [bt_document].
DBD: ERROR:Exception occured: null
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.ComputeColumnDataType(TDbSchemaUtils.java:978)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForPath(TDbSchemaGroupCfg.java:2028)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForPath(TDbSchemaCfg.java:1087)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDbSchemaCfg.java:1023)
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.TTupleSubstitutor.WriteTuple(TTupleSubstitutor.java:113)
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:1018)
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.IWDataDeploy.run(IWDataDeploy.java:608)
at java.lang.Thread.run(Thread.java:534)

DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source content/static/wa/retailsearch/xhtml/advancednoresults.html, obtained from filelist=/logs/btcom/tmp//mdcontentfi
le_Edition.23758
=======================================================

Environment details are given below

OD 6.2 Solaris
Target database: Oracle 9i
========================

We have tried to connect to database using DBI script and connectivity is fine. We are able to insert records as well in the tables without any issues while running SQL scripts.

Key thing I would like to mention,

Table we are trying to deploy is a private synonym which gives me a strong doubt about its failure but in this case DD should throw an oracle exception which is not available.

Any idea, why it is happening?

Find more posts tagged with

Comments

jkm

Any thoughts on this folks??

jkm

We are just stuck with this issue at the moment. Appreciate if people pour more ideas to debug this further..

Adam Stoller

We are just stuck with this issue at the moment. Appreciate if people pour more ideas to debug this further..

Try posting the following information:

be able to help you debug the problem.

jkm

Hi Adam,

Please find the requested information below

The actual version of OD/DD (including service pack and/or patch information)

rds09470cms21: /iw-home/OpenDeployNG/bin/iwodcmd -v
Version 6.2.0.0.0 Build 68916 Interwoven 20071109

The actual DD dbschema configuration or entire DD config file (feel free to ****-out username/password information for the database)

DD Config file is attached

The output of iwextattr -l for the file being processed (xhtml/advancednoresults.html ?)

IWEXTATTR for a sample file

TeamSite/Metadata/1/name=keywords
TeamSite/Metadata/1/value=bill, billing
TeamSite/Metadata/2/name=title
TeamSite/Metadata/2/value=Get money off your BT bill!
TeamSite/Metadata/3/name=url
TeamSite/Metadata/3/value=http://www.productsandservices.bt.com/consumerProducts/displayCategory.do?categoryId=CON-BT-CCARD-I
TeamSite/Metadata/4/name=segment
TeamSite/Metadata/4/value=CON
TeamSite/Metadata/5/name=description
TeamSite/Metadata/5/value=Automatically get money off your phone bill with the new BT Credit Card
TeamSite/Metadata/6/name=order
TeamSite/Metadata/6/value=1
TeamSite/Metadata/author=iwcms
TeamSite/Metadata/content_type=search_generic
TeamSite/Metadata/creation_date=06-06-2008 08:30

TeamSite/Metadata/document_live_date=07-06-2008 00:00
TeamSite/Metadata/document_retire_date=07-06-2010 23:59
TeamSite/Metadata/document_size=74
TeamSite/Metadata/id=2577273476
TeamSite/Metadata/modified_date=18-06-2008 06:41
TeamSite/Templating/Encoding=
TeamSite/Templating/PrimaryDCR=bt_.html
TeamSite/Templating/PrimaryDocumentType=content/search_generic
TeamSite/Templating/PrimaryPT=default.tpl

** The DB's table description information
I am unable to run describe command for the moment on the database because of access issues but I hope the information I have posted will help to develop further thoughts.

Adam Stoller

I'm familiar with seeing things like:

varchar2(20)

, but not with

varchar2(22 char)

- are you sure that is an allowed syntax? (I don't think it's the source of the current issue you're dealing with, but it does seem ... well ... different)

I think the issue you're having is with this:

...
  <group name="bt_document_metadata" root-group="no" >
    <attrmap>
      ...
      <column name="name" data-type="varchar2(240 char)"
                 value-from-field="TeamSite/Metadata/[1-200]/name"
                 is-replicant="yes" allows-null="no"/>
      <column name="value" data-type="varchar2(2000 char)"
list-to-replicant="yes"
                 value-from-field="TeamSite/Metadata/[1-200]/value"
                 is-replicant="yes" allows-null="no"/>
      ...
    </attrmap>
  </group>
  ...

If my reading of the documentation is correct -

list-to-replicant

is intended to take a comma-separated list of entries within a single field and treat them as-if they were individual entries within a replicant field. In your case you have metadata like:

...
TeamSite/Metadata/1/name=keywords
TeamSite/Metadata/1/value=bill, billing
TeamSite/Metadata/2/name=title
TeamSite/Metadata/2/value=Get money off your BT bill!
...

Unless you're expecting "bill" and "billing" to be treated as separate entries - I don't believe that

list-to-replicant

is appropriate here (and if you do want that, I'm not sure if it works like that - I've never used this feature).

So - try removing that setting and see if it resolves your problem.

jkm

Thanks Adams for your reply.

I am having less doubt on dd config file at the moment and the reason for this is, after doing various tests, we have confirmed that datadeploy is working fine when we are deploying directly to the tables but it fails when we deploy to synonyms.

This comes to the very first thing in my post where I was having doubt on public/private synonyms.

We raised this to IWOV Support as well and they have suggested as below

Basically, the data deploy config file needs to include the properties file which has the synonyms=true parameter set. For example, it would look like this:

properties-file = "c:\ddtest\db-properties.cfg"
real-update = "yes">

db-properties.cfg contains synonyms=true

I tried look for any documentation on this property but there is no information available in admin guide/support site apart from these articles

https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=52719

which are related to DD 5.6.

Do you guys have any further insight on this?

jkm

Just to conclude this thread, solution for this problem was, we need to set the property suggested by IWOV Support team

properties-file = "c:\ddtest\db-properties.cfg"
real-update = "yes">

db-properties.cfg contains synonyms=true

There is no documentation or support article available for this property and I will be raising a documentation bug for the same. I hope it will be useful for everyone.

Apart from this, we identified a problem on the set up of the schema and DB team has resolved the issue and we are able to perform the deployments.

Migrateduser

i am having a similar issue - our iwtracker table isnt being update. which config did u add these attributes to? database.xml?

DBD: Table [iwtracker] exists.
DBD: DEFAULT_PR_NEWS__NEWS__MAIN_COMMON_STAGING not registered
DBD: Error occured in TDbSchemaSynchronizer
DBD: ERROR:TDbSchemaSynchronizer create failure.