Error upgrading BB8.0.7 HF2 to BB9.1 SP7HF1

Encountered the following error while running the updater:


[java] [2012/04/03 12:46:03.538]        == updating table domain_tab_coll, 3 column(s)
     [java] [2012/04/03 12:46:03.539]        == altering table domain_tab_coll adding column parent_domain_pk1 as integer NOT NULL  DEFAULT null
     [java] java.sql.SQLException: Failed while executing: ALTER TABLE domain_tab_coll ADD parent_domain_pk1 integer  NOT NULL
     [java] ORA-01758: table must be empty to add mandatory (NOT NULL) column
     [java]
   

Solution.



truncate table bb_bb60.domain_tab_coll;