Skip to main content
gautams4173
gautams4173
April 11, 2023
Question

Import CSV to Database

  • April 11, 2023
  • 4 replies
  • 0 views

I am trying to use the import csv to database v6 node in the process model. Now while executing the model, there is an error saying "error executing sql". Now im not able to decode what is the error because I tried importing into the database directly from phpmyadim using the same parameters , it works ther, but does not work here. Can anyone tell me what I am possibly missing ? 

    4 replies

    S
    sanchitg0002
    April 11, 2023

    Please check tomcat-stdOut.log log file for smart service to get detailed error message.

    There must be some configuration issues you are running into, please check if all required inputs are configured properly.

    gautams4173
    gautams4173Author
    April 11, 2023

    Hmm makes sense .. but can you tell me how do we check the Tomcat logs in Appian, I'm new to it

    S
    sanchitg0002
    April 11, 2023

    Go to System logs and find the log named tomcat-stdOut.log

    Trigger the process model again and in the log file search with the smart service name and check the latest entry.

      Terms & ConditionsAccessibility statement