topic Re: Job Import question in SAS Data Management

Job Import question

ThomasH — Mon, 21 Mar 2011 16:41:20 GMT

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

Re: Job Import question

DaveR_SAS — Mon, 21 Mar 2011 17:30:25 GMT

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

Re: Job Import question

ThomasH — Tue, 22 Mar 2011 10:30:23 GMT

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

Re: Job Import question

DaveR_SAS — Tue, 22 Mar 2011 12:08:06 GMT

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

Re: Job Import question

ThomasH — Tue, 22 Mar 2011 14:09:36 GMT

Hi Dave,

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

Thomas

Re: Job Import question

DaveR_SAS — Tue, 22 Mar 2011 14:13:05 GMT

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

Re: Job Import question

TimStearn_SASProductManagement_ — Tue, 22 Mar 2011 16:06:15 GMT

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

Re: Job Import question

AWaykar — Thu, 12 Sep 2013 12:59:42 GMT

Hi,

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

Thanks

Regards

Re: Job Import question

MikeFrost — Sat, 14 Sep 2013 13:42:37 GMT

Hi Amol,

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

Regards,

Mike F.