Question
Nordea
SE
Last activity: 13 Nov 2018 7:51 EST
Unable to Restart Pega
Hi,
I was working on setting up an environment which is exact replica of our existing BAT environment. I copied whole DB schema and then configured pega from websphere by providing database details and deploying prpc_j2ee14_ws.ear file. After that when I restart app server, I am unable to get pega login screen. Attached is the pega log which can be referred. I could see some error related to application but I am not sure if they are at all responsible for server restart.
Accepted Solution
Nordea
SE
The problem was due to multiple datasource setup in Websphere. After removing the one which was not required, issue was resolved.
Pegasystems Inc.
PL
Hi,
Could you check your db connection ? In logs I can observe:
2018-11-12 09:10:50,941 [ lx64741.sbcore.net] [ STANDARD] [ ] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 3 for database "pegadata" to the pool as it previously encountered the following error
(...)
Hi,
Could you check your db connection ? In logs I can observe:
2018-11-12 09:10:50,941 [ lx64741.sbcore.net] [ STANDARD] [ ] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 3 for database "pegadata" to the pool as it previously encountered the following error
(...)
2018-11-12 09:10:50,943 [ lx64741.sbcore.net] [ STANDARD] [ ] (rnal.license.LicenseDaemonImpl) ERROR - problem while running the procedure in License Daemon:com.pega.pegarules.pub.database.DatabaseException: Database-General Problem encountered executing a stored procedure 6550 65000 ORA-06550: line 1, column 22:
PLS-00905: object CRM40_APP_DATA.SPPR_AGGREGATE_USAGE is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
DatabaseException caused by prior exception: java.sql.SQLException: ORA-06550: line 1, column 22:
PLS-00905: object CRM40_APP_DATA.SPPR_AGGREGATE_USAGE is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
| SQL Code: 6550 | SQL State: 65000
From: (B76D6C0ECC3EAB7DC9FACDC0607C7714F:(License Daemon))
SQL: {call CRM40_APP_DATA.sppr_aggregate_usage ()}
SQL Inserts:
Caused by SQL Problems.
Problem #1, SQLState 65000, Error code 6550: java.sql.SQLException: ORA-06550: line 1, column 22:
PLS-00905: object CRM40_APP_DATA.SPPR_AGGREGATE_USAGE is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Thanks,
Piotr
Nordea
SE
Thanks Piotr! I have resolved above issues but I am still unable to restart it. Attached the latest log. I could see some error related to Pega Marketing Database Schema but not sure if that's the root cause.