I recently installed a new ECS server version 10.5. We have been running 8.6 for a long time but licensing was not supported anymore and we had no choice but to go with the newest version in order to accommodate more users. Since we did not choose the upgrade path, everything was installed from scratch.
I installed the new ECS, setup all the QE’s, fine tuned all the query settings and distribution rules. Everything seems to run fine while testing basic queries, just noticed all our bigger reports take double the time to complete when compared with version 8.6. After some investigating I noticed the 10.5 master QE was doing all the work, it was not passing out jobs to the other QE sources. Just recently I have applied all the hot fixes and I’m currently on version 10.50 SP1. I have triple checked all my setting and they are basically the same as with 8.6 when I compare them side by side... same problems even after hotfixes.
One thing I noticed on the ESC server is that the Enable Firewall Exception registration setting under QE setting, Advanced Security is blanked out. Could it be because the server is a VM box? I can’t enable or disable it and this is bothering me. Anyone know why this setting is disabled and how I can turn it back on? Any ideas on why my jobs are not being distributed to the other available QE engines? I’m out of idea.
PLEASE HELP!
Just an FYI ... there is nothing in logs and there are no errors anywhere.