Question
PT Bank Sinarmas
ID
Last activity: 20 Sep 2017 0:34 EDT
Help Identifying and Fixing error from Log
Hi,
One of my colleague has created a post about server requirement because sometimes our Pega server runs slow, sometimes it runs fast, and sometimes it crashes.
here's the link to the post.
And after looking deeper we found that there's a lot of errors on the log and this might be the cause for the server to run sometimes fast, sometimes slow, and sometimes it crashes.
Here's attached a screenshot of the log that says the App Error is PegaRULES.
Can anyone help me identify what caused the error and how to fix it?
Any insight is appreciated.
Thanks,
--Michael
***Moderator Edit: Vidyaranjan | Updated Categories***
Pegasystems Inc.
IN
Hello
The log screenshot depicts that there are some issues with your batch requestor and agent. However, the information is very less and it is not sufficient to conclude that why your system is slow .
I suggest you to share the complete log ( pega rules and alert ) and share the date and time when you observed the issue. That can only help to understand the possible reason.
PT Bank Sinarmas
ID
Hi Santanu,
Thank you for the reply, here are the pega rules and alert you asked, as for the date and time, it's 12 Sept 2017 around 8:10.
Just remove the (.txt). Can't upload it here without that.
--Michael.
Pegasystems Inc.
US
Hi Michael,
After looking into your shared log file i can see that your whole log file is almost filled with the below error:
From: (B60C160AF5473E2D157E6940678D8330E)
SQL: {call PEGA.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }
SQL Inserts: <PEGA.CRM_SYS_QUEUES> <System-Queue-SFA-AccessMgmt> <PegaCRM-SFA:GenerateAccessForOperator> <Scheduled> <9c7887f58b100c44de24ed43992f4bde> <> <20170911T173511.375 GMT> <true> <> <(OUTPUT PARAMETER)>
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 942: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ORA-06512: at "PEGA.SPPR_SYS_RESERVEQUEUEITEM_B", line 151
ORA-06512: at line 1
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6283)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6676)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6632)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6613)
Looking like your stored procedure PEGA.SPPR_SYS_RESERVEQUEUEITEM_B is having an issue.
Regards
Mahesh
Hi Michael,
After looking into your shared log file i can see that your whole log file is almost filled with the below error:
From: (B60C160AF5473E2D157E6940678D8330E)
SQL: {call PEGA.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }
SQL Inserts: <PEGA.CRM_SYS_QUEUES> <System-Queue-SFA-AccessMgmt> <PegaCRM-SFA:GenerateAccessForOperator> <Scheduled> <9c7887f58b100c44de24ed43992f4bde> <> <20170911T173511.375 GMT> <true> <> <(OUTPUT PARAMETER)>
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 942: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ORA-06512: at "PEGA.SPPR_SYS_RESERVEQUEUEITEM_B", line 151
ORA-06512: at line 1
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6283)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6676)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6632)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6613)
Looking like your stored procedure PEGA.SPPR_SYS_RESERVEQUEUEITEM_B is having an issue.
Regards
Mahesh
JPMorgan Chase & Company
US
Hi Michael,
From the pega rules log file I can see frequently the ORA-06512: at "PEGA.SPPR_SYS_RESERVEQUEUEITEM_B", which means that configured database user is not able to find SPPR_SYS_RESERVEQUEUEITEM_B item, please check permissions.
JPMorgan Chase & Company
US
I can also see pega alerts log we have PEGA0004, PEGA0005, PEGA0001 and PEGA0017 which are causing the slowness of the application. Please resolve these alerts by following the below pdn article.
https://docs-previous.pega.com/performance/alerts-alert-analysis-tools-and-usage-guidelines
PT Bank Sinarmas
ID
Hi SudhakarReddy,
Where can I find this SPPR_SYS_RESERVEQUEUEITEM_B?
is it in pega oracle DB?
can you tell me in detail where to look?
Cuz I can't find it.
Also regarding the Alerts, I have found the Activities that were mentioned in the alerts.
Correct me if I'm wrong, but I'm looking at the activities mentioned on Last Step.
But I don't see how to fix it since they're activities like pxcallobjopen, pxretrievereportdata, dofuassembly, etc.
and when I see the step mentioned on Last Step which is Page-Remove which is also the last step of the activity.
Now I'm confused and I don't think I get it right.
Thanks in advance.
--Michael.