The root cause for the issue is a large database.
When trying to view a database revision, the FWM process generates CPMILinksMgr.db cache files for each database revision in $FWDIR/conf/db_versions/databases/<Database revision ID> directory. Since the database is large, the CPMILinksMgr.db file is also large and this causes the connection to time out.