Error while migrating Sybase embedded database to Oracle

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

Environment

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

Situation

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

Resolution

This is fixed in version 10.1.3 - see KB 7002526 "ZENworks 10 Configuration Management 10.1.3" which can be found at https://www.novell.com/support
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.