| Error 942 happened during loading of queue [message #64441] |
Sat, 29 January 2005 06:39  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi, i was getting the error
"kwqiclode: Error 942 happened during loading of queue"
in the Alert log very frequently(almost very minute).
I checked the trace file it showed
"Error 942 in Queue Table QS.QS_ORDERS_PR_MQTAB"
I checked the table that was used by a view QS.AQ$QS_ORDERS_PR_MQTAB
and the view was refrerring another table QS.AQ$_QS_ORDERS_PR_MQTAB_S which doesnt exists
in the database so i created the table(copied structure from another instance)
and recompiled the view now i am not getting this error.
Can anyone tell me whats the meaning of the above error and whats the purpose
of above view and for what the user QS is used.
Is it related to Locking on tables as initially there was too much locking
showed in OEM but now it has reduced.
Please let me know its very urgent for me
Thanks in advance
Vivek
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
