Skip to main content
April 17, 2024
Question

I am using import csv to database, where I need to pass the datasource name, but we have connected system datasource and when I am passing connected system datasource name it is giving me an error "Error: java.lang.reflect.UndeclaredThrowableExc

  • April 17, 2024
  • 5 replies
  • 0 views

import csv to database smart service from Excel tool is creating an issue with connected system data source

5 replies

karumurua531442
April 17, 2024

hi [mention:3d10757f18f24f3aa4c4b6297a86834f:e9ed411860ed4f2ba0265705b8793d05] what is the database you are using to import data, is it mariadb or postgres SQL 

April 18, 2024

We are importing the data into Maria DB.

shubhama926776
April 17, 2024

Hello [mention:3d10757f18f24f3aa4c4b6297a86834f:e9ed411860ed4f2ba0265705b8793d05] 
There's a high chance that, Import csv to database smart service likely expects a traditional database connection, which connected systems might not provide.

April 18, 2024

Thank for Shubham,


Yes, I did try with several options but it is still giving me the same error with the connected system database, after that I tried to import the data into another schema in Maria DB using the traditional datasource like 'jdbc/Appian' and it works but in case of connected system it is giving me the same error 

shubhama926776
April 18, 2024

Looks like Import CSV to Database smart service might not work with connected system data sources.
Plugin documentation doesn't have enough info. Still you can go through it.
[View:/cfs-file/__key/communityserver-discussions-components-files/19/Excel-Tool-Documentaion.pdf:320:240]