Unable to edit dvm from SOA composer

 Caused By: javax.ejb.EJBException: EJB Exception: ; nested exception is:
        oracle.fabric.common.FabricException:  oracle.mds.core.MetadataNotFoundException: MDS-00013: no metadata found  for metadata object  "/apps/abcEnterpriseDVMs/OracleOrgToWeighbridgeSiteMapping.dvm":  MDS-00013: no metadata found for metadata object  "/apps/abcEnterpriseDVMs/OracleOrgToWeighbridgeSiteMapping.dvm";  nested exception is: oracle.fabric.common.FabricException:  oracle.mds.core.MetadataNotFoundException: MDS-00013: no metadata found  for metadata object  "/apps/abcEnterpriseDVMs/OracleOrgToWeighbridgeSiteMapping.dvm":  MDS-00013: no metadata found for metadata object  "/apps/abcEnterpriseDVMs/OracleOrgToWeighbridgeSiteMapping.dvm"


The above errors are seen in the soa logs.

We fixed this by below solution.


The cause of this issue is invalid / incorrect data in <MDS_SCHEMA>.MDS_SANDBOXES.

Fix:
====
1 - Make a back up of the data for the table <MDS_SCHEMA>.MDS_SANDBOXES
2 - Delete the row with the name of the dictionary (or any other dictionary) on the table, commit the changes.(I truncated this table)
3 - Try to open the dictionary again on SOA Composer