QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
 
Line 1: Line 1:
This page contains new features and fixed issues for each QPR ProcessAnalyzer release. For information about compatibility of different versions, see [[QPR ProcessAnalyzer Version Compatibility|Version Compatibility Information]].
This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.
 
== Next Release: QPR ProcessAnalyzer 2025.7 (planned 2025-11-11) ==
[[Next_Release_Roadmap|See roadmap for next release features and fixes]]
 
== Latest Release: 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]


== Next Release: QPR ProcessAnalyzer 2022.2 (planned release date 2022-03-08) ==
<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;">
SAML 2.0 authentication has been renewed, changing urls used with it. The SAML authentication is now initiated from path '''/saml2''' (previously it was /api/saml). In addition, the redirect back url is now '''/saml2/acs''' (previously it was /api/samlsignin). These changes need to be set to the identity provider and taken into use during the QPR ProcessAnalyzer 2022.2 update. In addition, the redirection to the SAML authentication initialization path, that has possibly been set to IIS, need to be changed.
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 will fix 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;">
The WCF API has been removed in QPR ProcessAnalyzer 2022.2. Before updating, all customized integrations and other solutions that use WCF API need to be converted to use [[QPR_ProcessAnalyzer_API|Web API]]. Note that there may also exist scripts that contact the WCF API using the [[SQL_Scripting_Commands#--.23CallWebService|--#CallWebService]] command. The used API can be distinguished from the url: if it contains "/MainService.svc" the connection is to the WCF API and changes are required. Note also that if QPR ProcessAnalyzer Excel client has still been in use, from now on it won't work anymore.
Content-Security-Policy (CSP) HTTP header has been updated to enhance security by implementing more restrictive settings. The following directives have been added:
</div>
* object-src 'none'
* frame-ancestors 'self'
* form-action 'none'
* base-uri 'none'
* worker-src blob:


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
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]].
Due to the WCF removal, [[Installing QPR ProcessAnalyzer Server|installing]] QPR ProcessAnalyzer Server is now easier, as there is only one web.config file (i.e., no separate web.config files for http and https connections). Note also that the contents of the web.config file is changed, so settings contained by the file need to be migrated manually.
</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;">
Salesforce connector has been changed to use Salesforce REST API, and the API version is changed from 38 to 54. Due to these changes, there might be slight differences in the Salesforce connector behavior.
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 will fix this issue (D-14703).
</div>
</div>


