Symptom

We have started getting the following error while processing customer inbound XML orders. After re-processing the orders, this error will not occur for the second time.  java.io.IOException: java.sql.SQLException: ORA-01483: invalid length for DATE or NUMBER bind variable

Customer is on GIS 4.2 Build Version: 4206

DOracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

OS-System: AIX 5.3,ppc

1. In System.log file :

[2007-09-24 20:45:57.715] ERROR SQL State: 72000

java.sql.SQLException: ORA-01483: invalid length for DATE or NUMBER bind variable

          at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java(Compiled Code))

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Compiled Code))

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Inlined Compiled Code))

          at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java(Compiled Code))

          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java(Compiled Code))

          at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java(Compiled Code))

          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code))

          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java(Compiled Code))

          at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java(Compiled Code))

          at com.sterlingcommerce.woodstock.util.frame.jdbc.IJDBCVarData.insertBlob(IJDBCVarData.java:578)

          at com.sterlingcommerce.woodstock.util.frame.jdbc.IJDBCVarData.insertBlob(IJDBCVarData.java(Inlined Compiled Code))

          at com.sterlingcommerce.woodstock.util.frame.jdbc.IJDBCOutputStream.write(IJDBCOutputStream.java(Compiled Code))

          at com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCOutputStreamWrapper.write(JDBCOutputStreamWrapper.java(Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.DocumentOutputStream.writeToDB(DocumentOutputStream.java(Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.DocumentOutputStream.write(DocumentOutputStream.java(Compiled Code))

          at sun.nio.cs.StreamEncoder$ConverterSE.implWrite(StreamEncoder.java(Compiled Code))

          at sun.nio.cs.StreamEncoder.write(StreamEncoder.java(Compiled Code))

          at java.io.OutputStreamWriter.write(OutputStreamWriter.java(Compiled Code))

          at java.io.BufferedWriter.flushBuffer(BufferedWriter.java(Compiled Code))

          at java.io.BufferedWriter.write(BufferedWriter.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.util.XMLWriter.write(XMLWriter.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.util.XMLWriter.writeXMLTags(XMLWriter.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.blockprocessor.XMLOutputBlockHandler.processEndTag(XMLOutputBlockHandler.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.blockprocessor.XMLOutputBlockHandler.handleBlock(XMLOutputBlockHandler.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.blockprocessor.OutputStreamBlockProcessor.matchBlock(OutputStreamBlockProcessor.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.processBlock(BlockSequence.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.searchBlock(BlockSequence.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.searchGroup(BlockSequence.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.blockprocessor.XMLOutputBlockSequence.searchGroup(XMLOutputBlockSequence.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.searchForward(BlockSequence.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.processFileFormat(BlockSequence.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.engine.TranslationEngineImpl.translateOutput(TranslationEngineImpl.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.engine.TranslationEngineImpl.doTranslation(TranslationEngineImpl.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.engine.TranslationEngineImpl.translate(TranslationEngineImpl.java(Compiled Code))

          at com.sterlingcommerce.woodstock.translator.engine.TranslationEngine.translate(TranslationEngine.java(Compiled Code))

          at com.sterlingcommerce.woodstock.services.translation.TranslationServiceImpl.processData(TranslationServiceImpl.java:617)

          at com.sterlingcommerce.woodstock.workflow.activity.engine.ActivityEngineHelper.invokeService(ActivityEngineHelper.java(Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.activity.engine.ActivityEngineHelper.nextMainLogic(ActivityEngineHelper.java(Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.activity.engine.ActivityEngineHelper.next(ActivityEngineHelper.java(Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.doWork(WorkFlowQueueListener.java(Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.run(WorkFlowQueueListener.java(Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.onMessage(WorkFlowQueueListener.java(Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.onMessage(WorkFlowQueueListener.java(Inlined Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.queue.wfTransporter.run(wfTransporter.java(Compiled Code))

          at com.sterlingcommerce.woodstock.workflow.queue.BasicExecutor$Worker.run(BasicExecutor.java(Compiled Code))

          at java.lang.Thread.run(Thread.java(Compiled Code))