Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

[mra802003]

Hi,

tFixedFlowInput -> tJDBCSP ->tJava.

Stored procedure performs simple update on a table based on matching condition. It has three input parameters and no output parameter.

I have attached the details of the components.

I am getting the following error while executing the above scenario involving stored procedure.

Exception in component tJDBCSP_3
java.lang.NullPointerException
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.tFixedFlowInput_3Process(MMXFeed_Solution.java:858)
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.runJobInTOS(MMXFeed_Solution.java:1780)
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.main(MMXFeed_Solution.java:1570)
[statistics] disconnected

Any help in this regard is much appreciated.

Regards

[mra802003]

Can anyone help in this regard?

Regards

[wangbinlxx]

Click Code

=> Open with notepad++ (or whatever editor you prefer)

=> Check what are code in line 858/1570/1780 .

"

at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.tFixedFlowInput_3Process(MMXFeed_Solution.java:858)
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.runJobInTOS(MMXFeed_Solution.java:1780)
at fl_project.mmxfeed_solution_0_1.MMXFeed_Solution.main(MMXFeed_Solution.java:1570)

"

This could help, or you can post those lines here.

Cheers,

[mra802003 · Accepted solution]

Thanks. I was able to figure the issue. I was using tDie component in my design which was throwing this error. After removing that component, I was able to execute this successfully.

[Anonymous]

Hello,

Thanks for posting your solution here. We have accepted your solution, which allows others to see what has worked.

Best regards

Sabrina