Question:
Why am I seeing the following error after starting the Logi Report server cluster? Error Message: "Database is already being used by another Logi Report Server or Logi Report Cluster".
Answer: This error indicates that the two nodes in the cluster can't communicate with each other. Check the following settings to resolve the issue:
- Network and firewall settings to ensure the two nodes can communicate with each other. Try pinging each node to ensure it's responding.
- You can modify the property "server.rmiserver.fixed_port" in server.properties file as shown below. When Logi Report Server sits behind the firewall, please open port 1129 and 1130 in the inbound and outbound rules for each server.
For Server 1:
server.rmi.host=Your IP
server.rmi.port=Your Port Number
server.rmiadminservice.enable=true
server.rmimonitor.enable=true
server.rmiserver.enable=true
server.rmiserver.fixed_port=Your Port Number
For Server 2
server.rmi.host=Your IP
server.rmi.port=Your Port Number
server.rmiadminservice.enable=true
server.rmimonitor.enable=true
server.rmiserver.enable=true
server.rmiserver.fixed_port=Your Port Number
3. Add the IP address for each cluster to jgroups.xml file.
4. If you are using multiple IP addresses on a clustered server, please add -Djgroups.bind_addr=IP address to the JRServer.bat and NTservice.ini file located in <install_root>\bin to make sure the server can be started successfully.
Further Reading