Invalid state, the PreparedStatement object is closed.

[Anonymous]

Hi,

I am facing an issue with the below flow - 

tMap --> tJavaFlex-->tMSSQLOutput_1

   |

tMSSQLOutput_2

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 ?

[vboppudi]

Hi,

tMSSQLOutput_1 and tMSSQLOutput_2 using same DB object or different DB objects?

Regards,

[Anonymous]

Hello,

We will appreciate it a lot if you can upload your current job design screenshots on forum.

Best regards

Sabrina

[Anonymous]

Hi vbopuddi,

I have tried both the case - Same and different connection. What I have found - the problem is with tJavaFlex. If I remove the tJavaFlex, its executing fine.

As everytime I am getting two flows out of one through tJavaFlex. So for now to resolve the issue I have removed tJavaFlex and created one more flow out of tMap.

But in case if there are multiple flows, there must be a permanent solution.

Best Regards,
Abhishek

[Anonymous]

Hi xdishi,
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
                                               |
                                    tMSSQLOutput_2

Best Regards,
Abhishek

[vboppudi]

Hi,

What are you doing in tJavaFlex component? 

Regards,