Display Query -- Submit Query Column Identifiers may be System-Generated

Display Query -- Submit Query Column Identifiers may be System-Generated

book

Article ID: KB0092824

calendar_today

Updated On:

Products Versions
TIBCO DataSynapse GridServer -
Not Applicable -

Description

Resolution:
Column Identifier Inconsistency in Domain Statistics Reporting
When you select Reports -> Domain Stats and click either Display Results or Export Results, the column identifiers you see for the various statistics are the names of the Domain Statistics you chose for your report.

However, when you click Display Query to see the actual SQL used to generate the report, this may use a shortened, system-generated column identifier. And when you select Display Results or Export Results from the Display Query screen the resulting table uses the system-generated column identifier.

Why do I see this?
In some databases, column identifiers are limited to a certain number of characters. For example, the Sybase DB has a strict 28 character limit. To make sure that the SQL generated by FabricServer will run on all supported databases, the column identifiers for any columns whose name exceeds 24 characters in length are truncated at that length, then made unique by appending a number. (Currently, the only situation of this type is when generating Domain Statistics reports.) Note: When you design your own queries, be aware of the particulars of the database you use. FabricServer does not check user-designed queries against non-destructive errors.

Issue/Introduction

Display Query -- Submit Query Column Identifiers may be System-Generated