...
Email Accounts
File Collectors
Scripting
When using a Date/time function on an Attribute. If the date parameter is NULL, the function returns null instead of throwing an exception that the date can not be null.
Export / Import
The built-in limit on the size of files that can be imported / uploaded has been increased to 1Gb to allow for larger exported configuration files.
...
Now task initialisation failure message contains more details about the failure itself and in case of stream attribute expressions failures - it contains the details of stream name which failed, stream attribute name which failed, as well as the actual expression that failed.
More meaningful message is now provided in case of archiving failure.
Processing Statistics
Performance statistics are recorded in the 'STATS' table. Time duration statistics are now all standardized to be stored in seconds.
...
Stream Actions and Task Plans are now compiled the first time they are run, and the compiled versions are saved so that they can be re-used in subsequent runs. This can result in significant performance improvements, particularly for Actions that are run frequently.
Unprocessed
...
Bug Fixes
Graphical User Interface
...
Importing a dashboard that had a background filter set to reference a driving view could cause the filter to fail at runtime.
Dashboards that were created at 5.8 or earlier were upgraded to 5.9 in such a way that if they were then exported and imported into a different instance, the views in the dashboard sometimes became disconnected from the dashboard frame and could only be removed from the screen be reloading the application. This fix corrects the original issue in unmigrated dashboards, and also fixes dashboards that have been migrated.
Views
Pivot Views
When creating a Pivot View, A pivot column source can be set to an Expression referencing a lookup pipe that is used to generate the pivot columns. If the lookup pipe is self referencing on the stream for a Pivot View, then it is getting the columns from the previous stream set in instead of the latest streamset. It now correctly creates the pivot columns using the latest streamset.
Streams
Users can now use the internal variable _outputMultiplier in stream attribute expressions instead of "_type". _outputMultiplier is just an alias for _type and contains an element of the result of the Stream's "Output Multiplier" expression. See help on Stream output multipliers for an explanation of this advanced feature.
In memory stream caching limits were including update counts for streams items, when they should only be for stream items created. It now correctly controls the in memory stream caching for stream sets created.
Filters
Filters that contained empty sub-clauses sometimes generated invalid sql.
Analysis
Collectors & Exporters
File Collectors
Leaving the Xpath expression blank on an HTML File Collector caused the collector to fail with an internal error.
Excel file collectors failed occasionally when interpreting the time part of a date-formatted field.
Database Collectors
...
Database Exporters
Email Accounts
Scripting
Functions
System Administration
Active Directory
Active directory logging nolonger fails if {instance} not set.
General
A System Task would hang if the number of days to keep statistics records was not configured. Now, if the number of days is blank, no statistics records are deleted.
Processing Statistics
Statistics logging configuration changes in PhixFlow system configuration were not being applied until Tomcat was restarted. Now works correctly without restart required.
Statistics logging is now turned on and off via the System Configuration > System Tuning tab > 'Log Statistics to File' and 'Log Statistics to DB' checkboxes.
It was previously not possible to turn on/off logging to file and logging to the database indepndently.
Configuration
Storage
Trying to save large text values in certain object type (e.g. in the expression and description fields of a Stream Action) could fail with an Oracle ORA-24816 error.
Schema
This release corrects a schema index that was inconsistently named between a full install and an upgrade from a previous release.
Stream publishing no longer fails if the stream table's primary key and index on primary key column don't share the same name.
Logging
Unprocessed
| Processing Statistics (Stream Write Stats) - Store the Stream Storage Type in the stats data (field=context_1_type) |
| A privilege has been added to the user role to allow users to view applications. |
| If statistics logging is not enabled via System Configuration > System Tuning. ie. Log statistics to file checkbox is not ticked or Log statistics to DB checkbox is not ticked, then the Stats File Logging Seconds or Stats DB Logging seconds are not required fields, until stats logging is turned on by ticking the check boxes. |
| Show the record count in the page status/navigation bar for Pivot Views. |
| Workflow model is now always active. |
| Fixed: The pie chart configuration screen was showing #labelAttr due to a missing translation. |
| When setting up a Pivot View, a label attribute can be specified. If a label belongs to more than one Pivot column, it now shows a message indicating where the name of the label and which column its already been used on. Each Pivot Column requires its own unique label. |
| When count() was being used in a Pivot View value attribute, it was wrapping it inside a sum() aggregate by default. It now correctly allows a count() to be used as a pivot value. |
| Default worker size wil now be equal to either of the two: default buffer size, constant value of 1000, which ever is less. Even when worker size is set it will be restricted to either the value set or max buffer size / number of workers whichever is less. |
| Report General Error messages for File collectors and - show file name, line number and error class name. |
| When a Task plan fails and is re-ran Analysis is run on on the previously failed task within the Task plan which has an incomplete Stream Set and also for all tasks with incomplete Stream Sets following this task in the Task plan which had not yet been run. |
| Copying a stream causes duplicate actions and attributes in another stream no longer to be the case. |
| Report General Error messages for File collectors and - show file name, line number and error class name. |
| Lookup pipes are now prevented from using any strategy other than default. In such case a WrongStrategyException exception will be raised. |
| When data is excepted on a pipe. No error message was generated to the console when there was no data. Now correcly shows the error message. |
| MySQL / MariaDB collector queries now reflect column aliases in select statements i.e. select abc as "Def" previous this returned the attribute "abc", now it returns "Def" |
| Analysis and rollback of partitioned tables on SQL Server could fail with a 'Deadlock Detected' message. This failure was observed when many users were using Action buttons to run task plans on the same transactional stream, and when running analysis to populate many periods of data in Daily or Monthly streams, and only when running under heavy load. |
| The original error of discarding messeges without PhixFlow variables referenced has been resolved. |