'''Features:'''
===New features===
*  
* [[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-06441: Snowflake stored datatables and models can be managed in Workspace.
* 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-06495: In the fixed dashboards, chart and flowchart settings are now remembered during the user session.
* 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-06514: In UI, scripting and model permissions are finalized.
* Filter rules order now stays the same when making filter selections and confirming filter. (B-08801)
* B-06314: Workspace improvement continuation.
* 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-06551: New statistical calculations for charts and other statistical calculations improvements.
* 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-06362: Expression language: switch-case-default-break statement.
* Added following audit fields to users and groups: Created date, Created by, Last modified date, and Last modified by. (B-08792)
* B-05802: Support for encrypted SAML 2.0 assertions.
* 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-06259: SAML 2.0 authentication library has been changed.
* 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-06428: Change SAP data extraction to use SAP NetWeaver RFC library - part 2.
* B-05837: Root causes calculation is available in the expression language.
* B-05960: Distributed computing: All datatable columns are made available in dataframe processing method.
* B-06526: Set RuntimeComparison automatically based on ComparisonEventLog existence.
* B-06500: When empty, DatabaseId is generated automatically in PA_CONFIGURATION table on startup.
* B-06303: WCF service client has been dropped.
* B-06563: All WCF related functionalities has been removed.
* B-06558: Salesforce connector has been changed to use Salesforce REST API.
* B-06567: Translation updates for release 2022.2.
 
'''Fixed issues:'''
* D-11507: Removed "Drop unused model after" setting from UI, as hasn't worked as originally intended.
* D-11523: Chart tooltip showed incorrect series when some series was hidden.
* D-11489: Percentage character (%) was lost from file name when exporting a filter to a json file.
* D-11490: Stored filter rules were lost from default public filter when setting "All cases" to default public.
* D-11498: Trying to import empty csv file caused JavaScript error.
* D-11499: Trying to import csv file with header line only, correctly suggests now strings as datatype (instead of integers).
* D-11494: Flow Duration Distribution report had JavaScript error in Enhanced BPMN dashboard.
* D-11501: Hiding event type name from flowchart caused error.
* D-11502: Right click didn't work when user opened BPMN editor from measures settings.
* D-11506: BPMN editor could not be opened in the Notification rules editor when creating measure.
* D-11478: Model properties window stayed visible in login page after session expiration.
* D-11491: JPG format file export had incorrect black background color.
* D-11513: Multi-select list item removal from X button didn't work.
* D-11505: Changed new wiki location to help buttons: <nowiki>https://wiki.onqpr.com/pa</nowiki>.
* D-11486: Untranslated strings and translation inconsistencies for Finnish language fixed.
* D-11479: Selection list for new task could not display properly in BPMN editor.
* D-11508: Console error occurred when selecting Case conformance level in Notification rules editor.
* D-11510: Adjusting Object sample size caused error for Top violations chart.
* D-11144: Workspace scripts grid permissions was not checked when showing items context menu.
* D-11234: Creating new model option was incorrectly enabled when user had only view or analyst role for project.
* D-11520: In workspace, changing project with drag-and-drop takes now user permissions better into account.
* D-11521: Title could not display properly for Datatable properties when PA using Finnish UI.
* D-11536: Translation support was missing for "Running" in Script Editor.
* D-11450: Export filter button was enabled in not possible state.
* D-11557: Highcharts was not disposed correctly on redraw causing out-of-memory error.
* D-11444: All duplicated dashboards had same identifier.
* D-11483: Unnecessary Scroll bar displayed for system report.
* D-11402: Rename icon was using wrong graphic.
* D-11558: PA icons had small vertical-align problem.
* D-11559: PA  UI  did not use unique icon  for Export  functionality.
* D-11544: Datatable column names starting with lower case showed incorrectly in upper case.
* D-11495: Model specific DropUnusedModelsAfter-setting was not adjusted model's caching priority.
* D-11482: Importing table to itself using SqlDataFrame caused the SQL Server PA database to get partially stuck (until SQL server session is terminated).
* D-11458: Null reference error when ProcessingMethod is dataframe, ContextType is generic, and root is Cases.
* D-11487: ScriptById function did not return Access denied error if script id didn't exist.
* D-11497: Running script in web UI having ExecuteInClientSide=1 never completed.
* D-11461: Filtering didn't work in dataframe mode when StringifiedValues was used.
* D-11484: Script stayed in stopping state, when PA is shut down while script was running.
* D-11540: Column mappings didn't work with WithRowNumberColumn function in SqlDataFrames.
 
== Latest Release: QPR ProcessAnalyzer 2022.1 (build 774) (released 2022-01-24) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Known issue: If the "Drop Unused Model After" setting is specified for a model, the model may incorrectly be dropped from the memory when the memory consumption is high. As a workaround, set this setting to empty, so that the model is not dropped by itself. This incorrectly behaving setting will be removed from the software in the next release (D-11507).
</div>


'''Features:'''
===Fixed issues===
* B-06334: New dashboard component: textual labels can be added to dashboards.
* Snowflake Cortex based AI Assistant didn't show the results table. (D-14643)
* B-06324: Chart settings icon can be hidden in preview mode, and also icons visual layout has been improved.
* When percent stacking is used, Y-axis values are now shown as percentages in data label and tooltip. (D-14633)
* B-06494: Expression language: break and continue statements.
* Fixed issue where Label&Link component had sometimes unnecessary vertical scrollbar. (D-14685)
* B-06435: Web UI web page title in browser header simplified.
* Model validation showed incorrect error message for models with numeric duplicate case ID's. (D-14687)
* B-06535: Copyright year updated to 2022.
* In Workspace, scripts "View current run log" dialog didn't update log correctly when new entries were added. (D-14662)
* B-06466: Updated to Angular 13.
* Event type mapping in charts didn't work in object-centric models. (D-14620)
* B-06521: Frontend components have been updated.
* Model generation didn't work as transformation step using _system.ML.ApplyTransformation function. (D-14654)
* B-06448: Optimized Snowflake data import using Put command.
* Others aggregation has been removed from date type of dimensions because tables don't work with textual data in date columns. (D-14623)
* B-06481: Added support for project description field to expression language and Web API.
* Fixed issue in AI Assistant where using both Snowflake Cortex and OpenAI modes caused error. (D-14646)
* B-06491: Improvements for taking into use new SAP library.
* In User Management Effective permissions table, column filter incorrectly showed "true" and "false" as options. (D-14639)
* B-03053: Backend support for expression scripts permissions.
* Pivot table incorrectly showed "Numeric value is not recognized" error when Count or Unique count aggregations were used. (D-14559)
* B-06501: Translation updates for release 2022.1.
* 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)


'''Fixed issues:'''
===Other improvements===
* D-11462: Model notifications were not visible if there was notification containing dimensions.
* Added QPR ProcessAnalyzer API request ID to Snowflake queries to easily find matching query in Snowflake query history. (B-08839)
* D-11435: Links in model description showed "&" characters incorrectly.
* [[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)
* D-11447: Linked settings and variable mappings didn't work with flowchart.
* 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)
* D-11454: ScriptLauncher didn't work when only hostname was specified in ServiceURL.
* Added backend support for object-centric model filtering based on case-centric filter rules. (B-08836)
* D-11419: In CSV import, row number showed incorrectly in column count mismatch error message when file size was over 10MB.
* Frontend components have been updated. (B-08851)
* D-11425: In chart, Statistical calculation "Show change from previous" didn't show empty for first row.
* Backend components have been updated. (B-08852)
* D-11307: Transparent color was not working for chart layout setting.
* D-11439: Date format was changed in workspace when changing only the language.
* D-11423: Dropdown lists were shown partly out of screen in smaller screens.
* D-11477: Maximum rows in Root causes didn't have maximum limitation.
* D-11167: Removed unnecessary "_." structures from chart expressions.
* D-11470: Catch function failed with a constant expression and non-constant resultIfException expression.
* D-11429: There existed Undefined % and NaN value in Root Causes Analysis result.
* D-11343: Script log was written to wrong script when expression script calls SQL script.
* D-11377: Stdevp function incorrectly returned zero for array of one element.
* D-11255: Train function didn't work with only one case in training set.
* D-11413: Color picker cancel button didn't work.
* D-11414: Clicking context menu icon in projects hierarchy tree in Workspace to open sub menu, didn't do anything.
* D-11245: Removed not needed fonts.
* D-11453: Wrong font used for System reports.
* D-11455: Red color error message didn't use Open Sans font.
* D-11180: Workspace contextual menu icons vertical alignment was incorrect.
* D-11475: BPMN context menu hidden behind other frame when webpage zoom setting was bigger than 110%.
* D-11416: Context menu in projects hierarchy didn't open in Cypress tests.
* D-11115: Title of event type filter didn't display "&" character properly.
* D-11097: When clicking data grid input validation message, JS error appeared: TypeError: Cannot read property 'data' of null  at Gs.getRowInfo  at Gs.mouseClickHandler.
* D-11267: Unable to use datatables with columns names having square brackets.
* D-11243: Project LastModifiedDate and LastModifiedBy are now updated when project properties are changed.
* D-11457: There was useless error message when HTML error is get via Web API.


== Additional release for QPR ProcessAnalyzer 2021.9 (build 709) (released 2021-12-20) ==
== QPR ProcessAnalyzer 2025.5 (build 10361) (released 2025-08-21) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_5.pdf QPR_ProcessAnalyzer_2025_5.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;">
This release has brought back SQL Server 2014 support.
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>


'''Features:'''
===New features===
* B-06489: Restore support for SQL Server 2014.
* [[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)
* B-06257: Add new SAP data extraction connector library SAP NetWeaver RFC (preview feature).
* [[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)
* B-06443: Snowflake availability status is added to /api/serverinfo.
* [[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)


== QPR ProcessAnalyzer 2021.9 (build 700) (released 2021-12-14) ==
===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)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===Other improvements===
Starting from QPR ProcessAnalyzer 2021.9, ScriptLauncher uses Web API instead of legacy WCF API, and thus also the ScriptLauncher needs to be updated to 2021.9. In addition, in the ScriptLauncher configuration file, ''ConnectionType'' setting needs to be ''WebApi'' (the setting is in place in the 2021.9 release package). The new Web API based ScriptLauncher is not anymore dependent on the API protocol version, and thus starting from 2021.9, information about the protocol version is not published. The old ScriptLauncher using protocol version 39 still works with the 2021.9, but as the WCF API is deprecated, ScriptLauncher update is mandatory before updating to 2022.1.
* 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)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
== QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28) ==
When taking into use the Web API based ScriptLauncher, the ServiceUrl setting in the ScriptLauncher [[QPR_ProcessAnalyzer_ScriptLauncher#Configuring_ScriptLauncher|configuration file]] needs to be set differently: Previously it was enough to specify the server name (e.g. <nowiki>https://processanalyzer.onqpr.com</nowiki>), but now also the application path needs to be specified (e.g. <nowiki>https://processanalyzer.onqpr.com/qprpa</nowiki>). This issue will be resolved in upcoming release.
</div>
 
<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 2021.9, support for SQL Server 2012 and SQL Server 2014 has been dropped. See more in [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server|system requirements]].
</div>


<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_2025_4.pdf QPR_ProcessAnalyzer_2025_4.pdf]
The predefined analyses operations that QPR ProcessAnalyzer has traditionally been based on, are now deprecated and will be replaced by functionality provided by the expression language. In practice, the following features will be removed:
* [[SQL_Scripting_Commands#--.23GetAnalysis|--#GetAnalysis]] command in SQL scripting: If there are scripts using that command, replace them with the new [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] which uses the expression language to query data.
* [[DataFrame_in_Expression_Language#Extract_Data_to_DataFrames|Analysis]] function in expression language: If using that function, replace it with other functionalities provided by the expression language.
* POST /api/analysis/{analysisType} endpoint in the Web API: If using that endpoint in customized solutions, call the [[Web_API:_Expression/query|/api/expression/query]] endpoint instead.
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===New features===
QPR ProcessAnalyzer WCF API is now deprecated and it will not be available starting from 2022.1 release. All customized integrations and other solutions that use WCF API need to be converted to use [[QPR_ProcessAnalyzer_API|Web API]]. Note that there may also exist scripts that contact the WCF API using the [[SQL_Scripting_Commands#--.23CallWebService|--#CallWebService]] command. The used API can be distinguished from the url: if it contains "/MainService.svc" the connection is to the WCF API and changes are required.
* 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)
</div>
* Added a [[Filter_Selectors#Filter_selector|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 [[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)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===Fixed issues===
When installing 2021.9 server, note that there is a change in the web.config file, as httpRuntime element includes now targetFramework="4.7.1" attribute. Also, QPR ProcessAnanalyzer ScriptLauncher web.config has changed, as ''ConnectionType'' is now ''WebApi'' instead of ''Service''.
* 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)
</div>
* 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)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===Other improvements===
SQL scripting commands that create datatables and temporary tables, use now specific column data types (such as NVARCHAR(MAX), INT, FLOAT, DATETIME2 and BIT) instead of SQL_VARIANT. This may affect SQL commands that have relied on the SQL_VARIANT column type. For example, in joins there may be mismatches between data types, requiring explicit type conversion.
* Added expression language functions for using Snowflake Cortex Agents with Cortex Analyst access to query eventlogs. (B-08647)
</div>
* 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)


'''Features:'''
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9805) (released 2025-04-30)==
* B-03221: [[Process_Flowchart|Flowchart]] has been renewed.
* B-06378: Old flowchart has been removed.
* B-06317: --#runQuery to run expression queries in SQL scripts.
* B-06343: Bottleneck Flows preset is now sorted based on case counts and other visual improvements.
* B-06360: Model Manager view has been removed.
* B-06392: Enable ScriptLauncher to use Web API.
* B-06346: Expression optimization for finding first/last event of specific type in case.
* B-06399: Handling of simple requests has been optimized.
* B-06309: Datatable operations for Snowflake stored datatables.
* B-06413: Merge function for DataTables supporting SQL Server and Snowflake.
* B-06415: MatchByColumns mode for importing data to Snowflake stored datatables.
* B-06427: Append function for SqlDataFrames corresponding to UNION ALL in SQL.
* B-06397: Backend support for modifying Snowflake stored datatables.
* B-06408: Translation updates for 2021.9.
* B-06412: CalcTester and ScriptLauncher are combined.


'''Fixed issues:'''
===New features===
* D-11282: Some system presets for task log analysis were very slow.
* Navigation menu is now displaying dashboards from open dashboard's project or from selected Workspace project (earlier dashboards were shown from the selected model's project). (B-08673)
* D-11296: Data grid and pivot grid were showing "No records to display" when about to show content.
* D-11300: Following error appeared when doing logout when PA session was expired: Cannot read properties of null (reading 'find').
* D-11315: CSV export was missing from Root causes visualization.
* D-11316: Unnecessary error message appeared in login screen when user logged out quickly after opening the navigation menu.
* D-11274: Performance issue: pivot grid froze for a while during opening when there were lot of column.
* D-11350: In prediction, empty results should be shown when there is only one case in training set.
* D-11353: Incorrect expression existed in case measure "Event type count per case".
* D-11361: Cost input box was missing in Cost Savings by Automation preset.
* D-11379: Search by Case ID preset was not working.
* D-11290: Select Start or End filter from Bottleneck flow analysis result, Querying Variation error occurred.
* D-11302: Chart filter didn't have any effect on root causes analysis.
* D-11289: CSV import didn't warn about too long column names.
* D-11310: Custom layout settings for highcharts were not compatible with the pivot grid.
* D-11341: "Show for null values" didn't work in pivot grid.
* D-11346: Chart configuration validation failed if there was no expression defined above defined expression.
* D-11345: Some charts made in old version had nullValue=null which failed schema validation and showed error message when dashboard was opened.
* D-11349: Expression based filter rules could not be disabled.
* D-11326: Long project name string broke User effective permission layout.
* D-11344: Invalid column name error occurred While evaluating function "Collect" in context for Pivot grid.
* D-11387: Incorrect schema for "Table actions" caused error when opening dashboard.
* D-11369: In workspace, hovering script row in table increased row height.
* D-11224: In Workspace, sometimes when selecting row using checkbox, previous selections were unchecked.
* D-11301: Drag&drop object in the Workspace missed a visual feedback.
* D-11371: On-screen settings with multiple custom UI controls having same parameter name didn't work.
* D-11388: Donut chart didn't work with multiple measures.
* D-11261: Workspace column had sorting issue with empty date values.
* D-11285: Datatable with lot of columns and rows caused performance slowdown.
* D-11156: Unnecessary "This field is required" validation message existed in Manage Users dialog.
* D-11370: CSV file import didn't detect timezone in dates.
* D-11394: Workspace showed time incorrectly for 24h clock.
* D-11407: In dashboard, clicking Workspace button right after clicking save, gave unsaved changes message.
* D-11202: --#ImportDataTable did not create new columns when Append=1.
* D-11283: Backend incorrectly converted json strings that look dates to dates with different formatting.
* D-09499: When trying to use EventLog, CaseAttributes or EventAttributes properties in a loading script, clear error message was not given.
* D-11287: Sometimes incorrect error message was shown for query cancellation.
* D-11375: ProcessAnalyzer incorrectly ran with old .Net Framework runtime.
* D-11376: ModelMetaData was dropped from memory when there was memory pressure.


== QPR ProcessAnalyzer 2021.8 (build 614) (released 2021-11-02) ==
===Fixed issues===
* Fixed issue where AI Agent made unnecessary queries when filtering dashboard, and also opening dashboard with lot of chart may have been slow. (D-14503)
* When datatable columns were modified, queries to the data may have given "Invalid identifier" error. (D-14507)
* Clustering analysis didn't work with object-centric models. (D-14486)
* When a new groups is added, it's selected by default in the Manage Users dialog. Also clicking a selected group does not deselect it. (D-14491)
* Deleting last group didn't remove the group from the list. (D-14504)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9725) (released 2025-04-23)==
Known issue in 2021.8: Some dashboards created with earlier releases, may give following error when opened: ''Chart settings are invalid, and the chart may not work correctly. Type of property "measures/0/nullValue" must be string."'' Despite the error message, the dashboard still works correctly. The issue can be resolved by going through all charts in the dashboard and opening the ''Chart settings'' (in the ''Advanced'' tab). If the settings contain one of the following: ''nullValue: null'', ''emptyStringValue: null'', ''trueValue: null'' or ''falseValue: null'', replace them follows: ''nullValue: ""'', ''emptyStringValue: ""'', ''trueValue: ""'', ''falseValue: ""''. When changes have been made, save the dashboard and check that there is no error, when the dashboard is opened. This issue will also be fixed in the next release, and if decided to wait for it, there is no need to edit the dashboards.
</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;">
Known issue in 2021.8: Some dashboards created with earlier releases, may give following error when opened: ''Chart settings are invalid, and the chart may not work correctly. Property "expressionType" is required in dimensions/0."'' In addition to the error message, some charts in the dashboard may not work correctly. This issue appears if there are empty measures or dimensions ("none" selected) above defined measures or dimensions. The issue can be resolved by removing the empty measures and dimensions by clicking the ''Remove'' button for the measure/dimension. This may affect how the remaining measures and dimensions are mapped to the visualization, so the mappings may need to be adjusted in the measure/dimension settings. When changes have been made, save the dashboard and check that there is no error, when the dashboard is opened. This issue will also be fixed in the next release, and if decided to wait for it, there is no need to edit the dashboards.
There is an issue causing some dashboards having more than 50 charts to open slowly. The issue has been fixed in the next release by D-14503.
</div>
</div>


'''Features:'''
=== Fixed Issues ===
* B-06288: CSV file import can update existing rows in the datatable.
* Fixed issue where system stopped responding after opening Scripts tab several times (error in logs: Timeout expired prior to obtaining a connection from the pool). (D-14506)
* B-06281: User specific date format, first day of week and 12/24 clock can now be set separately from the language.
* Fixed issue where the object-centric models object types tables didn't work without the timestamp column. (B-08683)
* B-06291: Script log is refreshed automatically during the script run.
* Snowflake cache tables are now created after initiating calculation is completed to improve performance. (D-14460)
* B-06269: In Workspace, projects have been moved into a separate tab.
* Fixed issue in User Management where assigning role to project or adding user to group was not saved when there was a column filter. (D-14124)
* B-06213: Performance for numeric and date dimensions has been improved (by taking into use NumberPrecision and DatetimeTruncation parameters). Additionally, data type is now specified only for custom expressions, and for the custom dimensions, there is new setting "Date interval" for date values granularity (Truncate function is not used anymore).
* B-06316: Old data import view has been removed.
* B-06267: Blocking for brute force password guess attacks.
* B-06290: Expression optimization for pattern <aggregation function>(_.Attribute(<attribute name>)).
* B-06286: Backend support for date format, first weekday and 12-hour clock in server side.
* B-06262: Error codes added for different cancelling operation situations.
* B-06323: Added support for stored calculation sessions.
* B-06335: Frontend components have been updated.
* B-06327: Translation updates for PA release 2021.8.
* B-06221: .NET core migration: Thread.Abort calls are replaced with Thread.Interrupt.
* B-06349: ColumnTypes property for IDataFrame.
* B-06289: Enable ScriptLauncher to use Web API - improvements.


'''Fixed issues:'''
== QPR ProcessAnalyzer 2025.3 (build 9699) (released 2025-04-16)==
* D-11257: Sometimes date axis marks didn't match with data points.
* D-11136: In prediction preset, when all cases were filtered out, there was error "Index was outside the bounds of the array".
* D-11284: When viewing datatable contents, float type of columns are now shown in two decimals.
* D-11242: When dashboard was opened, it might have initially been in the scrolled down position.
* D-11116: Validation was missing when dashboard is imported from file.
* D-11252: Benchmark performance did not have input value limitation check for Repeat benchmarks.
* D-11219: Workspace tabs did not use Open Sans SemiBold correctly.
* D-11213: Dashboard Save button text was not well aligned vertically.
* D-11225: BPMN context menu stayed on screen when other functions were used.
* D-11199: CSV import validation process continued forever when the file had format error.
* D-11134: Two popup menus were displayed at the same time in the Workspace.
* D-11178: Underline of tabs was in the wrong order.
* D-11179: Checkbox at the table header was misaligned.
* D-11173: Some icons had visual defects.
* D-11160: Workspace item name create/rename validation failure was not clear.
* D-11211: Following error appeared: Could not convert object of type 'System.String' to type System.Collections.Generic.List.
* D-11262: Query designer didn't work in the dataframe mode if "dataframe" was not written in lowercase.
* D-11299: Importing timestamps from CSV that didn't exist in the local time, was incorrectly incremented by one hour.
* D-11263: Model was incorrectly loaded into memory event though query is run in dataframe mode.
* D-11227: "Self referencing loop detected ..." error for weighted root caused when there was expression filter with NumberPrecision.
* D-11170: Error: "Unable to set the value of an uninitialized variable var1 due to variable not being defined inside the current parallel context".
* D-11089: Querying same column multiple times omitted the duplicates from the response in SQLDataFrame.
* D-11247: Filtering numeric values gave incorrect results near zero.
* D-11198: Models where MOD_LAST_MODIFIED_DATE is null could not be deleted or modified.
* D-11230: Removed hardcoded allowed TLS versions from software.
* D-09453: Boolean values didn't work with EventAttributeValue filter.
* D-11256: Importing data to datatable having data and with previously created column created new columns as sql_variant.
* D-09452: Designed exceptions in running expressions shouldn't be logged as errors.
* D-11050: Time information was missing in error message.
* D-09497: Duplicate and empty column names gives now better error message in ODBC data source model.
* D-11113: Stopping never ending expression calculation did not stop processing.
* D-11226: Operation end time was not recorded when operation was canceled.
* D-11258: WriteLog function didn't write to script log if function call was in sub scope.
* D-11171: Log level for aborted operations should be info.
* D-11228: Entries were written to the script log twice.


== QPR ProcessAnalyzer 2021.7 (build 535) (released 2021-09-21) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_3.pdf QPR_ProcessAnalyzer_2025_3.pdf]
'''Notes:'''


<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 is now fully web browser based software, and so QPR ProcessAnalyzer Excel Client is not released anymore. If you have any issues in switching over to the web UI, please give us feedback through customercare@qpr.com and describe your process mining use case.
There is a potentially serious issue that can cause the system to stop responding, when opening the Scripts tab in the Workspace. The issue has been fixed in the next release (build 9725) by D-14506.
</div>
</div>


'''Features:'''
* B-05991: Models can be managed in the [[QPR_ProcessAnalyzer_Project_Workspace#Models|Workspace]] in a new tab.
* B-06212: [[Image|Images]] can be added to dashboards.
* B-05926: Presets performance can be [[Navigation_Menu#Benchmark_Performance|benchmarked]] with one click and results report can be export.
* B-06230: When duplicating elements in dashboards, now the width and height of duplicate stays same.
* B-05994: Duration datatype is now supported when importing data to datatables.
* B-05857: Implement expression language function to remove all preprocessings from model.
* B-06203: Translations for release 2021.7.
* B-06206: Web API: Existing datatable rows can be updated in CSV import (UI support implemented later).
* B-06207: Web API: Support for startFromPosition parameter to get last entries of the current script run log (UI support implemented later).
* B-06208: Exception codes implemented for usual exceptions returned by server (UI support implemented later).
* B-06265: Enable ScriptLauncher to use Web API (1).
* B-05856: Enable ScriptLauncher to use Web API (2).
* B-05848: Model loading has been refactored in backend.
'''Fixed issues:'''
* D-11188: CSV file import didn't work with negative numbers.
* D-11210: In boxplot presets, "no outliers" minimum/maximum might incorrectly have been lower/greater than the real minimum/maximum.
* D-11183: Chart datalabels showed wrong numbers for some presets.
* D-11175: Single select list was not updated when value was set from multi select list through variable.
* D-11099: Operation log for open operations does not now show the current operation.
* D-11206: Underscore before attribute function call caused some parse tree pattern matchers to not work.
* D-11155: Caching is now disabled when switching between tabs in Workspace.
* D-11161: Font was broken in the contextual popup menu.
* D-11165: Dropdown list values were not updated when changing preset.
* D-11177: Data grid excel filter item selection unselected checkbox layout was incorrect.
* D-11184: Unclear error information when tried to feed string value to Highcharts when value should be numerical.
* D-11189: Nothing happened when clicking Delete dimension when there were no dimensions.
* D-11166: All text type filter should have "Not Contains" option.
* D-11220: Shuffle function was incorrectly constant foldable.
* D-11185: Filtering didn't work for charts using variables in columns and row initialization expressions.
* D-11190: When deleting or modifying expressions, non-matching on-screen settings are now removed to avoid errors.
* D-11207: Javascript error "RangeError: Maximum call stack size exceeded" when clicked empty data grid rows area in Notifications and Business calendar.
* D-11208: When very small percentage of cases are shown, the header showed ".00" (now it shows ≈0%).
* D-11203: Removing parameters from url went to login page without clearing session and showed unnecessary error message.
* D-11138: Javascript error in console: "Cannot read property 'column' of undefined at Gs.cellSelecting".
* D-11200: Unselecting selected cell in table didn't hide the suggested filter.
* D-11215: There was a javascript error when selecting a range of two or more cells in the same line and then click any cell.
* D-11090: User terminated expression scripts didn't write to log.
* D-11172: Path until selected event analysis caused "Variable already exists in context" error.
* D-11162: DatetimeTruncation parameter didn't work with null values in filters.
* D-11060: Concurrency issue resolved with Clustering Cases analysis.
* D-09496: All needed parameters were not not passed to expression parsing.
* D-11204: Preset CasesByDurationBetweenEvents was failing in Snowflake.
* D-11218: Cancellation flag was not used correctly when checking if operation was cancelled.
== Additional release for QPR ProcessAnalyzer 2021.6 (build 474) (released 2021-08-25) ==
'''Notes:'''
<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;">
There is a change in the expression language behavior, as now existing variables cannot be reinitialized using the '''let''' operator. Thus, an error is given, if there is already a variable with the same name in the same scope. The new behavior reflects better how programming languages usually work, and also it's able to spot likely bugs in expression scripts.
Object-centric model simplification in the story B-08667 (object attributes can only have a single value) doesn't work with this release. The issue has been fixed in the next release (build 9725) by B-08683.
</div>
</div>


'''Features:'''
===New features===
* B-06245: Performance issue: Separate eventlogs were sometimes still created when drilling down in dashboards.
* Enhanced [[AI_Agent|AI Agent]] with UI for editing prompt datasets, and added checkbox to include other charts in dashboard to prompt. (B-08641)
* B-05937: Trying to initialize existing variable in the same scope gives now error.
* In [[Object-centric_Process_Mining_Model|object-centric models]], object-to-object relations are now followed by traversing once all object types. (B-08606)
* B-03091: Columns of the datatables stored to SQL Server use now specific data types instead of SQLVARIANT.
* In object-centric models, event type and object type tables are not mandatory anymore, and common attributes can be specified in events and objects tables. (B-08663)
* B-06205: Frontend 3rd party components have been updated.
* Object-centric models support simplified structure where object attributes can only have a single value. (B-08667)
* B-06021: Server logging has been improvement.
* "Object relation steps" setting can be empty to traverse all linked objects in the object-centric model. (B-08668)
 
* Snowflake Event Types preset has been improved by adding suggestion of desired and undesired activities based on frequency of occurrence. (B-08656)
'''Fixed issues:'''
* Added checkbox for [[Measure,_Dimension_and_Column_Settings#Advanced_settings|disabling filtering]] for individual dimensions or columns. (B-08589)
* D-11094: In datatable import dialog, emptying datatable column name field didn't take effect.
* Case and event attributes dropdown lists show number of unique values in Snowflake models (instead of attribute datatype as previously). (B-08316)
* D-11159: In chart, opening datatables list in "Datatable contents" gave error.
* [[SAML_2.0_Federated_Authentication|SAML authentication]] can now synchronize user groups from identity provider. (B-08612)
* D-11056: Table sorting using context menu didn't work.
* Groups can be [[Manage_Users_and_Groups#Deleting_Group|deleted]] in user management. (B-08330)
* D-11157: "Not contains" filter didn't work and rule didn't show any text in header.
* [[Storing_Secrets_for_Scripts|Secrets]] can be defines as global that can be used by all projects. To set global secrets, [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret|SetSecret]] function works also in the generic context. (B-08599)
* D-11158: There was an incorrect html encoding in multiselect list label.
* Snowflake [[Clustering_Analysis|Clustering analysis]] shows now number of event occurrences as features describing clusters. (B-08353)
* D-09506: In pivot table, export created incorrect Excel file from zero values.
* Model validity check has been extended to find issues in the eventlog data for Snowflake case-centric models. (B-07910)
* D-11078: In pivot table, selection caused javascript error when mouse was released over cell value.
* D-11147: For json type of error responses Content-Type should be "application/json; charset=utf-8".
 
== Additional release for QPR ProcessAnalyzer 2021.6 (build 460) (released 2021-08-19) ==
'''Features:'''
* B-06211: Performance improvement: Reuse event objects in all eventlogs of the model (event level calculation performance is doubled).
 
'''Fixed issues:'''
* D-11146: Filter calculation on dashboards using large model with several charts slowed down due to unnecessary duplicate eventlog generation.
* D-11145: "Not contains" option was missing from Excel filter sub menu, and filter type was not filled automatically in Custom filter dialog.
* D-11121: There was an unclear error message "Conformance statistics cannot be calculated" in Conformance statistics component.
* D-11152: There was an unnecessary separator in projects menu in models list.
* D-11150: There was a date conversion issue in CSV import related to number parts with leading zeros.
* D-11119: DataGrid Excel export didn't work with the "substitute character".
* D-11129: Case nonconformancies root tried to declare variables twice.
* D-11151: Some number conversions were incorrect in CSV import.
* D-11153: Decimal separator could not be specified for duration type of columns in the CSV import.
* D-11154: Client side validation didn't work for duplicate user and group names.
 
== QPR ProcessAnalyzer 2021.6 (build 444) (released 2021-08-10) ==


'''Features:'''
===Fixed issues===
* B-05859: CSV file import is renewed and available in the Workspace (old import is still available).
* Fixed a potential issue which could have leaked database connections and caused connection pool starvation. (D-14414)
* B-05988: Charts can be duplicated when editing dashboards.
* Renewed self-signed certificate used by SAML 2.0 authentication with ten years of validity. (D-14424)
* B-05969: Not contains -type of column filter is available in tables.
* Improved CallWebService function to send request body when using DELETE method. (D-14488)
* B-03225: If user is authenticated with SAML, password changing is not available.
* Login page now shows correct error message when there are serious system errors during login. (D-14480)
* B-03232: In dashboard export files, chart settings are stored as presentation object property instead of context variable.
* "Datatable contents (in-memory)" option now works also with Snowflake datatables. (D-14391)
* B-05982: Workspace context menu improvements.
* Added maximum data size limitation to AI assistant to avoid error with large datasets. (D-14419)
* B-05950: Allow empty value in first column in CSV file import.
* Day of the Year/Week/Month/Quater selection didn't work with specific event time in in-memory chart. (D-14421)
* B-05860: Frontend component update (part 2).
* KPI card now shows a scrollbar when content doesn't fit to the available space. (D-13428)
* Workspace projects hierarchy tooltips didn't show special characters correctly. (D-14430)
* BPMN editor crashed when creating filter from tasks giving following error: Cannot read properties of null (reading 'querySelector'). (D-14399)
* Value expressions didn't work that are referred in dimension and containing aggregation. (D-13624)
* Fixed issue where object-centric flowchart filter selection gave error when case-centric model was selected. (D-14408)
* Fixed issue where query to non-existing model incorrectly returned "Sequence contains no elements". (D-14402)
* Incorrect StringifiedValues in chart settings and expression filter rule caused UI to stuck. (D-14485)
* Table column filter value list didn't show the null value label correctly. (D-13844)
* "Visualize list items with colors" setting didn't work with the "Last Row Aggregates Over-limit Rows" setting. (D-14357)
* Made sure that failed queries are not added to model filter cache. (D-14484)
* Chart settings crashed when trying to use without model selected giving following error: Cannot read properties of undefined (reading 'injectValue'). (D-14395)
* Fixed issue where chart settings opened on top of full screen BPMN editor. (D-14472)
* Show details button in some error messages didn't have any effect when pressed. (D-14490)
* Model validation message was incorrect for model where other datatable is Snowflake and other SQL Server. (D-14475)


'''Fixed issues:'''
===Other improvements===
* D-11107: In Workspace, when new project, datatable or script is clicked, the name text was highlighted by default.
* Logging has been set to Warning level for Native App to avoid excessive number of log entries to Snowflake events table. (B-08687)
* D-11106: Query cancellation suppression didn't work when cancellation was in the inner exception.
* Datatable duplication is now synchronous in Snowflake until 30 seconds to avoid showing the created duplicate datatable with zero rows while the operation is still in progress. (B-08634)
* D-11118: Issues with Dropdown list selector: (1) dates as variable values are handled incorrectly, (2) list refreshes unnecessary when activated.
* Improved Snowflake cache table creation logic when there are multiple simultaneous queries. (B-08622)
* D-11117: Case attribute and event type filters lists incorrectly made queries already when dashboard is opened.
* Refactored SQL Server operations to improve robustness and avoid leaking database connections. (B-08649)
* D-11053: All texts didn't fit to screen in Syncfusion grid Excel filter when using e.g. Russian.
* Frontend components have been updated. (B-08638)
* D-11075: Datatable didn't open after creation from UI.
* Backend components have been updated. (B-08639)
* D-11105: Wrong color in Clear Filter icon in data grid Excel filter.
* Translations have been updated. (B-08640)
* D-11092: Code editor should not show errors for correct code.
* D-11104: When context menu is opened for project that is not previously selected, hierarchy was scrolled.
* D-11095: For json type of error responses Content-Type is now application/json.
* D-11071: Web API could still return datatables with null configuration.
* D-11098: Small layout issue fixes.
* D-11133: Submenu of "Move to" is opened at the top-left corner.


== QPR ProcessAnalyzer 2021.5 (build 389) (released 2021-06-23) ==
==Additional release for QPR ProcessAnalyzer 2025.2 (build 9476) (released 2025-03-19)==


'''Features:'''
=== Fixed issues ===
* B-05846: Datatable contents can be previewed, and also new system reports dialog.
* Fixed issue where charts axis labels had unnecessary line breaks on spaces. (D-14413)
* B-03233: Improved UI for chart background color, border color, border width and border corner radius.
* Fixed issue where AI Agent and LLMComplete function didn't work in Native App. (D-14410)
* B-05852: New presets for intelligent process automation and boxplot visualizations.
* Fixed translations for Workspace Scripts tab column filter for Status and Result columns. (D-14393)
* B-05828: Actions for tables to change dashboard variables.
* Fixed issue where Volume Distribution of Flow Analyzed object type didn't work. (D-14390)
* B-05853: Scripting supports also scripts written in the expression language.
* Removed reference to fonts.googleapis.com for stylesheets to avoid content-security-policy error. (D-14373)
* B-05093: Workspace visual layout has been improved and context menu is available also for projects, dashboards and datatables.
* Syncfusion dialog headers now show special characters correctly. (D-14407)
* B-05922: Component filter for case attribute and event type selectors.
* Object attribute filter gave null reference error when object type didn't exist in model. (D-14379)
* B-05847: Presets performance improvements: Digital fit rate by attribute, Path until selected event, Path starting from selected event.
* B-05836: Changed "Automation opportunity scout" to use even types as basis and implement optimizations.
* B-05825: Better performing method to get event type names in model.
* B-05821: Improved backend performance by removing unnecessary ToArray calls.
* B-05817: Backend support for running expression scrips in web UI.
* B-05855: Running expression scripts in ScriptLauncher.
* B-05946: Data type conversions for CSV import.
* B-05944: CSV file writing for expression script through ScriptLauncher and client side execution using expression scripts.
* B-05827: Distributed computing, part 8: SqlDataFrame support for locally stored datatables.
* B-05850: Distributed computing, part 9: External table naming, data table import refactorizations, generic context.
* B-05849: Distributed computing, part 10: Improvements and preparations for performance tests.
* B-05840: Frontend components have been updated.
* B-05935: Translations for 2021.5 release.


'''Fixed issues:'''
==QPR ProcessAnalyzer 2025.2 (build 9410) (released 2025-03-05)==
* D-11084: Syncfusion pivot table headers were not visible.
* D-11085: Tooltip in chart settings were stuck open in some occasions.
* D-09524: Polar chart showed wrong tooltips value and graph was shown incorrectly if polar chart disabled and enabled again.
* D-11007: Workspace grid showed shortly incorrect content.
* D-11030: Javascript error: "TypeError: Cannot read property 'length' of null" when returning to workspace.
* D-11042: Release package was much larger for 2021.4 than for earlier releases due to unnecessary Monaco editor files.
* D-11051: Negative timespans returned by server don't work in UI.
* D-11052: Number of cases not updated when removing ModelId from dashboard properties.
* D-11054: Background color conditional formatting didn't work for non-numerical columns.
* D-11055: Extra space appeared in header when changing model and opening filters list.
* D-11058: Expression filters didn't work due to single quotes don't work anymore.
* D-11059: On-the-fly migration for existing stored expression filter rules using single quotes.
* D-11068: When zooming and moving flowchart, following console error appeared: TypeError: Cannot read property 'behavior' of undefined.
* D-11073: Chart image export should have same scale as in the dashboard.
* D-11072: Index out of bounds error in Flow Duration analysis view.
* D-11074: Dragging root causes rule from header to chart sets invalid Comparison variable breaking dashboard.
* D-11045: Web UI incorrectly fetched resources from fonts.googleapis.com.
* D-10988: Pivot table javascript error: Uncaught TypeError: Cannot read property 'refreshFrozenScrollbar' of null.
* D-09594: Pivot table: Adjust browser size for event count analysis: Type Error: Cannot read property 'getPanel' of null occurred.
* D-11043: Deleted scripts caused error if they are in the script editor tab.
* D-11063: Datatable.Columns gave error for new datatable.
* D-11064: XES import does not always import event attributes.
* D-11067: Copying datatable that has configuration=null leads to inconsistent copied datatable.
* D-11076: Moving script to project didn't work.
* D-11044: Negative timespans were serialized incorrectly as positive.
* D-11027: SQL query failed because connection was closed by deadlock.
* D-11057: Optimization Where(Attribute(<constant 1>) == <constant 2>) works incorrectly.
* D-11040: All expression lexing errors were not handled.
* D-11019: Improve following unclear error message: "Selection failed: Unknown case attribute for object of type AttributeType: name".
* D-11082: Filtering didn't work when clicking cell text for cells using conditional formatting.
* D-11080: Clustering Analysis view had TypeError: Cannot read property 'field' of undefined.
* D-11087: Improved unclear error message:  Nullable object must have a value.
 
== QPR ProcessAnalyzer 2021.4 (build 328) (released 2021-05-18) ==
 
'''Notes:'''
 
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
There is a breaking change in 2021.4 related to using tags in custom expressions: If a tag provides a string value, before it was written e.g. ''Attribute("<#AutomationAttribute>")'', but now it needs to be written ''Attribute(<#AutomationAttribute>)'', because the quotation marks of the string literal now come with the value replacement. The former will cause error in 2021.4, as there will be two sets of quotation marks. This problem does not concern other type of values (e.g. numeric), as they don't have quotation marks.
</div>


<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_2025_2.pdf QPR_ProcessAnalyzer_2025_2.pdf]
Scripts that are stored to the ''model'' or ''user'' context are not available in the scripting web UI (scripts in ''project'' and ''system'' context are available). If you have scripts in the model or user context, they need to be recreated in the project or system context using the Excel Client latest in 2021.4. Starting from 2021.5, scripts in the model or user context are preserved in the system, but cannot be used anymore (and they will be removed in a future release).
</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;">
Tables used in dashboards are updated to the next generation of Syncfusion JS2 components. The [[QPR_ProcessAnalyzer_Chart#Visualization_Settings|Custom layout]] settings (defined as JSON) of the table might not be compatible between the generations, and thus they need to be changed manually after updating to 2021.4. See instructions how to migrate settings between the generations of the component: https://ej2.syncfusion.com/documentation/grid/ej1-api-migration/.
Detection of models with incomplete datasource configuration has been improved, and now models where the event timestamp column type is string, are not anymore considered valid models. Earlier the string type of data was accepted and converted into dates when model was loaded (for in-memory models) or in SQL queries (in Snowflake models).
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
The following query can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] (with System administrator user) to list models where the events datatable timestamp column type is string:
Starting from QPR ProcessAnalyzer 2021.4, the Data Grid Export Service (used for exporting tables as Excel files) is not needed anymore. The renewed table is able to create export files in the browser side without using any server/cloud side service. If the Data Grid Export Service has previously been installed, it's recommended to uninstall it for security reasons (to reduce attack surface).
<pre>
Models.Where({
let timestampColumn = _.Configuration?.TryGetValue("Datasource")?.TryGetValue("Events")?.TryGetValue("Columns")?.TryGetValue("Timestamp");
return First(_.EventsDatatable?.Columns?.Where(Name==timestampColumn))?.Datatype == "String";
}).(Name + " (id: " + Id + ")");
</pre>
</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;">
There is a new step in the QPR ProcessAnalyzer server installation instructions for allowing large process mining models: [[Installing_QPR_ProcessAnalyzer_Server#.Net_Configuration:_gcAllowVeryLargeObjects|.Net configuration: gcAllowVeryLargeObjects]]. The change should also be done for earlier QPR ProcessAnalyzer server versions if using models that have more than 50 million events.
For Snowflake dashboards, table actions to [[QPR_ProcessAnalyzer_Table#Table_actions|set dashboard variables]] now set the variable values in the [[Stringified_Value_Format|stringified format]] instead of as raw values. This makes the variables set by table actions compatible with the [[Chart_Linked_Settings|linked settings]] which also use the stringified format by default for the Snowflake models.
</div>
</div>


'''Features:'''
===New features===
* B-03297: Scripting is available in the web UI.
*Introduced [[AI Agent]] which is a new dashboard component showing LLM generated answers based on user prompt and input data. (B-08556)
* B-03231: Recycle bin for models and projects is available in the web UI.
*Added [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering by object attributes]] for object-centric models. Filters can be created from dialog or selecting items from charts. (B-08547)
* B-05764: Table component in dashboards has been upgraded to newer generation of Syncfusion JS2.
*In object-centric models, object-to-object relations are followed only forward and backward directions. Additionally, there are performance improvements for object-centric models. (B-08577)
* B-05814: There are now default parameter values for most preset.
*Snowflake warehouse can be [[QPR_ProcessAnalyzer_Project_Workspace#Change_Snowflake_Warehouse_for_Model|specified for each model]] allowing to use optimal type of warehouse for different sizes of models. (B-08610)
* B-05812: Optimize "Automation opportunity scout" preset and remove root items duplicate removal from dimensioning
*Home screen has been removed, and [[QPR_ProcessAnalyzer_Project_Workspace|Workspace]] has new card layout and other UX improvements. (B-08541)
* B-05769&B-03081: "Cost Savings by Automation" preset performance has been improved.
* Added [[Filtering_in_QPR_ProcessAnalyzer#Saving_filters|filter description]] field to filter properties dialog. (B-08451)
* B-05745: Functions CaseByName and Reverse, and improved support for TimespanPrecision/DatetimeTruncation.
*Removed event type existence check from charts, so that non-existing event types are allowed. (B-08585)
* B-05750: Expression language functions for managing datatables.
*Snowflake Native App configuration data can be [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Backup_configuration_data|backed up to a snapshot and restored]]. (B-08591)
* B-05800: Improvements to SQL script log writing.
*Improved detection of invalid models by adding [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CheckModelValidity|CheckModelValidity]] function returning model validation errors. (B-08426)
* B-05083: Expression language scripting.
* B-05789: Expression language scripting: Run expression language scripts using Run function.
* B-05799: Expression language scripting: Run SQL scripts using Run function.
* B-05752: Delete multiple items at the same time: Recyclebin.DeletePermanently().
* B-05082: Distributed computing, part 5: Improving KPI analysis expressions and data import.
* B-05762: Distributed computing, part 6: Improvements related to imports to external distributed computing systems
* B-05790: Distributed computing, part 7: Filtering etc.
* B-05775: Translations for PA 2021.4 release.


'''Fixed issues:'''
===Fixed issues===
* D-11008: "The given key was not present in the dictionary" still appears in dashboards.
*Prevented following error in Snowflake dashboards: Object "qprpa_dt_cache_..." already exists when creating a cache table. (D-14348)
* D-11034: Business calendar calculates incorrectly.
*In-memory chart "Cases filtered by attribute" didn't work for date type of attributes. (D-14387)
* D-10987: Filtering doesn't work from dimensions that need to use root expression.
*Fixed issue where each dashboard element resize made element width or height increase when chart margin was more than zero. (D-14361)
* D-10959: Unsaved change confirmation Russian translation  has "% 0" in message.
*Chart related buttons are now hidden in datatable content preview. (D-14360)
* D-10993: Column chart not working in Measure settings.
*Fixed issue where gateway based data import didn't write SAP errors into script log. (D-14351)
* D-10978: PA WebUI:  incorrect Case Level Permission expressions prevent using Model manager.
* Snowflake chart gave error when "Last Row Aggregates Over-limit Rows" setting was used with list aggregation. (D-14352)
* D-10984: Model cannot be used when in model json settings Permission.Case="".
*"Users" system report performance has been improved by adding EffectivePermissionTypesFor function. (D-14266)
* D-11010: Chart comparison cannot be created from header root cause analysis.
*Fixed issue where AI Assistant crashed when used with a model having ODBC or expression datasource. (D-14340)
* D-09533: Table column width changes back to default.
*Fixed issue where AI Assistant explaining charts crashed when applying to Label component. (D-14344)
* D-09509: Datatable multi-selection:  Uncaught TypeError: this.selectedRowCellIndexes[_].cellIndex.push is not a function.
*Improved client-side import not to perform redundant datatable configuration data queries. (D-14347)
* D-09521: Columns in wrong order for some of the periods in Event Count Trend by Types preset.
*Model was incorrectly identified as in-memory model when datatables were missing. (D-14325)
* D-09507: Tooltips for chart table columns shown far away from the column.
*Model default filter is now in use when model is opened from Workspace. (D-14376)
* D-11004: Error: Uncaught (in promise): Error: Dataset doesn't contain column "measure0".
* D-10970: Parameter define controls should display for full size Duration analysis view.
* D-11013: TypeError: Cannot read property 'querySelectorAll' of null.
* D-11018: Case duration exclude cases filter has wrong text in header.
* D-11021: BPMN editor console warnings: "Passing callbacks to is deprecated and will be removed in a future major release".
* D-11001: Filter option and checkbox display in two rows.
* D-09593: TypeError: Cannot read property '0' of undefined.
* D-10999: Error: <rect> attribute width or X: Expected length, "NaN".
* D-11012: Tooltip still shown after moving criteria for finding root causes  from header.
* D-10972: Include and exclude dropdown list cannot display properly when analysis view display in fullscreen.
* D-11020: Boxplot filtering by clicking does not work.
* D-10992: PDF generated in Chart settings shows some info twice.
* D-09513: When changing model and chart settings contain case/event attribute that doesn't exist in the model, error is given.
* D-11023: All mappings in Measures tab not shown when changing to Box Plot Chart.
* D-11024: Error messages not in logical order for missing values when drawing charts.
* D-10994: Empty popup for dashboard link going to a non-existing dashboard.
* D-10961: TypeError: Cannot read property 'refreshUI' of null.
* D-11026: Unsupported BPMN node types should not be selectable.
* D-11035: Table column resize causes never ending loading animation.
* D-11036: Chart settings doesn't open, if configuration has non-existing preset definition.
* D-11000: Model is incorrectly dropped first time some Permissions Expression data is added.
* D-10990: System.ArgumentException thrown on model loading from HashSet.SetCapacity.
* D-10977: Dimension rounding works incorrectly in expression filters.
* D-11003: Model JSON configuration related error to cases datasource.  
* D-11005: Error shown in some situations after empty string Permissions expression has been removed.


== QPR ProcessAnalyzer 2021.3 (build 263) (released 2021-03-30) ==
===Other improvements===
*Changed Snowflake charts to store [[QPR_ProcessAnalyzer_Table#Table_actions|variable change actions]] in stringified format to make them compatible with linked settings. (B-08587)
*Backend support for [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|object-centric filter rules Disabled flag]]. (B-08611)
*Implemented Entity Framework based database initialization and migrations. (B-08566)
*Added support for following Entity Framework database providers: SQL Server (full), Snowflake Hybrid Tables (experimental), PostgreSQL (experimental). (B-08581)
*Frontend components have been updated. (B-08597)
*Backend components have been updated. (B-08596)
*Translations have been updated for release 2025.2. (B-08607)


'''Features:'''
==QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23)==
* B-03242: Sampling for the analyzed objects of the chart.
* B-03239: Chart settings visual improvement and reorganization (migration to Syncfusion JS2).
* B-03307: Miscellaneous improvements to Workspace.
* B-03075: Models are kept in memory when settings are changed (excluding datasources and calculated attributes).
* B-03079: Improvements to model JSON configuration for Case/EventAttributes.
* B-03308: In Query Designer, ContextType should be "Model", when ProcessingMethod is "DataFrame".
* B-05075: Script entities are accessible in the expression language.
* B-03302: Scripting backend changes: Single state for scripts.
* B-05079: API for creating and editing scripts.
* B-05074: Frontend components update.
* B-05077: Support for scripts in POST /api/uielements/setproject/{projectid} and DELETE /qprpa/api/uielements.
* B-03296: API for recycle bin.
* B-03315: Distributed computing: Streamlining dataframe based KPI analysis configurations.


'''Fixed issues:'''
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_1.pdf QPR_ProcessAnalyzer_2025_1.pdf]
* D-10965: "The given key was not present in the dictionary" error when calculating expression referring to attribute values.
* D-10985: SAML service provider self-signed certificate is renewed.
* D-10976: Donut showed slices in incorrect order.
* D-09534: Filters were not working correctly in some cases.
* D-10974: Median aggregation didn't work in table conditional formatting.
* D-10962: Tables conditional formatting referring to other columns, didn't work.
* D-10963: Chart table web links should not encode tag if it contains entire url.
* D-09581: Fix for error: Cannot read property 'length' of undefined.
* D-09589: The error message is now more specific in the "no access" case.
* D-09592: Fix for error: TypeError: Cannot read property 'querySelector' of null.
* D-09518: Stacking for Column Pyramid Chart alignment issue.
* D-09597: Case attribute and event type filter components are not showing counts and visualize items without cases.
* D-09591: Server required To field information to send a notification.
* D-09494: Username and setting was missing in ScriptLauncher logs.
* D-09535: TakeSample function should not decrease performance when sampling is not needed.
* D-09580: TakeSample function should support DataFrames.
* D-09610: Expression based greater/lower than filters don't show texts in header.
* D-09601: Filter rule editor bugs: wrong counts and existing filters not taken into account.
* D-09606: Flowchart doesn't show loading spinner.
* D-09609: JavaScript error when opening flowchart for the first time.
* D-10960: Client side query cache should be cleared when model is dropped, reloaded or model settings changed.
* D-10967: Missing translation for "Select All" filter option.
* D-10969: Fix for error: SyntaxError: Unexpected token u in JSON at position 0.
* D-10979: Browser log should not contain informational messages.
* D-10982: Model properties has problem to get new added datatables for CASE and EVENT Datasources.
* D-09522: Uncaught TypeError: Cannot read property 'call' of undefined.
* D-09911: Turn off filter rule will cause i[e][a] is not iterable at Function.compactFilterRules error.
* D-09510: Clicking workspace button or switching between editor modes don't close chart settings.
* D-09519: Chart configuration validation doesn't show error message.
* D-09603: ERROR TypeError: Cannot read property 'getConfiguration' of null.
* D-09525: Search line is not under the search string for filters in Query Designer.
* D-09441: "In" function doesn't work with different integer types.
* D-09612: "In" function doesn't work when written in lower case.
* D-09586: CSV file import failed.
* D-09595: Query cancellation doesn't work in /api/expression/query.
* D-09440: User management web API doesn't write to operation log.


== QPR ProcessAnalyzer 2021.2 (build 215) (released 2021-03-03) ==
===New features===
*B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
*B-08530: Charts can have a [[QPR_ProcessAnalyzer_Chart#Visual_Settings|description text]] which are shown in a dialog when pressing the info button.
*B-08546: Added [[SQL_Expressions#LLMComplete|LlmComplete]] function to access Snowflake Cortex large language models.
*B-08439: Added project settings [[QPR_ProcessAnalyzer_Project_Workspace#Project-level_Snowflake_Database_and_Schema|DatabaseNameInDataSource and SchemaNameInDataSource]] to define Snowflake database and schema.
*B-08531: Projects can be created in expression language using [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateProject|CreateProject]] function.
*B-08387: Added backend support for object-centric model [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering for object attributes]].


'''Features:'''
===Fixed issues===
* B-03237: Dialog for defining email notifications.
* D-14339: Week numbers showed incorrect year for last dates in the end of year.
* 308126: Dialog for defining business calendars and using business calendars in charts.
*D-14323: Filtering with "Split data by filtering" dimension didn't work with exclude type of filter rules and when there were multiple filter rules.
* 308087: Datatables can be renamed and duplicated.
*D-14346: Fixed issue where manual activation using activation utility didn't work.
* 308090: Model settings dialog renewed, new dialog for calculated attributes, dialog for editing filter rules renewed, model duplicating.
* D-14326: Fixed issue where extra columns in objects table broke object-centric model.
* B-03292: Support for Polish language.
*D-14306: Fixed issue when there were both TimeStamp and ToTimeStamp event data columns.
* B-03265: Automatic license reactivation.
* D-14332: Flowchart event type and flow queries are now simultaneous which will improve performance.
* B-03314: Triggering email notifications using expression language.
*D-14331: Flowchart lost selection when flowchart used linked variables with array values.
* 308094: BPMN models are validated in the BPMN editor.
*D-14299: Table text filters didn't work in Snowflake (starts with, ends with, contains).
* B-03293: TakeSample function to expression language.
*D-14338: Model.Modify function generated model json configuration that frontend wasn't incompatible with.
* B-03298: API call for expression query.
*D-14342: Flow step and Zoom settings control have same size and layout is aligned.
* B-03300: Components update.
*D-14316: Occurrence impact on case duration measure didn't work with certain in-memory models.
* B-03299: Translations updates.
*D-14327: AI Assistant had console error when pressing send button without text.
* B-03301: Distributed computing, part 1: Merge code from distributed computing branch.
*D-14341: AI Assistant overlapped with BPMN editor in fullscreen mode.
* B-03317: Distributed computing, part 2: Access external DDBMS via data tables
*D-14321: Added error message for AI Assistant when trying to use it without model selected.
* B-03311: Distributed computing, part 3: Restoring support for Spark and Snowflake.


'''Fixed issues:'''
===Other improvements===
* 219613: Analyzed objects "Events of specific type" didn't work in chart when there is one event selected.
* B-08391: Datatable access has been optimized improving performance for object-centric models.
* 219611: Filtering attributes with empty string values did not work.
*B-08529: Added support for array type in stringified value format.
* 219616: Unnecessary small vertical scrollbar in models list in Chrome and Edge.
*B-08527: Improved SAP connector error handling and removed assumption for fixed dll file names.
* 219624: Dashboard link set variables incorrectly to dashboard context.
*B-08552: Migrated rest of SQL queries into Entity Framework as preparation for storing configuration data to Snowflake hybrid tables.
* 219436: Improved error message, when user has no access to any models.
*B-08544: Frontend components have been updated.
* 219505: Bottom margin was missing for dashboard if aspect ratio flex is 1.
*B-08561: Updated translations for release 2025.1.
* 219434: Error appeared when creating conformance filter for invalid BPMN model.
* 219427: Error "Conformance model created without any start events!" appeared and BPMN view was not usable.
* D-09584: Filter parameter was not passed correctly in the url when opening UI.
* D-09515: When creating/editing filter rule, selections shown should be filtered with other filter rules.
* D-09495: /api/signout to return 204 also when activation or session is expired.
* D-09568: Multi-select data from different datatable columns causes error.
* D-09569: Model loading failed after previously trying to load model with invalid calculated case attribute.
* D-09570: Performance optimization: BusinessCalendar function changed to constant foldable.
* D-09572: Clustering Cases analysis failed when data contains null values.
* D-09573: Predicted Long Cases fails on performance test machine.
* D-09574: Datatable copy fails to timeout with large data and blocks fetching datatables metadata.
* D-09577: Server crashed e.g. when editing calculated attributes (error in object finalizer).
* D-09578: Excel client: Operation log showed details of only one operation.
* D-09579: "From" in an expression was treated a keyword even if it should not be.
* D-09587: Improve logging in model loading.
* D-09516: JavaScript error when sorting by identifier in workspace: "Cannot read property 'closeDialog' of undefined".
* D-09576: api/expression/query changed to use ProcessCoreInterfaceCall.


== QPR ProcessAnalyzer 2021.1 (build 163) (released 2021-01-18) ==
== Old Releases==
 
See older releases in [[QPR ProcessAnalyzer Release Archive]]
'''Features:'''
* 308096: New function "EventLog" to expression language to explicitly define preprocessings.
 
'''Fixed issues:'''
* 219612: Opening models dropdown list jammed UI when there are lot of models.
* 219495: Improve error message when trying to change login name to already existing.
 
== QPR ProcessAnalyzer 2021.1 (build 156) (released 2021-01-12) ==
 
'''Notes:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
There is a potential performance issue with the list of models in the header, which may appear when there are dozens of models in the list. When there are lot of models, the models list jams the UI when opened. The next release (build 163) has solved the issue.
</div>
 
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
QPR ProcessAnalyzer 2021.1 does not have the '''Data Grid''' and '''HTML''' presentation objects, and they have been replaced by easier-to-use and more powerful [[QPR_ProcessAnalyzer_Chart|Chart]] presentation object, which supports many layouts such as [[QPR_ProcessAnalyzer_Table|tables]]. After updating to QPR ProcessAnalyzer 2021.1, existing dashboards containing Data Grid and HTML presentation objects will contain a placeholder with a message that the presentation object doesn't exist. That placeholder can be removed and replaced with the Chart presentation object. If you need to preserve settings for the removed presentation objects, that needs to be done before updating to QPR ProcessAnalyzer 2021.1.
</div>
 
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Data types of the datatables and temporary tables created by the [[SQL Scripting Commands#--.23ImportSapQuery|--#ImportSapQuery]] command has been changed: previously data types were NVARCHAR(255) for all columns. Now the maximum length in the NVARCHAR data type depends on the SAP data field length. This optimizes the space needed for data storage. In addition, there is a new parameter '''ConvertDataTypes''' allowing to specify which data types are converted correctly instead of using textual format.
</div>


'''Features:'''
* 308075: Chart data point colors can be defined using [[QPR_ProcessAnalyzer_Graphs#Conditional_Formatting|conditional formatting]].
* 307816: Datatables to workspace (part 1).
* 308076: QPRLibraries migration to Syncfusion JS2 (part 4).
* 308086: Syncfusion JS2 update.
* 307975: Data grid presentation objects and datasets have been removed.
* 307974: Remove HTML presentation objects have been removed.
* 308073: Create presentation object types for all HTML presentation objects used in system views - part 2.
* 308077: Translation updates for PA release 2021.1.
* 307652: Remove QPR Connector.
* 307709: Remove most of Excel client functionality and support of Xpress.
* 308039: Web API for terminating operations.
* 308046: Web API for copying datatable.
* 308051: [[Importing_Data_from_SAP|Data type conversions]] have been improved for SAP import.
* 308105: Copyright information update to 2021.
* 308063: SmtpFromAddress setting for sending email.
* 307368 & 308084: Business calendar for duration calculation.
* 307565: Expression filter rule improvements for comparing numerical values.
* 307990: Email notifications part 1.
* 308071: Conformance analysis performance improvements.
* 308080: IIS configurations for .po and .woff2 files.
'''Fixed issues:'''
* 219589: Enhanced BPMN system view has unnecessary horizontal scrollbar.
* 219590: UI got frozen when opening workspace from home view if no other system view opened just before.
* 219595: Long words were not wrapped in message dialog.
* 219519: Error message did not show clear enough information.
* 219557: Root causes analysis is changed to take into account summary row column count.
* 219592: Excel client installer did not contain all connector files.
* 219600: Confirmation message is improved when deleting project.
* 219607: Dashboards don't work with bpmn models having linebreaks.
* 219604: Special characters do not work correctly in chart settings.
* 219606: Using dashboard links sometimes causes an error message to popup.
* 219608: Conformance statistics po tooltip in tool palette is incorrect.
* 219593: Getting data tables is really slow and the query times out after 30 seconds.
* 219582: ScriptLauncher not work in direct database mode.
* 219549: Number of columns in the totals row of analysis types 14 (root causes) and 29 (duration root causes) should be same as in other rows.
* 219544: Inconsistent # Cases Total when running an analysis.
* 219539: Excessively large amount of data added into expression language exception messages.
* 217293: SQL script parser lost lines and error show wrong line numbers.
* 219572: In-memory dataframes (SimpleDataTable) don't work with >1 billion unique strings.
== Old Releases ==
See older releases in [[QPR ProcessAnalyzer Release Archive]]
__NOTOC__
__NOTOC__


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

Latest revision as of 09:49, 5 November 2025

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

Next Release: QPR ProcessAnalyzer 2025.7 (planned 2025-11-11)

See roadmap for next release features and fixes

Latest Release: 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 will fix 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 will fix 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)

Additional release for QPR ProcessAnalyzer 2025.3 (build 9805) (released 2025-04-30)

New features

  • Navigation menu is now displaying dashboards from open dashboard's project or from selected Workspace project (earlier dashboards were shown from the selected model's project). (B-08673)

Fixed issues

  • Fixed issue where AI Agent made unnecessary queries when filtering dashboard, and also opening dashboard with lot of chart may have been slow. (D-14503)
  • When datatable columns were modified, queries to the data may have given "Invalid identifier" error. (D-14507)
  • Clustering analysis didn't work with object-centric models. (D-14486)
  • When a new groups is added, it's selected by default in the Manage Users dialog. Also clicking a selected group does not deselect it. (D-14491)
  • Deleting last group didn't remove the group from the list. (D-14504)

Additional release for QPR ProcessAnalyzer 2025.3 (build 9725) (released 2025-04-23)

There is an issue causing some dashboards having more than 50 charts to open slowly. The issue has been fixed in the next release by D-14503.

Fixed Issues

  • Fixed issue where system stopped responding after opening Scripts tab several times (error in logs: Timeout expired prior to obtaining a connection from the pool). (D-14506)
  • Fixed issue where the object-centric models object types tables didn't work without the timestamp column. (B-08683)
  • Snowflake cache tables are now created after initiating calculation is completed to improve performance. (D-14460)
  • Fixed issue in User Management where assigning role to project or adding user to group was not saved when there was a column filter. (D-14124)

QPR ProcessAnalyzer 2025.3 (build 9699) (released 2025-04-16)

New features presentation: QPR_ProcessAnalyzer_2025_3.pdf

There is a potentially serious issue that can cause the system to stop responding, when opening the Scripts tab in the Workspace. The issue has been fixed in the next release (build 9725) by D-14506.

Object-centric model simplification in the story B-08667 (object attributes can only have a single value) doesn't work with this release. The issue has been fixed in the next release (build 9725) by B-08683.

New features

  • Enhanced AI Agent with UI for editing prompt datasets, and added checkbox to include other charts in dashboard to prompt. (B-08641)
  • In object-centric models, object-to-object relations are now followed by traversing once all object types. (B-08606)
  • In object-centric models, event type and object type tables are not mandatory anymore, and common attributes can be specified in events and objects tables. (B-08663)
  • Object-centric models support simplified structure where object attributes can only have a single value. (B-08667)
  • "Object relation steps" setting can be empty to traverse all linked objects in the object-centric model. (B-08668)
  • Snowflake Event Types preset has been improved by adding suggestion of desired and undesired activities based on frequency of occurrence. (B-08656)
  • Added checkbox for disabling filtering for individual dimensions or columns. (B-08589)
  • Case and event attributes dropdown lists show number of unique values in Snowflake models (instead of attribute datatype as previously). (B-08316)
  • SAML authentication can now synchronize user groups from identity provider. (B-08612)
  • Groups can be deleted in user management. (B-08330)
  • Secrets can be defines as global that can be used by all projects. To set global secrets, SetSecret function works also in the generic context. (B-08599)
  • Snowflake Clustering analysis shows now number of event occurrences as features describing clusters. (B-08353)
  • Model validity check has been extended to find issues in the eventlog data for Snowflake case-centric models. (B-07910)

Fixed issues

  • Fixed a potential issue which could have leaked database connections and caused connection pool starvation. (D-14414)
  • Renewed self-signed certificate used by SAML 2.0 authentication with ten years of validity. (D-14424)
  • Improved CallWebService function to send request body when using DELETE method. (D-14488)
  • Login page now shows correct error message when there are serious system errors during login. (D-14480)
  • "Datatable contents (in-memory)" option now works also with Snowflake datatables. (D-14391)
  • Added maximum data size limitation to AI assistant to avoid error with large datasets. (D-14419)
  • Day of the Year/Week/Month/Quater selection didn't work with specific event time in in-memory chart. (D-14421)
  • KPI card now shows a scrollbar when content doesn't fit to the available space. (D-13428)
  • Workspace projects hierarchy tooltips didn't show special characters correctly. (D-14430)
  • BPMN editor crashed when creating filter from tasks giving following error: Cannot read properties of null (reading 'querySelector'). (D-14399)
  • Value expressions didn't work that are referred in dimension and containing aggregation. (D-13624)
  • Fixed issue where object-centric flowchart filter selection gave error when case-centric model was selected. (D-14408)
  • Fixed issue where query to non-existing model incorrectly returned "Sequence contains no elements". (D-14402)
  • Incorrect StringifiedValues in chart settings and expression filter rule caused UI to stuck. (D-14485)
  • Table column filter value list didn't show the null value label correctly. (D-13844)
  • "Visualize list items with colors" setting didn't work with the "Last Row Aggregates Over-limit Rows" setting. (D-14357)
  • Made sure that failed queries are not added to model filter cache. (D-14484)
  • Chart settings crashed when trying to use without model selected giving following error: Cannot read properties of undefined (reading 'injectValue'). (D-14395)
  • Fixed issue where chart settings opened on top of full screen BPMN editor. (D-14472)
  • Show details button in some error messages didn't have any effect when pressed. (D-14490)
  • Model validation message was incorrect for model where other datatable is Snowflake and other SQL Server. (D-14475)

Other improvements

  • Logging has been set to Warning level for Native App to avoid excessive number of log entries to Snowflake events table. (B-08687)
  • Datatable duplication is now synchronous in Snowflake until 30 seconds to avoid showing the created duplicate datatable with zero rows while the operation is still in progress. (B-08634)
  • Improved Snowflake cache table creation logic when there are multiple simultaneous queries. (B-08622)
  • Refactored SQL Server operations to improve robustness and avoid leaking database connections. (B-08649)
  • Frontend components have been updated. (B-08638)
  • Backend components have been updated. (B-08639)
  • Translations have been updated. (B-08640)

Additional release for QPR ProcessAnalyzer 2025.2 (build 9476) (released 2025-03-19)

Fixed issues

  • Fixed issue where charts axis labels had unnecessary line breaks on spaces. (D-14413)
  • Fixed issue where AI Agent and LLMComplete function didn't work in Native App. (D-14410)
  • Fixed translations for Workspace Scripts tab column filter for Status and Result columns. (D-14393)
  • Fixed issue where Volume Distribution of Flow Analyzed object type didn't work. (D-14390)
  • Removed reference to fonts.googleapis.com for stylesheets to avoid content-security-policy error. (D-14373)
  • Syncfusion dialog headers now show special characters correctly. (D-14407)
  • Object attribute filter gave null reference error when object type didn't exist in model. (D-14379)

QPR ProcessAnalyzer 2025.2 (build 9410) (released 2025-03-05)

New features presentation: QPR_ProcessAnalyzer_2025_2.pdf

Detection of models with incomplete datasource configuration has been improved, and now models where the event timestamp column type is string, are not anymore considered valid models. Earlier the string type of data was accepted and converted into dates when model was loaded (for in-memory models) or in SQL queries (in Snowflake models).

The following query can be run in the Expression Designer (with System administrator user) to list models where the events datatable timestamp column type is string: 

Models.Where({
	let timestampColumn = _.Configuration?.TryGetValue("Datasource")?.TryGetValue("Events")?.TryGetValue("Columns")?.TryGetValue("Timestamp");
	return First(_.EventsDatatable?.Columns?.Where(Name==timestampColumn))?.Datatype == "String";
}).(Name + " (id: " + Id + ")");

For Snowflake dashboards, table actions to set dashboard variables now set the variable values in the stringified format instead of as raw values. This makes the variables set by table actions compatible with the linked settings which also use the stringified format by default for the Snowflake models.

New features

  • Introduced AI Agent which is a new dashboard component showing LLM generated answers based on user prompt and input data. (B-08556)
  • Added filtering by object attributes for object-centric models. Filters can be created from dialog or selecting items from charts. (B-08547)
  • In object-centric models, object-to-object relations are followed only forward and backward directions. Additionally, there are performance improvements for object-centric models. (B-08577)
  • Snowflake warehouse can be specified for each model allowing to use optimal type of warehouse for different sizes of models. (B-08610)
  • Home screen has been removed, and Workspace has new card layout and other UX improvements. (B-08541)
  • Added filter description field to filter properties dialog. (B-08451)
  • Removed event type existence check from charts, so that non-existing event types are allowed. (B-08585)
  • Snowflake Native App configuration data can be backed up to a snapshot and restored. (B-08591)
  • Improved detection of invalid models by adding CheckModelValidity function returning model validation errors. (B-08426)

Fixed issues

  • Prevented following error in Snowflake dashboards: Object "qprpa_dt_cache_..." already exists when creating a cache table. (D-14348)
  • In-memory chart "Cases filtered by attribute" didn't work for date type of attributes. (D-14387)
  • Fixed issue where each dashboard element resize made element width or height increase when chart margin was more than zero. (D-14361)
  • Chart related buttons are now hidden in datatable content preview. (D-14360)
  • Fixed issue where gateway based data import didn't write SAP errors into script log. (D-14351)
  • Snowflake chart gave error when "Last Row Aggregates Over-limit Rows" setting was used with list aggregation. (D-14352)
  • "Users" system report performance has been improved by adding EffectivePermissionTypesFor function. (D-14266)
  • Fixed issue where AI Assistant crashed when used with a model having ODBC or expression datasource. (D-14340)
  • Fixed issue where AI Assistant explaining charts crashed when applying to Label component. (D-14344)
  • Improved client-side import not to perform redundant datatable configuration data queries. (D-14347)
  • Model was incorrectly identified as in-memory model when datatables were missing. (D-14325)
  • Model default filter is now in use when model is opened from Workspace. (D-14376)

Other improvements

  • Changed Snowflake charts to store variable change actions in stringified format to make them compatible with linked settings. (B-08587)
  • Backend support for object-centric filter rules Disabled flag. (B-08611)
  • Implemented Entity Framework based database initialization and migrations. (B-08566)
  • Added support for following Entity Framework database providers: SQL Server (full), Snowflake Hybrid Tables (experimental), PostgreSQL (experimental). (B-08581)
  • Frontend components have been updated. (B-08597)
  • Backend components have been updated. (B-08596)
  • Translations have been updated for release 2025.2. (B-08607)

QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23)

New features presentation: QPR_ProcessAnalyzer_2025_1.pdf

New features

  • B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
  • B-08530: Charts can have a description text which are shown in a dialog when pressing the info button.
  • B-08546: Added LlmComplete function to access Snowflake Cortex large language models.
  • B-08439: Added project settings DatabaseNameInDataSource and SchemaNameInDataSource to define Snowflake database and schema.
  • B-08531: Projects can be created in expression language using CreateProject function.
  • B-08387: Added backend support for object-centric model filtering for object attributes.

Fixed issues

  • D-14339: Week numbers showed incorrect year for last dates in the end of year.
  • D-14323: Filtering with "Split data by filtering" dimension didn't work with exclude type of filter rules and when there were multiple filter rules.
  • D-14346: Fixed issue where manual activation using activation utility didn't work.
  • D-14326: Fixed issue where extra columns in objects table broke object-centric model.
  • D-14306: Fixed issue when there were both TimeStamp and ToTimeStamp event data columns.
  • D-14332: Flowchart event type and flow queries are now simultaneous which will improve performance.
  • D-14331: Flowchart lost selection when flowchart used linked variables with array values.
  • D-14299: Table text filters didn't work in Snowflake (starts with, ends with, contains).
  • D-14338: Model.Modify function generated model json configuration that frontend wasn't incompatible with.
  • D-14342: Flow step and Zoom settings control have same size and layout is aligned.
  • D-14316: Occurrence impact on case duration measure didn't work with certain in-memory models.
  • D-14327: AI Assistant had console error when pressing send button without text.
  • D-14341: AI Assistant overlapped with BPMN editor in fullscreen mode.
  • D-14321: Added error message for AI Assistant when trying to use it without model selected.

Other improvements

  • B-08391: Datatable access has been optimized improving performance for object-centric models.
  • B-08529: Added support for array type in stringified value format.
  • B-08527: Improved SAP connector error handling and removed assumption for fixed dll file names.
  • B-08552: Migrated rest of SQL queries into Entity Framework as preparation for storing configuration data to Snowflake hybrid tables.
  • B-08544: Frontend components have been updated.
  • B-08561: Updated translations for release 2025.1.

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=27214"