nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Deploy Failure

Natasha

Hi All,

While deploying some content to a database, we are encountering the following error :-


DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: ORA-01461: can bind a LONG value only for insert into a LONG column

DBD: Vendor Error Code: 1461
DBD: SQL state: 72000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
        at 

oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
        at 

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
        at 

oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984

)
        at 

oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3057)
        at 

com.interwoven.dd100.dd.TDbSchemaUpdateHelper.UpdateOneRow(TDbSchemaUpdateHelper.java:882)
        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.TTupleSubstitutor.WriteTuple(TTupleSubstitutor.java:113)
        at 

com.interwoven.dd100.dd.TPredicateEvaluator.WriteTuple(TPredicateEvaluator.java:116)
        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:1008)
        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.DoMultiDeployment(TAgentClient.java:206)
        at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:169)
        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: ERRORoRealUpdate() failed for group [F_STANDARD].
DBD:  -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata/
DBD: ERROReployment [fragments_standard] FAILED
DBD: ERROR:multi-deployment [microsites] FAILED

In order to resolve it, I just shortened the content for that particular field in the DCR and re-deployed it. I had to repeat this activity around 10 odd times in order to deploy the complete content. This is happening in case of a particular environment only as the same content is getting deployed to other environments without any issue.
Also, the field for which we are getting this error is specified as VARCHAR2(4000) and not of LONG type as specified in the exception message.

Could this issue be due to difference in the database across the environments as it is failing for one particular env.

Any pointers/help would be appreciated.

Thanks,
Natasha.

TS 6.7.1 SP1, OD 6.1, LS 3.0.1

Find more posts tagged with

Comments

Adam Stoller

You say the environments are different - are you sure the database itself is setup the same way? Perhaps the column in the database is defined as LONG and not VARCHAR2(4000) in one of the environments? i.e. the problem might be at the database end rather than at the DD end.

JavaChartExample.java

screenshot.png

Natasha

You say the environments are different - are you sure the database itself is setup the same way? Perhaps the column in the database is defined as LONG and not VARCHAR2(4000) in one of the environments? i.e. the problem might be at the database end rather than at the DD end.

Thanks for the response.
I have checked the table details in the database and found that the column is of type VARCHAR2(4000) and not LONG. As far as database setup for different environments is concerned, I couldn't think of way for checking it. And what is more surprising is that the same content is getting deployed to another environment's database without any issue. Both environments' databases have this column type as "VARCHAR2(4000). Is there any way of checking it further down?

Thanks,
Natasha.