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
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.
I think it's probably an issue with thr csv file.
If you want to rule out the DB type, you could try importing the file to another type of DB and see if that works.
Once that is ruled out, I would suggest you progressively try a simple version of the CSV and try adding columns progressively to try to nail down where the issue is in the CSV file.