In SAS ^® Credit Scoring for Banking, after you create a PD model and published it, you run the job MasterLoopModelDevJob from SAS^® Data Integration Studio. However, you might encounter a problem with the &status_table variable and the job fails. An error message similar to the following is displayed in the job log:

MLOGIC(UPD_STATUS):  %PUT ERROR: %sysfunc(sasmsg(smd_ds.bismsg,csmart.model_dev_load_error.1, noquote))
ERROR: Errors in loading model development data in Credit Scoring Additions Mart. Check Parameter_List_Model_dev table and log files
MLOGIC(UPD_STATUS):  %ABORT ABEND
ERROR: Execution terminated by an %ABORT statement.

The inner-loop jobs MasterLoopModelDevJob and MasterLoopCreditScoringJob, and other master jobs, have an option "Run jobs in parallel". In the original job from SAS Credit Scoring for Banking, this option is selected so that jobs run in parallel. If this option is deselected, then jobs fail because they do not find the status table "work.loop_Job_status" to update the status.

If you turn off parallel execution (the option is deselected), then you need to make the following modification to job metadata. Use these steps to add code in the Loop Transform pre-code section of the master loop jobs. These steps must be performed to this list of jobs:

• MasterLoopStarSchemaJob
• MasterLoopModelDevJob
• MasterLoopCreditScoringJob
• MasterLoopPoolScoreJob
• MasterLoopBusinessReportsJob

1. Log on to SAS Data Integration Studio using the Admin role.
2. Close any open SAS Data Integration Studio jobs, and SAS sessions (examples: Base SAS^®, SAS^® Enterprise Guide).
3. Go to the desired master loop job and open it.
4. Select Loop Transform in this job. Right-click the selected Loop Transform and select Properties.
5. Go to the Pre-Code tab and add the following code.
data work.loop_Job_status (keep = etls_handleName etls_machineId etls_startTime etls_endTime etls_status etls_jobRC JOB_NM); attrib etls_handleName length = $32 label = 'Name of handle to remote session'; attrib etls_machineId length = $32 label = 'Name of machine executing the task'; attrib etls_startTime length = 8 format = DATETIME. informat = DATETIME. label = 'Start time of task'; attrib etls_endTime length = 8 format = DATETIME. informat = DATETIME. label = 'End time of task'; attrib etls_status length = $32 label = 'Current status of task'; attrib etls_jobRC length = 8 label = 'Return code of task'; attrib JOB_NM length = $40; run;
6. Save the changes, and close the job.
7. Run the job.

Operating System and Release Information

data work.loop_Job_status
      (keep = etls_handleName etls_machineId etls_startTime etls_endTime etls_status 
              etls_jobRC JOB_NM
      );
      attrib etls_handleName length = $32
         label = 'Name of handle to remote session'; 
      attrib etls_machineId length = $32
         label = 'Name of machine executing the task'; 
      attrib etls_startTime length = 8
         format = DATETIME.
         informat = DATETIME.
         label = 'Start time of task'; 
      attrib etls_endTime length = 8
         format = DATETIME.
         informat = DATETIME.
         label = 'End time of task'; 
      attrib etls_status length = $32
         label = 'Current status of task'; 
      attrib etls_jobRC length = 8
         label = 'Return code of task'; 
      attrib JOB_NM length = $40; 
run;