SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 70645: SAS® Infrastructure for Risk Management errors

DetailsHotfixAboutRate It

A SAS Infrastructure for Risk Management instance fails with the following errors:

ERROR com.sas.solutions.risk.irm.server.engine.JobflowConfigurationManager  - java.lang.RuntimeException: org.omg.CORBA.COMM_FAILURE: An exception was thrown while sending a packet to the peer.  vmcid: 0x0  minor code: 0  completed: No
ERROR com.sas.solutions.risk.irm.server.engine.JobFlowService  - Cannot create instance: "irmif_input_report" 
java.lang.NullPointerException
    at com.sas.solutions.risk.irm.server.engine.FileService.resolveMacroVars(FileService.java:1114)
    at com.sas.solutions.risk.irm.server.engine.FileService.resolveLibname(FileService.java:886)...

ERROR com.sas.solutions.risk.irm.server.jobflowexec.JobFlowExecutor  - Caught exception in preparing the execution of flow instance 

java.lang.RuntimeException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

    at com.sas.solutions.risk.irm.server.persistence.PoolingDataAccessService.save(PoolingDataAccessService.java:113)

    …..

Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)

    …..

Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into data_path (DATA_PATH, DATA_PATH_KEY) values ('/app/sas/config/compute/Lev1/AppData/SASIRM/pa/pool/_1833095/GLOBAL.SYSTEM_OPTION.SAS7BDAT', 1926751) was aborted: ERROR: duplicate key value violates unique constraint "ix_data_path"

  Detail: Key (data_path)=(/app/sas/config/compute/Lev1/AppData/SASIRM/pa/pool/_1833095/GLOBAL.SYSTEM_OPTION.SAS7BDAT) already exists.  Call getNextException to see other errors in the batch.

    at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:154)

    …..

Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ix_data_path"

  Detail: Key (data_path)=(/app/sas/config/compute/Lev1/AppData/SASIRM/pa/pool/_1833095/GLOBAL.SYSTEM_OPTION.SAS7BDAT) already exists.

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2533)

    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2268)

    ... 23 more


ERROR com.sas.solutions.risk.irm.server.rest.JobFlowController - Caught exception when deleting job flow instance <instance_id>.java.lang.NullPointerException at
com.sas.solutions.risk.irm.server.webdav.IrmWebdavServlet.getFlowEntityKey(IrmWebdavServlet.java:2361) at com.sas.solutions.risk.irm.server.webdav.IrmWebdavServlet.cleanupCachedDataMap(IrmWebdavServlet.java:2376) at com.sas.solutions.risk.irm.server.engine.JobFlowService.deleteJobFlowInstance(JobFlowService.java:1835) at com.sas.solutions.risk.irm.server.engine.JobFlowService.deleteJobFlowInstance(JobFlowService.java:1802) at com.sas.solutions.risk.irm.server.rest.JobFlowController.deleteJobFlowInstance(JobFlowController.java:664)

ERROR | [[services]] | Servlet.service() for servlet [services] in context with path [/SASIRMServer] threw exception [Handler processing failed; nested exception is java.lang.StackOverflowError] with root cause
java.lang.StackOverflowError: null
        at java.util.HashMap.hash(HashMap.java:339) ~[?:1.8.0_252]
        at java.util.LinkedHashMap.get(LinkedHashMap.java:440) ~[?:1.8.0_252]
        at java.util.Collections$SynchronizedMap.get(Collections.java:2586) ~[?:1.8.0_252]
        at com.sas.metadata.remote.MdObjectStoreImpl.getObject(MdObjectStoreImpl.java:1019) ~[sas.oma.joma.rmt.jar:904601.3.0.20210115095737_v940m6f]
        at com.sas.metadata.remote.MdObjectStoreImpl.getObject(MdObjectStoreImpl.java:1003) ~[sas.oma.joma.rmt.jar:904601.3.0.20210115095737_v940m6f]
        at com.sas.metadata.remote.MdObjectListImpl.getObjectforID(MdObjectListImpl.java:1892) ~[sas.oma.joma.rmt.jar:904601.3.0.20210115095737_v940m6f]
        at com.sas.metadata.remote.MdObjectListImpl.getObjectforID(MdObjectListImpl.java:1872) ~[sas.oma.joma.rmt.jar:904601.3.0.20210115095737_v940m6f]
        at com.sas.metadata.remote.MdObjectListImpl.get(MdObjectListImpl.java:2560) ~[sas.oma.joma.rmt.jar:904601.3.0.20210115095737_v940m6f]
        at com.sas.metadata.remote.AssociationList.get(AssociationList.java:1665) ~[sas.oma.joma.rmt.jar:904601.3.0.20210115095737_v940m6f]
        at com.sas.solutions.risk.irm.server.utils.GroupRoleHelper.flattenGroup(GroupRoleHelper.java:289) ~

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.69.4 TS1M6
Linux for x643.69.4 TS1M6
* 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.