NAV service error on SQL server

nav13
Member Posts: 39
All,
Lately my users have been noticing significant performance issues where the system delays during refresh or the screen goes gray and comes back. So I went into the SQL server to see if any errors existing and to my surprise, there was 140 errors per hour being recorded by the SQL server coming from the NAV Service. The issues starting happening about one week ago but both my developer and I cannot pin point specific code or automatation that is causing this error. Furthermore, this error is coming every 2 mins then again in 9 mins then again every 2 mins. The error message is below:
Type: System.Runtime.InteropServices.COMException
ErrorCode: -2147221164
Message: Retrieving the COM class factory for component with CLSID {CD4D86E3-C704-4D20-AB91-D2BACDF6964B} failed due to the following error: 80040154.
StackTrace:
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at Microsoft.Dynamics.Nav.Types.NavAutomationHelper.CreateAutomationObject(Guid classId, String licenseKey, Boolean newServer)
at Microsoft.Dynamics.Nav.Runtime.NavAutomation.Create(DataError errorLevel, Boolean newServer, Boolean clientSide)
Source: mscorlib
PLEASE HELP AS THIS IS A BIG ISSUE NOW.
NAV 2009 R2
Thanks,
NAV13
Lately my users have been noticing significant performance issues where the system delays during refresh or the screen goes gray and comes back. So I went into the SQL server to see if any errors existing and to my surprise, there was 140 errors per hour being recorded by the SQL server coming from the NAV Service. The issues starting happening about one week ago but both my developer and I cannot pin point specific code or automatation that is causing this error. Furthermore, this error is coming every 2 mins then again in 9 mins then again every 2 mins. The error message is below:
Type: System.Runtime.InteropServices.COMException
ErrorCode: -2147221164
Message: Retrieving the COM class factory for component with CLSID {CD4D86E3-C704-4D20-AB91-D2BACDF6964B} failed due to the following error: 80040154.
StackTrace:
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at Microsoft.Dynamics.Nav.Types.NavAutomationHelper.CreateAutomationObject(Guid classId, String licenseKey, Boolean newServer)
at Microsoft.Dynamics.Nav.Runtime.NavAutomation.Create(DataError errorLevel, Boolean newServer, Boolean clientSide)
Source: mscorlib
PLEASE HELP AS THIS IS A BIG ISSUE NOW.
NAV 2009 R2
Thanks,
NAV13
0
Comments
-
Usually this kind of error is related to component registration (COM component not registered) or due to a 32 bit executable on a 64-bit machine.* Daniele Rebussi * | * Rebu NAV Diary *0
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
- 1.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