Skip to main content

Posts

Showing posts from June, 2011

How to create new (missing) columns for entities in your Data Export Service Azure SQL database

CRM 2011 New Entity form and F5 refresh issue

Today I had this situation:
I created a new accountI saved the new accountI started a workflowI hit F5 to refresh the window to see the changes in my newly created account.Issue: Instead of getting the form of my newly created account the refresh gave me another new empty account form!So what the heck is happening here?

After some research with the IE8 Developer Tool I found out that the entity window are actually two windows:
The main entity window with the ribbon barThe inner window (IFrame), which actually includes the entity's edit form and JavaScript handlers/event code.The main window has the following URL:
http://mucdevcrmdb01:22222/MyCompany/main.aspx?etc=1&extraqs=%3fetc%3d1&pagetype=entityrecord

The inner window (IFrame):
http://mucdevcrmdb01:22222/MyCompany/userdefined/edit.aspx?etc=1&id=%7b717BBB91-B59C-E011-8A01-00155D59091B%7d&pagemode=iframe&sitemappath=Workplace%7cMyWork%7cnav_activities

Issue/Bug: After creating a new entity the new entity's …

Migration of CRM 4.0 to CRM 2011

In this blog I will show you all the steps it took for me to migrate an CRM 4.0 organization to CRM 2011:

1. Created backups of my CRM 4.0 organization DB and report server DB
2. Imported backups on target environment / SQL Server
3. Connected report server instance to my imported CRMReports DB
4. Restored the SSRS encryption key (you need a password for your encryption key file)
5. Within the CRMReports DB in the table "Key" I deleted multiple entries so that it should look like this:
6. Started the Deployment Manager:
7. Started to import organization:

8. Selected my restored CRM 4.0 organization DB
9. Finished auto-mapping of AD-users and replaced one of the old CRM administrator accounts with my current new administrator account (might not be important for you).
10. Clicked next and started the migration.
11. Error appeared:

12:42:11| Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationUpgrader: Fehler bei der Aktion Microsoft.Crm.Tools.Admin.UpgradeD…