Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee 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 Microsoft Employee 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans