BI xPress Server Release Notes

2019

2019

Version 2019.1.1 [February 4, 2019]

New Features

  • New 46067: Add "Default Number of Days" setting within BI xPress Server feature settings
    • For users who have hundreds of executions occur within a single day, We recommend lowering the default number Used by the Extract Load Trend, Package Alerts, Recent Execution Details, Recent Execution Summary and Runtime Standard Deviation dashboards to specify the default number of days to include for usage within SSIS Dashboard Reports 

Fixes

  • Fix 45760: System Dashboard throws System.ArgumentException: A route named 'TestCoverageReportsForObjectPaths' could not be found in the route collection.
2018

2018

Version 2018.2.3 [April 27, 2018]

Important:  The 2018.2.3 release for BI xPress Server will be the last supported release for SQL Server 2008 and 2008 R2.

Updated Features

  • Update 16954: Improvements to Notification Engine's Visual Studio Team Services provider
    • The VSTS Provider now uses Personal Access Tokens (PATs) to connect to your Visual Studio Team Services Instance or Team Foundation Server
    • The Notification Engine now writes the message template to the work item's Repro Steps and Description
    • The VSTS Provider now includes the work item's Title, Priority and Severity within the work item that is created
    • Users can include placeholders within the VSTS Provider's fields to dynamically change its content based on the received notification request 

Fixes

  • Fix 13934: Applying Auditing Framework to a project via command line does not apply the Audit Framework
  • Fix 16989: SSIS Monitoring Console does not display errors and warnings
2017

2017

Version 2017.4.7 [November 27, 2017]

New Features

  • New 11612: Auditing Framework's Add / Remove buttons are now more intuitive
    • The Add / Remove buttons no longer toggle, clicking the button only performs the advertised function
    • The back and next buttons will appear and disappear when not applicable
  • New 13054: Workbench Server documentation now includes required permissions

Updated Features

  • Update 11979: Online help documentation now includes a rolling list of release notes that include all product release notes within a single file

Fixes

  • Fix 4409: Monitoring Console can hide precedence constraints if control flow components are in close proximity with each other
  • Fix 13531: Server edition's Extract / Load Detail should round runtime to the nearest hundredths
  • Fix 13073: The Workbench Server installer does not automatically add the "Log on as batch job rights" permission to the correct user
  • Fix 13525: Within System Dashboard, LegiTest Status tile does not appear even though valid tags are used

Version 2017.3.3 [August 7, 2017]

New Features

  • New 9201: Auditing Framework Command Line now includes itemPassword switch
    • Users can now provide a password that will be applied to all packages and projects that have their Protection Level set to either EncryptSensitiveWithPassword or EncryptAllWithPassword
  • New 10276: BI xPress Server and Notification Engine within SSDT now include a way to view notifications by event name.
    • BI xPress Server allows users to click on the event name to go to a page that will group notifications by event name.
    • BI xPress Notification Engine within Workbench or BI xPress Visual Studio Extension/Add-in now has a button that will show users the notifications grouped by event name.
  • New 2846: Licensing now works within environments that use FIPS compliant algorithms for encryption

Fixes

  • Fix 11952: Monitoring Console Server Performance slowed in version 2017.1.5 and beyond
  • Fix 12403: Denied Access to registry key "HKEY_CURRENT_USER"
  • Fix 11086: Stored procedures CheckIfUserCanAccessSecurable and GetAllSecurableEntities are always being dropped and created at website startup
  • Fix 12480: Could not load file or assembly 'ChilkatDotNet2' or one of its dependencies.

Version 2017.2.3 [May 1, 2017]

Updated Features

  • Update 11047: Help Documentation for Notification Engine now includes details for configuring custom parameters
  • Update 10978: Help documentation for setup instructions now includes details for multi-domain considerations

Fixes

  • Fix 10346: Some operations within DOC xPress and System Dashboard aren't responsive or appear disabled
  • Fix 10382: Workbench Server does not populate Action and RoleAction tables in host database

Version 2017.1.3 [February 2, 2017]

New Features

  • New 4999: BI xPress Monitoring console now interacts with Workbench Server's (Beta) System Status feature
    • Adding packages to a view found within Workbench Server's new (Beta) System Status allows System Status to read and display the status of those packages if executions are present within the Monitoring Console
    • The (Beta) System Status can be enabled by your Workbench Server administrator through the Administration Features page
    • By default, the new (Beta) System Status will be disabled
  • New 7913: Package Group filters included within SSIS Monitoring Dashboard
  • New 6256: Users can now delete System Dashboard tiles directly from the dashboard
  • New 6826: The System Dashboard is now the home page for Workbench Server
  • New 9267: Workbench Server now includes public beta features that can be enabled or disabled

