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 / Microsoft Dynamics SL (Archived) / management reporter ge...
Microsoft Dynamics SL (Archived)

management reporter generate report error

(0) ShareShare
ReportReport
Posted on by Robin Argue 100

Hi,

We just installed MR 2012 (previously used only Frx) and when trying to generate a report I keep getting the following error:  

I am able to set up a row definition and pull the account structure in which appears correct.

Any help is appreciated.

Thanks.

 

 

Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> System.Data.SqlClient.SqlException: Invalid column name 'AcctActive'.
Invalid column name 'SubActive'.
Invalid column name 'AcctSubActive'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.BalanceReader.Open()
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLBalanceResult..ctor(GLSystemProvider provider, GLBalanceRequest request, GLDataReaderCollection readers, Object[] sharedResources)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.SL.GLProvider.HandleBalanceRequest(GLBalanceRequest request)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLSystemProvider.HandleRequest(GLBalanceRequest request)
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemRequest.Handle[TRequest](SourceSystemProvider provider, TRequest request)
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)
   --- End of inner exception stack trace ---
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.HandleSubmit(SourceSystemRequest request)
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemConnection.Submit(SourceSystemRequest request)
   at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.SubmitRequestInternal(SourceSystemConnection connection, GLRequest request)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ProviderLink.SubmitRequest(GLRequest request, ProviderConnection context)

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: management reporter generate report error

    Hey Robin (and whoever else reads this)

    Thanks for the screenshots.  We were good there.  However, two things that fixed the issue.

    The first was the company ID didn't match in the SL database.

    The second was to re-import the companies in the configuration manager.

    Thanks!

    Nate

  • Robin Argue Profile Picture
    Robin Argue 100 on at
    RE: management reporter generate report error

    Hi Nate,

    I got this to run.  It was missing the Management Reporter 2012 Process Service.   I had to configure it through File Configure and then pick the Management Reporter Process Service item.  Then it then appears as running (Both Application Service & Process Service need to be running)

    It's been along time since I worked on this but I do have a couple of screen shots.  I can't get them to post here.   If you want them, email me directly and I can send them.

    rargue@the-alliance.org

    Robin

  • Community Member Profile Picture
    Community Member on at
    RE: management reporter generate report error

    Did this resolve the issue?  We are having the exact same issue and this did not resolve it for us.

    Regards,

    Nate

  • Cory Severson Profile Picture
    Cory Severson 695 on at
    Re: management reporter generate report error

    It looks like Jon was able to give you the answer.  Thanks Jon!

  • Suggested answer
    Jon Wheeler Profile Picture
    Jon Wheeler 325 on at
    Re: management reporter generate report error

    Robin

    This response is from Microsoft.

    "You must apply a hotfix to make this version of the Microsoft Dynamics SL data provider compatible with Microsoft Dynamics SL 2011 and with Microsoft Dynamics SL 2011 Service Pack 1 (SP1)."

    www.microsoft.com/.../details.aspx

    The HotFix is available on the main Management Reporter 2012 download page: mbs.microsoft.com/.../mroverview.htm

    At the above link you will see "Microsoft Dynamics SL 2011 Hot Fix (SL 2011 and SL 2011 SP1)". Installation instructions are included.

    Jon

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,140 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,895 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans