REPORTED PROBLEM
Renewal request in REC EZforms was resulting in an SQL error message and would not allow a user to continue to go back.
REPLICATION
As the call sign of the station experiencing the problem was provided, we were able to replicate the problem and verify the bug in code.
ROOT CAUSE
Some first generation LPFM records (2000/2001 window) have deteriorated over time and others were originally filed on paper. These records do not include CDBS positional interest data. As a result, the system could not properly build up a table of authorized signatories.
RESOLUTION
Modified the code so that in the event that if there is no positional interest data, the user is instructed to select the "NOT LISTED" operation, which will be the sole option in those cases. The system will also advise the user that they will be contacted by REC to get the signatory information for the application.
This code was modified in all three EZforms programs (renewals, license to cover and modification of licenses).
