IBM Support

"ORA-01652: Unable to extend temp segment by xxx in Tablespace YYYY" when performing task in Controller

Troubleshooting


Problem

User performs a task in Controller. - For example, user attempts to run a report to compare subconsolidation and legal consolidation, with different closing versions, group perspective and currency codes (same currency). User receives error message.

Symptom

The error will vary depending on what task the user is performing.

Example - Running a report:
Standard Error
Number: 5
Source: FrangoDirect.ExcelLinkD.fetchValues#system.WebServices
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException(0x80040E14): ORA-01652: Unable to extend temp segment by 128 in Tablespace TEMP at Cognos.Controller.Proxy.CCRWS.ExcelLinkB_FetchValues(String sGuid, DataSet rsKeys, String sMcurr, Boolean bLocLang, String sUser, String sRep, Boolean bIsLnk, String sSortOrd, Int32 |OptBitSet)

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1;10.2.0;10.1.1;10.1;8.5.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1033778

Document Information

Modified date:
08 May 2025

UID

swg21347215

Page Feedback