topic Re: Problem to execute a stored procedure with sybase on Talend Integratio in Talend Studio

Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Wed, 17 Dec 2014 14:33:48 GMT

Hi,
We have a problem to execute a stored procedure with sybase on Talend Integration Suite Professionnal Edition 4.2.4.
We want to execute a Sybase stored procedure with a date in entry to update several tables values. We use in our job a tsybase connection, tsybaserow to "set chained off" and trowgenerator to generate the current date (TalendDate.formatDate("MM/dd/yyyy",TalendDate.getCurrentDate()) with the object tSybaseSP to launch the stored procedure (with our current date as IN parameter).
Finally we have a tsybasecommit to save the changes.
The procedure is running (during 10 minutes) but the tables are not updated.
When we launch the stored procedure with RapidSQL, the tables are updated.
The problem comes about Talend. Is there specials parameters to add or something wrong in our job ?

The parameter requiered in entry of our procedure is :
"Parameters in entry: - @adt_end (MM/DD/YYYY) : End Date treatment"

Best regards

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 18 Dec 2014 07:41:30 GMT

Hi,
Could you please upload your job design screenshot into forum? How did you define basic setting in tSybaseSP?
Best regards
Sabrina

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 18 Dec 2014 12:02:17 GMT

Hi,
A screenshot of my job design.

The name of parameter in entry is "Date" but its format is String.
I create the row with the rowgenerator :

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 18 Dec 2014 12:17:07 GMT

Screen-Shot.pdf

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 18 Dec 2014 12:31:20 GMT

Hi,
These are common problems when you use date parameters... I think there is an issue with the date format... date is format generated by the talend is not accepted by the database... you can connect a tlogrow next to db output component or connect a reject link and you should get the reason for rejection of records... and this is due to incorrect date format.
Thanks
vaibhav

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 18 Dec 2014 13:34:12 GMT

Hi,
Like I told in a precedent post, I don't think the problem is a date parameter or format because I have no error message from Talend or Sybase and with a log row the date format is correct? When the date format is different (DD/MM/YYYY for example) I have an error message and the treatment stops.

And as you can see on the screenshot, the treatment time is 10 minutes. When we launch the procedure directly onRapid SQL, the tretment time is the same but the tables are updated.
I think there is a problem with the object because we have no error message and the tables are not updated with the same parameters

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 18 Dec 2014 13:52:06 GMT

Can you remove that onComponentOk and connect with onSubjobOk from tfixedflow? and check again.
vaibhav

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 18 Dec 2014 14:19:35 GMT

I connected with the onSubjobOK :

but the tables are not updated.
Did I a mistake ?
Thanks

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 18 Dec 2014 15:43:43 GMT

Remove onComponentOk from tsybasesp_1 and connect with onSubjobOk from tfixedflow to tsybaserow_1? and check again.
remove onComponentOk from tsybaserow_2 and connect with onSubjobOk to commit component

Vaibhav

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 18 Dec 2014 16:26:15 GMT

It doesn't work, the tables are not updated.

Best regards,
Perrin GRANDNE.

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Mon, 05 Jan 2015 17:52:13 GMT

Anyone has already encountered this problem and could help us, we don't find a solution or an alternative which works

Thanks.

Re: Problem to execute a stored procedure with sybase on Talend Integratio

Anonymous — Thu, 13 Oct 2016 12:07:51 GMT

Hello,
I got the same issue where the SP updates tables. Solve it.
tSybaseConnection_1 --> tFixedFlowInput --> tSybaseSP -> tSybaseCommit
check Auto Commit on Advanced settings of tSybaseConnection
uncheck "Close Connection" of tSybaseCommit
Hope it helps
Lalaina