Symptoms

The following error occurs when adding a SQL query to a report:

CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2020-04-27-06:23:14.006-#30612

 


Reason

This error code can have multiple reason. Check the log file on the server to get more details.

In this scenario, the error message was related to a duplicate column, see below.

Cognos log(cogaudit.log):

SecureErrorId: 2020-04-27-16:26:22.979-#46 Original Error: RQP-DEF-0149 The query specification is incorrect. RQP-DEF-0191 Column names must be unique. Column name 'logorder' is used more than once.

Resolution

User must modify the query to ensure that either there is no duplicate field name in the select statement or there are aliases to differentiate them.