- Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done

[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.

[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

[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.

[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.