MrDave's (David Yack) CRM Blog!

I had fun today tracking down a error that I created by importing an entity that had a lookup field on a form that was from another entity that the target system didn't have.  The result was after publish of the imported entity I could no longer bring up the entity form without getting a simple page that said "Query Builder error".

Using a platform trace I was able to figure out the name of the field having the problem.  Since it was from a lookup the field missing was something like ctc_myfieldID  which was the Id for the lookup field to be stored in.  On a suggestion from Mark Harrington from the CRM team, I added a dummy attribute with the same name.  Once that was done, I was able to publish the form without the lookup and then I was able to finally remove my dummy attribute.

The other obvious way you can fix this problem is to import the missing entity - but in some cases like this one I didn't want the missing entity in the target system.

And for those of you that happened to notice that my blog posts slowed down in May - that didn't mean I wasn't busy working but I've been working on trying to wrap up a project that I started about a year ago and it involves close to 600 pages.  Stay tuned to this space for an announcement with tons of more details on my mystery project!