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.
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.