Environment:
ZENworks 23.4 or higher
Situation:
When Migrating the ZENworks database on Oracle or MS SQL to embedded PostgreSQL using db-migration-tool, the migration fails due to the below error in the microfocus-zenworks-migration.log [ERROR] [10/04/2024 09:32:50.111] [24487] [AbstractDBMigrationDest] [36] [root] [ConfigureUtility] [] [Exception while migrating table : ZCVE] [java.sql.BatchUpdateException:
...
Caused by: org.postgresql.util.PSQLException: ERROR: index row size 2744 exceeds btree version 4 maximum 2704 for index "idx_zcve_summary_lower"
Detail: Index row references tuple (7352,9) in relation "zcve".
Hint: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)
Exception while performing migration of schema: ZCM. Refer microfocus-zenworks-configure.log for details. : DB migration failed for schema: ZCM] [com.novell.zenworks.configure.ConfigureException: DB migration failed for schema: ZCM
Note: The above error is specific to the ZCVE table, which is populated using CVE subscription for ZENworks Patch Management
Support
Documentation
Learning Services
Partner Programs
