Error in phase import Homogeneous system copy from...

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

面冷心慈的树叶 · 天天爱消除游戏隐私保护指引· 2 月前 ·

深情的可乐 · 浙江大学2020年山东省综合评价录取招生简章· 3 月前 ·

憨厚的课本 · 每个人都能感受到，一场深刻的变革正在进行！- ...· 3 月前 ·

沉稳的萝卜 · 企业破产法四大"亮点" 职工工资等费用优先受偿· 5 月前 ·

强健的熊猫 · 使用 ALLOW-FROM 值 | ...· 5 月前 ·

I'm doing a Homogeneous system copy from a BI 7.3 dual stack ABAP+JAVA system with an Oracle DB (11g version, 11.2.0.3.0 patch level) with AIX ibm OS.

Before starting export I've executed in the source system the report SMIGR_CREATE_DDL, as described in sap note 888210, and I generated *.SQL files.

After, during the import in the target system I get the following error message:

vi /expdb2/tmpDB0/sapinst_instdir/NW730/ORA/ORA/COPY/ORA/SYSTEM/STD/AS/import_monitor.log

INFO: 2014-03-08 00:21:57 com.sap.inst.migmon.LoadTask run_report

Monitor jobs: running 0, waiting 1, completed 60, failed 5, total 66 finish processing of package SAP0000

You can see below the detail of the 5 packages in error:

SAPAPPL0_1_5

DbSlExecute: rc = 99

(SQL error 2216)

error message returned by DbSl:

ORA-02216: tablespace name expected

(DB) INFO: disconnected from DB

/usr/sap/DB2/SYS/exe/uc/rs6000_64/R3load: job finished with 1 error(s)

/usr/sap/DB2/SYS/exe/uc/rs6000_64/R3load: END OF LOG: 20140307141347

SAPZPSA

DbSlExecute: rc = 99

(SQL error 2216)

error message returned by DbSl:

ORA-02216: tablespace name expected

(DB) INFO: disconnected from DB

SAPDODS

DbSlExecute: rc = 99

(SQL error 922)

error message returned by DbSl:

ORA-00922: missing or invalid option

(DB) INFO: disconnected from DB

SAPDFACT

DbSl Trace: Error 1741 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01741 occurred when executing SQL stmt (parse error offset=8126464)

(DB) ERROR: DDL statement failed

( ALTER TABLE "/BI0/F0TCT_C01" ADD PARTITION "/BI0/F0TCT_C010000001131" VALUES LESS THAN ( 0000001131 ) TABLESPACE "" )

DbSlExecute: rc = 99

(SQL error 1741)

error message returned by DbSl:

ORA-01741: illegal zero-length identifier

(DB) INFO: disconnected from DB

SAPZOSO

DbSl Trace: Error 922 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-00922 occurred when executing SQL stmt (parse error offset=242024448)

(DB) ERROR: DDL statement failed

