'sqlPrepareWithOptions' status='-9' error

[dbudale]

When I try to run a parrticular report in Production environment and export it in excel  it is showing "'sqlPrepareWithOptions' status='-9'" but the same report is running exactly fine in development environ.
Help needed

[blom0344]

Which probably indicates that:

1. Database structure is different.
2. Cognos model does not fit the database structure in whatever way.

This a backend/modelling issue , has probably little to do with the report definition.

SQL errors usually give clues when you check the details on the error message..