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 <[email protected]> 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 <[email protected]> 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. >> >> Error-1: >> >> 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 >> >> Error-2: >> >> 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. >> >> Thanks, >> Dinesh kumar. >> >> -- >> ARSList mailing list >> [email protected] >> https://mailman.rrr.se/cgi/listinfo/arslist >> > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
