Hi, I have installed FMS with HA on 2 server. But found lot of cartridges are not being installed during the installation. Showing below type of dependecies error and unable to install any type of cartriges on FMS. Found lot cartridges are in disable state, tried to enable those but failed.
2019-07-08 08:43:14.774 WARN ARJUNA012125: TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffffac1df110:ac43:5d233a2e:1ea0, org.hibernate.transaction.CacheSynchronization >
2019-07-08 08:43:14.831 ERROR An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.
2019-07-08 08:43:14.834 ERROR Cartridge FglAM-Adapter-5.9.4 could not be enabled. Enabling component FglAMConfiguration-5.9.4 failed with error: java.lang.RuntimeException: Failed to commit transaction.. All components of FglAM-Adapter-5.9.4 will be disabled.
2019-07-08 08:43:14.901 WARN Not all components of cartridge FglAM-Adapter-5_9_4 can be disabled successfully. Please check log file for detail.
2019-07-08 08:43:30.094 WARN ARJUNA012125: TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffffac1df110:ac43:5d233a2e:6e50, org.hibernate.transaction.CacheSynchronization >
2019-07-08 08:43:30.272 ERROR Cartridge Core-ServiceModel-Extensions-5.9.4 could not be enabled. Enabling component MonitoringPolicy- failed with error: java.lang.RuntimeException: Failed to commit transaction.. All components of Core-ServiceModel-Extensions-5.9.4 will be disabled.
2019-07-08 08:43:30.307 WARN Cannot enable cartridge Core-Services-5.9.4 on because of missing dependencies com.quest.nitro.service.cartridge.api.CartridgeDependencyException: Missing dependency for Cartridge: Core-Services-5.9.4 - 5.9.4-201811081709-c2d39206:Core-ServiceModel-Extensions-5.9.4 (matches: LATEST).
2019-07-08 08:43:30.308 WARN Cannot enable cartridge Core-ServiceModel-Extensions-UI-5.9.4 on because of missing dependencies com.quest.nitro.service.cartridge.api.CartridgeDependencyException: Missing dependencies for Cartridge: Core-ServiceModel-Extensions-UI-5.9.4 - 5.9.4-201811080655-631:Core-ServiceModel-Extensions-5.9.2 (matches: LATEST)Core-Services-5.9.2 (matches: LATEST).
We found few DB related error, which is saying that few tables doesn't have the primary key. As per DB team, inorder to resolve this issue we have to fix those tables by creating primary key for those. But i don't have any idea to fix this. Need urgent help on this to fix and let me know if i am missing anything.