Error while migrating Sybase embedded database to Oracle

  • Document ID:7001858
  • Creation Date:12-Nov-2008
  • Modified Date:27-Apr-2012
    • Micro Focus Products:
      ZENworks Configuration Management

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.