Hi All,
I am trying to Load CSV to DB, there are no errors in the instance. Have ensured correct mapping of table name, but CSV is not getting reflected in the DB.
Let me know if anyone has faced similar issues.
Discussion posts and replies are publicly visible
Did you try to check the stdout logs for more errors? Sometimes, the instances does not shows any error and looks like the service executed successfully but if you cannot see the changes, then please look for logs.
You can find it at <your community URl>/suite/shared-logs/<your community sub domain>/tomcat-stdOut.log
or
Go to System logs and search for tomcat-stdOut
Thanks for replying Harshit, checked this and it says, "Error at or near Data". Not able to move forward from there
There must be something in the data that the service cannot process. Can you copy-paste the last snapshot of the logs?
This is the snippet from the log.
Can you attach a screenshot of the CSV file and the table also please? As the other commenter mentioned, you need to ensure that the column count is same. Also, if you are using a new schema (other than Appian) in your DB then this service might not work. For that, we have a different service.
Harshit, we have business DB to which we are trying to push data from CSV. As mentioned above could you share the service which would help you to achieve this objective?