web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Programming Bulletproof 11500

(0) ShareShare
ReportReport
Posted on by

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.

I have the same question (0)
  • Verified answer
    CFROTON Profile Picture
    4,710 on at

    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

  • Community Member Profile Picture
    on at

    That worked! Thanks for you help!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 456 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans