cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

R3load fail to create tables

Former Member

on ‎09-03-2010 8:58 PM

0 Kudos

Hi all,

I'm trying to migrate from solaris 9 to hpux 11.31 oracle 10.2.0.4 with SBP SAP_102044_201007_HPUXIA64.zip SAP 4.7

I'm using migmon

The export finish ok but in the import side R3load cannot create any table

more APQD.log

/sapmnt/PRO/exe/R3load: START OF LOG: 20100903140907

/sapmnt/PRO/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP

/sapmnt/PRO/exe/R3load: version R6.40/V1.4

Compiled Jun 28 2010 17:06:44

/sapmnt/PRO/exe/R3load -ctf I /sapcd/EXP4/DATA/APQD.STR /sapcd/EXP4/DB/DDLORA.TPL APQD.TSK ORA -l APQD.log

/sapmnt/PRO/exe/R3load: job completed

/sapmnt/PRO/exe/R3load: END OF LOG: 20100903140907

/sapmnt/PRO/exe/R3load: START OF LOG: 20100903140907

/sapmnt/PRO/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP

/sapmnt/PRO/exe/R3load: version R6.40/V1.4

Compiled Jun 28 2010 17:06:44

/sapmnt/PRO/exe/R3load -i APQD.cmd -dbcodepage 1100 -k 1W9gdUM50Dh01eqtd1Mt0Qe0 -l APQD.log -merge_bck -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(GSI) INFO: dbname = "PRO20100903100929 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "tvasappp "

(GSI) INFO: sysname = "HP-UX"

(GSI) INFO: nodename = "tvasappp"

(GSI) INFO: release = "B.11.31"

(GSI) INFO: version = "U"

(GSI) INFO: machine = "ia64"

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

DbSl Trace: ORA-922 occurred when executing SQL statement (parse error offset=298)

(DB) ERROR: DDL statement failed

