Finance | Project Operations, Human Resources, ...

Data field on data source 'xx' with ID 'xx' is invalid.

(1) Share

Report

Posted on by DO-08051210-0

Hello Community,

In order to customize the standard Production Working status report (WHSWork)

I extended the query WHSWork as follows

We did a deployment on the prod environment
and it displays this error

Fault was thrown by the service for request ..

Exception details: Type: Microsoft.Dynamics.AX.Framework.Services.Metadata.Exceptions.MetadataItemException`1[[Microsoft.Dynamics.AX.Framework.Services.Metadata.Contracts.QueryDataSourceMetadata

, Microsoft.Dynamics.AX.Framework.Services.Platform.Contracts, Version=7.0.0.0, Culture=neutral, PublicKeyToken=null]]

Message: Data field on data source 'ProdTable' with ID '60001' is invalid.

This field turns out to be a custom field added to ProdTable via UI by Personalize this form on Prod environment

We bypass this error temporarily we deleted this field and applied changes

Does anyone know the cause of this error?

Categories:

Microsoft Dynamics AX

All responses (4)

Answers (0)

DO-08051210-0 22 on at

Like (0)

Report

Data field on data source 'xx' with ID 'xx' is invalid.

The action is I click on the Production Working Status button ,the dialog opens then I click on OK

I think the trigger of the issue is that we added the custom field on the ProdTable

On the VM, we imported a backup of the prod env after adding that field , built and synchronized and redeployed the report
I think that fixed the issue on the VM
André Arnaud de Cal... 291,462 Super User 2024 Season 2 on at

Like (1)

Report

Data field on data source 'xx' with ID 'xx' is invalid.

Hi,

Was the custom field also configured on the DEV environment? At what exact moment did you get the error? When running the customized report or at another action?

In case you add the field after you temporarily deleted it in production, do you then still have the same issue?
Suggested answer

DO-08051210-0 22 on at

Like (1)

Report

Data field on data source 'xx' with ID 'xx' is invalid.

Yes Its works Fine on Dev environment

Did you check the code that you deployed to production? Yes I checked the Code
Does it contain all the custom elements? Yes is done
Did you try to clear usage data? Yes we tried with different users

How you do this? "We bypass this error temporarily we deleted this field and applied changes "

Create and work with custom fields - Finance & Operations | Dynamics 365 | Microsoft Learn

Deleting custom fields:
When you decide that a custom field is no longer needed, a system administrator can choose to delete the field from the Custom fields page. To delete a custom field, select the field to delete, click Delete, click Yes to confirm the deletion, and finally click Apply changes.
Suggested answer

Waed Ayyad 6,543 Super User 2024 Season 2 on at

Like (1)

Report

Data field on data source 'xx' with ID 'xx' is invalid.

Hi,

Does the report with the new customizations work correctly in Sandbox and Dev environment? Did you check the code that you deployed to production? Does it contain all the custom elements? Did you try to clear usage data?

How you do this? "We bypass this error temporarily we deleted this field and applied changes "

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue