when loading data to olap error occures
436315Sep 7 2005 — edited Sep 13 2005Dear guys, I think I have sucessfully deployed the objects to OLAP using brige, but when I executed the work flow to load data into olap, error occures. Since I am new for OWB and OLAP, can anyone tell me how to check whether I have sucessfully deployed the objects to the OLAP?
Anyone can tell me what happened on earth and how to solve it?
Thank you very much
The errors is as follows:
note:LOAD_OLAP is a workflow to load data into dimensions and cubs,including load_time, load_item,load_subinvnetory,load_inventory.
Target_user is the target schema for deployment.
---------------------------------
begin to execute LOAD_OLAP
begin to start task LOAD_OLAP
executing task: LOAD_OLAP:LOAD_TIME
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.CWM2_OLAP_UTILITY", line 959
ORA-01403: no data found
ORA-06512: at "OLAPSYS.DBMS_AWM_PRV", line 115
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.CWM$OLAP$DIMENSION", line 242
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.CWM$UTIL", line 341
ORA-01403: no data found
ORA-06512: at "TARGET_USER.WB_OLAP_LOAD_DIMENSION", line 1
ORA-06512: at line 1
completing the task: LOAD_OLAP:LOAD_TIME
begin to start LOAD_OLAP:LOAD_ITEM
ORA-06550: line 1, column 40:
PLS-00201: identifier 'AW_INVENTORY' must be declared
ORA-06550: line 1, column 22:
PL/SQL: Item ignored
ORA-06550: line 1, column 86:
PLS-00201: identifier 'TARGET_USER' must be declared
ORA-06550: line 1, column 68:
PL/SQL: Item ignored
ORA-06550: line 1, column 137:
PLS-00357: Table,View Or Sequence reference 'INVENTORY_ITEM' not allowed in this context
ORA-06550: line 1, column 119:
PL/SQL: Item ignored
ORA-06550: line 1, column 192:
PLS-00201: identifier 'TARGET_USER' must be declared
ORA-06550: line 1, column 174:
PL/SQL: Item ignored
ORA-06550: line 1, column 247:
PLS-00201: identifier 'AW_ITEM' must be declared
...