This SAS KB article describes issues with the demographic job loader 3008, which causes several errors to occur.
The demographic loader job 3008 attempts to create the bat_job_sysin.lst file in the current working directory. The command to run the batch job is as follows: bat_run_job.sh -j 3008.
However, an issue occurs if the user running the job does not have Write access to the current working directory. As a result, the following error is written to the job log:
2025-04-24T11:58:46,613 ERROR [00000098] :s4q1spl - ERROR: Insufficient authorization to access /sasvol01/sashome94/SASFoundation/9.4/misc/fsmcm/scripts/bat_job_sysin.lst.
On Oracle and PostgreSQL systems, the SAS Fraud Management user required to run job 3008 is the Batch Special user. On IBM DB2 systems, the required user to run the job is the Batch user.
Note: If the user does have Write access, the above error does not occur, and the job completes successfully.
The demographic data loader job 3008 loads data from two pipe-delimited files into the FCM_CONTACT and FCM_ENTITY tables in the System of Record (SOR) database. The default names of the input files are custDemo and entity.txt. When the entity.txt file is empty, however, several error messages are printed to the log file, and the job aborts.
The error messages in the log are as follows:
2025-04-29T13:23:00,682 INFO [00000096] :s4q1spl - NOTE: Line generated by the macro variable "TOTAL_XML_LENGTH".
2025-04-29T13:23:00,682 INFO [00000096] :s4q1spl - 334 $ .
2025-04-29T13:23:00,682 ERROR [00000096] :s4q1spl - _
2025-04-29T13:23:00,682 ERROR [00000096] :s4q1spl - 391
2025-04-29T13:23:00,682 ERROR [00000096] :s4q1spl - 200
…
2025-04-29T13:23:00,682 ERROR [00000096] :s4q1spl - ERROR 391-185: Expecting a variable length specification.
2025-04-29T13:23:00,682 ERROR [00000096] :s4q1spl - ERROR 200-322: The symbol is not recognized and will be ignored.
…
2025-04-29T13:23:00,684 INFO [00000098] :s4q1spl - NOTE: Line generated by the macro variable "TABOPTS".
2025-04-29T13:23:00,684 INFO [00000098] :s4q1spl - 334 DBMAX_TEXT=&total_xml_length BL_USE_PIPE=YES BL_RECOVERABLE=NO BL_LOAD_METHOD=REPLACE BULKLOAD=YES BL_DELETE_FILES=NO
2025-04-29T13:23:00,684 ERROR [00000098] :s4q1spl - __________
2025-04-29T13:23:00,684 ERROR [00000098] :s4q1spl - 23
…
2025-04-29T13:23:00,731 ERROR [00000098] :s4q1spl - ERROR 23-7: Invalid value for the DBMAX_TEXT option.
…
2025-04-29T13:23:00,762 ERROR [00000006] :s4q1spl - ERROR: Aborting batch job.
…
2025-04-29T13:23:00,762 ERROR [00000006] :s4q1spl - ERROR: problems loading offline entity table.
…
2025-04-29T13:23:00,919 ERROR [00000006] :s4q1spl - ERROR: Errors printed on pages 77,78,79,81.