SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 65133: It is not possible to run any job-flow instances

DetailsHotfixAboutRate It

When you launch a task in SAS® Risk Governance Framework or SAS® Risk and Finance Workbench, or when you create a job-flow instance directly within SAS® Infrastructure for Risk Management, the instance might not run and a message like the following might occur in the middle-tier log file SASIRMServer.log:

ERROR org.hibernate.util.JDBCExceptionReporter  - ERROR: duplicate key value violates unique constraint "ix_data_path"

This problem can occur when the SAS Infrastructure for Risk Management web application server startup process detects some job-flow instances as out-of-date due to data or timestamp changes in some federated areas.

To work around this problem, perform the following steps:

  1. Identify which federated areas are associated with the out-of-date job-flow instances.
  2. In SAS® Management Console, on the Plug-ins tab, select Application ManagementConfiguration ManagerSAS Application Infrastructure ► right-click IRM Mid-Tier Server ► select PropertiesAdvanced tab.
  3. For each federated area that you identified in Step (1), add the following property:
    Property Name: com.sas.solutions.risk.irm.alwaysexecute.fa.<federated-area-id>
    Property Value: true
  4. Restart the SAS Infrastructure for Risk Management web application server, which is typically SASServer8_1.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Infrastructure for Risk ManagementMicrosoft® Windows® for x643.59.4 TS1M5
Linux for x643.59.4 TS1M5
* 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.