Live Datamart Resolved Issues

Fixed in Live Datamart 2.1.7

TIBCO^® Live Datamart 2.1.7 is a maintenance release with updates and enhancements as described in its New and Noteworthy document, and also corrections for issues as described in the following table. Live Datamart 2.1.7 inherits all fixes on the 2.0.x release branch through 2.0.6, and all the fixes on the 1.6.x release branch through 1.6.6.

Number	Resolution
CQS‑3848	Queries to tables with snapshot-parallelism greater than 1 could emit extra SNAPSHOTOVERLIMIT messages if the query was not an order-by query, it had a row limit, and the row limit was hit. LiveView clients would never see these messages, but they could be sent over the network. This issue was fixed.
CQS‑3824	When using the `liveview.project.out` system property to redirect all LiveView generated files and also using the lv-server -f option to specify an alternate sbconf file name, it was possible that some user EventFlow or interface files could not be found and the server would fail to start. This was fixed.
CQS‑3818	The AlertRule `newLVPUblishAlertAction` public API name was changed to correct the case. It is now `newLVPublishAlertAction`.
CQS‑3789	Enabling an action on a new alert before saving the alert in the Live Datamart Monitor web application would create an extra alerts in some cases. This was fixed, such that enabling the action now requires clicking Save first.
CQS‑3785	Release 2.1.7 corrects an issue where the JavaScript `getSbStreams` API incorrectly returned full stream names without regard to the origin URI. For example, retrieving a stream from `sb://localhost/ContainerName` would still include ContainerName in the stream name (that is, `ContainerName.StreamOne`). Now, for example, if you get the stream from `sb://localhost`, the API returns `ContainerName.StreamOne`, and if you get it from `sb://localhost/ContainerName` it returns `StreamOne`.
CQS‑3784	Upon creating certain alert types using the Live Datamart Monitor web application, an issue caused an alert rule with "id=0" to be created that could not be deleted. This was fixed.
CQS‑3780	The Web UI used to configure time-based alerts could generate incorrect cron string expressions when using the repeat every time unit builder. This was fixed.
CQS‑3754	Configuring an alert rule in the Live Datamart Monitor web application would fail to generate an alert key. This was fixed.
CQS‑3384	Under certain rare high session disconnection rates, a random session could become invalid and that session would have to reconnect. This was fixed.

Fixed in Live Datamart 2.1.6

TIBCO^® Live Datamart 2.1.6 is a maintenance release with updates and enhancements as described in its New and Noteworthy document, and also corrections for issues as described in the following table. Live Datamart 2.1.6 inherits all fixes on the 2.0.x release branch through 2.0.6, and all the fixes on the 1.6.x release branch through 1.6.6.

Number	Resolution
CQS‑3776, CQS‑3659	When using the Web interface to configure Cron-based alerts, and you are using Cron expressions, the web interface will re-write the cron expression with the default string if you make and save any changes to the alert. This was fixed.
CQS‑3743	The LVSessionQueries Table did not have a means to query for limits. The LVSessionQueries Table now includes LIMIT clause in the PredicateExpression column for queries having LIMIT clause in them.
CQS‑3734	With authentication enabled, attempts to stop the Live Datamart Server left behind a process that must be manually killed in order to start up a new project. In 2.1.6, authentication credentials used to start the process are passed to the shutdown request. If they fail, then you are prompted for credentials.
CQS‑3732	In some instances, lv-server generate created a broken publisher interface when more than one table with Custom ID generation is specified. Interface generation for tables with custom ID generation was changed in 2.1.6. The custom ID generation schemas are now placed in the custom ID `sbint` file instead of the table schema `sbint` file.
CQS‑3726	The LiveView EMS recovery sample had become out of date and would not start or run correctly. This was fixed.
CQS‑3722	An issue occurred in the CountIf() function upgrade when upgrading from the deprecated Static Aggregation tool to the Author-Time Aggregation tool. This was fixed.
CQS‑3716	Under certain rare conditions a LiveViewPublisher client could hang when its LiveViewConnection was being shut down by another thread. This was fixed.
CQS‑3698	When using the Workbook Viewer feature of TIBCO LiveView Desktop™ to open and use a workbook created by DataWatch Desktop, there is a Create PDF Report button on the far right of the toolbar for this viewer. That button required a library shipped with DataWatch Desktop, iText-`version`.jar, that was no longer shipped with LiveView Desktop. 2.1.6 now ships with a new JAR file, MPL 1.1, iText-4.2.0.jar.
CQS‑3689	When logging out or disconnecting, WebSocket connections could leak threads. This was fixed.
CQS‑3658	LiveView Publishers and Applications were being compiled with an overridden StreamBase `datadir` parameter. This only affects StreamBase disk-based Query Tables. This override was removed and the StreamBase configured `datadir` will be whatever the StreamBase is configured to use.
CQS‑3593	Prior to 2.1.6, Cross-origin resource sharing (CORS) was enabled by default and any host could potentially connect to LiveView. 2.1.6 adds the ability to configure CORS support via the `liveview.server.allowedOrigins property`.
SB‑29699	The LiveView Create/Drop table adapter command, CreateStart does not create the requested table successfully and returns an error after the timeout period. This was fixed.

Fixed in Live Datamart 2.1.5

TIBCO^® Live Datamart 2.1.5 is a maintenance release with updates and enhancements as described in its New and Noteworthy document, and also corrections for issues as described in the following table. Live Datamart 2.1.5 inherited all fixes on the 2.0.x release branch through 2.0.6, and all the fixes on the 1.6.x release branch through 1.6.6.

Number	Resolution
CQS‑3707	When using the Workbook Viewer feature of TIBCO LiveView Desktop™ to open and use a workbook created by DataWatch Desktop, there is a Create PDF Report button on the far right of the toolbar for this viewer. That button requires a library shipped with DataWatch Desktop, iText-`version`.jar, that is no longer shipped with LiveView Desktop. You can obtain this JAR file from https://github.com/ymasory/iText-4.2.0.
CQS‑3699	Live Datamart has long supported both server-level and project-level user web applications, but if the same WAR file was in both locations, an issue allowed both WAR files to load. As of this release, any project-level web application has higher precedence over a server-level web application, if both types are present.
CQS‑3676	An issue caused connections to fail if the USERNAME environment variable was set to an empty string. Release 2.1.5 fixes the URI parsing to support existing as well as empty parameters. This prevents throwing errors when USERNAME is empty.
CQS‑3671	The deprecated Static Aggregation feature had a rare issue when removing a group which had been previously modified within the conflation publish period. It was possible for an initial value row to remain in the Static Aggregation table, when it should have been removed. This was fixed.
CQS‑3541	The order of LiveView's internal control fields on a table's DataIn stream appeared in a different order compared to its generated DataIn schema. This was fixed.

Fixed in Live Datamart 2.1.4

TIBCO^® Live Datamart 2.1.4 is a maintenance release with updates and enhancements as described in its New and Noteworthy document, and also corrections for issues as described in the following table. Live Datamart 2.1.4 inherits all fixes on the 2.0.x release branch through 2.0.6, and all the fixes on the 1.6.x release branch through 1.6.6.

Number	Resolution
CQS‑3635	The LVSessionQueries table field, PredicateExpression, previously did not include WHEN expressions, if any. Now they do.
CQS‑3633	In some rare cases, rows that should have been filtered out by the requesting client were returned. This was corrected.
CQS‑3615	The lv-client command sets client-info to the USERNAME environment variable value if no client-info is specified in the supplied URL. Because the USERNAME value was not being URL-encoded, spaces or special characters caused the connection attempt to fail. This was fixed.
CQS‑3556	Session timeout for LiveView connections were reduced to two minutes. Since all active LiveView connections send heartbeat messages, even if there is no query active, this should not create any problems. However, if a client is shut down without the opportunity to close gracefully, the session memory will recover much sooner.

Fixed in Live Datamart 2.1.3

TIBCO Live Datamart 2.1.3 is a maintenance release with updates and enhancements as described in its New and Noteworthy document, and also corrections for issues as described in the following table. Live Datamart 2.1.3 inherits all fixes on the 2.0.x release branch through 2.0.5, and all the fixes on the 1.6.x release branch through 1.6.6.

