Functions in Forms in 5.0 SP1 -> Error Message

Kowa

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: ?

Slawek_Guzek

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

Kowa

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.

Slawek_Guzek

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

Kowa

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:

Slawek_Guzek

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

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)

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

Kowa

It's good to know that it is a bug . 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.