[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: Unsubscribe

Hi Ravi,

This is happening intermittent and we are not able to identify the pattern. If the table row got locked after that all subsequent update call is in wait. 
Until we release it from DB or kill that session its still in the same state. I can see from that AR Error log its trying to update the 112(Assignee group) field and its locking the row. 
DB is saying application is not passing the commit. Is there any way we can identify what are all SQL's are going to DB. 

Dinesh kumar.

On Tue, Mar 27, 2018 at 9:15 AM, Ravindrakumar Rodge <ravirup24@gmail.com> wrote:

You need to check. 
1. Escalations are running on the server or not. 
2. How many records stuck on cai:events form and clean unwanted stuck records. 
3. Ensure cai:plugin registry has threads defined as documented. (form name CAI:Plugin Registry) 
4. Ensure the z1DAction values are defined in the escalation in below link as it is escalation responsible for processing the records. 

5. Check with arerror.log and arjavaplugin. लोग with Debug Mode for more details. 

6. Enable Api sql fltr and reproduce the issue. That will give some inputs and leads. 

Try to do performance check and ensure your servers are properly configured for threads. 


On Tue, Mar 27, 2018, 10:48 AM Mark Rushton <mark.rushton@talk21.com> wrote:

Sent from my iPhone 6 😃

On 26 Mar 2018, at 19:28, Tauf Chowdhury <taufc.is@gmail.com> wrote:

Totally doing this from memory but I’m pretty sure the reason is that the query is looking at the product catalog form and timing out. You can try to be more specific in your query or do some tuning on those tables. 

Sent from my iPhone

On Mar 26, 2018, at 2:03 PM, LJ LongWing <lj.longwing@gmail.com> wrote:

Well, for #1, you are issuing a query to the db that's not returning in the 120 second timeout....for #2 you are getting disconnected from the DB....both scenarios are pointing to a DB that is either overwhelmed, or under performing...I would highly recommend working with your DBA to figure out what's happening at the DB level first.

On Mon, Mar 26, 2018 at 11:52 AM, Dinesh Kumar <gurudin@gmail.com> wrote:
Hi All,

We are facing below issue in our environment which causes a higher impact and Business critical.


SRM Fulfillment requests are not getting generated.


The requests are getting struck in the CAI Events form in the Running status for all the events (SRM_OUT_RESTART_SR_SUBMIT, TMS_OUT_GET_DATA).

We could see that PDT’s are also not getting connected to the Service Requests. (adding screenshot).


We are getting time out errors in the plugin and ARERR logs for the certain requests.




2018-02-14 09:12:55,772 ERROR [pool-2-thread-4] com.bmc.itsm.cai.filterapi.cai.worker.BaseEventWorker (BaseEventWorker.java:166) - CAI plugin failed to update error code of event:TMHAA5V0GJ3KKAPEER8HBGHK64BVRP. Failed with following exception. ERROR (94): Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation; ATVIEUUSMS006:2000 ONC/RPC call timed out




Wed Feb 14 09:24:49 2018 390627 : The SQL database operation failed. (ARERR 552)

Wed Feb 14 09:24:49 2018 ORA-03135: connection lost contact

Process ID: 315236

Session ID: 411 Serial number: 60447

Wed Feb 14 09:24:49 2018 lastsql UPDATE T2457 SET C112=';1000000018;',C5='Remedy Application Service',C6=1518531886 WHERE C1 = 'PDT000000005704'

Wed Feb 14 09:24:53 2018 390627 : SQL database is now available (ARNOTE 592)

SRM:ProcessDefinitionTemplate_Base(T2457) is getting locked and we are not able to create any request fulfillment after that.  Then we need to manually release.


Has one faced this kind of issues.


Dinesh kumar.

ARSList mailing list

ARSList mailing list

ARSList mailing list