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
Situation
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
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.
- Document ID:000021481
- Creation Date: 02-Jul-2024
- Modified Date:02-Jul-2024
-
- SUSE Manager Server
For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback[at]suse.com
