Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter 20...
Microsoft Dynamics GP (Archived)

Management Reporter 2012 error: The correlation name 'dv4' is specified multiple times in a FROM clause.

(0) ShareShare
ReportReport
Posted on by Community Member

I have a user trying to run a series of reports from Management Reporter and she continues to get an error that the object refference not set to an instance of an object. when I look in the MR2012 service log I get the error below. Any idea what could be causing this? We rebuilt the tree and tried to toggle some other settings but continue to get the same error. Incidently this only started after we upgraded to MR2012 version 2.1.8001.0.

System.Data.SqlClient.SqlException (0x80131904): The correlation name 'dv4' is specified multiple times in a FROM clause.

  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.ExecuteReader()

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.DataMartReader.Open()

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.DataMartTransactionDetailReader.Open()

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.DataMartTotallingTransactionReader.EnsureReader()

  at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.DataMartTotallingTransactionReader.Read()

  at Microsoft.Dynamics.Performance.Reporting.NativeReport.TransactionLineBuilder.PopulateTransactionLines()

  at Microsoft.Dynamics.Performance.Reporting.NativeReport.TransactionLineBuilder.BuildReportTransactionLines(GLTransactionResult result)

  at Microsoft.Dynamics.Performance.Reporting.NativeReport.ReportDataContext.LoadTransactionLines(Guid id, Int32 noteReportId, Int16 unit, Int32 row, Int32 account, Boolean loadNotes, ReportDataContext context, Line data, Structure reportStructure)

  at Microsoft.Dynamics.Performance.Reporting.NativeReport.ReportDataContext.LoadTransactionLines(Guid id, Int32 noteReportId, Int16 unit, Int32 row, Int32 account, Boolean loadNotes, ReportDataContext context, Line data)

  at Microsoft.Dynamics.Performance.Reporting.NativeReport.ReportDataContext.LoadLinesInternal(Guid id, Int16 unit, Nullable`1 row, Nullable`1 account, Boolean loadNotes, ReportDataContext context, Line data)

  at Microsoft.Dynamics.Performance.Reporting.NativeReport.ReportDataContext.<>c__DisplayClass6c.<LoadLines>b__6b(ReportDataContext context)

  at Microsoft.Dynamics.Performance.Reporting.NativeReport.ReportDataContext.Execute[T](Boolean writable, Func`2 execute)

  at Microsoft.Dynamics.Performance.Reporting.NativeReport.ReportDataContext.LoadLines(Guid id, Int16 unit, Nullable`1 row, Nullable`1 account, Boolean loadNotes)

  at Microsoft.Dynamics.Performance.Reporting.NativeReport.NativeReportService.<>c__DisplayClass22.<LoadLines>b__21()

  at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)

  at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)

*This post is locked for comments

  • Leahs Profile Picture
    Leahs on at
    RE: Management Reporter 2012 error: The correlation name 'dv4' is specified multiple times in a FROM clause.

    Is sounds like you were running into an issue with 1 of the companies that was included in the Tree Definition.  You should be able to zero in into by closing all the current building blocks that are open.  And then setting each of the companies as default.  Then Go to Administrative Tools >> Event viewer >> Windows Logs >> Application. Select the error and reply back with the text from the error.

  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter 2012 error: The correlation name 'dv4' is specified multiple times in a FROM clause.

    1)  Is Analytical Accounting being used in Dynamics GP? NO

    2)  Does a simplified Report Definition return the same error? no, if not using reporting tree.

    We seem to have isolated this to the reporting tree.

  • Leahs Profile Picture
    Leahs on at
    RE: Management Reporter 2012 error: The correlation name 'dv4' is specified multiple times in a FROM clause.

    1)  Is Analytical Accounting being used in Dynamics GP?

    2)  Does a simplified Report Definition return the same error?

    a) Create a new row with 1 or 2 accounts.

    b) Create a column with a Desc, FD/Periodic and FD/YTD.

    c) Create a new Report Definition and generate.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans