Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K 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
- 326 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Blocking Problem
Mally
Member Posts: 128
I m using NAV 4.0SP3.When I m feeding Journal voucher,it shows me an error "Excise Cenvat Claim Detail" table has been blocked by another user.Wait
But When I drilldown Sessions then there is no tick on Blocked field in session table.
Please what can be the cause of this problem? and solution
But When I drilldown Sessions then there is no tick on Blocked field in session table.
Please what can be the cause of this problem? and solution
0
Comments
Are you running on SQL or Native database? Try running an sp_who in SQL after you run your command but before the error opens. It could lead you to who is blocking you.
How many users? If not many, just ask what everyone is doing at that moment.
I m using NAV 4.0SP3SQL DB.How can I run sp_who in SQL.I m new to SQL.
If you have an experienced SQL person there work with them. sp_who isn't going to mess anything up, but it's best if you can sit with someone who can help you understand.