Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Version: 2024-R1-SR3 (5.4.3)

Release date: 21 August 2024

The Perfion Database Installer is needed to install a new database or upgrade an existing Perfion database to the latest release.

Release date: 01 February 2022

Important info: From this version on it is required that the database user, used to log in to the database connected to Perfion, has the “View Server State”-right. For information on how to give a user this access setup please see here.

Database Installer 2021-R2

Perfion.DBInstaller (NoData) (build 4.10.4).zip

Perfion.DBInstaller (InclDemoData)


(build 4.10.4

NOTE: The Perfion Database Installer requires the sqlserver to use CI (Case Insensitive) collation as its default collation - it will not work if temp/master DB is using CS collation. Workaround is to install a new named instance on the sqlserver with a CI collation.

View file
namePerfion.DBInstaller 2024-R1-SR3 (5.4.3).zip

Release notes

Jira Legacy
serverSystem JIRA
columnskey,type,release note title,release note
maximumIssues1000
jqlQueryfixVersion in ("Perfion DB 2022-R2") AND issuetype in (Bug, "Feature Request", "Tech feature request") AND "Release note internal" is EMPTY AND project = "Perfion Software"
serverId45283f66-30ea-3e94-853c-432617345c26

Bugs:

Issue ID

Title

Description

DEV-6309

Selectable items were incorrectly selectable

When setting up security so that the user is prevented to select certain values of a selectable feature, would not be prevented in the Web Client. This has been resolved.

DEV-6313

Perfion API - Using ID in a Where clause is fixed

In some mere complex Where clauses with a id='ID' throw an error. The id='ID' is used in some reports.

DEV-6303

View Relations did not work for multivalue localizables

Picking "View Relations" for an item representing a multi value localizable would cause previous versions of Perfion to throw a "null value exception". This has been fixed.

DEV-6280

Better user synchronization between Active Directory and Perfion

It was not possible to add non-localizable to users. Now there is created a new group in Active Directory for non-localizable.

 

Disabled users in Active Directory were not disabled in Perfion. Now inactive users are synced when opening Users and Groups settings.

DEV-6239

Active Directory cache not possible to access

Not possible to log in because it could not find part of the token cache file.

Now it automatically creates the path when logging in.

Features:

Issue ID

Title

Description

DEV-6309

Selectable items were incorrectly selectable

When setting up security so that the user is prevented to select certain values of a selectable feature, would not be prevented in the Web Client. This has been resolved.

DEV-6313

Perfion API - Using ID in a Where clause is fixed

In some mere complex Where clauses with a id='ID' throw an error. The id='ID' is used in some reports.

DEV-6303

View Relations did not work for multivalue localizables

Picking "View Relations" for an item representing a multi value localizable would cause previous versions of Perfion to throw a "null value exception". This has been fixed.

DEV-6280

Better user synchronization between Active Directory and Perfion

It was not possible to add non-localizable to users. Now there is created a new group in Active Directory for non-localizable.

 

Disabled users in Active Directory were not disabled in Perfion. Now inactive users are synced when opening Users and Groups settings.

DEV-6239

Active Directory cache not possible to access

Not possible to log in because it could not find part of the token cache file.

Now it automatically creates the path when logging in
2024-R1-SR3 (5.4.3)

Release note title

Release note

System Task for update license will now retry failed requests

Previously the 'Update License' system task, which by default checks for a new license every Sunday night, would only perform three consecutive retry attempts if the request failed. The task will now perform additional retries.

2024-R1-SR2 (5.4.2)

Release note title

Release note

Database triggers has been refactored for better performace

A few database triggers have been refactored to only run if there are any changes. This potentially improves the performance of the system.

A few new indices have been added to the database

A few new indices have been added to the SpecsIX, ImportLogs and TaskLogs tables. This is to improve performance of certain queries.

2024-R1-SR1 (5.4.1)

Release note title

Release note

Performance

Various performance updates to improvae handling of database triggers.

2024-R1 (5.4.0)

Release note title

Release note

Action log messages was truncated to 200 characters

Previously any Action log messages would be truncated to 200 characters, potentially removing important context information from the messages. This has now been extended to max. 4000 characters instead.

Actions - All ignore flags on Action groups are removed

All ignore flags on Action groups are removed to let all Actions continue working. An ignored group will ignore all child commands or groups.

Database transaction isolation level changes

To minimize the amount of database locks used when reading and writing data to the database, Perfion now uses the Read Committed Snapshot feature of SQL Server. This is an optimistic locking mechanism, where SQL Server will take a copy of the data targeted for update, allowing other users to read the existing data without further locking. Note that the copy will, per default, be placed in the tempdb, so this change may result in more load and disk usage in the tempdb.

Length of Remote Connection configuration has been extended

Previously, the length of a Remote Connection configuration was limited to 512 characters. This has been extended to 4000 characters.