tMSSqlSP_1 - Invalid state, the CallableStatement object is closed

[Anonymous]

 Hi,
I have a tMSSqlSP job setup properly and all 5 records display in tLogRow perfectly.  When I changed the output to tMSSqlOutput, it only inserted 1 record and give me the following errors:
Exception in component tMSSqlSP_1
java.sql.SQLException: Invalid state, the CallableStatement object is closed.
      at net.sourceforge.jtds.jdbc.JtdsCallableStatement.checkOpen(JtdsCallableStatement.java:137)
      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.setString(JtdsPreparedStatement.java:933)
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.tJavaFlex_1Process(bright_append_parcel_040417.java:35458)
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.tLibraryLoad_1Process(bright_append_parcel_040417.java:42513)
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.tMSSqlConnection_2Process(bright_append_parcel_040417.java:42728)
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.runJobInTOS(bright_append_parcel_040417.java:48879)
[FATAL]: bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417 - tMSSqlSP_1 Invalid state, the CallableStatement object is closed.
[statistics] disconnected
      at bright_public_records.bright_append_parcel_040417_0_1.bright_append_parcel_040417.main(bright_append_parcel_040417.java:48646)
Job bright_append_parcel_040417 ended at 16:00 04/04/2017. [exit code=1]

Can someone please explain what are the errors referring to?
Thanks
Andy

                                                                                                 

[Anonymous]

Maybe someone can help me figure out if this is the correct setting in sp?  it's related to my previous post.
                                                                                                                                                     

[vapukov]

You can use walk around way
tFixedFlowInput -> tFlowToIterate -> tMSSQLInput (and exec sp_ as SQL query with parameters from variables)
it will work