Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tMSSQLOutput issue

I have a very simple job that is attempting to load a csv file into a SQL Server table.  There is a tFilterow component between the tfileInputDelimited and the tMSSQLOutput components.  When executing the job, I receive the following error:

xception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the PreparedStatement object is closed.
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.checkOpen(JtdsPreparedStatement.java:406)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.getParameter(JtdsPreparedStatement.java:558)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(JtdsPreparedStatement.java:630)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setInt(JtdsPreparedStatement.java:808)
at voyager.sqlservertest_0_1.SQLServerTest.tFileInputDelimited_1Process(SQLServerTest.java:3396)
at voyager.sqlservertest_0_1.SQLServerTest.tMSSqlConnection_1Process(SQLServerTest.java:2184)
at voyager.sqlservertest_0_1.SQLServerTest.runJobInTOS(SQLServerTest.java:7052)
at voyager.sqlservertest_0_1.SQLServerTest.main(SQLServerTest.java:6592)

 

The connection object for SQL Server appears fine and I am able to insert rows into this table via command line.  Thank you!

 

 

Labels (5)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I figured this one out.  Had a tMSSQLCommit that was closing the connection

View solution in original post

1 Reply
Anonymous
Not applicable
Author

I figured this one out.  Had a tMSSQLCommit that was closing the connection