Skip to Content
Author's profile photo Rui Nogueira

Course guide “Introduction to SAP HANA Cloud Platform (repeat)” – week 3

Overview

ENROLL TO THE COURSE HERE (in case you haven’t, yet): Course: Introduction to SAP HANA Cloud Platform (repeat)

You can find a list of the course guides for each week of this course in the corresponding parent project of this blog post.

Course Guide Week 3 – Advanced Persistency Features

Hi everyone,

in the third week of the course Introduction to SAP HANA Cloud Platform we will provide you with some features of the Persistence Service and we’ll also look into the Document Service that stores unstructured data.

Find below additional information that can be useful to you during this course week. While monitoring the forums I’ll also add some sections around common mistakes and how to fix them into the corresponding units.

Table of Contents

Unit 1 – Local Development

Issues With This Unit

When going through this unit you’ll find a difference compared with the video. Read the blog post from Eli providing some help to get around that issue.

Additional Links

Unit 2 – Using HANA Modeler

Proxy settings

To be able to establish a database tunnel through the console client you need to have your proxy settings setup correctly. Just follow this instruction: https://help.hana.ondemand.com/help/frameset.htm?7613dee4711e1014839a8273b0e91070.html

Unit 3 – Introduction To The Document Service

Common issues

com.sap.ecm.api.ServiceException: Could not create repository. Document Service responded with http 400

One possibility for this error message can be that your password for your key is less than 10 characters long. Try to make the password at least 10 characters long and publish the code changes which should fix the issue.

Unit 4 – Consuming Document Service with External Tools

Unit 5 – Document Service Metadata & Queries

Assigned Tags

      42 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Ron or Rui.

      1. I misread the time as EST and I cannot take the week2 assignment as it is locked for me now.

      2. The other thing Is I was thinking I was pressing week 2 and pressed week 3 assignment

      but I have not read anything on week2. Can you please reset week3 for me.

      Thanks

      Bala

      Author's profile photo Former Member
      Former Member

      Hello Rui,

      When i was trying to work on the demo for week 2 unit 5 . After making all the changes when i restart the server to complete the demo I get following warnings and message which are attached can you please help me as to why this is happening./wp-content/uploads/2014/06/abc_485250.png/wp-content/uploads/2014/06/def_485251.png

      thanks

      Anu/wp-content/uploads/2014/06/ghi_485264.png

      Author's profile photo Former Member
      Former Member

      Hi Rui,

      While trying to work the example of week 3 unit 2, I get the following error message when I publish the changes:

      /wp-content/uploads/2014/06/error_publish_485600.jpg

      Thus the calculation view will not be displayed by the link "https://opensapw2u3s0000785840trial.hanatrial.ondemand.com/persistence-with-jdbc/ModelerTestServlet".

      Do have any advice ??

      Thanks Christian

      Update:  Problem solved (something was messed up with "  <web-app xmlns: .......".

      Author's profile photo Former Member
      Former Member

      Hi Rui,

      On week 3, unit 4, after about 9 minutes through the training I start my application opensapw3u4 but it fails to start. I get the following error message

      Server opensapw3u4.i062869trial at hanatrial.ondemand.com was unable to start within 120 seconds. If the server requires more time, try increasing the timeout in the server editor.

      Any ideas? I checked through each step of the code changes and validated each file.

      Do I just need to increase the timeout? or does this mean some sort of problem outside of the excercise

      Many Thanks
      Steve

      Author's profile photo Former Member
      Former Member

      Increasing the timeout is definitely the first step that you should do. There are circumstances when an application did not start in 120 secs. Just increase it to say 600 secs to be on the safe side. In case the app still fails to start, reply here so that we can have a deeper look.

      Author's profile photo Sebastian Lorberg
      Sebastian Lorberg

      Hi Rui,

      in Unit 4 I get an exception when starting the CMIS workbench connection:

      CMIS_WB_Exception.png

      This happend before and after I added the authentication role to my user.

      Regards,

      Sebastian

      Author's profile photo Former Member
      Former Member

      If you are behind a proxy, please open workbench.bat or workbench.sh and adapt the proxy settings there.

      Author's profile photo Sebastian Lorberg
      Sebastian Lorberg

      Thanks Dieter,

      your hint solved the problem.

      I was still behind our company proxy.

      Regards,

      Sebastian

      Author's profile photo Former Member
      Former Member

      Hi Rui,

      I'm stuck on Week 2 Unit 5 part. I get the window pop up when I try to select "Organize imports" Withe the selection option avilable (Screenshot below) I tried selecting few but its just brings more errors into the new code ? Please help. Thank you

      Regards,

      Indre

      /wp-content/uploads/2014/06/error_486921.png

      Author's profile photo Former Member
      Former Member

      See the official documentation.

      In general: prefer java.* packages over com.* ones

      Author's profile photo Former Member
      Former Member

      Hi Rui,

      I am in week3 unit 1.

      I got stuck at below screen, while creating a tunnel

          

      Please help me.

      Author's profile photo Former Member
      Former Member

      EXPORT is the command for unix-style OS while SET is the one for windows.

      See https://help.hana.ondemand.com/help/frameset.htm?7613dee4711e1014839a8273b0e91070.html

      Author's profile photo Marcelo Dudzin
      Marcelo Dudzin

      Hi Rui

      Everything was working spot on until I started unit 2 week 3.

      I have created the Trial Instance on the SAP Hana Cloud and I retrieved the Hana Instance opensap into Eclipse.

      Unfortunately, it does not allowing me to finish the Join in between the tables. Once I drag and drop the first field relation from BPA to SO, the system becomes unstable and it hangs.


      I have deleted the Trial instance and tried again with a different name opensap1, but I get stuck on the same point.

      I am not able to see the join between the 2 tables (i.e. the yellow line), althought I can see that the view is there.

      I am using a MAC.

      Does it looks to you that I am doing something wrong?

      I have tried to see if I can set the relation by hand in any other of the windows, but I am not able to see anything.

      Can you help me?

      Author's profile photo Twan van den Broek
      Twan van den Broek

      same issue over here. did you find a solution?

      kind regards

      Twan

      Author's profile photo Twan van den Broek
      Twan van den Broek

      Sorry Rui, you're right that's what the discussion forum is for 😉

      I posted mine: https://open.sap.com/courses/15/discussion_topics/7698

      Author's profile photo Rui Nogueira
      Rui Nogueira
      Blog Post Author

      Hi Marcelo, would you mind posting your question in the forum Here on SCN or (ideally) on the openSAP forum for this course and week? That's where all my other colleahues are monitoring and helping.

      Best,

      Rui

      Author's profile photo Former Member
      Former Member

      Hi Rui,

      While I was working in week 3 unit 2, while publishing in the last step I encountered an option to choose and from then onwards it is throwing an error. And i am not able to publish through ( opensapw2u3.p1940687684trial at hanatrial.ondemand.com) one.

      Please help me.

      Author's profile photo Klaus Billig
      Klaus Billig

      Hello Rui,

      Many thanks to you for providing this course. I really like following it. Now I need your help: In the video for week 3 unit 1 you mention a "Materials" folder or area where I can find the connection properties for the exercise?

      Thank you and kind regards,

      Klaus

      Author's profile photo Klaus Billig
      Klaus Billig

      Ooops, I just found it: It's the "connection.zip" in the "Download links" area of week 3 unit 1.

      Thanks anyway 🙂

      Connection.PNG

      Author's profile photo Former Member
      Former Member

      Hi,

      the links to the course materials (slides, files) for Week 3 are currently not working. Cannot get connection.zip or the other files.

      regards

      Andrew

      Author's profile photo Rui Nogueira
      Rui Nogueira
      Blog Post Author

      There is an issue with the openSAP platform we are trying to fix. Sorry.

      Best,

      Rui

      Author's profile photo Matthew Shaw
      Matthew Shaw

      I wonder if anyone can help?

      In the SAP HANA Cloud Platform Cockpit - under "HANA instances", when I click "New Trial Instance", give it a name of 'opensap' and then click save I get an error:

      Unable to create trial instance 'opensap': Internal Server Error (500)

      Unexpected exception in createSchema() called with account 'i049477trial', schema 'opensap', DB Type 'hanaxs', DB Version '1.00.74.00.390550', and DB Server 'null'



      Any ideas what the problem might be?

      Many thanks

      Matthew

      Author's profile photo Former Member
      Former Member

      I'm getting that myself as well 🙁

      Author's profile photo Matthew Shaw
      Matthew Shaw

      It's started to work now. I guess something was fixed. No change on my side!

      Author's profile photo Rui Nogueira
      Rui Nogueira
      Blog Post Author

      Today from 2-3pm we've had the regular update of the platform.

      Best,

      Rui

      Author's profile photo Former Member
      Former Member

      hello,

      Thanks for informative training sessions.

      Unfortunately, I am facing issues - clicking on the slide / ModelerTestServlet.zip returns "unexpected error occurred" page.

      http://help.sap.com/openSAP/HANACLOUD1-1/ModelerTestServlet.zip

      regards

      GeorgeICC_Q0019.jpg

      Author's profile photo Matthew Shaw
      Matthew Shaw

      The 'ModelerTestServlet.zip' file is not downloadable. I get an error. Could someone please re-share this?

      Thanks

      Matthew

      Author's profile photo Former Member
      Former Member

      Hello,

      The course content (slides, videos, transcripts) is not available. Is there anyway to fix this?

      Author's profile photo Rui Nogueira
      Rui Nogueira
      Blog Post Author

      Currently there is an issue with the openSAP platform we are trying to fix. Sorry.

      Best,

      RUi

      Author's profile photo Former Member
      Former Member

      hi rui,

      i am not able to open the CMIS workbecnh as i get follwoing error. I have added roles to my user but still getting this issue. I have checked my proxy settings too. I see everything okay but still this issue. Please help as i am not able to proceed any further.

      thanks

      Anu

      error.PNG

      Author's profile photo Former Member
      Former Member

      Hi Anu,

      hard to track alot of different errors in one discussion 🙂

      Please try to open the URL you use for the Workbench directly in your browser and report the result (as well as the URL). Please do this in a separate discussion thread.

      Thanks,

      Dieter

      Author's profile photo Former Member
      Former Member

      Hi Rui,

         I'm having an issue in W3U2 where after I connect to my newly created opensap instance, I cannot continue any further. I've pasted the error log messages as well. Thanks for your help.Image 1.JPGImage 2.JPGImage 3.JPG

      Author's profile photo Matthew Shaw
      Matthew Shaw

      Hello, I'm just finishing off this last unit and had hoped I could take the final exam this week as I'm on annual leave next week for 3 weeks. It appears I shall not have the opportunity to do the final exam. Is there anything anyone can do to make it available to me this week?

      Thank you

      Matthew

      Author's profile photo Rui Nogueira
      Rui Nogueira
      Blog Post Author

      Sorry Matthew. That is not possible.

      Best,

      Rui

      Author's profile photo Matthew Shaw
      Matthew Shaw

      Thanks Rui. I'll take the final test using my mobile phone whilst away. I'll be climbing some mountains in Switzerland. I bet no one else will be taking their OpenSAP course up a mountain!     Or will they?! 😉

      Wish me luck, I won't have access to all the PDF or any of the tools, web sites etc.

      Great course by the way Rui. Congratulations to you and the team. 🙂

      All the best,

      Matthew

      Author's profile photo Martin Knechtel
      Martin Knechtel

      Receiving the following error message when opening my column view.

      Screen Shot 2014-08-11 at 10.46.21.png

      Author's profile photo Martin Knechtel
      Martin Knechtel

      Just deleted and created the Trial Instance in the HANA Instances menu again and now it works.

      Author's profile photo Former Member
      Former Member

      Hello Rui,

      I have completed the steps in the week 3 unit 1 presentation but I am getting the below error while launching the applications on the localhost

      Cannot connect to jdbc:sap://localhost:30015/ [Cannot connect to host localhost:30015 [Connection refused: connect]

      Please advise.

      Thanks,

      Diptee

      Author's profile photo Former Member
      Former Member

      Hello Rui,

      The above issue is resolved, I noticed that I was incorrectly closing the db tunnel.

      Thanks,

      Diptee

      Author's profile photo Lucian Patrutu
      Lucian Patrutu

      Hi Rui,

      My web.xml is causing some problems.

      webxml.PNG

      This happened after I created the new servlet and added the resource ref for opensapDS.

      Could you please advise on the matter?

      Thanks,

      Lucian

      Author's profile photo Amanda Zhou
      Amanda Zhou

      Hi,

      in Unit 4 I get an exception when starting the CMIS workbench connection:

      CMIS_WB_Exception.png

      This happend before and after I added the authentication role to my user.

      May I ask how to set the proxy in the CMIS workbench? I can't find a button to allow me to do so.

      Thanks and Regards,

      Amanda

      Author's profile photo Former Member
      Former Member