CRM2016 – DCP Server Upgrade problems

Today, during the upgrade, I had an error to install the new version for DCP server. I tried to follow the workaround on this post but I did not resolve the problem.  My error was on other solution MSCRMADDONScomGeneral2015.101:

i1

i2

The problem was related about a “DROP FULLTEXT INDEX”

I tried to install manually the solution from App path\essentials folder but the result was the same:

i3

The log error was

Entity                   ptm_mscrmaddons_key             MSCRM-ADDONS.com Settingskeys     MSCRM-ADDONS.com Settingskeys                       Failure 0x80044150        DROP FULLTEXT INDEX statement cannot be used inside a user transaction.

After I tried to drop manually the index on the table. I tried again the DCP server setup and It’s running!!

DROP FULLTEXT INDEX ON ptm_mscrmaddons_settingsBase
DROP FULLTEXT INDEX ON [dbo].[ptm_mscrmaddons_keyBase]</p>

That’s all!

CRM2016 – Outlook 2016 plugin installation error

Today I tried to install the new CRM2016 plugin for Outlook 2016. I had a strange problem because the installation run but I did not have any errors:

c2

I had the previous status without a progress. I tried to wait for 30 minutes and after I stopped the setup.

On Eventviewer I found a continuos error for service “Computerbrowser”

c1

I tried to restart the service but it was impossible because there was an error 1053.

Error 1053: The service did not respond to the start or control request in a timely fashion.

After a google scouting I found a solution:

  1. Go to Start > Run > and type regedit
  2. Navigate to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
  3. With the control folder selected, right click in the pane on the right and select new DWORD Value
  4. Name the new DWORD: ServicesPipeTimeout
  5. Right-click ServicesPipeTimeout, and then click Modify
  6. Click Decimal, type ‘180000’, and then click OK
  7. Restart the computer

The cause of the problem was that the Microsoft Windows Service Control Manager controls the state (i.e., started, stopped, paused, etc.) of all installed Windows services. By default, the Service Control Manager will wait 30,000 milliseconds (30 seconds) for a service to respond. However, certain configurations, technical restrictions, or performance issues may result in the service taking longer than 30 seconds to start and report ready to the Service Control Manager.

After this procedure the Outlook plugin was istalled without any problem.

MSCRM : Delete Reports from database

Today we needed to delete more 100 reports from our solution. This operation is boring and long to do directly on CRM. My mate Flavio found an alternative way to clean reports from Database. It is an unsupport solution but for our needs run in right way.

The queries are simple:

DECLARE @Id nvarchar(max)
DECLARE MY_CURSOR CURSOR
LOCAL STATIC READ_ONLY FORWARD_ONLY
FOR
SELECT DISTINCT ReportId From ReportBase WHERE name like('Sub Accounts %')

OPEN MY_CURSOR
FETCH NEXT FROM MY_CURSOR INTO @Id
WHILE @@FETCH_STATUS = 0
BEGIN
--Do something with Id here
PRINT @Id
DELETE FROM dbo.ReportCategoryBase WHERE ReportId = @Id
DELETE FROM dbo.ReportEntityBase WHERE ReportId = @Id
DELETE FROM dbo.ReportLinkBase WHERE ReportId = @Id
DELETE FROM dbo.ReportLinkBase Where LinkedReportId = @Id
DELETE FROM dbo.ReportVisibilityBase WHERE ReportId = @Id
DELETE FROM dbo.Dependencybase WHERE DependencyId
in(SELECT DependencyId FROM dbo.Dependency WHERE RequiredComponentObjectId = @Id)
DELETE FROM dbo.Dependencybase WHERE DependencyId
in(SELECT DependencyId FROM dbo.Dependency WHERE DependentComponentObjectId = @Id)
DELETE FROM dbo.SolutionComponentBase WHERE ObjectId = @Id
DELETE FROM dbo.DependencyNodeBase WHERE ObjectId = @Id
DELETE FROM dbo.ReportBase WHERE ReportId = @Id;

FETCH NEXT FROM MY_CURSOR INTO @Id
END
CLOSE MY_CURSOR
DEALLOCATE MY_CURSOR

That’s all.

Upgrade CRM2015 to CRM2016 : Timeout error during the upgrade

When I tried to uprade an organization from CRM2015 to CRM2016 I hade a Time out error : “The timeout period elapsed prior to completion of the operation or the server is not responding.  The wait operation timed out“.

I checked on google and I read that “You cannot import your CRM 2015 database to upgrade to CRM 2016 if it has a Full Text Catalogue. Something that is likely if you have been using the improved searching functions of CRM 2015.

To fix this problem, we have two possibilities: First one is to disable the Full-search for Quick find on CRM2105 before to migrate. But I don’t know why You need to wait a full 24 hours from the time you change this setting before you attempt to import (or backup to import) the organization into a CRM 2016 environment.

 

quickfind

