Our Qlik server has crashed. It's a multi-node setup and initially the error was with posgres (corrupted logs) and the postgres server was inactive, but after a cleanup the postgres server is functioning correctly.
However, in the rim nodes, the Repository Service is stopping continuosly. Even after rebooting the servers and processes in the correct sequence, the Repository Service continues to stop after a while.
Checking the log in C:\ProgramData\Qlik\Sense\Log\Repository\System gave me this fatal error:
Command=Start repository;Result=-2146233079;ResultText=Error: A relationship multiplicity constraint violation occurred: An EntityReference can have no more than one related object, but the query returned more than one related object. This is a non-recoverable error. 0 0 0 INTERNAL System 0 Not available Repository Not available Not available Start repository
How would i go about fixing this issue?
Thank you,
Adarsh