This section provides some helpful troubleshooting tips.

Contents:

A waterfall chart within a dashboard doesn't render correctly

The waterfall chart shows e.g., lines instead of bars.

Recommended solution:

Make sure all of the templates are in the JSON format.

For example, instead of:

you need to have:

I cannot download data to Excel when working in Safari

When I use the Safari browser, I'm unable to download any data, charts, etc. to Excel.

Recommended solution:

Check the security preferences for Safari and make sure that the option Block pop-up windows is disabled.

Charts which work fine in the Classic UI fail to load in Unity

When I write a chart definition, the chart works normally in the Pricefx Classic user interface. However, when I open a dashboard containing this chart in Unity, the chart fails to load.

Recommended solution:

Charts displayed in Unity require the setGeneratedQueryDto parameter to be present in the chart definition. This line is added to the chart definition automatically, if the chart is exported from Analytics using the View Expression feature. If you write the chart definition yourself, please make sure that you include this parameter.

Internationalization: Translated strings are not displayed in Unity

In the Internationalization section, I have added a few translated strings but they are not displayed in Unity.

Recommended solution:

1. Log in to the Classic UI with the same locale as you use in Unity, e.g., containing locale=en in the URL.

2. In the Localization admin, import the translated labels.

3. In Unity, log out and log in again. The labels should now be visible.

The Customer input field is missing on quote Header tab - Unknown Type: "" error

The Customer input field is not rendered in the UI although it is defined in the calculation logic.

Open

Recommended solution:

Verify that the input definition also properly specifies the type of the input - InputType.CUSTOMER in this case:

Empty Drop-down menu

I am not able to enter input values as the drop-down menus are blank, without options.

Recommended solution:

Users with multiple active displays using Google Chrome on Windows may experience a problem with pages containing input elements. This is a Google Chrome issue. You may try to use a different browser.

Handle invalid saved filter definition in Advanced Filter

There can be situations, when the saved filter definition is not valid anymore (for example, the field has been renamed/removed in the Datamart). In such a case, the Advanced Filter will not work properly.
To notify users about this, we have added an alert to the Advanced Filter.

Open

Recommended solution:

Based on the details given in the alerts, user can adjust the saved filter to make the Advanced Filter work properly.

Related ticket: https://pricefx.atlassian.net/browse/PFUN-13821

Workflow email links lead to different UI version

Although using the React version of Quoting, Rebates or Agreements & Promotions, I'm always taken to the old Ember version when I follow the “reply to message” email link.

Recommended solution:

Replace the links in the message templates with new ones that work both for React and Ember versions:

Document detail page opens in React

Although using the Ember UI version, I'm taken to the React version of the detail page.

Recommended solution:

The default of the useReactFor feature flag was set to true in version 9.1. To avoid this problem, set the crm_config advanced configuration option so that it contains feature flags setting useReactFor to false.

Data uploads to Product/Customer Extension tables fail or take a long time to complete

When you use the endpoints loaddata and loaddata.file for data upload and you explicitly specify the joinFields option without including name (or any other column that is part of the business key of your extension), the existing indexes are not used which makes the upload slow or fail.

Workaround:

• Do not specify joinFields in the query but use detectJoinFields instead.

• Use the importfile endpoint which forces the caller to specify the name of the extension.

• Or simply make sure that name is included in joinFields.

Solution implemented in version 10.0:

The joinFields option includes fields that should be in the business key, that is name for Product/Customer/Seller Extension, sku for Product Extensions, customerId for Customer Extensions and sellerId for Seller Extensions.

Unable to parse any Excel file using PARSABLEINPUTFILE

I am unable to parse any Excel file using PARSABLEINPUTFILE and I’m getting the error Wrong data, found 2 BinaryData, expected 1.

Recommended solution:

This error can occur when the auto_increment value in the UploadStatus table isn't in sync with the max value of latestUploadStatusId in BinaryData table – i.e., the current auto_increment from UploadStatus <= max(latestUploadStatusId) from BinaryData. This leads to a situation that a new file upload can get the ID of an already occupied upload slot. This kind of data mismatch can be the result of some manual data operations or even a restart of the DB service; occurs in MariaDB and MySQL (versions lower than 8.0.0).

The following SQL statement can be used to adjust the auto_increment value in the UploadStatus table:

ALTER TABLE UploadStatus AUTO_INCREMENT=$(GREATEST(COALESCE((select max(latestUploadStatusId)+1 from BinaryData), 1), COALESCE((select max(id)+1 from UploadStatus), 1)));

It is advisable to contact Pricefx support if a fix in the database is required.

For more information about this issue, see:

• Auto-increment counter not persisted on disk with InnoDB

• InnoDB autoincrement stats lost on restart

• AUTO_INCREMENT Handling in InnoDB