Error 'sqlPrepareWithOptions' status='-9'

[Cognos_Jan2017]

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

[MFGF]

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 range

It 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.

[Cape Cod Gunny]

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.

[dougp]

Or do that backwards:  Delete a column at a time until it works, close without saving, fix the last column that was removed.

[Cognos_Jan2017]

Thank you MFGF, Cape Cod Gunny, and dougp.

I wound up deleting some Columns, and that corrected the error.