High growth of DB

[Former Member]

Hi experts,

I´m patching my system ERP 6.0 with this patches:

- ABA 19, 20, 21

- BASIS 19, 20, 21

- SAP_APPL 16, 17

- SAP_AP 16, 17, 18, 19, 20

- PI_BASIS 19, 20, 21

- SAP_BW 21, 22, 23

I have the last kernel and last spam.

The time by now is more than 15hours, the phase TBATG CONVERSION OF DD-OBJECTS is more than 10 hours and the data file growth (each one) more than 8GB, in total, more than 42GB, is it normal?

I check that executed a job with a program RDDGENBB with variant SQLT, TABL, VIEW e INDX in upgrade.

Now is in the phase TBATG CREATION OF ENQUEUE OBJECTS, in the sm50 appear a report SAPLOLEA more than 45.000seconds.

Seems all normal?

Thanks in advaced,

Regards,

[former_member204746 · Accepted solution]

This is a known problem.

when you tried to start your support pack import in SPAM, you got a very detailed popup telling you to read SAP note 822379.

You did not read SAP note 822379 - Known problems with Support Packages in SAP NW 7.0x AS ABAP. it tells you to read SAP note 1283197 - Cluster tables: Unrequired conversion

An error in the DDIC activation program causes cluster tables to be converted.
Symptom: When you activate DDIC objects, information in runtime objects may be lost under certain circumstances. As a result, cluster tables are converted. This is incorrect.

Solution: See Note 1283197 and implement the correction instructions specified in it before you import Support Packages.

so, you have 2 possible solutions:

1. you continue to wait a long time.

2. you restore , apply the SAP note and run your support packs again.

been there, done that.

[Former Member · Accepted solution]

Hi Eric Brunelle,

I don´t understand why you tell this...

I think, i haven´t errors in DDIC activation... why i should apply this note?

I put a SAP note, continue in the phase TBATG CREATION OF ENQUEUE OBJECTS, in the sm50 appear a report SAPLOLEA more than 20hours...

[Former Member · Accepted solution]

Out of box: can you please chek SM21 whats going on? also have you checked the /usr/sap/trans/tmp ?

[former_member204746 · Accepted solution]

look at

also, archive full situation in effect? check SM21, ST22. Check Os logs check if disks are full. check if database is full

check /usr/sap/trans/tmp

[Former Member · Accepted solution]

in /tmp it´s writing the same in a file, whitout errors.

Regards,

[former_member204746 · Accepted solution]

not /tmp

check /usr/sap/trans/tmp

[Former Member · Accepted solution]

Can you please past few last lines from latest file your /usr/sap/trans/tmp

[Former Member · Accepted solution]

Sorry, i say /usr/sap/trans/tmp.

The file is: N101014.DEV and repeat:

1 ED0316 Program parameters:

1 ED0314 Tp.proceso...............: secuencial

1 ED0302 =========================================================================

1 ED0320XStart phase "001" **********************************************************

1 ED0306 "Proceso previo de TBAG"

1 ED0301 *************************************************************************

1 ED0301X*************************************************************************

1 ED0306 "Proceso previo de TBAG"

1 ED0322 End phase "001" ***********************************************************

1AETR012XProgram terminated (job: "RDDGEN0L", no.: "16130600")

1AEPU320 See job log"RDDGEN0L""16130600""DEV"

1 ED0317XProgram start============================================================

1 ED0314

1 ED0314 DD: Ejecución de operaciones en base de datos

1 ED0314

1 ED0302 =========================================================================

1 ED0327 Process..................: "SAPDEVNW_19"

1 ED0303 User.....................: "DDIC"

1 ED0305 Date, time...............: "15.10.2010", "16:14:06"

1 ED0307 Platform.................: "CUSTOMER"-"DEV"("700")/"MSSQL/WindowsNT/SAPDEVNW"

1 ED0311 Tool.....................: "BATCH"/"RADBAT01"

1 ED0315 Log......................: "F", "

pror3sapmnt rans mpN101014.DEV"

1 ED0314

1 ED0316 Program parameters:

1 ED0314 Tp.proceso...............: secuencial

1 ED0302 =========================================================================

1 ED0320XStart phase "001" **********************************************************

1 ED0306 "Proceso previo de TBAG"

1 ED0301 *************************************************************************

1 ED0301X*************************************************************************

1 ED0306 "Proceso previo de TBAG"

1 ED0322 End phase "001" ***********************************************************

Thanks in advanced,

[Former Member · Accepted solution]

>> 1AETR012XProgram terminated (job: "RDDGEN0L", no.: "16130600")

>> 1AEPU320 See job log"RDDGEN0L""16130600""DEV"

have you checked above error?

[former_member204746 · Accepted solution]

when applying support packs, always login with language EN

[Former Member]

Yes, this is normal.

After the process you may be able to recover some of the space, but it is best to leave it allocated to the database.

[Former Member]

you can check whats going on at OS level, usr\sap\trans\tmp sort files by date/time. As this is windows you can't do tail -f so you have to copy the latest file to different location and open the file and check whats going on.