Sent from my iPhone 6 😃
> On 26 Mar 2018, at 19:28, Tauf Chowdhury <taufc...@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.longw...@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 <guru...@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. >>> >>> 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 >>> ARSList@arslist.org >>> https://mailman.rrr.se/cgi/listinfo/arslist >>> >> >> -- >> ARSList mailing list >> ARSList@arslist.org >> https://mailman.rrr.se/cgi/listinfo/arslist > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
