Execution of the published flow fails with error "duplicate key value violates unique constraint..." in SAS® Visual Investigator 10.8


In SAS Visual Investigator, a flow contains one or more primary scenarios, which can be record-level, aggregation, or DATA step scenarios. Along with primary scenarios, you can have summary scenarios.

The SAS Visual Investigator Scenario Administration service processes summary scenarios for a flow after the primary scenarios are run. When you run a published flow, alerts are produced. Published flow execution might fail with the following error in the user interface:

ERROR: duplicate key value violates unique constraint "scenario_fired_event_id" Detail: Key (scenario_fired_event_id)=(xxx) already exists.

Published flow execution might fail with the following error in the vsd-service log file:

ERROR — [] c.s.f.t.s.ScenarioFiredEventService : sas.svi-alert@@xxx[] Datahub SFE context request for SFE "xxx" returned status code 404 NOT_FOUND. Replicate the SFE's contributing objects instead.

com.sas.fcs.tdc.exceptions.TDCUnhandledServerException: Error response from REST GET. Status Code: 404 NOT_FOUND {"httpStatusCode":404,"errorCode":"DH6127","message":"The relationship with name \"xxx\" was not found in the entity with name \"xxx\".","version":1}

ERROR: duplicate key value violates unique constraint "scenario_fired_event_id" Detail: Key (scenario_fired_event_id)=(xxx) already exists.

This issue is fixed in the SAS Visual Investigator 10.8 update for February 2022.