Updated Features

  • Update 8739: Improved product version logging at start up

Fixes

  • Fix 9142: The license expiration date does not appear in the License Manager
  • Fix 7803: With the addition of the System Dashboard and System Status, the header is disjointed
  • Fix 7898: Workbench Server does not confirm when deleting users
  • Fix 7982: License activation and deactivation messages are confusing
  • Fix 8011: Workbench Server Licenses does not include access to System Dashboard
  • Fix 8699: System Dashboard drop-down buttons includes erroneous icons and white divider
  • Fix 8738: If Workbench Server's version falls outside a license's maintenance period, the system settings' licenses page will not display the license
  • Fix 9285: "Add Domain User" button is missing
2016

2016

Version 2016.4.5 [October 25, 2016]

New Features

  • New 1491: Control Flows now contain precedence constraints for nested tasks
    • Control Flows now support showing the precedence constraints for nested tasks such as Sequence Container, ForEach Container, and others. Also, users can now move the tasks and components around freely on the page in order to get a better view of some clustered items.
  • New 1618: BI xPress Server Administrators can now clean up orphaned activities and files within the Auditing Framework
    • This feature removes any activity that references a file that no longer exists. It also removes all user deployed files older than a day that are not associated with an activity.
  • New 1620: BI xPress Server's SSIS Monitoring Console is even more mobile device friendly.
  • New 6802: BI xPress Server notification engine now includes a default template for creating VSTS notifications
  • New 6723: Upgrading Workbench Server will now display a message indicating that all previous versions will be uninstalled during the upgrade process
    • Users upgrading Workbench Server will now see a message indicating that all previous versions of Workbench Server will be uninstalled prior to upgrading. This is not a change in behavior from previous releases, only an update to the user interface to make it more clear as to what is happening behind the scenes. This message is only visible when upgrading.
  • New 7373: Added PowerShell 3.0 or later to the system requirements for Workbench Server

Updated Features

  • Update 6279: SQL notification provider now supports batches
  • Update 4718: Activating or Deactivating a license now redirects users to license overview page upon completion

Fixes

  • Fix 4838: SSIS Monitoring Console's filter type drop down removes filter if filter value isn't first populated
  • Fix 4981: Users can't toggling between Project and Package Connection within Auditing Framework
  • Fix 5536: Notification template syntax errors aren't being logged within the Event Execution History
  • Fix 6214: BI xPress Server "Unspecified Error" when attempting to applying auditing framework to certain packages
  • Fix 6773: Event names are no longer being cached in-memory for Notification Subscriptions.
  • Fix 6666: Licensing is now more robust and should not issue an error during installation.

Version 2016.3.7 [August 1, 2016]

New Features

  • New 4112: Added Row Counts to Monitoring Console
    • Row counts for data flows are now displayed on the monitoring console web page.
  • New 4794: Notification Engine now supports collections and a new syntax engine is now available for powerful and dynamic message templates.
    • Collection support for Message Templates has arrived with new flexibility, features, and power. The new message templates allow collections of data to be sent to the Notification Engine and then displayed, transformed, summarized, and calculated using the new template syntax.
  • New 4945: New SSIS Package Status Tiles for System Dashboard
    • Brighten up your dashboard with customizable tiles that show how many packages have failed, succeeded, or generated warnings. Filter by package name and limit the duration to a time period of your choosing to further refine your dashboard and add as many tiles as you'd like.
  • New 4782: While upgrading Workbench Server, most of the existing settings can be reused.
    • Users can now choose whether to use the existing settings from the previous installation or choose to start fresh when upgrading Workbench Server.
  • New 4923: System Dashboard for Workbench Server.
    • Workbench Server's newest feature allows users to create a custom dashboard for displaying status and summary information for BI xPress' Auditing Framework and for LegiTest's System Coverage features. Users can add multiple "tiles" that are each configured for displaying concise data points they may be interested in.

Fixes

  • Fix 4655: SSIS Packages with Auditing Framework applied to ISPAC files now works when Row Count logging is enabled
  • Fix 4656: BI xPress Server's SSRS Monitoring Console no longer issues the error "An error occurred while processing your request" when using a password
  • Fix 6026: Editing a message template that uses HTML now behaves consistently with what users have come to expect in a document editor.

