Process to follow when a Qlik Visibility monitored database is upgraded to a newer version

[Nanda_Ravindra]

Environment

• Qlik Visibility 
• Databases: Oracle, DB2, Teradata, and Hadoop

The following steps need to be followed when the Visibility monitored database is upgraded to a newer version. The below steps are for when Oracle Database is upgrade from 12C to 19C.

1. Back the current $VISIBILITY_HOME/server/config/server.properties file

2. Edit the Origin section of the $VISIBILITY_HOME/server/config/server.properties file and replace the below with the new connection information for the monitored Warehouse:

   Server.Origin.Name.X=<warehousename>   <---- The name of the monitored database name. This name must match the name in your license key.

   Server.Origin.UserName.X=<repository-user>

   Server.Origin.Password.X=<repository-password>

   Server.Origin.Database.X=<repository-database>  <---- The connection string to connect to the monitored database.

3. Edit the Cataloger section of the $VISIBILITY_HOME/server/config/server.properties file and replace the below:

   Server.Origin.Name.X=devfc19 <--- The name of the monitored system being cataloged. This must match the name in your license key as well as the value for the Server.Origin.Names.X  property.

4. Run the below catalog command:

   cd $VISIBILITY_HOME/server/bin

   ./cataloger -sc -catalog <warehouse-database-name>

    Note: It's best to run the above command using nohup option since the catalog process can take longer to finish based on the number of objects you have in the monitored database.

    Like this:   nohup ./cataloger -sc -catalog <warehouse-database-name> &

[sarata02]

Team, can some one help where can we find the license file please?

[sarata02]

Can anyone help to update the license file with a new DB to be added for monitoring pls

[Sonja_Bauernfeind]

Hello @sarata02 

Let me look into this for you.

All the best,
Sonja 

[sarata02]

Thank you so much @Sonja_Bauernfeind  for a quick reply.

[Nanda_Ravindra]

Hello @sarata02 

Unfortunately, you won’t be able to get the license for the Qlik Visibility product as this product has been retired since January 31, 2022.

Please refer to the below link for the product retirement announcement.

https://community.qlik.com/t5/Support-Updates/Retirement-of-legacy-Attunity-products-on-January-31-2...

Hope this helps!

Thanks,

Nanda