cancel
Showing results for 
Search instead for 
Did you mean: 

Error during support pack using SUM

Former Member
0 Kudos

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

View Entire Topic
Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

paste here latest .elg log file.

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

please paste latest .elg file.

Former Member
0 Kudos

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
0 Kudos

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.

Former Member
0 Kudos

Hi Sriram,

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

Regards,

Prashanth Raja