IBM(R) DataQuant for Multiplatforms, Version 1 Release 2, Fix Pack 1 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 DATAQUANT FOR WORKSTATION 1.2 FIX PACK 1 3.0 DataQuant for WebSphere 1.2 Fix Pack 1 1.0 ABOUT THIS README FILE Welcome to IBM DataQuant for Multiplatforms, Version 1 Release 2, Fix Pack 1 README file. This README file contains descriptions of fixes for IBM DataQuant for Workstation and DataQuant for WebSphere. 2.0 DATAQUANT for WORKSTATION 1.2 FIX PACK 1 QMFDQ-226 Incorrect object behavior when connecting a grouped button using a connector object. QMFDQ-280 Exception occurs when opening a file with a .xml extension and that file is not in XML format. QMFDQ-541 Exception occurs when rendering a dashboard in PDF format in Runtime mode. QMFDQ-660 Contents of a list box object disappear after the SQL of the query whose parameters populate the list box are changed. QMFDQ-698 Progress information is now displayed when copying entries between repositories. QMFDQ-700 Added two scene events. The Deactivate event that fires when a user moves between scenes. The Close event that fires when a user switches from viewing the currently active scene (in runtime mode) to editing the scene in design mode. The Close event also fires when a user closes the currently active scene or the dashboard while in runtime mode. QMFDQ-817 Tick marks are incorrectly displayed when their appearance is modified using the TickSlide property for a VertSlider or HorzSlider. QMFDQ-838 Unable to right-click in dashboard scene when running DataQuant for Workstation on Linux. QMFDQ-903 Horizon object is incorrectly rendered when embedded in another Horizon object. QMFDQ-917 Frame boundaries in some chart layout objects display incorrectly. QMFDQ-948 Error can occur when opening a XML table using the 'Open from file' command. QMFDQ-2781 The same Object Tracking report displays differently in PDF, HTML and Rich Client formats. QMFDQ-2917 Saving a modified visual dashboard or visual report query does not clear original version of query from cache. QMFDQ-2984 Visual report generated from a classic report can contain a corrupted calculated column. QMFDQ-3059 In some cases, the menu item 'Properties' does not appear in the context menu for users and groups that have been assigned to an Internal secured repository. QMFDQ-3067 The 'Require use of this catalog when accessing the current server' checkbox is missing from the QMF plugin parameters dialog. QMFDQ-3084 Grid objects that are driven by OLAP queries can not be connected to Slicer objects using the Connectivity tool. QMFDQ-3097 When exporting query results to a table, the option to specify a comment should not be available for data sources that do not support table comments. QMFDQ-3106 Error can occur when viewing a visual report in 'Preview' mode and the 'NewPage' property value is set to true. QMFDQ-3107 The 'FixedPages' property value for a visual report is corrupted after viewing the report in 'Preview' mode. QMFDQ-3141 Creating, saving and deleting objects using procedure commands will now trigger a refresh of the Repository Explorer, Repositories, and Workspaces views. QMFDQ-3151 Unable to store a comment when updating a table. QMFDQ-3163 Error occurs when the 'Name' tab in the 'Data Source Connections' view is selected. QMFDQ-3181 Errors can occur when protecting QMF catalog tables using stored procedures and if specified collection ID already exists. QMFDQ-3194 Exception can occur when reloading a visual dashboard after it has been modified. QMFDQ-3205 Changing the 'ColumnSpan' and 'RowSpan' properties of a Table object should cause the Table object to be immediately refreshed in the editor. QMFDQ-3213 Changes to a scene property are not propagated to all layout objects that may reference that scene property. QMFDQ-3218 Visual Dashboard scene rendered in PDF format is empty after returning from full screen mode. QMFDQ-3244 Data source name is not shown in Set Name Filter dialog. QMFDQ-3266 Cache resource limits should be disabled if caching is not enabled. QMFDQ-3288 Enhancement to capture a user's entry in or selection from a Listbox or Combo control object. QMFDQ-3296 Information informing a user that a 'Calculation exception' occurred while running a visual dashboard should be written to the 'Output' view. QMFDQ-3302 Visual Designer orders some dashboard components differently in Design and Runtime modes. QMFDQ-3320 Exception can occur when creating BIRT report data set with substitution variables. QMFDQ-3332 Exception can occur resetting the default value for a new visual dashboard parameter with a data type of 'DateTimeSet'. QMFDQ-3334 In some cases unable to move columns to top or side groups in a visual dashboard Grid object. QMFDQ-3343 Focus can get lost when zooming in on a Combo control object. QMFDQ-3346 Exception can occur when setting up the Drilldown wizard to jump to another visual project. QMFDQ-3354 Exception can occur when opening a MDX cube from workspace. QMFDQ-3359 Unable to preview a BIRT report based on a query from an .ixf file. QMFDQ-3364 Irrelevant error message may be issued when creating a new repository group. QMFDQ-3365 Unable to set default values for TextSet, DateTimeSet, NumberSet parameter data types. QMFDQ-3366 Incorrect behavior can occur when using the 'Bottom' command with multiple query result sets. QMFDQ-3379 Unable to undo a 'Send to Back' action while working with a visual dashboard. QMFDQ-3380 In some cases legacy encrypted strings are indecipherable. QMFDQ-3383 Exception can occur when opening an internally secured repository's Users and Groups context menu. QMFDQ-3388 Tables may be listed twice in the prompted query 'Add Table' dialog. QMFDQ-3393 Unable to edit a third party library specification in the 'Preferences' dialog. QMFDQ-3394 Exception can occur when setting up a network service connection. QMFDQ-3395 More information is included in the error message that is issued when a database that does not have a JDBC driver installed is accessed. QMFDQ-3396 Unable to render visual dashboard extra wide chart objects (column, scatter, XY, timeline) in PDF format. QMFDQ-3397 Error can occur when accessing a data source that requires a login different from the repository login and the 'Try to use repository login and password to connect to this data source' option has been specified for the data source. QMFDQ-3398 Support has been added for 'set' data types in query parameters, making it much easier to wire multi-selections from listbox controls. QMFDQ-3402 Incorrect generation of the scatter charts that are contained within a Multivariate chart. QMFDQ-3404 Errors in content and location can occur when adding a Label object to a SimpleForm object. QMFDQ-3405 Exception can occur when dragging an OLAP cube from the Repository Explorer to a visual dashboard's 'Queries' folder in the Project Explorer. QMFDQ-3407 Error occurs when adding new calculated column to a set of query results using the 'left' function. QMFDQ-3413 Unable to place a Multipolygon object in a visual report. QMFDQ-3414 Improper update of global variables DSQAO_OBJ_NAME and DSQAO_OBJ_QWNER when a new object is saved to a repository. QMFDQ-3416 Unable to set a default result set number in a stored procedure using the global variable DSQEC_SP_RS_NUM. QMFDQ-3418 In some cases, unable to complete the drawing of a Multipolygon object in a visual dashboard. QMFDQ-3423 Exception can occur when placing the reserved variable &REF in the heading of a classic report. QMFDQ-3432 In some cases, a time value that is formatted using the function 'formatNum()' will display incorrectly in a visual dashboard. QMFDQ-3441 Provide the ability to page through content in the SQL and MDX editors using the page up/page down buttons. QMFDQ-3442 The list of tables is truncated in the 'Draw Query' dialog. QMFDQ-3444 Objects placed in the ‘FixedPages’ sections of visual reports are not rendered in the preview page. QMFDQ-3453 Changes in permissions for the ‘Everyone’ group are not propagated down to child items in the repository structure. QMFDQ-3454 Provide the ability to copy an attached query into a dashboard or report project before it is modified by the connectivity tool. QMFDQ-3455 Enhancement to automatically add the appropriate file extension when saving objects to a file and to automatically remove the file extension when saving the file back into the repository. QMFDQ-3457 All saved projects in the Project Explorer should be closed by selecting 'Close All Saved’ from the File menu. QMFDQ-3458 Unnecessary confirmation message is issued after viewing an object's permissions regardless of whether settings have been changed. QMFDQ-3460 Exception occurs if one proceeds with the draw query wizard after repeatedly canceling the database logon prompt. QMFDQ-3462 A selected roll-up row in the data grid remains partially selected after the row is expanded by clicking on the plus sign. QMFDQ-3463 Grid auto-fitting (by double-clicking on the top-left cell) does not adjust the height of the column headers to fully accommodate the column labels. QMFDQ-3464 Under certain conditions, expanding and collapsing grid roll-ups results in the incorrect placement of the plus and minus signs in the grid cells. QMFDQ-3465 The connectivity tool adds an additional ‘group by’ clause when adding a parameter to a query which already contains a group by clause. QMFDQ-3466 After navigating to a visual report from within a dashboard, performing a ‘Navigate Back’ action does not return the user to the dashboard. QMFDQ-3471 Unable to delete a user from the data source logon mappings dialog until all of their logon mappings are removed. QMFDQ-3476 Support has been added for BIGINT values in the query diagram and prompted query editors. QMFDQ-3477 The processing of a dashboard 'MouseMove' event is delayed and significantly lags the triggering move action. QMFDQ-3480 Dashboard mouse events are passed through to the embedded scene even when the EmbedddedScene object’s 'PassThroughEvents' property is set to false. QMFDQ-3484 The tooltip for a browse button on the Insert Query wizard incorrectly indicates that a query can only be selected from from the repository. QMFDQ-3489 After receiving an error while attempting to add a non-existent data source (e.g. BadDBName1), further attempts to add other non-existent data sources (e.g. BadDBName2) will continue to report the error related to the first data source (BadDBName1). QMFDQ-3492 Expression Designer does not keep an accurate record of the typing order of expressions, leading to an incorrect 'Undo' and 'Redo' history. QMFDQ-3497 Support added to automatically upgrade a repository when an administrator attempts to connect to a repository with an obsolete structure. QMFDQ-3500 Quoted values associated with query column names that are also quoted are preserved in the row conditions section of the prompted query facility. QMFDQ-3504 Exception can occur when setting listbox or combo box values and the value set is beyond the number of items in the control. QMFDQ-3510 Error occurs displaying references associated with a query which cites a non-existent table. QMFDQ-3511 Error occurs displaying references associated with a query which contains a ‘count(*) as alias’ expression. QMFDQ-3513 Saving data to a data source that does not permit such actions results in an incomplete error message. QMFDQ-3515 Unable to re-size a layout in the design view after renaming the layout (chart, graph etc.) in a report or dashboard. QMFDQ-3518 Instances of a matched item in the data grid are not progressively highlighted as the user selects the ‘Find Next’ button. QMFDQ-3524 Added the ability to type content directly into dashboard and report labels when the label is selected in the design mode (without the need to click twice to enter edit mode). QMFDQ-3526 A query displays redundant references when the SQL references the same columns with and without an alias. QMFDQ-3527 Adding a carriage return within a quoted value in the SQL editor results in incorrect SQL colorization. QMFDQ-3537 Added a 'BackgroundColor' property to a Button object to permit the setting of the button’s background color. QMFDQ-3539 When adding a query to a saved dashboard and then saving the dashboard under a new name, the newly added query is not saved with the new copy of the dashboard. QMFDQ-3543 It is not possible to close a combo box drop list by clicking on the drop list arrow. QMFDQ-3544 Unable to copy the contents of a label using the Ctrl+C keystroke combination. QMFDQ-3545 Visual reports do not support global variables that are defined at the application level (including QMF global variables). QMFDQ-3549 Added global variable value is not used if the variable already has a cached value. QMFDQ-3555 Exception can occur when exporting query results while connected to a repository with no data source definitions. QMFDQ-3563 Invalid connection information is added to a visual project when incorrect logon information is specified while adding a data source connection to the project. QMFDQ-3564 The 'DataRefreshInterval' property is ignored by grid and form layouts in a dashboard project. QMFDQ-3565 In some cases, a dashboard control object's color is rendered incorrectly when the controlling color property is set to ‘default’. QMFDQ-3571 Query results grid scrolls its content horizontally while selecting multiple vertical rows. QMFDQ-3572 Unable to use 'Find' or 'Replace' in the Output view. QMFDQ-3573 Unable to distinguish between double and single quote characters in the Expression Designer text box when the characters are used adjacent to each other. QMFDQ-3574 (worded without query diagram in web versions) Unable to view a query in the query diagram or prompted query editor if the query text is fully enclosed within parenthesis. QMFDQ-3580 Cancelling a query which has returned a partial result set does not release the database connection and has no effect on the suspended query state. QMFDQ-3583 Data-driven properties are transposed in some Candlestick and Stock charts. QMFDQ-3586 Dashboard Threshold and Event bands are rendered with zero width in design mode, making them difficult to select and manipulate. QMFDQ-3587 The ‘rename’ context menu item, offered within the repository search results, does not carry out the rename action when selected by the user. QMFDQ-3588 Connector objects within tables always start from the first table row in the Visual Designer design mode. QMFDQ-3589 Table layouts are rendered with excessively large borders in HTML mode. QMFDQ-3592 Adding corrupt or unsupported JPG files results in an application error or blank rendering of the JPG content, depending on the nature of the JPG file. QMFDQ-3599 Subsequent resizing of a label, whose 'Height' property is set to 0, using the mouse alters the height of the label in design mode. QMFDQ-3600 Label content is not clipped to the label’s bounds when the dashboard or report is displayed in ‘Print Preview’ mode. QMFDQ-3604 Changes to an OLAP query in order to support a multi-dimensional chart are not ‘undone’ when the adding of the chart is reversed using an 'Undo' action. QMFDQ-3611 Properties view does not remain set on the last selected component when the dashboard or report is moved from design mode to runtime mode. QMFDQ-3613 Conditional formatting expressions in the results grid do not accept conditions that contain negative numbers. QMFDQ-3618 The DSQAO_CURSOR_OPEN global variable always reports the value of 2, irrespective of the state of the database cursor. QMFDQ-3624 Unable to add an item from the dashboard or report palette using a copy and paste action, despite these options being listed in the respective context menus. QMFDQ-3625 The shift parameter associated with dashboard keyboard events does not report the state of the Ctrl and Alt keys. QMFDQ-3631 When dragging an object from the Palette view to the Project Explorer (rather than the scene canvas), subsequent canceling of the layout wizard does not remove the object from the dashboard or report. QMFDQ-3634 Dashboard and report layout wizards incorrectly add box brackets around certain column names if those names are both reserved words and quoted in the SQL. QMFDQ-3635 Error can occur if quotes are removed from a query alias which is also a reserved word and the query is subsequently saved to a file. QMFDQ-3648 A click event on a scene object is ignored when the dashboard is rendered in HTML mode. QMFDQ-3649 The progress window displays internal object names when executing a SQL statement event action within a dashboard. QMFDQ-3653 Unable to create a global variable and set its value to a single quote using the following procedure statement: SET GLOBAL (VARNAME=' QMFDQ-3660 After deleting a data source connection from a report or dashboard and electing not to update the queries that reference it, adding a new connection automatically sets the queries to use this new connection. QMFDQ-3663 Objects within an embedded scene component may only be partially rendered at runtime. QMFDQ-3669 The '/Batch' command line parameter results in a ‘file not found’ error. QMFDQ-3678 After adding a relational connection and relational query to a dashboard or report, changing the connection to point to an OLAP data source does not disconnect the relational query from the data source connection. QMFDQ-3685 Error occurs when a dashboard that contains a RadioGroup object set to an out of bounds value (such as zero) is run. QMFDQ-3686 Horizontal and vertical sliders are rendered incorrectly if their value property is set to an out of bounds value. QMFDQ-3689 A true 'Stretch' image property value is ignored when running a dashboard or report in HTML mode. QMFDQ-3691 Error occurs when a checkbox caption property is set to a list or combo box value property. QMFDQ-3699 The 'Finish' button in the ‘Set Values’ dialog (event action) may remain disabled if parameter values are added or modified without pressing the 'Enter' key. QMFDQ-3702 Dashboard and report objects may be removed when ungrouping collections which contain the same child object names. QMFDQ-3709 A visual report project may incorrectly remain open when a user switches repositories. QMFDQ-3712 The Command Library interface does not support connecting to secure repositories. QMFDQ-3713 The Command Library interface does not support the execution of objects stored in arbitrary repository locations; objects must reside in a QMF catalog. QMFDQ-3722 The repository creation mechanism does not check for the existence of the RSBI database logon when creating a repository within SQL server. This results in an error message should the account already exist within the database. QMFDQ-3725 Duplicate mapping values are presented in the LOB file extension mapping dialog. QMFDQ-3736 Exception may occur when concurrently creating, running and then closing multiple dashboard projects. QMFDQ-3739 The name of an open dashboard scene is not always displayed in the application title bar. QMFDQ-3740 Elements within hierarchical chart types are displayed overlapped with one another when rendered in HTML mode. QMFDQ-3744 (qmf does not use the word dashoard) After setting the height of a dashboard or report image to zero, attempts to resize the image using the mouse result in the incorrect rendering of the image in design mode. QMFDQ-3751 An open dashboard project may not be listed if the project was opened while the Project Explorer was hidden from view. QMFDQ-3756 The error message region at the top of the Expression Designer should include a vertical scrollbar since the error message often exceeds the allocated area. QMFDQ-3771 Exception can occur when a connector between objects in differing sections of a visual report is added. QMFDQ-3779 Error occurs when re-running a query whose previously run query results had columns deleted. QMFDQ-3780 Users without rights to the SYSIBM.SYSDUMMY1 table cannot connect to a repository. QMFDQ-3783 Unable to create a repository within an Oracle database that is secured with LDAP-based authentication. QMFDQ-3788 Unable to update Oracle-based repositories. QMFDQ-3797 After adding one or more fixed pages to a visual report section, the fixed page content is not listed in the fixed page list and cannot be subsequently edited or removed. QMFDQ-3824 SQL statements that use the ‘Select Into’ clause against Informix databases fail to execute due to the erroneous addition of optimization clauses. QMFDQ-3834 Error can occur when saving an object (query, report, form) to a workspace if the object has the same name as an existing object in the workspace. ********************************************** 3.0 DataQuant for WebSphere 1.2 Fix Pack 1 ********************************************** QMFDQ-877 Unable to configure JDBC drivers by copying driver file to WEB-INF/Config. QMFDQ-3023 In BiDi version of DataQuant for WebSphere Administrator some icons overlap text in the sidebar tree. QMFDQ-3080 Error can occur when testing the connection to a data source that does not require login information. QMFDQ-3083 In DataQuant for WebSphere Administrator, options to create a QMF catalog on a non-DB2 data source should be disabled. QMFDQ-3097 When exporting query results to a table, the option to specify a comment should not be available for data sources that do not support table comments. QMFDQ-3106 Error can occur when viewing a visual report in 'Preview' mode and the 'NewPage' property value is set to true. QMFDQ-3162 Grid objects that are driven by MDX queries appear incorrectly when rendered using HTML or an applet. QMFDQ-3266 Cache resource limits should be disabled if caching is not enabled. QMFDQ-3317 Added the ability to pre-populate one or more dashboard, report, or query parameter values for DataQuant dashboards and reports that are embedded in web pages and portlets. QMFDQ-3407 Error occurs when adding new calculated column to a set of query results using the 'left' function. QMFDQ-3408 Exception can occur creating a new repository with LDAP security. QMFDQ-3410 Header items display incorrectly in the query results grid when the horizontal alignment is set to left justify. QMFDQ-3411 Some links may break when visual dashboard is rendered in HTML format. QMFDQ-3412 Error can occur when creating a side group from the Layout tab in the query results window. QMFDQ-3414 Improper update of global variables DSQAO_OBJ_NAME and DSQAO_OBJ_QWNER when a new object is saved to a repository. QMFDQ-3416 Unable to set a default result set number in a stored procedure using the global variable DSQEC_SP_RS_NUM. QMFDQ-3424 Added 'Restore to default' button to the Global Variables dialog. QMFDQ-3429 Error occurs using the IMPORT query from file procedure command. QMFDQ-3431 Application hangs when adding a new global variable after the SHOW global variables procedure command has run. QMFDQ-3439 In some cases, unable to render Bar or Pie charts in HTML or PDF mode. QMFDQ-3444 Objects placed in the ‘FixedPages’ sections of visual reports are not rendered in the preview page. QMFDQ-3455 Enhancement to automatically add the appropriate file extension when saving objects to a file and to automatically remove the file extension when saving the file back into the repository. QMFDQ-3464 Under certain conditions, expanding and collapsing grid roll-ups results in the incorrect placement of the plus and minus signs in the grid cells. QMFDQ-3466 After navigating to a visual report from within a dashboard, performing a ‘Navigate Back’ action does not return the user to the dashboard. QMFDQ-3476 Support has been added for BIGINT values in the query diagram and prompted query editors. QMFDQ-3480 Dashboard mouse events are passed through to the embedded scene even when the EmbedddedScene object’s 'PassThroughEvents' property is set to false. QMFDQ-3497 Support added to automatically upgrade a repository when an administrator attempts to connect to a repository with an obsolete structure. QMFDQ-3500 Quoted values associated with query column names that are also quoted are preserved in the row conditions section of the prompted query facility. QMFDQ-3504 Exception can occur when setting listbox or combo box values and the value set is beyond the number of items in the control. QMFDQ-3510 Error occurs displaying references associated with a query which cites a non-existent table. QMFDQ-3511 Error occurs displaying references associated with a query which contains a ‘count(*) as alias’ expression. QMFDQ-3513 Saving data to a data source that does not permit such actions results in an incomplete error message. QMFDQ-3526 A query displays redundant references when the SQL references the same columns with and without an alias. QMFDQ-3527 Adding a carriage return within a quoted value in the SQL editor results in incorrect SQL colorization. QMFDQ-3545 Visual reports do not support global variables that are defined at the application level (including QMF global variables). QMFDQ-3549 Added global variable value is not used if the variable already has a cached value. QMFDQ-3564 The 'DataRefreshInterval' property is ignored by grid and form layouts in a dashboard project. QMFDQ-3565 In some cases, a dashboard control object's color is rendered incorrectly when the controlling color property is set to ‘default’. QMFDQ-3568 Content placed in a dashboard containing multiple zoom levels is ignored if located on a zoom level less than 200%. QMFDQ-3570 Exception occurs when a dashboard's default viewpoint is set to a zoom level other than 100%. QMFDQ-3574 Unable to view a query in the prompted query editor if the query text is fully enclosed within parenthesis. QMFDQ-3580 Cancelling a query which has returned a partial result set does not release the database connection and has no effect on the suspended query state. QMFDQ-3589 Table layouts are rendered with excessively large borders in HTML mode. QMFDQ-3592 Adding corrupt or unsupported JPG files results in an application error or blank rendering of the JPG content, depending on the nature of the JPG file. QMFDQ-3618 The DSQAO_CURSOR_OPEN global variable always reports the value of 2, irrespective of the state of the database cursor. QMFDQ-3625 The shift parameter associated with dashboard keyboard events does not report the state of the Ctrl and Alt keys. QMFDQ-3648 A click event on a scene object is ignored when the dashboard is rendered in HTML mode. QMFDQ-3653 Unable to create a global variable and set its value to a single quote using the following procedure statement: SET GLOBAL (VARNAME=' QMFDQ-3663 Objects within an embedded scene component may only be partially rendered at runtime. QMFDQ-3685 Error occurs when a dashboard that contains a RadioGroup object set to an out of bounds value (such as zero) is run. QMFDQ-3686 Horizontal and vertical sliders are rendered incorrectly if their value property is set to an out of bounds value. QMFDQ-3689 A true 'Stretch' image property value is ignored when running a dashboard or report in HTML mode. QMFDQ-3719 A ‘conversion error’ message may appear after enabling the QMF Catalog plug-in against a SQL Server database. QMFDQ-3722 The repository creation mechanism does not check for the existence of the RSBI database logon when creating a repository within SQL server. This results in an error message should the account already exist within the database. QMFDQ-3723 The EXPORT procedure command does not support the exporting of results to a file when running via a web browser. QMFDQ-3724 Exporting the results of an open query view to a file results in the query tab being renamed to that of the results file. QMFDQ-3725 Duplicate mapping values are presented in the LOB file extension mapping dialog. QMFDQ-3740 Elements within hierarchical chart types are displayed overlapped with one another when rendered in HTML mode. QMFDQ-3779 Error occurs when re-running a query whose previously run query results had columns deleted. QMFDQ-3780 Users without rights to the SYSIBM.SYSDUMMY1 table cannot connect to a repository. QMFDQ-3783 Unable to create a repository within an Oracle database that is secured with LDAP-based authentication. QMFDQ-3788 Unable to update Oracle-based repositories. QMFDQ-3824 SQL statements that use the ‘Select Into’ clause against Informix databases fail to execute due to the erroneous addition of optimization clauses. QMFDQ-3834 Error can occur when saving an object (query, report, form) to a workspace if the object has the same name as an existing object in the workspace.