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 🙂

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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