I am facing an issue with the below flow -
tMap --> tJavaFlex-->tMSSQLOutput_1
through tJavaFlex I could have multiple rows for one row. When I am executing the job. It is throwing the below error.
Exception in component tMSSqlOutput_2
java.sql.SQLException: Invalid state, the PreparedStatement object is closed.
Does anyone faced that issue or have a solution for that ?
tMSSQLOutput_1 and tMSSQLOutput_2 using same DB object or different DB objects?
We will appreciate it a lot if you can upload your current job design screenshots on forum.
Sorry, due to some security issues, I can not share the complete document. But the flow is like below-
tfilterRow -> tJavaRow -> tMap -> tJavaFlex->tMSSQLOutput_1