Number	Resolution
CQS‑3586	When using LiveView Web to connect to tables that are not native Live Datamart tables (for example, to TIBCO ActiveSpaces Spaces, or to StreamBase Query Tables from an external StreamBase process), the data was not presented correctly. Now it is.
CQS‑3576	In previous releases, there no way was provided for a JavaScript API user to know when an active Atmosphere Framework connection returned an error. This was fixed in the API.
CQS‑3574	In previous releases, the lv-client command previously allowed no way to specify JVM `-Xmx` options, which meant the command usually defaulted to a unnecessarily large heap. This was changed to supply `-Xmx512m` by default. The lv-client command now supports augmenting JVM parameters by setting the environment variable `LIVEVIEW_CLIENT_JVM_ARGS` in the context in which the lv-client process is launched.
CQS‑3573	If a client connection session to LiveView Server timed out when there were active queries (generally due to the browser being closed when a LiveView Web instance was active), an UnknownSessionException error showed in the server console, and the session state was not correctly released. This was fixed.
CQS‑3570	The lv-client publish command was not correctly clearing fields, so that if a row to be published specified `null` for a field value, the most recent previously published value was used instead. This was corrected.
CQS‑3562	In previous 2.1.x releases, no garbage collection (GC) options were specified by default, which meant that Live Datamart Server used the default collector for the JDK in use. For JDK 8, which is included with StreamBase, the default GC is the throughput collector. Starting with release 2.1.3, the default collector is explicitly specified as the G1 collector. See Java Garbage Collection Settings for a workaround for earlier 2.1.x releases.
CQS‑3558	When a password specified in an sbconf or lvconf file contained a forward slash (which is possible when the password is enciphered), and one or more alerts are configured, Live Datamart Server would fail to start. This corner case was fixed.
CQS‑3557, CQS‑3609	Enciphered values in a Live Datamart project's `sbd.sbconf` file, or in lower level imported sbconf files, were not being correctly deciphered. This was corrected.
CQS‑3540, CQS‑3520	In releases prior to 1.6, 2.0.6, and 2.1.3, the continuous portion of a query could send spurious delete or update messages to clients when the queried LiveView table was configured with two or more secondary indexes. The defect could also introduce inconsistent results in downstream aggregate or transformed tables. Snapshot queries were never affected. The failing situation was corrected. The workaround for the affected releases is to use one or no secondary indexes. Starting with 2.0.6, 2.1.3 and later, data tables can again use any number of secondary indexes. (As of release 2.1.3, release 2.0.6 is an expected but not promised future release.)
CQS‑3519	For tables with snapshot-parallelism greater than 1, Live Datamart 2.1.3 and later can process new queries faster than previous releases.
CQS‑3416	An error prevented the lv-generate interfaces command from working correctly when using the --all option, or when the equivalent command was run from Studio's menus. The command worked as designed when using the --type transform option with a --tables specification. The command and its Studio equivalent were corrected to work as designed in all cases.
CQS‑3386	Previously, attempting to connect to an unreachable LiveView Server produced a blank error message. The LiveView.Error on failed connection now has this message: `Connection Failed` with this detail line: `Failed connection to LiveView Server`.
CQS‑2441	In release 1.6.1's Java Client API, the behavior of the LiveResult and AbstractTupleEvent classes changed such that there was no way to use the LiveResult's getMap() method without accessing the now-deprecated event.getKey method. This was corrected.

Fixed in Live Datamart 2.1.2

TIBCO Live Datamart 2.1.2 is a maintenance release with updates and enhancements as described in its New and Noteworthy document, and also corrections for issues as described in the following table. Live Datamart 2.1.2 inherits all fixes on the 2.0.x release branch through 2.0.5, and all the fixes on the 1.6.x release branch through 1.6.6.

