I am stuck with the Out of Temp Space while trying to build this cube. I created this cube base in May but the DBAs must have changed the temp space that is utilized by Sort Area and now I am getting the ugly error, I found an article that talks about turning off Auto Summary and testing that NOW but if you have any other ideas, please let me know. I am desperate since it worked back in May and the customer loves the Report using Cubes.
Tue 04 Jun 2013 15:39:04 4 0000E927 Timing, OPEN DATA SOURCE,00:00:02
Tue 04 Jun 2013 16:20:34 2 0000E927 RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
Tue 04 Jun 2013 16:20:34 2 0000E927 UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
Tue 04 Jun 2013 16:20:34 2 0000E927 UDA-SQL-0107 A general exception has occurred during the operation "open result".
Tue 04 Jun 2013 16:20:34 2 0000E927 ORA-01652: unable to extend temp segment by 7680 in tablespace TEMP
The DBAs are saying, they can't help and they don't have time to deal with it and you have to go to the Upper Mgmt!!
So, the question is, what can I change in Cognos Transformer 10.1.2 that would use less of Oracle's DB Temp Space area Or may
be a smaller chunk at a time to need from Oracle.