QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(1,000 intermediate revisions by 7 users not shown)
Line 1: Line 1:
This page contains new features and fixed issues for each QPR ProcessAnalyzer release.
This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.


== Next Release: QPR ProcessAnalyzer 2023.3 (planned release date 2023-05-03) ==
[[Next_Release_Roadmap|See roadmap for next release features and fixes]]


'''Features:'''
==Current Release: QPR ProcessAnalyzer 2026.4 (build 10956) (released 20.5.2026)==
* B-07786: Big data chart and flowchart have now more aggregation methods available for measures, such as median, percentile, standard deviation and variance. Also for textual items, only unique values can be listed.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2026_4.pdf QPR_ProcessAnalyzer_2026_4.pdf]
* B-07747: Conformance checking has been imported to accept design models where there can be multiple tasks with the same name.
* B-07844: For Snowflake queries, support for "array" aggregation method to return aggregated items as a single array.
* B-07847: Add throttling for ScriptLauncher client-side/gateway imports.
* B-07856: Snowflake: Support for creating and accessing arrays and objects in SQL Expressions.
* B-07860: Snowflake: Array functions and DesignModel.Tasks.
* B-07571: Snowflake: Support for IsConformant function and arrays.


'''Fixed issues:'''
===New features===
* D-13536: BusinessCalendar.CalculatePresets threw "System.InvalidOperationException: Collection was modified"-exception.
* [[QPR_ProcessAnalyzer_BPMN_Editor#Opening_and_Saving_a_Diagram_in_the_Repository|BPMN diagrams stored in QPR EnterpriseArchitect]] can be opened and saved in QPR ProcessAnalyzer BPMN editor for conformance analysis. (B-09041)
* D-13527: Checkbox height didn't increase when long label needed to span to multiple lines.
* Added setting [[PA_Configuration_database_table#:~:text=AIAgentDefaultModelName|AIAgentDefaultModelName]] to define AI Agent's default LLM, and updated gpt-5.4 as default for OpenAIDefaultModelName setting. (B-09039)
* D-13477: Chart types without y-axis mapping caused an error when series mapping was used.
* Implemented OAuth refresh tokens grace period, and limited MCP tool names to 50 characters. (B-09090)
* D-13363: Snowflake query with EvaluateAfterAggregations and IsHidden failed when dimensioning by case id column.
* In object-centric flowchart, [[Object-Centric_Flowchart#Object-centric_flowchart_general_settings|object types can be hidden and shown]] with an toggle button, and flowchart flow routing has been improved to avoid label overlapping. (B-09042)
* D-13383: Snowflake query gave error "Invalid column name 'FromCase Name'".
* [[QPR_ProcessAnalyzer_Table|Table]] header margins have been adjusted to fit more text, and column filter menu icon is shown only when hovering header. (B-09032)
* D-13523: Request id was incorrectly shown as zeros in error messages.
* Expression language API is available to change filter's model, and added functions [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#:~:text=CreateScript|CreateScript]] for project, and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Script|Modify]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Script|DeletePermanently]] for script objects. (B-09006)
* D-13541: In CSV import, error message for maximum number of columns exceeded is improved (maximum is 300 column for SQL Server).
* Datatable foreign key definitions are maintained as consistent when datatables are modified. (B-09035)
* D-13583: Objects count in header didn't work for empty Snowflake model.
* D-13597: UI supports now datatable column type "ShortString" (previously datatable contents preview and CSV import didn't work).
* D-13553: Import big pacm file. Request body too large. The max request body size is 30000000 bytes.
* D-13306: StackOverflow gave exceptions when using SqlDataFrames.
* D-13575: Operand type clash: nvarchar(max) was incompatible with sql_variant when run ETL scripts that have worked before.
* D-13487: When Flows root and there was filter in Values expression, some flows were lost.
* D-13540: SqlDataFrame query with 300 columns failed to error "WithExpressionColumn: No name given for the new column".
* D-13429: Ordering in List aggregation couldn't find columns in dataframe query.
* D-13628: Statistical calculations were incorrectly not applied in chart CSV export.
* D-13406: Dataframe query with root FlowOccurrences and get value from cases caused error.
* D-13453: _model variable was not available for SqlExpressionValue filter rules.
* D-13538: There was incorrect handling of escaping characters in column names used in dimensions.
* D-13633: Ordering in List aggregation with null and empty values in dataframe query.
* D-13632: Going from variations to event types led to very poor performance with certain model.


== Latest Release: QPR ProcessAnalyzer 2023.2 (build 1478) (released 2023-03-22) ==
===Fixed issues===
* Listing scripts was slow when there were lot of script and operation logs. (D-14875)
* Error message returned from MCP tool call includes now actual exception message. (D-14870)
* Filtering Case and Event attribute profiling presets with decimal type of attributes didn't work in Snowflake models. (D-14866)
* Fixed issue where AI Agent did not provide any response for an eventlog with zero cases. (D-14835)
* Variation filter showed "undefined" in place of the variation order number when filtered variations were not in the eventlog. (D-14857)
* Improved error message in situation when model doesn't have the case or event attribute used by a chart filter. (D-14865)
* Improved model validation to detect when connection to the source tables in Snowflake is not valid. (D-14837)
* "Datatable with given name already exists in project" error message had localization missing. (D-14838)


'''Features:'''
===Other improvements===
* B-07755: [[Business_Calendar|Business calendar]] for duration calculation is available for Snowflake models.
* Frontend components have been updated. (B-09063)
* B-07719: In Snowflake dashboards, [[Big_Data_Chart#Using_measure_variables|measures can be assigned to variables]] and use the variables in other measures to create combined measures.
* B-07746: Changed in-memory conformance checking to not show invalid flow violations where starting or ending event type is invalid.
* B-07743: [[PA_Configuration_database_table#General_Settings|Default datasource]] can be configured for datatables created by scripts, allowing to set Snowflake as default.
* B-07740: System memory indicator moved from the header to User settings Version information dialog.
* B-07776: New SQL expressions functions Unicode, Char and Regexp, as a basis for future rule-based process mining.
* B-07741: Backend support for aggregation operations Median, Percentile, Stdev, Stdevp, Var and Varp to Snowflake.
* B-07742: Backend support for aggregation operation to list unique items in Snowflake.
* B-07770: Optimized Snowflake SQL generation by combining consecutive WithColumn function calls into one select.


'''Fixed issues:'''
==QPR ProcessAnalyzer 2026.3.1 (build 10941) (released 30.4.2026)==
* D-13491: QPR ProcessAnalyzer server crashed now and then when sorting was in progress and the query was cancelled.
* D-13380: Dimensioning integers in in-memory core calculation didn't work correctly as 0 and -1 were put to same bucket.
* D-13385: In Workspace Bin, Delete Forever and Restore from Bin buttons were misaligned.
* D-13332: Conformance checking didn't show in violations when there were multiple undesired events in same case.
* D-13405: Images take now always all available space in image component area.
* D-13417: KPI card without title was slightly misaligned vertically.
* D-13438: Clicking selected event type or flow in flowchart didn't cancel the filter selection.
* D-13350: Task log and Script log default filter end date is now empty by default.
* D-13381: Disabled browser auto-complete from flowchart variation stepper and Workspace create/rename object dialog.
* D-13347: Improved performance for in-memory business calendar calculation.
* D-13335: In in-memory chart, filtering didn't work in "Flow occurrences" root "Flow occurrences with specific event attribute value" dimension.
* D-13367: Percentage value wasn't displayed properly with German or Spanish language when event types were shown in object counts indicator.
* D-13451: Exported filter file is now named based on selected filter name.
* D-13378: In Big data chart, prevented error "Unable to aggregate from level RootCauses to level Custom".
* D-13293: DataFrame query with root Flows and IncludeEvents and ExcludeEvents filter rules failed.
* D-13370: Fixed issue where on-screen settings that didn't have any selectable items, showed a strange selection.
* D-13392: Clustering analysis was incorrectly shown when originally in-memory chart was converted into big data chart by changing chart json settings.
* D-12784: Some Snowflake queries incorrectly bypassed Snowflake caching because they used unique object names.
* D-13456: Improved error messages for incorrectly configured on-screen settings.
* D-13445: Conformance violations related translated terms have been fine-tuned for better translations into different languages.
* D-13421: Improved error messages when trying to use model having some column mappings missing.
* D-13485: Snowflake business calendar gave error when calendar contained Sunday.
* D-13218: Windows event viewer incorrectly contained log entries that are not errors.
* D-12634: Multiline text boxes width is set to non-changeable.
* D-13034: Confirmation dialog to delete items permanently has been updated.
* D-13288: In dialogs, the Create button didn't show the disabled state correctly.
* D-13427: When dropdown lists didn't have any selectable items, the "N/A" text appeared and the list incorrectly took more space vertically.
* D-13483: In Workspace, the new items menu was too narrow for Spanish texts.


== Additional release for QPR ProcessAnalyzer 2023.1 (build 1449) (released 2023-02-24) ==
===New features===
* MCP tools support [[Create_MCP_Tools#MCP_Tool_Settings|input parameters, structured output]], MCP metadata, and OAuth in Windows deployments. (B-09048)
* MCP supports [[PA_Configuration_database_table#:~:text=ClientCredentials|OAuth client credentials flow]], refresh tokens, and rate limiting. (B-09080)
* [[Data_Schema_Dialog|Data schemas]] consisting of datatables and relations can be visualized and modified using ER diagrams. (B-09023)


'''Features:'''
===Fixed issues===
* B-07690: System setting [[PA_Configuration_database_table#General_Settings|DatabaseId]] can be defined by administrator to get more simple table names in Snowflake.
* Business calendar related model properties could not be shown in chart settings. (D-14858)
* B-07737: In flowchart Bottlenecks preset, originally used flow colors has been recovered.
* Fixed unclear error when Snowflake connection string keys was removed when project was imported. (D-14833)
* B-07748: For Analyzed objects "Conformance checking findings" in charts, terminology has been revised and issue with the case count calculation fixed.
* B-07663: In [[Chart_On-screen_Settings|on-screen settings]], when case/event attribute is selected, related attribute values list are reset.
* B-07570: Backend support for [[Business_Calendar|business calendars]] in Snowflake.
* B-07660: Backend support for conformance checking to show also the last event index and event type in NotCompleted reason.
* B-07610: Memory counter related technical properties have been removed from expression language.


'''Fixed issues:'''
===Other improvements===
* D-13349: Opening dashboard containing Root causes preset with default settings jammed the system by generating lot of calculations (for more information, see previous release notes).
* Backend components have been updated. (B-09064)
* D-13277: Stacked charts with date type of data as series did incorrectly show gaps in columns/bars.
* D-13270: Flowchart conditional formatting didn't work with duration multi-unit format.
* D-13358: Calculation results caching works also across different user sessions.
* D-13250: Dashboard with two charts connected with linked settings using variables ended up to to a never ending loop.
* D-13230: SAP import did not automatically create columns to use the correct column types.
* D-12857: Deeply recursive functions caused a crash without any trace.
* D-12994: In Workspace, some buttons were not clickable due to breadcrumb covering them.
* D-13249: In Workspace, there was incorrect error message for duplicate datatable names when there were items with only letter capitalization was different.
* D-13232: In-memory chart Top variations preset is now sorted secondarily by average duration descending.
* D-13300: Setting DashboardFilter variable to empty value didn't have any effect in dashboard but old value was incorrectly used.
* D-12834: Limited the maximum number of dimensions to 20, to avoid too demanding queries for SQL Server.
* D-12917: Changed visual indication of missing items in dropdown lists (it's no longer showing "***").
* D-13111: In Root causes preset, there is now error message when trying to use weighting related columns when weighting isn't in use.
* D-13124: SQLDataFrame query containing filter rule EventTypes aggregating from cases failed.
* D-13207: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed.
* D-13292: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed (rev.2).
* D-12991: Dropdown list texts had some translations missing.


== QPR ProcessAnalyzer 2023.1 (build 1433) (released 2023-02-07) ==
==QPR ProcessAnalyzer 2026.3 (build 10933) (released 13.04.2026)==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2026_3.pdf QPR_ProcessAnalyzer_2026_3.pdf]
This release contains a potentially severe issue, where some dashboards completely jam the system by generating lot of calculations. The issue may appear in dashboards that have been created in earlier releases and containing the Root causes preset with default settings. The issue will be fixed by the next release. The issue can be worked around by exporting the affected dashboard, modifying the dashboard file manually and importing the dashboard back. The required modification is to remove line(s) containing <pre>"preset": "RootCauses"</pre> and the comma from the preceding line.
 
</div>
===New features===
* QPR ProcessAnalyzer acts as [[QPR_ProcessAnalyzer_as_MCP_Server|MCP server]] supporting MCP tools implemented using scripts with OAuth and API key authentication. (B-09004)
* [[Object-centric_Process_Mining_Model#Configure_object-centric_model|Units for each object type]] can be specified in object-centric models. (B-08992)
* [[PA_Configuration_database_table#:~:text=DefaultColorPalette|Charts color palette]] can be changed globally to easily manage consistent visual layout. (B-08993)
* [[External_Content|External content component]] url supports tags refering to dashboard variables to show dynamically changing web page. (B-08998)
* [[QPR_ProcessAnalyzer_Project_Workspace#Exporting_Project|Project export and import]] using files support public filters stored in models. (B-09007)
* [[QPR_ProcessAnalyzer_KPI_Card|KPI Card]] shows null value label when data has no rows, and table and chart show "No data" message. (B-08999)
* [[QPR_MEA_Integration|QPR MEA web service]] operations can be called using QPR ProcessAnalyzer expression language. (B-09030)
 
===Fixed issues===
* Flowchart had flows missing if shown flows were beyond the top-500 flows. (D-14848)
* Expression filter rules with greater/less than criteria were incorrectly applied as equal filters when editing chart filters. (D-14852)
* Table column filter dialog was not entire visible in narrow table located in the bottom of screen. (D-14783)
* Opening Scripts tab in Workspace was slow when there were scripts with long script log. (D-14670)
* Fixed issue where object-centric model queries sometimes gave inconsistent results. (D-14854)
* Snowflake query gave "invalid identifier" error when there were two measures with same cases going though event measure filter. (D-14845)
* Filter rules drag-and-drop didn't work between expressions in the same chart. (D-14850)
* Better error message is shown when invalid value is specified to dashboard aspect ratio flex, chart margin, dashboard margin, external content border width, or external content border corner radius. (D-14805)
* Improved error message when object-centric model perspective doesn't have the object type correctly defined. (D-14795)
* Reduced project properties dialog minimum height to fit for smaller screens. (D-14834)
* Updated NLTK to version 3.9.3. (D-14829)
 
* Frontend components have been updated. (B-09028)
* Backend components have been updated. (B-09027)
 
==Additional release for QPR ProcessAnalyzer 2026.2 (build 10910) (released 16.3.2026)==
 
===New features===
* Filters report in System reports shows also other users' private filters for admins. (B-09017)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===Fixed issues===
Following legacy analyses have been removed: Cases (analysis number: 5), Events (6), and EventTypes (7). This functionality may be in use in SQL scripts (in [[SQL_Scripting_Commands#--.23GetAnalysis|--#GetAnalysis]] command), and thus needs to be changed to the [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] command (see the [[RunQuery_Script_Examples|examples page]] how each legacy analysis can be replaced). Note that the legacy analyses removal don't affect the dashboarding functionality.
* Filter rules were lost when saving a filter with "Cases with specific events", "Cases starting with" or "Cases ending to" rules. (D-14847)
* Fixed issue where object-centric models sometimes gave "Object <cachetablename> does not exist or not authorized" error. (D-14797)
* ExtractSap function didn't work with QPR ScriptLauncher when using secret for storing SAP password. (D-14813)
* Variation stepper incorrectly skipped steps when going down when variation count is maximum. (D-14844)
* Improved error message when creating model from filter fails. (D-14811)
* System dashboard names were incorrectly translated twice. (D-14841)
* AI Assistant had one translation missing. (D-14840)


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts that use the removed analyses (and thus require migration):
==QPR ProcessAnalyzer 2026.2 (build 10897) (released 2026-02-26)==
<pre>
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2026_2.pdf QPR_ProcessAnalyzer_2026_2.pdf]
let removedAnalyses = [5, 6, 7];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;scr.code?.Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Starting from QPR ProcessAnalyzer 2023.1, the '''.NET Desktop Runtime''' is not needed anymore for QPR ProcessAnalyzer Server, so it can be uninstalled. Also for QPR ScriptLauncher, ''.NET Desktop Runtime'' is not needed, but instead install the '''.NET Runtime''' (which is more lightweight). ''.NET Desktop Runtime'' contains the ''.NET Runtime'', so the actions are not mandatory when updating to QPR ProcessAnalyzer 2023.1.
Snowflake user-defined functions (UDF) used by QPR ProcessAnalyzer have been updated to use Python 3.13. Some of the old versions of the functions use Python 3.9 which has been deprecated by Snowflake. Although the old versions are not anymore used by QPR ProcessAnalyzer, they are not automatically deleted and thus Snowflake may send notifications about existing deprecated functions. It's recommended to remove the old functions which are following:
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V2
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V3
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V4
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V5
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V6
* QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS
* QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS_V2
* QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS_V3
* QPRPA_UDF_BPMN_IS_CONFORMANT
* QPRPA_UDF_BPMN_IS_CONFORMANT_V2
* QPRPA_UDF_BPMN_IS_CONFORMANT_V3
* QPRPA_UDTF_CLUSTER
* QPRPA_UDTF_CLUSTER_V2
* QPRPA_UDTF_CLUSTER_V3
* QPRPA_UDTF_CLUSTER_V4
</div>
</div>


'''Features:'''
===New features===
* B-06997: Expression-based filter rules for Snowflake dashboards to allow versatile filtering and filtering from custom expressions.
* Fully conformant [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog|BPMN diagrams]] can be created from eventlogs with proper layout and identifying exclusive and parallel gateways. (B-08900)
* B-07383: Improvements to linked settings to allow binding to variables, tags and filter rules [[Chart_Linked_Settings|(more information)]].
* [[Object-Centric_Flowchart|Object-centric flowchart]] flows visibility can be controlled with a stepper based on top variations, and start and end symbols can be hidden for each event type. (B-08987)
* B-07508: Flowchart preset colors have been renewed to be more intuitive.
* Added preset for object-centric flowchart, and improved Process Discovery dashboard usage for object-centric models. (B-08863)
* B-07184: Automation preset in flowchart has now options for selecting the Automation attribute and value.
* Viewer users can [[Filtering_in_QPR_ProcessAnalyzer#Saving_filters|save private filters]] for personal use. (B-08920)
* B-07512: Changed datatable metadata can be refreshed from Snowflake, and all rows in the datatable can be deleted easily in Workspace [[QPR_ProcessAnalyzer_Project_Workspace#Datatables|(more information)]].
* [[Chart_On-screen_Settings|On-screen settings]] support static and dynamic case/event attribute values selection, and [[Chart_Linked_Settings|linked settings]] can bind to on-screen settings. (B-08814)
* B-07440: Date when the release was made is now shown in User settings.
* [[AI_Root_Causes|AI root causes analysis]] related error situations are easier to resolve with easier to understand error messages. (B-08997)
* B-07595: WeekOfYear property for DateTime objects in expression language to get the week number of a year (between 1 and 53).
* B-07623: In-memory expression language functions Random (to get random numbers) and Hash (to get hash value of string).
* B-07612: Breadcrumb in Workspace has now a Home button to quickly navigate to the top level of the projects hierarchy.
* B-07637: Language selector now shows the language options in local languages.
* B-07228: Remove following deprecated analyses: Cases, Events, and EventTypes (see the release note above).
* B-07538: Backend support: Snowflake root causes analysis can find event attribute related root causes.
* B-07706: Backend support: Snowflake expression-based filter rules support for roots containing Where function.
* B-07611: Removed following legacy filter rules: CaseAttributeTrend, EventAttributeTrend, EventTypeTrend, and Duration.
* B-07598: Refactored client-side import for SQL scripting to use generic client-side task mechanism.
* B-07716: ShortString columns are now properly detected in SQL Server queries.
* B-07652: Now it's possible to pipe multiline expression strings to QPR ScriptLauncher.
* B-07688: AddColumns function for Datatables to create multiple columns in one call.


'''Fixed issues:'''
===Fixed issues===
* D-13092: Table conditional formatting didn't work when color code was fetched from other column.
* Histogram chart did not show at all and gave a JavaScript error. (D-14801)
* D-13105: Some charts created in earlier release referring to non-existing presets names appeared as empty after software update.
* When chart with multiple series was sorted by measure, some datapoints were not shown when visible X-axis was limited by zooming or Custom layout settings. (D-14793)
* D-13107: Flowcharts crashed and showed loading animation forever when setting color or flow thickness to non-numerical measure.
* Disabled filter rules were incorrectly applied for the shown items in the filter rule editing dialog. (D-14791)
* D-13104: In BPMN model editor, context menus to edit elements didn't appear.
* If there were more than one Range filter components in dashboard, periods menu incorrectly affected all of them. (D-14818)
* D-12939: Script editor tabs Close buttons didn't work.
* List of event types in object-centric flowchart settings didn't open if there were object types linked to none events. (D-14798)
* D-13154: "Search by case ID" didn't work in in-memory chart.
* Snowflake flowchart root causes analysis gave "SQL compilation error" when run with case duration criteria. (D-14790)
* D-12933: CSV columns with only empty values were incorrectly auto-detected as integers.
* Term "Second" when meaning time unit was translated incorrectly in French. (D-14803)
* D-12929: In-memory chart Root causes for case duration and Root causes for case attributes (weighted) had Custom expression missing.
* OpenTelemetry metrics were not sent to Prometheus correctly. (D-14804)
* D-12928: Pivot table headers were empty when there were two column levels and two values.
* Opening script editor by url didn't show project path and also javascript error appeared to console. (D-14794)
* D-12924: Pivot table columns with Count and Distinct Count aggregations are now numeric and aligned right.
* Fixed issue where case attribute prediction failed when using more than one iteration. (D-14789)
* D-13033: Changing colors in chart settings Color palette caused "Item already exists" error and prevented changing colors.
* SQLDataFrame with several append operations had performance issue. (D-14772)
* D-12996: Tags referring to dashboard variables didn't work in Additional root expression.
* Null coalescing operators didn't work correctly in chaining in expression language. (D-14762)
* D-12877: UI gave error in some situations: Uncaught TypeError: Cannot read properties of undefined (reading 'min').
* Native app could not call procedure if project referred to other database and schema. (D-14749)
* D-13071: Prevented selecting two or more of the Y-axis, X-axis and series mappings at the same time for the same measure or dimension.
* Trying to create script with duplicate name gave unclear error: Cannot insert duplicate key row in object 'dbo.PA_SCRIPT' with unique index 'PA_SCRIPT_UNIQUE_NAME_IN_PROJECT'. (D-14784)
* D-12895: Big data chart crashed when on-screen setting contained event type selector and there were no event type filter set.
* BPMN editor popup menu was partly hidden behind other chart components. (D-14345)
* D-13231: Tooltips for dashboard name, model selector and filter selector in header show now the content text instead of generic instruction.
* When going to context menu report from BPMN editor, "Operation was cancelled by a user" was given when query was in progress. (D-14807)
* D-13139: There was an error when tried to create filter for a custom expression where selected data type didn't match with the actual type of data.
* BPMN editor tooltips measure descriptions didn't disappear at all. (D-14809)
* D-12988: Chart presets selection in chart settings showed unnecessary tooltip.
* Presets benchmarking didn't work for models without case attributes. (D-14822)
* D-12901: When set sampling over 1 million, Snowflake models gave error: parameter value out of range: size of fixed sample. Must be between 0 and 1,000,000.
* Object-centric filter rule editor gave javascript error when opened for case-centric model. (D-14799)
* D-12904: Creating expression filter having lower/greater logic with root objects sampling failed.
* Object-centric filter rule could incorrectly be dropped as root causes comparison rule. (D-14796)
* D-12923: Chart schema didn't accept pivotAggregation in dimensions/columns.
* Localization missing for "Save as new filter" button. (D-14839)
* D-12926: Root causes columns Selected weight, Compared weight and Total weight have now correct float data type.
* D-12880: In out-of-the box dashboards, chart titles and subtitles were not translated.
* D-12916: Improved filter rule description text in Filter rule editor dialog for expression filter rules.
* D-12889: No clear error message was given when user tried to export corrupted model from .pacm file.
* D-12869: Date selector in on-screen settings had inconsistent vertical alignment.
* D-12938: When creating a filter with lasso and selecting a single data point only, "equals" kind of filter rule is now created.
* D-12989: "Running tasks as specific time" system report may have ended up in loop causing following error: Maximum call stack size exceeded error.
* D-13010: Pivot table sometimes ended up to never-ending resizing loop when browser zoom was more than 100%.
* D-12790: Expression language: DataFrame.SetColumns: Initializing and using variables defined in closure of SetColumns function parameter didn't work
* D-12927: All on-screen settings were not be visible in narrow charts having several on-screen settings.
* D-12937: Added maximum value limitation to several number input fields in charts.
* D-12947: Message dialog didn't show line breaks correctly (e.g., in CSV file import).
* D-12948: Defining column setting caused error when Measure Expression was not defined.
* D-12946: Filter rule text couldn't be seen entirely from tooltip.
* D-12983: When range filtering using integer values in Highcharts chart, filter is now shown as integer value.
* D-12984: When range filtering in Highcharts charts and there is category axis, filter rule is now based on individual (category) values.
* D-12930: When creating filters from charts using date type of X-axis with lasso, "greater than or equal" and "less than or equal" filter rules are not created.
* D-12920: "Where" function in DataFrame lost column data types of the original DataFrame.
* D-13048: Model notifications failed with certain measures that define variables in root expression leading to error: Variable "sampleSize" already exists in this context.
* D-13116: BPMN editor had some translations missing.
* D-13019: Datatable and script selectors show now datatable/script name instead of id, when opening selector having existing selections.
* D-12951: Changing additional root expression in flowchart didn't refresh the flowchart.
* D-13147: Filter rule boxes in header had different widths, and Add filter rule button vertical alignment was incorrect.
* D-12907: Sometimes case attribute selection showed incorrect attribute name for empty model.
* D-13148: Filters and Datatables system reports loaded unnecessarily twice which could be seen as blinking.
* D-12844: In dataframe query, FlowOccurrences in root and GetValueFrom Cases with filter gave null reference exception
* D-12915: Repeating certain query twice with aggregations in Events root generated invalid SQL
* D-12728: Was huge amount logs in server during client side import (manual testing required as identification)
* D-13156: Persist function failed to snowflake: Invalid unicode escape sequence '\u0027ACCE'; should be at most '\u0010FFFF'.
* D-12876: Flows/FlowOccurrences in root didn't work with SqlExpressionValue filtering.


== Additional release for QPR ProcessAnalyzer 2022.8 (build 1397) (released 2023-01-11) ==
===Other improvements===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* SQL queries run in Snowflake have been further optimized. (B-08936)
This release fixes an issue where extracting large datasets from SAP increases memory consumption considerably and may lead to out-of-memory error. This release contains packages for both QPR ScriptLauncher and QPR ProcessAnalyzer Server. If SAP extractions are done using QPR ScriptLauncher in client side mode (ExecuteInClientSide=1), it's enough to update QPR ScriptLauncher to fix this issue.
* Snowflake stored procedures and user defined functions have been migrated to Python 3.13. (B-08984)
</div>
* Frontend components have been updated. (B-08991)
* Backend components have been updated. (B-08990)


'''Fixed issues:'''
==QPR ProcessAnalyzer 2026.1 (build 10870) (released 2026-01-19)==
* D-12941: Extracting data from SAP consumed unnecessary lot of memory and may have led to out-of-memory error (both when running using QPR ScriptLauncher and in server side).
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2026_1.pdf QPR_ProcessAnalyzer_2026_1.pdf]


== QPR ProcessAnalyzer 2022.8 (build 1396) (released 2022-12-30) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Creating datatables with duplicate names in the same project is prevented, and possible existing duplicate names are automatically changed to unique names with a random suffix. If there are duplicate names, they can be renamed either before updating QPR ProcessAnalyzer (to avoid automatic renaming) or after the update (by changing suffixed names). If the renamed datatables are used by models, the linkage will break because it's based on the datatable name. Creating duplicate datatables has already been prevented in the UI, but the improved method works also in the API level.
QPR ProcessAnalyzer Server and QPR ScriptLauncher are running on .NET 10, replacing the previous .NET 8 version. When updating to this release, make sure to install the .NET 10 Runtime ([[Updating_QPR_ProcessAnalyzer_Server|update instructions]]). While .NET 8 and .NET 10 can run side by side, .NET 8 does not need to be removed immediately. However, for security reasons, any unused .NET 8 installation should be uninstalled as soon as possible after the update.
 
Following SQL query can be used to list datatables (and project id) having duplicate names:
SELECT ITA_NAME, ITA_PROJECT_ID
FROM PA_INTEGRATION_TABLE
GROUP BY ITA_NAME, ITA_PROJECT_ID
HAVING Count(*) > 1
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
If trying to use business calendar for a model that doesn't have the business calendar defined, there will now be an error message instead of showing the chart. Either unselect the business calendar checkbox for the measure or dimension, or define a business calendar to the model. In this situation in earlier releases the business calendar was ignored and full time calculation used.
Known issue: The histogram visualization doesn't work in this release. The issue will be fixed in the next release. Possible workaround is to use the column chart where to set no spacing between columns. This can be configured with the following [[QPR_ProcessAnalyzer_Chart#:~:text=Custom%20Layout|Custom Layout]] settings:
<pre>
{
"plotOptions": {
"series": {
"pointPadding": 0,
"groupPadding": 0
}
}
}
</pre>
</div>
</div>


'''Features:'''
===New features===
* B-07498: Automation and Operational Excellence presets and Root causes analysis (for Snowflake), Weighted root causes analysis and Event scattering preset (for Snowflake and in-memory), Root causes for case duration (in-memory).
*Object-centric models support versatile [[Filtering_in_QPR_ProcessAnalyzer|object-centric filters]] based on case-centric filter rules using perspective. (B-08595)
* B-07177: Flexible mappings, user selectable aggregations and conditional formatting for Pivot table, and flexible mappings for KPI Card.
*[[AI_Root_Causes|AI Root Causes analysis]] is shown in a hierarchy for easier readability. (B-08921)
* B-07518: New function named Query to run call /api/expression/query.
*[[Process_Flowchart|Case-centric flowchart]] performance has been improved by making all queries simultaneously. (B-08916)
* B-07294: In Workspace, the left side projects hierarchy can be collapsed and expanded to make more space to project contents.
* Object counts indicator is hidden for object-centric models when perspective is not set. (B-08825)
* B-06814: In SQL expressions, new function DurationBetweenDates to calculate duration between timestamps precisely.
* B-07519: Replaced DateDiff function with the new DurationBetweenDates function in big data chart.
* B-07531: In SQL expressions, new mathematical functions Abs, Log, Mod, Power, Rand, Sign and Sqrt.
* B-07297: To optimize performance, Snowflake queries are automatically cancelled if they are not needed by UI.
* B-07569: To optimize performance, TakeSample function implementation is improved for Snowflake.
* B-07198: Several performance improvements to DataFrame queries (used in Snowflake).
* B-07464: Added Lead and Lag functions to SqlDataFrames to support getting previous and next event.
* B-07470: New ExtractSap function to fetch data from SAP using expression language.
* B-07536: New Pivot function to SqlDataFrames to enable root causes analysis.
* B-07488: Primary keys can be set to datatables to improve calculation performance (UI will follow later).
* B-07515: Added RootCauseAnalysis function to SqlDataFrames.
* B-07546: RootCauseAnalysis function support for complex weighting expressions.
* B-03052: Support for user-defined variables in /api/expression/query.
* B-07565: Support for NumberPrecision, DatetimeTruncation and TimespanPrecision properties for Values section in in-memory query.
* B-07513: For product activation file handling, replaced mutex based implementation with exclusive file lock.
* B-07480: Expression language support for DataFlows for data extraction.
* B-07613: Removed support for SQL Server based R scripting.
* B-07567: Take datatable primary keys into use in expression builder to improve performance (part 2).
* B-07588: Remove total memory information from log writing and DateDiff function for in-memory.


'''Fixed issues:'''
===Fixed issues===
* D-12715: Snowflake calculated imprecisely some operations containing division and aggregation.
* Filter to exclude case attribute values incorrectly excluded null values even if null wasn't selected. (D-14773)
* D-12761: Progress bar of the CSV import dialog didn't show any progress.
*Prediction generated invalid models where case IDs in events datatable didn't exist in cases datatable. (D-14758)
* D-12799: Opening datatable contents dialog settings was slow when there were lot of rows in the datatable.
* AI Root Causes presets didn't work with models without case attributes. (D-14759)
* D-12089: Include conforming/nonconforming cases made BPMN editor no responding.
* Snowflake query with multiple columns with aggregations and Coalesce function gave "invalid identifier" error. (D-14763)
* D-12496: Datagrid filter search keyword didn't work for rounded values, so the search was hidden for other than textual data.
*Dropdown list to add business calendar holidays from other model shows empty items. (D-14786)
* D-12704: Durations as quarters was calculated incorrectly in charts.
*In-memory Average function didn't work when aggregating dates using model's Attribute function. (D-14761)
* D-12662: Fixed issue where some special literals in custom expressions didn't work.
*Sometimes opening models list gave error "User doesn't have permission GenericRead to model". (D-14742)
* D-12403: Setting Notifications on a model had some visual issues.
* D-12859: Dependency wheel visualization crashed with nulls values in From and To mappings.
* D-12660: Removed unnecessary float conversions in SQL expressions.
* D-12653: In-memory datafram OrderByColumns function with mixed values failed.
* D-12657: When trying to use milliseconds period in some presets, frontend frozed.
* D-12706: Line breaks in data were shown in many places where it's undesired.
* D-12719: Syncfusion dialog headers showed backslaces incorrectly.
* D-12372: Refused to run the JavaScript URL because it violated the Content Security Policy directive.
* D-12730: Logging out when filter selection is in progress, gave javascript error.
* D-12705: Header object counts tooltip was sometimes messed after logout.
* D-12384: Selected project was not highlighted for whole project name string.
* D-12581: Prevented creating duplicate datatable names in same project in parallel execution.
* D-12722: There was incorrect syntax near '<' when running SqlDataFrame expressions.
* D-12736: Swedish and Finnish translation improvements for object counter tooltips.
* D-12702: For BPMN Editor component "Something went wrong" error was given when switching from in-memory to Snowflake model.
* D-12712: UI gave error: TypeError: Cannot read properties of undefined (reading 'id').
* D-12738: Business calendar showed total business time when calendar configuration was invalid.
* D-12776: Special character filter caused JavaScript SyntaxError.
* D-12785: Unnecessary vertical scrollbar displayed for main header toolbar.
* D-12164: There was unnecessary UnauthorizedAccess errors in logs.
* D-12580: Case duration was not same when comparing Big data chart with in-memory chart for same data.
* D-12768: Data grid links and variable change actions didn't work when grouping was used.
* D-12735: FindRootCauses (in-memory) function filtered out cases with zero contribution.
* D-12763: --#CallWebService didn't work from ScriptLauncher.
* D-12789: There was timeout in SQL queries to scripting sandbox.


== QPR ProcessAnalyzer 2022.7 (build 1331) (released 2022-11-15) ==
===Other improvements===  
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
*[[QPR_ProcessAnalyzer_Security_Hardening#Added_HTTP_Headers|Content-security-policy]] img-src blob: directive has been restored for Highcharts image export. (B-08904)
Starting from QPR ProcessAnalyzer 2022.7, to improve security expression language operations that modify data or connect to external datasources are prevented in dashboard custom expressions. The limitation is required, because when a dashboard is opened, its expressions are run with the user's permissions, and the user need to trust the expressions don't perform any unexpected operations, such as delete data. The full functionality of the expression language is available in the scripts and in the Expression Designer.
*Backend components have been updated [[Updating_QPR_ProcessAnalyzer_Server|including .NET 10]]. (B-08926)
*Frontend components have been updated. (B-08927)


The following functions and operations are prevented in dashboards: SendEmail(), CallWebService(), ImportOdbc(), ImportOdbcSecure(), Model.DeletePermanently(), Model.Restore(), Model.TriggerNotifications(), Project.DeletePermanently(), Project.Restore(), Project.CreateDatatable(), Datatable.AddColumn(), Datatable.DeletePermanently(), Datatable.Import(), Datatable.Merge(), Datatable.RemoveColumns(), Datatable.RenameColumns(), Datatable.Truncate(), RecycleBin.DeletePermanently(), and call SQL script. Calling expression scripts is allowed, but in the script all previously mentioned operations are prevented.
==Additional release for QPR ProcessAnalyzer 2025.7 (build 10845) (released 2025-12-11)==


Following SQL query can be executed in the QPR ProcessAnalyzer metadata database to reveal dashboards that potentially have prevented expressions:
===New features===
SELECT * FROM [PA_UI_ELEMENT] WHERE [UIE_PROPERTIES] LIKE '%SendEmail(%' OR [UIE_PROPERTIES] LIKE '%CallWebService(%' OR [UIE_PROPERTIES] LIKE '%ImportOdbc(%' OR [UIE_PROPERTIES] LIKE '%ImportOdbcSecure(%' OR [UIE_PROPERTIES] LIKE '%DeletePermanently(%' OR [UIE_PROPERTIES] LIKE '%Restore(%' OR [UIE_PROPERTIES] LIKE '%TriggerNotifications(%' OR [UIE_PROPERTIES] LIKE '%CreateDatatable(%' OR [UIE_PROPERTIES] LIKE '%AddColumn(%' OR [UIE_PROPERTIES] LIKE '%DeletePermanently(%' OR [UIE_PROPERTIES] LIKE '%Import(%' OR [UIE_PROPERTIES] LIKE '%Merge(%' OR [UIE_PROPERTIES] LIKE '%RemoveColumns(%' OR [UIE_PROPERTIES] LIKE '%RenameColumns(%'
*QPR ProcessAnalyzer can be deployed on-premise using [[Deploy_QPR_ProcessAnalyzer_from_Container|Linux containers]]. (B-08915)
</div>
*Snowflake SQL queries have been simplified to improve performance, e.g., when quering flows. (B-08901)


'''Features:'''
===Fixed issues===
* B-07287: Process Discovery and most important presets for Snowflake.
*ODBC and Loading script models, and models with calculated attributes didn't allow to create or modify case and event attribute filters from header. (D-14751)
* B-07271: "Last Row Aggregates Over-limit Rows" setting for big data chart.
*Fixed incompatibility issue when using Keycloak as identity provider for SAML authentication. (D-14757)
* B-06431: Snowflake datatables support for database views in the datasource.
*System report for users incorrectly listed some users with read-only permissions as Developers (issue with the EffectivePermissionTypesFor function). (D-14748)
* B-07266: Security: "limited mode" to prevent data modifications and external calls from dashboard expressions.
*Referrer-Policy HTTP header was incorrectly set to "same-origins" causing browser console error in Windows deployments. (D-14736)
* B-07097: Improved flowchart root causes color scales.
*Fixed issue where QPR ProcessAnalyzer request ID was not added to Snowflake data modification queries. (D-14728)
* B-07363: SQL LIKE function support for escape character.
*Login request duration was incorrectly shown as zero or negative in System reports. (D-14737)
* B-06877: Improved variation queries performance in Snowflake, part 1.
*In chart settings, some Snowflake measures with aggregations were missing possibility to define percentile value. (D-14276)
* B-07444: Improved variation queries performance in Snowflake, part 2.
*Fixed issue where it was not possible to delete a model with same name in the same project during the same session. (D-14708)
* B-07382: Support for empty strings and nulls in event type names in dataframe processing.
*Script editor to specific script can now be opened with a direct url containing the script_editor parameter. (D-14745)
* B-07273: WithRowNumberColumn, WithRankColumn, WithDenseRankColumn support for descending sorting.
*Fixed issue were sometimes an incorrect error code was given for a cancelled query. (D-14755)
* B-07303: FindRootCauses function support for weighting expression.
*Improved error message if model loading fails when loading script returns incorrect type of data. (D-14637)
* B-07327: Unpivot function for SqlDataFrames (for root cause analysis).
*Fixed issue where variations query with sampling was slow for new models. (D-14729)
* B-07385: Align token lifetime with SESSION_MAXIMUM_DURATION setting.
*Added tooltip to gantt chart's table layout header so that the header text can be fully seen. (D-13748)
* B-07500: ColumnMappings property for IDataFrame and DataTables.
*Switching between Snowflake and in-memory chart by adjusting chart configuration json caused some items in chart settings to appear twice. (D-14667)
* B-07499: IDataFrame.ApplyFilter function to filter events data using a JSON-based filter.
*Selecting model in dashboard when previously there was no model selected and going back to Workspace, gave error message. (D-14735)
* B-07469: Translation updates for release 2022.7.
*Query Designer gave untranslated error message: "You don't have permissions to model ...". (D-14727)
*Query Designer gave untranslated error message "Unable to use Snowflake tables as data source for in-memory query". (D-14683)
*In Query Designer, table column menu gave JavaScript error for columns where first row was null. (D-14684)
*Query Designer incorrectly gave message "There are no columns in the data" when the data had no rows. (D-14692)
*Fixed issue in Manage Users dialog where row selections disappeared when resizing the dialog. (D-14647)


'''Fixed issues:'''
==QPR ProcessAnalyzer 2025.7 (build 10821) (released 2025-11-13)==
* D-11630: Drag and drop from chart settings to main header was working incorrectly for filter and root cause rules.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_7.pdf QPR_ProcessAnalyzer_2025_7.pdf]
* D-12455: Moving a chart filter from one chart to another created a root cause analysis filter.
* D-12266: Root causes analysis showed incorrect results when certain combination of filters.
* D-12525: Numerical values in Excel export in data grid was formatted incorrectly.
* D-12534: Restoring item from recycle bin changed project from Bin to previous project.
* D-12529: Measure specific datalabel mapping did not work correctly when also mapped to Y-axis.
* D-12532: Multi-selection options caused layout issue for Chart setting.
* D-12541: Layout issue for Polish in multiselect list search dialog.
* D-11277: Increase/decrease Icons were missing in the dimension sorting for Mac.
* D-12552: Uncaught Error: Diagram.selectCollection given something that is not a Part: null.
* D-12567: Tooltip incorrectly showed for label component containing only spaces.
* D-12438: Operation was cancelled because it was replaced by a new operation.
* D-12551: Some expressions didn't work as calculated case/event attributes.
* D-11720: Chart buttons were not visible in Apple Safari and iPad.
* D-12544: On-screen settings "options" parameter did not work.
* D-12528: Multi-unit time unit selection appeared where it's not applicable.
* D-12583: Error message should be provided for invalid settings input  than just  display JS errors.
* D-12599: Tooltips didn't show correct measures/dimensions when "Show in tooltip" mappings are used.
* D-12561: Chart settings content was incorrectly drawn outside of the chart dialog.
* D-12568: Reload UI sometimes crashed chart having multiselect on-screen settings.
* D-12572: Main header toolbar lost when refresh maximized PA chart.
* D-12612: Drop Unused Filters After setting incorrectly allowed zero seconds.
* D-12533: Error message keeped blinking in Analysis view.
* D-12608: User could not select or add new case attribute when current select attribute doesn't exist.
* D-12451: Prevented deleting running script.
* D-12516: Windows event viewer warning: Failed to gracefully shutdown application.
* D-12523: Business calendar performance - part 2.
* D-12538: Column with same name could be added multiple times to datatable using expression language.
* D-12582: Improved EMS mutex code to support multiple PA service in one server.
* D-12624: Synchronize new (empty) data table generated failed queries in Snowflake.
* D-12622: Advanced setting page reserved room for the expression editor frame that did not exist.
* D-11295: In on-screen settings, some UI controls were vertically misaligned.
* D-11625: The heights of the parameter option menu in the clustering tab was not well aligned.
* D-12103: Small dropdown list layout issue.
* D-12633: Align issue for Column related Advanced settings.
* D-12505: Search dialog didn't escape % and _ characters correctly in dataframe processing.
* D-12645: Tabs in expression settings dialog were partly hidden when dialog is narrow.
* D-11382: Moving of flowchart was sometimes shaky.
* D-12655: Filter rule tooltips in header were styled incorrectly.
* D-12656: Large integer values in filter jsons were incorrectly presented as small integers.
* D-12661: Some exported filters contained unnecessary "invert" property.
* D-12500: Model with numeric case id's and filtering with the attribute mapped as case id: ERROR [22018] Numeric value <nowiki>''</nowiki> is not recognized.
* D-12509: Filtering null values didn't work in boolean attributes in Snowflake.
* D-12571: In dataframe processing in SQL Server, dividing two integers should not make rounding to integer.
* D-12610: Setting for global DropUnusedFiltersAfter was missing.
* D-12613: Filtering with case/event attributes with null values didn't match in Snowflake models.
* D-12617: Model didn't work when DropUnusedFiltersAfter is 00:00:00.
* D-12618: If model ConfigurationJson is null, Configuration property didn't work.
* D-12620: Filtering didn't work when there are backslaces in attribute names in Snowflake models.
* D-12643: AttributeFunctionCallExpression did not always work properly in array context.
* D-12647: SqlDataFrame with SQL Server: Comparing literals to variant column values failed.
* D-12648: Models that have DropUnusedModelsAfter setting caused "The sliding expiration value must be positive" error.
* D-11526: It was unable to translate Unicode character \uD83D at index 176 to specified code page.
* D-12637: In application startup arised FATAL Application startup exception System.UnauthorizedAccessException: Access to the path 'Global\MutexQPRPAActivation' is denied.


== Additional release for QPR ProcessAnalyzer 2022.6 (build 1262) (released 2022-10-19) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Known issue: Creating case and event attribute filters in dashboards is not possible from the main header for the following types of in-memory models and attributes:
*Any attributes for [[QPR_ProcessAnalyzer_Model_Datasources#ODBC_Datasource|ODBC loaded models]]
*Any attributes for [[QPR_ProcessAnalyzer_Model_Datasources#Loading_Script|Loading script models]]
*Calculated attributes in any in-memory models.


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Workaround is to create the filter rule in a chart's settings and drag-and-drop it to the header. The issue has been fixed by the next release (D-14751). The issue does not concern Snowflake models.
This release contains fixes to following major issues:
* Older QPR ScriptLauncher versions (<=2022.5) don't work with this release, when using the client side import. As a workaround, if updating to QPR ProcessAnalyzer 2022.6, also update QPR ScriptLauncher. Hotfix will be released to recover the backwards compatibility.
* When pressing the Add measure/Add dimension button in the chart settings, the chart settings dialog stop working. The workaround is to add the new measure/dimension to the bottom and use the Move up button to get the desired order of measures/dimensions. This issue will also be fixed in the hotfix.
* ETL scripts run using QPR ScriptLauncher in the client side import mode don't work if there is an import operation taking more than 10 minutes. This is because during the import, QPR ScriptLauncher erroneusly doesn't send the heartbeats to QPR ProcessAnalyzer Server, which then stops the script, believing QPR ScriptLauncher has stopped working. This issue occurs in all QPR ScriptLauncher versions. This issue will be fixed to QPR ProcessAnalyzer Server in the hotfix (i.e., no need to update ScriptLauncher).
</div>
</div>


'''Fixed issues:'''
===New features ===
* D-12586: Scripts using client-side import with older version of QPR ScriptLauncher didn't work.
*Presets added for [[AI_Root_Causes|AI Root Causes analysis]] based on Snowflake Top Insights which is a decision tree model finding combinations of root cause contributors. (B-08889)
* D-12597: QPR ScriptLauncher was not sending heartbeats during import, which might have stopped the script prematurely.
*Added new [[Range_Filter|filter selector]] component to dashboards to easily create date and number range filters. (B-08877)
* D-12589: Pressing Add measure/Add dimension button crashed chart.
*Projects can be browsed in the [[Navigation_Menu|navigation menu]] to access all dashboards, and also organized the menu into two columns. (B-08708)
* D-12558: In chart settings, setting expression to "(none)" gave error.
*When QPR ProcessAnalyzer is [[Embed_to_Website|embedded to a website]], SAML authentication is performed in a separate window for more robust operation. (B-08871)
*For more flexible options, [[AI_Agent|AI Agents]] runs the language model query using the Snowflake account where the selected model is located. (B-08860)


== QPR ProcessAnalyzer 2022.6 (build 1259) (released 2022-10-05) ==
===Fixed issues===
*If DefaultUiLanguage in PA_CONFIGURATION table was not defined, users who haven't changed language could not login. (D-14706)
*Improved performance in opening dashboard. (D-14705)
* Snowflake Native App didn't show the version number and build timestamp correctly. (D-14703)
*Snowflake Native App activation failed with a custom compute pool if container service was in the suspended state. (D-14722)
*Server stuck when trying to generate SQL for SqlDataFrame having multiple columns with the same name. (D-14730)
*In eventlog prediction, fixed issues preventing the usage of case attribute value prediction. (D-14702)
*Snowflake DurationBetweenDates function calculated incorrectly when used in a in divisor. (D-14723)
* Import now succeeds when importing Snowflake datatables refering to data without access. (D-14694)
*Fixed incorrect color in table column filters, and Workspace loading time has been improved. (D-14704)
* Fixed issue where dropdown list with projects showed "undefined" in place of project id. (D-14659)
*Fixed issue where specifying a secret name longer than 440 characters, prevented saving the secret and resulted in an error. (D-14674)
* SAML authentication failed when it needed to create a new user to QPR ProcessAnalyzer. (D-14717)
* Fixed issue where SQL dataframe queries didn't work if the root expression ended to a semicolon. (D-14714)
*Specific Snowflake query with a comparison criteria, AggregateFrom and GetValueFrom functions gave error about invalid identifier. (D-14718)
 
===Other improvements===
*[[QPR_ProcessAnalyzer_Security_Hardening#HTTP_Response_Headers|Content-Security-Policy HTTP header]] has been reduced to more secure by removing the script-src 'unsafe-eval' and img-src 'blob' directives. (B-08897)
*Added [[QPR_ProcessAnalyzer_Security_Hardening#HTTP_Response_Headers|security related HTTP headers]]: X-Permitted-Cross-Domain-Policies, Cross-Origin-Embedder-Policy, Cross-Origin-Opener-Policy, Cross-Origin-Resource-Policy, Referrer-Policy, and Permissions-Policy. (B-08879)
*Implemented backend support for Snowflake Top Insights for [[SqlDataFrame_in_Expression_Language#:~:text=TopInsights|AI root causes analysis]]. (B-08664)
*Implemented improved error handling when trying to save too long text to database. (B-08892)
*For more understandable error messages, error handling and error message generation have been refactored. (B-08754)
*Optimized database queries and reduced log writing. (B-08870)
*Frontend components have been updated. (B-08899)
*Backend components have been updated. (B-08898)
 
==QPR ProcessAnalyzer 2025.6 (build 10690) (released 2025-10-01)==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_6.pdf QPR_ProcessAnalyzer_2025_6.pdf]


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
QPR ProcessAnalyzer Server and QPR ScriptLauncher use now .NET 6 (instead of legacy .NET Framework). The hardware requirements are same, but the .NET 6 Runtime needs to be installed to machines running QPR ProcessAnalyzer Server and QPR ScriptLauncher. See more on the [[Updating_QPR_ProcessAnalyzer_Server|updating QPR ProcessAnalyzer]] instructions. Note that the IIS deployment script is not available anymore. QPR ScriptLauncher update is not mandatory (i.e., .Net Framework based QPR ScriptLauncher works with the .Net 6 based QPR ProcessAnalyzer Server), but update is recommended due to bug fixes made to the QPR ScriptLauncher.
Known issue: If the [[PA_Configuration_database_table#:~:text=DefaultUiLanguage|DefaultUiLanguage]] system configuration is not defined, users who haven't changed their own language, are unable to login. To prevent this problem, please ensure the DefaultUiLanguage is defined. The next release has fixed this issue (D-14706).
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Following legacy analyses have been removed: Flowchart (analysis number: 0), Variations (8), Duration (9), Profiling (10), and Flows (13). This functionality may have been used in the SQL scripts. Note that this change doesn't affect the functionality available in the QPR ProcessAnalyzer web UI.
Content-Security-Policy (CSP) HTTP header has been updated to enhance security by implementing more restrictive settings. The following directives have been added:
*object-src 'none'
*frame-ancestors 'self'
*form-action 'none'
*base-uri 'none'
*worker-src blob:


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts in the system that likely use the removed analyses:
These new restrictions may affect usage that has previously been possible. For example, with the new settings, QPR ProcessAnalyzer can be embedded to a website only within the same origin. For detailed instructions on embedding QPR ProcessAnalyzer on a different website, please refer to [[Embed_to_Website|this quide]]. Additionally, for information on modifying the CSP settings, see documentation for [[QPR_ProcessAnalyzer_Security_Hardening#HTTP_Response_Headers|security hardening]].
<pre>
</div>
let removedAnalyses = Flatten([0,8,9,10,13].(["'AnalysisType','" + _ + "')", "'AnalysisType', '" + _ + "')"]));
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.{let num=_;scr.code?.Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
In the QPR ProcessAnalyzer 2025.6 Native App, the release version number is not displayed correctly in the User Settings dialog. This omission does not have any other complications. QPR ProcessAnalyzer 2025.6 is the only release with this issue, making it possible to identify this release despite the missing version number. This issue is specific to the Native App only. The next release has fixed this issue (D-14703).
</div>
</div>


'''Features:'''
===New features===
* B-06524: Search dialog for finding and selecting multi-select items.
*[[User_Settings#Starting_dashboard|Starting dashboard]] after login can be defined for user groups, allowing to create customized starting pages for easy navigation. (B-08791)
* B-07173: CSV file importing supports date columns for row matching.
*Snowflake [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|chart's event filters]] are now embedded to filters created from chart, to precisely follow chart calculation. (B-08845)
* B-07277: Query timeout for dashboards.
*Result data can be filtered in Snowflake charts using [[QPR_ProcessAnalyzer_Chart#:~:text=Result%20filtering%20expression|result filtering expression]] which works for any datasets. (B-08751)
* B-06921: Expression language: For loop.
*Filter rules order now stays the same when making filter selections and confirming filter. (B-08801)
* B-07307: Expression language: DataTable.Synchronize().
*Added model setting [[QPR_ProcessAnalyzer_Project_Workspace#Hiding_Object_Count_Statistics|Show object count statistics]] to hide object counts information in dropdown lists to optimize performance. (B-08849)
* B-07288: SQL expression functions ToLower and ToUpper.
*Added support for [[Chart_On-screen_Settings#:~:text=showStatistics|hiding statistics for on-screen setting]] dropdown lists to improve performance, and in addition the case ID is hidden Case/Event attribute profiling presets. (B-08840)
* B-07335: Expression language: Datatable.NameInDataSource-property.
*Added following audit fields to users and groups: Created date, Created by, Last modified date, and Last modified by. (B-08792)
* B-07336: ScriptLauncher client side import heartbeat.
*Snowflake Native App: Added procedure to that [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Recover_administrator_access|creates administrator user to Native App]] if access to the app has been lost. Also, prevented user management operations that remove own access. (B-08733)
* B-07176: Dataframe queries run in SQL Server are stopped when operation is cancelled.
*Snowflake Native App: Added procedure to [[Change_Native_App_Compute_Pool_Size|change Native App compute pool size]]. Changed new Native Apps to use CPU_X64_S size compute pool, and improved Native App stability. (B-08859)
* B-06986: Support for AggregateOthers setting in dataframe processing.
 
* B-07342: Improved validation for dashboard import.
===Fixed issues===
* B-07267: Support for Comparison parameter in SQLExpression filter rule.
*Snowflake Cortex based AI Assistant didn't show the results table. (D-14643)
* B-06533: Timeout to /api/expression/query.
*When percent stacking is used, Y-axis values are now shown as percentages in data label and tooltip. (D-14633)
* B-07208: Remove deprecated analyses (part 2).
*Fixed issue where Label&Link component had sometimes unnecessary vertical scrollbar. (D-14685)
* B-07295: Frontend components update.
*Model validation showed incorrect error message for models with numeric duplicate case ID's. (D-14687)
* B-07290: Translation updates for release 2022.6.
*In Workspace, scripts "View current run log" dialog didn't update log correctly when new entries were added. (D-14662)
* B-07326: .NET 6 migration merge.
*Event type mapping in charts didn't work in object-centric models. (D-14620)
* B-07398: Improvements to PA service log writing during client-side import.
*Model generation didn't work as transformation step using _system.ML.ApplyTransformation function. (D-14654)
*Others aggregation has been removed from date type of dimensions because tables don't work with textual data in date columns. (D-14623)
*Fixed issue in AI Assistant where using both Snowflake Cortex and OpenAI modes caused error. (D-14646)
*In User Management Effective permissions table, column filter incorrectly showed "true" and "false" as options. (D-14639)
*Pivot table incorrectly showed "Numeric value is not recognized" error when Count or Unique count aggregations were used. (D-14559)
*Workspace buttons are now visible in small screens spanning to multiple lines. (D-14587)
*Added tooltip text to "Move to" submenu containing projects so that long project names can be seen. (D-14612)
*Translation was missing from error messages when deleting items from recycle bin. (D-14652)
*Fixed data type related issues with in-memory Floor, Ceiling and aggregation functions. (D-14622)
*Optimized resource loading by getting rid of unnecessary file assets/i18n/en_US.json. (D-14641)
*Fixed issue where opening script editor gave javascript error about content-security-policy violation. (D-14627)
*Fixed issue in charts showing datatable content had a strange error when datatable was not selected. (D-14650)
*Fixed incorrect data types in some project, user and group related measures. (D-14619)
* Fixed issue where moving expression scripts was not possible when SQL Scripting was not allowed. (D-14624)
*Deleting and renaming scripts were not available for expression scripts when SQL Scripting was not allowed. (D-14625)
*Improved documentation for situation when non-existing Snowflake warehouse is configured for a model. (D-14543)
*Project properties dialog shows a descriptive text when no secrets have been defined instead of an empty table. (D-14611)
* Improved messages and New project button visibility in Workspace top level when no projects are shown. (D-14609)
*Event preset gave error if enabling Apply with Chart Filters setting and trying to create filters. (D-14695)
 
===Other improvements===
*Added QPR ProcessAnalyzer API request ID to Snowflake queries to easily find matching query in Snowflake query history. (B-08839)
*[[QPR_ProcessAnalyzer_Security_Hardening#Added_HTTP_Headers|Content Security Policy HTTP header]] includes now object-src, frame-ancestors, form-action, base-uri, and worker-src. (B-08794)
*Snowflake queries have been optimized by removing null and empty string checks from mapped columns as they are now handled by the model validation check. (B-08837)
*Added backend support for object-centric model filtering based on case-centric filter rules. (B-08836)
*Frontend components have been updated. (B-08851)
*Backend components have been updated. (B-08852)


'''Fixed issues:'''
==QPR ProcessAnalyzer 2025.5 (build 10361) (released 2025-08-21)==
* D-12098: Attribute function worked incorrectly inside Switch statement.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_5.pdf QPR_ProcessAnalyzer_2025_5.pdf]
* D-12491: Case filter was not shown in header if case id column is integer.
* D-12535: Variables disappeared when going to other dashboard.
* D-12480: ScriptLauncher client side import stucked without error.
* D-12501: Snowflake model gave error: ERROR [42P13] Invalid argument types for function 'SUM': (BOOLEAN).
* D-12112: Added validation for allowed values of standard context variables.
* D-12470: Truncating datatable made it unreadable.
* D-12383: Chart settings export options didn't change when visualization is changed.
* D-11424: Multiselect dropdown lists were shown partly out of screen in smaller screens.
* D-12270: Old version Big data chart didn't show correct error message.
* D-12471: Expression query windowing didn't take Criteria parameter into account.
* D-12461: Several datagrid column menus were incorrectly visible at the same time.
* D-12430: Dashboard gave error: Uncaught SyntaxError occurred: Invalid or unexpected token  at new Function (<anonymous>).
* D-12436: When query specific mapping was used, variations indicate flow that didn't exist in flows query.
* D-12432: SqlExpressionValue filter rule using Datediff function didn't work.
* D-12393: Expression generated with "Show Expression" in query designer did not support column role mappings.
* D-11272: Measure/Dimension/Column settings icon was changed to be more understandable.
* D-12416: Some UI strings were not translated properly.
* D-12153: Removed logging when defining functions.
* D-12485: Business calendar performance issue - part 1.
* D-12537: Variables didn't work in PA opening url when SAML is in use.
* D-12506: Root Analysis gave error "Operations that change non-concurrent collections must have exclude access".


== QPR ProcessAnalyzer 2022.5 (build 1179) (released 2022-08-24) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Datatables can be stored to a separate SQL Server database, i.e., the datatables are not anymore created to the QPR ProcessAnalyzer metadata database. This improves performance as data intensive operations are isolated from metadata operations. To take the feature into use, create a new database in SQL Server and set the [[PA_Configuration_database_table#General_Settings|SqlServerConnectionString]] setting in the configuration table to connect to that database. When the configuration has been made, all new datatables are created to the datatables database. Pre-existing datatables are still located in the metadata database. To get the pre-existing datatables to the new database, they need to be recreated, which can be done by creating a duplicate of the datatable. Support for the metadata database stored datatables is continued, but deprecating the support in future will be considered.
When using Snowflake Cortex, the AI Assistant is not showing the results table in the assistant's response. This issue has been fixed by the next release.
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===New features=== 
Following legacy analyses have been removed: Variations Chart (analysis number: 1), Event Types Chart (4), Models (17), Model Report (21), Project Report (22), Datatable Report (23), and Script Report (24). To replace these analyses, use the corresponding native functionality in the expression language.
*[[Object-Centric_Flowchart|Object-centric flowchart]] can also use object-to-object relations to link events and objects simplifying event-to-object configuration. (B-08671)
*[[AI_Assistant_for_QPR_ProcessAnalyzer|AI Assistant]] can provide precise quantitative analysis by making queries to eventlog data (powered by Snowflake Cortex Analyst and Agents). (B-08652)
*[[Filtering_in_QPR_ProcessAnalyzer|Flows and variations can be filtered]] from any event attribute viewpoint in Snowflake. (B-08737)
* Added [[Project_Properties_Dialog|project properties dialog]] for viewing project information, changing Snowflake connection settings and project secrets. (B-08655)
*[[QPR_ProcessAnalyzer_Project_Workspace#Validating_Model|Model validity check]] easily detects technically invalid models and shows detailed reason for invalidity. (B-08624)
*Projects can be [[QPR_ProcessAnalyzer_Project_Workspace#Exporting_Project|exported]] to json files and imported as new projects. (B-08717)
*Action buttons can be added to dashboard by defining [[Label_and_Link|label component]] that can change dashboard variables and run scripts. (B-08694)
*Web user interface is available in [[Languages_and_Localization|Ukrainian language]]. (B-08734)


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts in the system that likely use the removed analyses:
===Fixed issues===
<pre>
*Fixed following error when performing client-side SAP import: Could not find a part of the path (QPR_ImportSource_Chunk_*.tmp). (D-14589)
let removedAnalyses = Flatten([1,4,17,21,22,23,24].(["'AnalysisType','" + _ + "')", "'AnalysisType', '" + _ + "')"]));
*Fixed issue where ManageProjects permission was incorrectly required when running scripts using QPR ScriptLauncher non-legacy mode. (D-14562)
OrderByDescending(Flatten(Projects.Scripts).Where({
*Fixed following error when using SAP import from SQL script called from expression language called from SQL: The given key '' was not present in the dictionary. (D-14593)
  let scr = _;Sum(removedAnalyses.{let num=_;scr.code?.Contains(num)})>0;
*Some analyses didn't work, when case ID columns for cases and events datatables differed only in upper/lowercase letters. (D-14556)
}),LastRunStart).(Project.Name + ": " + name + " (last run: " + (LastRunStart ?? "N/A") + ")");
*Business calendar didn't work for some measures/dimensions/columns and some had business calendar checkboxes missing. (D-14563)
</pre>
*Prediction failed to following error: transformer_model_next_activity/event_year_input_embedding. (D-14551)
</div>
*Scripting now works correctly after rows from PA_OPERATION_STATUS table have been deleted. (D-14545)
*Fixed issue where case-centric flowchart was very slow for object-centric model. (D-14544)
*Prevented creating dashboards, models and scripts with duplicate names in the same project. (D-09480)
*KPI Card now shows line breaks correctly in textual values. (D-14546)
*Improved table Excel export for list data to show items with separator character instead of showing as JSON. (D-14479)
*Column showing non-conformance reason was incorrectly aligned to right. (D-14570)
*GetRelatedValueFrom function caused column name conflict when used multiple times in same query. (D-14591)
* Fixed issue where in-memory sorting for arrays gave "Error in sorting analysis result rows possibly due to multiple types of values ...". (D-14592)
*Array type of values were shown incorrectly when used Last Row Aggregates Over-limit Rows setting. (D-14616)
*Fixed the "Most common" text aggregation sorting error for in-memory calculation. (D-14573)
*Snowflake model validation gave incorrect error message when mapped column didn't exist in datatable. (D-14565)
*Improved model validation to detect when connection string key for model or datatable does not exist. (D-14607)
* Model validation gave incorrect error when when events datatable case id mapping was missing. (D-14566)
*Model validation gave incorrect error message when cases and events datatables were in different datasources. (D-14567)
*Model validation gave incorrect error message when underlying Snowflake table didn't exist. (D-14568)
*Workspace Card/Table mode toggle buttons were not translated. (D-14547)
*Some invalid queries gave unexpected errors and strange outputs. (D-14569)
* Added translations to model notifications preview table headers. (D-14590)
* Added translations to access denied message for header object counts indicator. (D-13967)
* AI Assistant explaining charts speaks now user interface language. (D-14578)
* AI Agent prompt chart editor didn't show correctly if model was not selected. (D-14536)
*AI Assistant gave "Unsupported cache table type" error when trying to explain object-centric flowchart. (D-14477)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===Other improvements ===
Security hardening instructions to set the [[QPR_ProcessAnalyzer_Security_Hardening#Add_Security_Related_HTTP_Headers_in_IIS|Content-Security-Policy]] http header, has changed. In addition, the '''img-src''' directive includes also '''blob:''' urls (this allows to export Highcharts charts).
*When trying to open dashboard with an invalid model, the precise model validation error message is shown. (B-08629)
</div>
*Account locked message is now same as username/password incorrect to prevent account enumeration attack. (B-08740)
*Stringified value format supports also json objects. (B-08766)
*Event attribute used as event type can be defined for flow and variation filters in Snowflake models (backend support). (B-08705)
*Translations have been updated. (B-08757)
*Frontend components have been updated. (B-08760)
*Backend components have been updated. (B-08759)


'''Features:'''
==QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28)==
* B-06898: In Snowflake models, events can be filtered based on event attribute values.
* B-06996: In Snowflake models, event type mapping can be defined for each chart.
* B-07069: Datatables can be stored to separate SQL Server database to reduce load from metadata database.
* B-06525: In dashboard editor, the background alignment grid is now better visible with any background color.
* B-06844: In script editor, the script status is automatic refreshed.
* B-06643: Links in header changed, e.g., the eLearning library link.
* B-06981: Chart settings remember the last opened tab, and the settings are always for the active chart.
* B-06467: Added SelectDistinct function for dataframes for selecting distinct rows.
* B-06933: Added "Like" function to SQL expressions for string pattern matching.
* B-06543: Generic Eval function for evaluating an expression given in a string.
* B-06944: Truncate function to efficiently delete all rows from datatable.
* B-07207: Access to properties CreatedBy, LastModifiedBy and LastImportBy for datatables using expression language.
* B-06906: Added Configuration property to Model and Datatable objects to get configuration json as dictionary.
* B-07170: Added ScriptByName and ModelByName functions for project objects and changed behavior for DatatableByName function.
* B-06919: Expression language: Increment (++) and decrement (--) operators.
* B-06829: UI remembers the user's last selected model in next login.
* B-07000: Workspace Models and Scripts tab auto-refresh has been optimized for performance.
* B-06456: Changed icons in chart Visualization selection.
* B-07175: Removed deprecated analyses.
* B-07205: Replaced Scripts analysis (24) with expression language property.
* B-06813: Pacm file support case and event attribute data types.
* B-06907: Define start row for the returned data in dataframe processing.
* B-06879: NumberPrecision and DatetimeTruncation support for dataframe queries Values columns.
* B-06998: Implemented referrer policy HTTP header.
* B-06936: Prevented using outdated caches in dataframe processing.
* B-07066: Snowflake queries has been optimized by removing unnecessary metadata queries.
* B-06900: Backend support for expression filter rules to dataframe processing.
* B-06987: Add caching for Project objects.
* B-06910: Frontend components have been updated.
* B-07117: Translation updates for release 2022.5.


'''Fixed issues:'''
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_4.pdf QPR_ProcessAnalyzer_2025_4.pdf]
* D-12075: DashboardFilter variable rules were applied in incorrect order.
* D-12351: Pivot table columns headers had unnecessary prefix when there are multiple measures and no dimensions in columns.
* D-11946: Content security policy violation occurred when exporting Highcharts charts as images.
* D-12064: Chart pending query was incorrectly cancelled when going to and from Add component mode.
* D-11606: Scripts and Projects tab slightly covered the top borderline of workspace datagrid and entire grid was not visible.
* D-12389: When using AggregateFrom, filters were always applied on the completely unfiltered set of events even if a "top level" filter existed also.
* D-12324: The visibility stepper counter didn't follow changed variations.
* D-12373: CSV import may have failed when there are line breaks in strings.
* D-12045: Column filter was not cleared when user switched to other view in Recycle bin.
* D-11590: Two context menus were visible at the same time.
* D-11131: It was not possible to move data grid column Custom filter dialog.
* D-11401: For datatables filter popup menu was opened outside visible dialog and required more scrolling to be seen.
* D-11650: In Workspace, sub context menu for target projects to move items didn't open with latest Syncfusion.
* D-11651: Multiselect list lost some items when using search.
* D-11657: Combobox autofill was broken.
* D-11639: User's default model did not behave as it should.
* D-12085: Filter rules in header were lost when pressing F5.
* D-12142: KPI card value is now visible for non-numeric values.
* D-12105: Nullable object must have value error displayed  when trying to open Enhanced BPMN dashboard.
* D-12157: Root causes analysis in the Conformance Root Causes Analysis didn't work.
* D-12067: Some tooltips, e.g., in BPMN button, didn't disappear at all.
* D-12069: User got querying variation error when first time created big data flowchart.
* D-12177: In models list, search and cancel icons were vertically misaligned.
* D-12116: Add and delete filter rule from Create Filter dialogue did not work.
* D-11445: When using very large value for border corner roundness, chart settings were not visible.
* D-12166: External content presentation object was broken due to too strict content security policy.
* D-12151: KPI card incorrectly showed error "Measure data type needs to be numeric" when numerical measure has null value.
* D-12150: Event data column named "Case ID" mapping to both Case ID and Event Type caused error "An item with the same key has already been added".
* D-12325: Workspace root level had too many New items in context menu.
* D-12326: Wrong menu displayed for sub projects if first click create new option for root level from project tree view.
* D-12000: Script log system report default time interval was too long making report very slow.
* D-12119: Uncaught (in promise) TypeError occured: Cannot set properties of undefined (setting 'isAnimate').
* D-12293: "Cannot read properties of undefined (reading 'id') at o.checkTabNames" error occured.
* D-12294: Term ID was incorrectly translated.
* D-12353: Dialogs broke when there are quotation marks in header.
* D-11978: Soft deleted project could incorrectly be queried by admins.
* D-11982: Null reference error when filter contained attribute value with null.
* D-11706: Deadlocks during tests in Concurrency test category.
* D-11893: User.Globalpermissions returned incorrectly Hashset for inactive users (should return array).
* D-11892: Project-specific user role could be assigned without project id (as global).
* D-12114: In-memory core gave now and then error: The given key was not present in the dictionary.
* D-12138: Timespan function incorrectly assumed 32-bit integers.
* D-11548: Removed setting of default model and view.
* D-12230: Column mappings didn't work for some dataframe processing operations.
* D-12100: Giving project name (possibly id too) for DataFrame.Persist did not work when persisting a SqlDataFrame.
* D-12099: Querying SqlDataFrame for an empty table returned an empty in-memory DataFrame.
* D-12301: Duplicating local datatable didn't create datatable in sqlserver.
* D-12097: Error "Unable to join two tables without specified binding columns", when dimensioning events by two case attributes.
* D-11862: Filter with integer stringifiedvalues raised an exception when running in in-memory.
* D-12087: Error: Ambiguous column name 'CaseId'. The column 'CaseId' was specified multiple times for 'df_5'.
* D-12297: The datediff function resulted in an overflow when using high precision in SQL Server.
* D-12288: Error in querying event type measures: An item with the same key has already been added.
* D-12329: Filters using boolean attributes didn't work in SQL Server/Snowflake.
* D-12054: Backslashes in string literals gave null reference error in dataframe processing.
* D-12065: Case attribute filtering with column mapped to case id didn't work in filters.
* D-12070: PA server incorrectly modified dashboard json.
* D-12046: Expression language DateTime.Ticks was always UTC time.
* D-12102: SQL Expression: Variable-function did not work if the variable has upper-case letters.
* D-11950: Using list aggregation with different orderings in a single select did not work.
* D-12345: Mapping columns and using Columns function caused error 'invalid identifier'.
* D-12082: SourceData definition to events effected case attributes.
* D-12348: DateDiff did not support milliseconds in-memory.
* D-12374: Overflow error occurred when calculating standard deviation for case durations in large model.


== QPR ProcessAnalyzer 2022.4 (build 1001) (released 2022-05-31) ==
===New features ===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
*Added new AI Agent presets analyzing current state and proposing improvements based on different viewpoints, such as Event and Case Counts, Automation, Bottlenecks, and Root Causes. (B-08710)
Expression language has new function [[Generic_Functions_in_QPR_ProcessAnalyzer#Data_source_connectors|CallWebService]] for extracting data from web API's and make generic http calls. This function replaces the ReadWebService function which was a pre-production version of the same functionality. The ReadWebService function is thus now deprecated and it will be removed in future.  
*Added a [[Filter_Selectors#Filter_selector|generic filtering component]] that can be configured for creating any type of filters for distinct values. (B-08654)
</div>
*Volume declining in measures due to case sampling can be compensated in chart and flowchart by using a [[Measure,_Dimension_and_Column_Settings#Statistical_calculations|Statistical calculation method]]. (B-08598)
*In object-centric models, Object ID, Event ID, Event timestamp, and Event type [[Object-centric_Process_Mining_Model#Object-centric_perspectives|attribute names]] are shown correctly. (B-08680)
*Snowflake native app has now [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#User_access_to_application|application roles]] for user (for using app) and administrator (for managing app). (B-08660)
*For Snowflake native app, IMPORTED PRIVILEGES ON SNOWFLAKE DB privilege is removed and instead the [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Optional_privilege_for_AI_Agent|CORTEX_USER database role]] can be assigned. (B-08718)
*[[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Logging|Native app logging]] has been improved and now sharing application logs with QPR is possible. (B-08661)
* Added [[DataFrame_in_Expression_Language#CsvToDataFrame|CsvToDataFrame]] function to expression language to convert textual CSV data into in-memory dataframe. (B-08246)


'''Features:'''
===Fixed issues===
* B-06864: New dashboard component: Big data flowchart that calculates in Snowflake.
*Fixed "Invalid identifier" error when opening attribute selection list for case attribute preset caused by object id columns which differed only by letter capitalization. (D-14539)
* B-06434: Flowchart has been improved by adding e.g., presets, tabs and title (both in in-memory and big data flowchart).
*When Image component is clicked in dashboard edit mode, the component is now selected instead of link followed. (D-14525)
* B-06515: New setting for chart to prevent applying chart filter to other charts ([[QPR_ProcessAnalyzer_Chart#Filtering_Settings|Apply chart filters to dashboard]]).
*Filters created from dimensions having dimension-specific filter rules will now create expression filter rule where dimensions-specific filter is embedded, for accurately following the selection. (D-14499)
* B-06450: Log in screen visual layout has been renewed.
*Filtering variations or list of event attribute values didn't work in in-memory models. (D-14476)
* B-06876: User management system reports including used license for each user.
*Fixed issue where AI Agent didn't update when dashboard variable changed used by prompt chart. (D-14537)
* B-05981: Expression language function CallWebService for web api and http calls.
* Fixed issue where some statistical calculations inadvertently changed row order when applying in groups. (D-14495)
* B-06789: Datetime truncation function support for half-year and millisecond time units.
*In in-memory models, array type of data was not dimensioned correctly. (D-14518)
* B-06497: SqlExpression function for getting string length.
* AI Agent Process Variations preset gave "division by zero" error when there were zero cases. (D-14508)
* B-06581: SqlExpression function for trimming white spaces from strings (Trim).
*Table grouping header labels were not formatted correctly. (D-14514)
* B-06630: SqlExpression function to add duration to date (DateAdd).
*Fixed Root causes analysis to work with object-centric models. (D-14515)
* B-06631: SqlExpression function for getting a substring of a string (Substring).
*Filtering by OcelObjectId didn't work when model didn't have object type table for perspective used in filter. (D-14522)
* B-06860: SqlDataFrame function to remove columns (RemoveColumns).
*Fixed Root causes analysis with weighting expression to work with object-centric models. (D-14517)
* B-06832: When error occurs in script run in client side, error message is shown in script log.
*Fixed issue where persisting query results where query is started from datatable having custom table name overwrote data in original table. (D-14528)
* B-06818: Russian language has been removed from UI.
*Flowchart SVG export did not show start and end symbols. (D-12401)
* B-06445: Datatable row counts are cached to avoid querying the information from Snowflake.
*Fixed issue where join operation didn't find renamed columns in SqlDataFrames. (D-14512)
* B-06843: Backend support for filter rule to filter events by event attribute values.
*Improved chart filtering button positions to work with small chart sizes. (D-14509)
* B-06871: Translation updates for 2022.4 release.
*Datatable foreign key columns dictionary data type was incorrect preventing reading columns information. (D-14505)
*Workspace scripts editor allowed to change script code for viewer users (altough not save it). (D-14534)
* In chart custom sorting, trying to refer to measure that had None aggregation, caused SQL compilation error. (D-14526)
*Model validation check crashed when the datatables were in different datasources. (D-14502)


'''Fixed issues:'''
===Other improvements===
* D-11802: When closing fullscreen, sometimes main header stayed invisible.
*Added expression language functions for using Snowflake Cortex Agents with Cortex Analyst access to query eventlogs. (B-08647)
* D-11947: Dynamic dropdown lists didn't open in first click in certain situations in Firefox.
*Projects can be export and imported in JSON format containing dashboards, models, datatables and scripts. (B-08613)
* D-11783: Flowchart start/end flow measure label showed in incorrect place when there are only one starting/ending flow.
*Simplified object-centric model queries by accepting OcelObjectId as object attribute name in filters. (B-08702)
* D-11796: Data export in pivot table didn't work.
*Streamlined import API by removing importMode parameter and changing default fileType to CSV. (B-08704)
* D-11530: When model is moved to other project, linked datatables are now not moved.
*Frontend components have been updated. (B-08695)
* D-11714: Scripts list hover buttons didn't work in Firefox.
*Backend components has been updated. (B-08696)
* D-11500: Duplicated name check for workspace items was missing.
* D-11782: Some in-memory chart expressions gave parse exception: token recognition error at: '\n'.
* D-11871: Importing large number of rows to Snowflake could be very slow, as it incorrectly used SQL insert.
* D-11781: Persisting more complicated SqlDataFrames did not work.
* D-11849: Script log was not generated when running tasks in parallel using AsParallel function.
* D-11789: Changing expression to "none" crashed UI, and line breaks were incorrectly removed in multiline text fields.
* D-11817: Error missing when trying to run --#CallWebService with ExecuteInClientSide=1 in web UI.
* D-11716: Deleted models were incorrectly listed in main header.
* D-11912: User management dialog showed global roles incorrectly after they have been changed.
* D-11940: Datatable rows column didn't show all when there is over 1 billion rows.
* D-11596: Event count calculated incorrectly using AggregateFrom events.
* D-11588: EventTypes root dimensioned by case count with AggregateFrom did not work.
* D-11778: Variations dimensioned by flow count gave error in SQLDataFrames.
* D-11788: User roles did not work in expression language.
* D-11815: Variation case count showed as too large when there was other value joining events.
* D-11818: Flow case count calculated incorrectly in dataframes.
* D-11794: Switch statement returned null reference exception when condition expression evaluates to null.
* D-11820: Variation duration calculation gave error in dataframes.
* D-11867: Variations were not deterministic if there were events with same timestamps.
* D-11891: Snowflake data import could fail in SQL insert mode due to too many statements.
* D-11848: Configuration needed to be defined as valid JSON 'null'.
* D-11784: Memorycache root gave errors when measures were used.
* D-11913: Root causes icon was missing on the header.
* D-11938: Design model was incorrectly not stored to the dashboard.
* D-11939: Filter rule dialog showed incorrectly case/event attribute datatype in eventlog mode.
* D-12004: Adjustment expression and Custom aggregation expression could not be emptied.
* D-12034: All filter rules were not visible in main header when there are lot of them.
* D-11821: Flow count of variation is incorrectly null for some variations.
* D-11834: Error when dimensioning flows by case count in dataframes.


== Old Releases ==
==Old Releases==
See older releases in [[QPR ProcessAnalyzer Release Archive]]
See older releases in [[QPR ProcessAnalyzer Release Archive]]
__NOTOC__
__NOTOC__


[[Category: QPR ProcessAnalyzer]]
[[Category: QPR ProcessAnalyzer]]

Latest revision as of 18:35, 22 May 2026

This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.

See roadmap for next release features and fixes

Current Release: QPR ProcessAnalyzer 2026.4 (build 10956) (released 20.5.2026)

New features presentation: QPR_ProcessAnalyzer_2026_4.pdf

New features

  • BPMN diagrams stored in QPR EnterpriseArchitect can be opened and saved in QPR ProcessAnalyzer BPMN editor for conformance analysis. (B-09041)
  • Added setting AIAgentDefaultModelName to define AI Agent's default LLM, and updated gpt-5.4 as default for OpenAIDefaultModelName setting. (B-09039)
  • Implemented OAuth refresh tokens grace period, and limited MCP tool names to 50 characters. (B-09090)
  • In object-centric flowchart, object types can be hidden and shown with an toggle button, and flowchart flow routing has been improved to avoid label overlapping. (B-09042)
  • Table header margins have been adjusted to fit more text, and column filter menu icon is shown only when hovering header. (B-09032)
  • Expression language API is available to change filter's model, and added functions CreateScript for project, and Modify and DeletePermanently for script objects. (B-09006)
  • Datatable foreign key definitions are maintained as consistent when datatables are modified. (B-09035)

Fixed issues

  • Listing scripts was slow when there were lot of script and operation logs. (D-14875)
  • Error message returned from MCP tool call includes now actual exception message. (D-14870)
  • Filtering Case and Event attribute profiling presets with decimal type of attributes didn't work in Snowflake models. (D-14866)
  • Fixed issue where AI Agent did not provide any response for an eventlog with zero cases. (D-14835)
  • Variation filter showed "undefined" in place of the variation order number when filtered variations were not in the eventlog. (D-14857)
  • Improved error message in situation when model doesn't have the case or event attribute used by a chart filter. (D-14865)
  • Improved model validation to detect when connection to the source tables in Snowflake is not valid. (D-14837)
  • "Datatable with given name already exists in project" error message had localization missing. (D-14838)

Other improvements

  • Frontend components have been updated. (B-09063)

QPR ProcessAnalyzer 2026.3.1 (build 10941) (released 30.4.2026)

New features

Fixed issues

  • Business calendar related model properties could not be shown in chart settings. (D-14858)
  • Fixed unclear error when Snowflake connection string keys was removed when project was imported. (D-14833)

Other improvements

  • Backend components have been updated. (B-09064)

QPR ProcessAnalyzer 2026.3 (build 10933) (released 13.04.2026)

New features presentation: QPR_ProcessAnalyzer_2026_3.pdf

New features

  • QPR ProcessAnalyzer acts as MCP server supporting MCP tools implemented using scripts with OAuth and API key authentication. (B-09004)
  • Units for each object type can be specified in object-centric models. (B-08992)
  • Charts color palette can be changed globally to easily manage consistent visual layout. (B-08993)
  • External content component url supports tags refering to dashboard variables to show dynamically changing web page. (B-08998)
  • Project export and import using files support public filters stored in models. (B-09007)
  • KPI Card shows null value label when data has no rows, and table and chart show "No data" message. (B-08999)
  • QPR MEA web service operations can be called using QPR ProcessAnalyzer expression language. (B-09030)

Fixed issues

  • Flowchart had flows missing if shown flows were beyond the top-500 flows. (D-14848)
  • Expression filter rules with greater/less than criteria were incorrectly applied as equal filters when editing chart filters. (D-14852)
  • Table column filter dialog was not entire visible in narrow table located in the bottom of screen. (D-14783)
  • Opening Scripts tab in Workspace was slow when there were scripts with long script log. (D-14670)
  • Fixed issue where object-centric model queries sometimes gave inconsistent results. (D-14854)
  • Snowflake query gave "invalid identifier" error when there were two measures with same cases going though event measure filter. (D-14845)
  • Filter rules drag-and-drop didn't work between expressions in the same chart. (D-14850)
  • Better error message is shown when invalid value is specified to dashboard aspect ratio flex, chart margin, dashboard margin, external content border width, or external content border corner radius. (D-14805)
  • Improved error message when object-centric model perspective doesn't have the object type correctly defined. (D-14795)
  • Reduced project properties dialog minimum height to fit for smaller screens. (D-14834)
  • Updated NLTK to version 3.9.3. (D-14829)
  • Frontend components have been updated. (B-09028)
  • Backend components have been updated. (B-09027)

Additional release for QPR ProcessAnalyzer 2026.2 (build 10910) (released 16.3.2026)

New features

  • Filters report in System reports shows also other users' private filters for admins. (B-09017)

Fixed issues

  • Filter rules were lost when saving a filter with "Cases with specific events", "Cases starting with" or "Cases ending to" rules. (D-14847)
  • Fixed issue where object-centric models sometimes gave "Object <cachetablename> does not exist or not authorized" error. (D-14797)
  • ExtractSap function didn't work with QPR ScriptLauncher when using secret for storing SAP password. (D-14813)
  • Variation stepper incorrectly skipped steps when going down when variation count is maximum. (D-14844)
  • Improved error message when creating model from filter fails. (D-14811)
  • System dashboard names were incorrectly translated twice. (D-14841)
  • AI Assistant had one translation missing. (D-14840)

QPR ProcessAnalyzer 2026.2 (build 10897) (released 2026-02-26)

New features presentation: QPR_ProcessAnalyzer_2026_2.pdf

Snowflake user-defined functions (UDF) used by QPR ProcessAnalyzer have been updated to use Python 3.13. Some of the old versions of the functions use Python 3.9 which has been deprecated by Snowflake. Although the old versions are not anymore used by QPR ProcessAnalyzer, they are not automatically deleted and thus Snowflake may send notifications about existing deprecated functions. It's recommended to remove the old functions which are following:

  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V2
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V3
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V4
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V5
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V6
  • QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS
  • QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS_V2
  • QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS_V3
  • QPRPA_UDF_BPMN_IS_CONFORMANT
  • QPRPA_UDF_BPMN_IS_CONFORMANT_V2
  • QPRPA_UDF_BPMN_IS_CONFORMANT_V3
  • QPRPA_UDTF_CLUSTER
  • QPRPA_UDTF_CLUSTER_V2
  • QPRPA_UDTF_CLUSTER_V3
  • QPRPA_UDTF_CLUSTER_V4

New features

  • Fully conformant BPMN diagrams can be created from eventlogs with proper layout and identifying exclusive and parallel gateways. (B-08900)
  • Object-centric flowchart flows visibility can be controlled with a stepper based on top variations, and start and end symbols can be hidden for each event type. (B-08987)
  • Added preset for object-centric flowchart, and improved Process Discovery dashboard usage for object-centric models. (B-08863)
  • Viewer users can save private filters for personal use. (B-08920)
  • On-screen settings support static and dynamic case/event attribute values selection, and linked settings can bind to on-screen settings. (B-08814)
  • AI root causes analysis related error situations are easier to resolve with easier to understand error messages. (B-08997)

Fixed issues

  • Histogram chart did not show at all and gave a JavaScript error. (D-14801)
  • When chart with multiple series was sorted by measure, some datapoints were not shown when visible X-axis was limited by zooming or Custom layout settings. (D-14793)
  • Disabled filter rules were incorrectly applied for the shown items in the filter rule editing dialog. (D-14791)
  • If there were more than one Range filter components in dashboard, periods menu incorrectly affected all of them. (D-14818)
  • List of event types in object-centric flowchart settings didn't open if there were object types linked to none events. (D-14798)
  • Snowflake flowchart root causes analysis gave "SQL compilation error" when run with case duration criteria. (D-14790)
  • Term "Second" when meaning time unit was translated incorrectly in French. (D-14803)
  • OpenTelemetry metrics were not sent to Prometheus correctly. (D-14804)
  • Opening script editor by url didn't show project path and also javascript error appeared to console. (D-14794)
  • Fixed issue where case attribute prediction failed when using more than one iteration. (D-14789)
  • SQLDataFrame with several append operations had performance issue. (D-14772)
  • Null coalescing operators didn't work correctly in chaining in expression language. (D-14762)
  • Native app could not call procedure if project referred to other database and schema. (D-14749)
  • Trying to create script with duplicate name gave unclear error: Cannot insert duplicate key row in object 'dbo.PA_SCRIPT' with unique index 'PA_SCRIPT_UNIQUE_NAME_IN_PROJECT'. (D-14784)
  • BPMN editor popup menu was partly hidden behind other chart components. (D-14345)
  • When going to context menu report from BPMN editor, "Operation was cancelled by a user" was given when query was in progress. (D-14807)
  • BPMN editor tooltips measure descriptions didn't disappear at all. (D-14809)
  • Presets benchmarking didn't work for models without case attributes. (D-14822)
  • Object-centric filter rule editor gave javascript error when opened for case-centric model. (D-14799)
  • Object-centric filter rule could incorrectly be dropped as root causes comparison rule. (D-14796)
  • Localization missing for "Save as new filter" button. (D-14839)

Other improvements

  • SQL queries run in Snowflake have been further optimized. (B-08936)
  • Snowflake stored procedures and user defined functions have been migrated to Python 3.13. (B-08984)
  • Frontend components have been updated. (B-08991)
  • Backend components have been updated. (B-08990)

QPR ProcessAnalyzer 2026.1 (build 10870) (released 2026-01-19)

New features presentation: QPR_ProcessAnalyzer_2026_1.pdf

QPR ProcessAnalyzer Server and QPR ScriptLauncher are running on .NET 10, replacing the previous .NET 8 version. When updating to this release, make sure to install the .NET 10 Runtime (update instructions). While .NET 8 and .NET 10 can run side by side, .NET 8 does not need to be removed immediately. However, for security reasons, any unused .NET 8 installation should be uninstalled as soon as possible after the update.

Known issue: The histogram visualization doesn't work in this release. The issue will be fixed in the next release. Possible workaround is to use the column chart where to set no spacing between columns. This can be configured with the following Custom Layout settings: 

{
	"plotOptions": {
		"series": {
			"pointPadding": 0,
			"groupPadding": 0
		}
	}
}

New features

  • Object-centric models support versatile object-centric filters based on case-centric filter rules using perspective. (B-08595)
  • AI Root Causes analysis is shown in a hierarchy for easier readability. (B-08921)
  • Case-centric flowchart performance has been improved by making all queries simultaneously. (B-08916)
  • Object counts indicator is hidden for object-centric models when perspective is not set. (B-08825)

Fixed issues

  • Filter to exclude case attribute values incorrectly excluded null values even if null wasn't selected. (D-14773)
  • Prediction generated invalid models where case IDs in events datatable didn't exist in cases datatable. (D-14758)
  • AI Root Causes presets didn't work with models without case attributes. (D-14759)
  • Snowflake query with multiple columns with aggregations and Coalesce function gave "invalid identifier" error. (D-14763)
  • Dropdown list to add business calendar holidays from other model shows empty items. (D-14786)
  • In-memory Average function didn't work when aggregating dates using model's Attribute function. (D-14761)
  • Sometimes opening models list gave error "User doesn't have permission GenericRead to model". (D-14742)

Other improvements

  • Content-security-policy img-src blob: directive has been restored for Highcharts image export. (B-08904)
  • Backend components have been updated including .NET 10. (B-08926)
  • Frontend components have been updated. (B-08927)

Additional release for QPR ProcessAnalyzer 2025.7 (build 10845) (released 2025-12-11)

New features

  • QPR ProcessAnalyzer can be deployed on-premise using Linux containers. (B-08915)
  • Snowflake SQL queries have been simplified to improve performance, e.g., when quering flows. (B-08901)

Fixed issues

  • ODBC and Loading script models, and models with calculated attributes didn't allow to create or modify case and event attribute filters from header. (D-14751)
  • Fixed incompatibility issue when using Keycloak as identity provider for SAML authentication. (D-14757)
  • System report for users incorrectly listed some users with read-only permissions as Developers (issue with the EffectivePermissionTypesFor function). (D-14748)
  • Referrer-Policy HTTP header was incorrectly set to "same-origins" causing browser console error in Windows deployments. (D-14736)
  • Fixed issue where QPR ProcessAnalyzer request ID was not added to Snowflake data modification queries. (D-14728)
  • Login request duration was incorrectly shown as zero or negative in System reports. (D-14737)
  • In chart settings, some Snowflake measures with aggregations were missing possibility to define percentile value. (D-14276)
  • Fixed issue where it was not possible to delete a model with same name in the same project during the same session. (D-14708)
  • Script editor to specific script can now be opened with a direct url containing the script_editor parameter. (D-14745)
  • Fixed issue were sometimes an incorrect error code was given for a cancelled query. (D-14755)
  • Improved error message if model loading fails when loading script returns incorrect type of data. (D-14637)
  • Fixed issue where variations query with sampling was slow for new models. (D-14729)
  • Added tooltip to gantt chart's table layout header so that the header text can be fully seen. (D-13748)
  • Switching between Snowflake and in-memory chart by adjusting chart configuration json caused some items in chart settings to appear twice. (D-14667)
  • Selecting model in dashboard when previously there was no model selected and going back to Workspace, gave error message. (D-14735)
  • Query Designer gave untranslated error message: "You don't have permissions to model ...". (D-14727)
  • Query Designer gave untranslated error message "Unable to use Snowflake tables as data source for in-memory query". (D-14683)
  • In Query Designer, table column menu gave JavaScript error for columns where first row was null. (D-14684)
  • Query Designer incorrectly gave message "There are no columns in the data" when the data had no rows. (D-14692)
  • Fixed issue in Manage Users dialog where row selections disappeared when resizing the dialog. (D-14647)

QPR ProcessAnalyzer 2025.7 (build 10821) (released 2025-11-13)

New features presentation: QPR_ProcessAnalyzer_2025_7.pdf

Known issue: Creating case and event attribute filters in dashboards is not possible from the main header for the following types of in-memory models and attributes:

Workaround is to create the filter rule in a chart's settings and drag-and-drop it to the header. The issue has been fixed by the next release (D-14751). The issue does not concern Snowflake models.

New features

  • Presets added for AI Root Causes analysis based on Snowflake Top Insights which is a decision tree model finding combinations of root cause contributors. (B-08889)
  • Added new filter selector component to dashboards to easily create date and number range filters. (B-08877)
  • Projects can be browsed in the navigation menu to access all dashboards, and also organized the menu into two columns. (B-08708)
  • When QPR ProcessAnalyzer is embedded to a website, SAML authentication is performed in a separate window for more robust operation. (B-08871)
  • For more flexible options, AI Agents runs the language model query using the Snowflake account where the selected model is located. (B-08860)

Fixed issues

  • If DefaultUiLanguage in PA_CONFIGURATION table was not defined, users who haven't changed language could not login. (D-14706)
  • Improved performance in opening dashboard. (D-14705)
  • Snowflake Native App didn't show the version number and build timestamp correctly. (D-14703)
  • Snowflake Native App activation failed with a custom compute pool if container service was in the suspended state. (D-14722)
  • Server stuck when trying to generate SQL for SqlDataFrame having multiple columns with the same name. (D-14730)
  • In eventlog prediction, fixed issues preventing the usage of case attribute value prediction. (D-14702)
  • Snowflake DurationBetweenDates function calculated incorrectly when used in a in divisor. (D-14723)
  • Import now succeeds when importing Snowflake datatables refering to data without access. (D-14694)
  • Fixed incorrect color in table column filters, and Workspace loading time has been improved. (D-14704)
  • Fixed issue where dropdown list with projects showed "undefined" in place of project id. (D-14659)
  • Fixed issue where specifying a secret name longer than 440 characters, prevented saving the secret and resulted in an error. (D-14674)
  • SAML authentication failed when it needed to create a new user to QPR ProcessAnalyzer. (D-14717)
  • Fixed issue where SQL dataframe queries didn't work if the root expression ended to a semicolon. (D-14714)
  • Specific Snowflake query with a comparison criteria, AggregateFrom and GetValueFrom functions gave error about invalid identifier. (D-14718)

Other improvements

  • Content-Security-Policy HTTP header has been reduced to more secure by removing the script-src 'unsafe-eval' and img-src 'blob' directives. (B-08897)
  • Added security related HTTP headers: X-Permitted-Cross-Domain-Policies, Cross-Origin-Embedder-Policy, Cross-Origin-Opener-Policy, Cross-Origin-Resource-Policy, Referrer-Policy, and Permissions-Policy. (B-08879)
  • Implemented backend support for Snowflake Top Insights for AI root causes analysis. (B-08664)
  • Implemented improved error handling when trying to save too long text to database. (B-08892)
  • For more understandable error messages, error handling and error message generation have been refactored. (B-08754)
  • Optimized database queries and reduced log writing. (B-08870)
  • Frontend components have been updated. (B-08899)
  • Backend components have been updated. (B-08898)

QPR ProcessAnalyzer 2025.6 (build 10690) (released 2025-10-01)

New features presentation: QPR_ProcessAnalyzer_2025_6.pdf

Known issue: If the DefaultUiLanguage system configuration is not defined, users who haven't changed their own language, are unable to login. To prevent this problem, please ensure the DefaultUiLanguage is defined. The next release has fixed this issue (D-14706).

Content-Security-Policy (CSP) HTTP header has been updated to enhance security by implementing more restrictive settings. The following directives have been added:

  • object-src 'none'
  • frame-ancestors 'self'
  • form-action 'none'
  • base-uri 'none'
  • worker-src blob:

These new restrictions may affect usage that has previously been possible. For example, with the new settings, QPR ProcessAnalyzer can be embedded to a website only within the same origin. For detailed instructions on embedding QPR ProcessAnalyzer on a different website, please refer to this quide. Additionally, for information on modifying the CSP settings, see documentation for security hardening.

In the QPR ProcessAnalyzer 2025.6 Native App, the release version number is not displayed correctly in the User Settings dialog. This omission does not have any other complications. QPR ProcessAnalyzer 2025.6 is the only release with this issue, making it possible to identify this release despite the missing version number. This issue is specific to the Native App only. The next release has fixed this issue (D-14703).

New features

  • Starting dashboard after login can be defined for user groups, allowing to create customized starting pages for easy navigation. (B-08791)
  • Snowflake chart's event filters are now embedded to filters created from chart, to precisely follow chart calculation. (B-08845)
  • Result data can be filtered in Snowflake charts using result filtering expression which works for any datasets. (B-08751)
  • Filter rules order now stays the same when making filter selections and confirming filter. (B-08801)
  • Added model setting Show object count statistics to hide object counts information in dropdown lists to optimize performance. (B-08849)
  • Added support for hiding statistics for on-screen setting dropdown lists to improve performance, and in addition the case ID is hidden Case/Event attribute profiling presets. (B-08840)
  • Added following audit fields to users and groups: Created date, Created by, Last modified date, and Last modified by. (B-08792)
  • Snowflake Native App: Added procedure to that creates administrator user to Native App if access to the app has been lost. Also, prevented user management operations that remove own access. (B-08733)
  • Snowflake Native App: Added procedure to change Native App compute pool size. Changed new Native Apps to use CPU_X64_S size compute pool, and improved Native App stability. (B-08859)

Fixed issues

  • Snowflake Cortex based AI Assistant didn't show the results table. (D-14643)
  • When percent stacking is used, Y-axis values are now shown as percentages in data label and tooltip. (D-14633)
  • Fixed issue where Label&Link component had sometimes unnecessary vertical scrollbar. (D-14685)
  • Model validation showed incorrect error message for models with numeric duplicate case ID's. (D-14687)
  • In Workspace, scripts "View current run log" dialog didn't update log correctly when new entries were added. (D-14662)
  • Event type mapping in charts didn't work in object-centric models. (D-14620)
  • Model generation didn't work as transformation step using _system.ML.ApplyTransformation function. (D-14654)
  • Others aggregation has been removed from date type of dimensions because tables don't work with textual data in date columns. (D-14623)
  • Fixed issue in AI Assistant where using both Snowflake Cortex and OpenAI modes caused error. (D-14646)
  • In User Management Effective permissions table, column filter incorrectly showed "true" and "false" as options. (D-14639)
  • Pivot table incorrectly showed "Numeric value is not recognized" error when Count or Unique count aggregations were used. (D-14559)
  • Workspace buttons are now visible in small screens spanning to multiple lines. (D-14587)
  • Added tooltip text to "Move to" submenu containing projects so that long project names can be seen. (D-14612)
  • Translation was missing from error messages when deleting items from recycle bin. (D-14652)
  • Fixed data type related issues with in-memory Floor, Ceiling and aggregation functions. (D-14622)
  • Optimized resource loading by getting rid of unnecessary file assets/i18n/en_US.json. (D-14641)
  • Fixed issue where opening script editor gave javascript error about content-security-policy violation. (D-14627)
  • Fixed issue in charts showing datatable content had a strange error when datatable was not selected. (D-14650)
  • Fixed incorrect data types in some project, user and group related measures. (D-14619)
  • Fixed issue where moving expression scripts was not possible when SQL Scripting was not allowed. (D-14624)
  • Deleting and renaming scripts were not available for expression scripts when SQL Scripting was not allowed. (D-14625)
  • Improved documentation for situation when non-existing Snowflake warehouse is configured for a model. (D-14543)
  • Project properties dialog shows a descriptive text when no secrets have been defined instead of an empty table. (D-14611)
  • Improved messages and New project button visibility in Workspace top level when no projects are shown. (D-14609)
  • Event preset gave error if enabling Apply with Chart Filters setting and trying to create filters. (D-14695)

Other improvements

  • Added QPR ProcessAnalyzer API request ID to Snowflake queries to easily find matching query in Snowflake query history. (B-08839)
  • Content Security Policy HTTP header includes now object-src, frame-ancestors, form-action, base-uri, and worker-src. (B-08794)
  • Snowflake queries have been optimized by removing null and empty string checks from mapped columns as they are now handled by the model validation check. (B-08837)
  • Added backend support for object-centric model filtering based on case-centric filter rules. (B-08836)
  • Frontend components have been updated. (B-08851)
  • Backend components have been updated. (B-08852)

QPR ProcessAnalyzer 2025.5 (build 10361) (released 2025-08-21)

New features presentation: QPR_ProcessAnalyzer_2025_5.pdf

When using Snowflake Cortex, the AI Assistant is not showing the results table in the assistant's response. This issue has been fixed by the next release.

New features

  • Object-centric flowchart can also use object-to-object relations to link events and objects simplifying event-to-object configuration. (B-08671)
  • AI Assistant can provide precise quantitative analysis by making queries to eventlog data (powered by Snowflake Cortex Analyst and Agents). (B-08652)
  • Flows and variations can be filtered from any event attribute viewpoint in Snowflake. (B-08737)
  • Added project properties dialog for viewing project information, changing Snowflake connection settings and project secrets. (B-08655)
  • Model validity check easily detects technically invalid models and shows detailed reason for invalidity. (B-08624)
  • Projects can be exported to json files and imported as new projects. (B-08717)
  • Action buttons can be added to dashboard by defining label component that can change dashboard variables and run scripts. (B-08694)
  • Web user interface is available in Ukrainian language. (B-08734)

Fixed issues

  • Fixed following error when performing client-side SAP import: Could not find a part of the path (QPR_ImportSource_Chunk_*.tmp). (D-14589)
  • Fixed issue where ManageProjects permission was incorrectly required when running scripts using QPR ScriptLauncher non-legacy mode. (D-14562)
  • Fixed following error when using SAP import from SQL script called from expression language called from SQL: The given key was not present in the dictionary. (D-14593)
  • Some analyses didn't work, when case ID columns for cases and events datatables differed only in upper/lowercase letters. (D-14556)
  • Business calendar didn't work for some measures/dimensions/columns and some had business calendar checkboxes missing. (D-14563)
  • Prediction failed to following error: transformer_model_next_activity/event_year_input_embedding. (D-14551)
  • Scripting now works correctly after rows from PA_OPERATION_STATUS table have been deleted. (D-14545)
  • Fixed issue where case-centric flowchart was very slow for object-centric model. (D-14544)
  • Prevented creating dashboards, models and scripts with duplicate names in the same project. (D-09480)
  • KPI Card now shows line breaks correctly in textual values. (D-14546)
  • Improved table Excel export for list data to show items with separator character instead of showing as JSON. (D-14479)
  • Column showing non-conformance reason was incorrectly aligned to right. (D-14570)
  • GetRelatedValueFrom function caused column name conflict when used multiple times in same query. (D-14591)
  • Fixed issue where in-memory sorting for arrays gave "Error in sorting analysis result rows possibly due to multiple types of values ...". (D-14592)
  • Array type of values were shown incorrectly when used Last Row Aggregates Over-limit Rows setting. (D-14616)
  • Fixed the "Most common" text aggregation sorting error for in-memory calculation. (D-14573)
  • Snowflake model validation gave incorrect error message when mapped column didn't exist in datatable. (D-14565)
  • Improved model validation to detect when connection string key for model or datatable does not exist. (D-14607)
  • Model validation gave incorrect error when when events datatable case id mapping was missing. (D-14566)
  • Model validation gave incorrect error message when cases and events datatables were in different datasources. (D-14567)
  • Model validation gave incorrect error message when underlying Snowflake table didn't exist. (D-14568)
  • Workspace Card/Table mode toggle buttons were not translated. (D-14547)
  • Some invalid queries gave unexpected errors and strange outputs. (D-14569)
  • Added translations to model notifications preview table headers. (D-14590)
  • Added translations to access denied message for header object counts indicator. (D-13967)
  • AI Assistant explaining charts speaks now user interface language. (D-14578)
  • AI Agent prompt chart editor didn't show correctly if model was not selected. (D-14536)
  • AI Assistant gave "Unsupported cache table type" error when trying to explain object-centric flowchart. (D-14477)

Other improvements

  • When trying to open dashboard with an invalid model, the precise model validation error message is shown. (B-08629)
  • Account locked message is now same as username/password incorrect to prevent account enumeration attack. (B-08740)
  • Stringified value format supports also json objects. (B-08766)
  • Event attribute used as event type can be defined for flow and variation filters in Snowflake models (backend support). (B-08705)
  • Translations have been updated. (B-08757)
  • Frontend components have been updated. (B-08760)
  • Backend components have been updated. (B-08759)

QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28)

New features presentation: QPR_ProcessAnalyzer_2025_4.pdf

New features

  • Added new AI Agent presets analyzing current state and proposing improvements based on different viewpoints, such as Event and Case Counts, Automation, Bottlenecks, and Root Causes. (B-08710)
  • Added a generic filtering component that can be configured for creating any type of filters for distinct values. (B-08654)
  • Volume declining in measures due to case sampling can be compensated in chart and flowchart by using a Statistical calculation method. (B-08598)
  • In object-centric models, Object ID, Event ID, Event timestamp, and Event type attribute names are shown correctly. (B-08680)
  • Snowflake native app has now application roles for user (for using app) and administrator (for managing app). (B-08660)
  • For Snowflake native app, IMPORTED PRIVILEGES ON SNOWFLAKE DB privilege is removed and instead the CORTEX_USER database role can be assigned. (B-08718)
  • Native app logging has been improved and now sharing application logs with QPR is possible. (B-08661)
  • Added CsvToDataFrame function to expression language to convert textual CSV data into in-memory dataframe. (B-08246)

Fixed issues

  • Fixed "Invalid identifier" error when opening attribute selection list for case attribute preset caused by object id columns which differed only by letter capitalization. (D-14539)
  • When Image component is clicked in dashboard edit mode, the component is now selected instead of link followed. (D-14525)
  • Filters created from dimensions having dimension-specific filter rules will now create expression filter rule where dimensions-specific filter is embedded, for accurately following the selection. (D-14499)
  • Filtering variations or list of event attribute values didn't work in in-memory models. (D-14476)
  • Fixed issue where AI Agent didn't update when dashboard variable changed used by prompt chart. (D-14537)
  • Fixed issue where some statistical calculations inadvertently changed row order when applying in groups. (D-14495)
  • In in-memory models, array type of data was not dimensioned correctly. (D-14518)
  • AI Agent Process Variations preset gave "division by zero" error when there were zero cases. (D-14508)
  • Table grouping header labels were not formatted correctly. (D-14514)
  • Fixed Root causes analysis to work with object-centric models. (D-14515)
  • Filtering by OcelObjectId didn't work when model didn't have object type table for perspective used in filter. (D-14522)
  • Fixed Root causes analysis with weighting expression to work with object-centric models. (D-14517)
  • Fixed issue where persisting query results where query is started from datatable having custom table name overwrote data in original table. (D-14528)
  • Flowchart SVG export did not show start and end symbols. (D-12401)
  • Fixed issue where join operation didn't find renamed columns in SqlDataFrames. (D-14512)
  • Improved chart filtering button positions to work with small chart sizes. (D-14509)
  • Datatable foreign key columns dictionary data type was incorrect preventing reading columns information. (D-14505)
  • Workspace scripts editor allowed to change script code for viewer users (altough not save it). (D-14534)
  • In chart custom sorting, trying to refer to measure that had None aggregation, caused SQL compilation error. (D-14526)
  • Model validation check crashed when the datatables were in different datasources. (D-14502)

Other improvements

  • Added expression language functions for using Snowflake Cortex Agents with Cortex Analyst access to query eventlogs. (B-08647)
  • Projects can be export and imported in JSON format containing dashboards, models, datatables and scripts. (B-08613)
  • Simplified object-centric model queries by accepting OcelObjectId as object attribute name in filters. (B-08702)
  • Streamlined import API by removing importMode parameter and changing default fileType to CSV. (B-08704)
  • Frontend components have been updated. (B-08695)
  • Backend components has been updated. (B-08696)

Old Releases

See older releases in QPR ProcessAnalyzer Release Archive

Retrieved from "https://wiki.onqpr.com/pa/index.php?title=QPR_ProcessAnalyzer_Release_Notes&oldid=28394"