Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP with Manag...
Microsoft Dynamics GP (Archived)

Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

(0) ShareShare
ReportReport
Posted on by Mitch.M 530

A client recently updated MR to CU8. They had issues with the data and recreated the data mart. The data mart is not working correctly. It continually adds errors. Running a trace shows three events repeating constantly, the third of which is writing this error:

[GL Transaction to Fact] has encountered an error while reading records. Error text: A record level exception has occurred for record (N/A). Error text : Object reference not set to an instance of an object.

Has anyone seen this or know what to do to get around it?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

    Hi Mitch,

    Can you tell the steps involved about migration of MR to a new Database?

    Any Article related to this? This will help for our future reference.

  • Mitch.M Profile Picture
    Mitch.M 530 on at
    RE: Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

    As an aside to my original problem it was not fixed directly. We just 'migrated' everything from Management Reporter to a new database and were able to recreate the data mart after that. Thank you for the responses, however.

  • wee4sfolk Profile Picture
    wee4sfolk 20 on at
    RE: Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

    Please ignore my earlier post - My folder setting were hiding the Program Data folder.  Once I changed the settings to show hidden folders - there it was.

    We should mention that you have to stop the Process Service to open the log.

    Here is what I get - any ideas?

    INFO TID:TP-4 [2014-06-30T14:58:01.2029892-04:00]: [GL Transaction to Fact] has started in Map mode.

    06/30/2014 18:58:01: task d8e0ee67-a69c-4837-a209-fe017f6ba1c2 is Running

    INFO TID:TP-9 [2014-06-30T14:58:01.3748641-04:00]: [FiscalYearProvider to Fiscal Year] has started in Map mode.

    VERBOSE TID:TP-9 [2014-06-30T14:58:01.5467375-04:00]: [FiscalYearProvider to Fiscal Year] with MapId [d8e0ee67-a69c-4837-a209-fe017f6ba1c2] is searching for DELETE keys using 6/30/2014 6:57:02 PM as last change.

    VERBOSE TID:TP-9 [2014-06-30T14:58:01.5467375-04:00]: [FiscalYearProvider to Fiscal Year] DELETE returned no records to process.

    VERBOSE TID:TP-9 [2014-06-30T14:58:01.5467375-04:00]: [FiscalYearProvider to Fiscal Year] with MapId [d8e0ee67-a69c-4837-a209-fe017f6ba1c2] is searching for READ keys using 6/30/2014 6:57:02 PM as last change.

    VERBOSE TID:TP-9 [2014-06-30T14:58:01.7654876-04:00]: [FiscalYearProvider to Fiscal Year] READ returned no records to process.

    06/30/2014 18:58:01: task d8e0ee67-a69c-4837-a209-fe017f6ba1c2 is RanToCompletion

    VERBOSE TID:TP-9 [2014-06-30T14:58:01.7654876-04:00]: [FiscalYearProvider to Fiscal Year] has completed. 0 record(s) have been written. 0 record(s) have been deleted.

  • wee4sfolk Profile Picture
    wee4sfolk 20 on at
    RE: Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

    Thank you for your quick reply.  I do not have that location - no Program Data folder etc. on my SQL server. Do I need to create this path for the log?

    Thank you,

    Carla

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

    Hi Mitch,

    Please refer the below mentioned location once the config file is changed.

    C:\ProgramData\Microsoft Dynamics\Connector for Microsoft Dynamics\Logs

    if you dint find any details in the log file please change the value to 1 to trace the log.

  • wee4sfolk Profile Picture
    wee4sfolk 20 on at
    RE: Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

    After changing the MRServiceHost.exe.config file to enable logging, where do I find the resulting log?  Thank you.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

    Hi Mitch,

    Please change the config file to trace the root cause.

    To enable logging:

    1. Navigate to C:\Program Files\Microsoft Dynamics ERP\Management Reporter\(your version)\Server\Services\

    2. Open the MRServiceHost.exe.config in notepad.

    3. Search for <add name="Microsoft.Dynamics.Integration.TraceLog" value="0"/>

    4. Change the 0 to a 4, so it looks like this: <add name="Microsoft.Dynamics.Integration.TraceLog" value="4"/>

    5. Restart the MR Process Service.

    The log file will capture the error and it may provide root cause information that may help to fix the issue.

    most probably the issue will be: (some transactions in the G/L for non-existent  fiscal years) so need to create the fiscal years and the datamart setup to be completed again.

  • mtrotzuk Profile Picture
    mtrotzuk 5 on at
    RE: Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

    Running into the exact same thing. Tried running Checklinks and rebuilding the DataMart but no luck. Does anyone have any further suggestions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP with Management Reporter 2012 CU8: [GL Transaction to Fact] has encountered an error while reading records.

    We had the same problem and it was due to missing/bad data in GP. We ran Checklinks on everything and found missing tax schedule summary information. We rebuilt the DataMart afterwards and it finally worked.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans