question

brianpierschbacher avatar image
0 Votes"
brianpierschbacher asked ·

ADF V2 failed activity

On June17th when an stored procedure activity failed, anything that was written to output (aka Print) in the stored procedure was included in the error in ADF. Since July 1st this no longer is included in the output. Is there a way we can get this information from ADF on failed activities?


June 17th Example:
Operation on target plSPExec_POLICY_DIM_2 failed: Operation on target usp_Load_DimFuneralHome failed: Execution fail against sql server. Sql error number: 264. Error Message: The column name 'City' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code.
usp_Load_DimFuneralHome load #policy temp
usp_Load_DimFuneralHome load #prelaFH temp
usp_Load_DimFuneralHome load #pnalkFH1 temp
usp_Load_DimFuneralHome load #pnalkFH temp
usp_Load_DimFuneralHome load #paddr temp
usp_Load_DimFuneralHome load #pname temp
usp_Load_DimFuneralHome load #pagnt temp

azure-data-factoryazure-synapse-analytics
· 1
10 |1000 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.

What type of error details do you get now after 1-July? Has something changed in SP - like adding try, catch block which is not giving exact error in output? t is working fine for me. A procedure failed yesterday and I could see the error message : Invalid column name: ColumnABC.

0 Votes 0 ·
brianpierschbacher avatar image
0 Votes"
brianpierschbacher answered ·

Nothing changed in the stored procedure, the developer used PRINT statements before and after each called stored procedure. Before July 1st they showed up in output on failed as I showed in inital post. Today the do not. What version ADF and what region are you running? We are V2 in West Central US.

· 1 ·
10 |1000 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.

I have ADFv2 in East US.

Maybe the SP is failing even before printing the statements. Try running/failing the SP in SSMS and see if it is printing statements there.

0 Votes 0 ·
brianpierschbacher avatar image
0 Votes"
brianpierschbacher answered ·

It's not failing before printing. The first thing it does is print, and some of the sub procedures were executed. I executed the rest of the stored procedure manually and printing worked.

·
10 |1000 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.