HANA Express 2.0 SPS 01 The file requires "db://SBOOK" which is not provided by any file

[Former Member]

Having finally successfully installed HANA EXPRESS 2.0 SPS 01 (VM) on my 32GB RAM Notebook (24GB RAM for VM,4CPUs) I am now attempting to do the updated version of exercises for HANA 2 (SPS 0) of the OpenSAP HANA5 course (https://open.sap.com/courses/hana5/items/edjLJOYlvU7cH6q6bLpLM).

As per exercise 2.7 step 4 on page 64 of the document (openSAP_HANA5_Master_HANA2_HandsOn.pdf):

https://open.sap.com/files/7a5b026b-52b1-4f92-81a8-863dc4b54dee

I select the "core_db" folder and choose Build-Build but received the following 2 errors in SAP Web IDE for SAP HANA:

Error: The file requires "db://SBOOK" which is not provided by any file [8212001] at "src/data/FLIGHT.hdbcds" (2:1-25) 
Error: The file requires "db://SFLIGHT" which is not provided by any file [8212001]at "src/data/FLIGHT.hdbcds" (1:1-28)

I have also dumped the console log into a text file and attached it below:

exercise-2-7-issue-with-flight-hdbcds.txt

The errors point to the two "USING" statement of file "FLIGHT.hdbcds", which I have copied from the solution template/example (https://github.com/SAP/com.sap.openSAP.hana5.example/blob/hana2_sps01/core_db/src/data/FLIGHT.hdbcds)

using SFLIGHT as FLIGHTTBL;
using SBOOK as BOOKINGS;

Strangely, if I only choose the affected file "FLIGHT.hdbcds" (instead of the module core_db) and right click "Build selected file", the Build process ended successfully.

This implies that the "FLIGHT.hdbcds" itself is not the issue but the dependencies with other files within the module "core_db".

I am not sure whether it has to do with the exercise document being on HANA 2.0 SPS0 while the template/example solution is on SPS 01.

Thanks for any hint.

Sunny

[thomas_jung · Accepted solution]

Have you created the synonym files? These would have been created in Exercise 2.5. Did you perhaps skip that exercise and now are missing that item when you try to do exercise 2.7?

[Former Member · Accepted solution]

Hi Thomas, thank you so much for your hint.

I did not skip any exercise and I did create the synonym files. It wasn't until I realized, thanks to your hint and Github example, that I created the folder "synonyms" (Exercise 2.6 step 16 on page 61) under the module/folder "core_db" instead of creating it under the folder "core_db/src". Once I moved it under "core_db/src" and chose Build->Build, it went smooth and ended successfully as seen in the attachment.

exercise-2-7-issue-with-flight-hdbcds-solved.png

Sunny