BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
maubry
Obsidian | Level 7

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:

maubry_0-1639087845027.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
2 REPLIES 2
LinusH
Tourmaline | Level 20

Found this, so try to run the repaitr wizard:

https://communities.sas.com/t5/Administration-and-Deployment/Why-Importing-Metadata-gives-I-O-subsys...

 

Data never sleeps
maubry
Obsidian | Level 7

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

maubry_0-1639139088312.png

 

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 🙂

sas-innovate-white.png

🚨 Early Bird Rate Extended!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Lock in the best rate now before the price increases on April 1.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1102 views
  • 1 like
  • 2 in conversation