too big kdb file in Exec Engine

Question

Hi all, 
 
 One of our Process Exec engines does not start and it is too big. Because of that the development Environment is not usable. You can see in the screenshot attached that the .kdb file is around 6 GB

Do you know what can we do? can we delete the file as this is the development Environment we dont mind if we lose instances but we dont want to lose imporant stuff such as process models. 
 
 We are using appian 7.9 
 
 Many thanks!

Eliot Gerson · Accepted Answer

As noted in the Knowledge Base article, there needs to be sufficient memory. It's not possible to start the engine without using memory. 
 
If you don't have sufficient memory to start the engine, even without starting the other execution engines, you may need to add additional memory. 
 
One temporary way to do so could be to increase the amount of swap space. While this would likely make things really slow, and is not a configuration that I would recommend keeping beyond the time needed to troubleshoot the issue, it would potentially give you more resources to use for loading the kdb. Once the environment was up and running, you could then archive or delete processes to reduce the memory footprint, stop the engines, change the swap space configuration back to normal, and then start everything back up again.

vishnuv · Answer

Hi, 
Is there any error that you see in logs ? 
1. Check db PX051_*.log and gw_PX051_*.log for any errors. 
2. Also, can you help with the database version being used so as to validate the issue. 
3. Can you also confirm if ANT_HOME is referring to path - <APPIAN_HOME>\ hirdpartyapps\apache-ant\classes\com\appian\ant\datamaintenance 
 
Thanks.