Symptom
- During system update using Software update manager (SUM) in phase MAIN_NEWBAS/PARCONV_UPG, the following error is reported:
PARCONV.ELG:=========================
2WETP000 07:17:07: Retcode 1024: error in DDL statement for "/BIC/B0000420000" - repeat
3 ETP355 executed ( "0:00:12 (12.016595 sec)" )
2EETP345 07:17:19: Retcode 1024: SQL-error "322-cannot use duplicate view name: /BIC/B0000420000: l
2EETP345 ine 1 col 32 (at pos 31)" in DDL statement for "/BIC/B0000420000"
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 07:17:19: error in DDL, nametab for "/BIC/B0000420000" not activated
1 ETP111 exit code : "8"
==========================
and
PD*_PARCONV_UPG.<SID>:
3 ETP379X07:17:07: activating Nametab "/BIC/B0000420000":
3 ETP355Xstatements:
2 ETP000 CREATE COLUMN TABLE "SAPABAP1"."/BIC/B0000420000" ("REQUEST" NVARCHAR (000030) DEFAULT ''
2 ETP000 NOT NULL, "DATAPAKID" NVARCHAR (000006) DEFAULT '000000' NOT NULL, "RECORD" INTEGER DEFAUL
2 ETP000 T 0 NOT NULL, "COMP_CODE" NVARCHAR (000004) DEFAULT '' NOT NULL, "DEBITOR" NVARCHAR (00001.....
.....
2WETP000 07:17:07: Retcode 1024: error in DDL statement for "/BIC/B0000420000" - repeat
3 ETP355 executed ( "0:00:12 (12.016595 sec)" )
2EETP345 07:17:19: Retcode 1024: SQL-error "322-cannot use duplicate view name: /BIC/B0000420000: l
2EETP345 ine 1 col 32 (at pos 31)" in DDL statement for "/BIC/B0000420000"
Read more...
Environment
Systems running on NetWeaver 7.x with HANA database
Product
SAP S/4HANA all versions ; SAP S/4HANA foundation on SAP NetWeaver Application Server for ABAP, version for SAP HANA all versions
Keywords
SQL-error, 322, cannot use, duplicate view, cannot use duplicate view name, Retcode 1024, /BIC/B*, PARCONV_UPG , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , 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.
SAP Knowledge Base Article - Preview