Content Comparison

Version:

2024-

R1 (5.

4.

0)

Release date: 29 30 April 2024

Highlights

• Filtered Values: Filter available selectable values in any feature based on value in “controlling” feature and highlight violations in Language variants on selectables: Validate selectable translations in grid and item editor

• Filtered Values Setup: Create, Edit, Delete, Export and Import configurations for Filtered Values

• Active Languages: Administrators can now manage active languages

• New Action commands:

  • SELECT.API: Supports calls to REST and SOAP protocols

  • READ.FILE: Read any file type into a file stream

  • SELECT.XLIFF & IMPORT.XLIFF: Export and import using XLIFF format

• ‘Default values’ and ‘Copy’ are now allowed together

• Action management improvements

• Environment Definition: Manage multiple environments

See more info in the features presentation (on the front page of the Knowledge Base) or refer to the release notes.

Windows Client

The Perfion Windows Client has to be installed/upgraded for all Perfion users

Release Notes

2023-R2 SR3 (5.3.11)

2023-R2 SR2 (5.3.4)

Release note title

Release note

Improved performance in Perfion API when selecting items based on the id of some selectable feature value

Performance of the Perfion API has been improved in 2 areas:

1. When doing queries using clauses with non-inheritable features

2. When doing clauses that matches a selectable-feature value using its Item ID (or Item IDs). It could be a statement like this:

   Code Block
   <Clause id="Color.id" operator="=" value="1234" /> <!-- 1234 is item id of the Color-item "Black" --

Other clauses are not affected.

2023-R2 SR2 (5.3.3)

Release note title

Release note

User Administration - Indonesian(IND) language counts as extra language

A bug where the Indonesian(IND) language counts as extra language in the user administration is fixed

Load time of large configurations in WebClient has been reduced significantly

Load time of large configurations in WebClient has been reduced significantly.

Sorting multivalue features did not save correctly

When attempting to sort a multi-value feature via the Windows Client grid, the sort order would not be saved correctly. This happened when sorting was the only change. This has now been fixed.

Opening view formula in grid shows calculated value

Previously the view formula editor did not auto calculate the formula value on opening the editor.
This is done now.

Windows client selector proper row count when filtered values filtered

The row count in the Windows client selectors was not correct when filtered values filtering is active.
This has been fixed.

Filters on Search- and Table-features erroneously always matched no items

Right-clicking on a value of a Table- or Search-feature, making a filter always created a filter criteria that did not find anything. This was caused by an error in the Perfion API not properly constructing the SQL for such criteria. This has been fixed.

Filtered Values configuration - edit configuration does not fail in closing ribbon display options

An error occurred if entering ribbon display options when editing an existing Filtered Values configuration. The error occurred if trying to abandon the ribbon display options mode.
This has been fixed.

Dashboard widget - Fit text size to content

The text size in a count widget will decrease to fit the size of the widget content.

Issue with special characters in SMTP remote connections

If in an SMTP (mail server) remote connection, the password contained an equals character '=', Perfion could parse the connection string incorrectly, causing the connection to not work properly. This has now been fixed.

2023-R2 SR1 (5.3.2)

Release note title

Release note

Export from grid could sometimes fail with an 'Object reference not set to an instance of an object'

Export from grid could sometimes fail with an 'Object reference not set to an instance of an object' when either selecting or deselecting languages to export. This has been fixed.

Accepting an item without Supplier Key-feature set, will now give proper error message.

Accepting an item without Supplier Key-feature set. will now give proper error message. Before you got a null value exception.

Views from Supplier Portal are now available in Search Selector above grids.

Views from Supplier Portal are now available in Search Selector above grids. There are 4 such views: Expose, ExposeReadOnly, Mandatory and AutoApprove.

Perfion API will stop query execution on client disconnects.

Previously the Perfion API would continue query execution of selects, even if the client disconnected. Now, the Perfion API will cancel query execution if the client disconnects and thus release resources to process other requests.

Significantly optimized speed for "Global Search" in web-client

In most cases Global Search (available in Web Client) has had its performance significantly optimized. The optimization  works best in installation searching in many features on larger amounts of data. 

In Table Designer ensure units, captions etc. are present when expressions are used

An error was present in the Table Designer where feature variants like units, captions etc. was not shown when expressions for non-localizable features was using these variants - e.g.: using expression @FormatMultiValues({Value}({Unit})) for a multi value non-localizable feature would not show the unit.

This error has been fixed.

Image and File URLs returned from the eCommerce API is not URL encoded

The eCommerce API could previously return invalid URLs when using the new Image/File endpoints. The issue could be seen if the file name in Perfion contained spaces or other special characters. This has now been fixed by correctly encoding URLs.

Grid compare stage

A bug when using staging and compare are fixed

Removing active languages error

Removing a active language did not remove languages from users. This bug are now fixed.

Intermittent error 'API Update Failed'

When doing updates in Perfion users could see an intermittent error 'API Update Failed'. This error was caused by multiple users, a Trigger, or an Action, trying to update the same item at the same time. This issue has been resolved.

Possible to update unique value feature in Web client

Updating a unique value feature which is part of a configuration failed in the Web client when validating config choices as 'Exclude from copy' was not present as required for unique value features. The error has been fixed by adding config choice 'Exclude from copy' when adding a unique value feature to a configuration.

Can create new products-setting on Suppliers now respected by API

In previous versions of Perfion a Supplier was allowed to create new items in the Supplier Portal, despite that he was not given the right "Can create new products". This has been resolved. 

Perfion API could refuse to delete SupplierItem

The Perfion API could refuse to delete Supplier Items. It happened since the API mistakenly tested whether the Ids were part of any configuration (as Item Dependent items). Supplier Items can never be used in such a way, so the check has been fixed. 

Web report error when using language parameter with multiple values

Web reports failed when using language parameter containing more than one language.

This has been fixed.

'Sync with AD' may mark users as inactive in Perfion

User may incorrectly be marked as inactive when Perfion synchronizes users with Microsoft Entra ID (Azure AD). This has been fixed.

Unique-constraint on selectable feature made it impossible to copy/paste values

In previous versions of Perfion you could not copy/paste a feature value from a selectable feature being marked as unique to the same feature on another item. Instead you got a "unique constraint"-error message. This has been resolved.

Issues in Number default values in Feature Configuration

When changing a number feature default value in a Feature Configuration, the number was incorrectly saved if it included a decimal point.

This has been resolved

Web client import users can see all logs

When a user has the right to import data and view import logs the user can now see all logs for also other users.

When opening a "Selectable item" inheriting its configuration Item Editor would not show all values

When opening a "Selectable item" inheriting its configuration from another feature, i.e. opening a "Related product" inheriting its values from "Product", the Item Editor would not fetch all values (specs) from the Item. This has been fixed. 

Importing SupplierItems could in some cases cause importer to fail

Importer could in rare cases throw a null-value exception during import of selectable, localizable value singles. This has been fixed.

ECommerce API now supports getting and updating entities using their Perfion Id

All of the following methods GetProducts, GetCategories, GetSites, UpdateProducts, UpdateCategories and UpdateSites now supports filtering entities by their Perfion Id using the "PerfionIds"-parameter. See documentation for more information.

Dashboard Widget management

Validation added to the Dashboard Widget management.

ReportServer may not return correct filename of generated reports

When using the ReportServer (report.ashx), it would not return the filename of the generated report unless the request included 'action=save'. This has now been fixed.

Perfion API: In-operator in clause now throws error if not supplied at least one value

Using the IN-operator in Perfion now throws an understandable error message, if it is not supplied with at least one value. In previous versions of Perfion the clause has either been ignored or you got an error message back from the SQL-server that was quite hard to understand.

Monthly scheduling did not work

If you scheduled a Task to run using "Monthly"-scheduling it did not run at all unless scheduled in UTC-time. This has been fixed.

Incorrect handling of filenames containing periods (.)

If a binary asset (an image or file) contained one or more periods (.) in the filename, the filename would be incorrect when downloading binaries from grid via the Perfion web client. This has now been fixed.

Proper Query Analyser Grid count when using maxCount in Perfion SELECT

Paging is disabled in the Query Analyser Grid and when maxCount was used in the SELECT clause the grid count was not correct. This has been fixed.

Import/export of configurations extended with support for default values

On import/export configuration also import/export possible default values

