ILE Created while GL entry locking
vijay_g
Member Posts: 884
Problem,
in production journal when i am posting output and consumption it prompt me GL entry locking but i am seeing ILE created. what can be reason?
i have checked all commit statement in related CU all is well.
in production journal when i am posting output and consumption it prompt me GL entry locking but i am seeing ILE created. what can be reason?
i have checked all commit statement in related CU all is well.
0
Answers
-
1) When you see the ILE created? During the transaction? During waiting for the timeout?
2)
Does it means that there are some commits between start of the process and the timeout?i have checked all commit statement in related CU all is well.0 -
Just add sometable.consistent(false) before calling posting routlines and sometable.consistent(true) after.vijay_g wrote:Problem,
in production journal when i am posting output and consumption it prompt me GL entry locking but i am seeing ILE created. what can be reason?
It's very simple way to protect you'r code from commit statements (or quickly find it).Looking for part-time work.
Nav, T-SQL.0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