(CREATE TABLE "/BIC/B0000989000" ("REQUEST" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "DATAPAKID" VARCHAR2 (000018) DEFAULT '000000' NOT NULL, "PART

NO" NUMBER (000010) DEFAULT 0 NOT NULL, "RECORD" NUMBER (000010) DEFAULT 0 NOT NULL, "PLANT" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "MATERIA

L" VARCHAR2 (000054) DEFAULT ' ' NOT NULL, "RPA_CURUOM" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "RPA_MVF" NUMBER (000017, 000002) DEFAULT 0 NOT N

ULL, "PRICE_UNIT" NUMBER (000017, 000003) DEFAULT 0 NOT NULL, "RPA_QTYUOM" VARCHAR2 (000009) DEFAULT ' ' NOT NULL, "RT_SSMFGR" VARCHAR2 (000024)

DEFAULT '00000000' NOT NULL, "BASE_UOM" VARCHAR2 (000009) DEFAULT ' ' NOT NULL, "FRE_PLNPUR" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "FRE_MINS

TK" NUMBER (000017, 000003) DEFAULT 0 NOT NULL, "FRE_SERLEV" NUMBER (000017, 000003) DEFAULT 0 NOT NULL, "FRE_SELCLS" VARCHAR2 (000003) DEFAULT '

0' NOT NULL, "FRE_REPLST" VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "ABCKEY" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "RECORDMODE" VARCHAR2 (000003)

DEFAULT ' ' NOT NULL, "RT_SERVLEV" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "RT_SUPS" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "VAL_TYPE" VARCH

AR2 (000030) DEFAULT ' ' NOT NULL, "PUR_GROUP" VARCHAR2 (000009) DEFAULT ' ' NOT NULL, "RT_VPNEU" NUMBER (000017, 000002) DEFAULT 0 NOT NULL,

"CURRENCY" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "RT_VRKPE" NUMBER (000017, 000003) DEFAULT 0 NOT NULL, "DISMM" VARCHAR2 (000006) DEFAULT ' '

NOT NULL, "SALES_UNIT" VARCHAR2 (000009) DEFAULT ' ' NOT NULL, "RT_VP_BT" NUMBER (000017, 000002) DEFAULT 0 NOT NULL, "RT_VPE_BT" NUMBER (000017,

000003) DEFAULT 0 NOT NULL, "RT_VP_NT" NUMBER (000017, 000002) DEFAULT 0 NOT NULL, "RT_VPE_NT" NUMBER (000017, 000003) DEFAULT 0 NOT NULL, "R

T_VWAERBT" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "RT_VWAERNT" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "RT_VPMEIBT" VARCHAR2 (000009) DEFAULT '

' NOT NULL, "RT_VPMEINT" VARCHAR2 (000009) DEFAULT ' ' NOT NULL, "LOC_CURRCY" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "UNIT" VARCHAR2 (000009)

DEFAULT ' ' NOT NULL, "CM_MCATDIV" VARCHAR2 (000054) DEFAULT ' ' NOT NULL, "CM_CDT1" VARCHAR2 (000054) DEFAULT ' ' NOT NULL, "CM_CDT2" VARCHAR2

(000054) DEFAULT ' ' NOT NULL, "CM_CDT3" VARCHAR2 (000054) DEFAULT ' ' NOT NULL, "CM_CDT4" VARCHAR2 (000054) DEFAULT ' ' NOT NULL, "CM_HIEID"

VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "CPSTLC" NUMBER (000017, 000002) DEFAULT 0 NOT NULL, "CPSVLC" NUMBER (000017, 000002) DEFAULT 0 NOT NULL

, "STOCK_VAL" NUMBER (000017, 000002) DEFAULT 0 NOT NULL, "STOCK_QTY" NUMBER (000017, 000003) DEFAULT 0 NOT NULL, "RT_SEASON" VARCHAR2 (000012)

DEFAULT ' ' NOT NULL, "RT_SEASYR" VARCHAR2 (000012) DEFAULT '0000' NOT NULL, "CALDAY" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "CALWEEK"

VARCHAR2 (000018) DEFAULT '000000' NOT NULL, "RF_BNDID" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "/BIC/ZCATTR3" VARCHAR2 (000006) DEFAULT ' ' NOT

NULL, "/BIC/ZCSTYLE" VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "/BIC/ZCIMAGE" VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "/BIC/ZCBRNDTYP" VARCHAR2 (000

003) DEFAULT ' ' NOT NULL, "/BIC/ZCGROUPE" VARCHAR2 (000054) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE STORAGE (

INITIAL 0000000016 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0000

FREELISTS 001 FREELIST GROUPS 01) PARTITION BY RANGE ("PARTNO") ( PARTITION "/BIC/B00009890000000000002" VALUES LESS THAN (00000

00002) NOCOMPRESS ) )

DbSlExecute: rc = 99

(SQL error 922)

error message returned by DbSl:

ORA-00922: missing or invalid option

(DB) INFO: disconnected from DB

hello,

Before anything update DB shared lib, R3load, R3ldctl and R3szchk in the target system. Also Check in source system if you have any tables o index missing in db02 transaction, If this system wa upgraded from a previous release please check TAORA and IAORA tables in source system and check all the tablespaces named in those tables are created in the target system.

let me know how it goes.

Regards,

Michael

in Technology Blogs by SAP 2024 Aug 15 in Technology Blogs by Members 2024 May 14 in Technology Blogs by Members 2024 Apr 26 in Technology Q&A 2024 Apr 22 in Technology Q&A 2023 Dec 11