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.