GRC Upgrade Form 8.6.3.6032 to 8.6.4.3347 Failed With Invalid Number Of Argument Issue (Doc ID 2131826.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Application Access Controls Governor - Version 8.6.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade from 8.6.3.6032 to 8.6.4.3347 the following error occurs.

ERROR
-----------------------
 Error starting job
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT ALL_ISSUE_CONTROL_V.ID, ALL_ISSUE_CONTROL_V.NAME, ALL_ISSUE_CONTROL_V.ISSUE_VERSION, ALL_ISSUE_CONTROL_V.VERSION, ALL_ISSUE_CONTROL_V.COMMENTS, ALL_ISSUE_CONTROL_V.CREATED_BY, ALL_ISSUE_CONTROL_V.CREATED_DATE, ALL_ISSUE_CONTROL_V.UPDATED_BY_NAME, ALL_ISSUE_CONTROL_V.UPDATED_BY, ALL_ISSUE_CONTROL_V.UPDATED_DATE, ALL_ISSUE_CONTROL_V.CLOSED_BY, ALL_ISSUE_CONTROL_V.CLOSED_DATE, ALL_ISSUE_CONTROL_V.GRCC_CONTROL_ID, ALL_ISSUE_CONTROL_V.DIMENSION_VALUE_IDS, ALL_ISSUE_CONTROL_V.PERSPECTIVE_ITEM_IDS, ALL_ISSUE_CONTROL_V.PARTICIPANT_IDS, ALL_ISSUE_CONTROL_V.priority, ALL_ISSUE_CONTROL_V.type, ALL_ISSUE_CONTROL_V.ASSIGNED_TO, ALL_ISSUE_CONTROL_V.LAST_RUN_DATE, ALL_ISSUE_CONTROL_V.STATUS, ALL_ISSUE_CONTROL_V.DATASOURCE_IDS, ALL_ISSUE_CONTROL_V.LOCALE_KEY, ALL_ISSUE_CONTROL_V.ISS_PARTICIPANT_IDS, ALL_ISSUE_CONTROL_V.ENFORCEMENT_TYPE, ALL_ISSUE_CONTROL_V.EFFECTIVE_SEQUENCE, ALL_ISSUE_CONTROL_V.STATE_CODE, ALL_ISSUE_CONTROL_V.REVISION_DATE, ALL_ISSUE_CONTROL_V.INVESTIGATORS, ALL_ISSUE_CONTROL_V.INV_USER_IDS, ALL_ISSUE_CONTROL_V.REVIEWERS, ALL_ISSUE_CONTROL_V.APPROVERS FROM ALL_ISSUE_CONTROL_V WHERE ALL_ISSUE_CONTROL_V.type = 173 AND LOWER(ALL_ISSUE_CONTROL_V.ID) LIKE LOWER('MEBERT', 'LYANG', 'SCARROLL', 'TSTAGG') AND ALL_ISSUE_CONTROL_V.LOCALE_KEY = 'en_US' AND ALL_ISSUE_CONTROL_V.ASSIGNED_TO LIKE '%:BBOOTH:%']; nested exception is java.sql.SQLSyntaxErrorException: ORA-00909: invalid number of arguments


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Upgrade GRC from 8.6.3.6032 to 8.6.4.3347

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue,cannot continue with the upgrade.

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