SBL-GEN-03002: Required parameter %1 is NULL

Applies to:

Siebel Assignment Manager - Version: 7.8.2 [19213] to 8.1.1 [21112] - Release: V7 to V8
Information in this document applies to any platform.

Symptoms

When the SQL for the Dynamic Candidate was generated, then the component crashes with SBL-GEN-03002
SBL-GEN-03002: Required parameter %1 is NULL

Cause

Technical Support was unable to duplicate the issue.  When creating an identically configured dynamic candidate, with criteria stored in the same tables as the customer candidate, the candidate runs successfully in the Siebel lab environment.
Eventually, through testing the candidate successfully on multiple versions of the application in the lab environment, it was suspected that the dictionary cache file diccache.dat or the assignment cache file rulecache.dat in the customer's installation did not contain the proper database information required to successfully perform the assignment process. 
This was suspected because the customer's dynamic candidate | candidate id column was an extension column.  Specifically, the diccache.dat file acts as a data dictionary in the assignment process.

Solution

Diccache.dat and Rulecache.dat are located in the siebsrvr\bin directory.  The customer was asked to perform the following steps:

1.  Stop the Siebel server service
2.  Browse the siebsrvr\bin directory and rename diccache.dat and rulecache.dat to backup_diccache.dat and backup_rulecache.dat (it is important to retain a backup copy of these files until you are certain all components are running successfully after the process).
3.  Restart the Siebel Server Service.  As part of the restart files, the 2 files will be regenerated to reflect the repository database settings.

After completing these steps, the issue was resolved for this customer