Licensing issue when deploying Entity Framework project

Licensing issue when deploying Entity Framework project

Postby PerryD » Wed 19 Aug 2009 22:23

Here is my application configuration from top to bottom: webapp -> business logic -> data access -> entity framework data model -> oracle.

Like everyone else, this runs fine locally. Then when i go to deploy i get the following stack trace:
Code: Select all
2009-08-19 03:46:21 [Service.Global] DEBUG (null) - Stack trace follows
System.Data.EntityException: The underlying provider failed on Open. ---> Devart.Data.Oracle.OracleException: License not valid due to the problems with dotConnect for Oracle installation.
   at Devart.Data.Oracle.OracleConnection.Open()
   at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
   --- End of inner exception stack trace ---
   at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
   at System.Data.EntityClient.EntityConnection.Open()
   at System.Data.Objects.ObjectContext.EnsureConnection()
   at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at WaterRights.DataAccessObjects.SummaryDao.GetSummaryByWRNumber(String wrNumber) in d:\source\WaterRights\DataAccessObjects\SummaryDao.cs:line 47
   at WaterRights.BusinessLogic.SummaryActions.GetWaterRightSummaryByWrNumber(String wrNumber) in d:\source\WaterRights\BusinessLogic\SummaryActions.cs:line 39
   at Service.Controllers.SummaryController.DoProcessRequest(IExecutionContext context) in d:\source\WaterRights\Service\Controllers\SummaryController.cs:line 51
   at Bistro.Controllers.AbstractController.ProcessRequest(HttpContextBase context, IContext requestContext)
   at Bistro.Http.Module.ProcessRequestRecursive(HttpContextBase context, String requestPoint, IContext requestContext)
   at Bistro.Http.Module.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2009-08-19 03:46:21 [Service.Global] ERROR (null) - The underlying provider failed on Open.


I have done the following:
1. Since I am using dotConnect in a class library with the entity framework i created a licenses.licx and licenses.config and embeded the licx file as a resource in the library.
2. I put Devart.Data.dll, Devart.Data.Oracle.dll, and Devart.Data.Oracle.Entity.dll in the GAC on my two load balanced test servers.
3. I have run Tools/Oracle/License Information. There was one Fix button which i clicked which didn't seem to do anything.
4. Read every dotConnect for Oracle licensing issue post and tried everything that seemed relevant.
5. Ran out of time.

What else do I need to do? Thanks.
Perry
PerryD
 
Posts: 10
Joined: Thu 23 Jul 2009 19:20

Postby PerryD » Wed 19 Aug 2009 22:56

i am using version 5.25.39.0 and i also added Devart.Data.Oracle.Web.dll to the GAC on my target servers and that didn't help either.
PerryD
 
Posts: 10
Joined: Thu 23 Jul 2009 19:20

Postby PerryD » Wed 19 Aug 2009 23:10

i also tried moving the devart dll's to the bin folder of my app but that did not help either.
PerryD
 
Posts: 10
Joined: Thu 23 Jul 2009 19:20

Postby Shalex » Thu 20 Aug 2009 07:10

Please register our provider in your *.config file. For more information, please refer to http://www.devart.com/dotconnect/oracle ... Using.html , the Entity Framework Support part, the Deploying an Entity Framework Project section. Please notify us about the results.
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Thu 20 Aug 2009 11:53

It is also important whether the application is compiled on the developer machine or on the deployment server. If you compile your application on the deployment server which doesn't have dotConnect for Oracle installed, it is necessary to compile App_Licenses.dll separately on your developer server, and then to place it in the Bin folder of your application.
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44

Postby PerryD » Thu 20 Aug 2009 14:21

so i figured this out last night when i deployed my project directly from my development machine to the test servers rather than using ccnet and msbuild which builds the project from our repository server and then deploys.

following the directions to create the app_licenses.dll, so i can use our build server, i don't get the build runtime licenses menu item for the licenses.licx file. i put the licx file in the root of my asp.net project which is where i thought it needed to be. now what am i doing wrong?

thanks,
perry
PerryD
 
Posts: 10
Joined: Thu 23 Jul 2009 19:20

Postby Shalex » Thu 20 Aug 2009 15:08

App_Licenses.licx is necessary for Web Site projects. If your project type is ASP.NET Web Application, having only licenses.licx is enough. Is the licensing problem resolved?
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44

Postby PerryD » Thu 20 Aug 2009 15:18

Not yet. I embedded the licx file in my asp.net web app as a resource, added a reference to Devart.Data.Oracle.dll, and checked in my code (subversion). When msbuild builds the solution and deploys the project I still get the same "license not valid" error. The build is successful so I know that is not the issue.

Obviously, the devart dll's are not on the build server. But I would have thought putting the licx file in the asp.net project and having a reference to the Devart.Data.Oracle.dll (copy local) would have been enough.

Any other suggestions?

Thanks,
Perry
PerryD
 
Posts: 10
Joined: Thu 23 Jul 2009 19:20

Postby Shalex » Fri 21 Aug 2009 08:24

1. Have you added the following entry either to web.config or to machine.config of your deployment server?
Code: Select all

 
   
         description="Devart dotConnect for Oracle"
     type="Devart.Data.Oracle.OracleProviderFactory, Devart.Data.Oracle,
       Version=5.25.39.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
 

Replace 5.25.39.0 here with your actual version.

2. Please specify the full text of the error you are getting now.
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44

Postby PerryD » Mon 24 Aug 2009 13:48

Shalex, yes, that config entry is present in the web.config of my asp.net project. The error remains the same. I have sent the compiled binary to the support email.

Thanks for your help.

Perry
PerryD
 
Posts: 10
Joined: Thu 23 Jul 2009 19:20

Postby Shalex » Wed 26 Aug 2009 06:59

We have answered you by e-mail.
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle