The transaction log for database 'ECC' is full + ECC6.0 Installation Failur

184 Views

Guyz,

my ecc6 installation failed after 8 hours run with following error log snippet...

***

exec sp_bindefault 'numc3_default','SOMG.MSGNO'

)

DbSlExecute: rc = 99

(SQL error 9002)

error message returned by DbSl:

The transaction log for database 'ECC' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

(DB) ERROR: DDL statement failed

(ALTER TABLE [SOMG] ADD CONSTRAINT [SOMG~0] PRIMARY KEY CLUSTERED ( [MANDT], [OBJTP], [OBJYR], [OBJNO] ) )

DbSlExecute: rc = 99

(SQL error 4902)

error message returned by DbSl:

Cannot find the object "SOMG" because it does not exist or you do not have permissions.

ECCLOG1 data file has got 25GB initial size and growth was restricted to 10% (PROPOSED BY SAPInst)...

i'm assuming this error was due to lack of growth space for ECCLOG1 datafile...am i right? if so how much should i allocate memory for this log ? or is there any workaround ?

thanks in advance