DD Failure when Deploying a DCR+html

Salutes to great IWOVians,

I am working with TS 6.5/OD 6.0.2 with Transactional Deployment enabled in Solaris 8 Env. We are facing a DD Failure when a DCR and HTML is deployed to gether. It is a stand alone deployment configuration.

It is happening to a particular branch only. Please not we have a Custom Tuple Processor which refers to certain fields in the DCR and a config xml file as the Primary Keys while generating the tuple.

The peculilar thing is that DD prints the DCR , preprocesses it and builds the tuple and runs the DBD. Then it attempts to build the tuple for the HTML which is not at all intented to go to DB. Then it generates the following errors.
And entire deployment is rollled back.

I am dumbfounded. Please help me with some Pointers.....

Runtime Exception:

DBD: ERROR:Exception occured while calling PreProcessTuple()
DBD: ERROR:
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1444)
at com.****.****.***.tupleprocessor( a Custom Tuple Processor).TupleProcessor.PreProcessTuple(TupleProcessor.java:209)
at com.interwoven.dd100.dd.TExternalTupleProcessorHandler.ProcessTuple(TExternalTupleProcessorHandler.java:70)

DBD Error:

DBD: ERROR:Values for PK column [CONTENTID] missing in [*****docs/retail/popups/***/redir_***.html].
DBD: ERROR:Exception occured: Values for PK column [CONTENTID] missing in [*****docs/retail/popups/***/redir_***.html].
DBD: ERROR:
com.interwoven.dd100.dd.InvalidSourceTupleException: Values for PK column [CONTENT_ID] missing in [*****docs/retail/popups/***l/redir_****.html].
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmtForExistCheck(TDbSchemaGroupCfg.java:2135)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForTuple(TDbSchemaGroupCfg.java:2054)

ROLL BACK Error:

DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source ******docs/retail/popups/****/redir_****.html, obtained from filelist=/default/main/***/****/WORKAREA/users/logs/***dct.file.list.1200042840.cfg
DBD: Filelist walk done
DBD: ERROR Smiley Very Happy

eployment [DEV-****DCT-FILELIST] FAILED
DBD: ERROR:multi-deployment [DEV-MASTER-FILELIST] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)

Find more posts tagged with

Comments

Bhargav Coca

Can you please post your dbschema and ****_dd.xml, It would help to debug this more.

Thanks

Jangra

Check your DCR (content tree formation) and accordingly pick values of its fields in your DD script.
DCR type IWOV and DCR type XML have different tree formation in xml. check the type of DCR in templating.cfg and analyze the DCR also. Might be it will help you. Smiley Happy

gokz

Hi Liileywhile/Jangra,

Thanks for your responses.
I could not share my config files due to Security Policies of the Organization.
Please help me to debug further with the below info :

The mentioned DCT is defined as 'iwov' type.
We have a field in DCT called 'BODYCOPY' where HTML Content can be inserted.
The HTML file which is parsed by DD is passed by reference in this field.
We have a Tuple Process Mapping file as well in the workarea.
The TPP uses this file to create PrePorcess Tuple.
It goes to the a CLOB column in database.
And it creates a node tree in the DB Column.

We define the BODY COPY column as follows

<**node id="BODYCOPY" type="string" hasParseData="true"/>

And I could find following TPP Pre Processing in DD log also.

This is the attempt to Preprocess the HTML.

PreProcess: Printing Original DCR
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/1/ul/0/{iw_sub_elements}/2/li/0=
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/1/ul/0/{iw_sub_elements}/2/li/0/{iw_sub_elements}/0=
PreProcess: html/0/{iw_sub_elements}/0/head/0/{iw_sub_elements}/4/link/0/{iw_attributes}/0/type=text/css
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/2/p/0/{iw_sub_elements}/0/small/0/{iw_sub_elements}/5=
PreProcess: html/0/{iw_sub_elements}/1=
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/2/p/0/{iw_sub_elements}/0/small/0/{iw_sub_elements}/4=
PreProcess: html/0/{iw_sub_elements}/0=
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/2/p/0/{iw_sub_elements}/0/small/0/{iw_sub_elements}/3=

Please let me know if you find any anomaly in DCT Config with these details.

Regards

Gokul Alex
TS 6.5, OD 6.0.2/DD 5.6
Solaris 8

Ambuj

Hi Liileywhile/Jangra,

Thanks for your responses.
I could not share my config files due to Security Policies of the Organization.
Please help me to debug further with the below info :

The mentioned DCT is defined as 'iwov' type.
We have a field in DCT called 'BODYCOPY' where HTML Content can be inserted.
The HTML file which is parsed by DD is passed by reference in this field.
We have a Tuple Process Mapping file as well in the workarea.
The TPP uses this file to create PrePorcess Tuple.
It goes to the a CLOB column in database.
And it creates a node tree in the DB Column.

We define the BODY COPY column as follows

<**node id="BODYCOPY" type="string" hasParseData="true"/>

And I could find following TPP Pre Processing in DD log also.

This is the attempt to Preprocess the HTML.

PreProcess: Printing Original DCR
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/1/ul/0/{iw_sub_elements}/2/li/0=
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/1/ul/0/{iw_sub_elements}/2/li/0/{iw_sub_elements}/0=
PreProcess: html/0/{iw_sub_elements}/0/head/0/{iw_sub_elements}/4/link/0/{iw_attributes}/0/type=text/css
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/2/p/0/{iw_sub_elements}/0/small/0/{iw_sub_elements}/5=
PreProcess: html/0/{iw_sub_elements}/1=
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/2/p/0/{iw_sub_elements}/0/small/0/{iw_sub_elements}/4=
PreProcess: html/0/{iw_sub_elements}/0=
PreProcess: html/0/{iw_sub_elements}/1/body/0/{iw_sub_elements}/0/div/0/{iw_sub_elements}/2/p/0/{iw_sub_elements}/0/small/0/{iw_sub_elements}/3=

Please let me know if you find any anomaly in DCT Config with these details.

Regards

Gokul Alex
TS 6.5, OD 6.0.2/DD 5.6
Solaris 8

You said, "It is happening to a particular branch only". Is the same code / configuration working for other branches?
Is it working for any other data type in same Branch?
Is this problem coming recently or it never worked?
Did you try testing with some simple deployments (some fixed values)?

gokz

Hi Nitesh,

Thanks for the response. Please find my i/ps below.
DCR+HTML combination is working for other branches.
The deployment is working fine evn when the DCR is deployed separately.
And it is reported very recently.

Best Regards
Gokul