Wednesday, September 18, 2013

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:

Tuesday, September 17, 2013

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

Thursday, September 5, 2013

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