Number	Resolution
CQS‑3525	In previous releases, queries to TIBCO ActiveSpaces® back ends would not close all threads after the query was closed. This was fixed.
CQS‑3515	When using custom ID generation, using the setting `CQSDelete=true` for Publish path deletes had an issue deleting rows. This was fixed.
CQS‑3502	In previous releases, the lv-client addalertaction --sendtuple alert action could successfully send a tuple to a StreamBase URI, but the tuple had only null fields. The updated version takes `fieldName:value` pair arguments, so that you can define fields and use values from the input tuple or table.
CQS‑3455	An issue could cause a deadlock within the WebSockets framework used by the LiveView JavaScript Client API that prevented browsers from receiving query results. This was fixed.
CQS‑3325	An issue on the client side prevented URL actions to execute in an embedded Datawatch workbook called by LivewView Desktop. This was corrected by upgrading the Datawatch library.
CQS‑3135	There were cases where any LiveView client failed to shut down because there were still threads active. This was corrected.

Fixed in Live Datamart 2.1.1

TIBCO Live Datamart 2.1.1 is a maintenance release with updates and enhancements as described in its New and Noteworthy document, and also corrections for issues as described in the following table. Live Datamart 2.1.1 inherits all fixes on the 2.0.x release branch through 2.0.5, and all the fixes on the 1.6.x release branch through 1.6.6.

Number	Resolution
CQS‑3464	The andall() function with one argument is an aggregate function, but with two arguments is a simple function. In some LiveView contexts, andall() with more than one argument was being evaluated as an aggregate function. This was fixed.
CQS‑3454	The lastval() function is always an aggregate function, but in some LiveView contexts, it was being evaluated as a simple function. This was corrected.
CQS‑3445	In previous releases, an enciphered account credential would not match a non-enciphered token credential. This deficiency would manifest when an enciphered version of a user's password was placed in the `liveview.auth.properties` file, but the user attempted to access LiveView with a non-enciphered password. This was corrected such that, when matching account credentials, either the token credential, or the account credential, or both, can be independently enciphered.
CQS‑3434	In previous releases, author-time aggregation tables that used aliases in the projection for group keys were failing to delete aggregate rows when the group size went to zero. This was fixed.
CQS‑3321	Rows in the LVSessionPublisher table could sometimes skip having updates published at the regular two second update interval. The TotalPublished count was correctly maintained and the next time the row was updated, the values would be correct. This was fixed such that every row that has changes to it is updated every two seconds.

Fixed in Live Datamart 2.1.0

TIBCO Live Datamart 2.1.0 is a major release with updates and enhancements, and corrections for the issues in the following table. Live Datamart 2.1.0 inherits all fixes on the 2.0.x release branch through 2.0.4.

Number	Resolution
CQS‑3327	In previous releases, when a malformed query was sent to a LiveView Server — such as specifying a nonexistent or misspelled column name — sometimes the server would close the client connection before it had time to return an exception. This was fixed.
CQS‑2928	In previous releases, it was possible to write a Java LiveView client that used a LiveResult listener with a server running a continuous-only query. This is an unsupported combination with undefined results, so now an exception is raised during the registration of a continuous-only query used with a LiveResult listener.
CQS‑2431	In previous releases, when using the Java Client API, LiveResult.getChangedFields() could incorrectly report that the primary key value changed. The cause was identified and corrected.

Fixed in Live Datamart 2.0.6

TIBCO Live Datamart 2.0.6 is a service pack release with updates and enhancements. Live Datamart 2.0.6 inherits all fixes on the 1.6.x release branch through 1.6.6. The following issues were corrected in this release.

