on 02-29-2008 11:10 AM
Hello all,
in a customer project we connected a Visual Fox Pro Database via OLE-DB UDS.
Whenever data is retrieved, a fatal error shows up:
Fatal Error: Error occurred while processing data stream, null
Although the data is retrieved correctly!
MII used: 11.5
UDS-Server: xMII OLE DB UDS, version 4.0.1.10
This is the log from the UDS-Server:
[02/29/2008-11:22:40.195] oleDB [P:4404, T:4792, Framework, ERROR] 0x0 {extra params}: {5} [LHDSChannelHandler.cpp @ 488, CLHDSChannelHandler::ExecuteIOCP]
[02/29/2008-11:22:40.195] oleDB [P:4404, T:4792, Framework, ERROR] 0x17009 Exception occured: pid = 5, original = 5, data = <ExecutionContext><param name="MODE" value="QUERY"/><param name="QUERY" value="SELECT artikelnr FROM artikel "/><param name="ENDDATE" value="1204280560164"/><param name="ROWCOUNT" value="100"/><param name="STARTDATE" value="1204276960164"/></ExecutionContext>. [LHDSChannelHandler.cpp @ 493, CLHDSChannelHandler::ExecuteIOCP]
********** Start of Exception Stack Trace **********
1) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, UDS, ] 0x0 HRESULT: 0x80004005 [Unspecified error] [BaseOleDbMode.h @ 1133, BaseOleDbMode<class COleDbQuery>::ProcessDynamicResults]
2) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, UDS, RETHROW] 0x0 Rethrowing exception. [BaseOleDbMode.h @ 1211, BaseOleDbMode<class COleDbQuery>::ProcessDynamicResults]
3) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, UDS, RETHROW] 0x0 Rethrowing exception. [Query.cpp @ 107, COleDbQuery::ExecuteOleDbMode]
4) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, UDS, RETHROW] 0x0 Rethrowing exception. [BaseOleDbMode.h @ 381, BaseOleDbMode<class COleDbQuery>::ExecuteMode]
5) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, UDS, RETHROW] 0x0 Rethrowing exception over COM. [LHDSUtil.h @ 1086, lhds::LHDSModeImpl<class COleDbQuery,struct ILHDSMode>::Execute]
6) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, UDS, RETHROW] 0x0 Rethrowing exception. [LHDSUtil.h @ 1124, lhds::LHDSModeImpl<class COleDbQuery,struct ILHDSMode>::Execute]
7) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, Framework, RETHROW] 0x0 Rethrowing exception over COM. [LHDSDispatcher.cpp @ 135, CLHDSDispatcher::CallMode]
8) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, UDS, RETHROW] 0x0 Rethrowing exception over COM. [LHDSUtil.h @ 893, lhds::LHDataServerImpl<class CLHOleDbDataServer>::Execute]
9) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, Framework, ] 0x0 Caught exception over a COM boundry. [LHDSChannelHandler.cpp @ 566, CLHDSChannelHandler::OnExecute]
10) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, Framework, RETHROW] 0x0 Rethrowing exception. [LHDSChannelHandler.cpp @ 574, CLHDSChannelHandler::OnExecute]
11) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, Framework, RETHROW] 0x0 Rethrowing exception. [LHDSChannelHandler.cpp @ 502, CLHDSChannelHandler::ExecuteIOCP]
12) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, Framework, RETHROW] 0x0 Rethrowing exception over COM. [LHDSChannelHandler.cpp @ 189, CLHDSChannelHandler::Execute]
13) [02/29/2008-11:22:40.210] oleDB [P:4404, T:4792, Host, HANDLED] 0x0 Handled exception. [ThreadPool.cpp @ 228, ThreadPool::ThreadProc]
************** End of Exception Trace **************
Any help is very much appreciated.
Regards,
Matthias
Edited by: Matthias Wald on Feb 29, 2008 12:12 PM
Matthias,
There is a new v4 UDS out on SMP, navigate to http://service.sap.com/swdc -> Entry By Application Group
Installations and Upgrades -> SAP xApps -> SAP XMII -> SAP XMII UDS -> XMII UDS -> XMII UDS 4.0
And download the supported release...the version you have was never released and you should not even have it; let alone be using it. The officially released version is 4.0.3.10
Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Salvatore,
thanks a lot for the information. I upgraded to version 4.0. It did the job.
Obviously the error was in the part of showing the effected rows as now the
affected rows are shown where the original error was.
The OLE-DB support is obviously better but the OPC drivers still do not work.
I will create a separate thread for this.
Regards,
Matthias
Matthias,
Are you sure it's not v4.3.10?
Also what are the UDS configuration settings?
My guess is that you have MTA set for the threading model and if you change it to STA the problem will go away.
Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Salvatore,
tried your suggestian but no luck, same error.
I checked the Version. It shows 4.0.1.10.
Is there a later version available?
UDS Settings are (apologize any misspellings):
Collect Requests false
Log Level Info
Maximum Concurrent Connections 1000
Pool Size 5
Port 8087
Runtime Mode Service
Service Dependencies Eventlog
Service Passowrd *******
Service Startup Manual
Service User .\LocalSystem
Shutdown Timeout 10
Stack Size 0
Threading Model MTA
Trusted Requesters
Use IOCP true
Connection String Provider=VFPOLEDB.1;Data Source=D:\Daten;Mode=Share Deny None;Extended Properties="";User ID="";Password="";Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE;DSN="";DELETED=True;CODEPAGE=1252;MVCOUNT=16384;ENGINEBEHAVIOR=90;TABLEVALIDATE=3;REFRESH=5;VARCHARMAPPING=False;ANSI=True;REPROCESS=5
Persistent Connectikon true
Show Affected Rows Minimal
Variant Representation String
I have changed MTA to STA and also tried other admin user for service without luck.
Any other hints?
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.