DevForce Community Forum : Query Includes Trigger Relation Link Exception http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Query Includes Trigger Relation Link Exception Tue, 21 Apr 2026 10:40:25 -700 Thu, 10 Jun 2010 18:25:46 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1848 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Query Includes Trigger Relation Link Exception : Ok, we've released a DevForce... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7262#7262 Author: ting
Subject: 1848
Posted: 10-Jun-2010 at 6:25pm

Ok, we've released a DevForce 6.0.3.1 build that fixes this.  Thanks for the help!
]]> Thu, 10 Jun 2010 18:25:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7262#7262 Query Includes Trigger Relation Link Exception : This works! I had to do what kimj... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7245#7245 Author: ksmith
Subject: 1848
Posted: 10-Jun-2010 at 7:28am

This works! I had to do what kimj said as well for it to work. Also, I'm now able to run the application in Release mode and over HTTPS. Great work. Thank you.

]]> Thu, 10 Jun 2010 07:28:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7245#7245 Query Includes Trigger Relation Link Exception : Just an addendum to Ting's... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7239#7239 Author: kimj
Subject: 1848
Posted: 09-Jun-2010 at 6:53pm

Just an addendum to Ting's last post - make sure that you also link the file containing the partial class into your Silverlight domain model project, since the change is needed in both the Silverlight application and the BOS.]]> Wed, 09 Jun 2010 18:53:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7239#7239 Query Includes Trigger Relation Link Exception : Ok I think we have a solution... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7233#7233 Author: ting
Subject: 1848
Posted: 09-Jun-2010 at 3:53pm

Ok I think we have a solution for the Release Build problem.  It appears that the static fields on the EntityRelations class do not initialize in a Release Build if there is no static constructor.
 
The workaround is to define a partial class that defines a static constructor:

  public partial class EntityRelations {

    static EntityRelations() { }

  }

 

If you confirm that this also works for you, we will issue a patch for it.

 

 

]]> Wed, 09 Jun 2010 15:53:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7233#7233 Query Includes Trigger Relation Link Exception : One last thing to look into... I... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7202#7202 Author: ksmith
Subject: 1848
Posted: 08-Jun-2010 at 12:01pm

One last thing to look into...
 
I also ran into a problem testing the application over SSL. I noticed in the DevForce log file that the EntityService.svc starts up with an HTTPS URL but the EntityServer starts up over HTTP when the following in used in the Global.asax file:

System.Web.Hosting.HostingEnvironment.RegisterVirtualPathProvider(new IdeaBlade.EntityModel.Web.ServiceVirtualPathProvider());　

The Silverlight (SL) client could not communicate with the EntityServer over SSL.
 
I deployed to Windows Server 2008 RC 2, IIS 7.5, with an SSL cert installed and accessed the SL client over HTTPS.
 
Thanks
]]> Tue, 08 Jun 2010 12:01:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7202#7202 Query Includes Trigger Relation Link Exception : Thanks for the additional research.... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7181#7181 Author: ting
Subject: 1848
Posted: 07-Jun-2010 at 2:56pm

Thanks for the additional research.  This will help us nail it down.

]]> Mon, 07 Jun 2010 14:56:42 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7181#7181 Query Includes Trigger Relation Link Exception : Finally figured it out. I built... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7152#7152 Author: ksmith
Subject: 1848
Posted: 04-Jun-2010 at 8:02pm

Finally figured it out. I built the sample application in Release mode and experienced the same problem. I then deployed my application after building it in Debug mode and this problem did not occur. The problem happens when the application is built in Release mode on both Windows 7 and Windows Server 2008. You should be able to duplicate it now.]]> Fri, 04 Jun 2010 20:02:59 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7152#7152 Query Includes Trigger Relation Link Exception : I believe we have seen asssembly... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7150#7150 Author: ting
Subject: 1848
Posted: 04-Jun-2010 at 3:24pm

I believe we have seen asssembly probing issues when both DevForce and raw Entity Framework models are in the same deployment.  We're looking into this.
 
 
]]> Fri, 04 Jun 2010 15:24:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7150#7150 Query Includes Trigger Relation Link Exception : I modifieda DevForce sample application... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7146#7146 Author: ksmith
Subject: 1848
Posted: 04-Jun-2010 at 8:24am

I modified a DevForce sample application to display both customers and orders (using the Include() method) and then deployed it to the server and it worked. Therefore, the problem is specific to my application only. From the EDM, I am generating both the DevForce Entity classes and the EF classes although they are in different namespaces. I plan on refactoring my code to use just the DevForce generated classes. I tried step 1 and that did not work. The log file shows an error probing my domain model assembly where the generated classes reside. I haven't been able to get the probing to work when DevForce starts up.
 
At least I know now that the problem is app specific and not related to the deployment environment.
 
Thank you again for all of your help.
]]> Fri, 04 Jun 2010 08:24:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7146#7146 Query Includes Trigger Relation Link Exception : Two more things: 1) In the... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7142#7142 Author: ting
Subject: 1848
Posted: 03-Jun-2010 at 5:33pm

Two more things:
 
1)  In the global.asax, try adding:
  IdeaBlade.EntityModel.EntityRelation.InitializeEntityRelations(typeof(FieldServiceReport).Assembly);
 
2)  Take a look at the server-side debuglog.xml to see if there are any unusual errors there.
 
]]> Thu, 03 Jun 2010 17:33:51 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7142#7142 Query Includes Trigger Relation Link Exception : Thanks for trying that out. We... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7126#7126 Author: ting
Subject: 1848
Posted: 02-Jun-2010 at 6:31pm

