I’m getting an ‘incorrect syntax’ error in the connection agent log file.

Home Forum Integrating PerfectForms I’m getting an ‘incorrect syntax’ error in the connection agent log file.

This topic contains 0 replies, has 0 voices, and was last updated by  ehuezo 9 years, 9 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #110

    ehuezo
    Keymaster

    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.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.