Tip
This topic pertains only to
reports that were created in SAS IT Resource Management 3.2 and migrated
to SAS IT Resource Management 3.3. It does not apply to reports that
are created in SAS IT Resource Management 3.3.
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:
-
Open the SAS IT Resource
Management client with the correct credentials.
-
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:
-
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.
-
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.
-
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.