After importing QA/PROD dump and running developer tranform scripts (Retrieve a backup database from a safe place in production and load it on your laptop, Make the database safe to develop upon) EMS might not work correctly (e.g. showing no data in the host tree and widgets).

At the time of writing this it is caused by the transform scripts being outdated and not changing many of the configuration in db that is vital for correct EMS operation.

Following steps can be done in order to make sure everyting works fine:

• make sure you ran all the relevant upgrade scripts from the idms-sql-scripts repository (e.g. when using dump from 3.2, you should run the 3.3 upgrade scripts when developing 3.3)
• check the db_app_configuration table and verify all the URLs/hosts are correcty
• check the remote_thread_config and thread_config for correct data, they should look something like this:
  • remote_thread_config

'26', '0', 'localhost', 'rmi://localhost:1099/RemoteThreadService', 'JAVA_RMI', '4445', '8000', NULL, '16777216' 

• thread_config

'37', 'localhost', 'localhost', '1', 'DISTRIBUTOR_AND_HANDLER', NULL, NULL
'38', 'localhost', 'localhost', '1', 'IP_CONNECTIVITY', NULL, NULL
'39', 'localhost', 'localhost', '1', 'TRAP_FORWARDER', NULL, NULL

• re-create clusters
  • Run in db: delete FROM snmp_manager.shiro_user_cluster where shiro_user_clusters_id = 1; (delete all cluster assignments for admin)
  • Go to ShiroUser controller and reassign all the clusters back to admin