Problem Note 67789: Instances of "...duplicate key value violates unique constraint..." errors occur in the SAS® Web Infrastructure Platform Database log file
 |  |  |  |
In the SAS Web Infrastructure Platform Database log file, you might see errors like the following:
2021-04-09 06:14:49.008 EDTDETAIL: Key ("timestamp", measurement_id)=(1617963000000, 25458) already exists.
2021-04-09 06:14:49.008 EDTSTATEMENT: INSERT INTO HQ_METRIC_DATA_7D_0S (measurement_id, timestamp, value) VALUES (25458, 1617963000000, 0.00000)
2021-04-09 06:14:49.008 EDTERROR: duplicate key value violates unique constraint "hq_metric_data_7d_0s_pkey"
2021-04-09 06:14:49.008 EDTDETAIL: Key ("timestamp", measurement_id)=(1617963000000, 23796) already exists.
2021-04-09 06:14:49.008 EDTSTATEMENT: INSERT INTO HQ_METRIC_DATA_7D_0S (measurement_id, timestamp, value) VALUES (23796, 1617963000000, 0.24998)
2021-04-09 06:14:49.009 EDTERROR: duplicate key value violates unique constraint "hq_metric_data_7d_0s_pkey"
2021-04-09 06:14:49.008 EDTSTATEMENT: INSERT INTO HQ_METRIC_DATA_7D_0S (measurement_id, timestamp, value) VALUES (25458, 1617963000000, 0.00000)
2021-04-09 06:14:49.008 EDTERROR: duplicate key value violates unique constraint "hq_metric_data_7d_0s_pkey"
2021-04-09 06:14:49.008 EDTDETAIL: Key ("timestamp", measurement_id)=(1617963000000, 23796) already exists.
2021-04-09 06:14:49.008 EDTSTATEMENT: INSERT INTO HQ_METRIC_DATA_7D_0S (measurement_id, timestamp, value) VALUES (23796, 1617963000000, 0.24998)
2021-04-09 06:14:49.009 EDTERROR: duplicate key value violates unique constraint "hq_metric_data_7d_0s_pkey"
The errors are related to SAS® Environment Manager and can be ignored.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Environment Manager | Microsoft® Windows® for x64 | ||
| 64-bit Enabled AIX | ||||
| 64-bit Enabled Solaris | ||||
| HP-UX IPF | ||||
| Linux for x64 | ||||
| Solaris for x64 | ||||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-04-15 15:36:35 |
| Date Created: | 2021-04-15 13:11:46 |