(CREATE TABLE "APQD" ( "QID" VARCHAR2(20) DEFAULT ' ' NOT NULL , "TRANS" NUMBER(10) DEFAULT 0 NOT NULL , "BLOCK" NUMBER(10) DEFAULT 0 NOT NULL , "SEGMT" NUMB

ER(5) DEFAULT 0 NOT NULL , "MSGCOUNT" NUMBER(5) DEFAULT 0 NOT NULL , "VARLEN" NUMBER(5) DEFAULT 0 NOT NULL , "VARDATA" LONG ) TABLESPACE PSAP@SCHEMAID@ STOR

AGE (INITIAL 181190656 NEXT 0000010240K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 922)

error message returned by DbSl:

ORA-00922: missing or invalid option

(DB) INFO: disconnected from DB

/sapmnt/PRO/exe/R3load: job finished with 1 error(s)

my DDLORA.TLP

root@tvasappp:/sapcd/install42 # more DDLORA.TPL

prikey: AFTER_LOAD ORDER_BY_PKEY

seckey: AFTER_LOAD

cretab: CREATE TABLE &tab_name&

( /{ &fld_name& &fld_desc& /-, /} )

TABLESPACE &tablespace&

&compress&

&lob_cache&

STORAGE (INITIAL &init&

NEXT &next&

MINEXTENTS &minext&

MAXEXTENTS &maxext&

PCTINCREASE &pctinc& )

drptab: DROP TABLE &tab_name&

crepky: CREATE UNIQUE INDEX &pri_key&

ON &tab_name&

( &key_fld& /-, )

TABLESPACE &tablespace&

STORAGE (INITIAL &init&

NEXT &next&

MINEXTENTS &minext&

MAXEXTENTS &maxext&

PCTINCREASE &pctinc& )

NOLOGGING

...skipping...

prikey: AFTER_LOAD ORDER_BY_PKEY

seckey: AFTER_LOAD

cretab: CREATE TABLE &tab_name&

( /{ &fld_name& &fld_desc& /-, /} )

TABLESPACE &tablespace&

&compress&

&lob_cache&

STORAGE (INITIAL &init&

NEXT &next&

MINEXTENTS &minext&

MAXEXTENTS &maxext&

PCTINCREASE &pctinc& )

drptab: DROP TABLE &tab_name&

crepky: CREATE UNIQUE INDEX &pri_key&

ON &tab_name&

( &key_fld& /-, )

TABLESPACE &tablespace&

STORAGE (INITIAL &init&

NEXT &next&

MINEXTENTS &minext&

MAXEXTENTS &maxext&

PCTINCREASE &pctinc& )

NOLOGGING

COMPUTE STATISTICS ;

ALTER INDEX &pri_key& LOGGING

drppky: DROP INDEX &pri_key&

creind: CREATE &unique& INDEX &ind_name&

ON &tab_name&

( /{ &fld_name& /-, /} )

TABLESPACE &tablespace&

STORAGE (INITIAL &init&

NEXT &next&

MINEXTENTS &minext&

MAXEXTENTS &maxext&

PCTINCREASE &pctinc& )

NOLOGGING

COMPUTE STATISTICS ;

ALTER INDEX &ind_name& LOGGING

drpind: DROP INDEX &ind_name&

crevie: CREATE VIEW &view_name&

( /{ &fld_name& /-, /} )

AS &query&

drpvie: DROP VIEW &view_name&

trcdat: TRUNCATE TABLE &tab_name&

deldat: DELETE FROM &tab_name& &where&

negtab: LICHECK MLICHECK

negdat: LICHECK MLICHECK

negind: LICHECK0 MLICHECK0 LICHECK0 MLICHECK0

negvie:

negcpr:ARFCSSTATE ARFCSDATA ARFCRSTATE TRFCQDATA TRFCQIN TRFCQOUT TRFCQSTATE QRFCTRACE QRFCLOG

  1. table storage parameters

loc: APPL0 PSAPPRO 0000

APPL1 PSAPPRO 0000

APPL2 PSAPPRO 0000

CLUST PSAPPRO 0000

POOL PSAPPRO 0000

SDIC PSAPPRO 0

SDOCU PSAPPRO 0000

SLDEF PSAPPRO620 0000

SLEXC PSAPPRO620 0000

SLOAD PSAPPRO 0000

SPROT PSAPPRO 0000

SSDEF PSAPPRO620 0000

SSEXC PSAPPRO620 0000

SSRC PSAPPRO 0000

TEMP PSAPPRO 0000

USER PSAPPROUSR 0000

USER1 PSAPPROUSR 0000

sto: 0 0000000016K 0000000040K 0000000001 2147483645

1 0000000016K 0000000160K 0000000001 2147483645

10 0000000016K 0000655360K 0000000001 2147483645

11 0000000016K 0001310720K 0000000001 2147483645

12 0000000016K 0002621440K 0000000001 2147483645

13 0000000016K 0005242880K 0000000001 2147483645

14 0000000016K 0010485760K 0000000001 2147483645

2 0000000016K 0000000640K 0000000001 2147483645

3 0000000016K 0000002560K 0000000001 2147483645

4 0000000016K 0000010240K 0000000001 2147483645

5 0000000016K 0000020480K 0000000001 2147483645

6 0000000016K 0000040960K 0000000001 2147483645

7 0000000016K 0000081920K 0000000001 2147483645

8 0000000016K 0000163840K 0000000001 2147483645

9 0000000016K 0000327680K 0000000001 2147483645

  1. index storage parameters

loc: APPL0 PSAPPRO 0000

APPL1 PSAPPRO 0000

APPL2 PSAPPRO 0000

CLUST PSAPPRO 0000

POOL PSAPPRO 0000

SDIC PSAPPRO 0

SDOCU PSAPPRO 0000

SLDEF PSAPPRO620 0000

SLEXC PSAPPRO620 0000

SLOAD PSAPPRO 0000

SPROT PSAPPRO 0000

SSDEF PSAPPRO620 0000

SSEXC PSAPPRO620 0000

SSRC PSAPPRO 0000

TEMP PSAPPRO 0000

USER PSAPPROUSR 0000

USER1 PSAPPROUSR 0000

sto: 0 0000000016K 0000000040K 0000000001 2147483645

1 0000000016K 0000000080K 0000000001 2147483645

10 0000000016K 0000163840K 0000000001 2147483645

11 0000000016K 0000327680K 0000000001 2147483645

12 0000000016K 0000655360K 0000000001 2147483645

13 0000000016K 0001310720K 0000000001 2147483645

14 0000000016K 0002621440K 0000000001 2147483645

2 0000000016K 0000000160K 0000000001 2147483645

3 0000000016K 0000000640K 0000000001 2147483645

4 0000000016K 0000002560K 0000000001 2147483645

5 0000000016K 0000005120K 0000000001 2147483645

6 0000000016K 0000010240K 0000000001 2147483645

7 0000000016K 0000020480K 0000000001 2147483645

8 0000000016K 0000040960K 0000000001 2147483645

9 0000000016K 0000081920K 0000000001 2147483645

Any idea

Regards

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
‎06-26-2012 11:08 AM
0 Kudos

Hi folks.

The problem resides in a bug on scripts SQL files generated from SMIGR_CREATE_DDL.

You need to replace where is && to PSAPSR3 or other tablespace.

Regards.

Show replies
Show replies
former_member709110
Active Participant
‎09-03-2010 9:38 PM
0 Kudos

Hi ,

You might want to try by removing the clause &compress& from the DDLORA.TPL.

Regards,

Neel

Show replies
Show replies
Former Member
‎09-03-2010 9:54 PM
0 Kudos

Ok,

Trying

Thanks

Regards

Former Member
‎09-03-2010 10:00 PM
0 Kudos

It did not work

former_member709110
Active Participant
‎09-03-2010 10:24 PM
0 Kudos

Hi ,

Sorry that it didn't work . Are you using the latest R3load and dboraslib.o ? If not , you might want to try that.

Regards,

Neel

Former Member
‎09-03-2010 11:05 PM
0 Kudos

thanks for your help.

Problem is solved.

I changed DDLORA.TPL to the one in the install directory

Regards

Ask a Question