000032588 - Source file name containing numeric values are not accepted by collectors in RSA Via Lifecycle & Governance

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032588
Applies ToRSA Product Set: RSA Via Lifecycle & Governance (L&G)
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
ResolutionIf you have source file name containing numeric values you must surround the file name with quotation marks as shown below.
select accountname,logindate,accountmail,accountnumber from AveksaData."1010Accounts_Data"

Attachments

    Outcomes