SAS execution of [ugip_apm_datamart.sas] failed with rc 2

shoin — Wed, 29 Apr 2020 21:57:19 GMT

In SAS EVM after an UIP attempting to update SAS EVM as well. Any idea why that pgm is flagged?

The status via emi_init.sh -s is

./emi_init.sh -s
Service Architecture settings:
Level Root Dir : [/sas/config/Lev1]
Base Dir : [/sas/config/Lev1/Web/SASEnvironmentManager/emi-framework]
Initialized : [true]
Enabled : [true]
APM Initialized : [true]
ACM Initialized : [true]
APM Enabled : [true]
ACM Enabled : [true]
VA Feed Enabled : [false]

The utility output is:

./ugip_init.sh
Service Architecture Upgrade-in-Place Utility - Wed Apr 29 16:23:54 CDT 2020
Pending upgrade-in-place of the Service Architecture detected...

The original Service Architecture deployment directory has been moved to /sas/config/Lev1/Web/SASEnvironmentManager/emi-framework_2019-02-28_16.22.28
Existing datamart data has been moved to the current deployment

Preparing to back up existing SAS metadata content...
Backing up existing SAS metadata content

Deleting existing SAS Environment Manager metadata folder and contents...

Loading Service Architecture metadata content...
Loading SAS Package [emiContent.spk]

Updating kits...
Service Architecture Kit Installer - Wed Apr 29 16:24:31 CDT 2020
Installing all available kits...
Installing kit [SASJobs]...
Installing kit [WebServer]...
Installing kit [DSA]...
Installing kit [emi-framework]...
Installing kit [VALASR]...
Installing kit [SASGrid]...
Installing kit [sas-servers]...
Installing kit [MBL]...
Configuring kit [SASJobs] ...
Configuring kit [WebServer] ...
Configuring kit [DSA] ...
Configuring kit [emi-framework] ...
Configuring kit [VALASR] ...
Configuring kit [SASGrid] ...
Configuring kit [sas-servers] ...
Configuring kit [MBL] ...

Starting Data Mart Schema Migrations...
ACM is initialized; updating data schema.
APM is initialized; updating data schema.
ugip_apm_datamart.sas execution failed with return code 2

Exiting Service Architecture Upgrade-in-Place Utility
The upgrade-in-place of the Service Architecture did NOT complete successfully
Check ugipInit_20200429_162353.log for details, correct any issues and rerun this script

The upgrade-in-place of the Service Architecture did NOT complete successfully
Check ugipInit_20200429_163232.log for details,

The error in the log is

-rw-r--r--. 1 sas sasg 27357 Apr 29 16:33 ugipInit_20200429_163232.log
[sas@sasva Logs]$ grep -i ERROR ./ugipInit_20200429_163232.log
2020-04-29 16:33:26,862 INFO [main] [evKitInstaller] - Level 2 validation completed with 0 error(s) in 17.328 sec
2020-04-29 16:33:40,989 ERROR [main] [ugipInit] - SAS execution of [ugip_apm_datamart.sas] failed with rc 2

The said sas code has no issues and i ensured that it was chmod to 744

Re: SAS execution of [ugip_apm_datamart.sas] failed with rc 2

AnandVyas — Fri, 01 May 2020 07:17:45 GMT

Can you share the full log? ugipInit_20200429_163232.log

Re: SAS execution of [ugip_apm_datamart.sas] failed with rc 2

Hrry — Sat, 06 Jun 2020 22:39:13 GMT

Maybe this helps. Check the logs! emi-framework\Logs

On my site, one of the datafiles was corrupted, I simply renamed it (or repair/restore it if you need the data).

2020-06-07 00:21:36,864 ERROR [main] [ugipInit] - SAS execution of [ugip_acm_datamart.sas] failed with rc 2

Reason:

NOTE: File ACM.TCSSERVERMGRS.DATA is damaged.

[sasconfig]Lev1\Web\SASEnvironmentManager\emi-framework\Datamart\acm\tcsservermgrs.sas7bdat
Renamed, and it worked. If you need any data back, recover it.

Re: SAS execution of [ugip_apm_datamart.sas] failed with rc 2

shoin — Mon, 08 Jun 2020 18:21:23 GMT

TY for the suggestion, I will check and update.

topic Re: SAS execution of [ugip_apm_datamart.sas] failed with rc 2 in Administration and Deployment

SAS execution of [ugip_apm_datamart.sas] failed with rc 2

Re: SAS execution of [ugip_apm_datamart.sas] failed with rc 2

Re: SAS execution of [ugip_apm_datamart.sas] failed with rc 2

Re: SAS execution of [ugip_apm_datamart.sas] failed with rc 2