Training DEN60EDU0104LAB03 - Create bv_wo_distance_from_storage base view

I'm trying to do this lab, I'm trying to creat from a query, I'm using Denodo supplied code and I get this error: (See below past the code) CODE\Tip: SQL query: select LATITUDE as lat_storage, LONGITUDE as lon_storage, ID as storage_id, (NVL(6387.7,0) * ACOS((sin(NVL(@lat_input,0) / 57.29577951) * SIN(NVL(LATITUDE,0) / 57.29577951)) + (COS(NVL(@lat_input,0) / 57.29577951) * COS(NVL(LATITUDE,0) / 57.29577951) * COS(NVL(LONGITUDE,0) / 57.29577951 - NVL(@lon_input,0)/ 57.29577951)))) as distance from STORAGES order by distance asc Tip: Sample values: lat_input: 0 lon_input: 0 Error executing sentence: com.denodo.util.exceptions.InternalErrorException: ORA-00942: table or view does not exist How do I fix this?
user
06-11-2019 13:51:15 -0500

1 Answer

Hi, The error could have occured if the table is not available or if you are trying to create the view by connecting to oracle with a different user. Please ensure that you have executed the script "DEN60EDU0104LAB01-Oracle.zip" in oracle and created a ds_web_orders data source using "website_sys" as the Login credential. After that, try to create the query from base view and now you will be able to access the base view. For more information, refer the lab modules of on-demand course. Hope this helps!
Denodo Team
08-11-2019 03:13:54 -0500
You must sign in to add an answer. If you do not have an account, you can register here