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
'Host name configured is not listed in subject alternative names of certificate' and 'LDAP_CERT_HOSTNAME_MISMATCH_MSG_SHOR… 334Number of Views How to find upgrade files on SecurCare Online (SCOL) for RSA Via Lifecycle & Governance 83Number of Views Collector circuit breaker tripped by rejections in RSA Via Lifecycle and Governance 259Number of Views RSA Via Lifecycle & Governance (L&G) upgrade or installation on WebSphere or WebLogic fails to deploy aveksa.ear file with… 220Number of Views CSV Data Collectors of Data Source Type Database return incorrect result sets when joining multiple CSV files in RSA Ident… 62Number of Views
Trending Articles
Connection fails to Cloud Authentication Service when connecting through a proxy server from RSA Authentication Manager to… Downloading RSA Authentication Manager license files or RSA Software token seed records Unable to login to RSA Authentication Manager Security Console as super admin RSA Authentication Manager 8.9 Release Notes (January 2026) How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device
Don't see what you're looking for?