Error BR0970W

[Former Member]

IN DB13 - Database Check, I am getting this error:

BR0969I Checking database administration...

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPU3P.BCACT, value: PSAPU3P620

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPU3P.BCACT~0, value: PSAPU3P620

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPU3P.BCCOM, value: PSAPU3P620

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPU3P.BCCOM~0, value: PSAPU3P620

I can not find the value of PSAPU3P620 in any of these notes mentioned in SAP Note PSAPU3P620:

desc "SAPU3P"."TSORA"

desc "SAPU3P"."IAORA"

desc "SAPU3P"."TAORA"

desc "SAPU3P"."DD09L";

How can I fix this problem?

[Former Member · Accepted solution]

Hi William,

I think you'll find the solution at note 655162.

Best Regards,

JC Llanes.

[Former Member · Accepted solution]

I read that note. And it wasn't the answer.

I looked at all the tables mentioned in that note.

[Former Member · Accepted solution]

Hi,

Note 655162 talks generically about tables/indexes, not about concrete ones.

Please, read carefully the first part of "solution".

Regards,

JC Llanes.

[Former Member · Accepted solution]

I did.

I can not find the value of PSAPU3P620 in any of these notes mentioned in SAP Note PSAPU3P620:

desc "SAPU3P"."TSORA"

desc "SAPU3P"."IAORA"

desc "SAPU3P"."TAORA"

desc "SAPU3P"."DD09L";

How can I fix this problem?

[Former Member · Accepted solution]

SELECT DISTINCT TABSPACE, INDSPACE FROM "SAPU3P"."TSORA";

TABSPACE INDSPACE

PSAPU3PUSR PSAPU3PUSR

PSAPU3P620 PSAPU3P620

PSAPU3P PSAPU3P

PSAPU3P700 PSAPU3P700

SELECT TABNAME, TABART FROM "SAPU3P"."DD09L" WHERE TABNAME = 'BCACT';

TABNAME TABART

BCACT APPL0

SELECT TABART, TABSPACE FROM "SAPU3P"."TAORA" WHERE TABART = 'APPL0';

TABART TABSPACE

APPL0 PSAPU3P

SELECT TABART, TABSPACE FROM "SAPU3P"."IAORA" WHERE TABART = 'APPL0';

TABART TABSPACE

APPL0 PSAPU3P

So where is this warning coming from:

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPU3P.BCACT, value: PSAPU3P620

[Former Member · Accepted solution]

Hi William,

Can you post the output of

SELECT DISTINCT TABSPACE, TABART FROM "SAPU3P"."TAORA";

?

TSORA don't contain the TABART field.

Perhaps the TABART "APPL0" is not assigned to TABSPACE "PSAPU3P" but "PSAPU3P620". This can cause the brconnect warning.

Regards,

JC Llanes.

[Former Member · Accepted solution]

SELECT DISTINCT TABSPACE, TABART FROM "SAPU3P"."TAORA";

TABSPACE TABART

PSAPU3P DFACT

PSAPU3P DODS

PSAPU3P TEMP

PSAPU3P APPL0

PSAPU3P APPL1

PSAPU3P700 SLDEF

PSAPU3P SDIC

PSAPU3P APPL2

PSAPU3P DDIM

PSAPU3P SPROT

PSAPU3P700 SSDEF

PSAPU3P SDOCU

PSAPU3P SSRC

PSAPU3P POOL

PSAPU3P SLOAD

PSAPU3PUSR USER

PSAPU3P CLUST

PSAPU3P700 SLEXC

PSAPU3P700 SSEXC

PSAPU3PUSR USER1

20 rows selected

[Former Member · Accepted solution]

Hi,

Do the PSAPU3P620 TS exists? It appears at TSORA, but not at TAORA.

Have you upgraded your system recently? The old *620 tablespace must be removed at the end of upgrade.

Regards,

JC Llanes.

[Former Member · Accepted solution]

<<The old *620 tablespace must be removed at the end of upgrade.>>

We recently upgraded to ecc 6.0.

I drop the old tablespace and the messages went away!

Thanks!

[Former Member]

Let's make another approach:

1. Transaction SE11: BCACT as database table -> display, then go to Technical settings and note the data class associated with BCACT (APPL0 ?)

2. Transaction SE16: TAORA as table name, then F7, then F8 to note the association between the data class and the tablespace.

If BCACT is not in the correct tablespace, you'll have to relocate this table in the correct tablespace with brspace.

3. Perform the same with the other objects.

Hope this helps.

Christophe