Error during support pack using SUM

[Former Member]

Hi ,

I am getting the below error during the support pack upgrade using SUM. Please help.

1EETGCLN ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3702Xh

Regards,

Prashanth Raja

[Former Member · Accepted solution]

Hello Prashanth,

You have to extend the tablespace PSAPSR3702Xh and retry the sum. If you still face issue after extend also again you have to extend tablespace and retry the sum till the issue is resolved. I think extending the tablespace is only the solution for this.

[Former Member · Accepted solution]

Hi Mahendra,

Thanks for your answer, I have extended the space more than 150 GB for that table space but the issue still the there.

Regards,

Prashanth Raja

[Former Member · Accepted solution]

paste here latest .elg log file.

[Former Member · Accepted solution]

Hi Mahendra,

PFB, for your reference.

3 ETGCLN CREATE TABLE "WDY_VS_PROPERTY~" ("COMPONENT_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "WINDOW_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VSH_NODE_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VERSION" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "VS_PROP_DEF_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "X" NUMBER (000010) DEFAULT 0 NOT NULL, "Y" NUMBER (000010) DEFAULT 0 NOT NULL, "Z" NUMBER (000010) DEFAULT 0 NOT NULL, "PROPERTY_TYPE" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VALUE" VARCHAR2 (000765) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3702X NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000160 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WDY_VS_PROPERTY~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "WDY_VS_PROPERTY^0" ON "WDY_VS_PROPERTY~" ("COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3702X NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WDY_VS_PROPERTY~' AND INDEXNAME = '0'

3 ETGCLN insert /*+ APPEND */ into "WDY_VS_PROPERTY~" (  "COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME", "X", "Y", "Z", "PROPERTY_TYPE", "VALUE" ) select  "COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME", "X", "Y", "Z", "PROPERTY_TYPE", "VALUE" from "WDY_VS_PROPERTY"

1EETGCLN ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3702X

1EETGCLN WDY_VS_PROPERTY

1EETGCLN Error copying table data

Regards,

Prashanth Raja

[Former Member · Accepted solution]

in your first post i see tablespace is PSAPSR3702Xh. in .elg file it is PSAPSR3702X. as per this i understand that both are different. if yes please extend table space for PSAPSR3702X also.

[Former Member · Accepted solution]

Hi Mahendra,

I have extended more than 250 GB for PSAPSR3702X table space  still it is showing error.

Will require more than 250 GB for that table space ,Thanks.

Regards,

Prashanth Raja

[Former Member · Accepted solution]

please paste latest .elg file.

[Former Member · Accepted solution]

Hi Mahendra,

I have added another 60 GB and got the same error. PFB, the latest log, Thanks.

3 ETGCLN CREATE TABLE "WDY_VS_PROPERTY~" ("COMPONENT_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "WINDOW_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VSH_NODE_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VERSION" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "VS_PROP_DEF_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "X" NUMBER (000010) DEFAULT 0 NOT NULL, "Y" NUMBER (000010) DEFAULT 0 NOT NULL, "Z" NUMBER (000010) DEFAULT 0 NOT NULL, "PROPERTY_TYPE" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VALUE" VARCHAR2 (000765) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3702X NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000160 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WDY_VS_PROPERTY~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "WDY_VS_PROPERTY^0" ON "WDY_VS_PROPERTY~" ("COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3702X NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WDY_VS_PROPERTY~' AND INDEXNAME = '0'

3 ETGCLN insert /*+ APPEND */ into "WDY_VS_PROPERTY~" (  "COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME", "X", "Y", "Z", "PROPERTY_TYPE", "VALUE" ) select  "COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME", "X", "Y", "Z", "PROPERTY_TYPE", "VALUE" from "WDY_VS_PROPERTY"

1EETGCLN ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3702X

1EETGCLN WDY_VS_PROPERTY

1EETGCLN Error copying table data

Regards,

Prashanth Raja

[Former Member · Accepted solution]

what is the table space utilization? check in brtools.

see if below link helps you? as per my knowledge this is the issue of tablespace only.

also have you checked Anand Naroji's reply in this thread.

if nothing helps you contact SAP.

[Sriram2009 · Accepted solution]

Hi Raja

Could you check this SAP KBA and note

1500199 - Insufficient tablespace to write data.

139078 - ORA-01658 during hierarchy processing in BW

ORA-01658: unable to create INITIAL extent tips

Regards

SS

[Former Member · Accepted solution]

Hi Sriram,

I have added 1007 GB to that tablespace and issue is solved.

Regards,

Prashanth Raja

[Former Member]

Hello Prashanth,

Extend the tablespace PSAPSR3702Xh and try to run SUM again. if it does not work then

Please check the output of the following statement:

select tablespace_name, allocation_type from dba_tablespaces where tablespace_name = 'PSAPSR3702Xh';

If the output is "ALLOCATION" column show 'UNIFORM' then please proceed as follows:

- Recreate PSAPSR3702Xh as an LMTS tablespace with the allocation_type auto.  Please refer to os note #214995 regarding LMTS;

- Reorganize PSAPSR3702Xh as per oss note #646681.