topic Re: Datawarehouse export to GIT issue in Data Warehouse

Datawarehouse export to GIT issue

Vojtech — Tue, 19 Nov 2024 10:45:05 GMT

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

Re: Datawarehouse export to GIT issue

R1k91 — Tue, 19 Nov 2024 17:04:26 GMT

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.

Re: Datawarehouse export to GIT issue

Vojtech — Tue, 19 Nov 2024 20:23:29 GMT

Hello,

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

Re: Datawarehouse export to GIT issue

Anonymous — Wed, 20 Nov 2024 01:57:10 GMT

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

Re: Datawarehouse export to GIT issue

Vojtech — Wed, 20 Nov 2024 09:27:03 GMT

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!

Re: Datawarehouse export to GIT issue

Anonymous — Wed, 04 Dec 2024 05:32:02 GMT

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

Re: Datawarehouse export to GIT issue

Vojtech — Wed, 04 Dec 2024 14:21:21 GMT

Hello,

Unfortunately, cc091cd564fc900c6706aaccd256fc89 is not in the list.

Thank you!

Re: Datawarehouse export to GIT issue

abuislam — Sat, 14 Dec 2024 05:10:02 GMT

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:

Checking the repository for an artifact with the same name or ID ('cc091cd564fc900c6706aaccd256fc89') and resolving any duplicates.
Cleaning up any partially exported projects and retrying the export.
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.