Skip to main content
N
nandanp
July 22, 2022
Question

Load CSV to DB not working

  • July 22, 2022
  • 11 replies
  • 0 views

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.

11 replies

harshitb6843
harshitb6843
July 22, 2022

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

N
nandanpAuthor
July 22, 2022

Thanks for replying Harshit, checked this and it says, "Error at or near Data". Not able to move forward from there

harshitb6843
harshitb6843
July 22, 2022

There must be something in the data that the service cannot process. 
Can you copy-paste the last snapshot of the logs?

D
deepakg681722
July 26, 2022

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.

ashwinia3199
ashwinia3199
Participating Frequently
July 4, 2023

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.

mathieud0001
mathieud0001
Brainy
July 4, 2023

Which plugin is that Smart Service from?

I would suggest trying the latest version of this plugin:

[View:https://community.appian.com/b/appmarket/posts/excel-tools]

ashwinia3199
ashwinia3199
Participating Frequently
July 5, 2023

Hey Hi,

I used same plugin. still facing same problem.

Terms & ConditionsAccessibility statement