Thanks for trying that out.  We will try to reproduce this on our end.
]]> Wed, 02 Jun 2010 18:31:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7126#7126 Query Includes Trigger Relation Link Exception : I built a Windows Server 2008... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7125#7125 Author: ksmith
Subject: 1848
Posted: 02-Jun-2010 at 3:41pm

I built a Windows Server 2008 RC machine. Added the IIS and Web Server Roles and then installed the .Net Framework 4 on the machine. I marked all of the assemblies in my web project as Copy Local including the assemblies for IdeaBlade 6.0.2 and the Entity Framework assemblies and deployed the solution to the application folder on the server (I followed the deployment instructions in the IdeaBlade Deployment guide). Still the same error. Again, everthing works locally on Windows 7 using the same database that the application is using on the server. Have you tried deploying an application that Windows Server 2008 RC that uses a .Include() in a query? Queries that do not use a .Include() are working on this new server.
 
Thank you for your help.
 
]]> Wed, 02 Jun 2010 15:41:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7125#7125 Query Includes Trigger Relation Link Exception : Definitely confirm that all the... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7096#7096 Author: ting
Subject: 1848
Posted: 28-May-2010 at 3:56pm

Definitely confirm that all the assemblies are deployed into the bin folders and not in the GAC.  We found a similar support case and that turned out to be the problem.

]]> Fri, 28 May 2010 15:56:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7096#7096 Query Includes Trigger Relation Link Exception : Ok,the codeseems pretty normal. This... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7082#7082 Author: ting
Subject: 1848
Posted: 27-May-2010 at 6:47pm

Ok, the code seems pretty normal.
 
This feels like an assembly mismatch error.  Here are a few things to double check:
1)  Confirm the correct files are on the server.  (I'm sure you've done this already...)
2)  Make sure all the projects are targeted at the .NET 4.0 Framework.
3)  Check that DevForce is not installed on the machine, and there are no DevForce assemblies in the GAC or elsewhere except for your deployment directory.
 
If that fails, I'd try another server and see if it works there.
 
]]> Thu, 27 May 2010 18:47:56 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7082#7082 Query Includes Trigger Relation Link Exception : Yes, the client app is Silverlight.... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7076#7076 Author: ksmith
Subject: 1848
Posted: 27-May-2010 at 6:57am

Yes, the client app is Silverlight. Here is the query:

var query = EntityManager.FieldServiceReports

.Where(fsr => fsr.MembershipUserId == _userId && fsr.ReportDate == SelectedReportDate)

.Include(FieldServiceReport.EntityPropertyNames.FieldServiceRecords);

 
I tried changing to include to another navigation property besides FieldServiceRecords and got the same error.
 
Keith
]]> Thu, 27 May 2010 06:57:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7076#7076 Query Includes Trigger Relation Link Exception : Thats's weird. Can you post... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7070#7070 Author: ting
Subject: 1848
Posted: 26-May-2010 at 8:18pm

Thats's weird.  Can you post the query with the includes?  Is the client app in Silverlight?
]]> Wed, 26 May 2010 20:18:59 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7070#7070 Query Includes Trigger Relation Link Exception : The following exception happens... http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7063#7063 Author: ksmith
Subject: 1848
Posted: 26-May-2010 at 2:42pm

The following exception happens on Windows Server 2008 with IIS 7, Enterprise SQL Server 2008. However, using an exact copy of the database on Windows 7 using Visual Studio 2010 built in web server, this exception does not get thrown. The exception is triggered by an .Include() on a query. Queries without includes run perfectly. And again, I copied the database to SQL Express 2008 on my local machine and the error does not happen. I thought maybe the foreign key names in the database did not match the EDM schema. However, the .Include() work just fine locally and do not trigger this exception. The .NET Framework is 4 in both environments. Any ideas on what could cause this or on how to get more details of the error?
 
Caught exception: System.Data.EntityException: Unable to set field/property .... See InnerException for details. ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at IdeaBlade.EntityModel.NavigationEntityProperty.get_RelationLink()
   at IdeaBlade.EntityModel.NavigationListEntityProperty`2.GetEntityReference(EntityWrapper wrapper)
   at IdeaBlade.EntityModel.NavigationListEntityProperty`2.GetValueForSerialization(EntityWrapper ew)
   at IdeaBlade.EntityModel.NavigationListEntityProperty`2.GetValue(TInstance instance)
   at lambda_method(Closure , Object )
   at System.Data.Objects.Internal.EntityProxyFactory.<>c__DisplayClass5.<CreateBaseGetter>b__4(Object entity)
   at System.Data.Objects.Internal.PocoPropertyAccessorStrategy.GetNavigationPropertyValue(RelatedEnd relatedEnd)
   --- End of inner exception stack trace ---
   at IdeaBlade.EntityModel.Server.EntityServerQueryInterceptor.HandleException(Exception e, PersistenceFailure failureType)
   at IdeaBlade.EntityModel.Server.EntityServerQueryInterceptor.OnExecuteQuery()
   at IdeaBlade.EntityModel.Server.EntityServerQueryInterceptor.Execute(IEntityQuery entityQuery, SessionBundle sessionBundle, EntityServer entityServer)
   at IdeaBlade.EntityModel.Server.EntityServer.Fetch(SessionBundle sessionBundle, IEntityQuerySurrogate surrogate)
   at SyncInvokeFetch(Object , Object[] , Object[] )
   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)</entry>
 
Thanks
Keith
]]> Wed, 26 May 2010 14:42:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1848&PID=7063#7063