Six Stars

Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

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.

image.pngimage.pngimage.pngimage.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

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.

4 REPLIES
Six Stars

Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

Can anyone help in this regard?

Regards

Six Stars

Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

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,

Six Stars

Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

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.

Moderator

Re: Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.