In Windows grid do proper right click after move item to a parent

In the Windows client an error occurred if right clicking an item after move to a parent. This has been fixed.

Deleting all roles from user threw error

When you in the Windows-client deleted all roles on a user you would, in previous versions of Perfion, get an error. This has been fixed.

Logging in using a Group Id gave strange error message

When you in previous versions of Perfion tried to log in using a Group Id, say "Admins", you would get a strange error message. This has been fixed, so you now simply get a "User was not found" as you would if the id was unknown.

Extra view added to SupplierPortal-views

A view named “ExposeReadOnly” has been added to the Supplier Portal-views. Features in this view are treated special by the Supplier Portal. If a feature is in “ExposeReadOnly” its value in Standard Items will be shown to the Supplier giving some information of the product the Supplier is about to fill out. As the name implies, the Supplier cannot change the value of a feature in this view. A feature cannot be both in “Expose”- and “ExposeReadOnly”-view.

In XLIFF import choose among active Perfion languages if more than one Perfion language found

When doing XLIFF import some target languages gives hit on more than one Perfion language due to same culture name used. When this happens choose target Perfion language among active Perfion languages.

If max number of allowed suppliers is exceeded Perfion will enter "locked mode"

If max number of suppliers allowed in license is exceeded, Perfion will enter “locked mode” in which only an admin may lock in and only is allowed to either change license or reduce number of suppliers. Either by inactivating them or remove access from Supplier Portal.

Allowed number of Suppliers are now restricted by license

Maximum number of suppliers are now restricted by license. The interface creating organizations will prevent you from creating more than allowed.

Typing more than 200 characters in Company Name would cause SQL-error

In previous versions of Perfion, typing a Company name longer than 200 characters would give an error message when saving company. Now Company name edit-box is limited to 200 characters.

Reduced number of deadlocks using PTable Updates reduced

Under heavy load the API Update statement could fail due to a so-called deadlock. Deadlocks happen when other database requests holds or wants to hold the same resources. In such situations the database is forced to choose one or the other as a so-called deadlock victim and fail it. The Perfion API Update-statement is now capable of, in case it is chosen as the deadlock victim, to retry the update up to 3 times after it fails if problem persists. 

2023-R2 (5.3.1)

Release note title

Release note

Reduced number of deadlocks using PTable Updates reduced

Under heavy load the API Update statement could fail due to a so-called deadlock. Deadlocks happen when other database requests holds or wants to hold the same resources. In such situations the database is forced to choose one or the other as a so-called deadlock victim and fail it. The Perfion API Update-statement is now capable of, in case it is chosen as the deadlock victim, to retry the update up to 3 times after it fails if problem persists.

Application Server - Logging

Start and stop logging are added to actions executed via Application Server. This will make it possible to see time used to each action.

Action - Execute.Action

If an Execute.Action is called with an empty table, the action will fail. The bug is fixed to handle empty tables.

2023-R2 (5.3.0)

2023-R2 SR3 (5.3.10)

Release note title

Release note

Import Action - Performance optimization

The Import Action had some performance issues.

ConstructedFileName can now be output without fetching files

The ConstructedFileName is output as part Image- and Attachment-elements when the OutputKind is set to Image(File, '<some filename template>') or Attachment(File, '<some filename template>'). This also means, that a file named "<ConstructedFileName>" will be stored in a folder controlled by the Setting "OutputFolder". From this version of Perfion, you can get a ConstructedFileName without fetching and storing any file simply by Setting "OutputFolder" to blank.

2023-R2 SR3 (5.3.9)

Release note title

Release note

Import of certain Excel files could fail with message "Unable to read import file. Please check that it is in the correct format."

Import of certain newer Excel format could fail with message "Unable to read import file. Please check that it is in the correct format.". This has been fixed by attempting to convert the Excel file to an older format that are suitable for import.

2023-R2 SR3 (5.3.8)

Release note title

Release note

Binary imports may freeze when running on the Perfion Application Server

Running binary imports on the Perfion Application Server could cause the import to freeze, requiring a restart of the Application Server. The issue could occur because of locks in the database, causing the application server to wait indefinitely for the locks to be released. It will now time out after 5 minutes.

