Import Metadata : An unexpected exception occurred accessing the repository:

Question

Why when trying to import metadata through the connector wizard using InfoSphere Information Server tools, such as InfoSphere Information Analyzer, InfoSphere DataStage Designer, InfoSphere FastTrack or InfoSphere Business Glossary, user gets the following error?:

"An unexpected exception occurred accessing the repository"
JavaException
Caused by:
com.ascential.xmeta.exception.runtime.AuthenticationException:
User xxxxxxxx is not authorized to perform the operation:
CommonMetadata.commonMetadataImportRoles

Cause

Due to user not having the "Common Metadata Administrator" role assigned.
You can add this role to the user through the InformationServer web console, 'Administration', 'Users and Groups', Users, select user, 'Open User', Under Roles, tick 'Common Metadata Administrator', Save and Close.


Answer

InfoSphere Information Server tools, such as InfoSphere Information Analyzer, InfoSphere DataStage Designer, InfoSphere FastTrack or InfoSphere Business Glossary require the "Common Metadata Administrator" role by design. See the following link:


http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.iisinfsv.assetint.doc%2Ftopics%2Fpdr_cli_import.html

This behaviour which was not working correctly before release 8.7.0.1 (8.7 fixpack 1), allowed users to import metadata without this role. Now that the bug has been fixed in 8.7.0.1, it will fail as the software is working as expected and users are required to have this role.






Popular posts from this blog

Shrink you container size up to 95%.

alma linux: dnf Module yaml error: Unexpected key in data