Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Programming Bulletproof 11500

Posted on by Microsoft Employee

I am doing some testing after upgrading from Dynamics SL 7.0 SP4 to Dynamics 2018CU2 and I have encountered a programming bulletproof error message while choosing a user in the user maintenance screen.

The screen is not customized and it opens without a problem but on choosing a user on the screen I get the error message with addition information as follows:

"An unhandled exception occurred in application code, within a SAF control event handler.  Using a visual studio debugger, set a break point on a line of code indicated in this error message. If the line of code is a Sub or Function call, step into the code to find the point where the exception is occurring.  Once you have identified the line of code causing the exception, diagnose the problem and fix as appropriate.  If the line of code is not available create a debug version of the executable and re-run the program.

Exception:

     System.FormatException

      Input string was not in a correct format

Event Handler:

     SY952600.Form1.userId_Chk

     Line <not available>

I know that to address this problem I need to go into the users table and blank out all the passwords, but how do I do that?

Any suggestions to resolve this issue will be very much appreciated.  Thanks in advance.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Programming Bulletproof 11500

    That worked! Thanks for you help!

  • Verified answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Programming Bulletproof 11500

    Hello ,

    you would log into sql server management studio (SSMS) and access query analyzer , the table updated is in the system database for SL 2018

    You would run the following query

    Select * from userrec where rectype = 'U'

    note the number of rows...they should be your users (rectype u)

    Then run:

    Begin tran

    Update UserRec set Password = '' where RecType = 'U'

    if the number or rows updated is good, then

    Commit

    if not...then

    Rollback

    The users can then log in with blank password and go to the User maintenance or Set Password and set their passwords or the Sysadmin can go into User Maintenance and set the user passwords.

    I'm assuming that you are familiar with getting into query analyzer and the SSMS.

    Best Regards,

    Jana MacDonald

    MSDSL support

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans