Hi , I keep on gettng this error while using PUTSQL processor: ************************ Batch entry 0 INSERT was aborted: ERROR: syntax error at end of input Position: 7 Call getNextException to see other errors in the batch.. There were a total of 1 FlowFiles that failed, 0 that succeeded, and 0 that were not execute and will be routed to retry; : java.sql.BatchUpdateException: Batch entry 0 INSERT was aborted: ERROR: syntax error at end of input Position: 7 Call getNextException to see other errors in the batch. java.sql.BatchUpdateException: Batch entry 0 INSERT was aborted: ERROR: syntax error at end of input Position: 7 Call getNextException to see other errors in the batch. ***************************** I used ReplaceText processor prior to this, and the output file content of that processor is : ******************************* INSERT INTO vzcheckin_visits (visit_data) VALUES ('{ "visits": [ { "buildingCode": "AZ0014", "buildingName": "6955 W Morelos Pl, Chandler, AZ 85226, USA", "entrance": "Front Desk", "createdDate": "2019-05-08 16:56:40.0", "cancelled": false }, { "buildingCode": "AZ0014", "buildingName": "6955 W Morelos Pl, Chandler, AZ 85226, USA", "cancelled": false }] } ') ****************************** The above query runs perfect in command line manually except for the ";" taht i have to give at the end. can you please assist me to solve this error. @Matt Burgess
... View more
