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