If you are getting an error that looks like this in the Connection Agent log file:
2009-02-02 12:17:37 - v1.09.03 - IP:127.0.0.1 - /ExecuteCsvInsert - login1
INFO: SQL query [jdbc:jstels:csv:/C:/Casino/]: INSERT INTO "db") VALUES ()
2009-02-02 12:17:37 - v1.09.03 - IP:127.0.0.1 - /ExecuteCsvInsert - login1
ERROR: CSVException:[StelsCSV Driver] Can't parse SQL query: [SQL Engine API] Incorrect syntax near the word 'db' (position: 17). See realized SQL specification in the driver documentation
jstels.jdbc.csv.c.executeUpdate(c.java)
jstels.jdbc.csv.c.executeUpdate(c.java)
com.perfectforms.agent.services.csv.ExecuteCsvInsert.doPost(ExecuteCsvInsert.java:694)
SYMPTOM: The error indicates that the SQL syntax is incorrect and this is because changes have been made in the action editor, but the 'connect' or 'connect and search' object properties in the properties dialog have not been updated.
SOLUTION: To correct this problem, you will need to update the properties for the 'connect' or 'connect and search' objects so that they match withthe latest action changes made and try again.
