| |
Posted: Jan 18, 2008 12:39:53 AM |
Total Post: 8
Joined: Dec, 2007
|
From last few days the datebase is responding too sluggish.
I could find the following error logs in the trace file
ORA-12012 error on auto execute of job 908 or 838
ORA-01086 Savepoint Wf_savepoint never established
ORA-25263 no message in queue BTcom.WF_defferred_queue with message id .....
ORA-06512 at BTcom.WF_engine
Could someone let me know hoe to resolve this error. |
|
|
 Murtuja |
| Posted: Jan 18, 2008 02:47:34 AM |  |
|
Total Post: 843
Joined: Jan, 2006
|
could you provide some more information ?
|
|
|
|
|
| |
| Posted: Jan 18, 2008 03:09:51 AM | |
|
Total Post: 8
Joined: Dec, 2007
|
There is a workflow procedure
wf_engine.background procedure. Wf_savepoint references are present in two procedures called from this main proc:wf_engine.ProcessStuckProcess and Wf_engine.ProcessTimeOut , where savepoint wf_savepoint is mentioned in start of transaction individual procedure and rollback to wf_savepoint is mentioned in exception handling part of individual procedure.
I guess one of these savepoints is not being able to establish that is creating the problem
|
|
|
|
|
| Murtuja |
| Posted: Jan 18, 2008 04:40:30 AM | |
|
Total Post: 843
Joined: Jan, 2006
|
See Metalink Note:122538.1
ORA-1086, ORA-02049 Running Workflow Background Engine 2.5
|
|
|
|
|
| Murtuja |
| Posted: Jan 18, 2008 04:42:50 AM | |
|
Total Post: 843
Joined: Jan, 2006
|
See also Metalink Note:188590.1
Workflow is not running. Error ORA-25263 in queue OWF_ADMIN.WF_DEFERRED_QUEUE
symptom: Error ORA-25263: no message in queue OWF_ADMIN.WF_DEFERRED_QUEUE
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
