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
    mmv 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
    mmv 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
    keoma 32,675 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
    mmv 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
    Mohana Yadav 60,155 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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans