Topic
  • 3 replies
  • Latest Post - ‏2013-07-08T17:08:18Z by GOICEHOCKEY
GOICEHOCKEY
GOICEHOCKEY
135 Posts

Pinned topic Building Cognos Cube

‏2013-06-28T12:36:13Z |

Hi guys,

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.

  • rperzul
    rperzul
    25 Posts

    Re: Building Cognos Cube

    ‏2013-07-01T19:12:26Z  

    Hi,

    I guess that there is nothing that you can do in Cognos. It is definitely an Oracle error. Have you checked this?

    http://www-01.ibm.com/support/docview.wss?uid=swg21343686

    Regards,

    Ron

  • GOICEHOCKEY
    GOICEHOCKEY
    135 Posts

    Re: Building Cognos Cube

    ‏2013-07-02T14:59:29Z  
    • rperzul
    • ‏2013-07-01T19:12:26Z

    Hi,

    I guess that there is nothing that you can do in Cognos. It is definitely an Oracle error. Have you checked this?

    http://www-01.ibm.com/support/docview.wss?uid=swg21343686

    Regards,

    Ron

    Thank you Ron. I took your info and approached the DBA with some mgmt support. I take it it's best to have a temp tablespace associated

    to the user and not a default one that everyone utilizes.

    Thx for your help!!

  • GOICEHOCKEY
    GOICEHOCKEY
    135 Posts

    Re: Building Cognos Cube

    ‏2013-07-08T17:08:18Z  

    Thank you Ron. I took your info and approached the DBA with some mgmt support. I take it it's best to have a temp tablespace associated

    to the user and not a default one that everyone utilizes.

    Thx for your help!!

    Do you know by any chance or could you be able to direct me to anyone or document that is related to dealing with multiple Cubes per 3-Year. What I am mean it to create separate cubes to the cube creation is less intense but to be able to upload all the cubes from multiple years into a single Report Author and to include the multiple cubes As a part of all queries in the cube.

    There has to be a way!

    Thx