Errors on Opportinities Screen on upgrade to CRM 4.0 from 3.0

[BoneLazy]

Hi,

We recently upgraded to CRM 4.0 from 3.0.



Everything seems to work fine except we are receiving an error on the opportunites screen.



I enabled devErrors and the error seems to be on the closeprobability builtin property. This is the error I am receiving. I noticed the column is of datatype float in the CRM db but the attribute in CRM settings is int. I have tried installing rollups 1 and 2 just incase but to no avail, please help cuse i am running out of ideas on how to proceed fixing this



Error Description:

Type Mismatch: Type of Attribute: Opportunity.closeprobability is: System.Int32. However, Type of passed-in value is: System.Double

Error Details:

Type Mismatch: Type of Attribute: Opportunity.closeprobability is: System.Int32. However, Type of passed-in value is: System.Double

Full Stack:

[ArgumentException: Type Mismatch: Type of Attribute: Opportunity.closeprobability is: System.Int32. However, Type of passed-in value is: System.Double]


[CrmArgumentException: Type Mismatch: Type of Attribute: Opportunity.closeprobability is: System.Int32. However, Type of passed-in value is: System.Double]
at Microsoft.Crm.BusinessEntities.BusinessEntity.PerformTypeCheck(String attributeName, Object attributeValue)
at Microsoft.Crm.BusinessEntities.BusinessEntity.SetAttributeValue(String attributeName, Object attributeValue)
at Microsoft.Crm.BusinessEntities.QueryProcessObject.CreateResultEntityFromDataReader(IDataReader reader, ResultEntityDescription resultEntityDescription, ExecutionContext context)
at Microsoft.Crm.BusinessEntities.QueryProcessObject.CreateResultEntitiesFromDataReader(IDataReader reader, EntityExpression entityExpression, ResultEntityDescription resultEntityDescription, ExecutionContext context, Boolean& moreRecords)
at Microsoft.Crm.BusinessEntities.QueryProcessObject.RetrieveDataQueryAsResultXml(EntityExpression entityExpression, QueryStrategyType strategyType, ExecutionContext context)
at Microsoft.Crm.BusinessEntities.QueryProcessObject.RetrieveQueryAsResultXml(EntityExpression entityExpression, QueryStrategyType strategyType, ExecutionContext context)
at Microsoft.Crm.ObjectModel.SavedQueryService.Execute(String fetchXml, ExecutionContext context)

 

[jodonnell]

First hing I would do is take a full back up of your system. After that I would republish all your entities to make sure everything is in sync. Once you have done that do an IISRESET on the web server and test again.

John O'Donnell
Microsoft Dynamics ISV Architect Evangelist
Microsoft Corporation

http://blogs.msdn.com/jodonnell

http://blogs.msdn.com/usisvde

http://channel9.msdn.com/Wiki/DynamicsCRM/HomePage/

 

[BoneLazy]

Hi,
Thanks alot for the reply. I tried your suggestion that didnt work, anything else you can think of?