1. Home
  2. Support
Article - CS196513

Viewing Integrity Items fail with "check constraint (SYS.JAVA_DEV_DISABLED) violated" error

Modified: 16-Oct-2015   


Applies To

  • Integrity Server 2009, all service packs
  • Integrity Server 10.0 - 10.6
  • Configured for Oracle Database

Description

  • When viewing an Integrity Item containing dynamic aggregate computations, the following error is displayed to the user:
MKS124814: Cannot show view information: MKS131372: An unhandled database exception has occurred. Please contact your administrator.
The error supplied by the database is:
ORA-04045: errors during recompilation/revalidation of <schema>.IM
ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated
  • The following errors appear in the Integrity Server's <serverInstallDir>/log/server.log file with DEBUG logging enabled:
2015-01-20 15:26:42,750 DEBUG [mksis.IntegrityServer] DEBUG mks.ci.exception.CIException: java.sql.SQLException: MKS131372: An unhandled database exception has occurred.  Please contact your administrator.
The error supplied by the database is:
  ORA-04045: errors during recompilation/revalidation of <schema>.IM
ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    at mks.frame.sql.jdbc.common.CancellablePreparedStatement.executeQuery(CancellablePreparedStatement.java:78)
    at mks.frame.sql.jdbc.oracle.PreparedStatement.executeQuery(PreparedStatement.java:64)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:224)
    at mks.ci.server.engine.EngineIssue.populateComplexComputations(EngineIssue.java:1203)
    at mks.ci.server.engine.EngineIssue.internalGetIssues(EngineIssue.java:10417)
    at mks.ci.server.engine.EngineIssue.internalGetIssues(EngineIssue.java:9616)
    at mks.ci.server.engine.EngineIssue.quickGetIssues(EngineIssue.java:308)
    at mks.ci.server.engine.EngineIssue.getIssue(EngineIssue.java:379)
    at mks.ci.server.engine.LocalTriggerManager$ScriptServerBean.getIssueDeltaBean(LocalTriggerManager.java:2273)
    at mks.ci.server.engine.LocalTriggerManager$ScriptServerBean.getIssueDeltaBean(LocalTriggerManager.java:2216)
    at mks.ci.server.engine.EngineIssue.setIssue(EngineIssue.java:4320)
    at mks.ci.server.engine.EngineIssue.setIssue(EngineIssue.java:4274)
    at mks.ci.server.engine.EngineSQL.newIssue(EngineSQL.java:14525)
    at mks.ci.server.AgentImpl.newIssue(AgentImpl.java:1359)
... continues
 
2015-01-20 15:26:42,750 DEBUG [mksis.IntegrityServer] DEBUG java.sql.SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-04045: errors during recompilation/revalidation of <schema>.IM
ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated
  • After applying the Oracle JVM Mitigation Patch (ID: 19721304) as suggested by Oracle Document 1929745.1 for temporary mitigation of known Oracle security vulnerabilities (to January 2015), Integrity Items containing dynamic aggregate computations can no longer be viewed.
This is a printer-friendly version of Article 196513 and may be out of date. For the latest version click CS196513