Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by 30

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

  • Bharath45 Profile Picture
    Bharath45 15 on at
    RE: Extra node is getting added while restore data source in free text invoice report

    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

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: Extra node is getting added while restore data source in free text invoice report

    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.

  • Bharath45 Profile Picture
    Bharath45 15 on at
    RE: Extra node is getting added while restore data source in free text invoice report

    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

  • Elda Mataj Profile Picture
    Elda Mataj 190 on at
    RE: Extra node is getting added while restore data source in free text invoice report

    Hi Brajesh,

    Did you manage to solve this problem?

    I am facing the same issue with the report XXXFreeTextInvoice.

    Regards,

  • Brajesh singh Profile Picture
    Brajesh singh 30 on at
    RE: Extra node is getting added while restore data source in free text invoice report

    Hi Martin,

    Same error which i have mentioned above.

  • Martin Dráb Profile Picture
    Martin Dráb 230,445 Most Valuable Professional on at
    RE: Extra node is getting added while restore data source in free text invoice report

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

  • Brajesh singh Profile Picture
    Brajesh singh 30 on at
    RE: Extra node is getting added while restore data source in free text invoice report

    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

  • Martin Dráb Profile Picture
    Martin Dráb 230,445 Most Valuable Professional on at
    RE: Extra node is getting added while restore data source in free text invoice report

    All right, so the node is a parameter.

    What if you simply delete it?

  • Brajesh singh Profile Picture
    Brajesh singh 30 on at
    RE: Extra node is getting added while restore data source in free text invoice report

    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

    8321.Error2.jpg

    8130.Error.jpg

    Regards

    Brajesh Singh

  • Martin Dráb Profile Picture
    Martin Dráb 230,445 Most Valuable Professional on at
    RE: Extra node is getting added while restore data source in free text invoice report

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans