Error Message

<< Job Status log >>
[#80000] Common Services Error : Discovery of all the subSources failed

<< -remotejob@46016.log >>
Discovery failed
PersistenceException: 80026 JDBC executeQuery failed for 'load data local infile 'D:/CW/V95/data/esadb/dataStore_case_xxxxxxxxxx/filelist/0.18.455.1/xxxxxxxxxx/files/3/1.csv' IGNORE into table t_dirmetadata...

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: The used command is not allowed with this MySQL version

This is a known bug in MySQL Connector jar 5.1.49.
Default value of the connection property allowLoadLocalInfile has been changed to false.

The solution is to modify the setting used for the MySQL Connection ("esa.common.db.jdbc.url") in default properties and changes_esa properties files:

1. Make a backup of each file:
D:\CW\Vxx\config\configs.default.properties
D:\CW\Vxx\scratch\esa\changes_esa.properties

2. Modify both files with the following values:

Old Value:  (single line)
esa.common.db.jdbc.url = jdbc:mysql://{0}:{1}/{2}?useServerPrepStmts=true&useCursorFetch=true&useGmtMillisForDatetimes=true

New Value: (single line)
esa.common.db.jdbc.url = jdbc:mysql://{0}:{1}/{2}?useServerPrepStmts=true&useCursorFetch=true&useGmtMillisForDatetimes=true&allowLoadLocalInfile=true

Note: If the line is missing in either file, add the line and save both files.

3. Save both files

4. Run the Option #7 in the Clearwell Utilities

5. Open the esa.properties file and verify the new value now exists
D:\CW\Vxx\scratch\esa\esa.properties

6. Run the discovery of the data.