microsoft / Dynamics-365-FastTrack-Implementation-Assets

Dynamics 365 FastTrack Implementation guides
MIT License
312 stars 196 forks source link

Error: Content of directory on path 'XXX/XX/DATAAREA/*.csv' cannot be listed #231

Open jjordan495 opened 1 year ago

jjordan495 commented 1 year ago

I am executing the CDMUtilConsoleApp manually (For the first time).

Receiving numerous errors during the initial execution while executing with the root subscription owner account.
Content of directory on path 'Tables/Custom/DATAAREA/*.csv' cannot be listed

The owner account also has storage blob contributor role on the storage account. I can manually navigate to the above path inside the storage account and see the CSV files and I can also navigate inside Synapse and select the CSV with a SQL command to see data output/rows.

Can you provide further guidance on how to resolve the initial execution of this console app?

haqmdzeeshan commented 1 year ago

I am executing the CDMUtilConsoleApp manually (For the first time).

Receiving numerous errors during the initial execution while executing with the root subscription owner account. Content of directory on path 'Tables/Custom/DATAAREA/*.csv' cannot be listed

The owner account also has storage blob contributor role on the storage account. I can manually navigate to the above path inside the storage account and see the CSV files and I can also navigate inside Synapse and select the CSV with a SQL command to see data output/rows.

Can you provide further guidance on how to resolve the initial execution of this console app?

Did you get the solution of this problem?

jjordan495 commented 1 year ago

We ended up changing the config file (where connection strings) to use the SQL Account instead of an Azure AD account. The SQL account had all the necessary permissions to to create the views. Doesn't seem to make sense, but it works.

haqmdzeeshan commented 1 year ago

Thank you for your reply. It worked for me as well after granting synapse workspace blob data contributor access to storage account.