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.
Monday, March 22, 2010
User Notification Preference Update from backend
We have been facing problems when the email address is not properly defined in per_people_f and fnd_user at times the mailer changes the send mail preference to disabled. So this creates a situation where you have to ask the user to change his preference to HTML mail with attachments.
There is another way out doing it from back end.
exec FND_PREFERENCE.put('SYSADMIN', 'WF', 'MAILTYPE', 'MAILHTML');
COMMIT;
as documented in Metalink Note ID 746255.1
There is another way out doing it from back end.
exec FND_PREFERENCE.put('SYSADMIN', 'WF', 'MAILTYPE', 'MAILHTML');
COMMIT;
as documented in Metalink Note ID 746255.1
Subscribe to:
Posts (Atom)