We have a reasonably complex query, that when we open it, and try and put the cursor into the Rule Form box the whole config tool just freezes and becomes unresponsive. Does anyone have a solution?
FYI - our config tool has 3000mb as memory settings, the dev box has 16GB of RAM. The CPU on the Java process is running at 120%+
Query:
FIND Franchisor WHERE EXISTS Industry WHERE ((Industry IN Franchisor.IndustryLINK AND Industry IN LoggedInRegularUser.IndustryLINK) OR LoggedInRegularUser.IndustryLINK IS UNDEFINED) AND (Franchisor.BusinessModels CONTAINS LoggedInRegularUser.BusinessModel1 OR LoggedInRegularUser.BusinessModel1 IS UNDEFINED) AND (Franchisor.BusinessModels CONTAINS LoggedInRegularUser.BusinessModel2 OR LoggedInRegularUser.BusinessModel2 IS UNDEFINED) AND (Franchisor.BusinessModels CONTAINS LoggedInRegularUser.BusinessModel3 OR LoggedInRegularUser.BusinessModel3 IS UNDEFINED) AND (Franchisor.BusinessModels CONTAINS LoggedInRegularUser.BusinessModel4 OR LoggedInRegularUser.BusinessModel4 IS UNDEFINED) AND (Franchisor.BusinessModels CONTAINS LoggedInRegularUser.BusinessModel5 OR LoggedInRegularUser.BusinessModel5 IS UNDEFINED) AND (Franchisor.BusinessModels CONTAINS LoggedInRegularUser.BusinessModel6 OR LoggedInRegularUser.BusinessModel6 IS UNDEFINED) AND (Franchisor.TotalInvestment<=LoggedInRegularUser.InvestmentHigh OR LoggedInRegularUser.InvestmentHigh IS UNDEFINED) AND EXISTS Market WHERE ((Market IN Franchisor.MarketLINK AND Market IN LoggedInRegularUser.MarketLINK) OR LoggedInRegularUser.MarketLINK IS UNDEFINED) AND (Franchisor.NumberofOutlets>=LoggedInRegularUser.OutletsFrom OR LoggedInRegularUser.OutletsFrom IS UNDEFINED) AND (Franchisor.NumberofOutlets<=LoggedInRegularUser.OutletsTo OR LoggedInRegularUser.OutletsTo IS UNDEFINED) AND (Franchisor.Name CONTAINS LoggedInRegularUser.FranchisorName OR LoggedInRegularUser.FranchisorName IS UNDEFINED) AND Franchisor.Status<>'Closed' ORDER BY Franchisor.Name
Config tool log says nothing of any importance.
