DB02 - missing table can't be activated (M_MAT1)

[Private_Member_19084]

Hi experts,

in transaction DB02 I've a missing table (= M_MAT1).

I tried to activated/create it, but after that I get the following error messages:

Nametab of table M_MAT1 with status A does not exist

Nametab of table M_MAT1 with status A does not exist

Nametab of table M_MAT1 with status A does not exist

Request for M_MAT1 could not be executed

I already found note 695195, but this is not fore our release (we have basic 731).

Does anyone has a tipp for me?

Thx in advance

[former_member191911 · Accepted solution]

Do you see the table definition in tx SE11? And is it active over there? If not, you should first activate it there before creating it in the DB.

Kr. Mark

[Private_Member_19084 · Accepted solution]

Hi Mark,

first thx for help.

In se11 I get first the information message "Table M_MAT1 does not exist in the database".

After confirming this I get the se11-screen.

It is a "Display Pool" and it is inactive.

On activating I get the errors:

SQLT M_MAT1 was not activated

Check Table Pool M_MAT1

Table M_MAT1: active nametab could not be read

Maintain size category for table M_MAT1

Table Pool M_MAT1 was checked and contains errors

Thx for help

[former_member191911 · Accepted solution]

When you check in SE11, do you see if all fields in the attributes tab are filled?

Can you also check in SE14 for the storage parameters?

One addtition: can you also have a look at the settings in SE13. Is there an existing data class defined?

Kr. Mark

[Private_Member_19084 · Accepted solution]

This is the screen I get in se11

and these are the data from SE14:

Storage

        Table

            TABLESPACE           PSAPSR3
            INITIAL EXTENT       16
            NEXT EXTENT          640
            MINIMUM EXTENTS      1
            MAXIMUM EXTENTS      UNLIMITED
            PCT INCREASE         0
            FREELISTS            1
            FREELIST GROUPS      1
            PCT FREE             10
            PCT USED             40
            INITIAL TA-ENTRIES   01

        Indexes

            0

                TABLESPACE           PSAPSR3
                INITIAL EXTENT       16
                NEXT EXTENT          160
                MINIMUM EXTENTS      1
                MAXIMUM EXTENTS      UNLIMITED
                PCT INCREASE         0
                INITIAL TA-ENTRIES   02
                FREELISTS            1
                FREELIST GROUPS      1
                PCT FREE             10

Thx very much for help

[former_member191911 · Accepted solution]

Weird.. All settings look ok to me.. Can you try to maintain the size category in tx SE13?

I guess a package need to be defined as well in SE11.

Kr. Mark

[Private_Member_19084 · Accepted solution]

it seems to be possible.

Which value should I enter?

0 ?

[former_member191911 · Accepted solution]

Yes, 0 would be fine..

Can you also check the package in SE11?

Kr. Mark

[Private_Member_19084 · Accepted solution]

The field package is empty, may this be a problem?

See also the screen above.

[former_member191911 · Accepted solution]

Can you select a package when you are in change mode?

If so, you can just select any package to test this.

Kr. Mark

[Private_Member_19084 · Accepted solution]

hm, not directly

but at least at changing the sizing-value I've to enter a package at saving.

Do you know which is the correct package?

Or should I create an OSS-Message?

Thx in advance

[former_member191911 · Accepted solution]

You can use package $TMP if you don't want to transport it.. If you would like to transport this recording at a later stage, you can select an existing package.

Kr. Mark