000031650 - Error message "ORA-00911: invalid character" when attempting to run the Database Query Transporter datafeed in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Jul 3, 2019
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000031650
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Database Query Transporter Datafeed
RSA Version/Condition: 5.x, 6.x
Platform: OracleClient Data Provider
IssueThe user receives the error message below when attempting to run the Database Query Transporter Datafeed:
An unexpected error has occurred: ORA-00911: invalid character

User-added image

This occurs even after verifying that all the values in the Transport tab are correct.

 User-added image
CauseThis issue occurs when a semicolon ( ; ) is present at the end of the query statement.
In the example above, the query that was used is shown below.

SELECT foo2 FROM foo;
ResolutionRemoving the semicolon from the end of the query statement fixes the issue, as shown in the example below:
SELECT foo2 FROM foo