Source file name containing numeric values are not accepted by collectors in RSA Via Lifecycle & Governance
Originally Published: 2016-02-19
Article Number
Applies To
RSA Product/Service Type: Collectors
RSA Version/Condition: 7.0.0
Issue
The user has a source file stored in a path (for example: 1010Accounts_Data.csv in path /home/oracle/database/SampleData/AveksaData) and does not specify the entire file path in the following URL in the Collector Database Connection page:
jdbc:csv:///////home/oracle/database/SampleData?_CSV_Header=true;_CSV_Quoter="
If only the parent file path is given and the numeric file name is given in the accounts query with the Parent file (as shown in the example below), the following error message will be displayed:
select accountname,logindate,accountmail,accountnumber from AveksaData.1010Accounts_Data java.sql.SQLException: Syntax error: Can't continue parse.
This issue is not seen if file name does not contain numeric values, such as in the example below.
select accountname,logindate,accountmail,accountnumber from AveksaData.t_sample_ACCOUNTSDATA
Resolution
select accountname,logindate,accountmail,accountnumber from AveksaData."1010Accounts_Data"
Related Articles
Smart Card Logon certificate not accepted 42Number of Views Hyphen or minus character not accepted in hostname 14Number of Views Replica RADIUS not accepting authentication requests in RSA Authentication Manager 8.0 and 8.1 291Number of Views "A PIN is required for this token" error on RSA Authentication Manager 8.x when requesting an RSA SecurID software token f… 34Number of Views How to configure an RSA Authentication Manager 8.1 server to accept a system-generated PIN when a token is in new PIN mode… 294Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Governance & Lifecycle 8.0.0 Installation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA MFA Agent for UNIX Platform Support Matrix
Don't see what you're looking for?