Issue with version 7.2.77 when dll not in GAC

[enigma51]

Hi We are getting the following error on our application when we try and run it on a machine that dotconnect for oracle is not installed into the gac. The files are in the application directory as required.

I should point out that this error is only displayed in the eventviewer.


Application: WMSToSap.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.TypeInitializationException
Stack:
at Devart.Data.Oracle.OracleConnection..ctor()
at Devart.Data.Oracle.Linq.Provider.OracleDataProvider.CreateConnection()
at Devart.Data.Linq.DataProvider.Initialize(System.Object)
at Devart.Data.Oracle.Linq.Provider.OracleDataProvider.Initialize(System.Object)
at Devart.Data.Linq.DataProvider.a(Devart.Data.Linq.Engine.ci, System.Object)
at Devart.Data.Linq.DataContext.a(System.Object, Devart.Data.Linq.Mapping.MappingSource, System.Type)
at Devart.Data.Linq.DataContext..ctor(System.String, Devart.Data.Linq.Mapping.MappingSource)
at WMSToSapCns.WMS_Linq..ctor()
at WMSToSap.frm_Main..ctor()
at WMSToSap.Program.Main()

[MariiaI]

Please check the path from which the assemblies are loaded in your application.
Perform the following:
1. Start debugging your application.
2. In Visual Studio open Debug > Windows > Modules. Find the Devart assemblies and check that they are loaded from the directory you've copied the assemblies to (see the column "Path").

Also, please check whether all the necessary assemblies have been copied to the bin folder (Devart.Data.dll, Devart.Data.Oracle.dll, Devart.Data.Linq.dll and Devart.Data.Oracle.Linq.dll).

For more information please refer to:
http://www.devart.com/linqconnect/docs/Deployment.html
http://www.devart.com/dotconnect/oracle ... yment.html

[enigma51]

Hi we have looked at your documentation and also upgrade to version 7.2.96 but we can seem to get the application to not read the assemblies from the GAC.

Its an linqconnect forms application and the config file looks like this.

<?xml version="1.0"?>
<configuration>
<configSections>
<sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<section name="WMSToSap.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false"/>
</sectionGroup>
</configSections>
<system.data>
<DbProviderFactories>
<remove invariant="Devart.Data.Oracle" />
<add name="dotConnect for Oracle" invariant="Devart.Data.Oracle" description="Devart dotConnect for Oracle" type="Devart.Data.Oracle.OracleProviderFactory, Devart.Data.Oracle, Version=7.2.96.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</DbProviderFactories>
</system.data>

.......

[MariiaI]

We couldn't reproduce this issue.
As for your config file, it looks correct, you registered the provider in DbProviderFactories as it described here http://www.devart.com/dotconnect/oracle ... yment.html

After upgrading to the 7.2.96 version, make sure that you have deployed the following assemblies:
Devart.Data.dll - 5.0.555.0
Devart.Data.Oracle.dll - 7.2.96.0
Devart.Data.Linq.dll - 4.1.101.0
Devart.Data.Oracle.Linq.dll - 4.1.101.0

Also, please specify the InnerException of the System.TypeInitializationException, that you mentioned in your first post, and check which assemblies are loaded in your application (including their version and path) as described above.

Looking forward to your reply.

[enigma51]

Found then issues devart.data was missing from directory
Thanks

[MariiaI]

Glad to see that the problem was resolved. If you have any further questions, feel free to contact us.

[enigma51]

Hi We have another application that is causing us some not in GAC issues

We have two other application that has worked fine once we included devart.data.dll but this application is giving us the following error in the eventviewer

