Page 1 of 1
- Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
Posted: Mon 07 Apr 2014 03:09
by sir.wally.lewis
I am using latest Devart UNIDAC version 5.2.7 as of today.
According to the release notes this error is fixed.
But.
Large amounts of these errors are being generated what to do?
- Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. {C8B522BA-5CF3-11CE-ADE5-00AA0044773D} [0] := $1. PropId := 237
This is critically URGENT!
please help.

Re: - Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
Posted: Mon 07 Apr 2014 10:28
by AlexP
Hello,
Please specify the case, when this problem occurs: at the moment of connection to the database, query execution, etc. Also, please create a small sample demonstrating the problem and send it to alexp*devart*com
Re: - Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
Posted: Tue 08 Apr 2014 01:52
by sir.wally.lewis
Could it be that this code is not thread safe?
ie. "SQL Server" provider.
As I have no failures when I run other code that writes to "SQL Server" not in a threaded model.
It is quite difficult to create a live test bed environment.
As I am writing to a 3rd party database.
Errors this morning are:
<9>1 2014-04-08T07:09:03.527+08:00 - - Assertion failure (C:\V2\sources\3rdparty\Devart\UniDAC\Source\UniProviders\SQLServer\OLEDBAccessUni.pas, line 13526)
<9>1 2014-04-08T07:09:03.527+08:00 - - Assertion failure (C:\V2\sources\3rdparty\Devart\UniDAC\Source\UniProviders\SQLServer\OLEDBAccessUni.pas, line 13526)
<9>1 2014-04-08T07:54:43.447+08:00 - - Assertion failure (C:\V2\sources\3rdparty\Devart\UniDAC\Source\UniProviders\SQLServer\OLEDBAccessUni.pas, line 2715)
<9>1 2014-04-08T07:59:17.392+08:00 - - Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. {C8B522BA-5CF3-11CE-ADE5-00AA0044773D} [0] := $1. PropId := 237
<9>1 2014-04-08T08:02:18.945+08:00 - - List index out of bounds (0)
Kind Regards,
Robert.
Re: - Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
Posted: Wed 09 Apr 2014 11:33
by Dimon
This problem can arise in a multithreaded application.
SDAC can work in multithreaded applications, but the restriction is that you cannot use one component for more than one thread simultaneously.
Please check that you don't use one connection for more than one thread simultaneously.