Forum SquashTM

Bonjour, Il se pourrait que le problème provienne des triggers qui ne seraient plus présents sur votre base. Cela peut arriver lorsque l'on migre d'une base mysql vers MariaDb, notamment dans les versions pré 5.X. Pouvez-vous passer cette requête sur votre base : show triggers; Cordialement, Xavier,...

Bonjour, Bonne nouvelle, les scripts de montée de version jusqu'à la v9.X de Squash ont bien été passés, dans l'ordre. Je pense qu'on peut exclure un problème sur la base de données, pour le moment. Pouvez-vous : nous envoyer une capture d'écran de la page Administration > Système , ancre 'Informati...

Bonjour, Le comportement que vous me décrivez pourrait ressembler à un problème lors de votre montée de version ou prérequis sur votre instance. Pouvez-vous nous envoyer le résultat de la requête suivante (via fichier excel), à passer sur votre base de données hébergeant SquashTM : SELECT * FROM DAT...

Hello, Thank you for your feedback. I will inform our developers that the latest request worked well. This forum post will be particularly useful for us in tracking any issues encountered by our customers on their database, as well as the means used to correct them. Best regards, Xavier, SquashTM Su...

Hello, Currently, such a search is not possible, but we have a feature request ticket for this on our public GitLab: https://gitlab.com/henixdevelopment/open-source/squash/squashtest-tm-staging/-/issues/222 However, we do not have a release date to announce at this time. Unfortunately, there is also...

Hello, Here is the query that should correct the numerous duplicates in your database: DELETE FROM ITEM_TEST_PLAN_EXECUTION WHERE ctid NOT IN ( SELECT ctid FROM ( SELECT ctid, ROW_NUMBER() OVER ( PARTITION BY EXECUTION_ID, ITEM_TEST_PLAN_ID ORDER BY ctid ) as rn FROM ITEM_TEST_PLAN_EXECUTION ) t WHE...

Hello, Our developers are working on a corrective script. As your database is particularly damaged, we were expecting only a few duplicates, not 2,000 lines of returns. In the meantime, could you please tell me which version your database was created in and whether any significant changes have been ...

Hello, Indeed, according to the logs sent, there are not only duplicate iterations but also executions attached to several iteration plans. Can you send us the result of this query to run on your database? SELECT STRING_AGG(ITERATION.ITERATION_ID::TEXT, ', ' ORDER BY ITERATION.ITERATION_ID) as itera...

Hello, In your case, the iteration (ID 178) named “09/01/2025 IWBDEF-69, 70, 71 & 05” is attached to two campaigns (ID 97 and 143). What you need to do: Determine which single campaign this iteration should be attached to On a pre-production database (or make sure you have at least one dump of y...

Hello, Excellent news about your upgrade. Deletion is indeed one of the possible solutions, but it was also possible to simply delete the link between iteration and campaign that should not have been there. I have taken note of your executions and test suites. Normally, the v10 script already takes ...