Resolving "Internal Server Error" When Importing Model with Generic JDBC Connector

[Vicki786]

Resolving "Internal Server Error" When Importing Model with Generic JDBC Connector

This article addresses the issue of encountering an "Internal Server Error" when importing a model from a local desktop to a production environment using the Generic JDBC connector in Sisense. This error often arises due to compatibility issues with older JDBC frameworks. Here, we provide a solution to resolve this error by updating the JDBC connector and connections.

Step-by-step guide

Identify the Error:

1. When importing the model, if you receive an error message resembling:
   

Unexpected error value: { timestamp: {}, status: 500, error: "Internal Server Error", path: "/api/v1/internal/live_connectors/auth/GenericJDBC… }

1. This error could indicate a problem with the outdated Generic JDBC connector.

Understand the Cause:

1. The error is due to the Generic JDBC connector using an older framework incompatible with the latest Sisense versions.

Update the JDBC Connector:

1. Deploy the JDBC connector using the new JDBC framework.
2. Ensure all connections within the cube in the original environment where the model was exported are updated accordingly.

Deploying the New Framework:

1. Follow the step-by-step instructions detailed in the Sisense documentation for deploying a custom connector with the new JDBC framework.
2. Access the documentation here: Deploying a Custom Connector - Sisense Documentation.

Re-attempt the Model Import:

1. Once the JDBC connector is updated, try importing the model again into the production environment.

In conclusion, updating the Generic JDBC connector to align with the new JDBC framework and ensuring the connections are properly configured should resolve the "Internal Server Error" encountered during the import process. Following the above steps will help ensure a smooth and successful model import.

References/Related Content: 

• Deploying a Custom Connector - Sisense Documentation
• Sisense Community Support Forum
• Introduction to Data Sources

Disclaimer: This post outlines a potential custom workaround for a specific use case or provides instructions regarding a specific task. The solution may not work in all scenarios or Sisense versions, so we strongly recommend testing it in your environment before