soerepro: par_a_code must be unique

Bug #1009503 reported by Olivier Maury
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Datum
New
Critical
amd

Bug Description

The file template and the integration at soerepro/insertion/copyPasteFile use par_a_code to find the parameter. But par_a_code is not unique. Several parameters have the same code ("PCB *").

This will block the integration of values for such parameters.

To find them, use this SQL query:

 SELECT par_a_code, COUNT(*) AS cpt
 FROM parametre
 GROUP BY par_a_code
 HAVING COUNT(*) > 1
 ORDER BY par_a_code;

When these few codes will be replaced, a UNIQUE constraint must be added.

Tags: metadata
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.