My Oracle Support Banner

Error: " ORA-01652: unable to extend temp segment by 128 in tablespace" When Running an Analysis With Notebook Text in OBIEE (Doc ID 2420177.1)

Last updated on JULY 17, 2018

Applies to:

Primavera Analytics - Version 17.7 and later
Information in this document applies to any platform.

Symptoms

In Primavera Analytics, OBIEE is catching the following error when an Analysis has Notebook Text included:

ERROR

[2018-04-23T16:44:36.607-04:00] [OBIS] [TRACE:5] [] [] [ecid: ] [sik: ssi] [tid: 1084] [messageid: USER-34] [requestid: a450085] [sessionid: a450000] [username: pseg_test] -------------------- Query Status: [nQSError: 17012] Bulk fetch failed. [[
[nQSError: 17001] Oracle Error code: 1652, message: ORA-01652: unable to extend temp segment by 128 in tablespace STARUSER_TEMP
at OCI call OCIStmtFetch.
[nQSError: 43119] Query Failed:

Steps to Reproduce

  1. Connect to the Analytics URL in a browser.
  2. New Analysis -> P6 ACTIVITY
  3. Project -> General -> Project Name
  4. Activity -> General -> Activity Name
  5. Activity -> Notebooks -> Notebook Topic Name
  6. Activity -> Notebooks -> Notebook Text

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.