Getting error: Could not open JPA EntityManager for transaction

tushark171 over 7 years ago

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...

Connectionerror.txt

Discussion posts and replies are publicly visible

0 tushark171 over 7 years ago

...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...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tushark171 over 7 years ago

...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)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Omkar K over 7 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tushark171 over 7 years ago

Thanks Omkar. It's working now after enabling cross domain security and clearing cache.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel