How to resolve the "sql_execute: Api::AccessDenied" error while trying to import a TDV table into a TIBCO Team Studio Python Notebook?
Article ID: KB0072017
Updated On:
| Products | Versions |
|---|---|
| Spotfire Data Science Team Studio | 6.5.0 and above |
Description
This article will help to resolve the "sql_execute:Api::AccessDenied" error while trying to import a TDV table into a TIBCO Team Studio Python Notebook.
Issue/Introduction
This article will help to resolve the "sql_execute:Api::AccessDenied" error while trying to import a TDV table into a TIBCO Team Studio Python Notebook.
Environment
Linux
Resolution
We encounter an "API: Access denied" error in Python Notebook when we have integrated the SSL configured Team Studio server with the Non-SSL Python Notebook.
To resolve the issue, please uninstall your current Python Notebooks installation and do a fresh installation following the below steps.
When you are using an SSL certificate in the Team Studio server, and you are integrating it with Python Notebooks, we need to follow the steps below to enable SSL on TIBCO Team Studio Python Notebooks:
To resolve the issue, please uninstall your current Python Notebooks installation and do a fresh installation following the below steps.
When you are using an SSL certificate in the Team Studio server, and you are integrating it with Python Notebooks, we need to follow the steps below to enable SSL on TIBCO Team Studio Python Notebooks:
- Copy the Certificate and key files to the Python Notebooks server and Store them in the installation directory of the Python Notebooks (default path is /opt/notebooks)
- Download the Jupyter python notebooks installer file from the edelivery website(https://edelivery.tibco.com/storefront/index.ep) onto the location /opt/notebooks.
- Install the Jupyter python notebooks local version by running the installer file.
- During the installation, it asks you whether you have an SSL certificate. Please choose the option "yes."
- When asked for the path to the Certificate and key files, Please provide the paths and continue the installation.
- After installation, start the Jupyter Python Notebooks server with commands
systemctl stop tsnotebooks
systemctl start tsnotebooks
systemctl start tsnotebooks
Feedback
Yes
No
Powered by
