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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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
    on at

    goshoom  Sir, need help on this from your side

  • Community Member Profile Picture
    on at

    Khurram  Your Suggestion On this

  • Suggested answer
    Khurram Profile Picture
    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
    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
    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
    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
    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
    on at

    Khurram

  • Suggested answer
    Khurram Profile Picture
    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
    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 258 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans