Deploy HTML to DB using DataDeploy

Vijay_Tandel

Hi,

I am trying to DataDeploy HTML into database using URL Content


< column name = "CONTENT_HTML" data-type="CLOB" is-url="yes" value="file:///iwmnt/default/main/Test/WORKAREA/test_wa/HTML/Test.html"/ >

I get following error during deployment.

length of CLOB/LONG data = 369
DBD: ERROR:Error writing to CLOB Protocol violation
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: SQL string creation failure when converting value of column: CONTENT_HTML
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************

DBD: *******************************************************
DBD: SQLException occured in TDbAgent:Rollback()
DBD: Exception Message: Protocol violation
DBD: Vendor Error Code: 17401
DBD: SQL state: null
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: Protocol violation
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
at oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.java:149)
at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protocol.java:487)
at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1376)
at com.interwoven.dd100.dd.TDbAgent.Rollback(TDbAgent.java:3009)
at com.interwoven.dd100.dd.TDbAgent.Close(TDbAgent.java:3564)
at com.interwoven.dd100.dd.TDbSchemaAgent.Close(TDbSchemaAgent.java:506)
at com.interwoven.dd100.dd.TConsumerManager.CloseConsumers(TConsumerManager.java:294)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:194)
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)

Can anyone plese help me on this. How to deploy HTML content to database using DataDeploy.

Thanks,

Vijay_Tandel

Hi,

Following works for me

< column name = "CONTENT_HTML" data-type="BLOB" is-url="yes" value="file:///iwmnt/default/main/Test/WORKAREA/test_wa/HTML/Test.html" url-content-encoding="UTF-8" / >

Thanks,