An administrator must troubleshoot query execution related issues in a DQM executed report.
How is this achieved?
A query execution trace (run tree trace) shows queries that run against a data source. You use the trace to troubleshoot query-related issues.
You can find execution trace logs in the following location:
c10_location/logs/XQE/reportName/runtreeLog.xml.
A high user load and interactive reporting system on a distributed installation is throwing timeout error messages.
How is this resolved?
Increase Asynchronous Timeout in High User Load Environments.
If you have a high user load (over 165 users) and interactive reports are running continuously in a distributed installation, you may want to increase the asynchronous timeout setting to avoid getting error messages. The default is 30000.
To resolve this problem, increase the wait timeout.
Procedure
In a multi-server environment, an administrator wants to ensure that items in the Content Manager Cache service are re-validated every thirty seconds.
Which option would accomplish this?
ValidatorTimetoLive determines how long data objects remain in the cache. After the Validator timer expires objects are considered Invalid and have to be fetched from Cm again. Value is in ms, and default is 900000.
References: https://www.slideshare.net/barnaby1502/cognos-technical-super-session-2012, page 11
A high user load and interactive reporting system on a distributed installation is throwing timeout error messages.
How is this resolved?
Increase Asynchronous Timeout in High User Load Environments.
If you have a high user load (over 165 users) and interactive reports are running continuously in a distributed installation, you may want to increase the asynchronous timeout setting to avoid getting error messages. The default is 30000.
To resolve this problem, increase the wait timeout.
Procedure
IBM Cognos Analytics is installed on a non-Windows platform. An administrator receives the following error after setting up a datasource connection:
''XQE-DS-0014 Unable to logon to the data source. An unexpected error from the JDBC driver ''com.microsoft.sqlserver.jdbc.SQLServerDriver'':
''java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.8 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.''
What should the administrator do to rectify this problem?
Based on the error message that is displayed, it is likely that the JDBC driver is unable to read the correct '.jar' file. When performing an update of the JDBC driver to receive the new '.jar' file, the original '.jar' file is still likely to be stored in the same location as it contains the same file path that is held in the installer of the software.
Ensure that JDBC drivers are in the correct location. For the IBM Cognos Analytics, the JDBC drivers must be copied to the install_location\drivers directory.
References:
Clorinda
16 days ago