Application: IIT.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.FileLoadException
Stack:
at System.Reflection.CustomAttribute._CreateCaObject(System.Reflection.RuntimeModule, System.IRuntimeMethodInfo, Byte**, Byte*, Int32*)
at System.Reflection.CustomAttribute.CreateCaObject(System.Reflection.RuntimeModule, System.IRuntimeMethodInfo, IntPtr ByRef, IntPtr, Int32 ByRef)
at System.Reflection.CustomAttribute.GetCustomAttributes(System.Reflection.RuntimeModule, Int32, Int32, System.RuntimeType, Boolean, System.Collections.IList, Boolean)
at System.Reflection.CustomAttribute.GetCustomAttributes(System.RuntimeType, System.RuntimeType, Boolean)
at System.RuntimeType.GetCustomAttributes(System.Type, Boolean)
at Devart.Data.Linq.Mapping.r.GetAttribute[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Type, Boolean)
at Devart.Data.Linq.Mapping.r.GetContextAttribute[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]()
at Devart.Data.Linq.Mapping.r.a()
at Devart.Data.Linq.Mapping.q.h()
at Devart.Data.Linq.Mapping.MappingSource.a(System.Type)
at Devart.Data.Linq.Mapping.MappingSource.GetModel(System.Type)
at Devart.Data.Linq.DataContext.a(System.Object, Devart.Data.Linq.Mapping.MappingSource, System.Type)
at Devart.Data.Linq.DataContext..ctor(System.String, Devart.Data.Linq.Mapping.MappingSource)
at wms_lnq_Cns.WMS_Linq..ctor()
at IITWin.frm_Main..ctor()
at IITWin.Program.Main()


I have checke the license made sure all the dlls are in the directory but we still getting this.

[MariiaI]

It seems that one of the assemblies couldn't be loaded to your application. Have you checked the paths from which the assemblies are loaded?
If not, please check it when debugging your application (open Debug > Windows > Modules, find the Devart assemblies and check that they are loaded from the directory you've copied the assemblies to (see the column "Path")).
Also, could you please specify if there are some additional details in the Properties of the System.IO.FileLoadException (e.g., FileName)?

[enigma51]

Two problems with that

If i run it with debug it always starts with the GAC files. But i have checked all the devart libaries noted in modules are in the directory. On the development machine it runs all fine.

The error only happens on our test machine. (No visual studio and no devart) and the error is only in the eventvwr so no cant see more of the exception as what i have posted.

this is from the debug modules
Devart.Data.dll C:\Windows\assembly\GAC_MSIL\Devart.Data\5.0.555.0__09af7300eec23701\Devart.Data.dll No No No symbols loaded. 25 5.0.555.0 4/10/2012 21:23 04FC0000-05004000 [5640] IIT.vshost.exe: Managed (v4.0.30319)
Devart.Data.Linq.dll C:\Windows\assembly\GAC_MSIL\Devart.Data.Linq\4.1.101.0__09af7300eec23701\Devart.Data.Linq.dll No No No symbols loaded. 19 4.1.101.0 4/10/2012 21:26 06200000-062AE000 [5640] IIT.vshost.exe: Managed (v4.0.30319)
Devart.Data.Oracle.dll C:\Windows\assembly\GAC_MSIL\Devart.Data.Oracle\7.2.96.0__09af7300eec23701\Devart.Data.Oracle.dll No No No symbols loaded. 21 7.2.96.0 4/10/2012 21:23 06BE0000-06CF2000 [5640] IIT.vshost.exe: Managed (v4.0.30319)
Devart.Data.Oracle.Linq.dll C:\Windows\assembly\GAC_MSIL\Devart.Data.Oracle.Linq\4.1.101.0__09af7300eec23701\Devart.Data.Oracle.Linq.dll No No No symbols loaded. 20 4.1.101.0 4/10/2012 21:26 02080000-020A4000 [5640] IIT.vshost.exe: Managed (v4.0.30319)


I can confirm that all 4 files are in the directory of the application on the test machine.

[enigma51]

Not sure why but i rebuild the linq model by clicking refresh from database and now it works.

[MariiaI]

Glad to see that the problem was resolved. If you have any further questions, feel free to contact us.
Possibly, there was an old assembly in the bin folder and it was updated after the model was refreshed. On the development machine all the assemblies were loaded from the GAC, while on the test machine the assemblies were loaded from the bin folder including the old one.