IBM Support

Unable to run Report Studio report: UDA-SOR-0001 Unable to allocate memory.

Troubleshooting


Problem

Unable to run a Report Studio report.

Symptom

Original Error: RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation 'APICursor::OpenResult' is inactive
UDA-SOR-0001 Unable to allocate memory.

Cause

Reduce the sort buffer size in Cognos Configuration.

Resolving The Problem

Change the sort buffer size to a lower number than what it is currently set to.

Steps:

  1. Open IBM Cognos Configuration
  2. Select the Environment tab
  3. In the Sort buffer size in MB text box, set the sort buffer size to a lower value

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Connection","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.1;10.2.2","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21341799