Article

Savvion Worksteps suspended with: Internal error -100007 in SQL from subsystem DSM SERVICES function dsmLobUpdate called from proLob::updateData

Information

 
Article Number000056311
EnvironmentProduct: Savvion
Version: 7.6.x
OS: All supported platforms
Question/Problem Description
Savvion worksteps suspended with error -100007 followed by (11209).


 
Steps to Reproduce
Clarifying Information
BizLogic.log file also contains a line:

BizLogic | ERROR | ejbServer | BizLogic | (1621):SQL Exception occurs in database transaction.; context(BLDAOService.handle(SQLEx))[DataDirect][OpenEdge JDBC Driver][OpenEdge] Long data exceeds column width. (11209) | WorkManager(2)-34 |#]
Error Message[#| 17 Dec 2014 10:55:13,572 | BizLogic | ERROR | ejbServer | BizLogic | (3502):Update of output dataslots failed for Adapter <HoursRegistration_V2#130158>:<PrepareEmailApproved>:<1>.; context(EPM.updateAdapterOutput) | WorkManager(2)-35 |#]
com.savvion.sbm.bizlogic.util.BizLogicException: (1621):SQL Exception occurs in database transaction.; context(BLDAOService.handle(SQLEx))[DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -100007 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmLobUpdate called from proLob::updateData on for . Save log for Progress technical support.
at com.savvion.sbm.bizlogic.util.BLDAOService.handle(Unknown Source)
at com.savvion.sbm.bizlogic.server.dao.DataSlotDAO.update(Unknown Source)
at com.savvion.sbm.bizlogic.server.dao.DataSlotDAO.store(Unknown Source)
at com.savvion.sbm.bizlogic.server.WFDataSlotInstance.updateSlotValue(Unknown Source)
at com.savvion.sbm.bizlogic.server.WFProcessContext.updateSlotValue(Unknown Source)
at com.savvion.sbm.bizlogic.server.EPManager.updateAdapterOutput(Unknown Source)
at com.savvion.sbm.bizlogic.server.AdapterRunner.updateAdapterOutput(AdapterRunner.java:183)
at com.savvion.sbm.bizlogic.server.AdapterRunner.executeUsingUT(AdapterRunner.java:74)
at com.savvion.sbm.bizlogic.server.ejb.BLAdapterMDB.onMessage(BLAdapterMDB.java:63)
at sun.reflect.GeneratedMethodAccessor423.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.invocation.Invocation.performCall(Invocation.java:386)
at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:513)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:173)
at org.jboss.ejb.plugins.MessageDrivenTxInterceptorBMT.invoke(MessageDrivenTxInterceptorBMT.java:47)
at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:115)
at org.jboss.ejb.plugins.RunAsSecurityInterceptor.process(RunAsSecurityInterceptor.java:133)
at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:103)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
Defect/Enhancement Number
Cause
Error message indicates BLOB is corrupt. Column width for the BLOB column not large enough.

Error -100007 indicates a corrupted blob (no information available from the log files w.r.t which particular blob).
Error 11209 means: "Long data exceeds column width"
Resolution
Increase the PRO_SQL_WIDTH for LARGE_DATASLOTS column
 
ALTER TABLE BIZLOGIC_DS_<PTID> ALTER COLUMN LARGE_DATASLOTS SET PRO_SQL_WIDTH 2147483600;
Workaround
Notes
Attachment 
Last Modified Date12/18/2018 7:05 AM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025