Error while migrating Sybase embedded database to Oracle

  • 7001858
  • 12-Nov-2008
  • 27-Apr-2012


Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1 Database


ERROR:  Exception: [2008.10.22-18:23:26]SEVERE: ORA-01400: cannot insert NULL into("ZENWORKS"."LC_TALLYPRODUCT"."MANUFACTURER")


This is fixed in version 10.1.3 - see KB 7002526 "ZENworks 10 Configuration Management 10.1.3" which can be found at
Workaround:  Flag the tables on Oracle to allow Null values.

Additional Information

Note: In the future, the SQL scripts will be modified appropriately by removing the NOT NULL constraint for the tables causing issues.