Avatar of jontresko
jontresko

asked on 

Error when converting Lead to Opportunity in CRM 3.0

We just did several custom attributes and fields in the Lead and Opportunity forms.

Now, when we try to convert the lead to opportunity, we get the following error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

The string was not recognized as a valid DateTime. There is a unknown word starting at index 3.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: The string was not recognized as a valid DateTime. There is a unknown word starting at index 3.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace:


[FormatException: The string was not recognized as a valid DateTime.  There is a unknown word starting at index 3.]
   System.DateTimeParse.Lex(Int32 dps, __DTString str, DateTimeToken dtok, DateTimeRawInfo raw, DateTimeResult result, DateTimeFormatInfo& dtfi) +1658
   System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) +334
   System.DateTime.Parse(String s, IFormatProvider provider, DateTimeStyles styles) +30
   Microsoft.Crm.BusinessEntities.CrmDateTime.Deserialize(String serializedForm, String formattedDate, String formattedTime) +106
   Microsoft.Crm.BusinessEntities.EntityDeserializationStrategyBase.GetAttributeValue(EntityDeserializationContext context, AttributeMetadata attributeMetadata, String attributeValueText, IDictionary subAttributes) +179
   Microsoft.Crm.BusinessEntities.AttributeInfo.Deserialize(EntityDeserializationContext context, IEntityDeserializationStrategy deserializationStrategy) +541
   Microsoft.Crm.BusinessEntities.BusinessEntity.ReadAttribute(EntityDeserializationContext context, IEntityDeserializationStrategy deserializationStrategy, String attributeName) +46
   Microsoft.Crm.BusinessEntities.BusinessEntity.DeserializeAttributes(EntityDeserializationContext context, IEntityDeserializationStrategy deserializationStrategy) +41
   Microsoft.Crm.BusinessEntities.BusinessEntity.Deserialize(XmlReader reader, IEntityDeserializationStrategy deserializationStrategy) +146
   Microsoft.Crm.BusinessEntities.BusinessEntity.Deserialize(String entityXml, IEntityDeserializationStrategy deserializationStrategy) +86
   Microsoft.Crm.BusinessEntities.BusinessEntity.Deserialize(String entityXml) +26
   Microsoft.Crm.Application.Platform.Entity.CreateFrom(Int32 sourceEntityType, String sourceEntityId, TransformType transformType) +497
   Microsoft.Crm.Web.SFA.LeadDetailPage.Qualify(Object sender, DataEventArgs e) +430
   Microsoft.Crm.Application.Forms.DataEventProcessor.Raise(FormEventId eventId, FormState state, User user, String objectId, Entity entity) +176
   Microsoft.Crm.Application.Forms.AppForm.RaiseDataEvent(FormEventId eventId) +89
   Microsoft.Crm.Application.Forms.EndUserForm.Initialize(Entity entity) +56
   Microsoft.Crm.Application.Forms.CustomizableForm.Execute(Entity entity, String formId, String formType) +83
   Microsoft.Crm.Application.Forms.CustomizableForm.Execute(Entity entity) +13
   Microsoft.Crm.Web.SFA.LeadDetailPage.ConfigureForm() +346
   Microsoft.Crm.Application.Controls.AppPage.OnPreRender(EventArgs e) +29
   System.Web.UI.Control.PreRenderRecursiveInternal() +62
   System.Web.UI.Page.ProcessRequestMain() +1499

 
Looks like there's a problem with one of the dates, but  can't find the source.

The lead also goes to 'Closed Leads' but does not move to opportunities....

Any ideas?
Convert-Error.pdf
Microsoft Dynamics

Avatar of undefined
Last Comment
Biffster007
Avatar of Biffster007
Biffster007
Flag of New Zealand image

Hi,

Can you check the date settings of the user you're using to try and promote the Lead and compare it with the date settings of the CRM server itself?  They could be out of whack which might be causing the issue.

MH
Avatar of jontresko
jontresko

ASKER

So, when logged in as user -> Tools -> Options -> ?? How should I check date settings for user?

And for server -> Org Setting -> System Settings (which works now, thanks to you) -> Calendar?

I think I did make changes to the system settings, so this might make sense...

Other things I made changes to around the time this issue came up:

- Tried to install a cloning tool, which didn't work, so I undid all changes to config files.
- mapped all custom fields between leads and opportunities

Avatar of Biffster007
Biffster007
Flag of New Zealand image

Yes...The Tools-->Options--Formats Tab-->Current Format to check the user settings.

Administration-->System Settings-->Formats Tab-->Current Format to check the organisation setting.

The mapping could potentially be causing an issue as well if the settings are different.  You may find that if the settings are the same the mapping will work fine but if they're different then there could be issues.  

Let me know your findings.

Cheers,
MH
Avatar of jontresko
jontresko

ASKER

Ok, I'm not even getting a formats tab in the user settings...

In system settings, it's under the calendar tab and "Set date format used throughout the system"
Avatar of Biffster007
Biffster007
Flag of New Zealand image

Sorry...

Got my wires crossed there for a bit.  Thought we were talking CRM 4.0.

Yep...So you're right with the system settings.

Actually, I don;t think there is an option to change a users personal time format in 3.0.  

If you remove that mapping from Lead to Opportunity do you still get the error?

Cheers,
MH
Avatar of jontresko
jontresko

ASKER

There are a lot of fields in the forms with dates that are mapped, so I guess we can do start removing them working backwards to find the source...

Also, not sure if this helps, but since I was messing with the web.config file, I am not able to open the web client on my computer, but it's still working on the other computers...
ASKER CERTIFIED SOLUTION
Avatar of Biffster007
Biffster007
Flag of New Zealand image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of crm_info
crm_info
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of jontresko
jontresko

ASKER

Excellent!  I just hit 'Generate Mappings' which took us back to a time when we knew it was working.... Thankfully there were only 21 mappings we had to do manually, so this shouldn't take long to diagnose...

So, looks like it could be either:

- target field attribute was nvarchar, when source was datetime (or something to that effect)

or

- Source was system attribute and target is custom attribute?
Avatar of Biffster007
Biffster007
Flag of New Zealand image

Excellent.  Let me know how you get on.

Cheers,
MH
Avatar of jontresko
jontresko

ASKER

Thought you might also be interested to know... I figured out the issue I was having with not being able to open the Web Client.  Turns out my attempts were being thwarted by a pesky Google toolbar...
Avatar of Biffster007
Biffster007
Flag of New Zealand image

Ha...Yep that's stumped me in the past!!!

Well done ;;-)
Microsoft Dynamics
Microsoft Dynamics

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

5K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo