Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Payment proposal report "halts"

Posted on by 1,530

Dear All,

Recently I have run into a problem with the Payment Proposal report CustVendPaymProposal.

The behaviour is very odd so I am having trouble debugging the issue.


This is what happens:
I go to the payment journal lines.

Select print -> payment.
I just select the payment checkbox and print the report to screen.

In 80% of the cases the report "hangs" AX shows the report screen and is responsive but the report keeps loading and never shows result. I need to log in to SQL reporting and kill the running report task.
In the other 20% the report runs just fine. There are no issues with other reports.

There is nothing in the windows, sql or reporting logs. There are no locks occuring on the database.
Furthermore there are no customisations on the report. The enviroment compiles fine. CIl has recently been compiled and WCF has been regererated.  Allso I have redeployed the report several times.


I am running AX 2012 R3 CU8 and SQL 2014 cu5.


Has anyone experienced similair beheviour? Do you have any tips on resolving this issue?

*This post is locked for comments

  • Anton Venter Profile Picture
    Anton Venter 18,779 Super User 2024 Season 2 on at
    RE: Payment proposal report "halts"

    Hi Rik, I have seen similar behaviour but that was caused some sessions keeping the "temp" table locked even after the report has been rendered to the screen. Are you sure there are no locks on the table when it is "hanging"? Have you tried to do a SQL trace while running the report? Can you see if the process in SQL is maybe suspended?

  • Daniel Esser Profile Picture
    Daniel Esser on at
    RE: Payment proposal report "halts"

    Restart SSRS Server solve the problem in my case.

  • Daniel Esser Profile Picture
    Daniel Esser on at
    RE: Payment proposal report "halts"

    Hey, 

    i have the same problem.

    do you already have a solution?

    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans