Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Connection refused when preview a python data set

0 votes
1 view

I tried to configure a simple python dataset, and when I ask for a PREVIEW, the application give an error "Connection Refused" :

this occurs with Knowage suite7.4.5 deployed with the helm chart, but also with docker-compose deployment...

it seems there is something wrong with configuration of knowage python container, or in knowage server configuration, to allow them to communicate, like wrong port ?

please, can someone help to remedy this problem !

Environment Knowage version 7.4.5, deployed with helm chart in Kubernetes cluster, or deployed with docker
in Data Set by (670 points)
the error in knowage.log is :

[http-nio-8080-exec-1] 20 Aug 2021 15:05:28,330 ERROR it.eng.spagobi.rest.interceptors.RestExceptionMapper.toResponse:59 - Catched service error:
it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: An unexpected error occured while executing dataset: Connection refused (Connection refused)
        at it.eng.spagobi.tools.dataset.service.ManageDataSetsForREST.getDatasetTestResultList(ManageDataSetsForREST.java:1789)
        at it.eng.spagobi.tools.dataset.service.ManageDataSetsForREST.getDataSetResultsAsJSON(ManageDataSetsForREST.java:1737)
        at it.eng.spagobi.tools.dataset.service.ManageDataSetsForREST.datasetTest(ManageDataSetsForREST.java:1696)
        at it.eng.spagobi.tools.dataset.service.ManageDataSetsForREST.previewDataset(ManageDataSetsForREST.java:144)
......

a:121)
        at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
        at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:386)
        at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
        at it.eng.spagobi.utilities.rest.RestUtilities.makeRequest(RestUtilities.java:334)
        at it.eng.spagobi.utilities.rest.RestUtilities.makeRequest(RestUtilities.java:291)
        at it.eng.spagobi.tools.dataset.common.dataproxy.PythonDataProxy.load(PythonDataProxy.java:130)
        ... 70 more
by (670 points)

1 Answer

0 votes
 
Best answer

Hi,

you have to configure the address of the python engine in the Configuration Management section.

Log into Knowage as a superadmin and go to Settings -> Configuration Management and then add a new configuration of type PYTHON_CONFIGURATION.

Bye,
Marco

by (9.3k points)
selected by
Thanks for your answer @mbalestri
by (670 points)
Powered by Question2Answer
...