SQL-error "904-ORA-00904: "T1"."UII": invalid identifier"

[Nik3]

Hello,

I am upgrading an SAP system from ECC 5.0 to ECC 6.0 EHP4 (Central Applications & Discrete Ind. + Mill. Products). At the moment I'm stuck in phase PMVNTAB_UPG. I get the following error:

PMVNTUPG.ELG:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
MVNTABS errors (DDL) and RETURN CODE in PD070304.UTS
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2EETP345 00:57:45: Retcode 1: SQL-error "904-ORA-00904: "T1"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMAML                       "
2EETP334 00:57:45: error in DDL, nametab for "VIQMAML" not activated
2EETP345 00:57:57: Retcode 1: SQL-error "904-ORA-00904: "T1"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMAML_IFLOS                 "
2EETP334 00:57:57: error in DDL, nametab for "VIQMAML_IFLOS" not activated
2EETP345 00:58:09: Retcode 1: SQL-error "904-ORA-00904: "T2"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMEL                        "
2EETP334 00:58:09: error in DDL, nametab for "VIQMEL" not activated
2EETP345 00:58:21: Retcode 1: SQL-error "904-ORA-00904: "T2"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMELST                      "
2EETP334 00:58:21: error in DDL, nametab for "VIQMELST" not activated
2EETP345 00:58:33: Retcode 1: SQL-error "904-ORA-00904: "T2"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMELST_IFLOS                "
2EETP334 00:58:33: error in DDL, nametab for "VIQMELST_IFLOS" not activated
2EETP345 00:58:45: Retcode 1: SQL-error "904-ORA-00904: "T2"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMEL_IFLOS                  "
2EETP334 00:58:45: error in DDL, nametab for "VIQMEL_IFLOS" not activated
2EETP345 00:58:57: Retcode 1: SQL-error "904-ORA-00904: "T2"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMFEL                       "
2EETP334 00:58:57: error in DDL, nametab for "VIQMFEL" not activated
2EETP345 00:59:09: Retcode 1: SQL-error "904-ORA-00904: "T2"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMFEL_IFLOS                 "
2EETP334 00:59:09: error in DDL, nametab for "VIQMFEL_IFLOS" not activated
2EETP345 00:59:21: Retcode 1: SQL-error "904-ORA-00904: "T1"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMSML                       "
2EETP334 00:59:21: error in DDL, nametab for "VIQMSML" not activated
2EETP345 00:59:33: Retcode 1: SQL-error "904-ORA-00904: "T1"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VIQMSML_IFLOS                 "
2EETP334 00:59:33: error in DDL, nametab for "VIQMSML_IFLOS" not activated
2EETP345 00:59:33: Retcode 1: SQL-error "904-ORA-00904: "T1"."UII": invalid identifier" in DDL stat
2EETP345 ement for "VQQMELST                      "
2EETP334 00:59:33: error in DDL, nametab for "VQQMELST" not activated
1 ETP111 exit code           : "8"

I didn't find anything in SAP notes and google search. I repeated this phase three times.

Has anybody of you come across this error during upgrade?

Best regards

Niklas

[former_member264034]

Hi,

Could you please check this with the below utility.

SE11 -> <Tabname> -> Execute -> Utilities -> Runtime Object -> Check"

and activate the tables.

Regarding the issue you are getting I would also suggest you to

check SAP Notes:

- 731 Collective note: ORA-00904 and

- 648203 Database objects with INVALID status

which should help you to solve the

problem.

Regards,

Aidan

[Nik3]

Hi

the views are now correctly created on the DB. I found out that the identifier UII comes from the table QMEL which was already active. I activated the QMEL again and now all my views are consistent and exist on the DB. I didn't have to activate the views as they were immediately consistent. Probably this has been done during activation of table QMEL.

Best regards

Niklas