Advertisements
Home > CRM 2011 > Table alias is not unique amongst all top-level table and join aliases – Exception

Table alias is not unique amongst all top-level table and join aliases – Exception

Recently we upgraded from UR 8 to UR 13 and from then I was getting ‘Unexpected’ error when I was adding members to my ‘Dynamic Marketing list’ using ‘Advanced Find’ window.

Below is the error log from my Event viewer

Exception type: CrmException

Exception message: Table alias a_7f4fc1baff99e111bef200155dc87c59 is not unique amongst all top-level table and join aliases

This is a known issue  with UR 12 and would be resolved in UR 15.

Here is the link which has solution/workaround for the issue.

🙂

Advertisements
  1. PeterTox
    March 14, 2014 at 12:49 PM

    Hi,

    We run RU15 but the issue is still present. Can you confirm it was fixed for you?

    Kind Regards,
    Peter

    • March 14, 2014 at 3:28 PM

      Hi,

      As per the KB article

      Installing Microsoft Dynamics CRM 2011 Update Rollup 15 resolves the issue for the views which are modified after installing Update Rollup 15. The existing views identified before installing Update Rollup 15 throwing the error needs to be fixed manually.

      So only newly created views do not throw exception but all the existing views has to be fixed manually.

      http://support.microsoft.com/kb/2907665

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: