Maximo Open Forum

When you are importing database back up ,rather than importing whole back up, you need to do table by table backup and exclude table storing XMLs which you don't want to refresh. Even if you do for it, you will still have problem in syncing all other xmls stored in same table.

B solution is to take backup of XMLs and import them after DB refresh either by MXLoader or by Manually as part of Post Refreshment activity. 

@ Prashant Sharma,

noted on that, may I ask if are you're familiar with the database table where the menu.xml and library.xml are stored?

Thanks

Hi @RJ Agnes! 

The table is maxpresentation. You can see both with the next query:

select * from maximo.maxpresentation where app in ('MENUS','LIBRARY')

Regards!

Rather than mess with the DB refresh, a better approach might be to structure the dialog that is displaying the environment information to read the information from somewhere where you can store the information for each environment and retrieve the information based on the current environment.  You could possibly create user-defined System Properties where part of the PropName is the DB Name and retrieve the appropriate record using a relationship that gets the MaxPropValue record corresponding to the PropName for the current environment.  How exactly to do that varies depending on your DB and, if Oracle, whether you're using a Containerized DB.