Tuesday, March 23, 2010

Workflow Error


Today we faced a peculiar error the invoices were not being initiated and the approval through work list was erroring out since morning
Looking at alert.log found the following

ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000061324C00040$$ by 16 in tablespace APPS_TS_QUEUES
ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000061324C00040$$ by 16 in tablespace APPS_TS_QUEUES
ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000060902C00036$$ by 16 in tablespace APPS_TS_QUEUES
ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000060902C00036$$ by 16 in tablespace APPS_TS_QUEUES


And the error seen the workflow is

[Mar 23, 2010 10:55:24 AM AST]:1269330924199:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:prd-app1.main.tadmur.com:192.168.200.100:-1:-1:ERROR:[SVC-GSM-WFALSNRSVC-13481-10003 : oracle.apps.fnd.cp.gsc.Processor.performError(ProcessorException)]:Maximum number of errors have occurred for this processing thread.
[Mar 23, 2010 10:55:25 AM AST]:1269330925626:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:prd-app1.main.tadmur.com:192.168.200.100:-1:-1:ERROR:[SVC-GSM-WFALSNRSVC-13481-10002 : oracle.apps.fnd.wf.bes.AgentListenerProcessor.read()]:Could not executeUpdate() on { CALL WF_EVENT.LISTEN ( p_agent_name => :1, p_wait => :2, p_correlation => :3, p_deq_condition => null, p_message_count => :4, p_max_error_count => :5 )} -> java.sql.SQLException: ORA-20002: 3837: An unhandled error '-604 - ORA-00604: error occurred at recursive SQL level 1
ORA-01691: unable to extend lob segment APPLSYS.SYS_LOB0000060902C00036$$ by 16 in tablespace APPS_TS_QUEUES' encountered when dispatching event 'oracle.apps.wf.notification.send' with key '213664'
ORA-06512: at "APPS.WF_EVENT", line 1560
ORA-06512: at line 1


The size of APPS_TS_QUEUES was increased and the workflow components were restarted.

No comments: