Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

NAV 2013 R2: General Journal Test Report runs into loop

(0) ShareShare
ReportReport
Posted on by 11,467

Dear All,

I am using NAV 2013 R2 (AU). Something very strange is that the standard General Journal-Test Report (Report ID 2) is running into loop. When I checked, I found out that the ErrorLoop is causing problem.

Any idea?

Best Regards, MMV

*This post is locked for comments

  • mmv Profile Picture
    11,467 on at
    RE: NAV 2013 R2: General Journal Test Report runs into loop

    Dear All,

    I found out the issue.  Though there is a filter set on the Integer table, it yields the maximum number of records, i.e., 2000000001 and hence it was running into loop.  All these happened because of the "Build Server Application Objects" command.  I tried to remove the Integer table entry from the Object Metadata table (in the standard database) and executed the "Build Server Application Objects" command and tried to run the Test Report, report started going into loop.

    So the issue seems to be with the "Build Server Application Objects".

    Any suggestion how to overcome this.

    Best Regards,

    MMV

  • mmv Profile Picture
    11,467 on at
    RE: NAV 2013 R2: General Journal Test Report runs into loop

    hi,

    Thank you for you reply.

    In the ErrorLoop, the current code is

    SETRANGE(Number,1,ErrorCounter);

    If I change the above as

    SETRANGE(Number,1,1);

    It works well.  

    But if the counter is anything apart from one, i.e.,

    SETRANGE(Number,1,2);

    It goes onto loop.

    Any idea?

    Best Regards,

    MMV

  • Suggested answer
    keoma Profile Picture
    32,727 on at
    RE: NAV 2013 R2: General Journal Test Report runs into loop

    if the report is a standard report, export that report as text file ( ! ) from a database, where it runs well and import it to the target database, compile the report, test again.

    if this does not work, run the debugger to find the position, where the error occurs for better analysis.

  • mmv Profile Picture
    11,467 on at
    RE: NAV 2013 R2: General Journal Test Report runs into loop

    Hi,

    The below issue is happening only on a particular database.  I tried to replicate on another copy of the database, but it works well.  

    But the issue is with my live database using the standard object.

    Best Regards,

    MMV

  • Suggested answer
    Mohana Yadav Profile Picture
    60,226 Super User 2025 Season 1 on at
    RE: NAV 2013 R2: General Journal Test Report runs into loop

    I didn't see any issue, may be it is happening in a particular scenario.

    So please try to replicate issue in Cronus Demo Database and If you can replicate then please create a service call for Microsoft.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans