Home » Developer & Programmer » Data Integration » data loading to olap occures error
data loading to olap occures error [message #136301] Wed, 07 September 2005 08:08
jonazjp
Messages: 1
Registered: September 2005
Junior Member
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
ORA-06550: line 1, column 229:
PL/SQL: Item ignored
ORA-06550: line 1, column 470:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 1, column 433:
PL/SQL: Statement ignored
completing task LOAD_OLAP:LOAD_ITEM
starting task LOAD_OLAP:LOAD_SUBINVENTORY
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 'SUBINVENTORY' not allowed in this context
ORA-06550: line 1, column 119:
PL/SQL: Item ignored
ORA-06550: line 1, column 190:
PLS-00201: identifier 'TARGET_USER' must be declared
ORA-06550: line 1, column 172:
PL/SQL: Item ignored
ORA-06550: line 1, column 245:
PLS-00201: identifier 'AW_SUBINVENTORY' must be declared
ORA-06550: line 1, column 227:
PL/SQL: Item ignored
ORA-06550: line 1, column 476:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 1, column 439:
PL/SQL: Statement ignored
completing task LOAD_OLAP:LOAD_SUBINVENTORY
starting task LOAD_OLAP:LOAD_INVENTORY
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 132:
PLS-00357: Table,View Or Sequence reference 'INVENTORY' not allowed in this context
ORA-06550: line 1, column 114:
PL/SQL: Item ignored
ORA-06550: line 1, column 177:
PLS-00201: identifier 'TARGET_USER' must be declared
ORA-06550: line 1, column 159:
PL/SQL: Item ignored
ORA-06550: line 1, column 227:
PLS-00201: identifier 'AW_INVENTORY' must be declared
ORA-06550: line 1, column 209:
PL/SQL: Item ignored
ORA-06550: line 1, column 450:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 1, column 418:
PL/SQL: Statement ignored
completing task LOAD_OLAP:LOAD_INVENTORY
completing task LOAD_OLAP
completing LOAD_OLAP
Previous Topic: OWB changing runtime database version
Next Topic: Informactica Mappings
Goto Forum:
  


Current Time: Sat Apr 04 23:31:41 CDT 2020