Treasury Board of Canada Secretariat - Government of Canada

Error

An error has been encountered in the Federal Contaminated Sites Inventory (FCSI).

[15] 14::dbo.usp_FCSI_QRY_CreateNewQID
-2146232060
Violation of PRIMARY KEY constraint 'PK_CS_QRY_SUMMARY'. Cannot insert duplicate key in object 'dbo.CS_QRY_SUMMARY'. The duplicate key value is (2336211). 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 (2336211, 2024-2025, 00028179, SVC). The statement has been terminated. DEBUG: 07:37:31:287 - Load and Clean: Remove existing QID rows which will be re-inserted from CS_QRY_DETAIL DEBUG: 07:37:31:290 - Load and Clean: USER <> RPISSSLUSER - Entered code block. DEBUG: 07:37:31:290 - Load and Clean: USER<>RPISSSLUSER - Load protected (0) sites not having a DFRP and also protected (0) sites on protected (0) pro DEBUG: 07:37:31:317 - Load and Clean: USER<>RPISSSLUSER - Load protected (0) sites hiding location where the sites are located on protected (2) proper DEBUG: 07:37:31:333 - Load and Clean: USER<>RPISSSLUSER - Load protected (2) sites hiding location where the sites are located on properties not bring DEBUG: 07:37:31:343 - Load and Clean: USER<>RPISSSLUSER - Load Annual Data for queried sites. The statement has been terminated. DEBUG: 07:37:31:347 - Load and Clean: Update summary metrics.
 
Page: /fcsi-rscf/fsi-isf/00028179-eng.aspx