# Registry service couldn't get Database Time

**URL:** <https://forums.pega.com/t/registry-service-couldnt-get-database-time/1054>\
**Category:** General\
**Tags:** updates, manufacturing, experience-designer, 8-5-1\
**Created:** [January 18, 2021, 2:36pm UTC](https://forums.pega.com/t/registry-service-couldnt-get-database-time/1054 "2021-01-18T14:36:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dharan](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/dharan/32/16827_2.png) [@Dharan](https://forums.pega.com/u/Dharan)\
**Post date:** [January 18, 2021, 2:36pm UTC](https://forums.pega.com/t/registry-service-couldnt-get-database-time/1054/1 "2021-01-18T14:36:12Z")

</div>

| 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&nbsp;  
com.pega.pegarules.pub.PRRuntimeException: PRRuntimeException&nbsp;  
 at com.pega.pegarules.data.internal.sqlapi.exec.NativeSQLListExecutor.execute(NativeSQLListExecutor.java:85) ~[prprivate-data.jar:?]&nbsp;  
 at com.pega.pegarules.data.internal.sqlapi.exec.NativeSQLListExecutor.execute(NativeSQLListExecutor.java:52) ~[prprivate-data.jar:?]&nbsp;  
 at com.pega.pegarules.data.internal.PRDataProviderImpl.executeNativeSQL(PRDataProviderImpl.java:1663) ~[prprivate-data.jar:?]&nbsp;  
 at com.pega.pegarules.data.internal.PRDataProviderForModulesImpl.executeNativeSQL(PRDataProviderForModulesImpl.java:138) ~[prprivate-data.jar:?]&nbsp;  
 at com.pega.platform.serviceregistry.internal.database.persistence.DatabaseTimeProvider.get(DatabaseTimeProvider.java:61) ~[service-registry.jar:?]&nbsp;  
 at com.pega.platform.serviceregistry.internal.database.tasks.Heartbeat.heartbeat(Heartbeat.java:205) ~[service-registry.jar:?]&nbsp;  
 at com.pega.platform.serviceregistry.internal.database.tasks.Heartbeat.lambda$execute$0(Heartbeat.java:136) ~[service-registry.jar:?]&nbsp;  
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0\_222]&nbsp;  
 at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0\_222]&nbsp;  
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0\_222]&nbsp;  
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0\_222]&nbsp;  
 at com.pega.platform.serviceregistry.internal.PrThreadFactory$PrpcThread.run(PrThreadFactory.java:71) ~[service-registry.jar:?]&nbsp;  
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&nbsp;  
&nbsp;  
DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended&nbsp;  
&nbsp;  
 | SQL Code: 933 | SQL State: 42000&nbsp; |  
| - |

---

<div class="post-metadata">

**Author:** ![system](https://cdck-file-uploads-pega1.s3.dualstack.us-west-2.amazonaws.com/pegasbx/original/1X/000334954d35e690a08019a81d1b9bcfa13a435e.png) [@system](https://forums.pega.com/u/system)\
**Post date:** [January 29, 2021, 6:40pm UTC](https://forums.pega.com/t/registry-service-couldnt-get-database-time/1054/2 "2021-01-29T18:40:23Z")

</div>

@Dharanidharan

Hi,

Could you please try to grant the required privileges and try.

> **[Pegasystems Documentation](https://docs.pega.com/bundle/archive/page/archive/topics/archive-directory.htmlknowledgebase/documents/pega-platform-85-upgrade-guide-apache-tomcat-and-oracle)**

> **[Engine fails to initialize after clean upgrade to PEGA 851 (FIXED) | Support...](https://support.pega.com/discussion/engine-fails-initialize-after-clean-upgrade-pega-851-fixed)**
>
> Description After performing an out-of-place upgrade with a single migration, PRPC fails to initialize. The error seen in catalina.out suggests of a missing table but does not specify what is missing. Nothing significant appears in PegaRULES.log at...

Thanks

---

<div class="post-metadata">

**Author:** ![Dharan](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/dharan/32/16827_2.png) [@Dharan](https://forums.pega.com/u/Dharan)\
**Post date:** [September 3, 2021, 7:20am UTC](https://forums.pega.com/t/registry-service-couldnt-get-database-time/1054/3 "2021-09-03T07:20:27Z")

</div>

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.
