Problem with new Data Class

[Former Member]

Hi,

I have a problem with defining new Data Class. When you perform upgrade BW from 3.x to 7.x you have to do preparation step "Converting Data Classes of InfoCubes", what we have to do is:

1. Define new Data Class (Note 46272 - Implement new data class in technical settings)

2. Run report RSDG_DATCLS_ASSIGN to migrate objects to other Data Class

So I ran BRTOOLS (Oracle 10.2.0.4, BRTOOLS 7.00 (46)), and created new tablespace successfully. This tool also automatically performed defining new Data Class and link between Data Class and Tablespace. However under RSDG_DATCLS_ASSIGN report I have no option to select newly created Data Class ("USER2"), there are only "old" ones..

My system is:

SAP Netweaver 2004

HP-UX / SAP Kernel 640, lvl 304, DBSL Patch lvl: 276, Non-unicode

SAP_ABA	640	0027	SAPKA64027	Cross-Application Component
SAP_BASIS	640	0027	SAPKB64027	SAP Basis Component
PI_BASIS	2004_1_640	0008	SAPKIPYI68	Basis Plug-In (PI_BASIS) 2004_1_640
ST-PI	2008_1_640	0000	     -	SAP Solution Tools Plug-In
SAP_BW	350	0011	SAPKW35011	SAP_BW 350
FINBASIS	300	0008	SAPK-30008INFINBASIS	FINBASIS 300 : Add-On Installation Reque
BI_CONT	353	0003	SAPKIBIFP3	BI_CONT 353 Upgrade: Meta-Commandfile (F
SEM-BW	400	0005	SAPKGS4005	SEM-BW Add-on component
ST-A/PI	01L_BCO640	0000	     -	Servicetools for other App./Netweaver 04

DB02: Current Sizes:

Tablespace                       Size (kb)      Free (kb)      Used (%)   Tab/ind    Extents    AutoExt (kb)   Used (%)   Status     Backup
PSAPBIQICUBES                      5.242.880      5.242.816          0          0          0    Off                  0    ONLINE     NOT ACTIVE

TSORA:

TABSPACE                       INDSPACE
PSAPBIQICUBES                  PSAPBIQICUBES

DDART:

TABART DDCLASS DARTTEXT
USER2  USR     Customer data class USER2 generated by BRSPACE

DARTT:

TABART  DDLANGU DARTTEXT
USER2   D       Customer data class USER2 generated by BRSPACE
USER2   E       Customer data class USER2 generated by BRSPACE
USER2   L       Customer data class USER2 generated by BRSPACE

TAORA:

TABART  TABSPACE                         PCTINC OFREELIST OFREEGROUP OPCTFREE OPCTUSED
USER2   PSAPBIQICUBES                    0000   001       01         10       40

IAORA:

TABART  TABSPACE                       PCTINC OFREELIST OPCTFREE
USER2   PSAPBIQICUBES                  0000   001       10

Thank you for any suggestions!

K

[Former Member]

It seems to be a problem with RSDG_DATCLS_ASSIGN report.. In SE13 my new Data Class is available to choose. In mentioned report - it's not.

Thanks in advance!

Regards,

K

[Former Member]

Another strange thing..

My ABAP colleague, debugged the program for me and point out:

      *   get data class (only standard and user values)
>         SELECT * FROM ddart INTO TABLE l_t_ddart
                              ORDER BY tabart.
          DELETE l_t_ddart WHERE   ddclass <> 'STD'  AND
                                   ddclass <> 'USR'.

          LOOP AT l_t_ddart INTO l_s_ddart.

The l_t_ddart table contains only 21 rows (without my new Data Class, which is visible under SE16!)! I checked under oracle sqlplus and SELECT * FROM SAP<SID>.ddart; returned 22 rows WITH my new Data Class!

I'm a little bit confused...

[Former Member]

So.. It was buffer issue. /$SYNC and done.