J
James Cates
Guest
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
RIVER={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 StringSN=W4Prod_32;HOST=########;DB=###;UID=######;PWD=##########;PORT=8150; SQLFilesPath:C:\Projects\SQL
Continue reading...
RIVER={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 StringSN=W4Prod_32;HOST=########;DB=###;UID=######;PWD=##########;PORT=8150; SQLFilesPath:C:\Projects\SQLContinue reading...