SAP Knowledge Base Article - Preview

3002168 - DB6: table creation failed with SQL0204N "<tablespace name>" is an undefined name in MAIN_NEWBAS/PARCONV_UPG phase during system upgrade

Symptom

Table creation is failed in MAIN_NEWBAS/PARCONV_UPG phase during system upgrade.

The following errors can be found

in PARCONV.ELG:

4 ED0314 DROP TABLE "<tablename>"
2 ED0313 SQL error -204: SQL0204N "<schema>.<tablename>" is an undefined name. SQLSTATE=42
2 ED0314 704
4 EDA093 "DDL time(___1):" ".........1" milliseconds
4 EGT247 .... "<tablename>" was already removed
2EEGT207 Creation of table "<tablename>" or primary index in DB failed
2EEGT239 Error in step "<tablename>-STEP2"
4 EGT253XTotal time for table "<tablename>": "000:00:00"
2EEGT094 Conversion could not be restarted


in NCONVXX.<sid>:

2 EGT054XRequest: Convert "Table <tablename> (DDIC/27.11.20/10:18)"
3WEGT062 A restart log already exists for table "<tablename>"
4 EGT092 Conversion of table "<tablename>" was restarted
2 EGT241 The conversion is continued at step "2"
4 EGT246 Type of conversion: "P" -> "T"
4 EGT850XBeginning of Step "<tablename>-STEP2" ( "10:18:03" )
4 EGT281 sql:
4 ED0314 CREATE TABLE "<tablename>"
...
4 ED0314 IN "<tablespace name>"
4 ED0314 INDEX IN "<tablespace name>"
4 ED0314 LONG IN "<tablespace name>"
4 ED0314 COMPRESS NO
2 ED0313 SQL error -204: SQL0204N "<tablespace name>" is an undefined name. SQLSTATE=42704
4 EDA093 "DDL time(___1):" ".........2" milliseconds
2EEGT236 The SQL statement was not executed
4 EGT281 sql:
4 ED0314 DROP TABLE "J_POOL_S01"
2 ED0313 SQL error -204: SQL0204N "<schema>.<tablename>" is an undefined name. SQLSTATE=42
2 ED0314 704
4 EDA093 "DDL time(___1):" ".........1" milliseconds
4 EGT247 .... "<tablename>" was already removed
2EEGT207 Creation of table "<tablename>" or primary index in DB failed
2EEGT239 Error in step "<tablename>-STEP2"
4 EGT253XTotal time for table "<tablename>": "000:00:00"
2EEGT094 Conversion could not be restarted

Issue can happen on several tables.


" is an undefined name in MAIN_NEWBAS/PARCONV_UPG phase during system upgrade"> Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

SQL0204N, PARCONV_UPG , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.