Issue with version 7.2.77 when dll not in GAC

Issue with version 7.2.77 when dll not in GAC

Postby enigma51 » Wed 03 Oct 2012 01:18

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()
enigma51
 
Posts: 18
Joined: Thu 02 Dec 2010 18:55

Re: Issue with version 7.2.77 when dll not in GAC

Postby MariiaI » Wed 03 Oct 2012 13:38

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/docs/Deployment.html
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Issue with version 7.2.77 when dll not in GAC

Postby enigma51 » Wed 10 Oct 2012 20:56

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>

.......
enigma51
 
Posts: 18
Joined: Thu 02 Dec 2010 18:55

Re: Issue with version 7.2.77 when dll not in GAC

Postby MariiaI » Thu 11 Oct 2012 13:02

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/docs/?deployment.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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Issue with version 7.2.77 when dll not in GAC

Postby enigma51 » Thu 11 Oct 2012 20:31

Found then issues devart.data was missing from directory
Thanks
enigma51
 
Posts: 18
Joined: Thu 02 Dec 2010 18:55

Re: Issue with version 7.2.77 when dll not in GAC

Postby MariiaI » Fri 12 Oct 2012 06:59

Glad to see that the problem was resolved. If you have any further questions, feel free to contact us.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Issue with version 7.2.77 when dll not in GAC

Postby enigma51 » Thu 18 Oct 2012 02:04

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.
enigma51
 
Posts: 18
Joined: Thu 02 Dec 2010 18:55

Re: Issue with version 7.2.77 when dll not in GAC

Postby MariiaI » Thu 18 Oct 2012 10:48

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)?
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Issue with version 7.2.77 when dll not in GAC

Postby enigma51 » Thu 18 Oct 2012 20:11

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
 
Posts: 18
Joined: Thu 02 Dec 2010 18:55

Re: Issue with version 7.2.77 when dll not in GAC

Postby enigma51 » Thu 18 Oct 2012 21:37

Not sure why but i rebuild the linq model by clicking refresh from database and now it works.
enigma51
 
Posts: 18
Joined: Thu 02 Dec 2010 18:55

Re: Issue with version 7.2.77 when dll not in GAC

Postby MariiaI » Mon 22 Oct 2012 15:00

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to dotConnect for Oracle