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: 

Questions re: "Multi-model with SAP HANA Cloud" developer challenge

Vitaliy-R
Developer Advocate
Developer Advocate
70 REPLIES 70

asm_sapdev
Explorer
0 Kudos

Hi,

I am excited to try out this new challenge. Thanks for a very detailed step-by-step instructions.

I am receiving an error in Step 9. I have created DevChallenger user and executed GRANT statement. No errors. I was able to complete sub-step 1 under Step 9 which is - Store the credentials of the DevChallenger user in the HANA Client user store similarly to what you did for the user DBAdmin, but now using the key myDevChallenger.

asm_sapdev_0-1717736718416.png

I am unsure about what I missed. Any guidance will be appreciated.

Thanks in advance,

Regards

ASM

0 Kudos

You should be able to check details for such correlation-id using DBAdmin and the query like

 

~/sap/hdbclient/hdbsql -U myDBadmin -jA "SELECT AUTHENTICATION_FOR, USER_NAME, REASON FROM SYS.AUTHENTICATION_ERROR_DETA
ILS WHERE CORRELATION_ID='55896626B5A4DC47A1D09B7F9BC1D2D5'"

 

VitaliyR_0-1717762535057.png

 

asm_sapdev
Explorer
0 Kudos

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
0 Kudos

Getting below error.Could you please help.

gphadnis2000_0-1717762451978.png

 

0 Kudos

Can you please check that your SAP HANA db is in the running state?

0 Kudos

Yes Hana instance is running

gphadnis2000_0-1717762723978.png

 

ng.

 

 

0 Kudos

The URL of your HANA db SQL endpoint

3d11-492b-bdcd-3189b1067789.hana.trial-us10.hanacloud.ondemand.com:443

is a bit too short and is missing 4 alphanumeric characters at the beginning.

Can you double-check if it matches the SQL Endpoint of your HANA db?

VitaliyR_0-1717775785241.png

You can see me getting the same error if I remove a few characters from the beginning of my HANA db endpoint.

Thanks Vitaliy.

It was issue with URL i did not notice.This worked for me.

i was able to rectify the error and have submitted my week 1 challenge of setup.

Ruthiel
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello @Vitaliy-R !
Thanks for this challenge!

I am also having an error in step 9!
Connection with my HANA DB:

Ruthiel_0-1717974793537.png

 

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Hi @Ruthiel  It seems you are the step 7, not 9.

It is most likely that the password stored in the key is incorrect, so I would suggest you try running the SQL statement using `hdbsql` but with host and user name instead of the user key, like:

 

~/sap/hdbclient/hdbsql -u DBAdmin -n 236b8dce-adfc-404f-93e9-ca01e10ddab1.hana.trial-us10.hanacloud.ondemand.com: 443 -jA "SELECT Current_User FROM DUMMY" 

 

VitaliyR_0-1718014831032.png

 

ayanv1
Discoverer
0 Kudos

Where will I get the step 7 information ?
When I am checking in BTP cockpit to create the instance in BAS, Create option is disable for me.

ayanv1_0-1718002912390.png

And when I am going to create service, "SAP Business Application Studio" it's showing that this service is already subscribed in my plan.

ayanv1_1-1718003049866.png



What should I do, Please guide me.

Thanks,

Visha

 

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Hi @ayanv1 

From your screenshot, I see you only have SAP Business Application Studio subscribed, but the SAP HANA Cloud application is missing. And I do not see any instance of SAP HANA Cloud db either.

Here is what it looks in my account:

VitaliyR_1-1718015189003.png

Have you completed step 1, deploying your own SAP HANA database in your BTP Trial?

 

satyasundar3
Explorer
0 Kudos

Hi Vitaliy,

I am getting the below error with Step-9. Can you please help me here ?

satyasundar3_0-1718093205303.png

 

It seems you tried to log on with the user DevChallenger and incorrect password too many times. You can see the policy:

~/sap/hdbclient/hdbsql -U myDBAdmin -jA "SELECT * FROM M_PASSWORD_POLICY"

...which by default is:

| PROPERTY                                    | VALUE |
| ------------------------------------------- | ----- |
| force_first_password_change                 | true  |
| last_used_passwords                         | 5     |
| minimum_password_lifetime                   | 1     |
| maximum_password_lifetime                   | 182   |
| maximum_unused_initial_password_lifetime    | 7     |
| maximum_unused_productive_password_lifetime | 365   |
| password_expire_warning_time                | 14    |
| minimal_password_length                     | 8     |
| password_layout                             | A1a   |
| detailed_error_on_connect                   | false |
| ignore_password_exclude_list                | false |
| maximum_invalid_connect_attempts            | 6     |
| password_lock_time                          | 1440  |
| password_lock_for_system_user               | true  |
14 rows selected (overall time 1604 usec; server time 240 usec)

 Try to unlock the user DevChallenger using the user DBAdmin, like:

~/sap/hdbclient/hdbsql -U myDBAdmin -jA "ALTER USER DevChallenger RESET CONNECT ATTEMPTS"

 

VitaliyR_0-1718099975289.png

 

SushmitaG
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

I am not able to validate my credentials. Which password do I need to enter?Screenshot 2024-06-11 at 7.35.18 PM.png

SushmitaG
Product and Topic Expert
Product and Topic Expert

Thanks for your suggestion. Issue is resolved now.

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

This should be the password of the DBAdmin administrator user, which you specified while creating the HANA db instance in point 3 of the step "Choose your license, instance name, and password": https://developers.sap.com/tutorials/hana-cloud-mission-trial-3.html#03f5ea2e-c7d4-4666-90ee-9f46df6...

SushmitaG
Product and Topic Expert
Product and Topic Expert

Thanks @Vitaliy-R . The issue is with role assignment to my user.

chirag_makwana
Explorer

0 Kudos

found an issue, it's due to myDevChallenger ID. however, I tried to store the credentials, its stating authentication failed .

chirag_makwana_2-1718129694852.png

 

Thanks, error was resolved by recreating devchallenger id. All steps completed and submissions done.

sagarsv
Explorer
0 Kudos

Hello Vitaliy-R ,

All the first excercise data is gone from trial workspace of BTP. when I try to redo , profile seemes not working.

sagarsv_0-1718201773920.png

 

regards

sagar

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Please check the complete description of the week 2: https://github.com/SAP-samples/sap-community-developer-challenge-hana-multimodel/blob/main/challenge...

I assume you should see all extensions after reloading the web browser.

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Btw, I just ran into the same issue... Do you get any similar errors in the panel when you pick the output from the "server"?

VitaliyR_1-1718220851343.png

In the meantime, I deleted and re-imported the profile same as during the Setup execise.

Cocquerel
Active Contributor
0 Kudos

When running "from gensim import downloader, models"

I'm getting the following error

ImportError: cannot import name 'triu' from 'scipy.linalg' (/home/user/projects/.venv/lib/python3.11/site-packages/scipy/linalg/__init__.py)

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

You were faster than me @Cocquerel 

The complete week 2 exercise was published just now: https://github.com/SAP-samples/sap-community-developer-challenge-hana-multimodel/blob/main/challenge...

It lists the proper `scipy` dependency version 🤓

gphadnis2000
Participant
0 Kudos

Hi Vitaliy,

getting below error.

gphadnis2000_0-1718262946169.png

 

0 Kudos

Hi @gphadnis2000, This error is in the external package `gensim`, not in my code, so it is a bit difficult for me to say what caused this particular error. Can you check what is there in the directory, where this package downloads the files to, i.e. in `/home/user/gensim-data/`?

Then try deleting that directory

rm -rf /home/user/gensim-data/

and restart that failed cell in the Jupyter Notebook.

Srijani
Explorer
0 Kudos

Hi,

I just started today. Regrading HANA Cloud Trial , The link given in the Tutorial (  https://developers.sap.com/group.hana-cloud-get-started-1-trial.html ) is not working , it's resulting in a "Page Not Found" error . Instead, If I try SAP HANA CIoud Trial system , I  am getting SAP HANA Cloud Basic Trial with SAP Academy journey which is producing a separate Credentials , therefore does not use the BTP Trial Account Credential . Is it fine ? or there is any other link for it ?

Thanks and Best Regards

srhrchro

Hi Vitaliy-R,

I have completed the Week1 Excercise . Have uploaded the screenshot.

 

 

 

SushmitaG
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @Vitaliy-R, For the week 2 challenge I am not getting (.venv) env in my kernal even though my profile is set to HANAwPy. Screenshot 2024-06-14 at 9.43.45 AM.png

0 Kudos

Hi,

Yesterday I have been working correctly but this morning I faced to the same problem, have you found the solution?

Thanks!