ADF V2 failed activity

BrianP 21 Reputation points
2020-07-08T12:30:35.77+00:00

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 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,396 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,603 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. BrianP 21 Reputation points
    2020-07-08T14:15:59.153+00:00

    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.

  2. BrianP 21 Reputation points
    2020-07-08T15:02:08.817+00:00

    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.

    0 comments