Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

when loading data to olap error occures

436315Sep 7 2005 — edited Sep 13 2005
Dear 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
...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2005
Added on Sep 7 2005
1 comment
377 views