Skip to main content
Participating Frequently
Apr 17, 2024 12:20 PM UTC
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

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

5 replies

karumurua531442
Participating Frequently
Apr 17, 2024 1:50 PM UTC

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

Participating Frequently
Apr 18, 2024 4:33 AM UTC

We are importing the data into Maria DB.

shubhama926776
Brainy
Apr 17, 2024 5:43 PM UTC

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.

शुभम्
Participating Frequently
Apr 18, 2024 4:36 AM UTC

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
Brainy
Apr 18, 2024 4:52 AM UTC

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]

शुभम्