custom expresion having stored procedures inside loop is failing in runbook of azure synapse

Tangirala DineshReddy 21 Reputation points
2021-10-16T14:59:51.31+00:00

141028-procedure3.jpeg141071-procedurecode1.jpeg140957-procedurecode2.jpeg

Hi sir,

  1. I have a runbook & in that runbook, the execution process is
    a. I am executing 4 pipelines in azure synapse b. after that I am executing custom expression having for loop(in that loop, same procedure is executing with
    different parameters 4 times). procedure name is insert. please find the below screenshot(table name and procedure names are blurred in blue color).

141081-image.png 

c. again another pipelines are executing.
  1. the problem is runbook is failing in b step and the below error information is coming to my mail.

140980-image.png

note

  1. please find the attachment of procedure code in order of procedure1, procedure2, procedure3
  2. procedure is executing successfully in azure synapse sql with in 45 seconds without no issue but custom expression having these procedures are failing in runbook and showing exception.

Could you please suggest to fix this issue as early as possible.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,405 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ganga, Prasanth (External) 1 Reputation point
    2021-10-18T13:29:35.487+00:00

    Hi Siva,

    Please add @(Invoke-Sqlcmd -Querytimeout 300 -Query

    by default azure synapse SQL within 30 seconds only consider so, query execution increase command is Querytimeout 300

    0 comments