Uploaded image for project: 'OpenICF'
  1. OpenICF
  2. OPENICF-933

ORA-00933: SQL command not properly ended

    Details

      Description

      Customer is hitting an issue with IDM 6.0 using DatabaseTableConnector 1.4.0.0 against an Oracle 11R2. When they click on the data tab of the connector view in the Admin UI, they get this exception:
      ```
      Caused by: org.identityconnectors.framework.common.exceptions.ConnectorException: Can not read from the table or view 'user_account'.
      at org.identityconnectors.databasetable.DatabaseTableConnector.executeQuery(DatabaseTableConnector.java:604)
      at org.identityconnectors.databasetable.DatabaseTableConnector.executeQuery(DatabaseTableConnector.java:129)
      ```
      I’ve tracked this down to the commit for OPENICF-776 which introduced paging in the connector. However, 11R2 does not support this type of OFFSET paging, only 12c does. This fact is mentioned in OPENICF-776. However, since we say that we support 11R2 in the release notes, the connector should be able to handle this for 11R2. 

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gael Gael Allioux
                Reporter:
                mark.offutt Mark Offutt [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: