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.
The headers of the CSV and the column names in the Table are same. It should be the to insert CSV to DB sucessfully. Also, please take care of the column length and primary key/foreign key concept as well while doing insertion from smart service.
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?
Hello,
I also have same requirement. if we have appian cloud or SQL DB then this smart service (Import CSV to Database V6) working properly. but when I did in on-Premises Environment where we are using oracle facing error. Process model completed successfully. But when saw log or error of that node it shows: Error executing SQL.
My question: is this smart service is not compactible to Oracle?
or did I miss anything here?
Thank you in advanced.
Which plugin is that Smart Service from?
I would suggest trying the latest version of this plugin:
Hey Hi,
I used same plugin. still facing same problem.