microsoft / Dynamics-365-FastTrack-Implementation-Assets

Dynamics 365 FastTrack Implementation guides
MIT License
299 stars 193 forks source link

Error In the DataLakeToSQLCopy Pipeline #241

Open OsamaAli95 opened 1 year ago

OsamaAli95 commented 1 year ago

Hello @jiyada

I have been working on implementing the Copy from ADLS into Azure SQL DB Solution as described here https://github.com/microsoft/Dynamics-365-FastTrack-Implementation-Assets/blob/master/Analytics/CDMUtilSolution/readme_datacopy.md

However, the DataLakeToSQLCopy (Dataflow part) keeps failing and outputs the following error: Error DataLakeToSQL_CDMToSQL_Dataflows {"message":"Job failed due to reason: com.microsoft.dataflow.broker.MissingRequiredPropertyException: account is a required property for Source_Datalake_LinkedService1c25c14e035c4852bf29a4c7ea3fe8da.\ncom.microsoft.dataflow.broker.PropertyNotFoundException: Could not extract value from Source_Datalake_LinkedService1c25c14e035c4852bf29a4c7ea3fe8da. Details:","failureType":"UserError","target":"DataLakeToSQL_CDMToSQL_Dataflows","errorCode":"DFExecutorUserError"}

I tried debugging the issue but could not find this property "account".