Number	Resolution
CQS‑3615	The lv-client command sets client-info to the USERNAME environment variable value if no client-info is specified in the supplied URL. Because the USERNAME value was not being URL-encoded, spaces or special characters caused the connection attempt to fail. This was fixed.
CQS‑3574	In previous releases, the lv-client command previously allowed no way to specify JVM `-Xmx` options, which meant the command usually defaulted to a unnecessarily large heap. This was changed to supply `-Xmx512m` by default. The lv-client command now supports augmenting JVM parameters by setting the environment variable `LIVEVIEW_CLIENT_JVM_ARGS` in the context in which the lv-client process is launched.
CQS‑3573	If a client connection session to LiveView Server timed out when there were active queries (generally due to the browser being closed when a LiveView Web instance was active), an UnknownSessionException error showed in the server console, and the session state was not correctly released. This was fixed.
CQS‑3570	The lv-client publish command was not correctly clearing fields, so that if a row to be published specified `null` for a field value, the most recent previously published value was used instead. This was corrected.
CQS‑3525	In previous releases, queries to TIBCO ActiveSpaces® back ends would not close all threads after the query was closed. This was fixed.
CQS‑3520	Aggregate expressions that use functions that can underflow could return incorrect results in rare cases. This could occur if the nature of the data attempted to change an expression in underflow state from one group-by bucket to another. Examples of aggregate functions that can underflow are firstval, lastval, min, and max. This issue was corrected.
CQS‑3518	In rare cases, it was possible for query registrations to get an NPE exception on the server. This would cause the client's query to fail. This was fixed.
CQS‑3515	When using custom ID generation, using the setting `CQSDelete=true` for Publish path deletes had an issue deleting rows. This was fixed.
CQS‑3464	The andall() function with one argument is an aggregate function, but with two arguments is a simple function. In some LiveView contexts, andall() with more than one argument was being evaluated as an aggregate function. This was fixed.
CQS‑3454	The lastval() function is always an aggregate function, but in some LiveView contexts, it was being evaluated as a simple function. This was corrected.
CQS‑3445	In previous releases, an enciphered account credential would not match a non-enciphered token credential. This deficiency would manifest when an enciphered version of a user's password was placed in the `liveview.auth.properties` file, but the user attempted to access LiveView with a non-enciphered password. This was corrected such that, when matching account credentials, either the token credential, or the account credential, or both, can be independently enciphered.
CQS‑3434	In previous releases, author-time aggregation tables that used aliases in the projection for group keys were failing to delete aggregate rows when the group size went to zero. This was fixed.

Fixed in Live Datamart 2.0.5

TIBCO Live Datamart 2.0.5 is a service pack release with updates and enhancements. Live Datamart 2.0.5 inherits all fixes on the 1.6.x release branch through 1.6.5. The following issues were corrected in this release.

Number	Resolution
CQS‑3441	In previous releases, persistent recovery of LiveView data tables that use custom ID generation correctly recover all data, but were incorrectly handling CQSInternalID initialization. This caused inserts and updates after recovery to fail to map properly to the correct pre-recovery rows. This was fixed.
CQS‑3432	The MultiConnectionConfig class in the LiveView Client API would previously stop trying to connect if it found no servers available. This was corrected to continue trying to connect. This fix allows you to enter a single URL in the list of servers; if the connection to that server goes away, it will continuously try to reconnect until the server is back up, at that point reconnecting all queries.
CQS‑3426	In certain very rare conditions, the LiveViewStatistics table logic that determines the amount of memory a table is using could deadlock in a way that prevented the LiveViewStatistics table from updating at all. This was fixed.
CQS‑3408	In previous releases, aggregate queries that had a group that is removed, then re-added back in later, could in some circumstances have the group keys set to null. Tables with snapshot-parallelism greater then 1 could have this null value set back to the correct value. All other values in the row not involving the group key or keys were correct. The cause was identified and corrected.
CQS‑3401	In certain rare timing conditions the LiveView Publish, Query, or Delete adapters could throw a benign NullPointerException during server shutdown. This was fixed and the NPE no longer occurs.
CQS‑3394	Time windowed queries that have top level OR terms could receive incorrect results. The cause was identified and corrected as of release 2.0.5. Previous releases can avoid this defect by surrounding the predicate portion of time windowed queries that contain OR terms with outermost parentheses.
CQS‑3389	In previous releases, LiveView projects that met two conditions could fail to start from the command line with lv-server. The conditions were that the project (1) imported a schema from an `.sbint` or `.sbapp` file, and (2) used liveview.project.out to specify an output directory other than the project root.
CQS‑3381	In release 2.0.4 only, the `<java-vm>` element of the `sbd.sbconf` file for LiveView projects was inadvertently limited to a single `<param>` child element. This meant that you could only specify `<param name="java-home"...>` or `<param name=jvm-args ...>` but not both. This incorrect limitation was lifted in release 2.0.5 to allow both `param` types in the same `<java-vm>` element.
CQS‑3303	Certain aggregate and order-by queries against a LiveView Server can cause server refill requests that are logged at the INFO level in the server log. In previous releases, this resulted in a great many refill request messages. Starting with this release, these refill requests are now rate limited to one per minute per query using the StreamBase logger's compressed log feature.

