Share all details about your problem, including any error messages you may have received.
Does anyone have experince with migrating their Access History database between hosts? My company has a separate team of database administrators that want to move my Oracle Access History database to a new host. What process would I need to follow in order to support this?
We run Sailpoint identity IIQ 8.4 across 4 RHEL linux servers (2 UI servers and 2 task/request server). Our Access History database is Oracle, and we leverage an external connection broker (Windows) running ActiveMQ.
I’m familar with the iiq.properties file and see where our Oracle connection strings are defined. Is this as straightforward as stopping tomcat, updating that file to point to the new Oracle database host, and restarting tomcat? Am I missing any steps?
more or less, SP have an easy configuration for DB.
Usually DB are installed in a different server rispect of application and everything is stored into DB, so you can migrate or change DB in a relatively easy way.
Yes this is.
Stop tomcat on all server
Copy/Migrate from old DB to the newer
Update iiq.properties ( and build.proprieties if use SSB)
Restart tomcat
Easy easy
PS Remember to open the comunication to new DB server
Followed these steps without issue, but seeing the following errors in log files now, indicating an issue connecting to my Windows connection broker:
2024-08-21T02:00:52,896 ERROR ActiveMQ Task-1 activemq.transport.failover.FailoverTransport:1089 - Failed to connect to [tcp://<myservername>:61616] after: 10 attempt(s)
-where <myservername> is the FQDN of my windows connection broker
The Dispatch Access History task also fails and returns error: An error occurred communicating with the broker. Please confirm the broker is available to receive messages.
Can someone point me to the firewall rules necessary between all my linux sailpoint servers and windows connection broker?
I’m seeing connections in ActiveMQ on my windows connection broker, but I’d like to confirm nothing is being blocked and I have the correct connection protocols and ports opened.
