About the mtb_server.log File - trillium_discovery - trillium_quality - 17.1

Trillium Reporting Adapter for Excel Guide
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Reporting Adapter for Excel Guide
Topic type
How Do I
Overview
Configuration
Reference
Administration
Installation
First publish date
2012

Column names can be used as parameters in queries to help narrow the scope of your results. Column Names lists the available external column names (the columns as displayed in the Control Center and returned when you run a query) for most queries.

For some view queries, (including the OLE DB queries view_attribute_null_values_rows, view_attribute_values, view_br_fail, view_entity_fail, view_entity_values, view_name, and view_rows) the column names are unknown until you run the query because the columns for these queries are dependent on the data view accessed.

If you are unsure of what column names to specify in a query, run the basic query without parameters, and then open the mtb_server.log file. The vcols section of the log lists the available columns for that query.

The log is located in the logs directory on your server system. For example, on Windows 7, this is located at: C:\Users\All Users\Trillium Software\MBSW\17\Data\logs.

Note: When running view queries all available columns, including those hidden in the Control Center, are returned. Therefore, to return a subset of columns, you can run the view query, note the columns returned, then add parameters as needed and rerun the query.

Example

The following example is an excerpt from an mtb_server.log and shows the internal columns (in bold for this example) returned for the view_attribute_values query:

2020-02-06 12:52:46 04040 INFO VIEW_ATTRIBUTE_VALUES vcols {VALUE {Value {The data value} N Keys} FREQUENCY_COUNT {Frequency {The number of times the data value occurs in the attribute} N Stat} _distribution {{Dist %} {The percentage of the attribute which contains the data value} N Stat} _length {Length {The length of the data value} N func} _soundex {Soundex {The coarse-grain phonetic representation of the data value} N func} _metaphone {Metaphone {The fine-grain phonetic representation of the data value} N func} _pattern {Pattern {The structure of the data value} N func} _mask {Mask {The mask pattern of the data value} N func}}

Note: Column names are case sensitive; you must enter the names exactly as shown. Some names are prefixed with an underscore (_) which must be included when you specify the parameter.