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
Additional Links
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.
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
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.

thanks
Anu
Hi Rui,
While trying to work the example of week 3 unit 2, I get the following error message when I publish the changes:
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: .......".
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
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.
Hi Rui,
in Unit 4 I get an exception when starting the CMIS workbench connection:
This happend before and after I added the authentication role to my user.
Regards,
Sebastian
If you are behind a proxy, please open workbench.bat or workbench.sh and adapt the proxy settings there.
Thanks Dieter,
your hint solved the problem.
I was still behind our company proxy.
Regards,
Sebastian
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
See the official documentation.
In general: prefer java.* packages over com.* ones
Hi Rui,
I am in week3 unit 1.
I got stuck at below screen, while creating a tunnel
Please help me.
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
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?
same issue over here. did you find a solution?
kind regards
Twan
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
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
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.
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
Ooops, I just found it: It's the "connection.zip" in the "Download links" area of week 3 unit 1.
Thanks anyway 🙂
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
There is an issue with the openSAP platform we are trying to fix. Sorry.
Best,
Rui
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:
Any ideas what the problem might be?
Many thanks
Matthew
I'm getting that myself as well 🙁
It's started to work now. I guess something was fixed. No change on my side!
Today from 2-3pm we've had the regular update of the platform.
Best,
Rui
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
George
The 'ModelerTestServlet.zip' file is not downloadable. I get an error. Could someone please re-share this?
Thanks
Matthew
Hello,
The course content (slides, videos, transcripts) is not available. Is there anyway to fix this?
Currently there is an issue with the openSAP platform we are trying to fix. Sorry.
Best,
RUi
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
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
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.


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
Sorry Matthew. That is not possible.
Best,
Rui
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
Receiving the following error message when opening my column view.
Just deleted and created the Trial Instance in the HANA Instances menu again and now it works.
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
Hello Rui,
The above issue is resolved, I noticed that I was incorrectly closing the db tunnel.
Thanks,
Diptee
Hi Rui,
My web.xml is causing some problems.
This happened after I created the new servlet and added the resource ref for opensapDS.
Could you please advise on the matter?
Thanks,
Lucian
Hi,
in Unit 4 I get an exception when starting the CMIS workbench connection:
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
http://scn.sap.com/thread/3701811