dbTalk Databases Forums  

msolap80 provider error with VB6 COM+ Dll

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss msolap80 provider error with VB6 COM+ Dll in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Manuel Arbulu via SQLMonster.com
 
Posts: n/a

Default msolap80 provider error with VB6 COM+ Dll - 09-05-2005 , 01:33 PM






I made a business layer using VB 6.0 sp 5 and Component Services under win2k
sp3, this Dll executes a few MDX querys through a huge OLAP (Analysis
Services 2k sp3) cube using ADOMD as well SQL Querys to a SQL 2k SP 3a
enterprise edition, this environment works fine in production for several
weeks serving about 40,000 MDX querys at day. We are using MDAC 2.8

Our Presentation Layer has been made in ASP pages, formatting all output in
HTML format

But after days working fine, It started to appear an Provider error
'80040e14' in all MDX querys, is not an OLAP issue because reestarting the
server does not fix the problem, when the COM+ application is restarted is
when the problem disappears.

The production server has The Microsoft Debug Diagnostic Tool 1.0 and has
made a User Dump file for this Dll warning us about a First Chance Access
Violation problem in the Dll, I don't know how to found the problem y how to
interpret the Debug File.

Report for DLLHOST.EXE__Xchange Central WEB Negocio
Com+__PID__2340__Date__09_05_2005__Time_11_12_04AM __203__Manual Dump.dmp
Type of Analysis Performed Hang Analysis
Machine Name
Operating System Windows 2000 Service Pack 3
Number Of Processors
Process ID 2340
Process Image C:\WINNT\system32\DLLHOST.EXE
System Up-Time 0 day(s) 00:00:00
Process Up-Time 10 day(s) 12:05:42

Thread 9 - System ID 3800
This thread is performing an unidentified task, that may or may not be a
problem. Further analysis of these threads is recommended.

Function Source
msolap80!DllRegisterServer+b4943
msolap80!DllRegisterServer+4d6b5
msolap80!DllRegisterServer+53525
msolap80!DllRegisterServer+53ce7
msolap80!DllRegisterServer+bc4f8
msolap80!DllRegisterServer+45e82
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+d0cf0
msolap80!DllRegisterServer+4622e
msolap80!DllRegisterServer+45f56
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+cb05d
msolap80!DllRegisterServer+dd12a
msolap80!DllRegisterServer+dd888
msolap80!DllRegisterServer+ddd76
msolap80!DllRegisterServer+4622e
msolap80!DllRegisterServer+45f56
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+cb05d
msolap80!DllRegisterServer+e8bdd
msolap80!DllRegisterServer+dc3cc
msolap80!DllRegisterServer+dd888
msolap80!DllRegisterServer+dd888
msolap80!DllRegisterServer+dd888
msolap80!DllRegisterServer+dd888
msolap80!DllRegisterServer+dd888
msolap80!DllRegisterServer+dd888
msolap80!DllRegisterServer+81d5c
msolap80!DllRegisterServer+d809c
msolap80!DllRegisterServer+d8449
msolap80!DllRegisterServer+d046c
msolap80!DllRegisterServer+4622e
msolap80!DllRegisterServer+45f56
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+cb05d
msolap80!DllRegisterServer+dd63a
msolap80!DllRegisterServer+ddd76
msolap80!DllRegisterServer+dddc0
msolap80!DllRegisterServer+4622e
msolap80!DllRegisterServer+45f56
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+1029
msolap80!DllRegisterServer+e2d
msadomd!CMdCellset::getCellFormattedValue+7d
msadomd!CMdCell::get_FormattedValue+59
txfaux!CallFrame::Invoke+51 ..\callframe.cpp @ 923 + 23
OLE32!CCtxChnl::SyncInvoke2+84
OLE32!CCtxChnl::SendReceive2+1bb
OLE32!CCtxChnl::OnCall+1fc
txfaux!Interceptor::CallIndirect+107 ..\interceptor.cpp @ 1081 + a
txfaux!InterceptorThunk+29 ..\interceptor.cpp @ 1744
XCHCENTRALNEG!DllCanUnloadNow+313a9
XCHCENTRALNEG!DllCanUnloadNow+7e71
OLEAUT32!DispCallFunc+15d
msvbvm60!BASIC_CLASS_Invoke+259
msvbvm60!BASIC_CLASS_Invoke+52
OLEAUT32!IDispatch_Invoke_Stub+6d
OLEAUT32!IDispatch_RemoteInvoke_Thunk+3c
rpcrt4!NdrStubCall2+604
rpcrt4!CStdStubBuffer_Invoke+c8
OLEAUT32!CStubWrapper::Invoke+9f
OLE32!SyncStubInvoke+61
OLE32!StubInvoke+a8
OLE32!CCtxComChnl::ContextInvoke+bb
OLE32!MTAInvoke+18
OLE32!STAInvoke+56
OLE32!AppInvoke+88
OLE32!ComInvokeWithLockAndIPID+2b5
OLE32!ComInvoke+41
OLE32!ThreadDispatch+21
OLE32!ThreadWndProc+101
USER32!UserCallWinProc+18
USER32!DispatchMessageWorker+2e4
USER32!DispatchMessageW+b
comsvcs!STAMessageWork:oWork+15 ..\inc\STAThred.h @ 244
comsvcs!STAThread::STAThreadWorker+423 .\stathred.cpp @ 650
KERNEL32!BaseThreadStart+52


Thread 20 - System ID 3744
This thread is performing an unidentified task, that may or may not be a
problem. Further analysis of these threads is recommended.

Function Source
msolap80!DllRegisterServer+4d635
msolap80!DllRegisterServer+534ca
msolap80!DllRegisterServer+53ce7
msolap80!DllRegisterServer+bc4f8
msolap80!DllRegisterServer+45e82
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+d0cf0
msolap80!DllRegisterServer+dca08
msolap80!DllRegisterServer+4622e
msolap80!DllRegisterServer+45f56
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+d28e2
msolap80!DllRegisterServer+d2512
msolap80!DllRegisterServer+4622e
msolap80!DllRegisterServer+45f56
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+d0cf0
msolap80!DllRegisterServer+4622e
msolap80!DllRegisterServer+45f56
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+cb05d
msolap80!DllRegisterServer+dd12a
msolap80!DllRegisterServer+dd888
msolap80!DllRegisterServer+ddd76
msolap80!DllRegisterServer+4622e
msolap80!DllRegisterServer+45f56
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+cb05d
msolap80!DllRegisterServer+e8bdd
msolap80!DllRegisterServer+dc3cc
msolap80!DllRegisterServer+dd8d6
msolap80!DllRegisterServer+dd888
msolap80!DllRegisterServer+81d5c
msolap80!DllRegisterServer+d809c
msolap80!DllRegisterServer+d8449
msolap80!DllRegisterServer+d046c
msolap80!DllRegisterServer+4622e
msolap80!DllRegisterServer+45f56
msolap80!DllRegisterServer+46609
msolap80!DllRegisterServer+cb05d
msolap80!DllRegisterServer+dd63a
msolap80!DllRegisterServer+81d5c
msolap80!DllRegisterServer+d809c
msolap80!DllRegisterServer+4334f
msolap80!DllRegisterServer+42952
msolap80!DllRegisterServer+2efa
msolap80!DllRegisterServer+49e9
msolap80!DllRegisterServer+1d25
msolap80!Ordinal98+2586c
msolap80!Ordinal98+2308b
msolap80!Ordinal98+22d3f
msolap80!Ordinal98+219ab
msadomd!CMdCellset::getDataset+dd
msadomd!CMdCellset::Open+184
XCHCENTRAL!DllCanUnloadNow+18bc5
XCHCENTRAL!DllCanUnloadNow+145dd
rpcrt4!Invoke+30
rpcrt4!NdrStubCall2+664
rpcrt4!CStdStubBuffer_Invoke+6b
OLEAUT32!CUnivStubWrapper::Invoke+e4
OLE32!SyncStubInvoke+61
OLE32!CCtxChnl::SendReceive+145
rpcrt4!NdrProxySendReceive+4c
rpcrt4!NdrClientCall2+4f5
rpcrt4!ObjectStublessClient+76
rpcrt4!ObjectStubless+f
XCHCENTRALNEG!DllCanUnloadNow+b6c5
OLEAUT32!DispCallFunc+15d
msvbvm60!BASIC_CLASS_Invoke+259
msvbvm60!BASIC_CLASS_Invoke+52
OLEAUT32!IDispatch_Invoke_Stub+6d
OLEAUT32!IDispatch_RemoteInvoke_Thunk+3c
rpcrt4!NdrStubCall2+604
rpcrt4!CStdStubBuffer_Invoke+c8
OLEAUT32!CStubWrapper::Invoke+9f
OLE32!SyncStubInvoke+61
OLE32!StubInvoke+a8
OLE32!CCtxComChnl::ContextInvoke+bb
OLE32!MTAInvoke+18
OLE32!STAInvoke+56
OLE32!AppInvoke+88
OLE32!ComInvokeWithLockAndIPID+2b5
OLE32!ComInvoke+41
OLE32!ThreadDispatch+21
OLE32!ThreadWndProc+101
USER32!UserCallWinProc+18
USER32!DispatchMessageWorker+2e4
USER32!DispatchMessageW+b
comsvcs!STAMessageWork:oWork+15 ..\inc\STAThred.h @ 244
comsvcs!STAThread::STAThreadWorker+423 .\stathred.cpp @ 650
KERNEL32!BaseThreadStart+52

Can anyone help me with this issue, or maybe looking in the right direction?

Best regards

--
Manuel Arbulu

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.