selectSingleNode error after crm 2011 rollup 16 installed

The processes which were working before start giving 'selectSingleNode' error, after doing little bit of search I found out this is happening due to from rollup 12 and plus, CRM 2011 gives multibrowser support. And the javascript file referenced had i.e. specific calls. http://community.dynamics.com/crm/b/gonzaloruiz/archive/2013/02/13/javascript-xml-processing-dom-and-crm-2011-ur12.aspx

import crmsolution failed after update to rollup 16

Import-CrmSolutionFile : Import Error. workflow:{000000000-xxxxx-xxxxx}:Workflow name This workflow cannot be created, updated or published because it was created
 outside the Microsoft Dynamics CRM Web application. Your organization does not allow this type of
workflow.

http://msdn.microsoft.com/en-us/library/8da8c71e-84af-441e-b99b-0b59399f10f6#enable_disable

when following above instructions I started getting the below error.

At C:\PS\CRMPS.SolutionSourceControl.psm1:478 char:26
+             import-crmsolutionfile <<<<  -connection $connection -inputfile $solutionfile -publis
hworkflows -OverwriteUnmanagedCustomizations
    + CategoryInfo          : NotSpecified: (:) [Import-CrmSolutionFile], Exception
    + FullyQualifiedErrorId : System.Exception,CRMPS.Snapin.ImportCrmSolutionFileCmdlet

CRMPS > Add-PSSnapin Microsoft.Crm.Powershell
Add-PSSnapin : No snap-ins have been registered for Windows PowerShell version 2.
At line:1 char:13
+ Add-PSSnapin <<<<  Microsoft.Crm.Powershell
    + CategoryInfo          : InvalidArgument: (Microsoft.Crm.Powershell:String) [Add-PSSnapin], P
   SArgumentException
    + FullyQualifiedErrorId : AddPSSnapInRead,Microsoft.PowerShell.Commands.AddPSSnapinCommand


Resolution:

Check if the deployment manager is installed on the same machine from where the PowerShell is running.

Run "Windows PowerShell Modules"

1. Add-PSSnapin Microsoft.Crm.PowerShell

2. $setting = get-crmsetting customcodesettings
   

3. $setting.AllowDeclarativeWorkflows="True"
   
   

4. set-crmsetting $setting
   
   
   

5. get-crmsetting customcodesettings
   
   
   

F-12 in model window and clear cache in IE

I had a requirement where we have to show a custom web page as a model window, I have used jquery on the custom site and was trying to hit a break point, I was hitting couple of issue first one was the javascript file was not getting updated as it was a model window I wasn't able to press CTRL+F5, to sort this out

Press F12 on the main I.E and got to Cache and then select 'Always refresh from server option'

Second issue I was hitting was I wasn't able to open debug window by pressing F-12 on model window. To sort this out

In the main window Go to Internet Options then select Security Tab and then click on the Custom Level button and under Miscellaneous options select the 'Disable' option for the 'Allow websites to open windows without address or status bars.

how to get access to parent record from the new entity record opened using the lookup view

I had a requirement where we got a lookup field on the entity form and on click of that lookup user is able to either select existing record or click on new record, the new record needs to have reference of some selects which user have specified in the initial form.

CRM passes the details of parent window in the url, and used the following code  to extract the id
 
var idMatch = (/currentid=([^&]+)/i).exec(parent.window.opener.location.search);

if (idMatch != null) {

var id = idMatch[1];

    id = id.replace("%7b", "");

    id = id.replace("%7d", "");

return id;



}

Using Query Expression

QueryExpression query1 = new QueryExpression()
                    {
                        EntityName = "prefix_entityname",
                        ColumnSet = new ColumnSet(true),
                        LinkEntities = {
                            new LinkEntity
                            {
                                JoinOperator = JoinOperator.Natural,
                                LinkFromEntityName = "prefix_entityname",
                                LinkFromAttributeName = "prefix_entitynameid",
                                LinkToEntityName = "prefix_entityname2",
                                LinkToAttributeName = "prefix_entitynameid",
                                LinkCriteria = new FilterExpression
                                {
                                    FilterOperator = LogicalOperator.And,
                                    Conditions  =
                                    {
                                        new ConditionExpression
                                        {
                                            AttributeName = "prefix_entityname2id",
                                            Operator = ConditionOperator.Equal,
                                            Values =  {
                                                entity2id
                                            }
                                        },
                                        new ConditionExpression
                                        {
                                         AttributeName = "prefix_entity2attribute2",
                                         Operator = ConditionOperator.Equal,
                                         Values = {
                                         attribute2value
                                         }
                                        }
                                    }
                                }
                            }
                        }
                    };

Query execution time of xxxx seconds exceeded the threshold of 10 seconds

When tring to delete one of the custom entity I was getting failure in deletion and when looked into the event view I saw the message

Query execution time of 30.0 seconds exceeded the threshold of 10 seconds


After a quick google I found the value of threshold is stored in the ServerSettingProperties table of MSCRM_Config database, I used following queue to update the value

use mscrm_config

update serversettingsproperties
set intcolumn = 25
where columnname = 'longQueryThresholdInSeconds'


http://community.dynamics.com/crm/f/117/t/64580.aspx

Creating schedules to send a report to user at certain time.

To send a crm report output to recipients using email at a specified time http://blog.customereffective.com/blog/2014/05/crm-report-scheduler.html