1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / "Telerik.OpenAccess.MySql.Data" Reference Error

"Telerik.OpenAccess.MySql.Data" Reference Error

9 posts, 1 answered
  1. Mike
    Mike avatar
    40 posts
    Registered:
    24 Jun 2010
    25 Apr 2011
    Link to this post
    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.
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    26 Apr 2011
    Link to this post
    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

    Answered
  3. Travis
    Travis avatar
    10 posts
    Registered:
    13 Dec 2010
    18 May 2011
    Link to this post
    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
    
  4. Vlad
    Vlad avatar
    498 posts
    Registered:
    19 Jun 2017
    25 May 2011
    Link to this post
    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
  5. Sebastian
    Sebastian avatar
    21 posts
    Registered:
    06 Sep 2011
    23 Dec 2011
    Link to this post
    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.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       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 : http://localhost:28452/sf_New20111222/ManageRequests/


    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: 
    ----------------------------------------
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    26 Dec 2011
    Link to this post
    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
  7. Sebastian
    Sebastian avatar
    21 posts
    Registered:
    06 Sep 2011
    29 Dec 2011
    Link to this post
    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
  8. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    30 Dec 2011
    Link to this post
    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
  9. Sebastian
    Sebastian avatar
    21 posts
    Registered:
    06 Sep 2011
    30 Dec 2011
    Link to this post
    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
9 posts, 1 answered