Hello,
During the update process i have this SQL error:2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 7 ERROR: numeric field overflow
DETAIL: A field with precision 3, scale 0 must round to an absolute value less than 10^3.
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] For query : INSERT INTO columnselector
(scope,objectClass,idUser,field,attribute,hidden,sortOrder,name)
SELECT
'workflow' AS scope,
CONCAT('workflow#', w.id) AS objectClass,
s.id AS idUser,
s.name AS field,
s.name AS attribute,
CASE
WHEN s.forAgileScrum = '1' THEN 0
WHEN s.id = (
SELECT s2.id
FROM status s2
WHERE s2.forAgileScrum = '0'
AND s2.idle = '0'
ORDER BY s2.sortOrder ASC, s2.id ASC
LIMIT 1
) THEN 0
ELSE 1
END AS hidden,
COALESCE(s.sortOrder, s.id) * 10 + 300 AS sortOrder,
CONCAT('workflow#', w.id, ' status#', s.id) AS name
FROM workflow w
JOIN status s ON 1=1
LEFT JOIN columnselector cs
ON cs.scope='workflow'
AND cs.objectClass = CONCAT('workflow#', w.id)
AND cs.idUser = s.id
WHERE w.name = 'Agile'
AND cs.id IS NULL;
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] Strack trace :
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] #0 Sql->query called at [/var/www/html/db/maintenanceFunctions.php:72]
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] #1 runScript called at [/var/www/html/db/maintenance.php:179]
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] #2 include called at [/var/www/html/tool/loginCheck.php:145]
2025-12-22 17:55:59.067 ===== TRACE =====
2025-12-22 17:55:59.067 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V12.4.0 (see above message)
2025-12-22 17:55:59.067 ===== TRACE =====
2025-12-22 17:55:59.067 ===== TRACE ===== *************************************************
My question is: it is un blooking point or not ?
Thanks for your feedback.
Bruno.
Hi,
thank for your feedback,
this sql error is not blocking if your not using the new Agile scrum feature.
We create a new ticket #10951 for this issue it will be fix in next patch and if your got subscription you can get the fixe as soon has it will be fixed.
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
Cookies settings
×
Functional Cookies
Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.
Session
Please login to see yours activities!
Other cookies
Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.