cancel
Showing results for 
Search instead for 
Did you mean: 

Fatal Error while retrieving data from Visual Fox Pro using OLE-DB UDS

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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

Former Member
0 Kudos

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

Answers (1)

Answers (1)

0 Kudos

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

Former Member
0 Kudos

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?