Refresh Population Errors with following error in collaborator logs ORA-00920: invalid relational operator (Doc ID 2018880.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Deduction and Settlement Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

The Run Refresh Population workflow is not completing and import process jobs gets the following errors

Description : Process ID: 850726
Schema ID: 2167
Schema name: 'DGI Refresh Population'
Step ID: 'Step2'
Step name: 'Run Refresh Pop'

Error description 'Program internal error:'

The collaborator logs show

 2015-06-01 08:31:25,384 PDT [WFProcess_9] ERROR appserver.error: com.demantra.applicationServer.appServerExceptions.ApplicationServerException: ODPM-10192: Refresh Population Process Encountered 1 Errors. Refresh Population Process Encountered 1 Errors. Id 1010468, 'Copy (1) of Shelf strips and Mngmnt Fee [1010468]' : java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator at com.demantra.applicationServer.services.refreshPopulation.PopulationRefresher.refresh(PopulationRefresher.java:264) at com.demantra.workflow.step.RefreshPopulationStep.doExecute(RefreshPopulationStep.java:278) at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:938) at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:1281) at com.demantra.workflow.process.WFProcess.run(WFProcess.java:662) at java.lang.Thread.run(Thread.java:744) 2015-06-01 08:31:25,385 PDT [WFProcess_9] FATAL workflow.general: ODPM-10192: Refresh Population Process Encountered 1 Errors. Refresh Population Process Encountered 1 Errors. Id 1010468, 'Copy (1) of Shelf strips and Mngmnt Fee [1010468]' : java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator com.demantra.applicationServer.appServerExceptions.ApplicationServerException: ODPM-10192: Refresh Population Process Encountered 1 Errors. Refresh Population Process Encountered 1 Errors. Id 1010468, 'Copy (1) of Shelf strips and Mngmnt Fee [1010468]' : java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator at com.demantra.applicationServer.services.refreshPopulation.PopulationRefresher.refresh(PopulationRefresher.java:264) at com.demantra.workflow.step.RefreshPopulationStep.doExecute(RefreshPopulationStep.java:278) at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:938) at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:1281) at com.demantra.workflow.process.WFProcess.run(WFProcess.java:662) at java.lang.Thread.run(Thread.java:744) 2015-06-01 08:31:25,386 PDT [WFProcess_9] ERROR dpweb.general: #################################### Step Failure. #################################### 2015-06-01 08:31:25,386 PDT [WFProcess_9] ERROR dpweb.general: Process ID: 851481 Schema ID: 2167 Schema name: 'DGI Refresh Population' Step ID: 'Step2' Step name: 'Run Refresh Pop' Error description 'Program internal error:' 2015-06-01 08:31:25,386 PDT [WFProcess_9] ERROR dpweb.general:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms