"Telerik.OpenAccess.MySql.Data" Reference Error

Posted by Community Admin on 25-Apr-2011 00:00

The Visual Studio projects created by the Sitefinity Project Manager include an invalid reference. Opening a project in Visual Studio and building it results in the following build error:

c:\Windows\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(1360,9): warning MSB3245: Could not resolve this reference. Could not locate the assembly "Telerik.OpenAccess.MySql.Data". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors.

The "bin" folder does not include the "Telerik.OpenAccess.MySql.Data.dll" file the reference is set to use. To address the error, the bad reference can be deleted. Note that there is a separate "MySql.Data" reference set to use an "MySql.Data.dll" file that does exist.

This bug exists in Sitefinity 4.1, Sitefinity 4.0 SP1, and Sitefinity 4.0, in both generated projects an the "_EmptyProject" template.

Posted by Community Admin on 26-Apr-2011 00:00

Hi Mike,

I saw the issue and yes, the following reference should be removed for now if you experience compilation issues.

<Reference Include="Telerik.OpenAccess.MySql.Data, Version=2010.2.1013.8, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>bin\Telerik.OpenAccess.MySql.Data.dll</HintPath>
    </Reference>

Kind regards,
Ivan Dimitrov
the Telerik team

Posted by Community Admin on 18-May-2011 00:00

Had this problem. Did a global search for Telerik.OpenAccess.MySql.Data reference and never found any. So I removed the referenced assembly and built anyways.

Now, I've copied the DLL to the new 4.1 project and I'm getting this error, please help.

Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

Source Error:


            An unhandled exception was generated during the execution of the current
            web request. Information regarding the origin and location of the
            exception can be identified using the exception stack trace below.

Stack Trace:

[ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.]
   DynamicModule.ns.Wrapped_OpenAccessMetaDataProvider_ec1f975d253c4301b4b62df7c81519f3.Initialize(String providerName, NameValueCollection config, Type managerType) +283
   Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +2706
   Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +117
   Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +407
   Telerik.Sitefinity.Data.ManagerBase`1..ctor(String providerName, String transactionName) +249
   Telerik.Sitefinity.Data.ManagerBase`1..ctor() +37
   Telerik.Sitefinity.Data.Metadata.MetadataManager..ctor() +28

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) +98
   System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +241
   System.Activator.CreateInstance() +103
   Telerik.Sitefinity.Data.ManagerBase`1.GetManager(String providerName, String transactionName) +123
   Telerik.Sitefinity.Data.ManagerBase`1.GetManager() +72
   Telerik.Sitefinity.Data.Metadata.MetadataManager.GetManager() +27
   Telerik.Sitefinity.Services.SystemManager.Initialize() +196
   Telerik.Sitefinity.Abstractions.Bootstrapper.RegisterRoutes(RouteCollection routes) +319
   Telerik.Sitefinity.Abstractions.Bootstrapper.Bootstrap() +234
   Telerik.Sitefinity.Web.SitefinityHttpModule.Init(HttpApplication context) +42
   System.Web.Routing.UrlRoutingModule.System.Web.IHttpModule.Init(HttpApplication application) +10
   System.Web.HttpApplication.InitModulesCommon() +80
   System.Web.HttpApplication.InitModules() +43
   System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +828
   System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +304
   System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +107
   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +327

Posted by Community Admin on 25-May-2011 00:00

Hi Travis,

Maybe your problem is not related to Telerik.OpenAccess.MySql.Data, at least it is not mentioned in the error description. Let me know if I am missing something.
Can you send us the log files, generated around the time this exception is thrown? They are located in ~/App_Data/Sitefinity/Logs folder.

Greetings,
Vlad
the Telerik team

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Posted by Community Admin on 23-Dec-2011 00:00

I am getting similar error in 4.3. Please see below.

Thanks.

Sebastian

----------------------------------------

Timestamp: 12/23/2011 9:06:37 PM

Message: HandlingInstanceID: d7846167-415d-4866-8814-71e969c5b003

An exception of type 'System.Reflection.ReflectionTypeLoadException' occurred and was caught.

---------------------------------------------------------------------------------------------

12/23/2011 13:06:37

Type : System.Reflection.ReflectionTypeLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Message : Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

Source : mscorlib

Help link :

Types : System.Type[]

LoaderExceptions : System.Exception[]

Data : System.Collections.ListDictionaryInternal

TargetSite : System.Type[] GetTypes(System.Reflection.RuntimeModule)

Stack Trace : at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)

at System.Reflection.Assembly.GetTypes()

at System.Data.Metadata.Edm.ObjectItemConventionAssemblyLoader.LoadTypesFromAssembly()

at System.Data.Metadata.Edm.ObjectItemAssemblyLoader.Load()

at System.Data.Metadata.Edm.AssemblyCache.LoadAssembly(Assembly assembly, Boolean loadReferencedAssemblies, ObjectItemLoadingSessionData loadingData)

at System.Data.Metadata.Edm.AssemblyCache.LoadAssembly(Assembly assembly, Boolean loadReferencedAssemblies, KnownAssembliesSet knownAssemblies, EdmItemCollection edmItemCollection, Action`1 logLoadMessage, Object& loaderCookie, Dictionary`2& typesInLoading, List`1& errors)

at System.Data.Metadata.Edm.ObjectItemCollection.LoadAssemblyFromCache(ObjectItemCollection objectItemCollection, Assembly assembly, Boolean loadReferencedAssemblies, EdmItemCollection edmItemCollection, Action`1 logLoadMessage)

at System.Data.Metadata.Edm.ObjectItemCollection.ExplicitLoadFromAssembly(Assembly assembly, EdmItemCollection edmItemCollection, Action`1 logLoadMessage)

at System.Data.Metadata.Edm.MetadataWorkspace.ExplicitLoadFromAssembly(Assembly assembly, ObjectItemCollection collection, Action`1 logLoadMessage)

at System.Web.UI.WebControls.EntityDataSourceView.ConstructContext()

at System.Web.UI.WebControls.EntityDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)

at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)

at Telerik.Web.UI.RadComboBox.PerformSelect()

at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()

at Telerik.Web.UI.RadComboBox.OnPreRender(EventArgs e)

at System.Web.UI.Control.PreRenderRecursiveInternal()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Additional Info:

MachineName : SEBASTIAN-W7

TimeStamp : 12/23/2011 9:06:37 PM

FullName : Telerik.Sitefinity.Utilities, Version=4.3.2019.0, Culture=neutral, PublicKeyToken=b28c218413bdf563

AppDomainName : db7e1134-24-129691479061521672

ThreadIdentity : admin

WindowsIdentity : PSMFC.ORG\SDudek

Requested URL : localhost:28452/.../

Category: ErrorLog

Priority: 0

EventId: 90000

Severity: Error

Title:Enterprise Library Exception Handling

Machine: MD1

App Domain: db7e1134-24-129691479061521672

ProcessId: 3844

Process Name: C:\Sitefinity.exe

Thread Name:

Win32 ThreadId:12872

Extended Properties:

----------------------------------------

Posted by Community Admin on 26-Dec-2011 00:00

Hi,

Could you check if you haven't removed any dll from your bin folder? This will happen if you perform rebuild. The error says that there are missing assemblies that couldn't be loaded.

All the best,
Ivan Dimitrov
the Telerik team

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Posted by Community Admin on 29-Dec-2011 00:00

Hello Ivan,

When I make considerable changes to my solution, I clean it then recreate the bin folder with dlls from sitefinity's "empty project" bin folder.
Otherwise I just do a build.

Thank you,
Sebastian

Posted by Community Admin on 30-Dec-2011 00:00

Hi,

The error says that there are missing assemblies that couldn't be loaded, so you are missing a dll or reference.

All the best,
Ivan Dimitrov
the Telerik team

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Posted by Community Admin on 30-Dec-2011 00:00

It was the Telerik.Sitefinity.MigrationContracts.dll and Micorsoft.Http.dll that would be missing after rebuild. I added reference to both of them in my VS10 and now it is working.

Sebastian

This thread is closed

All Replies

Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.