web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Getting Errors in depl...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Getting Errors in deploying the table while restoring the dataset of Table

(0) ShareShare
ReportReport
Posted on by Community Member

Hello Everyone,

While restoring the dataset of table ,I am getting an error occurred while deploying the report WMSPickingList_OrderPickCopy.Report, DB.
This might be because the SQL Server Reporting Services has not been installed, or is not configured correctly.
System.Web.Services.Protocols.SoapException: '_SCM_FooterText' is not a valid report parameter name. Names of objects must be CLS-compliant identifiers.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
Deploying rdl files for report WMSPickingList_OrderPickCopy failed.

Even on blank report, i am getting this error also.

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    goshoom  Sir, need help on this from your side

  • Community Member Profile Picture
    Community Member on at

    Khurram  Your Suggestion On this

  • Suggested answer
    Khurram Profile Picture
    Khurram 655 on at

    The actual error looks in parameter naming convention, avoid _ underscore to start with. CLS names should not start with underscore or symbols:

    System.Web.Services.Protocols.SoapException: '_SCM_FooterText' is not a valid report parameter name. Names of objects must be CLS-compliant identifiers.

  • Community Member Profile Picture
    Community Member on at

    On changing the name of _SCM_FooterText to SCM_FooterText but on again deploying the SSRS Report ,I am getting again error that

    When restoring an SSRS data source that has new parameters, deployment fails with the following message: An error occurred while deploying the report WMSPickingList_OrderPickCopy.Report, DB.

    This might be because the SQL Server Reporting Services has not been installed, or is not configured correctly.

     System.Web.Services.Protocols.SoapException: The number of defined parameters is not equal to the number of cell definitions in the parameter panel.

      at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)

      at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)

    Even I have done this

    daxonline.org/1708-the-number-of-defined-parameters-is-not-equal-to-the-number-of-cell-definitions-in-the-parameter-panel.html

  • Khurram Profile Picture
    Khurram 655 on at

    This separate error, and you need to open report design in XML in VS. Follow the instructions on time 32-34 on this YouTube video: https://youtu.be/qx4lpOgdSNU

  • Community Member Profile Picture
    Community Member on at

    While removing and matching the parameters in dataset,on build the project , i am getting this error.

    Code Description Project File Line Suppression State

    Path: []:System.InvalidOperationException: Sequence contains no elements

      at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)

      at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()

      at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)

      at Microsoft.Dynamics.Framework.Tools.ILGeneratorAgent.MetadataValidator.Validate(IEnumerable`1 elements, String module)

      at Microsoft.Dynamics.Framework.Tools.ILGeneratorAgent.CompilationService.ValidateMetadata(String module, String metadataPath, String compilerMetadataPath, IEnumerable`1 referencedAssembliesFolders, IEnumerable`1 elements) 0

  • Community Member Profile Picture
    Community Member on at

    It turned out that during the dataset restore a parameter was added. It was added at the Parameters (sub node Datasets) and the node Parameters.

    When you delete it only in the node Parameters the Error occurs.

  • Community Member Profile Picture
    Community Member on at

    Khurram

  • Suggested answer
    Khurram Profile Picture
    Khurram 655 on at

    Yes it is a bug and only way is by existing XML file, to remove extra parameter name tag.

  • Community Member Profile Picture
    Community Member on at

    Extra Parameter name is _SCM_FooterText in my report and in AOT I check with Original Report where parameter is Footer text for both in Datasets.How can I change that in xml file as on changing parameter i am getting error while building reports

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans