E-mail connector failure in Bonita 6.4.0.

1
0
-1

**Hello,

I'm trying to make a process where that after rejection of the request Initiator of the process receives e-mail information about the result. I am using Bonita Community 6.4.0. I defined:

SMTP Host: smtp.gmail.com SMTP Port: 465 Security: SSL

Username: my.mail@gmail.com Password: *****

From: my.mail@gmail.com To: return BonitaUsers.getUserProfessionalContactInfo(apiAccessor, BonitaUsers.getProcessInstanceInitiator(apiAccessor, processInstanceId).getId()).getEmail();

Subject: Request Denied Message: String message = "Dear " +name+ ",

"; message += " Your request wasn't approved because:

" +manager_s_comment+ "

" +supervisor_name; return message;

But, I am not getting email and this is what logs say: ** 2015-01-08 14:12:05 org.bonitasoft.engine.api.impl.transaction.process.DisableProcess INFO: THREAD_ID=55 | HOSTNAME=Ira | TENANT_ID=1 | The user has disabled process in version <1.0> with id <7303628374798138081> 2015-01-08 14:12:06 org.bonitasoft.engine.api.impl.ProcessManagementAPIImplDelegate INFO: THREAD_ID=55 | HOSTNAME=Ira | TENANT_ID=1 | The user has deleted process with id = <7303628374798138081> 2015-01-08 14:12:08 org.bonitasoft.engine.api.impl.ProcessAPIImpl INFO: THREAD_ID=55 | HOSTNAME=Ira | TENANT_ID=1 | The user has installed process in version <1.0> with id <7487801938897213482> 2015-01-08 14:12:08 org.bonitasoft.engine.api.impl.transaction.process.EnableProcess INFO: THREAD_ID=55 | HOSTNAME=Ira | TENANT_ID=1 | The user has enabled process in version <1.0> with id <7487801938897213482> 2015-01-08 14:12:12 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[jsp] FINE: Disabling the response for futher output 2015-01-08 14:12:12 org.bonitasoft.engine.api.impl.ProcessStarter INFO: THREAD_ID=49 | HOSTNAME=Ira | TENANT_ID=1 | The user has started the process instance <5> of process in version <1.0> and id <7487801938897213482> 2015-01-08 14:12:19 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[jsp] FINE: Disabling the response for futher output 2015-01-08 14:12:41 org.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTask INFO: THREAD_ID=58 | HOSTNAME=Ira | TENANT_ID=1 | The user has executed the task [name = , display name = , id = <59>, parent process instance = <5>, root process instance = <5>, process definition = <7487801938897213482>] 2015-01-08 14:13:02 org.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTask INFO: THREAD_ID=53 | HOSTNAME=Ira | TENANT_ID=1 | The user has executed the task [name = , display name = , id = <60>, parent process instance = <5>, root process instance = <5>, process definition = <7487801938897213482>] 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: charset UTF-8 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: message Dear Sergej,

Your request wasn't approved because:



