SUM SP11 P7 - Oracle AutoExtend TableSpace Ignored

[former_member204618]

Hi All,

I'm in the prep stages of an SPS upgrade on our ERP 6 system.  During phase 5.4 Checks it's stop and said manual activities required :-

Insufficient free space in the database as follows. Please refer to file /sapsoftware/SUM/abap/log/DBFPLUSD.RES for more details and additional information about the results of the free space check.



Extend TABLESPACE SYSTEM by 341 MB



INFO: To adjust the size of your tablespaces, you may use the commands
in file '/sapsoftware/SUM/abap/log/ORATBSXT.LST' using the 'brspace' utility.



Please copy the file before making changes, as it may be
overwritten in subsequent upgrade phases.



You must fulfill these requirements first before you continue with the procedure!



Free space recommendation
In some scenarios there might be more space required, which was not part of the calculation. Therefore we recommend to have up to 20% more free space than overall required:
Additional 225 MB to TABLESPACE SYSTEM

But our SYSTEM tablespace is set to autoextend and has 935.75MB free to extend into.

Tablespace name

Size(MB)

Free(MB)

Used(%)

Autoextend

Total size(MB)

Sum of all free fragments(MB)

Total used (%)

#Files

#Segments

#Extents

Status

Contents

SYSTEM

1,124.00

11.75

99

YES

2,048.00

935.75

54

1

1,214

3,107

ONLINE

PERMANENT

Therefore we don't need to extend the tablespace as it's suggesting, as we have plenty free.

Is this going to prevent me moving forward?

UPDATE - this has stopped the update, seems to be a bug in SUM!

Thanks

Craig

[james_wong · Accepted solution]

Hi Craig,

Have you referred to the INFO from the error message?

INFO: To adjust the size of your tablespaces, you may use the commands      in file '/usr/sap/NGD/SUM/abap/log/ORATBSXT.LST' using the 'brspace' utility.
      Please copy the file before making changes, as it may be overwritten in subsequent upgrade phases.

Please refer to INFO to solve the issue. You need use the commands in ORATBSXT.LST via brspace to create the tablespace. Do copy the file before the changing.  Refer to Note 606395 - FAQ: Oracle Limitations

Is the autoextend set to MANUAL or AUTOMATIC for PSAPSR3731X?

Best regards,

James Wong

SAP Topic Communicator

[former_member204618 · Accepted solution]

Hi James,

I'm afraid you've lost me, you are simply telling me what it already told me which did resolve the issue but shouldn't have occurred in the first place.  Since I had plenty of space to extend into.

That note you refer to isn't released.

Also I was having an issue with tablespace SYSTEM what has PSAPSR3731X got to do with anything?

Thanks

Craig

[ACE-SAP · Accepted solution]

Hi

SUM does not seem to care about space extension and reclaim 'real' freespace

It want's 341 more + a 20% margin => 341 + 225 = 566

You only provide 411 free, so it is asking for more and rounding to the next hundered ... try to extend one datafile of 200Mo and it should work

Regards

[james_wong · Accepted solution]

Hi Craig,

I am glad the issue is resolved.  To get to know what space requirements are needed, you can run the PREPARE and check the output in CHECKS.LOG.  There are too many circumstances which influence the amount of data and our estimations. The only way to estimate the amount of data growth in a better manner is to do this upgrade and provide us the data.

If you experience further issue and require a further root cause analysis, please logon an incident with the data and we can perform further investigation for you.

Best regards,

James Wong

[gabriela_pieper2 · Accepted solution]

Hello James,

I experience also the some problem related here, with the size of the Tablespace ( in my case " PSAPSR3702X" ) as I whant to Update Solution Manager to the last SP12 with SUM.

I increase the size with brspace -function tscreate , please see below.

By the second execution on the same check database free space phase with SUM it ask me to increase the free space again with a lower value.

Could you helpe to solve this?

Thanks in advaced,

GP

[james_wong · Accepted solution]

Hi GP,

Is the autoextend turned on for this tablespace PSAPSR3702X?

