Question

5
Replies
115
Views
Anthony Gourtay (Anthony_Gourtay)
Altran

Altran
BE
Anthony_Gourtay Member since 2017 14 posts
Altran
Posted: February 10, 2021
Last activity: May 7, 2021
Posted: 10 Feb 2021 7:27 EST
Last activity: 7 May 2021 1:39 EDT

PEGA 8.5.2 & ORA-00933

Hello,

on Webphere 9, Oracle 11, I've upgraded platform from 8.2.1 to 8.5.2.(typical in-place)

All is started as expected after adding the specific grant - GRANT SELECT ON SYS.V_$PARAMETER to yourDBUser; - https://collaborate.pega.com/discussion/engine-fails-initialize-after-clean-upgrade-pega-851-fixed

Agents are disabled. For testing purpose, I've set up node 1: Search,WebUser,BackgroundProcessing   node 2: WebUser, Stream On each node running in standalone or in cluster, the same exception is recurrently raised: DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended (same was occurring with a single Universal node) First occurrence is during the startup itself

[2/10/21 12:55:20:198 CET] 00000098 SystemOut     O 2021-02-10 12:55:20,197 [ervice-registry-task] [  STANDARD] [                    ] [                    ] (l.access.RuleCandidateIterator) INFO    - Single candidate rule resolution optimization is enabled [2/10/21 12:55:20:595 CET] 00000098 SystemOut     O 2021-02-10 12:55:20,571 [ervice-registry-task] [  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.FailedServiceCleaner.execute(FailedServiceCleaner.java:62) ~[service-registry.jar:?]         at com.pega.platform.serviceregistry.internal.database.tasks.TaskExecutor.execute(TaskExecutor.java:74) ~[service-registry.jar:?]         at com.pega.platform.serviceregistry.internal.database.tasks.TaskExecutor$$Lambda$165/00000000A40B5C10.run(Unknown Source) ~[?:?]         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522) ~[?:1.8.0]         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:319) ~[?:1.8.0]         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:191) ~[?:1.8.0]         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) ~[?:1.8.0]         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160) ~[?:1.8.0]         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:1.8.0]         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

-- few more similar lines then start continues  ---- [2/10/21 12:55:35:888 CET] 00000098 SystemOut     O 2021-02-10 12:55:35,888 [         was60603.bc] [  STANDARD] [                    ] [                    ] (al.access.InstanceExistsFilter) INFO    - Added 165600 entries to the instance exists filter in 25.384000 seconds with a false positive rate of 0.001  

Second similar exception during startup [2/10/21 12:59:18:955 CET] 00000098 SystemOut     O 2021-02-10 12:59:18,955 [         was60603.bc] [  STANDARD] [                    ] [                    ] (   external.async.IStartupTask) INFO    - Initializing service registry... [2/10/21 12:59:18:989 CET] 00000098 SystemOut     O 2021-02-10 12:59:18,976 [         was60603.bc] [  STANDARD] [                    ] [                    ] (rsistence.DatabaseTimeProvider) ERROR   - Could not retrieve the database time com.pega.pegarules.pub.PRRuntimeException: PRRuntimeException  

...................

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  

..........................

[2/10/21 12:59:19:143 CET] 00000098 SystemOut     O 2021-02-10 12:59:19,142 [         was60603.bc] [  STANDARD] [                    ] [                    ] (   external.async.IStartupTask) INFO    - Service registry initialized successfully  

etc...

 

Typical logs then application is up. Then above similar error keeps being printed in logs.

I don't see what could be the reason for this (DB is fine, all grants & synonyms are fine). Issue with database table pr_sys_serviceregistry was already fixed This post is around the same following post but not providing solution: Error Getting Current Database time | Collaboration Center (pega.com))  Any clue?

Thank you

Regards

Anthony

 

Pega Platform 8.5.2 System Administration Upgrades System Administrator