Robert 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: html true 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: subject Manager Rejected Your Request 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: bcc null 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: cc null 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: to lanedi.edward@gmail.com 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: from lanedi.edward@gmail.com 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: userName lanedi.edward@gmail.com 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: starttlsSupport false 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: sslSupport true 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: smtpPort 465 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: smtpHost smtp.gmail.com 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: replyTo null 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: password ****** 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: Headers null 2015-01-08 14:13:02 org.bonitasoft.connectors.email.EmailConnector INFO: headers [] 2015-01-08 14:13:03 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork SEVERE: THREAD_ID=336 | HOSTNAME=Ira | TENANT_ID=1 | The work [ExecuteConnectorOfActivity: flowNodeInstanceId = 62, connectorDefinitionName = Manager rejection] failed. The failure will be handled. 2015-01-08 14:13:03 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork SEVERE: THREAD_ID=336 | HOSTNAME=Ira | TENANT_ID=1 | org.bonitasoft.engine.core.connector.exception.SConnectorException : "PROCESS_DEFINITION_ID=7487801938897213482 | PROCESS_NAME=Business Trip Request | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=5 | ROOT_PROCESS_INSTANCE_ID=5 | FLOW_NODE_DEFINITION_ID=-7530274760241085096 | FLOW_NODE_INSTANCE_ID=62 | FLOW_NODE_NAME=Trip Rejected by Manager | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=Manager rejection | CONNECTOR_INSTANCE_ID=2 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 465; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target" 2015-01-08 14:13:03 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork FINE: THREAD_ID=336 | HOSTNAME=Ira | TENANT_ID=1 | Exception : org.bonitasoft.engine.core.connector.exception.SConnectorException: PROCESS_DEFINITION_ID=7487801938897213482 | PROCESS_NAME=Business Trip Request | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=5 | ROOT_PROCESS_INSTANCE_ID=5 | FLOW_NODE_DEFINITION_ID=-7530274760241085096 | FLOW_NODE_INSTANCE_ID=62 | FLOW_NODE_NAME=Trip Rejected by Manager | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=Manager rejection | CONNECTOR_INSTANCE_ID=2 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 465; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:332) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnector(ConnectorServiceImpl.java:150) at org.bonitasoft.engine.connector.ConnectorServiceDecorator.executeConnector(ConnectorServiceDecorator.java:111) at org.bonitasoft.engine.execution.work.ExecuteConnectorWork.work(ExecuteConnectorWork.java:125) at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42) at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42) at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42) at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42) at org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork.work(FailureHandlingBonitaWork.java:70) at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:56) at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:47) at org.bonitasoft.engine.work.BonitaRunnable.run(BonitaRunnable.java:35) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 465; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:119) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:324) ... 14 more Caused by: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 465; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at java.util.concurrent.FutureTask.report(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.getValue(ConnectorExecutorImpl.java:143) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:113) ... 15 more Caused by: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 465; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:72) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:188) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:170) at java.util.concurrent.FutureTask.run(Unknown Source) ... 3 more Caused by: org.bonitasoft.engine.connector.ConnectorException: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 465; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at org.bonitasoft.connectors.email.EmailConnector.executeBusinessLogic(EmailConnector.java:473) at org.bonitasoft.engine.connector.AbstractConnector.execute(AbstractConnector.java:74) at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:70) ... 6 more Caused by: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 465; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1972) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:642) at javax.mail.Service.connect(Service.java:317) at javax.mail.Service.connect(Service.java:176) at javax.mail.Service.connect(Service.java:125) at javax.mail.Transport.send0(Transport.java:194) at javax.mail.Transport.send(Transport.java:124) at org.bonitasoft.connectors.email.EmailConnector.executeBusinessLogic(EmailConnector.java:471) ... 8 more Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.ssl.Alerts.getSSLException(Unknown Source) at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source) at sun.security.ssl.Handshaker.fatalSE(Unknown Source) at sun.security.ssl.Handshaker.fatalSE(Unknown Source) at sun.security.ssl.ClientHandshaker.serverCertificate(Unknown Source) at sun.security.ssl.ClientHandshaker.processMessage(Unknown Source) at sun.security.ssl.Handshaker.processLoop(Unknown Source) at sun.security.ssl.Handshaker.process_record(Unknown Source) at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source) at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source) at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source) at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source) at com.sun.mail.util.SocketFetcher.configureSSLSocket(SocketFetcher.java:548) at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:352) at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:207) at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1938) ... 15 more Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.validator.PKIXValidator.doBuild(Unknown Source) at sun.security.validator.PKIXValidator.engineValidate(Unknown Source) at sun.security.validator.Validator.validate(Unknown Source) at sun.security.ssl.X509TrustManagerImpl.validate(Unknown Source) at sun.security.ssl.X509TrustManagerImpl.checkTrusted(Unknown Source) at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source) ... 27 more Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.provider.certpath.SunCertPathBuilder.build(Unknown Source) at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source) at java.security.cert.CertPathBuilder.build(Unknown Source) ... 33 more

**Can someone explain me what is error and how to fix it? Step by step, please, how to get that certification or whatever i need? **

Comments

Submitted by sylvain.bailly on Thu, 01/08/2015 - 17:38

For the body of the message, do it simple to begin. Let it empty (work step by step). It is just an advice.

Submitted by marcy.ira on Fri, 01/09/2015 - 08:46

Tried, but it didn't help :(

2 answers

1
+4
-1

Please see your other post, the problem is SSL certification, as noted.

regards Seán

Comments

Submitted by marcy.ira on Mon, 01/12/2015 - 16:25

Thank you. Now it is working.

Submitted by Sean McP on Tue, 01/13/2015 - 13:04

Glad to be of help

best regards Seán

1
0
-1
Notifications