Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
55 REPLIES 55

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos
3,704

Thank you for being the first @Cocquerel !

Was there any part that was in any way difficult?

Btw, I know that I mostly published steps to execute, but I think about adding more explanations and references to that too.

Cocquerel
Active Contributor
3,682

Just one comment, the step to create myDevChallenger user store entry is missing

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos
3,654

Indeed, step 9 was missing 😖

Fixed now. Thank you!

Please let me know, if there is any other feedback.

MioYasutake
Active Contributor
3,626

My week1 submission here.

MioYasutake_0-1717705598610.png

In Step8, I first executed the command as-is (`sh ~/sap/hdbclient/hdbsql -U myDBAdmin`), and got an error:

MioYasutake_1-1717705656991.png

After reviewing the screenshot below the instructions, I realized that 'sh' was not required.

 

0 Kudos
3,607

Thank you for joining, and thank you for reporting the typo in Step 8. Fixed.

Have you had any other problems with commands or systems?

0 Kudos
3,568

@Vitaliy-R 

I had no other problems while executing the exercise.

sagarsv
Explorer
3,507

Done week 1 😃 
Very smooth documentation and clearly understood the steps.

sagarsv_0-1717758612338.png

 

asm_sapdev
Explorer
3,504

My week1 submission

asm_sapdev_1-1717759171618.png

I raised an issue earlier but when I followed the steps second time, it worked. I think in the background HANA Cloud was not running that might have caused the issue.

gphadnis2000
Participant

DirkO
Participant
3,117

My week1 submission here.

DirkO_0-1717876105331.png

The issues I had were not comming from exercise description, they were 100% PICNIC. 😀

Many thanks Witalij for this awesome developer challenge. 👍

 

Alpesa1990
Participant
3,085

My submission:

Alpesa1990_0-1717891479736.png

The challenge is very well explained!

Congrats!

 

ajmaradiaga
Developer Advocate
Developer Advocate

moh_ali_square
Participant
2,737

Hi, 

Thanks for the challenge. Here is my submission. two parts due to screen size 💻

Submission_1.pngSubmission_2.png

christof_m
Explorer
2,650

Hi Vitaliy, here is my submission.
Everything worked very well, I like the red numbered markers on the screenshots.
Thanks again also for the great Code Jam ("Getting started in Machine learning") last monday in Mannheim 

christof_marte_0-1718051228766.png

 

geek
Participant
2,612

Yesterday, the keystore just wouldn't respond and threw errors, today, no issues:

geek_0-1718095092929.png

satyasundar3
Explorer

tobiasz_h
Active Participant

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos
2,480

Hi John. I see you pasted all the separate Python statements into a single IPython execution.

Was it on purpose? 🤓 

chirag_makwana
Explorer

CameronWilson
Explorer

VS_Chandu
Associate
Associate

SushmitaG
Product and Topic Expert
Product and Topic Expert
2,385

Finally with little bit of struggle I am able to complete the challenge.Screenshot 2024-06-12 at 10.35.41 AM.png

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos
2,352

Thank you @SushmitaG  🤓 What part(s) did you struggle with, if I may ask?

SushmitaG
Product and Topic Expert
Product and Topic Expert
0 Kudos
2,346

Hi @Vitaliy-R , I was facing authentication error while creating DB user. Finally it is resolved after receiving so many inputs from you and from the fellow developers 😀.

JerryW
Explorer

reachdebopriya
Active Participant
2,148

Hello,

Issue resolved.

Done.

reachdebopriya_2-1718301540663.pngreachdebopriya_3-1718301578427.png

Regards,

Debopriya Ghosh

 

 

0 Kudos
2,145

Hi @reachdebopriya From what I can read "... path '/home/user/.hdb/workspaces-ws-mjlvr' failed, rc=2:No such file or directory")"

What is the output of the following commands in the BAS terminal for you?

ls -la /home/user/.hdb/

and

echo ${WORKSPACE_ID}

?

Srijani
Explorer
0 Kudos
2,091

Hi ,

I have done the Week 1 Excercise.

Srijani_1-1718323710534.png

 

Srijani_0-1718323661064.png

Thanks and Best Regards

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos
2,006

Hi @Srijani As I can see from your screenshots, the setup was not done correctly and you were not able to connect from Python to your SAP HANA db with the user key.

I see you are getting error when connecting and the error returns the correlation-id.

Check the error reason behind this correlation id using the suggestions from https://community.sap.com/t5/application-development-discussions/questions-re-quot-multi-model-with-...

and fix it.

Resubmit your screenshot with the fixed situation after that, please.

1,980

Hi,

Sorry, I did not notice it. My Credentials were wrong somehow for DBAdmin. At step 7 I received error yesterday, but then tried with the SQL Endpoint , it worked there but the saved credential was wrong maybe.

I rectified it.. please find the  correct Screenshot

Srijani_0-1718398782978.png

Thanks and Regards,

Srijani

 

mwn
Participant
1,886

In [5]: %sql hana://userkey=myDevChallenger

In [6]: %sql SELECT Current_User FROM DUMMY
* hana://userkey=myDevChallenger
Done.
Out[6]: [('DEVCHALLENGER',)]

In [7]: %sql hana://userkey=mydbadmin

In [8]: %sql
...: hana_db_info = %sql SELECT "KEY", "VALUE" FROM "M_HOST_INFORMATION" WHERE "KEY" IN ('build_cloud_edition', 'start_time')
hana://userkey=myDevChallenger
* hana://userkey=mydbadmin
hana://userkey=myDevChallenger
* hana://userkey=mydbadmin
Done.

In [9]: type
Out[9]: type

In [10]: type(hana_db_info)
Out[10]: sql.run.ResultSet

In [11]: hana_db_info.DataFrame()
Out[11]:
key value
0 build_cloud_edition 2024.2.16
1 start_time 2024-06-16 09:19:51.482

In [12]: print("That's the end of the setup exercise!")
That's the end of the setup exercise!

In [13]: quit