Problem Symptoms

• Adding Event transactions to reports in Report Studio and Query studio returns this error:

RQP-DEF-0177
An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'.
CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2014-07-07-10:46:40.300-#4

• The same error appears in Report Studio when you run a report that has Event Transactions query subjects.

Defect Status

Issue VYG-5887 is resolved in Voyager 9.1.0 and higher.

Replication Steps

1. Cognos Connection > Query Studio
2. Select Voyager 9.0.0 - Circulation and Call Slip Package
3. Expand Event Transactions
4. Add query subjects from the Event Transactions area.
5. Receive the following error:

RQP-DEF-0177
An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'.
CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2014-07-07-10:46:40.300-#4
#The same error appears in Report Studio when you run a report that has Event Transactions query subjects.

• Article last edited: 16-Oct-2014