very nice post on knowledge base article on ms crm 2011

here you go and thanks to the guy
http://paulnieuwelaar.wordpress.com/2011/04/10/the-knowledge-base-in-dynamics-crm-2011/

regards,
yes.sudhanshu

Exception type: CrmArgumentException , Exception message: Cannot add attribute from of type partylist in a condition , advance search phone call MS CRM 2011

while i was doing advanced search i got the below error

when i tried in a fresh organization, i donot see From as searchable.
while investigating, i got to know that the From field in Phone Call, EMail was made searchable.
both are partylist and by default those are not searchable.
so i changed to non searchable and its done.

how it come as searchable?
if you go to fields and select more than one and do edit, then you can edit...
initially searchable is disabled and read only as below..

then i made bulk edit as below

then see the below screen as the field enabled and you can select Yes or No

below is the event viewer details

Event code: 3005 Event message: An unhandled exception has occurred. Event time: 13/9/2013 5:11:23 PM Event time (UTC): 13/9/2013 9:11:23 AM Event ID: 50e5f1731078425abce195415f682f94 Event sequence: 864 Event occurrence: 10 Event detail code: 0 Application information: Application domain: /LM/W3SVC/2/ROOT-1-130235340940535000 Trust level: Full Application Virtual Path: / Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\ Machine name: XRM Process information: Process ID: 3820 Process name: w3wp.exe Account name: MSCRM\ADMINISTRATOR Exception information: Exception type: CrmArgumentException Exception message: Cannot add attribute from of type partylist in a condition at Microsoft.Crm.Query.ConditionExpressionCollection.Add(ConditionExpression element) at Microsoft.Crm.Query.DeserializeFetchVisitor.Visit(FilterExpression criteria) at Microsoft.Crm.Query.DeserializeFetchVisitor.Visit(EntityExpression entity) at Microsoft.Crm.Query.EntityExpression.InternalDeserializeFromFetchXml(String xmlInfo, ParsingConditionValuesOption parsingOption) at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.SetupQueryBuilder(QueryBuilder queryBuilder, View view) at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData() at Microsoft.Crm.Application.Controls.GridUIProvider.PrepareGridData() at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Page.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Cannot add attribute from of type partylist in a condition Request information: Request URL: http://xrm:5555/ICACRM/AdvancedFind/fetchData.aspx?EntityCode=112&QueryId={00000000-0000-0000-00AA-000010001028}&ViewType=1039&pagemode=iframe&sitemappath=Workplace|MyWork|nav_dashboards Request path: /ICACRM/AdvancedFind/fetchData.aspx User host address: fe80::1960:804d:95b2:ac66C:\Program Files\Microsoft Dynamics CRM\CRMWeb\ User: MSCRM\ADMINISTRATOR Is authenticated: True Authentication Type: Negotiate Thread account name: MSCRM\ADMINISTRATOR Thread information: Thread ID: 19 Thread account name: MSCRM\ADMINISTRATOR Is impersonating: False Stack trace: at Microsoft.Crm.Query.ConditionExpressionCollection.Add(ConditionExpression element) at Microsoft.Crm.Query.DeserializeFetchVisitor.Visit(FilterExpression criteria) at Microsoft.Crm.Query.DeserializeFetchVisitor.Visit(EntityExpression entity) at Microsoft.Crm.Query.EntityExpression.InternalDeserializeFromFetchXml(String xmlInfo, ParsingConditionValuesOption parsingOption) at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.SetupQueryBuilder(QueryBuilder queryBuilder, View view) at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData() at Microsoft.Crm.Application.Controls.GridUIProvider.PrepareGridData() at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Page.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Custom event details:

Debugging sandboxed plugins ms crm 2011

we know how to debug the plugins and also if its asynchronous.
in ms crm 2011 we got new concpet of registering plugin in sandbox, so if its registered in sandbox mode then how to debug...?
its very simple, add the w3p processess(all those are running) and also the sandbox services(if multiple are running add all), then process should get into your break point.

more please follow
http://msdn.microsoft.com/en-us/library/gg328574.aspx#bkmk_sandboxplugin

Regards,
yes.sudhanshu

Outgoing Status: Failure - An error occured while checking the connection to the Microsoft Dynamics server MS CRM 2011 Email Router configuration

while i was configuring Email Router for MS CRM 2011, i got the below error.
the profile and load users and queue is perfect, but when i click test access i got the below error.

no error logs also i found.
then i just changed the MS CRM 2011 Email Router service account from network to a domain account and then it started working and perfect...

regards,
yes.sudhanshu
 

The Report cannot be displayed. (rsProcessingAborted) MS CRM 2011, Report execution

one of my implementation i got the below error for the reports "The Report cannot be displayed. (rsProcessingAborted) ".

when i chekced the system reports working fine.
even if i created one more report with wizard also fine.
rollups on report server same as crm server.

i come to know my developer was using Stored Proc for the reports(SSRS).
but when i scaned the reports log i found the below...

e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet1'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object '<StoredProc_Name>', database 'Org_MSCRM', schema 'dbo'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The EXECUTE permission was denied on the object '<StoredProc_Name>', database 'Org_MSCRM', schema 'dbo'.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()    at System.Data.SqlClient.SqlDataReader.get_MetaData()    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

So from the log , i found that the user does not have access to the Stored Proc.

my report service was runnin gunder NT AUTHORITY\NETWORK SERVICE.

so i went to the stored proc and added the NT AUTHORITY\NETWORK SERVICE and gave execute permission.

to do this, go to the DB is sql studio -> Programability -> stored procudures-> right click on the Stored Proc -> properties -> Permissions -> click Search to add the NT AUTHORITY\NETWORK SERVICE and give Execute access.

then the report should execute.

 

Regards,

yes.Sudhanshu