Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Feb 1, 2022 9:10:27 AM
Apr 15, 2020 1:13:56 PM
Viewing and Downloading Qlik Compose for Data Warehouses Log Files – QC4DWH: 1.1 This section describes where each of our Qlik Compose for Data Warehouse logs exists:
Qlik Compose for Data Warehouse logs are in four different locations:
Note:
1.2 This section describes how to view log files from our UI:
Note: Any terms that match the specified string will be highlighted in blue.
See below for an example:
1.3 This section describes how to download log files from our UI:
See below for an example:
2.0 Setting up logs to verbose mode for different modules in Qlik C4DWH: 2.1 Setting up server logs to verbose mode:
Note: In the screenshot below, the Compose and DataMart module are set to Verbose:
Note: Changes to the logging level take place immediately. There is no need to restart the Qlik Compose for Data Warehouses service.
2.2 Setting up Agent log to verbose mode:
Note: Changes to the logging level take place immediately. There is no need to restart the Qlik Compose for Data Warehouses service.
2.3 Setting up ETL logs to Trace or Debug mode:
Note: The log levels DEBUG and TRACE impact performance. You should only select them for troubleshooting if advised by Qlik Support team
2.4 Setting up Data Mart logs to Trace or Debug mode:
Note: The log levels DEBUG and TRACE impact performance. You should only select them for troubleshooting if advised by Qlik Support team
3.0 Database connections and JVM setting for Data warehouse and Datamart in Qlik C4DWH: 3.1 Setting up and calculating Database connections for Data warehouse and DataMart:
Maximum number of database connections: Enter the maximum number of connections allowed. The default value is 10.
Example shown below is the setting from the DataMart pane:
For more information, see below for determining the Required Number of Database Connections for Data warehouse and DataMart.
As a rule of thumb, the higher the number of database connections opened for Compose for Data Warehouses, the more tables Compose for Data Warehouses will be able to load in parallel. It is therefore recommended to open as many database connections as possible for Compose for Data Warehouses. However, if the number of database connections that can be opened for Compose for Data Warehouses is limited, you can calculate the minimum number of required connections as described below.
To determine the number of required connections:
Similarly, if a workflow has two Storage Zone tasks that run in parallel and each task requires 5 connections, then the minimum number of required connections will be 10. However, if the same workflow also contains two data mart tasks (that run in parallel) and the sum of their connections is 20, then the minimum number of required connections will be 20.
3. Factor in the connections required by the Compose Console. To do this, multiply the maximum number of concurrent Compose users by three and then add to the sum of Step 2 above. So, if the number of required connections is 20 and the number of concurrent Compose users is 4, then the total would be:
20 + 12 = 32
3.1 JVM settings in Data warehouse and DataMart:
The default size is: -Xms1024M -Xmx4096M
Xms is the minimum memory; Xmx is the maximum memory. With the above default setting, the JVM starts running with value 1024M and can use up to value 4096M.
Example shown below is the setting from the DataMart pane:
Note: You only should edit the memory for the java virtual machine (JVM) ONLY if you experience performance issues or seeing an running out of memory error in the in the ETL log. Please contact support before making this change
When updating our logging level in the Advanced Settings of the ETL Set, the select dropdown lists the options in the following order:
-INFO
-DEBUG
-TRACE
Based on the selection order of the "Log level" dropdown, I would have expected TRACE log level to provide a finer grain log than DEBUG, but that contradicts the documentation you provided above in section 2.3.
Can you please confirm if the Order of the Log Level select dropdown options I am seeing are out of order based on log grain?
Is the DEBUG level is a finer grain log than the TRACE level as stated in your documentation above?
Currently on QC4DWH 6.5.041
Thanks!