Question
1
Replies
65
Views
HCL
Posted: January 18, 2021
Last activity: January 29, 2021
Registry service couldn't get Database Time
Need help in resolving the below error, this is happening after upgrading to 8.5. The Application is up and running except for the below issue. 2021-01-18 00:00:02,360 [e-registry-heartbeat] [ STANDARD] [ ] [ ] (rsistence.DatabaseTimeProvider) ERROR - Could not retrieve the database time com.pega.pegarules.pub.PRRuntimeException: PRRuntimeException at com.pega.pegarules.data.internal.sqlapi.exec.NativeSQLListExecutor.execute(NativeSQLListExecutor.java:85) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.sqlapi.exec.NativeSQLListExecutor.execute(NativeSQLListExecutor.java:52) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.PRDataProviderImpl.executeNativeSQL(PRDataProviderImpl.java:1663) ~[prprivate-data.jar:?] at com.pega.pegarules.data.internal.PRDataProviderForModulesImpl.executeNativeSQL(PRDataProviderForModulesImpl.java:138) ~[prprivate-data.jar:?] at com.pega.platform.serviceregistry.internal.database.persistence.DatabaseTimeProvider.get(DatabaseTimeProvider.java:61) ~[service-registry.jar:?] at com.pega.platform.serviceregistry.internal.database.tasks.Heartbeat.heartbeat(Heartbeat.java:205) ~[service-registry.jar:?] at com.pega.platform.serviceregistry.internal.database.tasks.Heartbeat.lambda$execute$0(Heartbeat.java:136) ~[service-registry.jar:?] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_222] at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_222] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_222] at com.pega.platform.serviceregistry.internal.PrThreadFactory$PrpcThread.run(PrThreadFactory.java:71) ~[service-registry.jar:?] Caused by: com.pega.pegarules.data.internal.rd.queryexec.ExecuteQueryException: An error occured on executing the query for the report definition - There was a problem getting a list: code: 933 SQLState: 42000 Message: ORA-00933: SQL command not properly ended DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended | SQL Code: 933 | SQL State: 42000 |
***Edited by Moderator: Pooja Gadige to change category from Product to Upgrade***
@Dharanidharan
Hi,
Could you please try to grant the required privileges and try.
https://community.pega.com/knowledgebase/documents/pega-platform-85-upgrade-guide-apache-tomcat-and-oracle
https://collaborate.pega.com/discussion/engine-fails-initialize-after-clean-upgrade-pega-851-fixed
Thanks