Posted on behalf of an Exor user.
Error message appears when trying to run the Inventory Loader stage 2:
oracle error: ora-00942: table or view does not exist
occured in: dl_lo_3_drop
It seems that the hhinv_load_3 table is missing so you need to create one and restart the load from stage 1.
Please run the following query in SQL*Plus or SQL Developer when logged on as a user doing the load to create a table:
create table hhinv_load_3 as (select * from hhinv_load_2 where 1>1);
Once the table is created you should run the cleaninv script (or maiclinv if run through Exor FasPath) and restart the load from stage 1.
Let me know if you are not familiar with cleaninv and do not have maiclinv installed and I will send it through to you.
Answer Verified By: Sarah Willis-Culpitt
A sql desc of hhinv_load_3 suggests its already there - albeit with 0 rows
The above results suggest that the user DEDYCBH2 does not have the HHINV_LOAD_3 table. Please run the following logged on as the user DEDYCBH2 to create the table:
Created the table as above and re-run the load.
Now get the following error reported in GRI0210:
Database type is: Maintenance Manager
info: beginning start up stage..........BPR8506
module called sql_err() function
oracle error
ORA-01403: no data found
occured in : get_run_num
Please run the MAICLINV script through FastPath in Exor and restart the load from stage 1.
If you do not have the MAICLINV installed in your system this wiki article explains how to do that http://communities.bentley.com/products/assetwise/exor/w/wiki/how-to-clear-ukpms-temporary-tables.aspx
Have loaded and run the maiclinv script and restarted the load
Failed again on stage 2 (GRI0210 - BPR8506) with same error
occurred in : get_run_num
This is for non highways user - works OK for highways user
Have you run maiclinv as DEDYCBH2 user? You need to run it as a user getting the error because running as Highways user will only clear Highways user’s tables.