We have a voluteer database programmed based on the separation model. At the moment, we have an intermittent problem with the registration module. The module has at minimum 3 steps: collect personal information, collect criminal records and collect interested activities to volunteer for. As soon as the registration starts, the "New Record/Request" executes and create the record. As the volunteer moves along the registration process, these additional info is added into the profile. When the volunteer finishes the registration process, a script called "Finish New Account" starts and assign a username and password for that volunteer. Unfortunately, NOT all volunteers are assigned with usernames (username is a calculation of firstname.MI.lastname + # of the duplicated username).
We know that the script runs for all volunteers because it loops the volunteers through school specific selection. The username calc is intermittent and difficult to troublshoot. Any idea where can we start to troubleshooting this issue?
We're researching different causes and work around methods such as record locking and utility table. Anyone has experience with these options? Will they be helpful for our issue?
Thank you very much for any advice,