DB6CONV fails on conversion to 'adaptive' type compression

[former_member283840]

DB6CONV fails when trying to convert table BKPF.  Any thoughts? Thanks, Len. Here is error: ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 20151203 213519 =============NEW CONVERSION - START================== 20151203 213519 Version of DB6CONV            : 6.21 20151203 213519 SID                          : ES1 20151203 213519 Name of application server    : aubces1 20151203 213519 strt_date,strt_time          : 20151203 213519 20151203 213519 Starttime                    : 20151203 213519 20151203 213519 Internal Conversion ID        : 1384 20151203 213519 Conversion type              : Batch immediate 20151203 213519 >> Batch job name            : DB6CONV_MKPF 20151203 213519 >> Batch job number          : 21351900 20151203 213519 Conversion defined specifying : Target Tablespaces 20151203 213519 Conversion object            : Single Table 20151203 213519 Table name                    : MKPF 20151203 213519 DATA Tablespace              : ES1#BTABD 20151203 213519 >>> Partition group          : SAPNODEGRP_P01 20151203 213519 >>> Partition number          :  0 20151203 213519 INDEX Tablespace              : ES1#BTABI 20151203 213519 >>> Partition group          : SAPNODEGRP_P01 20151203 213519 >>> Partition number          :  0 20151203 213519 LONG Tablespace (optional)    : 20151203 213519 Use COPY_WITH_INDEXES        : Yes 20151203 213519 Use LOAD                      : No 20151203 213519 Use REDIRECT                  : No 20151203 213519 Stop before switching        : No 20151203 213519 Switch on AMT Trace          : No 20151203 213519 COMPRESS Data                : YES (ADAPTIVE) 20151203 213519 COMPRESS Index                : KEEP 20151203 213519 ITC                          : Keep 20151203 213519 Delete original              : Yes 20151203 213519 Update Statistics After Conv. : Yes 20151203 213519 >>> LOCKSIZE : ROW 20151203 213519 >>> OPTIONS : COMPRESS YES STATIC 20151203 213519 DROP TABLE "QCM8MKPF" 20151203 213519 SQL0204N  "SAPSR3.QCM8MKPF" is an undefined name.  SQLSTATE=42704 => IGNORE                   AND CONTINUE 20151203 213519 CREATE TABLE "QCM8MKPF" ("MANDT" SAPDB6CHAR(000003) DEFAULT '000' NOT NULL                   , "MBLNR" SAPDB6CHAR(000010) DEFAULT ' ' NOT NULL , "MJAHR"                   SAPDB6CHAR(000004) DEFAULT '0000' NOT NULL , "VGART" SAPDB6CHAR(000002)                   DEFAULT ' ' NOT NULL , "BLART" SAPDB6CHAR(000002) DEFAULT ' ' NOT NULL ,                   "BLAUM" SAPDB6CHAR(000002) DEFAULT ' ' NOT NULL , "BLDAT"                   SAPDB6CHAR(000008) DEFAULT '00000000' NOT NULL , "BUDAT"                   SAPDB6CHAR(000008) DEFAULT '00000000' NOT NULL , "CPUDT"                   SAPDB6CHAR(000008) DEFAULT '00000000' NOT NULL , "CPUTM"                   SAPDB6CHAR(000006) DEFAULT '000000' NOT NULL , "AEDAT" SAPDB6CHAR(000008)                   DEFAULT '00000000' NOT NULL , "USNAM" SAPDB6CHAR(000012) DEFAULT ' ' NOT                   NULL , "TCODE" SAPDB6CHAR(000004) DEFAULT ' ' NOT NULL , "XBLNR"                   SAPDB6CHAR(000016) DEFAULT ' ' NOT NULL , "BKTXT" SAPDB6CHAR(000025)                   DEFAULT ' ' NOT NULL , "FRATH" DECIMAL(000013,000002) DEFAULT 0 NOT NULL                   , "FRBNR" SAPDB6CHAR(000016) DEFAULT ' ' NOT NULL , "WEVER"                   SAPDB6CHAR(000001) DEFAULT ' ' NOT NULL , "XABLN" SAPDB6CHAR(000010)                   DEFAULT ' ' NOT NULL , "AWSYS" SAPDB6CHAR(000010) DEFAULT ' ' NOT NULL ,                   "BLA2D" SAPDB6CHAR(000002) DEFAULT ' ' NOT NULL , "TCODE2"                   SAPDB6CHAR(000020) DEFAULT ' ' NOT NULL , "BFWMS" SAPDB6CHAR(000001)                   DEFAULT ' ' NOT NULL , "EXNUM" SAPDB6CHAR(000010) DEFAULT ' ' NOT NULL ,                   "SPE_BUDAT_UHR" SAPDB6CHAR(000006) DEFAULT '000000' NOT NULL ,                   "SPE_BUDAT_ZONE" SAPDB6CHAR(000006) DEFAULT ' ' NOT NULL , "LE_VBELN"                   SAPDB6CHAR(000010) DEFAULT ' ' NOT NULL , "SPE_LOGSYS" SAPDB6CHAR(000010)                   DEFAULT ' ' NOT NULL , "SPE_MDNUM_EWM" SAPDB6CHAR(000016) DEFAULT ' ' NOT                   NULL , "GTS_CUSREF_NO" SAPDB6CHAR(000035) DEFAULT ' ' NOT NULL , "KNUMV"                   SAPDB6CHAR(000010) DEFAULT ' ' NOT NULL , "XCOMPL" SAPDB6CHAR(000001)                   DEFAULT ' ' NOT NULL , "FLS_RSTO" SAPDB6CHAR(000001) DEFAULT ' ' NOT NULL                   , "MSR_ACTIVE" SAPDB6CHAR(000001) DEFAULT ' ' NOT NULL) IN "ES1#BTABD"                   INDEX IN "ES1#BTABI" LONG IN "ES1#BTABD" PARTITION BY (MANDT , MJAHR) (                   PART "MKPF_900_2008" STARTING ( '900' , '2008' ) IN "MKPF1D" INDEX IN                   "MKPF1I" LONG IN "MKPF1D", PART "MKPF_900_2009" STARTING ( '900' , '2009'                   ) IN "MKPF2D" INDEX IN "MKPF2I" LONG IN "MKPF2D", PART "MKPF_900_2010"                   STARTING ( '900' , '2010' ) IN "MKPF3D" INDEX IN "MKPF3I" LONG IN                   "MKPF3D", PART "MKPF_900_2011" STARTING ( '900' , '2011' ) IN "MKPF4D"                   INDEX IN "MKPF4I" LONG IN "MKPF4D", PART "MKPF_900_2012" STARTING ( '900'                   , '2012' ) IN "MKPF5D" INDEX IN "MKPF5I" LONG IN "MKPF5D", PART                   "MKPF_900_2013" STARTING ( '900' , '2013' ) IN "MKPF6D" INDEX IN "MKPF6I"                   LONG IN "MKPF6D", PART "MKPF_900_2014" STARTING ( '900' , '2014' ) IN                   "MKPF7D" INDEX IN "MKPF7I" LONG IN "MKPF7D", PART "MKPF_900_2015"                   STARTING ( '900' , '2015' ) IN "MKPF8D" INDEX IN "MKPF8I" LONG IN                   "MKPF8D", PART "MKPF_900_2016" STARTING ( '900' , '2016' ) IN "MKPF9D"                   INDEX IN "MKPF9I" LONG IN "MKPF9D", PART "MKPF_900_MAX" STARTING ( '900'                   , '2017' ) ENDING ( '900' , '9999' ) INCLUSIVE IN "MKPF10D" INDEX IN                   "MKPF10I" LONG IN "MKPF10D", PART "MKPF_900_GUARD_LOW" STARTING ( '000' ,                   MINVALUE ) ENDING ( '899' , MAXVALUE ) IN "MKPFLD" INDEX IN "MKPFLI" LONG                   IN "MKPFLD", PART "MKPF_900_GUARD_HIGH" STARTING ( '901' , MINVALUE )                   ENDING ( '999' , MAXVALUE ) IN "MKPFHD" INDEX IN "MKPFHI" LONG IN                   "MKPFHD" ); -- DB6_PARTAD DELTA 0 PARTSIZE 0 SPAREPART 2 20151203 213519 SQL0204N  "MKPFLD" is an undefined name.  SQLSTATE=42704 20151203 213519 Step 1 aborted with errors 20151203 213519 *************************************************** 20151203 213519 Status  : >>>>>>> CONVERSION ABORTED <<<<<<< 20151203 213519 Stoptime: 20151203 213519 20151203 213519 Duration: 0:00:00 20151203 213519 =============END OF SECTION==========================

[Former Member]

Hello,

Please make sure that you have a tablespace called "MKPFLD" in your database.

Regards,

Masako

[former_member283840]

Masako;

Thanks for the recommendation but it is not necessary to have a specific tablespace for this conversion.  I have done others without and they completed OK.

Thanks,

Len.

[former_member301417]

Hi Leonard,

please check carefully the CREATE TABLE statement you posted in the very beginning:

partition PART "MKPF_900_GUARD_LOW" is specified with 'IN "MKPFLD" INDEX IN "MKPFLI" LONG IN "MKPFLD"! so the two tablespaces mentioned here must exist. the error message you receive indicates, that MKPFLD does not exist on db level.

regards, Frank

[former_member283840]

Frank;

I see that but it is to be created in the 'temp' tablespace that is to be created by the program.  This tablespace will be deleted also upon completion.

Thanks,

Len.

[former_member283840]

Frank;

My mistake.  The utility will only create a new tablespace if you chose too.  I did not so therefore the temporary tables (qcm---) will be built in the source tablespaces, BTABD, BTABI.

Thanks,

Len.

[former_member301417]

Hi Leonard,

Does tablespace MLPFLD exist on db level or not?

I did not quite understand your last response:

- Which "temp" tablespace do you refer to?

- Where did you speficy that the table is to be created into the "temp" tbsp (instead of MLPFLD?)