Fixed in Live Datamart 2.0.4

TIBCO Live Datamart 2.0.4 is a service pack release with updates and enhancements. Live Datamart 2.0.4 inherits all fixes on the 1.6.x release branch through 1.6.5. The following issues were corrected in this release.

Number	Resolution
SB‑28030	Prior to release 2.0.4, deleting a row via the publish path was less efficient than publishing a row. This was optimized so that deleting a row now costs about as much as publishing one.
CQS‑3169	Table row deletes using the data path were failing to honor the case insensitive directive for the primary key field, and thus were always case sensitive. This was fixed.
CQS‑3165	A null pointer exception could occur when new rows were inserted following a delete into a StreamBase Query Table exposed to the LiveView server. The cause was identified and corrected.
CQS‑3141	In the Alert Send Tuple action, when the connection to the configured StreamBase Server was broken, it would never try to reconnect. LiveView clients now try to reconnect each time another Send Tuple action is fired to that StreamBase Server.
CQS‑3138	Values set in the LiveView URI client-info query parameter could not use URI encoded characters. This was fixed.
CQS‑3119	In previous releases, for tables configured with periodic publish, if a row was added then removed within the publish period, clients would see a delete event for a row that was never added. This was corrected for releases 1.6.5 and 2.0.4.
CQS‑3115	In previous releases, join target tables that were configured with the snapshot-parallelism attribute set greater than 1 would prevent LiveView Server from completing startup. This was fixed for releases 1.6.5 and 2.0.4.
CQS‑3114	LiveView Desktop would restart all queries every five minutes, which would cause the server to resend snapshots of the query results. This is no longer the case: the initial snapshot is received only when the query is started, and after that, query updates keep LiveView Desktop up-to-date.
CQS‑3102, CQS‑3099	Under certain circumstances, in LiveView Desktop, a time series chart such as a line graph might have displayed erroneous values, due to an interpolation setting that was not user configurable. This automatic interpolation was removed, and a time series lines now display only actual values. This fix also corrected an issue with time series line graphs plotting incorrectly.
CQS‑3092	In previous releases, LiveView Desktop could fail to draw open-high-low-close graphs. The cause was identified and corrected.

Fixed in Live Datamart 2.0.3

TIBCO Live Datamart 2.0.3 is a service pack release with updates and enhancements. Live Datamart 2.0.3 inherits all fixes on the 1.6.x release branch through 1.6.4. The following issues were corrected in this release.

Number	Resolution
CQS‑3082	With LiveView Desktop connected to a LiveView Server with running queries, if the server is then shut down, the query views would display `(Not Connected)` in their top status bars — which was correct while the server was, in fact, down. However, when the server was restarted and the Desktop reconnected (using File → Reconnect to Server), the query views would still display the `(Not Connected)` message, even though the contents of those views had begun updating again. This was fixed such that the `(Not Connected)` message only displays when the Desktop is genuinely not connected to the server.
CQS‑3074	Predicates that contained index key fields set to null would sometimes return an error. The cause was identified and corrected in releases 1.6.5 and 2.0.3. A workaround for earlier releases is to set the system property `liveview.query.unique.plans` to 1.
CQS‑3072	For dynamic aggregation queries only, and only the continuous portion thereof, and only for predicates that are planned where there is more than one value used for index equity, client data updates could be missed. The way to tell whether a predicate has more than one index equity is by looking in the server log for instances of `Predicate rewritten: <re-written predicate> plans: X, unique plans: Y`. If Y is greater than 1, then this issue can occur. This situation was corrected in LiveView 1.6.5 and 2.0.3. For LiveView 1.6.4 and below, and for 2.0.0 through 2.0.2, you can work around this issue by setting the system property `liveview.query.unique.plans` to 1. LiveView 1.5.x did not have the problem.
CQS‑3053	The `<adapter-configurations>` element, newly added to the XML syntax of server configuration files in release 7.5.0, was not correctly copied to the generated `lv-bin/sbd.sbconf` when starting LiveView Server. This prevented the use in LiveView projects of adapters that use this feature, such as the ActiveSpaces operators. The cause was identified and corrected in StreamBase 7.5.3.
CQS‑2536	The `Not Connected` message in LiveView Desktop's bottom right status bar was trying to squeeze into a non-resizable field that just fit the word `Connected`. This was fixed.

