Last updated on JULY 05, 2017
Applies to:
Oracle Data Provider for .NET - Version 11.2.0.2 and laterMicrosoft Windows (32-bit)
***Checked for relevance on 28-Jan-2013***
Symptoms
While running a query from an ODP.NET application with a large amount of data (the exact amount was not specified). They intermittently get either an Access Violation exception or ORA-01024 invalid datatype in OCI call.
Here is the Access Violation error stack:
Exception object: 057c482c
Exception type: System.AccessViolationException
Message: Attempted to read or write protected memory. This is often an
indication that other memory is corrupt.
InnerException: <none>
StackTrace (generated):
SP IP Function
00000000 00000000
Oracle_DataAccess!Oracle.DataAccess.Client.OpsPrm.FreeOpoPrmCtx(Oracle.DataAcc
ess.Client.OpoPrmCtx*)+0x1
00C0E938 1339DE2A Oracle_DataAccess!Oracle.DataAccess.Client.OracleCommand.FreeNonCachedOpoPrmCt
x()+0xaa
00C0E99C 12F7244D
Oracle_DataAccess!Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean
, Boolean, System.Data.CommandBehavior)+0xf5d
00C0EB38 12F7130C
Oracle_DataAccess!Oracle.DataAccess.Client.OracleDataAdapter.Fill(System.Data.
DataSet, Int32, Int32, System.String, System.Data.IDbCommand,
System.Data.CommandBehavior)+0xcc
00C0EB94 6181AE0F
System_Data_ni!System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet)+0x5f
00C0EBC4 0E6693E7
ADP_EZLM_DA_Common!ADP.EZLM.DA.Common.DataManager.RunSqlReturnDS(ADP.EZLM.DA.C
ommon.DbConnectionInfo, System.String, System.Data.IDbDataParameter[])+0x117
00C0EC64 149FC81C
ADP_EZLM_DA_UserEmployee!ADP.EZLM.DA.UserEmployee.EmployeeDatesDAO.GetEmployee
DatesByEmployeeID(Int32, System.String)+0x8cc
00C0EE50 149FBD66
ADP_EZLM_Shared_Behavior!ADP.EZLM.Shared.Behavior.Associate.PositionServiceDat
eBehaviorImpl.GetServiceDates(System.String)+0x96
00C0EEE4 149FA320
ADP_EZLM_Shared_Behavior!ADP.EZLM.Shared.Behavior.Associate.PositionBehaviorIm
pl.GetSecondaryData(ADP.EZLM.Shared.Interfaces.Associate.DataItem.IPositionDat
aItem)+0x120
00C0EF78 149F67A1
ADP_EZLM_Shared_Behavior!ADP.EZLM.Shared.Behavior.Associate.PositionBehaviorIm
pl.GetPositionByEmployeeID(System.String)+0x71
00C0EFA4 149F652E
ADP_EZLM_Shared_Behavior!ADP.EZLM.Shared.Behavior.Associate.AssociateBehaviorI
mpl.GetAssociateByID(System.String, System.String, System.String,
System.String)+0x8e
00C0F01C 149F460F
ezLaborManagerNet!ezLaborManagerNet.UI4.Setup.Associate.Associate.LoadObjectFr
omDatabase()+0x48f
00C0F270 149F3F32
ezLaborManagerNet!ezLaborManagerNet.UI4.Setup.Associate.Associate.ProcessPostb
ackEvent()+0x72
00C0F2AC 149F3515
ezLaborManagerNet!ezLaborManagerNet.UI4.Setup.Associate.Associate.OnPreRender(
System.EventArgs)+0x205
00C0F404 672C7958
System_Web_ni!System.Web.UI.Control.PreRenderRecursiveInternal()+0x68
00C0F41C 672C5301
System_Web_ni!System.Web.UI.Page.ProcessRequestMain(Boolean, Boolean)+0x9c1
00C0F644 672C479D System_Web_ni!System.Web.UI.Page.ProcessRequest(Boolean,
Boolean)+0x8d
00C0F67C 672C46BF System_Web_ni!System.Web.UI.Page.
Exception type: System.AccessViolationException
Message: Attempted to read or write protected memory. This is often an
indication that other memory is corrupt.
InnerException: <none>
StackTrace (generated):
SP IP Function
00000000 00000000
Oracle_DataAccess!Oracle.DataAccess.Client.OpsPrm.FreeOpoPrmCtx(Oracle.DataAcc
ess.Client.OpoPrmCtx*)+0x1
00C0E938 1339DE2A Oracle_DataAccess!Oracle.DataAccess.Client.OracleCommand.FreeNonCachedOpoPrmCt
x()+0xaa
00C0E99C 12F7244D
Oracle_DataAccess!Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean
, Boolean, System.Data.CommandBehavior)+0xf5d
00C0EB38 12F7130C
Oracle_DataAccess!Oracle.DataAccess.Client.OracleDataAdapter.Fill(System.Data.
DataSet, Int32, Int32, System.String, System.Data.IDbCommand,
System.Data.CommandBehavior)+0xcc
00C0EB94 6181AE0F
System_Data_ni!System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet)+0x5f
00C0EBC4 0E6693E7
ADP_EZLM_DA_Common!ADP.EZLM.DA.Common.DataManager.RunSqlReturnDS(ADP.EZLM.DA.C
ommon.DbConnectionInfo, System.String, System.Data.IDbDataParameter[])+0x117
00C0EC64 149FC81C
ADP_EZLM_DA_UserEmployee!ADP.EZLM.DA.UserEmployee.EmployeeDatesDAO.GetEmployee
DatesByEmployeeID(Int32, System.String)+0x8cc
00C0EE50 149FBD66
ADP_EZLM_Shared_Behavior!ADP.EZLM.Shared.Behavior.Associate.PositionServiceDat
eBehaviorImpl.GetServiceDates(System.String)+0x96
00C0EEE4 149FA320
ADP_EZLM_Shared_Behavior!ADP.EZLM.Shared.Behavior.Associate.PositionBehaviorIm
pl.GetSecondaryData(ADP.EZLM.Shared.Interfaces.Associate.DataItem.IPositionDat
aItem)+0x120
00C0EF78 149F67A1
ADP_EZLM_Shared_Behavior!ADP.EZLM.Shared.Behavior.Associate.PositionBehaviorIm
pl.GetPositionByEmployeeID(System.String)+0x71
00C0EFA4 149F652E
ADP_EZLM_Shared_Behavior!ADP.EZLM.Shared.Behavior.Associate.AssociateBehaviorI
mpl.GetAssociateByID(System.String, System.String, System.String,
System.String)+0x8e
00C0F01C 149F460F
ezLaborManagerNet!ezLaborManagerNet.UI4.Setup.Associate.Associate.LoadObjectFr
omDatabase()+0x48f
00C0F270 149F3F32
ezLaborManagerNet!ezLaborManagerNet.UI4.Setup.Associate.Associate.ProcessPostb
ackEvent()+0x72
00C0F2AC 149F3515
ezLaborManagerNet!ezLaborManagerNet.UI4.Setup.Associate.Associate.OnPreRender(
System.EventArgs)+0x205
00C0F404 672C7958
System_Web_ni!System.Web.UI.Control.PreRenderRecursiveInternal()+0x68
00C0F41C 672C5301
System_Web_ni!System.Web.UI.Page.ProcessRequestMain(Boolean, Boolean)+0x9c1
00C0F644 672C479D System_Web_ni!System.Web.UI.Page.ProcessRequest(Boolean,
Boolean)+0x8d
00C0F67C 672C46BF System_Web_ni!System.Web.UI.Page.
Changes
Migrated from the Microsoft Provider for the Oracle Data Provider for .Net.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms