| 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 |
| - |
@Dharanidharan
Hi,
Could you please try to grant the required privileges and try.
Thanks
The issue is because of oracle older version, Oracle 11.2 is not fully compatible with Pega 8.5+ (few DB queries generated by Pega 8.5 is not executable by Oracle 11.2). Upgrade Oracle to 12 or later to fix this issue.