Finance | Project Operations, Human Resources, ...

Extra node is getting added while restore data source in free text invoice report

(0) Share

Report

Posted on by Brajesh singh

Hi,

I have added few fields in temp table(FreeTextInvoiceHeaderFooterTmp) which is used as data source in the free text invoice report.

When i am clicking on restore on Data source(FreeTextInvoiceHeaderFooterDS) extra node "SuppressDepreciationOfPaymentSection1" getting created and it not allowing me to deploy the report.

Please suggest how can solve this issue.

Thanks in Advance.

Regards

Brajesh singh

I have the same question (0)

All responses (10)

Answers (0)

Bharath45 15 on at

Like (1)

Report
Copy link

Link copied!

Hi Girish,

Thanks for your response.

Yes, this error is due to newly added parameters which are automatically added by themselves when are doing the restore on the dataset.

I found a workaround by deleting the parameter from the report but we don't have the option to delete it directly from Dataset parameters.

So I edited the report in an XML editor in VS and manually deleted the new parameter and saved the report. Then I am to deploy the report without any issues.

Thanks

BK

Was this reply helpful? Yes No
Suggested answer

GirishS 27,829 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Bharath,

Try to create new report design and copy paste all the textboxes, Tablix etc. from existing design to the new design - Now delete the old design - deploy the report and try again.

This error may be due to the newly added parameters are not added in XML format of the design.

If you create new design parameter will be added to xml format again.

Thanks,

Girish S.

Was this reply helpful? Yes No
Bharath45 15 on at

Like (0)

Report
Copy link

Link copied!

Hi Brajesh,

Are you able to resolve the issue? I am also running into the same issue and couldn't find a solution.

Thanks

BK

Was this reply helpful? Yes No
Elda Mataj 190 on at

Like (0)

Report
Copy link

Link copied!

Hi Brajesh,

Did you manage to solve this problem?

I am facing the same issue with the report XXXFreeTextInvoice.

Regards,

Was this reply helpful? Yes No
Brajesh singh 30 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Same error which i have mentioned above.

Was this reply helpful? Yes No
Martin Dráb 238,286 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Aha. So what problem do you get when you don't delete the parameter?

Was this reply helpful? Yes No
Brajesh singh 30 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

i tried to delete the node but after deleting the node i am getting an above error message in during build.

Regards

Brajesh Singh

Was this reply helpful? Yes No
Martin Dráb 238,286 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

All right, so the node is a parameter.

What if you simply delete it?

Was this reply helpful? Yes No
Brajesh singh 30 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Thank you for your response.

Error:

Severity Code Description Project File Line Suppression State

Error Path: [AxReport/XXXXFreeTextInvoice]:"An unhandled exception was thrown while validatingXXXFreeTextInvoice with callstack System.InvalidOperationException: Sequence contains no matching element

at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)

at Microsoft.Dynamics.AX.Metadata.Extensions.Reports.AxReportDataSetParameterExtensions.GetAssociatedReportParameter(AxReportDataSetParameter datasetParameter, AxReport report)

at Microsoft.Dynamics.AX.Metadata.Validation.DataSetParameterConstraint.Validate(ModelValidationContext context, AxReportDataSetParameter element)

at Microsoft.Dynamics.AX.Metadata.Validation.AxReportValidator.ValidateDataSets(AxReport report, ModelValidationContext validationContext)

at Microsoft.Dynamics.AX.Metadata.Validation.AxReportValidator.DoValidate(AxReport report, Uri uri, IMetadataProvider metadataProvider, IDiagnosticSink diagnostics)

Screentshot

Regards

Brajesh Singh

Was this reply helpful? Yes No
Martin Dráb 238,286 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Where do you see the node? Couldn't you add a screenshot, please?

Also, what problem do you have with deployment? You said it's not allowing you to do that, but not what's happening. Do youy get an error, for example? If so, what does the error say?

Was this reply helpful? Yes No