Datawarehouse export to GIT issue

[Vojtech]

Hello,

I have encountered an issue with one of my warehouses. When I click on the "Source Control" button, I receive the following message after a while:

Cluster URI https://wabi-europe-north-b-redirect.analysis.windows.net/

Activity ID 40496327-ddb7-41b1-8e38-2b1154717302

Request ID 21c097f6-c506-acc9-5a89-fed3c7a38b30

Workload Error Code InternalError

Workload Error Message An object with name 'cc091cd564fc900c6706aaccd256fc89' already exists in the collection.

ArtifactObjectId a2c0f950-166a-48ed-b044-260ea5efd092

GitErrorDetails {"artifactType":"Datawarehouse","artifactDisplayName":"dwh_sk_hr","artifactLogicalId":"0d7f367c-c904-47f8-8ecf-9d8d2075918a","rootActivityId":"21c097f6-c506-acc9-5a89-fed3c7a38b30","httpStatus":0,"errorType":"Exception","errorCode":null,"errorSource":1,"targetCommit":null,"artifacts":null,"errorDetails":{"ErrorCode":"InternalError","ErrorMessage":"An object with name 'cc091cd564fc900c6706aaccd256fc89' already exists in the collection.","ErrorParameters":null,"ErrorCategory":"Microsoft.ServicePlatform.Exceptions.DataContracts.ExceptionData","IsTransient":false,"AdditionalParameters":[{"Name":"ExceptionType","Value":"Microsoft.ServicePlatform.Exceptions.DataContracts.ExceptionData"},{"Name":"ArtifactObjectId","Value":"a2c0f950-166a-48ed-b044-260ea5efd092@7b131192-3e04-4ad6-8ed7-eab2fc49137d$2024-11-19T10:40:40.5498126Z@d81b08d4-8a02-4804-adf7-70dc99a4b72d"}],"ErrorSource":0,"UserInteractionRequest":null},"gitProviderErrorResponse":null,"culprit":0}

Time Tue Nov 19 2024 11:40:55 GMT+0100 (Central European Standard Time)

Additionally, when I attempt to export the Database Project, I encounter the following error:

Something went wrong

Archive is undefined

Thank you in advance for your assistance.

Best regards,
Vojtěch

[abuislam]

This seems like a tricky issue. The error message about the object already existing in the collection suggests there might be a conflict with an artifact in your Git repository. You could try:

1. Checking the repository for an artifact with the same name or ID ('cc091cd564fc900c6706aaccd256fc89') and resolving any duplicates.
2. Cleaning up any partially exported projects and retrying the export.
3. Ensuring your configurations for Source Control are up to date and consistent across environments.

The 'Archive is undefined' error could point to an incomplete process—maybe clearing your cache or trying a different workspace could help.

When troubleshooting complex issues like this, I find it helpful to pause and reflect. Personally, when I read Surah Yaseen, it gives me a sense of clarity and helps me tackle challenges with a fresh perspective.

Hope this helps! Let us know how it goes.

[Anonymous]

Hi @Vojtech,

>>An object with name 'cc091cd564fc900c6706aaccd256fc89' already exists in the collection

As the message mentions, it seems like the issue due to specific object already exists in your collections. Have you check if the previous operation already create same objects?

Regards,

Xiaoxin Sheng

[Vojtech]

I certainly do not have an user object named "cc091cd564fc900c6706aaccd256fc89" in the Data Warehouse. I believe this might be some kind of "internal" object. Do you have any suggestions on how I can check its existence?

Thank you!

[Anonymous]

Hi @Vojtech,

Perhaps you can try to use semantic functions to list all the artifacts, it will show the table with corresponding object id.

Semantic functions - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng

[Vojtech]

Hello,

Unfortunately, cc091cd564fc900c6706aaccd256fc89 is not in the list.

Thank you!

[R1k91]

Do you have something called "Archive" in your Warehouse?

I experienced similar issues having "aux" as schema in the Warehouse. It's a reserved keyword in windows therefore the DACPAC can't create "aux" folder on the client machine.

[Vojtech]

Hello,

Thank you for the tip, but unfortunately, there is no object named Archive in my Warehouse.