Importing patch information into database fails with SQL Exception: ERROR: value too long for type character varying(4000)

This document (000021481) is provided subject to the disclaimer at the end of this document.

Environment

SUSE Manager 4.3.12

Situation

/var/log/rhn/rhn_taskomatic_daemon.log contains errors similar to:

2024-06-14 00:00:09,975 [DefaultQuartzScheduler_Worker-7] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: INSERT INTO Errata (mgm_id, synced_date, severity,advisory_type,synopsis,update_date,advisory_name,errata_id,cve,issue_date,reboot_required,organization,advisory_status,affects_package_manager)      VALUES (1, current_timestamp, ?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT DO NOTHING
com.redhat.rhn.common.db.WrappedSQLException: ERROR: value too long for type character varying(4000)

Resolution

Please install the Program Temporary Fix (PTF) as provided here:

https://ptf.suse.com/f2cf38b50ed714a8409693060195b235/susemanager-4.3/28270/x86_64/20240702/

Once installed, please execute as root:

spacewalk-sql --reportdb --select-mode /etc/sysconfig/rhn/reportdb-schema-upgrade/uyuni-reportdb-schema-4.3.10-to-uyuni-reportdb-schema-4.3.11/001-alter-errata-cve-column.sql.postgresql

to change the database.

Cause

The errata table has a column defined as VARCHAR(4000) which is the maximum. The included SQL script changes the column to type text.

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.