Load CSV to DB not working

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:

Excel Tools

Overview Provides the following custom smart services…

By Appian AppMarket 9 days ago in Appian Community > AppMarket

335 comments

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.

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.