Error executing MSSQLServer stored procedure using tJDBCSP having no output parameters

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


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.


All Replies
Six Stars

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

Can anyone help in this regard?

Regards

Seven 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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download