Backorder report locking up Navapp Session - Ideas?

dhahlen

A little background:

Navision 4.0 SP2

The system in place here is custom designed to work with the companies web page. The web cart interacts with Navision and this is how the cart contents are generated. If the Navision Service stops or the Navapp session locks up the web-cart will generate an error when you try to access it. We currently have the company who designed the interface looking into it but I was hoping someone might have a better idea.

The report will run as any report does. It will put a lock on SQL until it is finished running. (This is supposidely going to be fixed when they switch to 3 Tier in Nav 5.0). Normally a report will cause a lock on the SQL session, and once finished it unlocks and everything is working normally. However, when this backorder procedure is ran (ran after hours due to the fact it locks the session for an extended period of time). The lock initiates and the report will eventually hit 100%. This is completely normal up until the last 30 seconds. Once the report reaches 100% something happens (unknown) that causes the Navapp session to lock in Navision. The report finishes, but in the process it has locked the session and taken down the web cart. In order to restore it we do the following.

Log into SQL Server
Kill Navision service
Go into Kill Sessions in Navision
Kill DOMAIN\Navapp Session
Restart Service

After that things are back to normal. The problem is an easy fix but the report should not be causing this problem. It should lock the session and unlock when finished but should not freeze the navapp session.

Any help or suggestions are greatly appreciated

dhahlen

Waiting on the approval from the design company before we enable the debugger and breakpoint options...

This might give us a look into what it is doing after that report finishes...

I would like to have a look at this 'code coverage' option.