Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Entire server fails if I add a specific field type

Posted on by 3,079

I'm in the process of setting up a new CRM (and DB) server.  I've imported my solutions (only 5 - our internal one, Process JS, DyanmicsCRM2016Workflows, and Ribbon Workbench), and I can see everything just fine.  I can create records, all is dandy.  So in the new system I decided to try a couple of new modifications.  I added a couple of fields, and all was great.  Until...I tried to add a currency field to one of our custom entities.  Then everything just died a horrible death.  I immediately started getting 404 errors on the entire site.  I restored the db from backup and tried again, to confirm - same thing.  I can create other field types in that entity just fine, and I can create currency fields in other entities.  Just this one particular combination sets the whole thing on fire.  I tried enabling CRM and IIS trace logs, but the IIS ones still just gave me the same 404 message (which was a regular file not found, even on the server with all friendly-errors turned off), and even with logging turned on on the CRM server I get nothing in the log dir.

 I'm completely stumped.  Anyone have any clue as to what might be happening, or even where else I can look?

*This post is locked for comments

  • Verified answer
    awalters Profile Picture
    awalters 3,079 on at
    RE: Entire server fails if I add a specific field type

    Yes, this was all set.  And I could add currency fields elsewhere with no issue; just not this one entity.

    Turns out, it looks like a bug in the CRM 2016 solution export, as far as I can tell.  The entity in question had had a currency field at one point, but it had been removed.  When a currency field is removed, the transactioncurrency and exchangerate fields stay, which is apparently expected behaviour.  However, if you export a solution when this has happened, the transactioncurrency field gets exported into the solution, but not the exchange rate field.  Then when it's brought in, it has one, not both.  So when I tried to make a new currency field after import, it was in a state that did not make any sense at all and it got very cranky.  (So, kind of two bugs, as there doesn't seem to be any error checking for this scenario, and it puts the whole system into a rather amazingly hard fail state.)

    Was able to resolve by rolling the DB back to pre-import, adding a currency field to the entity in question in the old system, then re-importing.  After that I can create and delete currency fields in that entity however much I'd like.

  • Nadeeja Bomiriya Profile Picture
    Nadeeja Bomiriya 6,804 on at
    RE: Entire server fails if I add a specific field type

    Hi Allison,

    Check if you have configured currency in your new CRM instance.  Set your personal currency setting using Options menu.

    When you create a currency field for the first time in an entity, CRM creates 4 fields instead of one.

    <field_name>

    <field_name>_Base

    exchangerate

    transactioncurrencyid

    transactioncurrencyid refers to the default currency.

    Check this article for more information.

    debajmecrm.com/.../understanding-currency-field-in-microsoft-dynamics-crm

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans