Invalid User ID and Password Embedded in Generated Code of Report Jobs

The SAS IT Resource Management Gallery Transformation embeds the metadata server user ID and encoded password of the SAS Data Integration Studio user into the generated code that is produced for inclusion in the report jobs. If the user ID or password is changed, then the generated code must change for all of the corresponding jobs.

There are two ways to handle this issue:

Redeploy the jobs with the updated credentials. To do so, perform the following steps:
1. Open the SAS IT Resource Management client with the correct credentials.
2. Redeploy the reporting jobs. The newly deployed jobs will have the correct credentials.
Use an autoexec file to set the user ID and password. To do so, perform the following steps:
1. Add the following statements to the autoexec file for the deployed jobs:
  %global metauser metapass; %let metauser=<userid>; %let metapass=<password>;
  
  Note: The password can be entered in open text or can be encoded using the PWENCODE procedure.
2. If the deployed jobs are being run with the batch server, then add this code to the autoexec_usermods.sas file for the batch server.
3. If the jobs are being run with native SAS (using the SAS command or in interactive SAS), then create an autoexec file that contains the preceding code and use the –autoexec option.

For more information about the configuration file and how autoexec files should be set up so that they can be located by SAS, see the SAS documentation for your operating environment.