CMIS Workbench: - no proxy settings - error

[former_member387626]

Hello colleagues,

I do the course 'Introduction to SAP HANA Cloud Platform' week 3 unit 4 and I have a problem to load with the CMIS Workbench the file.

I think there is a wrong proxy setting, but I don not know how to set the right values. Can one of you help me? The error is:

Exception: CmisConnectionException

Cannot access "https://opsensapw3u4d0%%%%%trial.hanatrial.ondemand.com/hello-world/cmis/json/": opsensapw3u4d0%%%%%trial.hanatrial.ondemand.com

Cause: UnknownHostException

opsensapw3u4dd0%%%%%trial.hanatrial.ondemand.com

The CMIS Workbench could not connect to the server.

Check your URL and your network and proxy settings.

Current proxy settings:

- no proxy settings -

Best regards and thank you,

Dietmar

[Former Member · Accepted solution]

In the meantime the workbench should support the standard proxy env variables, so e.g. for unix/osx this would be:

export https_proxy=http://proxy:8080

export http_proxy=http://proxy:8080

I guess on Windows you use set instead of export.

If that does not help you could as well directly edit the workbench.bat/workbench.sh and enter the proxy there (see e.g.

Regards,

Dieter

[former_member387626 · Accepted solution]

Hello Dieter,

I'm on Windows and with the commands

set https_proxy=http://proxy:8080

set http_proxy=http://proxy:8080

executed before the workbench command, this solves the issues.

Thank you and best regards,

Dietmar

[former_member208047 · Accepted solution]

Hello Dieter,

I have the same issue. My application is working but I can't set up the CMIS connection.

https://opensapw3u4i849681trial.hanatrial.ondemand.com/hello-world

I was getting the same error intially as the one described in this question. But, on incorporating the changes in the solution provided, I get a new error:

Exception: CmisConnectionException Parsing exception!

Cause: JSONParseException null

  The provided URL does not return a JSON response. Check your URL, the binding, and your proxy settings.  Some servers return a HTML login page if the credentials are incorrect. Check your credentials.    Current proxy settings:

HTTP proxy:

proxy:8080

HTTPS proxy:

proxy:8080

I would highly appreciate your assistance in resolving this issue.

Thanks

[Former Member · Accepted solution]

For the workbench to work, you need to point it to the CMIS endpoint (and not the simple servlet that responds with some text).

The URL should be

https://opensapw3u4i849681trial.hanatrial.ondemand.com/hello-world/cmis/json

Regards,

Dieter

[former_member208047 · Accepted solution]

Hi Dieter,

I indeed used the url:

https://opensapw3u4i849681trial.hanatrial.ondemand.com/hello-world/cmis/json

But I am getting the same error as described earlier. Could you please suggest me what's wrong at my end. If I don't use

set https_proxy=http://proxy:8080

set http_proxy=http://proxy:8080

Then I get the same error as the question. But when I set these parameters,
I get the following error:

Exception: CmisConnectionException Parsing exception!

Cause: JSONParseException null

  The provided URL does not return a JSON response. Check your URL, the binding, and your proxy settings.  Some servers return a HTML login page if the credentials are incorrect. Check your credentials.    Current proxy settings:

HTTP proxy:

proxy:8080

HTTPS proxy:

proxy:8080

I would highly appreciate your assistance in resolving this issue.

Thanks

[former_member208047 · Accepted solution]

Hi there !

For those of you who are going through the course now or would like to take it in the future, there is a minor change you would have to make. With great help from Dieter Guendisch, I was able to fix the above stated issue. 

Please refer the following steps:

Cockpit -> Your application -> Authentication Configuration -> Custom -> Make sure the username and password field is checked.

Also, go to the roles tab under your application and assign your user ID to the openSAPDeveloper role. 

Restart the cockpit and application for the changes to take effect. And you should be able to get the desired results now.

Regards,
Arush

[SAP_Gopal · Accepted solution]

Hi Arush,

The solution by you was helpful.

Thanks and Best Regards,

Gopal

[former_member208047 · Accepted solution]

Hi Gopal,

I'm glad the solution was helpful.

Regards

[former_member502434 · Accepted solution]

Many thanks for this update. I would have never made it otherwise.

[former_member342307 · Accepted solution]

Many thanks Arush and Dieter !! Just doing the openSAP-course Intro SAP HANA PLATFORM right now and this info is still very much applicable !!

And for those coming behind: do not like me upon finding this nugget...forgetting to save upon checking the username and password box in the FORM area. Took me another 5 minutes plus a stop & start.

regards,

Bart

[Former Member · Accepted solution]

Thank you, this solved the problem