Question

1
Replies
97
Views
Close popover
Dharanidharan Murugesan (Dharanidharan)
HCL
Senior System Architect
HCL
IN
Dharanidharan Member since 2014 1 post
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***
Pega Platform 8.5.1 System Administration Upgrades Manufacturing Front-End Developer Upgrade