ERROR in PREPARE - Tablespace

[hanse_atik2]

Hi there,

Prepare gives the error message:

ERROR: insufficient free space in database as follow:

create tablespace PSAPSR3700 with 27428 MB

When I use the tool BRSAPCE as it is recommended by CAR.SAV I get the error message even if I have enough space on the Disk:

BR0280I BRSPACE time stamp: 2008-09-28 23.22.14

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1057E Not enough free space in E:\oracle\PLT\sapdata1\sr3700_4 for file E:\ora

cle\PLT\sapdata1\sr3700_4\sr3700.data4, missing at least 2552.452 MB

BR0669I Cannot continue due to previous warnings or errors - you can go back to

repeat the last action

BR0280I BRSPACE time stamp: 2008-09-28 23.22.14

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Any idea how to get out from this circle.?

Thanks

HanseAtik

[former_member235680 · Accepted solution]

Hello Atik,

As you said that there is sufficient space in E: Drive, then you try to create the required tablespace in some other SAPDATA <n>, other than SAPDATA1.It may be the case your SAPDATA1 could have filled to the maximum level.

The brtools has an option to switch to the required SAPDATA.

And try to add the file of lesser intial size(say 2048 MB) with the "auto extent on" with 512M or 1 GB whatever suits you. The maximum file size you can give as the required size by the upgrade.

Cheers

Abhishek

[Former Member]

Hi,

The prepare is checking for the required space in the tablespace PSAPSR3700 for its activities to take place with out any interruptions and it pointed you that you need to give more space for the tablespace PSAPSR3700.

when you run the command provided by the prepare to extend the tablespace PSAPSR3700 it is trying to add a datafile in your E drive and in SAPDATA1. It shows that there is not freespace in the E drive hence try to add the datafile in some other drive which has got enough freespace. before adding in another drive make sure you design you DB layout and how to manage it later, so that you will not have troubles in managing the DB later.

hope this helps you.

Thanks,

Venkat.

[hanse_atik2]

Hi,

Thanks for the reply.

But my problem is that I have around 75 GB free on drive E:

I check via properties etc.. and I can see there is enough space.

So why its asking for space?

Thanks

HanseAtik

[Former Member]

A couple of things you could do:

->Check SAP note 716377

->Is the affected tablespace already configured with autoextend ON?

->Ensure you are using the latest SAPup version.

->Reset the prepare phase, delete all logs, etc and restart the prepare from scratch.

[Former Member]

Hi,

check for the free space availability of sapreorg also.

If you tried to add the datafile of 27GB then try to add in 2 or 3 datafiles of 10GB each.

Even it does not work then update your BRtools.

Thanks,

Venkat.

[Former Member]

Hi,

If you are sure that the disk space is available, this could be a bug in the Brtools program. What Brtools patch level are you on? Try updating to the latest patch as per note 12741.

Cheers!