Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Report gives an error but keeps locking tables
matias_jaure
Member Posts: 157
Hello,
We have a problem with a report that we have in a job to run every 30 minutes. This report run the Post batch (automatically post all orders in Realease state). Sometimes, it gives an error because some table that it's trying to use is locked. There would not be a problem if the report wouldn't keep blocking other tables, the most common one is Sales Line.
When someone goes and click OK in the error message, other users can work again. So, we think that this report is locking the tables. The Transaction Type of the Report is <Update No Locks>. We are using Navision 4.03 with SQL.
Thanks for ur time!
Matias
We have a problem with a report that we have in a job to run every 30 minutes. This report run the Post batch (automatically post all orders in Realease state). Sometimes, it gives an error because some table that it's trying to use is locked. There would not be a problem if the report wouldn't keep blocking other tables, the most common one is Sales Line.
When someone goes and click OK in the error message, other users can work again. So, we think that this report is locking the tables. The Transaction Type of the Report is <Update No Locks>. We are using Navision 4.03 with SQL.
Thanks for ur time!
Matias
0
Comments
Please read this http://www.mibuso.com/forum/viewtopic.p ... highlight=
It's 4.03, How I check if I have that update?
I have to verify that with DBA, they don't allow me to do that find of things :x ... If there is that version, what should I do?
http://dynamicsuser.net/blogs/waldo/arc ... dated.aspx
for the Links to mbs.microsoft.com/knowledgebase you neet passport login
Regards
In Waldo's blog you should pay attention to Update 6.2 KB945349.
I accidenlty ran into this thread ... .
Cool!
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
See all that time blogging didn't go to waste \:D/
http://www.BiloBeauty.com
http://www.autismspeaks.org
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog