Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 297 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Backorder report locking up Navapp Session - Ideas?
dhahlen
Member Posts: 14
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
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
0
Comments
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.