2023-R2 SR3 (5.3.7)

Release note title

Release note

Perfion could fail to retry in database deadlock situations

If the database cancelled an operation due to a potential deadlock, Perfion would fail to retry the change. This situation would surface as a NullReferenceException in e.g. the Item Trigger log. This has been fixed, so that Perfion correctly retries.

2023-R2 SR3 (5.3.6)

Release note title

Release note

Binary imports may freeze when running on the Perfion Application Server

Running binary imports on the Perfion Application Server could cause the import to freeze, requiring a restart of the Application Server. Inter-thread communication has been refactored, so that locking is more unlikely to occur.

2023-R2 SR3 (5.3.5)

Release note title

Release note

Feature Data Import could sometimes be slow, even when importing the same data

Feature Data Import could sometimes be slow, even when importing the same data. Analysis shows that the issue is caused by the execution of a sub-optimal query plan on the database. An extra index has been added to the table in question, to help SQL Server make a better execution plan.

Improved performance in Perfion API when selecting items based on the id of some selectable feature value

Performance of the Perfion API has been improved in 2 areas:

1. When doing queries using clauses with non-inheritable features

2. When doing clauses that matches a selectable-feature value using its Item ID (or Item IDs). It could be a statement like this:

<Clause id="Color.id" operator="=" value="1234" /> <!-- 1234 is item id of the Color-item "Black" --

Other clauses are not affected. 

Remove not used column 'Has Violations' and menu item 'Show Violations' in Filtered Values configurations

In Filtered Values configuration the column 'Has Violations' is not used and menu item 'Show Violations' are not used. These have been removed.

With logging enabled, eCommerce API queries could return incorrect error information.

When querying the eCommerce API with logging enabled, the API could return an incorrect error message if an error occurred. This would especially happen if the supplied logon credentials to the API was invalid. This issue has been fixed.

Action Command DOWNLOAD.FTP

The DOWNLOAD.FTP return a memory stream and this is now set to Position = 0

Users may be unable to logon to the Perfion Webclient if multifactor authentication is configured.

When trying to access the Perfion Webclient, users could experience an error causing the browser to show an extra Windows login prompt. This issue could show if multifactor authentication is configured. This has now been fixed.

Proper enable of 'Replace' in grid menu when inherited values exist

An error was present of disabling 'Replace' menu item in grid when selected cell column had inherited values. This has been fixed.

Perfion API commands Delete and Insert could be done as Reader

The Perfion API commands Delete and Insert could be done through the API despite that the user was reader (i.e. did not have Edit-access to any language). Inserts would only work, if no features were assigned a value. Update commands were not allowed, since they by nature assigns at least one feature value which is prohibited without any edit access to any language.

This has been fixed so that all data modifying API-Commands (Insert/Update/Delete) now require the user to be an editor, i.e. capable of editing at least one language or non-localizables.

Statistics and Index maintenance could fail on custom objects

If a database contained custom (customer-created) indices or statistics, the scheduled database maintenance job could fail if the objects contained certain characters such as dashes. This has now been fixed.

Running the 'Sync AD users' scheduled task fails due to missing assembly reference

When running the 'Sync AD users' scheduled task, it would fail with a message that a reference to Microsoft.Kiota.Abstractions was missing. This has been fixed.

Freeze column in grid is only cleared if view/columns are changed

A previous fix cleared the freeze column in grid when the grid was refreshed. This has been changed so the freeze column is only cleared if changes are made to grid columns - e.g. by choosing new view or add/remove grid language.

<feature id='MySrd' type='Relation' />

<Feature id='MySrd' type='Relation' view='Family' />

<Query>
  <Select languages='EN' options='IncludeConfiguredSwapRelations' >
    <Feature id='*' view='Item'/>
  </Select>
  <From id='ProductDefaultValues' />
  ...
</Query>

<Product ...>
  <MySrd type="table">
    <MySrd id="123" parentId="0" ...>
      <Value seq="0">SRD1</Value>
    </MySrd>
    <MySrd id="234" parentId="0" ...>
      <Value seq="0">SRD2</Value>
    </MySrd>
  </MySrd>
  ...
</Product>

<Product ...>
  <MySrd type="table" data="1" />
  ...
</Product>