"An error occurred" message is displayed when you add data items to a crosstab in SAS® Visual Analytics on SAS® Viya® 3.5


An Error Occurred message can be displayed when you add data items to the roles of a Crosstab object in a SAS Visual Analytics report.

In some scenarios, the report data log also contains a message similar to the following:

PDX registry could not be initialized because the disk store PDX was not created.

This issue occurs in SAS Viya 3.5.

The log message indicates a likely failure in the report data caching layer, specifically an Apache Geode PDX disk store initialization problem in the cache server.

Workaround

To circumvent this issue, clear the temporary files used by the cache server. 

  1. Back up the files in the following directory:
    /opt/sas/viya/config/tmp/sas-cacheserver/

  2. Stop all SAS Viya services on all machines running SAS Viya microservices.

  3. Delete the contents of the following directory on all applicable servers:
    /opt/sas/viya/config/tmp/sas-cacheserver/

  4. Restart all SAS Viya services.
    See Start and Stop All Servers and Services for service start procedures.