Skip to Content
avatar image
Former Member

nametab for "VZFZE" not activated

Hello,

We would like to ask for any help in case you have encountered this type of error:

MVNTABS ERRORS: ddlntabs and RETURN CODE in PD991030.EC2

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2EETP345 12:21:37: Retcode 1: SQL-error "22859-ORA-22859: invalid modification of columns" in DDL s

2EETP345 tatement for "VZFZE "

2EETP334 12:21:37: error in DDL, nametab for "VZFZE" not activated

1 ETP111 exit code : "8"

We are currently doing an enhancement package 4 on our ECC6 and we are stuck on "downtime" phase with this type of error.

Thanks in advance for your reponse.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 03, 2009 at 05:26 PM

    Hi,

    This error generally comes in upgrade when upgrade tries to change data type of column XVAR700 from CLOB to VARCHAR2(3600).

    When we faced this problem we took backup of the table then changed the data type of this column to VARCHAR2(3600) manually. And it went through.

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2009 at 10:39 AM

    Hello Jaypee,

    your error .... "ORA-22859: invalid modification of columns".

    Now let's check at first the table definition (copy and paste from my ECC 6.0 system with any EPHs).

    SQL> desc SAPSR3.VZFZE ;
     Name                                      Null?    Type
     ----------------------------------------- -------- ----------------------------
     MANDT                                     NOT NULL VARCHAR2(9)
     BUKRS                                     NOT NULL VARCHAR2(12)
     SVORGANG                                  NOT NULL VARCHAR2(30)
     LFDNR                                     NOT NULL VARCHAR2(9)
     SBUAKT                                    NOT NULL VARCHAR2(9)
     SATZART                                   NOT NULL VARCHAR2(30)
     SOBJEKT                                   NOT NULL VARCHAR2(30)
     VARLNG                                    NOT NULL NUMBER(5)
     XVAR700                                            CLOB
    

    And now let's check the service market place for informations about "ORA-22859" ... and find sapnote #1160950.

    This error may occur when you activate a table, in the phase PARCONV_UPG of an upgrade, or when you import a Support Package.

    Reason and Prerequisites

    The field of the relevant table has a DDIC length (in a Non-UNICODE case) of between 2000 and 4000 or of between 666 and 1333 in a UNICODE case. This field has the data type LONG or CLOB on the database.

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded