Activation problem.

[Former Member]

Hi

I have some serious activation problems. I have created a new table ZTAX with SE14 and it works fine, but when I will activate I get this "Table is not created in the database". Se below.

3S3T | Activate table ZTAX

| Table ZTAX must be created in the database

| Adjust table in DB >>>

| Table ZTAX (Error adjusting the database)

| Table ZTAX was not activated

-

---

| *************************************************************************

| Activation of objects

| End phase 001 ***********************************************************

-

---

| Start phase 002 **********************************************************

| Final log

| *************************************************************************

-

---

| Following objects not activated/deleted or activated/deleted w. warning:

-

---

| Table ZTAX could not be activated

| (E- Table ZTAX (Error adjusting the database) )

-

---

| *************************************************************************

| Final log

| End phase 002 ***********************************************************

-

---

| Start phase 003 **********************************************************

| Statistics on activated and deleted objects

| *************************************************************************

-

---

| Number of objects to be activated............: 1

| Objects not activated........................: 1

| Activated objects with errors in dependencies: 0

| Objects activated with warning...............: 0

| Successfully activated objects...............: 0

| Number of objects to be deleted..............: 0

| Objects not successfully deleted.............: 0

| Successfully deleted objects.................: 0

| Tables/views with DROP/CREATE................: 0

| No. of them marked for DROP/CREATE: 0

| Not marked for DROP/CREATE: 0

| Number of nametabs to be deleted.............: 0

| Successfully deleted nametabs................: 0

| Nametabs that were not successfully deleted..: 0

Running DB2 on i5. 4.6C on patchlevel 050.

Anyone have a ide on that?

MFG

Mads Hammer

[Former Member · Accepted solution]

Hi Mads,

Was the tabled created before? (The trace says "Error adjusting the database")

If yes, would you delete the table from OS/400 level (object R3<SID>DATA/ZTAX likely), then activate it from SE11 or SE14 again? If the data is still needed, try CPYF to save the records first.

Good luck,

Victor

[Former Member]

See note 66985

[dorothea_stein]

Hi Mads,

thanks for posting the resolution, that explains it. - This thing started bugging me...

Kind regards,

Dorothea

[Former Member]

Hi all

and thanks for some god suggestions. Finally we had to call SAP. The solution was simple Apparently it's the first this customer is creating their own tables and that was the problem. So the problem was inherited from the system copy made years ago

See note 66985.

Best regards / Mfg

Mads Hammer

[Former Member]

Hi Dorothea

Thanks for a helpfull information, but no solution. Se log.

After reconstruct i get this error:

ACTTABLZTAX

&#61487;&#61472; Nametab reconstruction table ZTAX (DDIC/21.06.07/12:52)

Table does not exist in the database

Mads Hammer

[dorothea_stein]

Hi Mads,

if this is the reconstruction log, this is not an error yet. Now please try again to activate the table. If you are still having problems, please have a look at SM50 or take an SQL trace to the the SQL error.

Best regards,

Dorothea

[Former Member]

Hello Mads,

It is a tough Z table.

I would try the following steps:

1. copy ZTAX to ZTAX_COPY in SE11

2. delete ZTAX

3. command $SYNC to sync buffer

4. check there is no R3<SID>DATA/ZTAX object

(hopefully it is removed by here)

5. copy ZTAX_COPY back to ZTAX

6. Activate and hope it works

Best regards,

Victor

[Former Member]

Hi all

Even when I delete the object from OS level, I get the same error. It's almost like the creation of the table is not recognized by the OS or DDIC.

If deleted from OS and a new creation with SE14, the creation is successfull but I can't activate object. The message is that the object dos not exists. At OS level it is created fine with correct authorities.

Mads Hammer

[dorothea_stein]

Hi,

not sure it helps, but like Victor, I'd suggest to clean up everything and then to try the activation again. In preparation of that, make sure you do not only delete the object on the database, but destroy the runtime description as well. How to do that:

Sign on to SAP as user DDIC. Then use SE14: table -> reconstruct. It will adjust the runtime object to what the database looks like (== delete it). This will not affect the DDIC representation.

After that, check that runtime and database description are gone (SE11 -> Utilities -> Runtime object -> view; same for "database object"), and activate the DDIC decription.

If that did not help, please provide the activation log and potential errors in the dev trace.

Best regards,

Dorothea

[former_member204746]

expand completely your log, you will find the database error message it might have generated.

[dorothea_stein]

Hi,

please check the developer trace (SM50) for DB errors and/or take an SQL trace of the activation (ST05).

Best regards,

Dorothea