Functions in Forms in 5.0 SP1 -> Error Message

Kowa
Kowa Member Posts: 926
edited 2008-07-16 in NAV/Navision Classic Client
We have a number of sales and purchase reports which use a form variable "Calculation" with some parameters passed by reference to perform some calculations.
The form is not opened when the report is run, only its functions are used.

Up to now ( for the last 6 years :) ) this has been working fine. With the current 5.0 SP1 client, it is no longer possible to print the report. An error message pops up:

'Sales - Quote SI' cannot be closed, because it is locked by 'Calculation'.
Please finish 'Calculation' before closing.

The client then hangs up and can only be stopped by the task manager.

This message does not come up during a report preview. Also, when a 5.0 Client is used, the report is printed without any problem.

Does anybody have any information on this new "feature" ? Or is it just a :bug: ?
Kai Kowalewski

Answers

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Hi,

    I know that is sounds ridiculous.. but try in your SQL:
    GRANT SHOWPLAN TO [$ndo$shadow]
    Get back with the results please.

    Regards,
    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • Kowa
    Kowa Member Posts: 926
    Slawek Guzek wrote:
    Hi,

    I know that is sounds ridiculous.. but try in your SQL:
    GRANT SHOWPLAN TO [$ndo$shadow]
    Get back with the results please.

    Regards,
    Slawek
    This happens on a native server, no SQL-tweaking possible. :)
    Kai Kowalewski
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    :(

    Regardless it is a feature or bug it is some undocumented change in NAV client behaviour :evil:. BTW - try if the same is on SQL Client..

    I wonder what happens when we upgrade our clients to NAV 2009... :whistle:

    Regards,
    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • Kowa
    Kowa Member Posts: 926
    Slawek Guzek wrote:
    I wonder what happens when we upgrade our clients to NAV 2009... :whistle:
    All the documented changes are usuallly just the tip of the iceberg…
    It's very annoying that time-consuming stuff like this, which can even cause projects to fail, always is the sword hanging above your head when doing new implementions or upgrades. A simple technical upgrade can render a system practically unusable if things like this are foisted upon us without being announced. :roll:
    Kai Kowalewski
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Today's posting in KB:
    "Error message when you try to print a custom report in Microsoft Dynamics NAV 5.0 with Service Pack 1: "'[Report_name]' cannot be closed, because it is locked by '[Form_name]'"
    https://mbs.microsoft.com/knowledgebase ... wsignin1.0

    So now we know - it is a bug not a feature :D

    For those who don't have access to the PartnerSource
    WORKAROUND
    To work around this problem, move the code from the form into a code unit.
    and this for the chosen ones ('wasting' their money for on support contract) :mrgreen:
    RESOLUTION
    A supported hotfix is now available from Microsoft. The hotfix corrects the problem that is described in this article. Apply the hotfix only to systems that are experiencing this specific problem.
    Regards,
    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • Kowa
    Kowa Member Posts: 926
    It's good to know that it is a bug :lol:. Wouldn't have made much sense otherwise. Thanks for checking the knowledge base today, I did this two days ago but, naturally, couldn't find anything then.
    Kai Kowalewski

Categories