BI

Prev Next

Note for Windows environments:
The Zetaly BI Tool must be installed on the C\: drive and cannot be installed on other drives.

Installation Troubleshooting

ProblemActions
"msg": "Depsolve Error occured: \n Problem: problem with installed package buildah ...
Run the following commands :
yum remove buildah skopeo podman containers-common atomic-registries docker container-tools
rm -rf /etc/containers/* /var/lib/containers/* /etc/docker /etc/subuid* /etc/subgid*
cd ~ && rm -rf /.local/share/containers/

BI Tool Troubleshooting Table

ProblemActions
During the BI Tool installation, the following error appears:
"Licence for user expired"

Two possible causes : 

  • The system has kept traces of the previous installation.
    Try to completely uninstall and reinstall the BI Tool.
  • The Machine ID (MID) has changed and the license no longer corresponds to the new MID.
    Contact the Zetaly Support (https://zetaly.io/support/) with the new MID to renew your license.
  • Elasticube : Build Failed
    and
  •  Sisense.CLRConnectorsContainer service is "stopped" and cannot be restarted
  • Try to increase a timeout creating following Windows registry key:
    Location : HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
    Name : ServicesPipeTimeout
    Type : REG_DWORD  (DWORD (32-bit) Value)   
    Value data : 120000  
    Base : Decimal
  • Reboot the computer
BI answer with error mesage :
"message":"Expected type array but found type null","status":422,"httpMessage":"Unprocessable Entity"
Update the dashboard json
"previewLayout": null
should be
"previewLayout": []
You have the ZCC or ZSI permission but can not see the associated dashboards.Remove the permission (ZCC or ZSI) of the user and reactivate it.
Cross Cutting Concern - Admin Sisense - Add-on WiserFilterWidget disabled (ZETALY-3361)
After each Sisense installation, the WiserFilterWidget Add-on is disabled. You must enable it manually as follows:
  1. In Sisense, select Admin > Add-ons.
  2. Click the WiserFilterWidget toggle switch so its status changes to Enabled.
Note:  the WiserFilterWidget Add-on is only supported on Windows.
ZCC- zc_cc.a.e_Budget_vs_Cost - Build failed (Zetaly-3707)
Manually redefine the database connection before building the ElastiCube.
ZIT-BI First install-Error during cubes building (ZETALY-5290)
Sometimes, when installing and building ElastiCubes for the first time, the following error occurs :
[WARNING] Request to http://XXX.XXX.XXX.XXX:8081/api/v2/ecm/ failed. Retrying
The temporary solution is to relaunch the BI Tool with the property Elasticubes.ImportAction = skip

Performance Issues

If you are having performance issues with the BI Tool, do the following:

  1. As an administrator, log to BI Tool's administration interface (port: 8081).
  2. Under Data Management, select Data Sources
  3. Click the cog icon at the top-right.
  4. Expand the Advanced section.
  5. Use the slider to reduce the Max Elasticube Memory Allocation to 50%.