topic execute stored procedure in Talend - nothing happens in Talend Studio

execute stored procedure in Talend - nothing happens

pawe84 — Fri, 29 Jul 2022 12:08:10 GMT

Hi everyone,

I try to execute a stored procedure which is on a MSSQL Database and called Products_GetList.

The sp by itself will create a product table with 30 columns.

But if I start the job, nothing happens, seems that sp hasn't been executed it.

Do I have to create a schema? I don't understand what's the issue in talend, see my example jon below.

Thanks for any advice.

Re: execute stored procedure in Talend - nothing happens

Anonymous — Mon, 01 Aug 2022 04:14:09 GMT

Hello,

To test it, try to deactivate tprejob and tpost job and please use tDBSP component only with correct MSSQL DB connection parameter to see if it works?

Best regards

Sabrina

Re: execute stored procedure in Talend - nothing happens

Anonymous — Mon, 01 Aug 2022 04:15:44 GMT

Hello,

In addition, if you don't mind, could you please open the error log generated automatically by the Studio to see whether you have error stack trace there; if you do, we will appreciate it a lot if you can paste it here.

About how to open this error log: in your Studio, click Window to open the menu, then select Show View->General->Error Log. Once you see an error, double click it.

Best regards

Sabrina