Version 2016.2.4.504 [May 4, 2016]

New Features

  • New 4386: SQL Server 2016 Support
  • New 4207: BI xPress Server now allows users to filter package names and groups
  • New 4208: Allow BI xPress Server users to specify the BI xPress DB from which to monitor
  • New 4280: The Add / Edit Notification UI should have an editable drop-down list of existing Event Names
  • New 4285: The Add/Edit Notification UI needs a test button
  • New 4090: Administrators can now add users without those user having to login
  • New 4293: Pragmatic Works License Activator is now included.

Fixes

  • Fix 4274: Notification providers are duplicated in the Add Notification providers drop-down
  • Fix 4264: Notification Engine now sends notifications more efficiently and faster.
  • Fix 4115: The installer has been made simpler with regards to the URL
  • Fix 4287: Text boxes within Workbench Server do not mark forms as modified until they lose focus

Version 2016.1.7.131 [January 31, 2016]

New Features

  • New SSIS Dashboard
    • (BIXSRV-VSO-1666): Execution Dashboard gives users one place to view the most common counters of SSIS package execution
    • (BIXSRV-VSO-1667): Extract/Load Trend Dashboard provides users with a graphical view of extract and load trends over days, months, weeks or even years
    • (BIXSRV-VSO-1668): Extract/Load Detail Dashboard provides users with a more detailed look of each data flow within package executions
    • (BIXSRV-VSO-1669): Package & Task Performance Dashboard provides users with package and task level performance graphs for specified intervals
    • (BIXSRV-VSO-1670): Package Performance Dashboard provides users with package level performance graphs for specified intervals
    • (BIXSRV-VSO-1671): Package Execution Trend Dashboard provides users with information regarding package and task runtimes as well as errors and warnings
    • (BIXSRV-VSO-1672): Package Alerts Dashboard provides users with detailed error and warnings for packages
    • (BIXSRV-VSO-1673): Recent Executions Summary Dashboard provides users with the status of package executions
    • (BIXSRV-VSO-1674): Recent Executions Detail Dashboard provides users with a more detailed look at recently execute packages and tasks
    • (BIXSRV-VSO-1675): Runtime Standard Deviation Dashboard provides users with a graphical display of packages that are running slower / faster than their usual trend
    • (BIXSRV-VSO-3330): Include help documentation for SSRS Monitoring

Updated Features

  • Update SSIS Monitoring
    • (BIXSRV-VSO-3349): When dynamically generating a data flow layout, SSIS Monitoring will infer as many of the component icons as possible
    • (BIXSRV-VSO-3368): When new control flow tasks have been detected within SSIS Monitoring, the new control flow task will now appear
    • (BIXSRV-VSO-3645): Improved search result filtering between SSIS Monitoring and DOC xPress Server
  • Update Notification
    • (BIXSRV-VSO-3328): Add help documentation for Notification
  • Update Workbench Server
    • (BIXSRV-VSO-3688): Chocolatey package ids have been changes to not include hyphens

Fixes

  • Fix Auditing
    • (BIXSRV-VSO-2651): Auditing now correctly handles invalid JSON characters that are included within a group's name
    • (BIXSRV-VSO-3489 & 3879): Auditing now correctly handles applying auditing to SSIS 2008 packages on an SSIS 2008 only server
    • (BIXSRV-VSO-3731): Resolve issue within BI xPress Server database when database is not set to "Large DB Support"
  • Fix Notification
    • (BIXSRV-VSO-3798): Notification command line tool now correctly sends notifications when sending based on notification id instead of event name
2015

2015

Version 2015.3.7 [November 5, 2015]

New Features

  • New Auditing
    • (BIXSRV-VSO-1500): SSIS Package can now be organized using custom Package Groups
  • New SSIS Monitoring
    • (BIXSRV-VSO-1500): Package Executions can now be grouped using Auditing's Package Grouping Feature

Updated Features

  • Update SSIS Monitoring
    • (BIXSRV-VSO-1254): BI xPress Server's SSIS Monitoring now uses the same layout engine to display missing or outdate layouts and Data Flows no longer show a "layout out of date message"
  • Update Notification
    • (BIXSRV-VSO-1710): Users can now use the command line to send notifications using BI xPress Server's Notification
    • (BIXSRV-VSO-2476): Notification is now included within both a BI xPress Server or LegiTest Server license

Fixes

  • Fix Auditing
    • (BIXSRV-VSO-1753): Progress Status messages now appear in the correct order
  • Fix SSIS Monitoring
    • (BIXSRV-VSO-1892): SSIS Monitoring package execution header now correctly displays
  • Fix Notification
    • (BIXSRV-VSO-1857): Saving changes to message templates now provide visual feedback to the user
  • Fix SSRS Monitoring
    • (BIXSRV-VSO-2600): SSRS Database Password property within Feature Settings now displays asterisks instead of plain text
  • Fix Workbench Server
    • (BIXSRV-VSO-1989): Fix visual issue with Product Summaries when adjusting size of browser window

Version 2015.2.5 [September 14, 2015]

Updated Features

  • Update Workbench Server
    • Update installer to be compatible with Windows 10

Version 2015.2 [September 3, 2015]

New Features

  • New Notification
    • Send notifications via Email (SMTP), SMS Text Message, Event Log, SQL Server, Text Files, or Twitter
    • Utilize Notification's command line tool to send notifications

Updated Features

  • Update LegiTest Server
    • (BIXSRV-TFS-10495): Create subscriptions to LegiTest solutions that trigger BI xPress Server notifications based on passed or failed tests.

Fixes

  • Fix SSIS Monitoring
    • (BIXSRV-TFS-11169): Resolve issue where Monitoring package execution header would disapear

Version 1.6.0.505 [May 5, 2015]

New Features

  • New Auditing
    • (BIXSRV-TFS-9521): BI xPress Server can now add or remove Auditing to individual files and support SSIS 2005, 2008, 2012, and 2014 DTSX packages in addition to the already supported SSIS 2012 and 2014 ISPAC file support. Please note, each desired version of SSIS must be installed on the machine that BI xPress Server will operate on.
  • New BI xPress Server
    • (BIXSRV-TFS-8750): BI xPress Server now supports read only users. Read only users can download and view packages that others have processed as well as access the SSIS Monitoring but they can't apply or remove Auditing from packages.

Updated Features

  • Update SSIS Monitoring
    • (BIXSRV-TFS-9814): Warning and Errors pane now includes paging, which dramatically increases performance of view loading
    • (BIXSRV-TFS-9781): SSIS Monitoring now includes a loading indicator.
  • Update Workbench Server
    • (BIXSRV-TFS-8716): Include Activities with Workbench Server and allow Auditing to access progress lists for past executed activities.
    • (BIXSRV-TFS-10391):Workbench Server now reconciles over-allocated users after any license operation and deallocates user CALs from a feature based on last login date.

Fixes

  • Fix Auditing
    • (BIXSRV-TFS-9364): Update Auditing to now read and extract the Project Protection level for ISPACs.
    • (BIXSRV-TFS-9778): Auditing now correctly applies to SSIS Packages containing Package Connect Managers and Parameters.
    • (BIXSRV-TFS-10501): When uploading SSIS Objects, the file filter within directory browser now behaves similarly between different browsers.
  • Fix SSIS Monitoring
    • (BIXSRV-TFS-9407): Switching between Data and Control Flow now correctly refreshes the Tasks and Components Success / Failure colors.
  • Fix Workbench Server
    • (BIXSRV-TFS-9377): Include further Internet Explorer 8 compatibility improvement.
    • (BIXSRV-TFS-9418): Resolve stability issues within Feature Settings page.
    • (BIXSRV-TFS-9770): Include custom landing page for "401 - Unauthorized" errors.
    • (BIXSRV-TFS-9771): Include navigation header in error page.
    • (BIXSRV-TFS-10103): Special Characters are now allowed within user names.

Version 1.5.2.114 [January 14, 2015]

New Features

  • New Auditing Feature
    • The new online Auditing provides users with web browser access the ability to upload SSIS 2012 or 2014 Project Deployment Files (ISPACs) to BI xPress Server in order to add, remove, or edit BI xPress' package auditing feature to the SSIS packages contained within the ISPACs.
    • Download ISPACs that have already had Auditing added, removed, or edited.
    • Control Auditing default settings for all BI xPress Server users from within Feature Settings.
  • New SSIS Monitoring Feature
    • The new online SSIS Monitoring provides users with web browser access to real time monitoring of all SSIS packages that have Auditing. Normally such information can only be obtained through debugging packages within the development environment.

Important:  Precedence constraints within containers currently are not supported within the SSIS Monitoring. This limitation has absolutely no impact on package executions.