Data deploy with CLOB datatypes.

Hi,

I am trying to use data deploy to deploy a DCR into the oracle DB table. One column type is CLOB. When I create an XML out of the DCR and send it to DB for deploy using data deploy it fails giving out reason (the XML element sent out is String (varchar) where as the DB column is CLOB):--

DBD: ERROR:Error writing to CLOB No more data to read from socket
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: SQL string creation failure when converting value of column: PROMOTION_TEXT
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: SQL string creation failure when converting value of column: PROMOTION_TEXT
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1293)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.InsertReplSameLevel(TDbSchemaGroupCfg.java:1646)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformReplicantInsert(TDbSchemaGroupCfg.java:1372)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1150)
at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:477)
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: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.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: ERROR Smiley Very Happy

oInsert() failed for group [PROMOTION].

How should I configure my DD config or the tpl xml so as to pass that particular value as CLOB and not string to the DB so that it can accept it.

Thanks.

Find more posts tagged with

Comments

cesarecastro

You must setup your dd script to deploy a CLOB. Here is an example;

column name="BODY_COPY" data-type="CLOB" value-from-field="somethinghere/0/page/0/generated_file/0" is-url="yes" url-content-encoding="UTF-8"

geargrinder

Thanks Cesarecastro,

Here the sample xml that gets created from my code. Also the DDConfig is the same as you have suggested. Does the xml look fine?

Thanks

cesarecastro

geargrinder

First thing you need to do is open a case with Interwoven support.

The xml looks formatted correctly. Please share your dd configuration for this type and possibly your db table setup. This may help us help you better.

sivaramiyer

are you trying to deploy an entire DCR into the CLOB field? if yes, I dont think that works with datadeploy.
I remember running into the same issue in the past; and I have a custom code that handles deployment to table.

Thanks
Sivaram

sumitk

Try appending file:// protocol in the DCR field after entering value in DCR for CLOB datatype. This worked for me for BLOB datatype.

elenav

Hi geargrinder,

I have the same problem. I see it is an old problem, but can you tell me if you have resolved it?

Thanks,
Elena

jateen

column name="column_Name" data-type="CLOB" value-from-field="rootContainer/0/container/[0-5]/item/0" is-replicant="yes|no" allows-null="no" is-url="no"

you can check /usr/OpenDeployNG/etc/datatypes.xml
for clob data type .

MidnightDad

Did you ever solve this? We're having a similar problem with OpenDeploy 6.2.1.0.0 and Oracle driver 9.2.0.1.0.

nipper

MidnightDad wrote:
Did you ever solve this? We're having a similar problem with OpenDeploy 6.2.1.0.0 and Oracle driver 9.2.0.1.0.

Since this thread is 7 years old you would be much better opening a new thread.

OD 6.2.1 is also so far EOL (end of life) that you will be lucky to get help. 6.2.1 came out in 2007/2008