Treasury Board of Canada Secretariat - Government of Canada

Erreur

Une erreur a été produite dans le l'Inventaire des sites contaminés fédéraux (ISCF).[65] 14::usp_FCSI_QryCM
-2146232060
Violation of PRIMARY KEY constraint 'PK_CS_QRY_DETAIL'. Cannot insert duplicate key in object 'dbo.CS_QRY_DETAIL'. The duplicate key value is (4592390, 00003305, 0). Violation of PRIMARY KEY constraint 'PK_CS_QRY_DETAIL_FY'. Cannot insert duplicate key in object 'dbo.CS_QRY_DETAIL_FY'. The duplicate key value is (4592390, 2011-2012, 00003305, DOE). The statement has been terminated. DEBUG: 11:21:57:183 - Load and Clean: Remove existing QID rows which will be re-inserted from CS_QRY_DETAIL DEBUG: 11:21:57:187 - Load and Clean: USER <> RPISSSLUSER - Entered code block. DEBUG: 11:21:57:187 - Load and Clean: USER<>RPISSSLUSER - Load protected (0) sites not having a DFRP and also protected (0) sites on protected (0) pro DEBUG: 11:21:57:383 - Load and Clean: USER<>RPISSSLUSER - Load protected (0) sites hiding location where the sites are located on protected (2) proper DEBUG: 11:21:57:483 - Load and Clean: USER<>RPISSSLUSER - Load protected (2) sites hiding location where the sites are located on properties not bring DEBUG: 11:21:57:540 - Load and Clean: USER<>RPISSSLUSER - Load Annual Data for queried sites. The statement has been terminated. DEBUG: 11:21:57:560 - Load and Clean: Update summary metrics.
 

Page: /fcsi-rscf/cm-fra.aspx