I have the Telerik Ultimate collection 2012 Q2 installed on my machine as well as Sitefinity 5.0.

The there is a difference between the versions of Open Access.

I'm trying to create a OA Class library to my solution to use in some custom code that I intend to run on my Sitefinity site.

I know that Sitefinity has to have the references appropriate to ites build, so I thought that the thing to do would be to create my OA Class library and then change the references in it to point to rthe same DLLs that the SitefinityWebSite project uses.

I did that but have found I get an error when I try and build but OA Class Library...

Error 31 Could not load file or assembly 'Telerik.OpenAccess.35.Extensions, Version=2012.2.607.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342' or one of its dependencies. General Exception (Exception from HRESULT: 0x80131500)
ExceptionString:
System.IO.FileLoadException: Could not load file or assembly 'Telerik.OpenAccess.35.Extensions, Version=2012.2.607.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342' or one of its dependencies. General Exception (Exception from HRESULT: 0x80131500)
File name: 'Telerik.OpenAccess.35.Extensions, Version=2012.2.607.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342' ---> System.Exception: The referenced assembly 'c:\MyPath\Telerik.OpenAccess.35.Extensions.dll' has the wrong version; expected Version=2012.2.607.1 but found Version=2011.3.1320.1.
   at Telerik.OpenAccess.SPI.AssemblyProvider.LoadFromReferences(String assemblyName)
   at Telerik.OpenAccess.SPI.AssemblyProvider.RefResolveEventHandler(Object sender, ResolveEventArgs args)
   at System.AppDomain.OnAssemblyResolveEvent(RuntimeAssembly assembly, String assemblyFullName)
   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)
   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
   at System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
   at System.Type.GetType(String typeName)
   at Telerik.OpenAccess.Sdk.Enhancer.Enhancer.CrossDomainRunImpl(AssemblyLoader assemblyLoader)
   at Telerik.OpenAccess.Sdk.Enhancer.EnhancerBase.CrossDomainRun()

You aren't...is essentially the problem we ALL face :/  It'll be endless problems (different enhancers, etc) and unsupported so don't even bother. 

I railed on this after the last release in which they shipped it with an internal version of OA not even downloadable from our accounts!  You could only get access to it by installing the full SDK, and then the resulting OA version was only usable inside of sitefinity.

The good news though is the SF teams and OA teams are now working together, so the release cycles are synced.  So when 5.1 hits, it'll ship with Q2 2012 of OA, you'll be fine then.  Until then however I'd revert back to the OA version that SF uses (which should now be available in your account)

...I would hope Ajax, Kendo are also synced, and someone wakes up and also includes a somewhat more recent Reporting version than like Q1-Q2 2011 (or whatever it has).

In all of my years working with Telerik and their products, that's the first case of bass-ackward thinking I've come across.

And that has just killed any hope I had of getting the work done I had planned in the timescale I had promised.

Bvgger!

--
Stuart

You could try assembly binding in the meantime, but I don't know if that'd work...when I sometimes mix OA assembly versions you sometimes get the enhancer version errors...

At least...its fixed now and the release cycles are synced, it'd just be nicer if Sitefinity wasn't +- 3-4 weeks after the latest Q release :/ 

We have built out some of our on controls and some have used OA for data. When a new version of SF came out, it would install the new OA on my system.  When I would go back to compile an older version of our code, I was faced with almost the same thing you are facing now.

Just got bit in the ass by this one while upgrading from 4.4 to 5.0.2860.  I dowloaded and installed the Sitefinity 5 Upgrade and the Sitefinity 5 SDK.  Next, I upgraded my SF project using the steps outlined in the Upgrade Guide, and build my solution.  The result:

