'sqlOpenResult' status='-28'

[raj_hpking]

Hi,

I managed to install Report Studio and i published sales_pkg, when i create sample report using this package i am getting below error,

An error occurred while performing operation 'sqlOpenResult' status='-28'.
(UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SQL-0564 [Microsoft SQL Server Native Client 10.0]Arithmetic overflow error converting expression to data type int.)

But i have selected only one field (Country code), still getting same error. The respective table is having only 10-15 records.

I have tested the connection via framework manager and it is fine, i am getting data in framework manager.
Regards,
Raj

[jayanthhyd]

1st Check your sales_pkg connections just test the connection

2nd in FM click on data source and change database to native(local)
In FM double click on any table and click test check u getting values or not.

3rd check cognos content store started or not.