ACE.OLEDB.12.0 Clashes my app sometimes when executed.

Hiago Souza 1 Reputation point
2022-11-16T01:41:02.7+00:00

I have been using OLEDB with an RPA tool(BluePrism) and sometimes causes a Exception that makes the app to clash. Checking the Event Viewer, I´ve found this exeception:

Application: Automate.exe  
Framework Version: v4.0.30319  
Description: The process was terminated due to an unhandled exception.  
Exception Info: System.AccessViolationException  
   at System.Data.OleDb.DataSourceWrapper.InitializeAndCreateSession(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.SessionWrapper ByRef)  
   at System.Data.OleDb.OleDbConnectionInternal..ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)  
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection)  
   at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection, System.Data.Common.DbConnectionOptions)  
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionPoolGroup, System.Data.Common.DbConnectionOptions)  
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(System.Data.Common.DbConnection, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal, System.Data.ProviderBase.DbConnectionInternal ByRef)  
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions)  
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions)  
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory)  
   at System.Data.OleDb.OleDbConnection.Open()  
   at Data___OLEDB_Extended.Open(System.String)  
  
Exception Info: System.Reflection.TargetInvocationException  
   at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)  
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(System.Object, System.Object[], System.Object[])  
   at System.Reflection.RuntimeMethodInfo.Invoke(System.Object, System.Reflection.BindingFlags, System.Reflection.Binder, System.Object[], System.Globalization.CultureInfo)  
   at BluePrism.AutomateProcessCore.Compilation.MethodInvoker.InvokeMethod(System.Object, System.String, BluePrism.AutomateProcessCore.Argument[], BluePrism.AutomateProcessCore.Argument[])  
   at BluePrism.AutomateProcessCore.CompilerRunner.Execute(BluePrism.AutomateProcessCore.Stages.CodeStage, BluePrism.AutomateProcessCore.ArgumentList, BluePrism.AutomateProcessCore.ArgumentList, System.String ByRef)  
   at BluePrism.AutomateProcessCore.Stages.CodeStage.Execute(System.Guid ByRef, BluePrism.AutomateProcessCore.CompoundLoggingEngine)  
   at BluePrism.AutomateProcessCore.BluePrismProcess.r(BluePrism.AutomateProcessCore.ProcessBreakpointInfo ByRef, Boolean)  
   at BluePrism.AutomateProcessCore.BluePrismProcess.RunAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction, BluePrism.AutomateProcessCore.ProcessBreakpointInfo ByRef, Boolean)  
   at BluePrism.AutomateProcessCore.BluePrismProcess.RunAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction)  
   at BluePrism.AutomateProcessCore.VBO.DoDoAction(System.String, BluePrism.AutomateProcessCore.ProcessStage, BluePrism.AutomateProcessCore.ArgumentList, BluePrism.AutomateProcessCore.ArgumentList ByRef)  
   at BluePrism.AutomateProcessCore.BusinessObject.DoAction(System.String, BluePrism.AutomateProcessCore.ProcessStage, BluePrism.AutomateProcessCore.ArgumentList, BluePrism.AutomateProcessCore.ArgumentList ByRef)  
   at BluePrism.AutomateProcessCore.Stages.ActionStage.Execute(System.Guid ByRef, BluePrism.AutomateProcessCore.CompoundLoggingEngine)  
   at BluePrism.AutomateProcessCore.BluePrismProcess.r(BluePrism.AutomateProcessCore.ProcessBreakpointInfo ByRef, Boolean)  
   at BluePrism.AutomateProcessCore.BluePrismProcess.RunAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction, BluePrism.AutomateProcessCore.ProcessBreakpointInfo ByRef, Boolean)  
   at AutomateUI.ctlProcessViewer.ExecuteAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction)  
   at AutomateUI.ctlProcessViewer.DebugAction(BluePrism.AutomateProcessCore.Processes.ProcessRunAction, Boolean)  
   at AutomateUI.frmProcess.evhDoStepOver(System.Object, System.EventArgs)  
   at System.Windows.Forms.ToolStripItem.RaiseEvent(System.Object, System.EventArgs)  
   at System.Windows.Forms.ToolStripButton.OnClick(System.EventArgs)  
   at System.Windows.Forms.ToolStripItem.HandleClick(System.EventArgs)  
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(System.Windows.Forms.MouseEventArgs)  
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(System.EventArgs, System.Windows.Forms.ToolStripItemEventType)  
   at System.Windows.Forms.ToolStripItem.FireEvent(System.EventArgs, System.Windows.Forms.ToolStripItemEventType)  
   at System.Windows.Forms.ToolStrip.OnMouseUp(System.Windows.Forms.MouseEventArgs)  
   at System.Windows.Forms.Control.WmMouseUp(System.Windows.Forms.Message ByRef, System.Windows.Forms.MouseButtons, Int32)  
   at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)  
   at System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef)  
   at System.Windows.Forms.ToolStrip.WndProc(System.Windows.Forms.Message ByRef)  
   at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)  
   at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)  
   at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)  
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG ByRef)  
   at System.Windows.Forms.Application+ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr, Int32, Int32)  
   at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Int32, System.Windows.Forms.ApplicationContext)  
   at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Int32, System.Windows.Forms.ApplicationContext)  
   at System.Windows.Forms.Application.RunDialog(System.Windows.Forms.Form)  
   at System.Windows.Forms.Form.ShowDialog(System.Windows.Forms.IWin32Window)  
   at System.Windows.Forms.Form.ShowDialog()  
   at AutomateUI.BPApplication.Start(System.String[])  
   at Automate.Program.Main(System.String[])  

I am using the Microsoft Access Database Engine 2016 Redistributable 32 bit version.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,596 questions
{count} votes