Fixed in Live Datamart 2.0.2

TIBCO Live Datamart 2.0.2 is a service pack release with updates and enhancements. Live Datamart 2.0.2 inherits all fixes on the 1.6.x release branch through 1.6.4. The following issues were corrected in this release.

Number	Resolution
CQS‑2961	The lastval() aggregate function could sometimes return incorrect values. Tables that had a higher snapshot-parallelism setting and predicates that underflowed for any reason would exacerbate the problem. This was fixed.

Fixed in Live Datamart 2.0.1

TIBCO Live Datamart 2.0.1 is a service pack release with updates and enhancements. Live Datamart 2.0.1 inherits all fixes on the 1.6.x release branch through 1.6.3. The following issues were corrected in this release.

Number	Resolution
CQS‑2919	In LiveView Desktop, when connected to a LiveView Server, in the Window → Preferences dialog, the Restore Defaults button could fail to restore the dialog. This was fixed.
CQS‑2918	In LiveView Desktop, with a tabular query view whose query is not running (because it is paused or has hit a row limit), if you right-clicked in that view and chose either Columns or Notifications, an internal exception would prevent the expected dialog from appearing. This was corrected.
CQS‑2844	Deleting rows via the DataIn path was unexpectedly slow. The delete performance was greatly improved.
CQS‑2837	A transform application referencing an aggregation table failed to see delete events when a row left aggregation scope, preventing the transform from acting on these events or sending a delete action into the recipient table. As of release 2.0.1, transform applications now see these events as an input tuple with `CQSReferredCount==0` and the row that was deleted reported in the newly added `Old` field of type tuple. Since a new field was added, transform applications written before 2.0.1 will no longer typecheck. You must at minimum regenerate the transform interface, and possibly also convert your transform application to accommodate the new input field. To migrate an existing transform application: Regenerate the transform interface, using either the new StreamBase → Generate LiveView Interfaces menu option or a command like the following: `lv-server generate --type transform --tables baseTable,transformedTable projectDir` Update the transform application's Input Stream schema to use the newly generated transform schema. If you expect delete events and wish to act on them, continue with the following migration steps: Add to the transform a Filter operator with two output ports, the first emitting tuples matching the test `CQSReferredCount==0` and the second emitting all remaining tuples. This isolates tuples representing a row deletion in the source table. To emit a deletion event, send out of the transform Output Stream the key fields needed in the recipient table, and the field `CQSDelete` set to `true`.
CQS‑2756	In release 2.0.0, the Jetty web server launched as part of LiveView Server was locking HTML files under its control by default when running, which affected development of new and updated HTML files, especially on Windows. As of release 2.0.1, the server no longer locks its files by default.
CQS‑2475	If a LiveView data table had a snapshot parallelism setting of 1, and a query with a limit of X was issued where there were exactly X rows that matched the query, all X rows would be delivered to the client, but then a snapshot exceeded exception was thrown. This was fixed.

Fixed in Live Datamart 2.0.0

TIBCO Live Datamart 2.0.0 is a major release with updates and enhancements, and corrections for the issues in the following table. Live Datamart 2.0.0 inherits all fixes on the 1.6.x release branch through 1.6.3.

Number	Resolution
CQS‑2430	The text of the `EOF reading data from binary stream` DEBUG message was changed to indicate that EOF and I/O exceptions incurred just after a server connection is closed are normal and can be safely ignored.