Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

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

Published by

Rajeev Pentyala

on

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
Advertisements

2 responses to “Table alias is not unique amongst all top-level table and join aliases – Exception”

  1. PeterTox Avatar
    PeterTox

    Hi,

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

    Kind Regards,
    Peter

    Reply
    1. Rajeev Pentyala Avatar
      Rajeev Pentyala

      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

      Reply

Leave a comment

Visitors

2,096,298 hits

Top Posts
Copilot Studio | Create an Agent and Use Adaptive CardsCopilot Studio | Create an Agent and Use Adaptive CardsJuly 15, 2025Rajeev Pentyala
[Step by Step] Beginner : Create a PCF control and add it to a custom page[Step by Step] Beginner : Create a PCF control and add it to a custom pageDecember 2, 2024Rajeev Pentyala
Power Apps Code App with Dataverse: Building CRUD OperationsPower Apps Code App with Dataverse: Building CRUD OperationsDecember 15, 2025Rajeev Pentyala