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 (4696213).
Violation of PRIMARY KEY constraint 'PK_CS_QRY_DETAIL'. Cannot insert duplicate key in object 'dbo.CS_QRY_DETAIL'. The duplicate key value is (4696213, 00010575, 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 (4696213, 2011-2012, 00010575, DOE).
The statement has been terminated.
The statement has been terminated.
DEBUG: 13:35:05:500 - Load and Clean: Remove existing QID rows which will be re-inserted from CS_QRY_DETAIL
DEBUG: 13:35:05:507 - Load and Clean: USER <> RPISSSLUSER - Entered code block.
DEBUG: 13:35:05:507 - Load and Clean: USER<>RPISSSLUSER - Load protected (0) sites not having a DFRP and also protected (0) sites on protected (0) pro
DEBUG: 13:35:05:610 - Load and Clean: USER<>RPISSSLUSER - Load protected (0) sites hiding location where the sites are located on protected (2) proper
DEBUG: 13:35:05:653 - Load and Clean: USER<>RPISSSLUSER - Load protected (2) sites hiding location where the sites are located on properties not bring
DEBUG: 13:35:05:670 - Load and Clean: USER<>RPISSSLUSER - Load Annual Data for queried sites.
The statement has been terminated.
DEBUG: 13:35:05:680 - Load and Clean: Update summary metrics.
Page: /fcsi-rscf/cm-eng.aspx