web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

MS CRM 2015 update 0.1 Upgrade Error

(0) ShareShare
ReportReport
Posted on by

Hello,

Getting an issue when upgrading an Organization from Base 2015 (v) to Update 0.1. The error seen in the logs is;

System.Data.SqlClient.SqlException: The correlation name 'IsMapiPrivatePLTable' is specified multiple times in a FROM clause.

This error occurs during initial phases of the upgrade. The series of actions before this error are;

12:27:37|   Info| Applying latest dbUpdates to organization.  Id=19b99e4e-1379-e411-84a6-0050568b2d3a, UniqueName=NISCI0.

12:27:48|Verbose| Upgrading custom activities for organization 19b99e4e-1379-e411-84a6-0050568b2d3a

12:27:49|Verbose| Found 3 custom activities

12:28:10|Verbose| Upgrading Entity nis_foeform

12:28:10|Verbose| Creating the missing components of nis_foeform updated for solution eac35a60-2f29-4fc7-83ab-40bf36477197 with action type Create

12:28:10|Verbose| Adding Attribute deliverylastattemptedon with id 4944dd08-cdcc-e511-80d8-0050568b1a32

12:28:10|Verbose| Adding Attribute postponeactivityprocessinguntil with id 4a44dd08-cdcc-e511-80d8-0050568b1a32

12:28:10|Verbose| Adding Attribute senton with id 4b44dd08-cdcc-e511-80d8-0050568b1a32

12:28:10|Verbose| Adding Attribute deliveryprioritycode with id 4c44dd08-cdcc-e511-80d8-0050568b1a32

12:28:10|Verbose| Adding Attribute community with id 4d44dd08-cdcc-e511-80d8-0050568b1a32

12:28:10|Verbose| Adding Attribute deliveryprioritycodename with id 4f44dd08-cdcc-e511-80d8-0050568b1a32

12:28:10|Verbose| Adding Attribute communityname with id 5044dd08-cdcc-e511-80d8-0050568b1a32

12:28:10|Verbose| Adding Attribute leftvoicemailname with id 5144dd08-cdcc-e511-80d8-0050568b1a32

12:28:10|Verbose| Adding Attribute ismapiprivatename with id 5244dd08-cdcc-e511-80d8-0050568b1a32

12:28:10|Verbose| Adding LocalizedLabel with id 5a44dd08-cdcc-e511-80d8-0050568b1a32 for object id 4944dd08-cdcc-e511-80d8-0050568b1a32: Date and time when the delivery of the activity was last attempted.

12:28:10|Verbose| Adding LocalizedLabel with id 5b44dd08-cdcc-e511-80d8-0050568b1a32 for object id 4944dd08-cdcc-e511-80d8-0050568b1a32: Date Delivery Last Attempted

12:28:10|Verbose| Adding LocalizedLabel with id 5c44dd08-cdcc-e511-80d8-0050568b1a32 for object id 4c44dd08-cdcc-e511-80d8-0050568b1a32: Priority of delivery of the activity to the email server.

12:28:10|Verbose| Adding LocalizedLabel with id 5d44dd08-cdcc-e511-80d8-0050568b1a32 for object id 4c44dd08-cdcc-e511-80d8-0050568b1a32: Delivery Priority

12:28:10|Verbose| Adding LocalizedLabel with id 5e44dd08-cdcc-e511-80d8-0050568b1a32 for object id 4a44dd08-cdcc-e511-80d8-0050568b1a32: For internal use only.

12:28:10|Verbose| Adding LocalizedLabel with id 5f44dd08-cdcc-e511-80d8-0050568b1a32 for object id 4a44dd08-cdcc-e511-80d8-0050568b1a32: Delay activity processing until

12:28:10|Verbose| Adding LocalizedLabel with id 6244dd08-cdcc-e511-80d8-0050568b1a32 for object id 4b44dd08-cdcc-e511-80d8-0050568b1a32: Date and time when the activity was sent.

12:28:10|Verbose| Adding LocalizedLabel with id 6344dd08-cdcc-e511-80d8-0050568b1a32 for object id 4b44dd08-cdcc-e511-80d8-0050568b1a32: Date Sent

12:28:10|Verbose| Adding LocalizedLabel with id 6444dd08-cdcc-e511-80d8-0050568b1a32 for object id 4d44dd08-cdcc-e511-80d8-0050568b1a32: Shows how contact about the social activity originated, such as from Twitter or Facebook. This field is read-only.

12:28:10|Verbose| Adding LocalizedLabel with id 6544dd08-cdcc-e511-80d8-0050568b1a32 for object id 4d44dd08-cdcc-e511-80d8-0050568b1a32: Social Channel

12:28:12|   Info| CrmAction execution time; InstallDatabaseUpdatesAction; 00:00:36.0500513

12:28:12|  Error| Installer Complete: OrganizationDatabaseHotFixer - Error encountered

Any help would be greatly appreciated.

Girish

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Hi,

    I had same problem with my CRM 2015 organization. It seems that problem is caused by custom activities. So that what i did

    1. Run the following SQL statement in your CRM database to make custom activity types behave like normal entities

    UPDATE Entity

    SET IsActivity = 0

    Where LogicalName in ('customactivitylogicalname1','customactivitylogicalname2')

    2. Upgrade the organization in CRM deployment manager

    3.  Run the following SQL statement to make custom activity activity types again

    UPDATE Entity

    SET IsActivity = 1

    Where LogicalName in ('customactivitylogicalname1','customactivitylogicalname2')

    At least it works more me and hope it works for you as well !!

    Best Regards

    Arvind Sedha

  • Community Member Profile Picture
    on at

    Thanks Arvind, I will try that and confirm.

    Regards,

    Girish

  • Community Member Profile Picture
    on at

    That worked, thanks Arvind.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans