Strange memory error running query in PROD.
edited Oct 3, 2019 5:01AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 9 commentsAnswered ✓
I have a query that uses trees. It's running in under 20 seconds in our test environment that is refreshed every day at 4am. But in PROD, it either times out, or I get the following error message:
Unable to find node AY_EVEN. This could be caused by a tree change or lack of memory. (24,4)
[Open Query] [CQryStmt::Prepare] could not generate SQL for query [ PUBLIC.UCFA_E_GRAD_F_V ]
I've verified that the tree node is good and has not been touched. What memory should we be checking?
We had a query last week timing out as well out of nowhere that does not contain trees. That query is working fine again. And, had not been changed. So, it's all very odd.
2