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
Error "PIN change failed dictionary check" and authentication fails for a user in new PIN mode in RSA Authentication Manag… 94Number of Views RSA Authentication Manager 8.3 P4 - Summary of Known Third-Party Component Vulnerabilities Under Investigation 39Number of Views RSA Authentication Manager 8.x - Fixed Passcode is failing with Authentication method failed passcode format error 1.14KNumber of Views RSA RSA SecurID - Force all tokens to be in New PIN mode without clearing PIN 310Number of Views Enable RADIUS debug/verbose logs with all versions of RSA Authentication Manager 8.x 1.92KNumber of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?