Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Pfisterbi
Advocate I
Advocate I

SQL Statement "OUTPUT" is not supported.

Hi
In our DWH (an ASQL DB), we use a SP at the start of the ADF Pipeline to write some metadata about the Pipeline into an Audit log (table in DB).  The following code is an excerpt of the code: 

 

insert into logging.adf_run_log (master_pl_run_id, parent_pl_run_id, pl_run_id, execution_object, source_object, layer, status, start_time)
		OUTPUT inserted.pl_run_id
		select ISNULL(@master_pl_run_id,cast('00000000-0000-0000-0000-000000000000' as uniqueidentifier))
		     , ISNULL(@parent_pl_run_id,cast('00000000-0000-0000-0000-000000000000' as uniqueidentifier))
		     , ISNULL(@pl_run_id,NEWID())
			 ,  @execution_object, @source_object, @layer, 'RUNNING', getdate()

 

While the code works smoothly in the ASQL DB, we get an error message in Fabric. 
"OUTPUT is not supported.
Msg 15868, level 16, state 11, code line 35
Each SQL statement is executed as an independent session. The session context is not maintained across SQL statements."

The provided link for the infos about the error does not work: https://go.microsoft.com/fwlink/?linkid=2230216.

Is this a bug?

If not, how can we write logging / audit infos about the Pipeline into a Fabric DWH?
We need to know, when a Pipeline runs starts, ends and the number of rows written, read etc. 
Thank you.

1 REPLY 1
HimanshuS-msft
Community Support
Community Support

Hello  @Pfisterbi
I am assuming that the code which you shared is from the SP . I will suggest you to please comment the below line and try again . 

insert into logging.adf_run_log (master_pl_run_id, parent_pl_run_id, pl_run_id, execution_object, source_object, layer, status, start_time)

-- OUTPUT inserted.pl_run_id

select ISNULL(@master_pl_run_id,cast('00000000-0000-0000-0000-000000000000' as uniqueidentifier)) , ISNULL(@parent_pl_run_id,cast('00000000-0000-0000-0000-000000000000' as uniqueidentifier)) , ISNULL(@pl_run_id,NEWID()) , @execution_object, @source_object, @layer, 'RUNNING', getdate()


Please do let us know how it goes .

 

Thanks 
Himanshu 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.