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.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.