Error in MDS deploying SOA App
Hi,
Today we found that we can't deploy SOA Apps with the following error.
[11:42:29 AM] Error deploying archive sca_PruebaMDS_rev1.0.jar to partition "default" on server WLS_SOA2 [soa2.xxx.xx:8001, Cluster:SOA_Cluster]
[11:42:29 AM] HTTP error code returned [500]
[11:42:29 AM] Error message from server:
Error during deployment: oracle.mds.transfer.TransferException:
MDS-00001: exception in Metadata Services layer
MDS-00515: failure to create document /deployed-composites/default/PruebaMDS_rev1.0/default.bpmn in the metadata repository
MDS-00910: unable to save the document because the database sequence "MDS_DOCUMENT_ID_NN_S" is corrupt
ORA-20102:
ORA-06512: at "PROD_MDS.MDS_INTERNAL_COMMON", line 1584
ORA-06512: at line 1
We found the following detail in documentation, but we don't know how to fix it.
MDS-00910: unable to save the document because the database sequence "MDS_DOCUMENT_ID_NN_S" is corrupt
Cause: The database sequence used for generating the unique document ID was corrupt.
Action: Retry the operation after deploying metadata to another MDS database repository partition.
Level: 1
Type: ERROR
Impact: Data
Thank You!!!
JP