Cognos 10.2.2
Vendor App (they completely control Framework Manager) has "Prompts Only" which generate a Prompt Page.
Only has 11 columns in a List Report, and need to add maybe 6 to 8 more columns.
After responding to the generated prompt page, trying to run the report results in ...
An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "prepare".[FreeTDS][SQL Server]Invalid cursor state[FreeTDS][SQL Server]Column out of rangeRSV-SRV-0042 Trace back:RSReportService
Any ideas what may be wrong?
TIA, Bob
Quote from: Cognos_Jan2017 on 26 Sep 2019 02:25:57 PM
Cognos 10.2.2
Vendor App (they completely control Framework Manager) has "Prompts Only" which generate a Prompt Page.
Only has 11 columns in a List Report, and need to add maybe 6 to 8 more columns.
After responding to the generated prompt page, trying to run the report results in ...
An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "prepare".[FreeTDS][SQL Server]Invalid cursor state[FreeTDS][SQL Server]Column out of rangeRSV-SRV-0042 Trace back:RSReportService
Any ideas what may be wrong?
TIA, Bob
Hi,
The two pieces of this that appear to be most useful are:
Invalid cursor state, and
Column out of rangeIt looks like you are using a SQL Server data source, and accessing it via FreeTDS?
If I had to guess, I would suspect there is a data type mismatch going on somewhere - maybe trying to treat a date column as numeric or character. Have you made sure the prompt responses are correct based on the data types of the items being prompted for?
MF.
Quote from: Cognos_Jan2017 on 26 Sep 2019 02:25:57 PM
Cognos 10.2.2
Vendor App (they completely control Framework Manager) has "Prompts Only" which generate a Prompt Page.
Only has 11 columns in a List Report, and need to add maybe 6 to 8 more columns.
After responding to the generated prompt page, trying to run the report results in ...
An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "prepare".[FreeTDS][SQL Server]Invalid cursor state[FreeTDS][SQL Server]Column out of rangeRSV-SRV-0042 Trace back:RSReportService
Any ideas what may be wrong?
TIA, Bob
If it was me I would troubleshoot at the query level. I would add one field to the query at a time and run "Tabular data" against the query.
Or do that backwards: Delete a column at a time until it works, close without saving, fix the last column that was removed.
Thank you MFGF, Cape Cod Gunny, and dougp.
I wound up deleting some Columns, and that corrected the error.