Skip to Content
0

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

Jun 21, 2017 at 12:52 AM

183

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Thomas Jung
Jun 23, 2017 at 07:06 PM
0

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?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0