Question
HCLTech
HCLTech
US
HCLTech
Posted: Jan 18, 2021
Last activity: Aug 7, 2023
Last activity: 7 Aug 2023 10:34 EDT
Closed
Solved
Registry service couldn't get Database Time
Need help in resolving the below error, this is happening after upgrading to 8.5. |
Show More
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 |
Show Less
***Edited by Moderator: Pooja Gadige to change category from Product to Upgrade***
To see attachments, please log in.