000030074 - How to resolve "ORA-00911: invalid character" error within collections

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000030074
Applies ToRSA Product Set: Identity Management and Governance
 
IssueWhen running a collection or [Test Collection] the following error may be encountered
Collector test failed:

com.aveksa.server.runtime.ServerException: Test request failed with response: com.aveksa.server.runtime.ServerException: com.aveksa.sdk.collector.CollectionException: com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by java.sql.SQLException: ORA-00911: invalid character Caused By Stack com.aveksa.sdk.collector.CollectionException: com.aveksa.common.DataReadException: 
ResolutionThe ORA-00911 occurs when the collector is defined with a Data Source Type: Database and the SQL used to collect the data includes a trailing semicolon (;) character.   For example a SQL statement of
select user_id, fname, lname, email, supervisor from hr_identities;
will result in the ORA-00911 failure.   To resolve this issue, remove the trailing semicolon and thus
select user_id, fname, lname, email, supervisor from hr_identities

Attachments

    Outcomes