if you need to resolve problem in fast way there is the second solution: This one is an update script directly on databse but it is not supported. The steps are the following:

  1. Restore backup from CRM 2015 database
  2. On the SQL manager, select the Database in question, and select “New Query” (our 2015 dates restore is demo_2016_MSCRM)s2
  3. In the new Query window. Paste the following code and click Execute
    declare @catid int
    
    select @catid=fulltext_catalog_id from sys.fulltext_catalogs where name='CRMFullTextCatalog'
    
    declare c cursor for
    
     select sys.tables.name, sys.fulltext_indexes.unique_index_id from sys.fulltext_indexes inner join sys.tables on sys.fulltext_indexes.object_id = sys.tables.object_id where sys.fulltext_indexes.fulltext_catalog_id=@catid
    
     open c
    
     declare @TableName varchar(200), @UniqueID as integer
    
     fetch next from c into @TableName, @UniqueID
    
     while @@fetch_status = 0
    
     begin
    
     declare d cursor for
    
     select sys.indexes.name, sys.tables.object_id from sys.tables inner join sys.indexes on sys.tables.object_id = sys.indexes.object_id where sys.tables.name=@TableName and sys.indexes.index_id = @UniqueID
    
     open d
    
     declare @KeyIndex varchar(200), @object_id as integer
    
     fetch next from d into @KeyIndex, @object_id
    
     if @@FETCH_STATUS &lt;&gt; 0 
    
     begin
    
     Print 'Error with' + @TableName
    
     end
    
     while @@fetch_status = 0
    
     begin
    
     BEGIN TRY
    
     Print 'CREATE FULLTEXT INDEX ON [dbo].'+@TableName+' KEY INDEX ['+@KeyIndex+'] on([CRMFullTextCatalog]) WITH (CHANGE_TRACKING AUTO)'
    
     Print 'GO'
    
     declare e cursor for
    
     select sys.columns.name from sys.columns inner join sys.fulltext_index_columns on sys.columns.object_id=sys.fulltext_index_columns.object_id and sys.columns.column_id=sys.fulltext_index_columns.column_id where sys.columns.object_id=@object_id
    
     open e
    
     declare @ColumnName varchar(200)
    
     fetch next from e into @ColumnName
    
     while @@fetch_status = 0
    
     begin
    
     Print 'ALTER FULLTEXT INDEX ON [dbo].'+@TableName+' Add ('+@ColumnName+')'
    
     Print 'GO'
    
     fetch next from e into @ColumnName
    
     end
    
     close e
    
     deallocate e
    
     END TRY
    
     BEGIN CATCH
    
     print 'Error' + @KeyIndex
    
     END CATCH
    
     fetch next from d into @KeyIndex, @object_id
    
     end
    
     close d
    
     deallocate d
    
     fetch next from c into @TableName, @UniqueID
    
     end
    
     close c
    
     deallocate c
    

    The complete script is on my Github: DisableFullTextSearch-Catalog.sql

  4.  When the query executes successfully. Copy to the Clipboard all of the “Message” output in the bottom half of the screen to your clipboard.s3
  5. Now Expand the “Storage / Full Text Catalogues” section of the Database in question and select Properties. s4
  6. Select Table / Views. Using the the little Left pointing arrow. s5Click it as many times as needed to move all the items on the right to the left. Like this:s6
  7. Once finished, select he Script Dropdown and select “Script Action to New Window” (or just click on OK both actions should work)s7
  8. Now Close all the Management for the SQL Server. This is Important.
  9. Upgrade your CRM database the normal way using the Microsoft Dynamics Deployment Manager / Organisations / Import Organisation
  10. Once the upgrade has finished and you have your database imported and upgraded to CRM 2016, Open the SQL manager for the database in question again, and run a new query against the database as we did in step 3 above.This time however we are going to paste the output we captured to clipboard in step 4 above, and run that output as a script.s9
  11. Click Execute again. And you should be rebuilding the database indexes to a state that will function with the new CRM upgraded database.

Source are :

  • community.dynamics.com/crm/f/117/t/184508
  • interactivewebs.com/blog/index.php/crm/crm-2016-import-upgrade-from-crm-2015-failure-timeout-expired/

 

 

 

 

 

 

 

Upgrade CRM2015 to CRM2016 : Database having version 8.0.1.79 is not supported for upgraded.

Today I had a problem to migrate CRM2015 to CRM2016. When I try to import I had this error: Database having version 8.0.1.79 is not supported for upgraded.

I thought that the problem was related with CRM database but Microsoft Community helps me to understand the problem:

The error is misleading as it has nothing to do with the version of the database. If you are trying to import an organization database that has already been imported to an organization on that crm server, you will get this error, because the organization has the same ID.

To resolve it I found two solutions:

  1. Remove the organization with the same ID from server
  2. Change server

But my mate Martin got me another possiblity: Change organization ID from database. It is an unsupported solution but for my needs is perfect. Now I executed the SQL Script and all it is import right.  If you want, you can find the script on my GITHUB: Change Organisation ID V3.sql.

 

 

CRM2016 – Wrong height Layout inside a WebResource on Form

We have a HTML Page as a webresource inside our CRM. In this webPage there are two dropdownlist. We need to manage a Due date.
This was created in the past for CRM2011 and all layout worked always in right way.

Capturecrm2011

CRM2011 – Right layout

We upgrade our CRM to CRM2016 and we start with layout problem:

Capture11

CRM2016 – Wrong layout

 

I must insert this piece of code inside my webresource:

if (typeof parent.$ !== 'undefined') //Check for CRM2011 version. Work only on CRM2015/CRM2016
{
   parent.$( document ).ready(function() {
           var elem = parent.$('#WebResource_duedate');
           elem.height('24px');
   });
}

This code works on DOM directly and change the height. The result is:
Capturenew

CRM2016 – Right Layout

CRM2013 – Save and refresh an entity without postback

Today I had a strange problematic for my client: I needed to update an hidden field without that the user niticing it. I found a solution on this blog: http://www.hebbink.com/post/2015/06/22/saving-and-refreshing-a-crm-entity-form-without-postback

function SaveAndRefresh() {
    Xrm.Page.getAttribute("myAttributeName").setValue(null);
    Xrm.Page.data.refresh(true);
}

Thanks a lot for this great solution!