question

TangiralaDineshReddy-1882 avatar image
0 Votes"
TangiralaDineshReddy-1882 asked ShaikMaheer-MSFT commented

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

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
procedure3.jpeg (220.7 KiB)
procedurecode1.jpeg (133.1 KiB)
procedurecode2.jpeg (93.5 KiB)
image.png (954.7 KiB)
image.png (437.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @TangiralaDineshReddy-1882 ,

Following up to see if below answer helps you? If yes please consider accepting it as answer. Please let us know if any further queries.

0 Votes 0 ·

Hi @TangiralaDineshReddy-1882 ,

Just checking in to see if the below answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

GangaPrasanthExternal-1578 avatar image
0 Votes"
GangaPrasanthExternal-1578 answered

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




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.