I am facing a strange issue with ASCP Planner Workbench. We got a centralized instance. For TST instance, complete refresh is run and data is collected. Gather Schema Statistics run successfully with 40%. ASCP plan is run successfully.
Now while opening planner workbench, the planner workbench query hangs. Few queries work but then hangs again for the next step. Foe example: - If I run query to find specific item then query hangs. If it runs successfully ( after a long time) and I want to query Supply and Demand for specific item then again it hangs.
This is highly frustrating situation.
Request your input on what can be the issue and the resolutions if any.