cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP Export Fails for SAPAPPL0 in System Copy,ORA-00942: table or view does not exist

Former Member
0 Kudos

Hi...

I am doing the System Copy export  using below option.


SAP NetWeaver 7.0 Support Release 3 ------->Software life-cycle
options-------->System Copy-------->Oracle--------->SourceSystem
Export------>Central System ----->Based on AS ABAP and AS JAVA
----->Database and Central Instance Export .

In the Export monitor Jobs screen as shown below i m getting error in one Job.

When i checked inthe Directory..

cd /tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/AS/EXP>>   cat SAPAPPL0.log | more

Below are the logs of SAPAPPL0.log

*****************************************************************

(EXP) TABLE: "/BDL/BDLFUPDEF" #20130823170729

(EXP) TABLE: "/BDL/BDLFUPEXP" #20130823170729

(EXP) TABLE: "/BDL/BDLFUPIMP" #20130823170729

(EXP) TABLE: "/BDL/BDLFUVER2" #20130823170729

(EXP) TABLE: "/BDL/BDLFUVER3" #20130823170729

(EXP) TABLE: "/BDL/BDLFUVERS" #20130823170729

(EXP) TABLE: "/BDL/BDLGROUPS" #20130823170729

(EXP) TABLE: "/BDL/BDLREFSERV" #20130823170729

(EXP) TABLE: "/BDL/BDLSADATA" #20130823170730

(EXP) TABLE: "/BDL/BDLSERGRPS" #20130823170730

(EXP) TABLE: "/BDL/BDLSERTRAN" #20130823170730

(EXP) TABLE: "/BDL/BDLSERVICE" #20130823170730

(EXP) TABLE: "/BDL/BDLST14KEY" #20130823170730

(EXP) TABLE: "/BDL/LOCK" #20130823170730

(EXP) ERROR: DbSlExeRead failed
  rc = 103, table "/BI0/0100000004"
  (SQL error 942)
  error message returned by DbSl:
ORA-00942: table or view does not exist
(DB) INFO: disconnected from DB

/usr/sap/KBP/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/KBP/SYS/exe/run/R3load: END OF LOG: 20130823170731

*************************************************************************************************

Kindly help how can i solve the above error to proceed this export installation

Regards,

gayathri

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Advisor
Advisor
0 Kudos

Hello

rc = 103, table "/BI0/0100000004"

(SQL error 942)

error message returned by DbSl:

Check whether this table is present and activated in the SAP system - Tx SE11

Is the table present at the database ?
Additionally update the R3* tools and check whether it helps.

Regards

RB

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Gayathri,

       Did you execute SAP_DROP_TMPTABLES report before start of the xport?

If not, please go to SE14 -> enter the table -> see whether it is available in the database.

If not, you can set the table export status to ign and continue the export.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hello All,

Thanks to all for Valuable suggestions , responses and feed back.

Regards,

Gayathri.K

Reagan
Advisor
Advisor
0 Kudos

Also check this SAP note

Note 449891 - Temporary database objects in BW 3.x

Regards

RB

former_member184473
Active Contributor
0 Kudos

Hello Gayathri,

Ensure table /BI0/0100000004 is created in the database (SAP and DB dictionaries consistency).

Regards,

Eduardo Rezende