'sqlOpenResult' status='-28'

[john234]

When I send the output of my report to html everything works fine. When I send it to PDF or Excel I get an error 'sqlOpenResult' status='-28'

There are no errors when I validate the report.

[harish.malik]

Hi John,

If you experiencing these error messages then the potential cause could be related to you server configuration. You could be requesting all of your report requests through one BiBus process.

QE-DEF-0177 Error executing operation 'sqlOpenResult' Status='-28'
UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.
UDA-SOR-0001 Unable to allocate memory.

One test to resolve this issue would be to increase the settings for the Interactive and Batch report processes. When you optimize the environment, requests are spread over a number of BiBus processes, and the memory issue may no longer occur.

Test 1
1. Log into Cognos Connection as a System Administrator.
2. Select Tools.
3. Select Server Administration.
4. Select the properties of the Dispatcher.
5. Click the Settings tab.
6. In the Category menu, click Tuning.
7. Increase:

Maximum number of processes for the batch report service (start with 2 per CPU)
Maximum number processes for the Interactive report service (start with 2 per CPU)

8. Stop and restart the Cognos service.

Test 2:
You could also try decreasing the sort memory setting in Cognos Configuration to the default value (4 MB). If this setting was changed, then you should research the initial reason as to its change. This setting applies to each BiBusTkServerMain Process, so it gets multiplied by the configured number of Report Processes.

1. Open Cognos Configuration, and select Environment from the Explorer Bar
2. Change the value of the Sort buffer size in MB to a smaller amount.
3. Save the configuration.
4. Stop and restart the Cognos service.


Test 3
You should also confirm that there is free space available on the drive where Cognos8 is installed. During processing of reports temp directory is used to store the information temporarily. It is hard to determine how much free space is required to be used by the Cognos8 temp directory. However, it is recommended to have at least 4 GB of free space on the drive.

Hope this helps.
~Harish

[dfite]

I may be way off, but I've run into problems like that when I try to squeeze too much stuff onto one report page - it'll generate just fine in html (which will expand to display whatever), but it'll bomb out in pdf because the info just doesn't fit on the page size I set up.

Just my $0.02 on the matter...