pac paportal download | Adxstudio.Xrm is not valid to download

[chris-nguyen-MSFT]

Issue

When using pac CLI to download a website, the following error happens when downloading a given record; this error also happens with the Power Platform toolset for Azure Devops.

Error

Microsoft PowerPlatform CLI
Version: 1.21.8+ga93a2c3

Error: Processing field adx_settings in table adx_entitylist with record id:f8e162f8-213a-ed11-9daf-001dd8023633 FAILED due to Type:Adxstudio.Xrm.Web.UI.CrmEntityListView.GridMetadata DetailsFormModal, Adxstudio.Xrm is not valid to download

Other tools are able to download the file successfully:

• XRMToolbox Portal Records mover
• pac tool cmt (Configuration Migration Tool)

Impact

This is customer facing work using Azure Pipelines and the Power Platform toolset; the process errors out during regular portal metadata deployments/ALM.

Content of adx_settings

adx_settings.txt

[kkanakas]

@chris-nguyen-MSFT can you please try out the latest version of the PAC CLI ?

[chris-nguyen-MSFT]

@chris-nguyen-MSFT can you please try out the latest version of the PAC CLI ?

Same error - have moved thread internally.

PS C:\Users\nguyenchris> pac paportal download --path $folder -id $websiteId -o true

Microsoft PowerPlatform CLI

Version: 1.21.13+g348c5e9

Error: Processing field adx_settings in table adx_entitylist with record id:f8e162f8-213a-ed11-9daf-001dd8023633 FAILED due to Type:Adxstudio.Xrm.Web.UI.CrmEntityListView.GridMetadata DetailsFormModal, Adxstudio.Xrm is not valid to download

[MrRishabhJain]

Hey @chris-nguyen-MSFT, thanks for reaching out, we are looking into the issue. As the 'adx_settings' field holds configurations for the list component, seems like something might have been set incorrectly/differently that PAC download is not able to parse. Can you please share the WebAPI response for the record having the issue, need to check the response we get for the 'adx_settings' field in the given scenario.

API - [Your Organization Uri]/api/data/v9.0/adx_entitylists(f8e162f8-213a-ed11-9daf-001dd8023633)

Example API - https://org7e035972.crm10.dynamics.com/api/data/v9.0/adx_entitylists(3755fdd2-0e84-44ef-b823-00ee8d58644a)

For more details you can refer - https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api

Note: If the response contains some sensitive information, I'd request you to work with the Support team and create a support incident to discuss further on this.

[chris-nguyen-MSFT]

Hi @MrRishabhJain , the adx_settings is attached to the original issue; it's been added here for easy access (it was formatted in VS for readability)

Funny enough after inspecting the record, I see there are a few tab escape characters (\t) in the adx_settings column; I have no idea how they were introduced though.

adx_settings.txt

[MrRishabhJain]

Hi @chris-nguyen-MSFT, can you please share how you were able to obtain the contents of the "site_settings" field as this seems to be generated by PAC while being downloaded, but the issue is with PAC download itself.

If this was obtained by a previous PAC download, this may contain some stale value, hence recommended method would be to use the Web API as described in my previous comment.

[chris-nguyen-MSFT]

I exported the records via excel using advanced find. I'll extract using the webapi and send in a follow-up e-mail.

…

________________________________ From: Rishabh Jain ***@***.***> Sent: Tuesday, April 18, 2023 6:36 AM To: microsoft/powerplatform-vscode ***@***.***> Cc: Chris Nguyen ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/powerplatform-vscode] pac paportal download | Adxstudio.Xrm is not valid to download (Issue #493) Hi @chris-nguyen-MSFT<https://github.com/chris-nguyen-MSFT>, can you please share how you were able to obtain the contents of the "site_settings" field as this seems to be generated by PAC while being downloaded, but the issue is with PAC download itself. If this was obtained by a previous PAC download, this may contain some stale value, hence recommended method would be to use the Web API as described in my previous comment. — Reply to this email directly, view it on GitHub<#493 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AWKHOIUPVAYJKTOW3DJBY7LXBZVDFANCNFSM6AAAAAAWPGJN6E>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[chris-nguyen-MSFT]

hi @MrRishabhJain , the webapi extract is below attached to this comment

adx_entitylists(f8e162f8-213a-ed11-9daf-001dd8023633).json.txt