My Oracle Support Banner

Emails are not being sent to assignees, 'exception.code:31037' (Doc ID 2135834.1)

Last updated on APRIL 11, 2021

Applies to:

Oracle Business Process Management Suite - Version 12.1.3.0.0 and later
Identity Manager - Version 12.2.1.4.0 to 12.2.1.4.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

Emails are not being sent to assignees and the log contains the following exception:

[2016-05-03T16:31:02.224-06:00] [soa_server1] [ERROR] [] [oracle.soa.services.workflow.common] [tid: [ACTIVE].ExecuteThread: '59' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: <ecid>] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] exception.code:31037[[
exception.type: INFO
exception.severity: 4
exception.name: Retrieved notification html content is not well formed.
exception.description: For actionable email the retrieved HTML content does not seem well formed. So Task details will not be populated in notification email.
exception.fix: Check the underlying exception and correct the error. If the error persists, contact Oracle Support Services.
 ORABPEL-31037

exception.code:31037
exception.type: INFO
exception.severity: 4
exception.name: Retrieved notification html content is not well formed.
exception.description: For actionable email the retrieved HTML content does not seem well formed. So Task details will not be populated in notification email.
exception.fix: Check the underlying exception and correct the error. If the error persists, contact Oracle Support Services.

at oracle.bpel.services.workflow.task.notification.TaskNotifications.getEmailPayload(TaskNotifications.java:1697)
at oracle.bpel.services.workflow.task.notification.TaskNotifications.getEmailNotificationContent(TaskNotifications.java:1293)
at oracle.bpel.services.workflow.task.notification.TaskNotifications.sendEmailNotification(TaskNotifications.java:1248)
at oracle.bpel.services.workflow.task.notification.TaskNotifications.sendPreferredNotification(TaskNotifications.java:2674)
at oracle.bpel.services.workflow.task.notification.TaskNotifications.sendNotificationToUser(TaskNotifications.java:2577)
at oracle.bpel.services.workflow.task.notification.TaskNotifications.sendTaskNotification(TaskNotifications.java:2295)
at oracle.bpel.services.workflow.task.notification.TaskNotifications.notifyForTaskInternal(TaskNotifications.java:822)
at oracle.bpel.services.workflow.task.notification.TaskNotifications.notifyForTask(TaskNotifications.java:612)
at oracle.bpel.services.workflow.task.notification.MDBTaskNotificationConsumer.deliverNotification(MDBTaskNotificationConsumer.java:362)
at oracle.bpel.services.workflow.task.notification.MDBTaskNotificationConsumer.onMessage(MDBTaskNotificationConsumer.java:230)
at sun.reflect.GeneratedMethodAccessor1659.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:131)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAs(JpsSubject.java:208)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:643)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:118)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:197)
at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:112)
at sun.reflect.GeneratedMethodAccessor956.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:94)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
at com.sun.proxy.$Proxy551.onMessage(Unknown Source)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:439)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:362)
at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:297)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:5115)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:4786)
at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:4174)
at weblogic.jms.client.JMSSession.access$000(JMSSession.java:130)
at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5635)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:643)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:617)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:397)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused by: ORABPEL-31037

exception.code:31037
exception.type: INFO
exception.severity: 4
exception.name: Retrieved notification html content is not well formed.
exception.description: For actionable email the retrieved HTML content does not seem well formed. So Task details will not be populated in notification email.
exception.fix: Check the underlying exception and correct the error. If the error persists, contact Oracle Support Services.

at oracle.bpel.services.workflow.task.notification.html.HTMLTagReader.initialize(HTMLTagReader.java:192)
at oracle.bpel.services.workflow.task.notification.html.GenericHTMLContentParser.parse(GenericHTMLContentParser.java:384)
at oracle.bpel.services.workflow.task.notification.TaskNotifications.parseHtmlContentForImages(TaskNotifications.java:1854)
at oracle.bpel.services.workflow.task.notification.TaskNotifications.getEmailPayload(TaskNotifications.java:1622)
... 49 more

 

#### <soa_server1> <[ACTIVE] ExecuteThread: '27' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <[severity-value: 8] [rid: <rid>] [partition-id: 0] [partition-name: DOMAIN] > Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_UMS.DEVICE_ADDRESS_ADDRS_DELIV_UQ) violated

Error Code: 1
Call: UPDATE DEVICE_ADDRESS SET ADDRESS = ?, version = ? WHERE ((id = ?) AND (version = ?))
bind => [4 parameters bound]
Query: UpdateObjectQuery(oracle.ucsinternal.userprefs.persistence.DeviceAddressImpl@c54c97aa)],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=2,seconds left=60,useSecure=false,XAServerResourceInfo[WLStore_soa_domain_SOAJMSFileStore]=(ServerResourceInfo[WLStore_soa_domain_SOAJMSFileStore]=(state=rolledback,assigned=soa_server1),xar=WLStore_soa_domain_SOAJMSFileStore175825380,re-Registered = false),XAServerResourceInfo[SOADataSource_soa_domain]=(ServerResourceInfo[SOADataSource_soa_domain]=(state=rolledback,assigned=soa_server1),xar=SOADataSource,re-Registered = false),XAServerResourceInfo[OraSDPMDataSource_soa_domain]=(ServerResourceInfo[OraSDPMDataSource_soa_domain]=(state=rolledback,assigned=soa_server1),xar=OraSDPMDataSource,re-Registered = false),SCInfo[soa_domain+soa_server1]=(state=rolledback),properties=({weblogic.transaction.partitionName=DOMAIN, weblogic.transaction.name=[EJB oracle.bpel.services.workflow.task.notification.MDBTaskNotificationConsumer.onMessage(javax.jms.Message)]}),local properties=({weblogic.jdbc.jta.SOADataSource=[ No XAConnection is attached to this TxInfo ], weblogic.jdbc.jta.OraSDPMDataSource=[ No XAConnection is attached to this TxInfo ]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=soa_server1+<IP ADD>+soa_domain+t3+ CoordinatorNonSecureURL=soa_server1+<IP ADD>+soa_domain+t3+ coordinatorSecureURL=null, XAResources={eis/File/XAFileAdapter2, eis/XAFileAdapter3, eis/tibjms/Queue, eis/activemq/Queue, WLStore_soa_domain_UMSJMSFileStore_auto_2, eis/aq/aiaB2BInfraAQCF, eis/wls/EDNxaDurableTopic, eis/wls/EDNLocalTxTopic, eis/jbossmq/Queue, eis/wls/EDNLocalTxDurableTopic, eis/jms/aiaB2BQueueCF, eis/oracle/in-memory, SOADataSource_soa_domain, eis/webspheremq/Queue, eis/AQ/aqSample, eis/tibjms/Topic, eis/tibjmsDirect/Queue, eis/aqjms/Queue, eis/Apps/Apps, WLStore_soa_domain__WLS_soa_server1, WLStore_soa_domain_SOAJMSFileStore, eis/pramati/Queue, tangosol.coherenceTx, eis/aqjms/EDNLocalTxDurableTopic, OraSDPMDataSource_soa_domain, eis/wls/Queue, eis/XAFileAdapter, WLStore_soa_domain_BPMJMSFileStore, awardsDS_soa_domain, eis/jms/aiaErrorTopicCF, tangosol.coherenceTxCCI, eis/aqjms/EDNxaTopic, eis/tibjmsDirect/Topic, WSATGatewayRM_soa_server1_soa_domain, eis/wls/Topic, eis/aqjms/EDNLocalTxTopic, eis/File/XAFileAdapter, eis/sunmq/Queue, eis/aqjms/Topic, EDNDataSource_soa_domain, eis/wls/EDNxaTopic, soacomDS_soa_domain, eis/aqjms/EDNxaDurableTopic, eis/fioranomq/Topic},NonXAResources={})],CoordinatorURL=soa_server1+<IP ADD>+soa_domain+t3+): weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@462ee06e
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.1.v20150916-55dc7c3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_UMS.DEVICE_ADDRESS_ADDRS_DELIV_UQ) violated

Error Code: 1
Call: UPDATE DEVICE_ADDRESS SET ADDRESS = ?, version = ? WHERE ((id = ?) AND (version = ?))
bind => [4 parameters bound]
Query: UpdateObjectQuery(oracle.ucsinternal.userprefs.persistence.DeviceAddressImpl@c54c97aa)

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.