- What is "the program"?

- Which tablespace do you refer to in the last sentence with "This tablespace"?

Regards, Frank

[former_member283840]

Frank;

I responded to your last reply but you might have missed it.

The program DB6CONV lets you choose to either create a new tablespace for the conversion or if you do not and choose to use the existing tablespace that the source of the conversion is it will do that.  I did not create a new tablespace and let the program use the existing tablespace (BTABD & BTABI) for this conversion.  That is where the code goes wrong.  For whatever reason it is not using the existing tablespace to create the 'temporary' tables (qcm8) and that is why it fails in the first step. This is a DB6CONV issue as I have used the utility to make this conversion before. I hope this clears up the confusion you were having.

Thanks,

Len.

[former_member283840]

To all;

This is not a problem caused by the non-creation of a tablespace.  It is caused by the creation of the temporary table (qcm8).xxx for each object.  Table MKPF has more than 254 columns and that is why this program fails. The code to correct this was supposedly in version 6.09 or higher.  This system has version 6.21 which is supposed to have the fix included.  That is why this execution is failing.

Thanks,

Len.

[maria_shen]

Hello Len,

As Frank has pointed out already , the conversion log listed in the initial description shows creation of QCM8 table failed due to SQL0204N error. It claims the missing of tablespace MKPFLD.

Regarding of the defect you metioned above, it would return the SQL0204N error claiming for QCM8 table, which is not the case here (here it claims for the tablespace). Furthermore, as described in note#1513862, if you hit this defect, the table conversion will finish without error when you click continue.

Kind regards
Maria