Skip to main content
R
robh0004
November 18, 2022
Question

Import CSV to Database v5 for Connected System

  • November 18, 2022
  • 1 reply
  • 0 views

Hi,

I am connected to a database via Connected System in Appian and not JDBC. When trying to use the Import CSV to Database v5 node in my process model, I am getting the error: 

java.lang.reflect.UndeclaredThrowableException

I am wondering if you are able to use this node when connecting to a database this way? I have gotten this node to successfully work with a JDBC connection just not when my data source is a Connected System. I am wondering if I am just using the wrong syntax for the data source parameter on the node. I am using the exact name of the datasource I can see when connecting the datastore so basically just the Connected system object name.

Hopefully someone can help me on this?

Thanks in advance

    1 reply

    jakubf0002
    jakubf0002
    November 23, 2022

    We faced many issues with importing data to database and it turned out that we have to change encoding to UTF-8. Try different encoding possibilities and maybe this will help

    Terms & ConditionsAccessibility statement