[Linux] Resolving data model connection errors in Sisense after importing models

Introduction

This article addresses an issue where data models in Sisense fail to open, producing a "Cannot read properties of undefined (reading 'datasets')" error message. The problem appears during the import of models from one environment to another, accompanied by difficulties in cleaning up datasets using APIs.

Step-by-step guide

Identify the Problem Context:

Ensure that the error message is related to "Cannot read properties of undefined (reading 'datasets')" while attempting to connect after importing models via Sisense API.
In the API-gateway logs you will find the following error after the model import: path":"/api/v2/datamodels/schema","status":500

Check Recent System Changes:

Verify if any recent upgrades or changes have been made. Problems like this can often be traced back to issues within migration processes during upgrades (e.g., from Sisense version 2024.3 to 2025.1).

Verify Configuration Settings:

Review the connection manager's settings. Check if it is enabled after the upgrade

Go to Admin Tab - Server & Hardware - System Management - Configuration - Click 5 times on Sisense logo - Click 3 times on General - File Explorer - base - search connectionManagement settings - check if connectionManagement.enabled.value set to true

[ALT Text: Sisense configuration screen showing ConnectionManagement settings, with 'connectionManagement.enabled.value' set to true and highlighted by an orange arrow.]

Final Verification and Testing:

Once corrective actions are performed, trigger the import process again.
Verify the connection to the data models through dashboards in the Sisense environment.

Conclusion: A summary of key takeaways or final points.

For a step toward preventive measures, consider revisiting your system's upgrade and migration process. Investigate options to automate configuration checks and validations pre- and post-upgrade.

Regular monitoring of logs can preemptively catch errors linked to data model connections.

By following these steps, you should be able to restore functionality to your dashboards and ensure smooth operations when importing data models across environments.