AIA Configuration Reload Error MDS-00557

Ran into MDS-00557 today while trying to update an AIA configuration to MDS. In my case the error was happening when running an ant with UpdateMetadata.xml for AIA.

The error
[deployComposite] ---->response code=500, error:Error during deployment: Data transfer error in MDS.:
[deployComposite] MDS-00001: exception in Metadata Services layer
[deployComposite] MDS-00522: failure to save document /apps/META-INF/MANIFEST.MF to the metadata repository
[deployComposite] MDS-00557: Resource /apps/META-INF/MANIFEST.MF is already locked or is being modified.
[deployComposite]
[deployComposite] MDS-00001: exception in Metadata Services layer
[deployComposite] MDS-00522: failure to save document /apps/AIAMetaData/config/AIAConfigurationProperties.xml to the metadata repository
[deployComposite] MDS-00557: Resource /apps/AIAMetaData/config/AIAConfigurationProperties.xml is already locked or is being modified.

Solution

This error happens when there is a lock file in the Reload process. Look for any .lck files inside Reload process and delete them.

 rm ./Infrastructure/CAVS/ReloadProcess/classes/.data/00000000/je.lck ./Infrastructure/CAVS/ReloadProcess/SCA-INF/classes/.data/00000000/je.lck

If the above solution doesn't help, check the database and make sure there are no orphaned sessions locking the MDS tables.

select * from v$session s, v$process p where s.paddr = p.addr and s.sid in (select SESSION_ID from v$locked_object);

alter system kill session 'sid,serial' immediate;