@SteveV
Try this (in your webconfig under <configuration>:

**EDIT** or just re-compile whatever assemblies you used that reference that openaccess version, make sure their refs are pointing at 2011.3.1320.1 and build them again.

Steve,

Thanks for the very quick reply.  I added the config block you provided under the opening <configuration> tag in my web config.  Alas, no joy--I get the exact same error.

Regarding: "or just re-compile whatever assemblies you used that reference that openaccess version, make sure their refs are pointing at 2011.3.1320.1 and build them again."

That's the wierd part; I have a number of custom modules that are all part of my main Sitefinity project.  The few custom assemblies I am using don't have references to any OpenAccess assemblies.

-- Steve

The thing is, that error only really happens when you have an assembly in there which was compiled under the older version.  It's not really a problem with the upgrade tool, as that can't kick-off a build on the solution.

Have you gone though every project in there and pointed the OA references to the files in the SF bin folder?  You sure there aren't any pointing at the GAC\OA program files install folder, etc etc?

Well, I'm at a complete loss.  My solution only has one project in it.  I've confirmed at all of the references (other than those in the System namespace) point to my solution's bin folder.  I have references to 4 external binaries; 3 from projects under my control, I've opened the 3 projects and confirmed that they have no references to any OpenAccess assemblies and that none of the references in those projects have OpenAccess dependencies.  I've also opened all 4 assemblies in Telerik JustDecompile to confirmed that none of the references include any OpenAccess entries.

Any other thoughts?

Thanks--Steve

...any 3rd party controls in the bin folder that arn't "projects" (per say)?

Yes, there are several:

Facebook.dll (not sure why this is in my bin folder.  Removed - no change)
NHamcrest.dll (not sure why this is in my bin folder. Removed - no change)

*GhostscriptSharp.dll (Dotnet interop wrapper for gsdll64.dll - see below.  Removing causes missing reference errors)
gsdll64.dll (Native dll for GhostScript.  Removed - no change)
*PDFThumbnailer.dll (Used with GhostscriptSharp.dll to create thumbnail images of PDF docs.  Removing causes missing reference errors)
HiQPdf.dll (3rd party PDF document creation library.  Removed - no change)
*NLGTestResources.dll (Used with elearning module.  Removing causes missing reference errors)

The 3 assemblies noted with * are my assemblies from other projects which I have confirmed contain no OpenAccess references. 

Thanks -- Steve

More info:

I created a new SF5 project using the SF Project Manager. 

Next I added all of the the references that are included in the problem project.  Result: compiles fine.

Next, I added the handfull of assemblies listed in my previous post to the new project's bin folder.   Result: compiles fine.

Next, I added all of the folder and source files that are included in the problem project to the new SF5 project.  Result: compiles fine.

As far as I can tell, the folder structure and file content is identical in both projects.  The only noticable difference is the config files: the problem project includes custom control and custom module entries where the new SF5 project a single default config file (ProjectConfig.config). 

Not sure where to go from here since screwing with the config file versions when upgrading is generally frowned upon. 

[EDIT]
For the purposes of isolating the unlikely posibility that the config files were causing the issue, I added all of the config files from the problem project to the new SF5 project.  Result: compliles fine.

Anyone have any thoughts?

Thanks -- Steve

Found the problem.  I don't remember the specifics, but I recall runnning into problems creating custom modules when I first created the project last year.  I came across the following Telerik OpenAccess Developers Guide which included info about importing the OpenAccess.targets:

Import the OpenAccess.targets

The final step is to import the OpenAccess.targets. In order to do this:

1. Right-click on your project in the Solution Explorer and select Unload Project.
2. Again in the Solution Explorer, right-click on the unloaded project and select Edit ProjectName.csproj.
3. In your csproj file, find a line like this one:
   

   XML	Copy Code
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />

   And import the following code after the aforementioned line:
   

   XML	Copy Code
   <Import Condition="Exists('$(MSBuildExtensionsPath)\OpenAccess.targets')" Project="$(MSBuildExtensionsPath)\OpenAccess.targets" />

4. Save your changes. Right-click on your project in the Solution Explorer and select Reload Project.

SteveV,
    In my post earlier I talked about creating a separate folder to hold the files needed for the different versions of OA. The import statement that you added is where you would change the path to folder location that houses the version in which your site is compiled in.

Hi Richard,

Thanks for your detail reply.  I did read your previous post but since I was upgrading my SF project which also includes the custom modules using OA *and* I had installed the SF SDK which I assumed included the required OA assemblies, I also assumed that all of the OA assemblies would have been updated.

So, after installing the SF SDK it appears that none of the files in the "C:\Program Files (x86)\Telerik\OpenAccess ORM\bin" folder have been updated.  Is it normal that I would need to copy all of the OA files from the SF SDK to the OpenAccess.targets folder?

Also, the OA folder structure (C:\Program Files (x86)\Telerik\OpenAccess ORM) in the SF SDK looks nothing like the OpenAccess.targets folder structure.  Any idea which files and folder I need from the SF SDK OpenAccess--just the bin folder?

Sorry for all the questions but the docs are *** poor at best and mostly non-existant.

My custom modules do use OA so I'm curently stuck with ugly exceptions that look like:

I've never had to copy any of the newer files into the OA directory. I just copy the older files and store them in a secondary location to access for older sites. Once the SDK has been installed, it should update the files with the latest versions. Either the new SF install or the SF SDK install will also install the latest version of OA. (I think it is the SDK) That should copy all of the correct files you would need for the newer version.

Sorry--I'm being incoherent.  What I was trying to say is that my "C:\Program Files (x86)\Telerik\OpenAccess ORM" folder structure looks odd.  See that attached "openaccess orm folder.png" screen snip:

I have what appears to be folders from the SF 4.x SDK install dated 11/14/2011 which includes for following folders:
bin
documentation
dsl2008
dsl2010
dsw
sdk
src

There's also another folder named "ProductSdk" with a Date Modified value of 6/20/12 10:44 AM which certainly coincides with the date and time I installed the SF SDK.  The "ProductSdk" folder contents are completly different--see  "openaccess orm_productsdk folder.png".

So the question is which path do I need to point the "OpenAccessPath" variable to in the OpenAccess.target file?

Thanks -- Steve

The path in the OpenAccess.targets file needs to point to the directory in which the enhancer.exe and venhance.exe files are located. On my machine, these files are located in the sdk folder.

Got it sorted out finally.

This was the fix:

You can probably use the folder from the SF SDK:
C:\Program Files (x86)\telerik\Sitefinity 5.0\SDK\Content\Common\Dependencies

The folder path may be a little different depending on the install and SF version. The actual OA directory is from and OA install. I think if you use the SDK folder from the OA folder, you may actually need the OA SDK for the version in which you want to use. The SF SDK also gives you the the files needed for compilation as I showed above.

Hopefully that might clear up some confusion.

I'm no stranger to this issue myself, but a while back was able to put together a pretty decent process to work around it.

I fully intended to blog about it but never found the time. However, now that there's so much interest in it from this thread, I decided I should go ahead and push it out.

I published it on the Sitefinity Guru blog: Developing With Sitefinity When A Different Version of OpenAccess is Installed

Hope this is helpful!

Thanks Josh--very helpful.

Dredging up an old post but just got bit in the ass again upgrading from 5.1 to 5.2 (on my way to 6.0 sp1 via the 5.2>5.4>6.0 upgrade madness).  Telerik no longer offers the older versions of OpenAccess for download so Josh's solution no longer works.  Anyone have any ideas?

Thanks -- Steve

Hi,

If you are going to upgrade to 6.0 for which the SDK is available to download (as its the latest version) I suggest disabling the module until you upgrade sitefintiy to 6.0, here is a teporary FTP where you can download SDK for 5.2, 5.3, 5.4

Set FTP in Active Mode!
IP address: 82.103.64.22
Username: Sitefintiy51SDK
Password: Ya]$8#R$ok#
------------------------------------------
Please keep in mind that the user account will expire in 15 days and all the files in the client folder will be deleted in 15 days

Regards,
Stanislav Velikov
Telerik

Hi Stanislav,

We have about 10 clients with custom modules we look after, all across various versions and although we try to convince them to stay up with the latest release most won't until they really have to or we build the cost into some other work we do.

This is a major problem and I don't see the logic here as to why Telerik are not providing us permanent access to the SDK dependencies. If you download a SDK for say 5.2 to upload a 5.1 project when you run the installer it says "please use the latest version" and then quits.

What is so hard about maintain a ZIP of JUST the SDK dependencies for each version somewhere under our Telerik accounts so us developers can upgrade our customers? Why the 15 day limit?????? We don't need all the SDK just the dependancies folder.... sounds easy!

Can you raise this with the team. It shouldn't take days to upgrade our customers. On this particular project I am now up to day 5.

Right now I am upgrading a 5.0 to 5.1.3450 and I can't get hold of the right SDK dependancies anywhere!!!!!

I have tried to connect to the FTP that you created to see whether that SDK for 5.1 just happens to be in there and it just times out on getting the dir listing... yep it's on active mode.

Thanks,

Seth

Hi,

Got into the SDK ftp... all that is in there is: Sitefinity_SDK_4.1.1395.1.msi

Has something gone wrong?

Seth

Sorry, but this just ins't practical.  I can't disable all my OpenAccess dependant modules while I do the 3 required upgrades from 5.1>6.0.  Support has suggested I copy my production database to my dev machine, do all of the upgrades on my dev machine then copy everything, including the databse back to my production server.

How is this a viable solution?  All database updates that occur on my production server will be overwritten by the older upgraded version of the database.  This includes ecommerce orders, user specific content changes, etc..  Our site provides users with specialty training videos that qualify for continuing education credits. Videos are served from a CDN and have protected access. The user purchases access to the videos, some of which are several hours long. Once the ecommerce transaction is completed, access to video is automatically added to the user's available digital content along with a test, downloadable materials, etc. The user has 72 access to the video from the time they first start watching it. The user can choose to watch the entire video in one session or across many session so long as they comple the video within 72 hours from the first time they press play.

Since these videos qualify for continuing education credits we must be able to ensure they have watched the video in its entirety. Viewing progress is tracked and stored in the database. The user can "rewind" the video as much as they want but can only "fast foward" up to their maximum viewing progress. Once the user has finished viewing the video, they must take, and pass, an online test. The test can also be taken across multiple session in one session. They are allowed to take the test as many times as is required to pass. Test progress is also tracked in a database record. Once the test is completed it is submitted to our testing body.

Now, imaging what would happen if multiple people purchased access to a training video and started taking the test on the production database while we were performing the upgrade in the off-line version of the same database. Best case, we're looking at perhaps 6 hours to complete the 5.2>5.4>6.0 upgrades, test, and ensure the front and backend pages and content all work properly.

What happens when we copy the offline version back to the production server? All online orders, video viewing progress, test progress, test submissions, etc, that occurred on the production database are now overwritten. Not an acceptable solution.

Support's suggestion was that we monitor changes to the database, then encorporate them into the upgraded database.  Umm, how the hell do I do that? 

Telerik really needs to think about the impact the upgrade process has on its users.  I don't have the tools, time, or budget to continue to upgrade if the process is this convoluted and unreliable.  Read this post is you're curious about my latest "upgrade" experience.

Steve