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, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • Comment • 0
  • 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.5.3.1
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

Attachments

    Outcomes