topic Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}} in Pipelines

Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

GuillaumeBer — Fri, 09 Jun 2023 03:21:23 GMT

I created my first Fabric Data Factory pipeline (from data copy wizard) and when I tried to save and run it, I got the following error message :

Request failed with 500(Internal Server Error): {"error":{"code":"UnknownError","pbi.error":{"code":"UnknownError"}}}, requestid: 79d3e74a-a71f-bf73-d32c-345e4b6a0695"

see ID#2306050050002903

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

SamWilliams — Mon, 05 Jun 2023 14:25:30 GMT

I'm getting a similar error when publishing a dataflow gen2:

---------- Message ----------

Unhandled HTTP Request Exception. Status Code: 500. Reason: undefined. Response Text: {"error":{"code":999999,"message":"Something went wrong, please try again later. If the error persists, please contact support.","details":null}}.

---------- Stack ----------

ApiResponseError: Unhandled HTTP Request Exception. Status Code: 500. Reason: undefined. Response Text: {"error":{"code":999999,"message":"Something went wrong, please try again later. If the error persists, please contact support.","details":null}}.

at Bt.handleLoadEvent (https://us.prod.powerquery.microsoft.com/DataflowsApp/scripts/app.a596db03743bdca27024.bundle.js:2:96923)

at XMLHttpRequest.<anonymous> (https://us.prod.powerquery.microsoft.com/DataflowsApp/scripts/app.a596db03743bdca27024.bundle.js:2:97966)

---------- Session ID ----------

da688575-994f-4418-8bd8-d3fb04446690

Was working Friday, so I expect there is a service issue.

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

GraceGu — Wed, 07 Jun 2023 05:26:23 GMT

GuillaumeBer Is this error consistent? or transient?

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

GuillaumeBer — Wed, 07 Jun 2023 10:46:37 GMT

Hi GraceGu , yes it's consistent, here is a new tentative I just made for you now

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

Jotheesh — Thu, 08 Jun 2023 03:57:26 GMT

I am seeing similar issue and it's consistent

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

GraceGu — Thu, 08 Jun 2023 06:21:24 GMT

I can repro this.

It is likely caused by: inside copy activity, generated parameterization does not work.

Work-around: Remove the paraterization, manually set this table action, then save.

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

GuillaumeBer — Thu, 08 Jun 2023 08:32:29 GMT

Hi GraceGu , I'm not sure to understand your workaround proposal.

1/ as you can see below I did validate the Pipeline and it's all good.
2/ if I remove the parameterization of the target table in this pipeline it will not work (multiple source tables are copied)

So if you tell me that it's indeed a bug and that has been referenced with Bug_ID#xyz (+I can track/subscribe to this bug status) then that's perfectly fine for me to wait for a fix (since Fabric is still in Public Preview.) Thanks for your confirmation

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

GraceGu — Thu, 08 Jun 2023 09:04:28 GMT

Yes, it is a bug - Table action parameterization causes the error. Bug is tracked internally.

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

ajarora — Fri, 09 Jun 2023 21:44:26 GMT

The above mentioned bug on pipelines will not impact dataflows, please start a separate thread for it.

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

MichBDO — Thu, 15 Jun 2023 14:21:29 GMT

I also get this error although I have the Table action on 'Append'. My source is a single XLSX file in a file folder in the lakehouse and the destination is a table in the lakehouse. What could be the cause of this?

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

GraceGu — Fri, 16 Jun 2023 06:10:34 GMT

The issue tracked is for parameterization of Table action or Partition Option. Can you open a separate thread?

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

GuillaumeBer — Fri, 16 Jun 2023 11:12:21 GMT

Hi GraceGu , I couldn't find the issue_Id about parameterization of table action on https://support.fabric.microsoft.com/en-us/known-issues ?

Re: Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

GraceGu — Tue, 20 Jun 2023 23:54:05 GMT

Fix is in rollout. Tentive ETA to be available for all regions is mid Jul.