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

[Vitaliy-R]

This discussion thread is for you to ask your questions and discuss issues if you are participating in the June 2024 developer challenge. The topic is "Multi-model processing with SAP HANA and Python in SAP Business Application Studio."

Please use separate discussions created for the submission of your solutions. Keep this thread for your questions only.

[abhijitmoholkar]

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.

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

Thanks in advance,

Regards

ASM

[Vitaliy-R]

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'"

[abhijitmoholkar]

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]

Getting below error.Could you please help.

[Vitaliy-R]

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

[gphadnis2000]

Yes Hana instance is running

ng.

[Vitaliy-R]

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?

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

[gphadnis2000]

Thanks Vitaliy.

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

[gphadnis2000]

Getting below error now.

[gphadnis2000]

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

[Ruthiel]

Hello @Vitaliy-R !
Thanks for this challenge!

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

[Vitaliy-R]

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" 

[abhi7733]

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.

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

What should I do, Please guide me.

Thanks,

Visha

[Vitaliy-R]

Hi @abhi7733 

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:

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

[satyasundar3]

Hi Vitaliy,

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

[Vitaliy-R]

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"

[satyasundar3]

@Vitaliy-R Thanks It worked.

[SushmitaG98]

Hi,

I am not able to validate my credentials. Which password do I need to enter?

[satyasundar3]

Use the password that you set in Step-8

[SushmitaG98]

Thanks for your suggestion. Issue is resolved now.

[Vitaliy-R]

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

[SushmitaG98]

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

[chirag_makwana]

Facing issue in Step-11

[chirag_makwana]

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

[Vitaliy-R]

Can you please check the message of this correlation id the way I described in: https://community.sap.com/t5/application-development-discussions/questions-re-quot-multi-model-with-...

?

Thank you!

[chirag_makwana]

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

[sagarsv]

Hello Vitaliy-R ,

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

regards

sagar

[Vitaliy-R]

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]

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"?

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

[Cocquerel]

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]

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 🤓

[Cocquerel]

indeed, it is now working. Thanks

[gphadnis2000]

Hi Vitaliy,

getting below error.

[Vitaliy-R]

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.

[gphadnis2000]

let me try that option

[Srijani]

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

[Srijani]

Hi Vitaliy-R,

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

[SushmitaG98]

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. 

[Alpesa1990]

Hi,

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

Thanks!