Getting error: Could not open JPA EntityManager for transaction

Hi,

Any idea what might be the issue behind below error ? also I have attached complete stacktrace of error.

Thanks,
Tushar

com.appiancorp.process.expression.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'pfdc_getrevieworganizationdata' (called by rules 'pfdc_getorganizationgroupidbyname' > 'pfdc_checkreviewgroupsplitrequired' > 'pfdc_viewloanmainscreen') at function a!queryEntity [line 33]: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection (APNX-1-4198-000)
at com.appiancorp.process.expression.ExpressionRuntimeException.<init>(ExpressionRuntimeException.java:70)
at com.appiancorp.core.expr.exceptions.AppianScriptException.<init>(AppianScriptExcept...

OriginalPostID-251643


Connectionerror.txt

  Discussion posts and replies are publicly visible

  • ...ion.java:25)
    at com.appiancorp.core.expr.exceptions.AppianScriptException.wrapException(AppianScriptException.java:44)
    at com.appiancorp.core.expr.exceptions.AppianScriptException.convert(AppianScriptException.java:34)
    at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:47)

    Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:427)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction

    Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManage...
  • ...rImpl.java:1214)

    Caused by: java.sql.SQLException: Pool connect failed : java.lang.SecurityException: [Security:090398]Invalid Subject: principals=[pe_guest]
    at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:277)
    at weblogic.jdbc.pool.Driver.connect(Driver.java:153)

    Caused by: java.lang.SecurityException: [Security:090398]Invalid Subject: principals=[pe_guest]
    at weblogic.security.service.SecurityServiceManager.seal(SecurityServiceManager.java:855)
    at weblogic.security.service.IdentityUtility.authenticatedSubjectToIdentity(IdentityUtility.java:30)



  • This might help you:
    The WebLogic security exception "090398" indicates a problem with WebLogic cross domain security. Here is a link to the WebLogic documentation.

    docs.oracle.com/.../domain.htm
  • Thanks Omkar. It's working now after enabling cross domain security and clearing cache.
  • This might help you:
    The WebLogic security exception "090398" indicates a problem with WebLogic cross domain security. Here is a link to the WebLogic documentation.

    docs.oracle.com/.../domain.htm

  • spring:
      config:
        activate:
          on-profile: deployed
      cloud:
        vault:
          uri: "${VAULT_ADDR}"
          fail-fast: true
          authentication: approle
          app-role:
            role-id: "${VAULT_ROLE_ID}"
            secret-id: "${VAULT_SECRET_ID}"
          kv:
            backend: "secret/${spring.application.product}"
      datasource:
        url: "{{ db_formulary_url }}"
        hikari:
          max-lifetime: '{{ db_oracle_max_connection_lifetime_millis }}'
          idle-timeout: '{{ db_oracle_idle_timeout_millis }}'
    surescripts:
      formularyhome: '{{ formulary_home }}'
      intAuth:
        authUrl: '{{intauth_jwt_authurl}}'
        tokenIssuer: ${spring.application.name}
        tokenAudience: '{{intauth_jwt_audience}}'
        tokenExpirationSeconds: {{intauth_jwt_exp_seconds}}
        tokenVersion:
          current: '{{intauth_jwt_version_current}}'
          previous: '{{intauth_jwt_version_prev}}'
      distributedLock:
        token: '{{consul_acl_lock_token}}'
      metrics:
        enabled: true
    formularydownload:
      participant-cache-refresh-schedule: 60m
      pbm-cache-refresh-schedule: 60m