Stored procedure parameters are deleted when you reimport physical models after upgrading InfoSphere Information Server.
Previously imported stored procedure parameters are deleted when you use InfoSphere Data Architect MetaBroker to reimport physical data models. This occurs after you apply the patch rollup_RU3_imam_all_8701 to InfoSphere Information Server, Version 8.7, after you upgrade to InfoSphere Information Server, Version 9.1, or after you apply the patch rollup_RU1_imam_all_9100-9101 to InfoSphere Information Server Version 9.1.
When you reimport a physical data model, the Preview screen for the staged import in InfoSphere Metadata Asset Manager shows that stored procedure parameters will be deleted. When you share the import, the stored procedure parameters are deleted.
Resolving the problem
To resolve this problem, share the reimport to metadata repository. This deletes the stored procedure parameters from the metadata repository. When you next reimport, the stored procedure parameters objects are imported into the metadata repository.
More support for:
InfoSphere Information Server
IBM InfoSphere Metadata Asset Manager
Software version: 8.7, 9.1
Operating system(s): Windows
Reference #: 1625814
Modified date: 15 May 2013