SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Job Import question

Reply
Contributor
Posts: 51

Job Import question

Dear all,

I am trying to export a job from 9.1.3 SP4 to 9.2 (via DI Studio) and out of my several hundred jobs 5 do not work. The import log says

--

ERROR - Fehler beim Verarbeiten von "/<...directory...>/" Fehler: The object or objects are not found in the mdassoc container in the repository.
com.sas.iom.SASIOMDefs.GenericError: The object or objects are not found in the mdassoc container in the repository.
at com.sas.iom.SASIOMDefs.GenericErrorHelper.read(GenericErrorHelper.java:21)
at com.sas.iom.SASIOMDefs.GenericErrorHelper.extract(GenericErrorHelper.java:46)
at com.sas.meta.SASOMI._portable_stub_IOMI.DoRequest(_portable_stub_IOMI.java:581)
at com.sas.metadata.remote.MdOMIWrapperImpl.DoRequest(MdOMIWrapperImpl.java:623)
at com.sas.metadata.remote.MdOMIUtilImpl.DoRequestNoReturn(MdOMIUtilImpl.java:2646)
at com.sas.metadata.remote.impl.MdObjectBaseXMLImpl.updateMetadataAll(MdObjectBaseXMLImpl.java:540)
at com.sas.metadata.remote.MdObjectStoreImpl.updatedMetadataAll(MdObjectStoreImpl.java:319)
at com.sas.etl.models.impl.OMRAdapter.save(OMRAdapter.java:400)
at com.sas.etl.migration.UpgradeJobAction.upgradeJob(UpgradeJobAction.java:640)
at com.sas.publicobjects.etl.Job.upgradeFromPreviousVersion(Job.java:282)
at com.sas.metadata.promotion.UpgradeManager.performCustomUpgrade(UpgradeManager.java:415)
at com.sas.metadata.promotion.UpgradeManager.upgradeObject(UpgradeManager.java:385)
at com.sas.metadata.promotion.UpgradeManager.upgradeObjects(UpgradeManager.java:236)
at com.sas.metadata.promotion.ImportHandler.upgradeObjects(ImportHandler.java:734)
at com.sas.metadata.promotion.ImportHandler.runImport(ImportHandler.java:562)
at com.sas.metadata.promotion.ImportHandler.runImport(ImportHandler.java:520)
at com.sas.metadata.promotion.visuals.ImportExecutePanel$ImportThread.launchImport(ImportExecutePanel.java:149)
at com.sas.metadata.promotion.visuals.ImportExecutePanel$ImportThread.run(ImportExecutePanel.java:130)

---

However, the job is imported, but when I open it the system prompts:

"The requested action is not available for this object / version 0.5 is not supported."

What to do?

Thanks,
Thomas
SAS Employee
Posts: 75

Re: Job Import question

Here's a topic that describes some special considerations when you are converting jobs from earlier releases to 9.2 (DI Studio 4.2). Do any of these conditions apply to your jobs that are not being converted?

http://support.sas.com/documentation/cdl/en/whatsdiff/62095/HTML/default/viewer.htm#a003313387.htm
Contributor
Posts: 51

Re: Job Import question

Posted in reply to DaveR_SAS
Hi Dave,

thanks for the quick reply!

I have checked the page, but I cannot find anything that would prevent the job from being imported.

Any other ideas? The job was created in DI Studio 3.4, does only contain out of the box SQL Join, Extract, Table Loader transformations.

Thanks,
Thomas
SAS Employee
Posts: 75

Re: Job Import question

This is just a guess: if you right-click the job, do you see an Upgrade option?
Contributor
Posts: 51

Re: Job Import question

Posted in reply to DaveR_SAS
Hi Dave,

there is an "upgrade" button, but it throws the same error as written in the first post.

Thomas
SAS Employee
Posts: 75

Re: Job Import question

Sorry that did not help. If no one else posts a solution, a tech support call might be in order.
SAS Employee
Posts: 51

Re: Job Import question

Posted in reply to DaveR_SAS
Thomas,

I found the information below in a support track that sounds very much like your problem. Please give this a try:

Q: The object or objects are not found in the mdassoc container in the repository

A: clean the mdassoc table with the "Analyze/Repair Metadata" tool in SMC. Start it via "Active Server" -> "Metadata Manager" plugin or directory of the repository. RMB for options.

If you need further description, please post again.

Thanks,

Tim Stearn
N/A
Posts: 1

Re: Job Import question

Hi,

Has there been any other resolution to his fix this? As the resolution which Tim suggested doesn't seem to work.

Thanks

Regards

SAS Employee
Posts: 33

Re: Job Import question

Hi Amol,

I recommend you open a tech support track for this issue so that it can investigated more thoroughly.

Regards,

Mike F.

Ask a Question
Discussion stats
  • 8 replies
  • 538 views
  • 0 likes
  • 5 in conversation