Stored Procedure not completing successfully

[Brodie]

I have a simple task setup to connect to a SQL database, run a stored procedure, then disconnect.


The stored procedure i am calling works successfully from within SQL Enterprise Manager, but fails within AA. I am using version 5.5.

I have tested this with other store procedures on the same database, and they work fine. The only difference i can see between the stored procedures is that the one which is failing takes about 6-10 minutes to run via SQL Enterprise Manager, vs. the other stored procedures which take seconds to run.

I have put time out options into the connection parameter and on the stored procedure task line, but this doesn't seem to make a difference.

No parameters are passed in the stored procedure, and the stored procedure name is sprdwloadcompany so does not have any of the known issues like commas or over 100 char that i can find in the forums.

Any ideas for tracking this down? As AA is only telling me to look at line 2 called Stored Procedure - not v. helpful.

Thanks for your help.

[forumsupport]

Hello,

Did you try putting time (600 sec) in 'Timeout for the procedure' field of Database:Run Stored Procedure' command?

Hope that helps.

[Brodie]

Hi,
Yes i have put the maximum time out period i could into the optional timeout box in the stored procedure command, and have also tested passing a timeout value as part of the Connection string also.

Any other ideas?

[forumsupport]

Hello,

This is strange as we have not experienced such issue before.

Is it possible for you to upload your stored procedure or upload the text format of procedure so we can look into it and try to reproduce the scenario at our end?

It would help us investigate further.