Post installation steps after SAP BW system copy

[Former Member]

Hi!

I am about to do post processsing steps after system copy of SAP BW system.

1) One of the steps is to delete all entries from tables DBSTATHORA, DBSTAIHORA, DBSTATIORA,

DBSTATTORA.

Question: what is the way to do this?

2) During the installation I received the error within import ABAP step.

(IMP) INFO: import of D010TAB completed (4477754 rows) #20090505133631

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

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "D010TAB~0" ON "D010TAB" ( "MASTER", "TABNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 423090176 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P000

ORA-01659: unable to allocate MINEXTENTS beyond 34 in tablespace PSAPSR3700

(DB) INFO: disconnected from DB

As solution I changed the the following lines within D010TAB.TSK:

from D010TAB~ 0 C err to D010TAB~0 C ign and

from D010TAB_{1 C err to D010TAB}1 C ign

Question:

how to create index manually after system copy?

Thnak you very much!

[Former Member]

Hi Everyone,

I got similar error while doing a Homogenous system copy using R3Load process for R/3 4.7 ext110 on windows 2003 Std Edt SP1 with Oracle 9.2 on 32bit intel platform, kernel 620.

-

---

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "D010TAB~0" ON "D010TAB" ( "MASTER", "TABNAME" ) TABLESPACE PSAPSR2620 STORAGE (INITIAL 0 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 1652)

error message returned by DbSl:

ORA-01652: unable to extend temp segment by 2560 in tablespace PSAPTEMP

-

---

SQL> CREATE UNIQUE INDEX D010TAB~0 ON SAPSR2.D010TAB (MASTER, TABNAME)

2 TABLESPACE PSAPSR2620 STORAGE (INITIAL 0 NEXT 0000000640K

3 MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0);

CREATE UNIQUE INDEX D010TAB~0 ON SAPSR2.D010TAB (MASTER, TABNAME)

*

ERROR at line 1:

ORA-00911: invalid character

-

---

I tried creating the index but I got the above error at D010TAB~0 as Oracle is not able to resolve the name. I am trying to find the index name which gets created so I can create the index maunally. Could someone share there knowledge and help us with the information.

Thanks in advance

Regards

gabbasis

[lbreddemann]

> CREATE UNIQUE INDEX D010TAB~0 ON SAPSR2.D010TAB (MASTER, TABNAME)

> *

> ERROR at line 1:

> ORA-00911: invalid character

You got that one because you didn't read properly what I wrote and forgot the " " around the index name.

Characters like ~ are special to Oracle and can only be addressed with " " around them.

That way Oracle knows 'this is just a string - I don't try to interpret it'.

So use

CREATE UNIQUE INDEX "D010TAB~0" ON ...

and you'll be fine.

regards,

Lars

[markus_doehr2]

> (CREATE UNIQUE INDEX "D010TAB~0" ON "D010TAB" ( "MASTER", "TABNAME" ) TABLESPACE PSAPSR2620 STORAGE (INITIAL 0 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

> DbSlExecute: rc = 99

> (SQL error 1652)

> error message returned by DbSl:

> ORA-01652: unable to extend temp segment by 2560 in tablespace PSAPTEMP

This is a different error and means that your temporary tablespace is not big enough to create the index. Increase PSAPTEMP and retry.

Just to add:

> I got similar error while doing a Homogenous system copy using R3Load process for R/3 4.7 ext110 on windows 2003 Std Edt SP1 with Oracle 9.2 on 32bit intel platform, kernel 620.

Oracle 9.2 is out of support (Note 1021844 - Oracle 9.2 Extended Support free until July 31, 2008)

Kernel 6.20 is long out of support (almost 4 years now! - See Note 803429 - Desupport 6.20 kernel).

Markus

[former_member204746]

truncate table sapsr3.DBSTATHORA;

truncate table sapsr3.DBSTAIHORA;

truncate table sapsr3.DBSTATIORA;

truncate table sapsr3.DBSTATTORA;

add a datafile for tablesapce PSAPSR3700:

brspace -c -u / -f tsextend

[lbreddemann]

>

> Hi!

>

> I am about to do post processsing steps after system copy of SAP BW system.

>

> 1) One of the steps is to delete all entries from tables DBSTATHORA, DBSTAIHORA, DBSTATIORA,

> DBSTATTORA.

> Question: what is the way to do this?

Simply run

TRUNCATE TABLE <table_name>;

for each of those tables.

Make sure to either logon as SAP<SID> or provide the owner of the tables with the statement.

> 2) During the installation I received the error within import ABAP step.

> (IMP) INFO: import of D010TAB completed (4477754 rows) #20090505133631

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

> DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)

> (DB) ERROR: DDL statement failed

> (CREATE UNIQUE INDEX "D010TAB~0" ON "D010TAB" ( "MASTER", "TABNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 423090176 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )

> DbSlExecute: rc = 99

> (SQL error 12801)

> error message returned by DbSl:

> ORA-12801: error signaled in parallel query server P000

> ORA-01659: unable to allocate MINEXTENTS beyond 34 in tablespace PSAPSR3700

> (DB) INFO: disconnected from DB

>

> As solution I changed the the following lines within D010TAB.TSK:

> from D010TAB~ 0 C err to D010TAB~0 C ign and

> from D010TAB_{1 C err to D010TAB}1 C ign

>

> Question:

> how to create index manually after system copy?

The problem here was the large INITIAL size clause.

If there is enough freespace at all in the tablespace this should work:

CREATE UNIQUE INDEX "D010TAB~0" ON "D010TAB" ( "MASTER", "TABNAME" ) TABLESPACE PSAPSR3700 NOLOGGING COMPUTE STATISTICS PARALLEL;

If I'm not wrong, the second index is just vice versa:

CREATE UNIQUE INDEX "D010TAB~1" ON "D010TAB" (  "TABNAME", "MASTER" ) TABLESPACE PSAPSR3700 NOLOGGING COMPUTE STATISTICS PARALLEL;

In general it is really not a good idea to skip the creation of unique indexes...

regards,

Lars

[Former Member]

Hi!

Many thanaks for your response!

Unfortunatel when I try to execute

>CREATE UNIQUE INDEX "D010TAB~0" ON "D010TAB" ( "MASTER", "TABNAME" ) TABLESPACE

> PSAPSR3700 NOLOGGING COMPUTE STATISTICS PARALLEL;

I get the error: Table or view does not exist

Is there other possiblities to solve this problem?

My problem is that all dialog processes are busy for this program "D010TAB" with sequntial reading.

Thank you very much!

regards

Jürgen

[lbreddemann]

>

> Hi!

> Many thanaks for your response!

>

> Unfortunatel when I try to execute

> >CREATE UNIQUE INDEX "D010TAB~0" ON "D010TAB" ( "MASTER", "TABNAME" ) TABLESPACE

> > PSAPSR3700 NOLOGGING COMPUTE STATISTICS PARALLEL;

> I get the error: Table or view does not exist

>

> Is there other possiblities to solve this problem?

Please read my reply carefully!

> Make sure to either logon as SAP<SID> or provide the owner of the tables with the statement.

You were not logged on as the SAP<SID> user when you ran the "CREATE INDEX" statement.

So you either add the owner to the statements ("CREATE UNIQUE INDEX SAP<SID>."D010TAB...")

or you logon as SAP<SID> and run the statement as I posted it.

If you really don't know which user is the SAP<SID> on your db, you may use

select owner from dba_tables where table_name ='D010TAB';

regards,

Lars