topic Re: DIS - Import SAS Package issue in SAS Programming

DIS - Import SAS Package issue

maubry — Thu, 09 Dec 2021 22:15:03 GMT

Hi,

I'm migrating SAS 9.4 M5 (Windows) to SAS 9.4 M7 (Linux). During the process, I have to migrate several DI jobs.
Very easy steps with DI Studio

Export SAS Packages
Select all jobs & Check dependencies
Confirm
Import Packages on the other server

Everything was fine but I forgot to migrate only one DI Job. I applied the same steps and during the import on the new server :

The import process finished with errors. For more details, view the import log.

In the error log, I see this:

The error message is:

ERROR - Error importing metadata. Reason: The event pre-defined container in the Foundation repository cannot be registered because it contains data.

It seems the error is caused by the job itself and only when importing on the new server.

Any ideas on what's happens or what can I check because I have no idea anymore

Many thanks for your help.

Mykel

Re: DIS - Import SAS Package issue

LinusH — Fri, 10 Dec 2021 08:25:19 GMT

Found this, so try to run the repaitr wizard:

https://communities.sas.com/t5/Administration-and-Deployment/Why-Importing-Metadata-gives-I-O-subsystem-error/td-p/413184

Re: DIS - Import SAS Package issue

maubry — Fri, 10 Dec 2021 12:31:51 GMT

Hi LinusH,
many thanks for your previous answer. And I share my "experience":

I run the tool "Analyze/Repair Metadata" :

Backup Metadata first
SAS Management Console
- Metadata Manager
  - Right click on Active Server + Analyze/Repair Metadata

The tool will analyze all metadata objects (permissions, folder structure, orphaned objects, ...).

You can :

Analyze and Repair during the same process
Analyze only
Repair after checking each "warning message" (the log is very helpful).

But during that process (Analyze/repair Metadata), the Metadata server is paused and nobody can't access to SAS (neither run code, ...).
The only thing allowed are only administrative tasks on the metadata. All sessions (except Management Console) are interrupted and I'm not sure it was done properly.

Be careful when running this tool and inform your users otherwise, they can lost some work.

@LinusH many thanks for your help 🙂