IBM E027SLL-H Troubleshooting Guide - Page 216

in Header and Footer expressions set through the view Properties window will only be substituted if the workspace is reached as the target of a link. Verify that the custom workspace for which the expression is being specified is being reached through a link rather than being selected directly from a navigator node or the Workspaces menu. Otherwise, the symbols will evaluate as an empty string. For best results, also ensure that the expression is assigned to the Header or Footer target workspace property through the Link Wizard rather than by editing the Title text field for the Header or Footer region on the Style panel of the Properties Dialog. Whatever expression is assigned to the target workspace property through the Link Wizard will override the Title text entered in the Style panel when the workspace is reached through the link. This problem was reported against Tivoli Management Portal v1.9.6 but also applies to the Tivoli Enterprise Portal v6.1.0, v6.2.0, v6.1.1, and v6.2.2. Unresolved variables in custom queries Whenever you assign a custom query containing $-delimited symbol references to a view through the Properties window, a popup appears asking for values for all symbol references for which a value cannot be found. The values provided through this window are used to parameterize the query issued to fill the Preview pane of the Properties window. The values provided will NOT be saved in the workspace state although they will remain defined from when the Properties window is dismissed until the workspace is refreshed. The reason for the prompt for values is to allow the author of the query/workspace to test whether or not the query returns the expected result set for the provided values. The values are optional and need not be provided in order to complete the assignment of the query to the view. The only impact of not providing values is that the query triggers a syntax error when executed by the Properties window Preview pane and the view is empty. In order for the query to work correctly in the workspace, values must be provided for all the referenced symbols through the execution environment. Typically, this is done by reaching the workspace through a link that either explicitly or implicitly assigns values to the symbols. It can also be done through special controls like the Timespan window, but these must be built into the product. Custom query processing differs from 'standard' query processing in that, for custom queries, a value must be provided for every symbol reference while, for 'standard' queries, the system discards segments of the WHERE clause involving symbols for which a non-null value cannot be found. In order to support historical queries against summarized data, various agent groups distribute product-provided custom queries that reference symbols that are meant to be provided by the Timespan window when the 'Use summarized data' option is selected. These queries are used with the product-provided 'Historical Summarized ...' workspaces available from the Workspaces menu of the Operating System summary workspaces like 'Windows Systems'. In order for the queries to return data, the Warehouse Proxy and Summarization and Pruning agents must be configured and have been running long enough to collect and summarize the data being viewed. The queries reference a number of symbols. Following are some of the commonly referenced symbols and example values: KFW_USER: Name of the summarized database schema owner. Default is ITMUSER but it can be any value assigned by the customer during installation. 198 IBM Tivoli Monitoring: Troubleshooting Guide