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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / management reporter
Microsoft Dynamics GP (Archived)

management reporter

(0) ShareShare
ReportReport
Posted on by Community Member

New install of MR2012, migrated reports from FRx. 

I have a couple of reports that will not run. Other reports for this particular company run without error. 

The error logs are below. Any insight would be appreciated.

 

Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartCondition.ColumnAlias(ReaderSource source)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionPart(ReaderSource source, ICondition condition, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildChartValuesQuery(ChartElementCollection elementCollection, String accountTableName, ChartFieldCollection fieldCollection, ChartDescriptorCollection additionalDescriptorCollection, TreeNode conditionTreeNode)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.InsertIntoChartValuesTable(SqlConnection sqlConnection, String entityDatabase, String accountTableName, String balanceRowTableName, ChartElementCollection elementCollection, ChartDescriptorCollection additionalDescriptorCollection, TreeNode conditionTreeNode)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.GLProvider.PopulateBalanceRowTable(SqlConnection sqlConnection, BalanceRowCollection balanceRows, String balanceRowTableName)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.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.GeneralLedger.GLBalanceRequest.HandleRequest(SourceSystemProvider provider)
   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.SourceSystemProvider.Submit(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)
 
 
System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartCondition.ColumnAlias(ReaderSource source)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionPart(ReaderSource source, ICondition condition, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildChartValuesQuery(ChartElementCollection elementCollection, String accountTableName, ChartFieldCollection fieldCollection, ChartDescriptorCollection additionalDescriptorCollection, TreeNode conditionTreeNode)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.InsertIntoChartValuesTable(SqlConnection sqlConnection, String entityDatabase, String accountTableName, String balanceRowTableName, ChartElementCollection elementCollection, ChartDescriptorCollection additionalDescriptorCollection, TreeNode conditionTreeNode)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.GLProvider.PopulateBalanceRowTable(SqlConnection sqlConnection, BalanceRowCollection balanceRows, String balanceRowTableName)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.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.GeneralLedger.GLBalanceRequest.HandleRequest(SourceSystemProvider provider)
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)
 
 
 
Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartCondition.ColumnAlias(ReaderSource source)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionPart(ReaderSource source, ICondition condition, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildConditionQuery(ReaderSource source, TreeNode currentNode, String tableNameOverride)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.BuildChartValuesQuery(ChartElementCollection elementCollection, String accountTableName, ChartFieldCollection fieldCollection, ChartDescriptorCollection additionalDescriptorCollection, TreeNode conditionTreeNode)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.ChartRequestDataAccess.InsertIntoChartValuesTable(SqlConnection sqlConnection, String entityDatabase, String accountTableName, String balanceRowTableName, ChartElementCollection elementCollection, ChartDescriptorCollection additionalDescriptorCollection, TreeNode conditionTreeNode)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.GLProvider.PopulateBalanceRowTable(SqlConnection sqlConnection, BalanceRowCollection balanceRows, String balanceRowTableName)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.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.GeneralLedger.GLBalanceRequest.HandleRequest(SourceSystemProvider provider)
   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.SourceSystemProvider.Submit(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)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ProviderLink.SubmitBalanceRequest(ProviderConnection context, GLBalanceRequest balanceRequest)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.RetrieveGLDataBatch(Int32 rowNumber)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.GetData()

*This post is locked for comments

I have the same question (0)
  • Cory Severson Profile Picture
    Cory Severson 695 on at

    Hey Andy,

    I could only find one hit on this error.  

    I would check to make sure your companies you are trying to run the report for have all of their account segments named appropriately.

    Tools --> Setup  --> Company --> Account Format

    Make sure each company has a name for each segment.  They should also match between each company if possible.

    Another item to check is to make sure your budgetid's are filled out properly in your GL00200 and GL00201 tables.

    You may want to narrow down the issue to what company is having a problem and then start looking at the above.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I have fixed the issue with error "object reference not set to an instance of an object" for the above error by checking the table GL40200 (Account Format Setup) for the Company/Entity on which this error was coming, in my case it was entity 10 and it doesn’t have the SGMTNUMB defined in the sequential order as you can see in the below screenshot and this was throwing the above error when running the report. In the front end from GP screen if you check they all appear in ascending order but at the back end they were not so in order to fix that I re-entered them again through the GP screen and this fixes the sequence no in the table and now we are able to run the reports for this entity now.

    Hope this helps some of those who are receiving the same error even after upgrading to MR2012 with latest service packs.

    　

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    I wrote a blog post on this particular issue - it is highly likely you are missing something subtle...

    redbeardblogging.blogspot.com/.../management-reporter-report-has.html

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans