IBM Support

Error when running report: UDA-SOR-0005 Unable to write the file..

Troubleshooting


Problem

Unable to run reports in Report Studio due to the following errors. [Error Message -] UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive. UDA-SOR-0005 Unable to write the file. RSV-SRV-0025 Unable to execute this request.

Resolving The Problem

The error "UDA-SOR-0005 Unable to write the file" indicates that IBM Cognos failed to perform a write operation to temporary file space. This may be caused by insufficient disk space under crn\temp.

By default, Cognos ReportNet writes temp files to ...\crn\temp.

Verify if space is available under the crn\temp director.

In a UNIX environment if "Tempdir" or "temp" is set as an environment variable, then ensure the user who is starting the Cognos 10 process has write access to this directory.

Steps:1. Open Cognos Configuration.

2. Verify the path under Environment \ TEMP (default \temp).

3. Check for available disk space under the path specified in step 2.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"PowerPlay Enterprise Server","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1011537

Document Information

Modified date:
15 June 2018

UID

swg21338861