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
Running upgradeJDK.sh issues "ACM is not supported on this version of linux" in RSA VIA Lifecycle & Governance 63Number of Views Updating RSA Via Lifecycle & Governance Appliance Firmware (Dell R620 or R720) 236Number of Views 'Host name configured is not listed in subject alternative names of certificate' and 'LDAP_CERT_HOSTNAME_MISMATCH_MSG_SHOR… 346Number of Views LDAP Collectors report 'No subject alternative names matching IP address n.n.n.n found' in RSA Identity Governance & Lifec… 727Number of Views Change Verification task running after Account Data Collection (ADC) taking many hours to be completed in RSA Via Lifecycl… 174Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA Authentication Manager Patch Updates RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to Download OTP Token Seed Files from myRSA
Don't see what you're looking for?