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.

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