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

Parents Reply Children
  • 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