CSV lookup plugin no longer working, Message=Failed to start database

Products

• Data Loss Prevention Enforce

Issue/Introduction

CSV query not longer working, Message=Failed to start database.

You may see following error in localhost file:

13 Nov 2012 12:39:53,433- Thread: 40 INFO [com.vontu.lookup.csv.DerbyConnector] creating database jdbc:derby:CSV_LOOKUP_DATABASE; create=true using derby jdbc dbName: "jdbc:derby:CSV_LOOKUP_DATABASE; create=true"
13 Nov 2012 12:39:58,081- Thread: 40 SEVERE [com.vontu.lookup.csv.DerbyConnector] Message=Failed to start database 'CSV_LOOKUP_DATABASE', see the next exception for details. SQLState=XJ040 SQLError=40000
13 Nov 2012 12:39:58,083- Thread: 40 INFO [com.vontu.lookup.csv.DerbyConnector] creating database jdbc:derby:CSV_LOOKUP_DATABASE_1; create=true using derby jdbc dbName: "jdbc:derby:CSV_LOOKUP_DATABASE_1; create=true"

Resolution

CSV looks have the following requirements: 

• The CSV Lookup Plug-In requires a CSV file that is stored on the Enforce Server.
• The first data row of the CSV file must contain column headers.
• Column header fields cannot be blank.- Make sure that there are no white spaces at the end of the column header fields.
• Make sure that all rows have the same number of columns.- Each row of the file must be on a single, non-breaking line.
• You specify in the attribute mapping which column heads are to be used as keyfields. You also specify the key field search order. Common key fields typically include email address, Domain\UserName (for Endpoint incidents), and username (for Storage incidents).
• The data values in the key field columns must be unique. If multiple columns are used as key fields (for example, EMP_EMAIL and USER_NAME), the combination of values in each row must be unique.
• Fields in data rows (other than the column header row) can be empty, but at least one key field in each row should contain data.
• The same type of delimiter must be used for all values in the column header and data rows.
• If the CSV file is read-only, make sure that the CSV file has a new line at the end of the file. The system will attempt to add a new line to the file on execution of the plug-in, but if the file is read-only the system cannot do this and the plug-in will not load.
• If more than 10% of the rows in the CSV file violate any of these requirements, the Plugin does not load.
• For accuracy in the lookup, the CSV file needs to be kept up to date