CAUAJM_E_10163 Exhausted maximum number of query retries.

Document ID : KB000046146
Last Modified Date : 14/02/2018
Show Technical Document Details

ISSUE:

 

A production instance stopped processing events 11 hours ago before being picked up by a business customer. The messages provided in the log are insufficient to allow for root cause. 

 

Need CA Technical Support involvement to get to the cause and to prevent this from happening again. 

 

Stopped and started the instance which allowed processing to continue 

 

[06/14/2016 00:06:18] CAUAJM_E_10163 Exhausted maximum number of query retries. 

[06/14/2016 00:06:18] CAUAJM_E_18002 Stored Procedure execution returned a failure: -6 

[06/14/2016 00:06:18] CAUAJM_E_18016 Server: XXXXXXX

[06/14/2016 00:06:18] CAUAJM_E_18017 Procedure: ujo_batch_get_event 

[06/14/2016 00:06:18] CAUAJM_E_18018 Server message: Message number(2714), Severity(16), State(3), Line(17), Message String: Th 

ere is already an object named '#ujo_bge' in the database. 

[06/14/2016 00:06:18] CAUAJM_E_18016 Server: XXXXXXX 

[06/14/2016 00:06:18] CAUAJM_E_18017 Procedure: ujo_batch_get_event 

[06/14/2016 00:06:18] CAUAJM_E_18018 Server message: Message number(208), Severity(16), State(6), Line(44), Message String: #uj 

o_bge not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). 

[06/14/2016 00:06:18] CAUAJM_E_18012 Event Server: <XXXXXXX:autosys_p81> Failed Stored Procedure: <EXEC ujo_batch_get_ 

event @time0, @time0_prev <<1465862678,0>>>

 

 

 

ENVIRONMENT:

 

autoflags -a 

742 AIX SYB 11.3.6 SP4

select str_val from ujo_alamode where type='AEDB_VERSION' 

11.3.6.4.0 

 

SOLUTION:

 

This appears to be an SAP Issue. 

 

Link for fixes in ASE 15.76 SP137: 

https://apps.support.sap.com/sap/support/knowledge/preview/en/2265965 

 

Based on the description this is the closes issue found: 

 

790672In rare scenarios where the monOpenObjectActivity table is used and a #temp table is being dropped, the 3702 error, "Cannot drop or replace the < obj_name > because it is currently in use" may be reported and the temp table could not be dropped.