search

microsoft / powerplatform-vscode

The Power Platform VSCode extension makes it easy to manage Power Platform environments and allows the developer to create, build and deploy Power Platform solutions, packages and portals.
MIT License
206 stars 37 forks source link

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

Open chris-nguyen-MSFT opened 1 year ago

chris-nguyen-MSFT commented 1 year ago

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:

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 commented 1 year ago

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

chris-nguyen-MSFT commented 1 year ago

@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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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-MSFThttps://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 GitHubhttps://github.com/microsoft/powerplatform-vscode/issues/493#issuecomment-1512846140, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWKHOIUPVAYJKTOW3DJBY7LXBZVDFANCNFSM6AAAAAAWPGJN6E. You are receiving this because you were mentioned.Message ID: @.***>

chris-nguyen-MSFT commented 1 year ago

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

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