| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Workitem timeout / core dump problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| spprash |
 Posted: Thu Jul 31, 2003 2:15 am Post subject: Workitem timeout / core dump problem |
 |
|
Apprentice
Joined: 29 Dec 2002
Posts: 25
|
I have developed a WebSphere application to access workflow. During system testing we get the following error. this occurs both while starting a workflow process and querying workitems.
FMC38009E MQSeries Workflow API Error :
API Return Code : 14
Error Origin : /projects/fmc/drvl/lbld/v332/src/fmcjcins.cxx, line 3338
Error Message : FMC00014E Timeout occurred
Nested Exception : None
at com.ibm.workflow.api.loc.ProcessInstanceImpl.start2ProcessInstanceImpl.java:592) at com.jpmorgan.cc.server.workflowmanager.WorkflowAdapter.startWorkflowProcessInstance(WorkflowAdapter.java:361)
The Workflow Error Logs revealed the following errors
- 07/28/03 10:42:01 AM FmcSQLException, Sqlcode=-1562, Sqlerrmc=ORA-01562: fail
ed to extend rollback segment number 3
ORA-01650: unabl, Sqlerrp=NOT SET , Sqlerrd[0]=0, Sqlerrd[1]=0, Sqlerrd[2]=0, Sq
lerrd[3]=0, Sqlerrd[4]=0, Sqlerrd[5]=0, Sqlwarn= , Sqlext=
I created more Rollback segments and allocated space to these segments.
However the problems persisted but with a different error. We got Core while accessing workflow. The WORK_ITEM table revealed over 100,000 entries and on truncating the WORK_ITEM table I was able to get the system running.
I have two queries.
1.What effect has the rollback segments got on queryWorklist method and the eventual timeouts we get
2.What is the exact purpose of the WORK_ITEM table and why does it get filled with 100,000 records and is it acceptable to clear this table periodically.
_________________
Prash |
|
| Back to top |
|
 |
| Andy |
| Posted: Thu Jul 31, 2003 2:59 am Post subject: |
|
|
Centurion
Joined: 14 May 2003
Posts: 122
|
| spprash wrote: |
| 2.What is the exact purpose of the WORK_ITEM table and why does it get filled with 100,000 records and is it acceptable to clear this table periodically. |
What should be done periodically are:
1. Run Cleanup Server during offpeak hours.
2. Run statistics on tables, once per week atleast.
As we can guess seeing table and it's column names, WORK_ITEM table stores the information about work items. But exact usage and purpose of tables are not disclosed by IBM.
What is known to all is that indexes, audit trail and workitem tables are used most frequently by MQWF.
_________________
 Andy |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
