SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64570: SAS® Visual Investigator alert scenario flows fail, and you see a DataIntegrityViolationException message

DetailsHotfixAboutRate It

When you run scenario flows to generate alerts, the flows might fail intermittently with no obvious cause. In the vsd log, you see a message that is similar to the following:

2019-01-29T13:08:42.36-0500 [APP/PROC/WEB/0] OUT 2019-01-29 18:08:42.363 ERROR 9 --- [enerContainer-8] c.s.f.t.s.ScenarioFiredEventService  [645/83791]\u2502 103206 vcap      10 -10   64228   2920   2484 R   0.0  0.0   0:00.00 top vi-alert@@acme [196069dbf4a71098] Error replicating object.  ScenarioFiredEventId: fcf05550-f74a-4975-b32d-939753866086                     

You also see an exception like the following:

    2019-01-29T13:08:42.36-0500 [APP/PROC/WEB/0] OUT org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [tdc_replicated_object_replicated_object_id_key]; nested exception is org.hibernate.exception.ConstraintViolationException:
    2019-01-29T13:08:42.36-0500 [APP/PROC/WEB/0] OUT at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:278) 2019-01-29T13:08:42.36-0500 [APP/PROC/WEB/0] OUT     at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244)  
    2019-01-29T13:08:42.36-0500 [APP/PROC/WEB/0] OUT at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible
(AbstractEntityManagerFactoryBean.java:525)
    2019-01-29T13:08:42.36-0500 [APP/PROC/WEB/0] OUT at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible
(ChainedPersistenceExceptionTranslator.java:59) 

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual InvestigatorLinux for x6410.5.110.6ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.