Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL forum / Management Reporter: [...
Microsoft Dynamics SL forum
Answered

Management Reporter: [G/L Transaction to Fact] has encountered an error. Processing will be aborted. Error text: Object reference not set to an instance of an object.

(1) ShareShare
ReportReport
Posted on by Deb Lashua 2,165

We did a test upgrade of SL 2011 and MR 2012. Everything was fine in the test environment. We then completed the final upgrade for SL2011. We are rebuilding the data mart in MR and encounter an issue with the integration. We see the integration in progress, but it never completes. The Data Mart integration log does have one error in it that indicates the the C/L transaction to fact has encountered an error. Processing will be aborted. However, it looks like the integration is still in process. Any ideas on how to get this to complete would be appreciated. This is a very large database. Thank you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter: [G/L Transaction to Fact] has encountered an error. Processing will be aborted. Error text: Object reference not set to an instance of an object.

    Indeed, create an incident with Microsoft and ask them for the Diagnostic scripts that they have to look for any SL data that would cause problems w/ the MR integration. The scripts are extraordinarily useful in not only identifying the problem data but also on how to fix it.

  • Camilo Virguez Profile Picture
    Camilo Virguez 452 on at
    RE: Management Reporter: [G/L Transaction to Fact] has encountered an error. Processing will be aborted. Error text: Object reference not set to an instance of an object.

    Hi ,  Yes...  agree with Deb Lashua's answer.  in my case we created a new environment and imported with .dat and .def file to a new environment  and we cleaned the transactions.  transactions on shared tables was not deleted for legal entities that were not present in the new environment.  had to go in ax and with a job finish the delete.  after that the MR  synch the information without any error.

  • Deb Lashua Profile Picture
    Deb Lashua 2,165 on at
    RE: Management Reporter: [G/L Transaction to Fact] has encountered an error. Processing will be aborted. Error text: Object reference not set to an instance of an object.

    We actually had two issues - 1. Dimension Tran Error and 2.GL Tran Error. We were able to locate the affected transactions.

    1. The dimension tran error was caused by the vendorid in the fieldclassname field in the segdef table. Once we deleted this from the table, the error was resolved.

    2. The GL Tran error was caused by the curyid not be equal to USA or being blank in GLTran table. Once we corrected these transactions, the error was resolved.

    These errors can be caused by other things being incorrect in the tables. This is just an example of what you might run into.

    I hope this helps you. If not, I would suggest opening a ticket with Microsoft.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter: [G/L Transaction to Fact] has encountered an error. Processing will be aborted. Error text: Object reference not set to an instance of an object.

    Deb,

    I am running into the same issue. Can you elaborate on what transactions were causing the problem?

  • Verified answer
    Deb Lashua Profile Picture
    Deb Lashua 2,165 on at
    RE: Management Reporter: [G/L Transaction to Fact] has encountered an error. Processing will be aborted. Error text: Object reference not set to an instance of an object.

    Thank you. I was able to determine the problem with the transactions and corrected them via sql. I have been able to rebuild the data mart without issue.

  • EDJJR Profile Picture
    EDJJR on at
    RE: Management Reporter: [G/L Transaction to Fact] has encountered an error. Processing will be aborted. Error text: Object reference not set to an instance of an object.

    Good Afternoon Deb,

    I would recommend for you to create a support case so that we can better troubleshoot the issue. There can be a variety of different issues that can cause the Fact table, in the DDM, not to populate.

    Thanks,

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans