Symptom

[2007-08-22 17:45:16.503] ERROR 000610130014 TRANSLATION.TRANSLATION_UTIL.ERR_SQLWriter_exception7 TRANSLATOR: SQL Exception while performing operation for IC322REF:2

[2007-08-22 17:45:16.503] ERROR SQL Error Code: -99999

[2007-08-22 17:45:16.503] ERROR SQL State: HY014

java.sql.SQLException: Limit on number of statements exceeded.

at com.ibm.as400.access.JDError.throwSQLException(JDError.java:389)

at com.ibm.as400.access.AS400JDBCConnection.getUnusedId(AS400JDBCConnection.java:12 78)

at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.ja va:1902)

at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.ja va:1726)

at com.sterlingcommerce.woodstock.translator.util.SQLWriter.getPreparedStatementFor SQLString(SQLWriter.java:759)

at com.sterlingcommerce.woodstock.translator.util.SQLWriter.executeSQL(SQLWriter.ja va:542)

at com.sterlingcommerce.woodstock.translator.fieldprocessor.SQLOutputFieldHandler.p rocessFieldValues(SQLOutputFieldHandler.java:217)

at com.sterlingcommerce.woodstock.translator.fieldprocessor.SimpleFieldProcessor.pr ocessFieldValues(SimpleFieldProcessor.java:352)

at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockHandler.handleBloc k(BlockHandler.java:103)

at com.sterlingcommerce.woodstock.translator.blockprocessor.SQLBlockHandler.handleB lock(SQLBlockHandler.java:422)

at com.sterlingcommerce.woodstock.translator.blockprocessor.OutputSimpleBlockProces sor.matchBlock(OutputSimpleBlockProcessor.java:122)

at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.processBl ock(BlockSequence.java:818)

at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.searchBlo ck(BlockSequence.java:644)

at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.searchGro up(BlockSequence.java:512)

at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.searchFor ward(BlockSequence.java:304)

at com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.processFi leFormat(BlockSequence.java:278)

at com.sterlingcommerce.woodstock.translator.engine.TranslationEngineImpl.translate Output(TranslationEngineImpl.java:1355)

at com.sterlingcommerce.woodstock.translator.engine.TranslationEngineImpl.doTransla tion(TranslationEngineImpl.java:1446)

at com.sterlingcommerce.woodstock.translator.engine.TranslationEngineImpl.translate (TranslationEngineImpl.java:1008)

at com.sterlingcommerce.woodstock.translator.engine.TranslationEngine.translate(Tra nslationEngine.java:192)

at com.sterlingcommerce.woodstock.services.translation.TranslationServiceImpl.proce ssData(TranslationServiceImpl.java:587)

at com.sterlingcommerce.woodstock.workflow.activity.engine.ActivityEngineHelper.inv okeService(ActivityEngineHelper.java:1577)

at com.sterlingcommerce.woodstock.workflow.activity.engine.ActivityEngineHelper.nex tMainLogic(ActivityEngineHelper.java:569)

at com.sterlingcommerce.woodstock.workflow.activity.engine.ActivityEngineHelper.nex t(ActivityEngineHelper.java:347)

at com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.doWork(WorkF lowQueueListener.java:277)

at com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.run(WorkFlow QueueListener.java:192)

at com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.onMessage(Wo rkFlowQueueListener.java:157)

at com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.onMessage(Wo rkFlowQueueListener.java:143)

at com.sterlingcommerce.woodstock.workflow.queue.wfTransporter.run(wfTransporter.ja va:332)

at com.sterlingcommerce.woodstock.workflow.queue.BasicExecutor$Worker.run(BasicExec utor.java:519)

at java.lang.Thread.run(Thread.java:534)