Please kindly take a look at Note: 646681 - Reorganization of tables with BRSPACE.

Kind regards,

James Wong

SAP System Upgrade & Update Troubleshooting Wiki Space

[gabriela_pieper2 · Accepted solution]

Hi James,

thanks a lot for your answer. Yes, the auto extend is turned on.

I attached also the last DBFPLUSD.LOG with the related space check sequence.

Best Regards,

GP

1 ETQ201 Entering upgrade-phase "PREP_SPACECHECKS/SPACECHK_OPT" ("20150223140319")
2 ETQ367 Connect variables are set for standard instance access
4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'
4 ETQ399 Environment variables:
4 ETQ399   dbs_ora_schema=SAPSR3
1 ETQ200 Executing actual phase 'PREP_SPACECHECKS/SPACECHK_OPT'.
1 ETQ399 Phase arguments:
2 ETQ399 Arg[0] = 'DBFPLUSD.SPC'
2 ETQ399 Arg[1] = 'DBFPLUSD.RES'
2 ETQ399 Arg[2] = 'TAIATRANS.DAT'
2 ETQ399 Arg[3] = 'MODE=ALL'
4 ETQ056 Free space request "ORACLE SYSTEM", size "1125", loaded from file
4 ETQ056 Free space request "ORACLE PSAPEL702D", size "3750", loaded from file
4 ETQ056 Free space request "ORACLE PSAPEL702I", size "2500", loaded from file
4 ETQ056 Free space request "ORACLE PSAPES702D", size "3750", loaded from file
4 ETQ056 Free space request "ORACLE PSAPES702I", size "2500", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3", size "19443", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3702", size "15711", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3702X", size "2611", loaded from file
1 ETQ399 Unicode factor determined as 1.25.
4 ETQ057 Free space request "ORACLE SYSTEM", size "1125", to be written to file
4 ETQ057 Free space request "ORACLE PSAPSR3702X", size "3750", to be written to file
4 ETQ057 Free space request "ORACLE PSAPSR3702X", size "2500", to be written to file
4 ETQ057 Free space request "ORACLE PSAPSR3702X", size "3750", to be written to file
4 ETQ057 Free space request "ORACLE PSAPSR3702X", size "2500", to be written to file
4 ETQ057 Free space request "ORACLE PSAPSR3", size "19443", to be written to file
4 ETQ057 Free space request "ORACLE PSAPSR3702X", size "15711", to be written to file
4 ETQ057 Free space request "ORACLE PSAPSR3702X", size "2611", to be written to file
4 ETQ380 computing toolpath for request "TP_EXECDBSCRIPT_NEW"
4 ETQ381 request "TP_EXECDBSCRIPT_NEW" means "execdbscript with 46A feature"
4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
4 ETQ399 Requirement for tp maps to 'exe'
4 ETQ383 translates to path "E:\Install\SUM\abap\exe"
4 ETQ056 Free space request "ORACLE SYSTEM", size "1125", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3702X", size "3750", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3702X", size "2500", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3702X", size "3750", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3702X", size "2500", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3", size "19443", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3702X", size "15711", loaded from file
4 ETQ056 Free space request "ORACLE PSAPSR3702X", size "2611", loaded from file
4 ETQ276 Executing SQL-script "..\var\SPACECHK.TQL"
3 ETQ120 20150223140319: PID 6472 execute 'E:\Install\SUM\abap\exe\tp "pf=E:\Install\SUM\abap\var\DEFAULT.TPP" execdbscript SM7 -x ..\var\SPACECHK.TQL', output written to 'E:\Install\SUM\abap\log\SPACECHK.ECO'.
3 ETQ123 20150223140320: PID 6472 exited with status 0 (time 0.000 real)
2 ETQ277 SQL-script "..\var\SPACECHK.TQL" executed successfully
4 ETQ064 Free space of "      18" MBytes found in tablespace "SYSTEM"
4 ETQ064 Free space of "      28" MBytes found in tablespace "SYSAUX"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       4" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       3" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       5" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      17" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      21" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      23" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       4" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       3" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      67" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      45" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      30" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       5" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      14" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       9" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       9" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      41" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      75" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      10" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      10" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      31" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       3" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      23" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       4" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       2" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       9" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "     233" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      44" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      59" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      24" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      21" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       8" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      64" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "       1" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      48" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      40" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "     659" MBytes found in tablespace "PSAPUNDO"
4 ETQ064 Free space of "      32" MBytes found in tablespace "PSAPSR3"
4 ETQ064 Free space of "     159" MBytes found in tablespace "PSAPSR3"
4 ETQ064 Free space of "      96" MBytes found in tablespace "PSAPSR3"
4 ETQ064 Free space of "     152" MBytes found in tablespace "PSAPSR3"
4 ETQ064 Free space of "     152" MBytes found in tablespace "PSAPSR3"
4 ETQ064 Free space of "      79" MBytes found in tablespace "PSAPSR3"
4 ETQ064 Free space of "     126" MBytes found in tablespace "PSAPSR3"
4 ETQ064 Free space of "      59" MBytes found in tablespace "PSAPSR3"
4 ETQ064 Free space of "     192" MBytes found in tablespace "PSAPSR3"
4 ETQ064 Free space of "      11" MBytes found in tablespace "PSAPSR3702"
4 ETQ064 Free space of "      19" MBytes found in tablespace "PSAPSR3702"
4 ETQ064 Free space of "     194" MBytes found in tablespace "PSAPSR3702"
4 ETQ064 Free space of "     254" MBytes found in tablespace "PSAPSR3702"
4 ETQ064 Free space of "     282" MBytes found in tablespace "PSAPSR3702"
4 ETQ064 Free space of "     134" MBytes found in tablespace "PSAPSR3702"
4 ETQ064 Free space of "       5" MBytes found in tablespace "PSAPSR3702"
4 ETQ064 Free space of "      17" MBytes found in tablespace "PSAPSR3702"
4 ETQ064 Free space of "      18" MBytes found in tablespace "PSAPSR3USR"
4 ETQ064 Free space of "    1353" MBytes found in tablespace "PSAPSR3DB"
4 ETQ064 Free space of "    1333" MBytes found in tablespace "PSAPSR3DB"
4 ETQ064 Free space of "     358" MBytes found in tablespace "PSAPSR3DB"
4 ETQ064 Free space of "     999" MBytes found in tablespace "PSAPSR3702X"
4 ETQ064 Free space of "     999" MBytes found in tablespace "PSAPSR3702X"
4 ETQ064 Free space of "    1210" MBytes found in tablespace "PSAPTEMP"
4 ETQ072 Growable space of "    9250" MBytes found in tablespace "SYSTEM"
4 ETQ072 Growable space of "    9620" MBytes found in tablespace "SYSAUX"
4 ETQ072 Growable space of "    7660" MBytes found in tablespace "PSAPUNDO"
4 ETQ072 Growable space of "    6580" MBytes found in tablespace "PSAPSR3"
4 ETQ072 Growable space of "    6580" MBytes found in tablespace "PSAPSR3"
4 ETQ072 Growable space of "    6580" MBytes found in tablespace "PSAPSR3"
4 ETQ072 Growable space of "    6680" MBytes found in tablespace "PSAPSR3"
4 ETQ072 Growable space of "    6680" MBytes found in tablespace "PSAPSR3"
4 ETQ072 Growable space of "    6680" MBytes found in tablespace "PSAPSR3"
4 ETQ072 Growable space of "    6780" MBytes found in tablespace "PSAPSR3"
4 ETQ072 Growable space of "    6760" MBytes found in tablespace "PSAPSR3"
4 ETQ072 Growable space of "    6760" MBytes found in tablespace "PSAPSR3"
4 ETQ072 Growable space of "    7580" MBytes found in tablespace "PSAPSR3702"
4 ETQ072 Growable space of "    7600" MBytes found in tablespace "PSAPSR3702"
4 ETQ072 Growable space of "    7600" MBytes found in tablespace "PSAPSR3702"
4 ETQ072 Growable space of "    7640" MBytes found in tablespace "PSAPSR3702"
4 ETQ072 Growable space of "    7660" MBytes found in tablespace "PSAPSR3702"
4 ETQ072 Growable space of "    7640" MBytes found in tablespace "PSAPSR3702"
4 ETQ072 Growable space of "    7620" MBytes found in tablespace "PSAPSR3702"
4 ETQ072 Growable space of "    7480" MBytes found in tablespace "PSAPSR3702"
4 ETQ072 Growable space of "    9980" MBytes found in tablespace "PSAPSR3USR"
4 ETQ072 Growable space of "    8000" MBytes found in tablespace "PSAPSR3DB"
4 ETQ072 Growable space of "    8000" MBytes found in tablespace "PSAPSR3DB"
4 ETQ072 Growable space of "    9000" MBytes found in tablespace "PSAPSR3DB"
4 ETQ072 Growable space of "    9000" MBytes found in tablespace "PSAPSR3702X"
4 ETQ072 Growable space of "    9000" MBytes found in tablespace "PSAPSR3702X"
4 ETQ072 Growable space of "    8790" MBytes found in tablespace "PSAPTEMP"
2 ETQ399 Requested task ID is 'TABTEST'.
2 ETQ399 Skipping execution and scanning cached output 'E:\Install\SUM\abap\log\TABTEST.LOG'.
3 ETQ399 Reading selections from 'TABTEST.LOG'.
4 ETQ399 Read 40618 entries for table 'TABDBS'.
3 ETQ399 Reading selections from 'TABTEST.LOG'.
4 ETQ399 Read 40618 entries for table 'TABDBS'.
2 ETQ399 Requested task ID is 'INDTEST'.
2 ETQ399 Skipping execution and scanning cached output 'E:\Install\SUM\abap\log\INDTEST.LOG'.
3 ETQ399 Reading selections from 'INDTEST.LOG'.
4 ETQ399 Read 55924 entries for table 'TABINDDBS'.
3 ETQ399 Reading selections from 'INDTEST.LOG'.
4 ETQ399 Read 55924 entries for table 'TABINDDBS'.
2 ETQ399 Requested task ID is 'TABLOC'.
2 ETQ399 Skipping execution and scanning cached output 'E:\Install\SUM\abap\log\TABLOC.LOG'.
3 ETQ399 Reading selections from 'TABLOC.LOG'.
4 ETQ399 Read 41310 entries for table 'TABLOC'.
3 ETQ399 Reading selections from 'TABLOC.LOG'.
4 ETQ399 Read 41310 entries for table 'TABLOC'.
4 ETQ060 Summing up all free space requests for location "SYSTEM"
4 ETQ055 Sum of free space requests for "ORACLE SYSTEM" is "1125" (unit DB specific)
4 ETQ060 Summing up all free space requests for location "PSAPSR3702X"
4 ETQ055 Sum of free space requests for "ORACLE PSAPSR3702X" is "3750" (unit DB specific)
4 ETQ060 Summing up all free space requests for location "PSAPSR3"
4 ETQ055 Sum of free space requests for "ORACLE PSAPSR3" is "19443" (unit DB specific)
4 ETQ276 Executing SQL-script "..\var\DISPCHK.TQL"
3 ETQ120 20150223140321: PID 4508 execute 'E:\Install\SUM\abap\exe\tp "pf=E:\Install\SUM\abap\var\DEFAULT.TPP" execdbscript SM7 -x ..\var\DISPCHK.TQL', output written to 'E:\Install\SUM\abap\log\SPACECHK.ECO'.
3 ETQ123 20150223140322: PID 4508 exited with status 0 (time 0.000 real)
2 ETQ277 SQL-script "..\var\DISPCHK.TQL" executed successfully
4 ETQ068 Summing up the allocation dispersion for request "ORACLE SYSTEM", size "1125"
4 ETQ070 Free space request "ORACLE SYSTEM", size increased to "1125"
4 ETQ068 Summing up the allocation dispersion for request "ORACLE PSAPSR3702X", size "30822"
4 ETQ070 Free space request "ORACLE PSAPSR3702X", size increased to "30822"
4 ETQ068 Summing up the allocation dispersion for request "ORACLE PSAPSR3", size "19443"
4 ETQ070 Free space request "ORACLE PSAPSR3", size increased to "19443"
4 ETQ205 Module state set to error
4 ETQ010 Date & Time: 20150223140322 
1 ETQ202 Upgrade phase "SPACECHK_OPT" completed sucessfully ("20150223140322"

[gabriela_pieper2 · Accepted solution]

very useful answer, solved the problem of insufficient free space.

I use Tablespace Management with BR*Tools ( brtools -c) and extend the Tablespace "PSAPSR3702X" as required.

Best Regards,

GP

[tomas_black · Accepted solution]

Hello Former Member, Former Member, Former Member and ,

I had to ask UPG Development about this intriguing information:

Insufficient free space in the database as follows. Please refer to file /sapsoftware/SUM/abap/log/DBFPLUSD.RES for more details and additional information about the results of the free space check.

Extend TABLESPACE SYSTEM by 341 MB

INFO: To adjust the size of your tablespaces, you may use the commands

in file '/sapsoftware/SUM/abap/log/ORATBSXT.LST' using the 'brspace' utility.

Please copy the file before making changes, as it may be

overwritten in subsequent upgrade phases.

You must fulfill these requirements first before you continue with the procedure!

Free space recommendation

In some scenarios there might be more space required, which was not part of the calculation. Therefore we recommend to have up to 20% more free space than overall required:

Additional 225 MB to TABLESPACE SYSTEM

The explanation is as follows: the tablespace has 840Mb free space, the calculated requirement is 1125Mb, so only 1125-841=284Mb is missing. Adding 20% as a safe margin over 284Mb gives you the figure of 341Mb.

Besides this requirement SAP recommends to have another 20% of the requested 1125Mb available, which is 225Mb. So you could extend it by 384Mb to make the tool happy, but probably 341+225=556Mb is better.

Development agreed this logic is confusing and difficult to understand, they informed they'll review the coding of this particular part.

I hope I could help.

Best regards,

Tomas Black

[gabriela_pieper2 · Accepted solution]

Hello Tomas Blank,

thank you for the explanation. In the meantime I solved the problem increasing the free space of tablespace with a value (more than required) as I didn't understood the calculated requirement. Also, is very nice to hear that UPG Development will improve this in the future.

Thanks a lot and have a nice day.

Gabriela Pieper

[former_member204618]

OK I've increased the datafile size by 400MB using BRTOOLS but it's still complaining with the same error as above!

Tablespace name

Size(MB)

Free(MB)

Used(%)

Autoextend

Total size(MB)

Sum of all free fragments(MB)

Total used (%)

#Files

#Segments

#Extents

Status

Contents

SYSTEM

1,524.00

411.75

73

YES

2,048.00

935.75

54

1

1,214

3,107

ONLINE

PERMANENT

How do I force it to do a proper recheck?

UPDATE

In order to get around this error (this has to be a bug!) I had to run the script it provided.

30> cat /sapsoftware/SUM/abap/log/ORATBSXT.LST
#  These are examples for brspace commands to extend/create the required
#  tablespaces. You can adapt them according to your own needs.
#  Add option '-c force' to call the commands in batch mode.
#  Change option '-autoextend' to 'yes' and set '-maxsize' and '-incrsize'
#  to create autoextensible segments.
brspace -function tsextend -tablespace SYSTEM -size 200 -incrsize 200 -maxsize 400 -autoextend yes
# brspace -function tsextend -tablespace SYSTEM -size 200 -incrsize 200 -maxsize 400 -autoextend yes

Which generated another datafile of 200MB extendible to 400MB!

Thanks

Craig