Error Executing Stored Procedure in MSSQL with Matillion - Execution Blocked?

Matillion ETL
1

Hello,

 

I am trying to execute a stored procedure in MSSQL using Matillion; but I am facing  an issue where the execution seems to be blocked / fails without clear error messages.

 

I have ensured that the procedure works fine when run directly in SSMS; but through Matillion; it either times out /  hangs indefinitely. I have checked Matillion ETL documentation

msbi documentation guide but still need help.

 

 

Has anyone faced similar issues with executing stored procedures through Matillion? Are there any specific configurations / settings in Matillion that I need to adjust to ensure smooth execution of the stored procedure in MSSQL?

 

 

 

Any advice  would be greatly appreciated!

 

 

Thanks in advance!

 

 

2

Hi @gregbowers23​

Thank you for your post, apologise I did not get to it sooner, I am curious if you were able to get this resolved. Please let me know and if not we can get a ticket raised with our support team to take a closer look into that for you.

Kind regards, Joe