Hi Venkat,
looks like your database was migrated only partially leading to an inconsistent state.
DCC knows two modes for creating/updating or migrating the DB schemas: Products and Components.
Please note that the component “Archive” requires its own database schema, otherwise it won´t work correctly.
See Monitor Users Guide for details.
Additionally I recommend to split the schema into several smaller ones, so you won´t lose all configs/data completely when the schema crashes but only parts of them:
- BPM & IntegrationServer (ProcessEngine, ProcessAudit, ISInternal, DocumentHistiory, CrossReference, ISCoreAudit, DistributedLocking, TaskEngine for IS)
- TradingNetworks
- Optimize (for Infrastructure and Processes)
- MWS (consists of MWS, CommonDirectoryServices and CentralConfiguration)
- Archive
All of these schemas should be updated to “Latest” version using Products when available and using Components when no Product covers the appropriate function.
Regards,
Holger
#webMethods