org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException: Web service call failed with code 500

Pentaho BI Platform Tracking | Mat Lowery | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Repro: 1. Create a PRPT within Agile BI. 2. Publish it to server using suzy. Get error dialog (see attached pdi.png). It says, "Connection Error: Could not connect to the selected server." Problems: a. The error message is misleading. The connection was made perfectly. b. The error occurs on Browse, before creating the data connection. Even unchecking the connection under "Publish Associated Items" does not bypass the error. c. The denial seems to be happening on a read operation but the permission being checked seems like a write operation. Stack trace on client: org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException: Web service call failed with code 500 at org.pentaho.platform.dataaccess.client.ConnectionServiceClient.getResultDocument(ConnectionServiceClient.java:519) at org.pentaho.platform.dataaccess.client.ConnectionServiceClient.getConnectionByName(ConnectionServiceClient.java:283) at org.pentaho.agilebi.spoon.publish.ModelServerPublish.getRemoteConnection(ModelServerPublish.java:135) at org.pentaho.agilebi.spoon.publish.ModelServerPublish.compareDataSourceWithRemoteConnection(ModelServerPublish.java:160) at org.pentaho.agilebi.spoon.publish.XulDialogPublish.checkDatasources(XulDialogPublish.java:446) at org.pentaho.agilebi.spoon.publish.XulDialogPublish.connect(XulDialogPublish.java:426) at org.pentaho.agilebi.spoon.publish.XulDialogPublish$4.run(XulDialogPublish.java:279) at java.lang.Thread.run(Thread.java:662) Stack trace on server: Caused by: org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException: ConnectionServiceImpl.ERROR_0001 - Permission is denied at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.ConnectionServiceImpl.getConnectionByName(ConnectionServiceImpl.java:120) at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.ConnectionServiceConcrete.getConnectionByName(ConnectionServiceConcrete.java:55) ... 86 more

    Pentaho BI Platform Tracking | 6 years ago | Mat Lowery
    org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException: Web service call failed with code 500
  2. 0

    Repro: 1. Create a PRPT within Agile BI. 2. Publish it to server using suzy. Get error dialog (see attached pdi.png). It says, "Connection Error: Could not connect to the selected server." Problems: a. The error message is misleading. The connection was made perfectly. b. The error occurs on Browse, before creating the data connection. Even unchecking the connection under "Publish Associated Items" does not bypass the error. c. The denial seems to be happening on a read operation but the permission being checked seems like a write operation. Stack trace on client: org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException: Web service call failed with code 500 at org.pentaho.platform.dataaccess.client.ConnectionServiceClient.getResultDocument(ConnectionServiceClient.java:519) at org.pentaho.platform.dataaccess.client.ConnectionServiceClient.getConnectionByName(ConnectionServiceClient.java:283) at org.pentaho.agilebi.spoon.publish.ModelServerPublish.getRemoteConnection(ModelServerPublish.java:135) at org.pentaho.agilebi.spoon.publish.ModelServerPublish.compareDataSourceWithRemoteConnection(ModelServerPublish.java:160) at org.pentaho.agilebi.spoon.publish.XulDialogPublish.checkDatasources(XulDialogPublish.java:446) at org.pentaho.agilebi.spoon.publish.XulDialogPublish.connect(XulDialogPublish.java:426) at org.pentaho.agilebi.spoon.publish.XulDialogPublish$4.run(XulDialogPublish.java:279) at java.lang.Thread.run(Thread.java:662) Stack trace on server: Caused by: org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException: ConnectionServiceImpl.ERROR_0001 - Permission is denied at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.ConnectionServiceImpl.getConnectionByName(ConnectionServiceImpl.java:120) at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.ConnectionServiceConcrete.getConnectionByName(ConnectionServiceConcrete.java:55) ... 86 more

    Pentaho BI Platform Tracking | 6 years ago | Mat Lowery
    org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException: Web service call failed with code 500

    Root Cause Analysis

    1. org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException

      Web service call failed with code 500

      at org.pentaho.platform.dataaccess.client.ConnectionServiceClient.getResultDocument()
    2. org.pentaho.platform
      ConnectionServiceClient.getConnectionByName
      1. org.pentaho.platform.dataaccess.client.ConnectionServiceClient.getResultDocument(ConnectionServiceClient.java:519)
      2. org.pentaho.platform.dataaccess.client.ConnectionServiceClient.getConnectionByName(ConnectionServiceClient.java:283)
      2 frames
    3. org.pentaho.agilebi
      XulDialogPublish$4.run
      1. org.pentaho.agilebi.spoon.publish.ModelServerPublish.getRemoteConnection(ModelServerPublish.java:135)
      2. org.pentaho.agilebi.spoon.publish.ModelServerPublish.compareDataSourceWithRemoteConnection(ModelServerPublish.java:160)
      3. org.pentaho.agilebi.spoon.publish.XulDialogPublish.checkDatasources(XulDialogPublish.java:446)
      4. org.pentaho.agilebi.spoon.publish.XulDialogPublish.connect(XulDialogPublish.java:426)
      5. org.pentaho.agilebi.spoon.publish.XulDialogPublish$4.run(XulDialogPublish.java:279)
      5 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame