[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OP

Posted by James Cates on 14-Jul-2016 10:10

We are getting up to thousands of these per day when doing simple UPDATE or INSERT calls to PROGRESS from a .Net web application using the ODBC drivers.

Progress OpenEdge Server Version: 11.5.1 64bit

ODBC drivers version: Connection String:DRIVER={Progress OpenEdge 10.1C driver}; 32 bit

Update: I have always tried with the 11.5.1 32bit client drivers - same problem.

Anyone have any ideas? There is some replication going on between our MS SQL and OpenEdge servers, as well. A lot of this seems to have begun after replication was implemented.

These happen less often during days when no major batch jobs are running, of course, but blow up exponentially on batch run days.

Example error:

2016-07-14 09:43:08 [jcates] - 

Full Exception Message: Machine:JCATES1
User:jcates
Process:BackOfficeBatch.vshost
ThreadIdentityName:
ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Error in Stored Procedure Execution. (7853)
at RetailDataLLC.DataAccess.DAL.MultiCommand.ExecuteNonQueryWithLockRetry() in d:\Projects\RetailDataLegacy\RetailDataLegacy-Dev\RetailDataLLC.DataAccess\DAL\MultiCommand.cs:line 1149
at RetailDataLLC.DataAccess.DAL.MultiCommand.ExecuteNonQuery(Boolean KeepTransactionAlive) in d:\Projects\RetailDataLegacy\RetailDataLegacy-Dev\RetailDataLLC.DataAccess\DAL\MultiCommand.cs:line 743
~~~~~~~~~~~~~~~~~~~~~~~~~~

Current Command Info: CommandTextFile:Insert_SKUSubset.txt
Query:INSERT INTO PUB.SKUSubset(SubsetID, SubsetCode, CorpID, Name, AddedOn, AddedBy, IsActive)
VALUES(?, ?, ?, ?, Now(), ?, ?)
(param values redacted)

Connection String:DSN=W4Prod_32;HOST=########;DB=###;UID=######;PWD=##########;PORT=8150;
SQLFilesPath:C:\Projects\SQL

All Replies

This thread is closed