This is the documentation for Clover Club 12.0.
Documentation for the upcoming version Rampur 13.0 can be found here.
Troubleshooting – All Versions
This section provides some helpful troubleshooting tips.
Contents:
- 1 A waterfall chart within a dashboard doesn't render correctly
- 2 I cannot download data to Excel when working in Safari
- 3 Charts which work fine in the Classic UI fail to load in Unity
- 4 Internationalization: Translated strings are not displayed in Unity
- 5 The Customer input field is missing on quote Header tab - Unknown Type: "" error
- 6 Empty Drop-down menu
- 7 Handle invalid saved filter definition in Advanced Filter
- 8 Workflow email links lead to different UI version
- 9 Document detail page opens in React
- 10 Data uploads to Product/Customer Extension tables fail or take a long time to complete
- 11 Unable to parse any Excel file using PARSABLEINPUTFILE
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:
{
credits: {
enabled: true,
text: "Example.com",
href: "http://www.example.com"
},
...
you need to have:
{
"credits": {
"enabled": true,
"text": "Example.com",
"href": "http://www.example.com"
},
...
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:
Log in to the Classic UI with the same locale as you use in Unity, e.g., containing locale=en in the URL.
In the Localization admin, import the translated labels.
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.
Recommended solution:
Verify that the input definition also properly specifies the type of the input - InputType.CUSTOMER in this case:
quoteProcessor.addOrUpdateInput("ROOT", [
name : "Customer",
filterFormula : [name : "CustomerFilter"],
type : InputType.CUSTOMER
])
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.
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:
Module | Link |
---|---|
Quoting | $baseURL$/app/modules/#/qc/go-to-quotes/$entity.typedId$/messages/$msgEntity.typedId$ |
Agreements & Promotions | $baseURL$/app/modules/#/pm/go-to-contracts/$entity.typedId$/messages/$msgEntity.typedId$ |
Rebates | $baseURL$/app/modules/#/rm/go-to-rebate-agreements/$entity.typedId$/messages/$msgEntity.typedId$ |
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 usedetectJoinFields
instead.Use the
importfile
endpoint which forces the caller to specify the name of the extension.Or simply make sure that
name
is included injoinFields
.
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: