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
- 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Navision 4.03 Adjust cost item entries running slow
Vikas_Rai
Member Posts: 2
Hi,
My client is running Navision 4.03 version from last 4 years.
Till 29th August 2012 it was running very fine but suddenly when client runs the batch job
in September 2012 , its taking alot of time and system get hanged.
The strange thing is that when we run the same batch job in native database it runs fine,
and also when we take a backup and restore again in the production, it run perfectly, but again
from the second time it running very slow.
If anyone have some ideas , please help me to find out reason behind this problem.
Regards
Vikas Rai.
My client is running Navision 4.03 version from last 4 years.
Till 29th August 2012 it was running very fine but suddenly when client runs the batch job
in September 2012 , its taking alot of time and system get hanged.
The strange thing is that when we run the same batch job in native database it runs fine,
and also when we take a backup and restore again in the production, it run perfectly, but again
from the second time it running very slow.
If anyone have some ideas , please help me to find out reason behind this problem.
Regards
Vikas Rai.
0
Comments
Have your SQL Administrator delete all records/rows in the syscacheobjects table in your master system database by executing DBCC FREEPROCCACHE, and then try running the adjust cost process.
That fixed the problem for us.