Issue with Upload CSV to Database Node

Iain, what version are you on? Also, do you have any more clues? For example: more details from the Alert or the logs? Have there been any changes made recently that may have affected your environment?

Hi Alex, we are running Appian 7.1. This nide was working earlier today and then stopped- there were no changes to the environment.
The specific error from the log is as follows:

10:43:55,430 INFO [stdout] (default-threads - 8) 2013-05-02 10:43:55,426 [default-threads - 8] ERROR com.appiancorp.process.runtime.activities.DBImportFromCSVActivity - java.lang.reflect.UndeclaredThrowableException
10:43:55,430 INFO [stdout] (default-threads - 8) java.lang.reflect.UndeclaredThrowableException

There was no further info from the alert itself.
Thanks for your help

Are you able to find in the stack trace which line number in DBImportFromCSVActivity is throwing the exception?

Iain, are you using the same CSV file that was working earlier? Reference the information provided by the author of the plugin to ensure that the component can handle the file you are trying to upload.

Hi Owen, the next few lines from the logs are as follows:

10:43:55,430 INFO [stdout] (default-threads - 8)           at com.sun.proxy.$Proxy331.lookup(Unknown Source)
10:43:55,430 INFO [stdout] (default-threads - 8)           at com.appiancorp.process.runtime.activities.DBImportExportUtil.getConnection(DBImportExportUtil.java:33)
10:43:55,430 INFO [stdout] (default-threads - 8)           at com.appiancorp.process.runtime.activities.DBImportFromCSVActivity.run(DBImportFromCSVActivity.java:56)
10:43:55,430 INFO [stdout] (default-threads - 8)           at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:101)
10:43:55,430 INFO [stdout] (default-threads - 8)           at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:98)
10:43:55,430 INFO [stdout] (default-threads - 8)           at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:25)
10:43:55,430 INFO [stdout] (default-threads - 8)           at com.appiancorp.process.runtime.framework.DefaultActivityExecutor.execute(DefaultActivityExecutor.java:98)

Afraid that there is nothing more in the alert than what was in my first post.

Alex, yes- exactly the same csv file, with no changes made either side of the node working. The inputs to the node are all fully defined, if that's what you mean?

Thanks again.

Can you double check that the datasource being used on the node is a valid datasource. It should match to one of the datasources in the dropdown of the Query RDBMS node or when creating a datastore.

The data source is being referenced using a constant calling "java:/jdbc/database". Even when I put this in directly I get the error message (this is the correct and just the same as the options in the query node dropdown..)

It seems that it's having trouble looking up the datasource. Do you get similar errors when you export to CSV from RDBMS?

No- there are no issues exporting to CSV from RDBMS..

i am trying to import csv file to db.. its throwing error tat invalid identifiers for last column..any one pls help