We have recently upgraded our dev and q/a systems to 7.01 SP5 (equivalent of 7.0 SP20). After the upgrade, queries using a variable on the ORG UNIT hierarchy fail with the following error: Error in BW: error creating tmp table . Notification Number RS_EXCEPTION 105
The same queries run fine if the hierarchy is not used. The problem occurs in queries written against DSOs. It does not occur in queries written against InfoSets.
The queries are BEX 3.5 queries. They run fine in our production system which has not been upgraded.
Has anyone else seen this?