Google calendar Connector (API v3)

1
0
-1

Hi,

I'm trying the google calendar connector (API v3) for getting an event, and I'm following the Bonita documentation ( calendar api v3 ), however I'm having some problems. When I try 'configure client in your domain', the Google admin console doesn't allow me to access. I see a page that says I'm not logged in.

Please, I need some help. Thanks in advance and regards.

EDIT: I've tried to create a new event, testing the conector, but I get the following error: java.lang.reflect.InvocationTargetException at org.bonitasoft.studio.connectors.operation.TestConnectorOperation.run(TestConnectorOperation.java:183) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122) Caused by: org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.NullPointerException Maybe caused by the admin console problem? Can anyone tell me the steps to follor for getting this conector works?

EDIT_2: Well, Here I go again... I attach some images with the cofiguration I'm testing the connector. I attach the first and secon windows cause the rest have te default values and there are not required fields. Here are the images: http://s1.postimg.org/xdslifp7z/connector_1.png

http://s1.postimg.org/n504cm167/connector_2.png

I dont' understand what's the point of Google Apps. It seems it is required for configuring the Google calendar conector, but It seems too, that It has only paid versions. Does this means, there is no way to use the calendar conector in Bonita without paying anything? I have used a calendar connector in another BPM, creating a Client ID on the Google Developers Console selecting Web application as the application type, and I didn't need any aditional configuration in the Google Admin Console of Google Apps, to make it works. Besides, I have no domain to register on it (that's not required for web application type) and It seems that Google offers a 30-day free trial, but I cannot access to it.

Please, How can I use this connector? (If it can be used).

Comments

Submitted by thomas.allweyer on Fri, 06/12/2015 - 10:12

I've got the same problem. Judging from the fields in the connector wizard it should be possible to use the connector without a paid domain-registration for Google apps. Registering a domain is the only part of the connector's documentation I have left out.

It would be useful to get some information whether and how you can use the connector without a paid google app subscription.

Submitted by Sean McP on Fri, 06/12/2015 - 11:42

I think that would be a question for Google,

Ask on the Google Forums as subscribing to Google is not really related to BonitaSoft.

regards

Submitted by thomas.allweyer on Fri, 06/12/2015 - 17:12

Well, I have subscribed to Google, and everything seems to be fine. It would be useful to hear from the connector's developers whether it is intended to work with the standard Google calendar with a standard Google account.

Submitted by javiermmm.fujitsu on Mon, 06/15/2015 - 09:56

I agree with you, thomas. And could you please, put the link to the post on Google Forums?

Thanks and regards.

Submitted by thomas.allweyer on Mon, 06/15/2015 - 10:08

I haven't posted to Google Forum. I just meant that everything with my Google subscription and the calendar app looks fine. So I think there is no point in posting to Google Forum "I have configured the Google calendar API, and everything looks fine, but I can't connect to it with the Bonita connector." They would most certainly answer "There must be some problem with the Bonita connector".

2 answers

1
0
-1

1
0
-1

Si buenas, pregunto su merced pudo resolver su problema de calendar yo me encuentro en la misma situacion ..

gracias por la ayuda.

Comments

Submitted by javiermmm.fujitsu on Thu, 06/18/2015 - 09:43

Hi unab99,

...And nope. I have not solved it. I still need some help for making this connector work. Any idea?

Submitted by bos2013 on Thu, 06/18/2015 - 23:27

Hello,

Have you configured and generated a p12 file you added to your connector ? Are you a standard gmail/calendar account (free) or a companygmail/calendar account (paid) ?

Using the V3 Google API needs a company Google account calendar where you'll generate the p12 and associated connexion developpers account.

On following webinar at minute 27:00 you have Google calendar V3 API using inside the V3 Gcalendar connector. http://www.bonitasoft.com/for-you-to-read/videos/power-bpm-your-business...

It works really fine. Just need to check that your account developpers is right and appropriate to access suche GCalendar APIs.

Regards, LL

Submitted by unab99 on Thu, 06/18/2015 - 23:42

hi bos2013, i go to the link but y dont see anything about de configuration , you can show your configuration , i really appreciate that help thx.

Submitted by javiermmm.fujitsu on Fri, 06/19/2015 - 08:23

Have you configured and generated a p12 file you added to your connector ?

Yes. I have followed the bonita documentation of this point.

Are you a standard gmail/calendar account (free) or a companygmail/calendar account (paid) ?

Standard. I'm using a common gmail account.

Using the V3 Google API needs a company Google account calendar

Really? So I am NOT ABLE to use the calendar connector inside Bonita without a paid Google account? Are you sure? Is that Official? I would thank some comments from Bonita team, on this subject.

thanks and regards.

Submitted by romain.bioteau on Fri, 06/19/2015 - 08:40

You may found usefull information about what goes wrong in the Studio/Engine log files (Help menu)

Submitted by javiermmm.fujitsu on Tue, 06/23/2015 - 08:40

Well, the studio log has the following:

!ENTRY org.bonitasoft.studio.common 4 0 2015-06-23 08:32:14.679 !MESSAGE !STACK 0 java.lang.reflect.InvocationTargetException at org.bonitasoft.studio.connectors.operation.TestConnectorOperation.run(TestConnectorOperation.java:183) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122) Caused by: org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.NullPointerException at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143) at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88) at com.sun.proxy.$Proxy28.executeConnectorOnProcessDefinition(Unknown Source) at org.bonitasoft.studio.connectors.operation.TestConnectorOperation.run(TestConnectorOperation.java:178) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122) at < ========== Beginning of the server stack trace ========== >. ( ) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinitionWithOrWithoutOperations(ProcessAPIImpl.java:3447) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinition(ProcessAPIImpl.java:3408) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:363) at org.bonitasoft.engine.api.impl.ServerAPIImpl$1.call(ServerAPIImpl.java:332) at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:288) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:339) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:274) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128) at org.bonitasoft.engine.api.internal.servlet.HttpAPIServletCall.doPost(HttpAPIServletCall.java:112) at org.bonitasoft.engine.api.internal.servlet.HttpAPIServlet.doPost(HttpAPIServlet.java:35) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) at Caused by: org.bonitasoft.engine.core.connector.exception.SConnectorException.: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.NullPointerException ( ) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:332) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeMutipleEvaluation(ConnectorServiceImpl.java:296) at org.bonitasoft.engine.connector.ConnectorServiceDecorator.executeMutipleEvaluation(ConnectorServiceDecorator.java:62) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinitionWithOrWithoutOperations(ProcessAPIImpl.java:3439) at ... 35 more. ( ) at Caused by: org.bonitasoft.engine.connector.exception.SConnectorException.: java.util.concurrent.ExecutionException: java.lang.NullPointerException ( ) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:129) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:324) at ... 38 more. ( ) at Caused by: java.util.concurrent.ExecutionException.: java.lang.NullPointerException ( ) at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:188) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.getValue(ConnectorExecutorImpl.java:153) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:123) at ... 39 more. ( ) at Caused by: java.lang.NullPointerException.: null ( ) at sun.util.calendar.ZoneInfoFile.getFileName(ZoneInfoFile.java:501) at sun.util.calendar.ZoneInfoFile.createZoneInfo(ZoneInfoFile.java:596) at sun.util.calendar.ZoneInfoFile.getZoneInfo(ZoneInfoFile.java:566) at sun.util.calendar.ZoneInfo.getTimeZone(ZoneInfo.java:663) at java.util.TimeZone.getTimeZone(TimeZone.java:566) at java.util.TimeZone.getTimeZone(TimeZone.java:562) at org.bonitasoft.connectors.google.calendar.common.BuildEventConnector.buildEventDateTime(BuildEventConnector.java:290) at org.bonitasoft.connectors.google.calendar.common.BuildEventConnector.checkStartDate(BuildEventConnector.java:123) at org.bonitasoft.connectors.google.calendar.CreateEventConnector.checkParameters(CreateEventConnector.java:27) at org.bonitasoft.connectors.google.calendar.common.CalendarConnector.validateInputParameters(CalendarConnector.java:79) at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.validate(SConnectorAdapter.java:61) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:207) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:180) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at ... 1 more. ( ) Root exception: org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.NullPointerException at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143) at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88) at com.sun.proxy.$Proxy28.executeConnectorOnProcessDefinition(Unknown Source) at org.bonitasoft.studio.connectors.operation.TestConnectorOperation.run(TestConnectorOperation.java:178) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122) at < ========== Beginning of the server stack trace ========== >. ( ) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinitionWithOrWithoutOperations(ProcessAPIImpl.java:3447) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinition(ProcessAPIImpl.java:3408) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:363) at org.bonitasoft.engine.api.impl.ServerAPIImpl$1.call(ServerAPIImpl.java:332) at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:288) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:339) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:274) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128) at org.bonitasoft.engine.api.internal.servlet.HttpAPIServletCall.doPost(HttpAPIServletCall.java:112) at org.bonitasoft.engine.api.internal.servlet.HttpAPIServlet.doPost(HttpAPIServlet.java:35) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) at Caused by: org.bonitasoft.engine.core.connector.exception.SConnectorException.: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.NullPointerException ( ) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:332) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeMutipleEvaluation(ConnectorServiceImpl.java:296) at org.bonitasoft.engine.connector.ConnectorServiceDecorator.executeMutipleEvaluation(ConnectorServiceDecorator.java:62) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinitionWithOrWithoutOperations(ProcessAPIImpl.java:3439) at ... 35 more. ( ) at Caused by: org.bonitasoft.engine.connector.exception.SConnectorException.: java.util.concurrent.ExecutionException: java.lang.NullPointerException ( ) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:129) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:324) at ... 38 more. ( ) at Caused by: java.util.concurrent.ExecutionException.: java.lang.NullPointerException ( ) at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:188) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.getValue(ConnectorExecutorImpl.java:153) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:123) at ... 39 more. ( ) at Caused by: java.lang.NullPointerException.: null ( ) at sun.util.calendar.ZoneInfoFile.getFileName(ZoneInfoFile.java:501) at sun.util.calendar.ZoneInfoFile.createZoneInfo(ZoneInfoFile.java:596) at sun.util.calendar.ZoneInfoFile.getZoneInfo(ZoneInfoFile.java:566) at sun.util.calendar.ZoneInfo.getTimeZone(ZoneInfo.java:663) at java.util.TimeZone.getTimeZone(TimeZone.java:566) at java.util.TimeZone.getTimeZone(TimeZone.java:562) at org.bonitasoft.connectors.google.calendar.common.BuildEventConnector.buildEventDateTime(BuildEventConnector.java:290) at org.bonitasoft.connectors.google.calendar.common.BuildEventConnector.checkStartDate(BuildEventConnector.java:123) at org.bonitasoft.connectors.google.calendar.CreateEventConnector.checkParameters(CreateEventConnector.java:27) at org.bonitasoft.connectors.google.calendar.common.CalendarConnector.validateInputParameters(CalendarConnector.java:79) at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.validate(SConnectorAdapter.java:61) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:207) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:180) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at ... 1 more. ( )

But I don't understand the error. I only understand that in some point there is a nullpointerException. I've added all the libs available for preventing a lib missing (only to test the connector). I've review the fields in order to find required fields not filled, but there are not.

So why cannot I use this connector? Google Account? I'm getting crazy...

Submitted by romain.bioteau on Tue, 06/23/2015 - 09:02

What jvm are you using (oracle, openJDK...) ? And in which version ? The npe comes from the TimeZone resolution in low layers of java. Can you try to set a timezone in your configuration ?

Submitted by javiermmm.fujitsu on Tue, 06/23/2015 - 09:26

What jvm are you using (oracle, openJDK...) ? And in which version ?

If I understand what are you referring to, I'm using the default in Bonita, jdk1-7-0_55

Can you try to set a timezone in your configuration ?

Sure. I've tried it. I've put GMT+02:00 for the initial and end date timeZone, and it seems you were right (thank you so much for that), but now, after many seconds waiting a new error is trown (TimeOut):

!ENTRY org.bonitasoft.studio.common 4 0 2015-06-23 09:18:03.352 !MESSAGE !STACK 0 java.lang.reflect.InvocationTargetException at org.bonitasoft.studio.connectors.operation.TestConnectorOperation.run(TestConnectorOperation.java:183) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122) Caused by: org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143) at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88) at com.sun.proxy.$Proxy28.executeConnectorOnProcessDefinition(Unknown Source) at org.bonitasoft.studio.connectors.operation.TestConnectorOperation.run(TestConnectorOperation.java:178) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122) at < ========== Beginning of the server stack trace ========== >. ( ) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinitionWithOrWithoutOperations(ProcessAPIImpl.java:3447) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinition(ProcessAPIImpl.java:3408) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:363) at org.bonitasoft.engine.api.impl.ServerAPIImpl$1.call(ServerAPIImpl.java:332) at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:288) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:339) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:274) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128) at org.bonitasoft.engine.api.internal.servlet.HttpAPIServletCall.doPost(HttpAPIServletCall.java:112) at org.bonitasoft.engine.api.internal.servlet.HttpAPIServlet.doPost(HttpAPIServlet.java:35) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) at Caused by: org.bonitasoft.engine.core.connector.exception.SConnectorException.: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out ( ) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:332) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeMutipleEvaluation(ConnectorServiceImpl.java:296) at org.bonitasoft.engine.connector.ConnectorServiceDecorator.executeMutipleEvaluation(ConnectorServiceDecorator.java:62) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinitionWithOrWithoutOperations(ProcessAPIImpl.java:3439) at ... 35 more. ( ) at Caused by: org.bonitasoft.engine.connector.exception.SConnectorException.: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out ( ) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:129) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:324) at ... 38 more. ( ) at Caused by: java.util.concurrent.ExecutionException.: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out ( ) at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:188) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.getValue(ConnectorExecutorImpl.java:153) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:123) at ... 39 more. ( ) at Caused by: org.bonitasoft.engine.connector.exception.SConnectorException.: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out ( ) at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:72) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:209) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:180) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at ... 1 more. ( ) at Caused by: org.bonitasoft.engine.connector.ConnectorException.: java.net.SocketTimeoutException: connect timed out ( ) at org.bonitasoft.connectors.google.calendar.common.CalendarConnector.executeBusinessLogic(CalendarConnector.java:110) at org.bonitasoft.engine.connector.AbstractConnector.execute(AbstractConnector.java:77) at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:70) at ... 6 more. ( ) at Caused by: java.net.SocketTimeoutException.: connect timed out ( ) at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:618) at sun.net.NetworkClient.doConnect(NetworkClient.java:175) at sun.net.www.http.HttpClient.openServer(HttpClient.java:432) at sun.net.www.http.HttpClient.openServer(HttpClient.java:527) at sun.net.www.protocol.https.HttpsClient.(HttpsClient.java:275) at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:371) at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:932) at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177) at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1091) at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(HttpsURLConnectionImpl.java:250) at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:77) at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:965) at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:283) at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307) at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:268) at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489) at com.google.api.client.auth.oauth2.Credential.intercept(Credential.java:217) at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:859) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:410) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:343) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:460) at org.bonitasoft.connectors.google.calendar.CreateEventConnector.doJobWithCalendarEvents(CreateEventConnector.java:46) at org.bonitasoft.connectors.google.calendar.common.CalendarConnector.executeBusinessLogic(CalendarConnector.java:105) at ... 8 more. ( ) Root exception: org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143) at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88) at com.sun.proxy.$Proxy28.executeConnectorOnProcessDefinition(Unknown Source) at org.bonitasoft.studio.connectors.operation.TestConnectorOperation.run(TestConnectorOperation.java:178) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122) at < ========== Beginning of the server stack trace ========== >. ( ) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinitionWithOrWithoutOperations(ProcessAPIImpl.java:3447) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinition(ProcessAPIImpl.java:3408) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:363) at org.bonitasoft.engine.api.impl.ServerAPIImpl$1.call(ServerAPIImpl.java:332) at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:288) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:339) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:274) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128) at org.bonitasoft.engine.api.internal.servlet.HttpAPIServletCall.doPost(HttpAPIServletCall.java:112) at org.bonitasoft.engine.api.internal.servlet.HttpAPIServlet.doPost(HttpAPIServlet.java:35) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) at Caused by: org.bonitasoft.engine.core.connector.exception.SConnectorException.: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out ( ) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:332) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeMutipleEvaluation(ConnectorServiceImpl.java:296) at org.bonitasoft.engine.connector.ConnectorServiceDecorator.executeMutipleEvaluation(ConnectorServiceDecorator.java:62) at org.bonitasoft.engine.api.impl.ProcessAPIImpl.executeConnectorOnProcessDefinitionWithOrWithoutOperations(ProcessAPIImpl.java:3439) at ... 35 more. ( ) at Caused by: org.bonitasoft.engine.connector.exception.SConnectorException.: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out ( ) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:129) at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:324) at ... 38 more. ( ) at Caused by: java.util.concurrent.ExecutionException.: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out ( ) at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:188) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.getValue(ConnectorExecutorImpl.java:153) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:123) at ... 39 more. ( ) at Caused by: org.bonitasoft.engine.connector.exception.SConnectorException.: org.bonitasoft.engine.connector.ConnectorException: java.net.SocketTimeoutException: connect timed out ( ) at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:72) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:209) at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:180) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at ... 1 more. ( ) at Caused by: org.bonitasoft.engine.connector.ConnectorException.: java.net.SocketTimeoutException: connect timed out ( ) at org.bonitasoft.connectors.google.calendar.common.CalendarConnector.executeBusinessLogic(CalendarConnector.java:110) at org.bonitasoft.engine.connector.AbstractConnector.execute(AbstractConnector.java:77) at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:70) at ... 6 more. ( ) at Caused by: java.net.SocketTimeoutException.: connect timed out ( ) at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:618) at sun.net.NetworkClient.doConnect(NetworkClient.java:175) at sun.net.www.http.HttpClient.openServer(HttpClient.java:432) at sun.net.www.http.HttpClient.openServer(HttpClient.java:527) at sun.net.www.protocol.https.HttpsClient.(HttpsClient.java:275) at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:371) at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:932) at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177) at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1091) at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(HttpsURLConnectionImpl.java:250) at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:77) at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:965) at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:283) at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307) at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:268) at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489) at com.google.api.client.auth.oauth2.Credential.intercept(Credential.java:217) at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:859) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:410) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:343) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:460) at org.bonitasoft.connectors.google.calendar.CreateEventConnector.doJobWithCalendarEvents(CreateEventConnector.java:46) at org.bonitasoft.connectors.google.calendar.common.CalendarConnector.executeBusinessLogic(CalendarConnector.java:105) at ... 8 more. ( )

So now, I think, It's something wrong with the connection to Google. I'm having many problems, trying to connect with the Google services: http://community.bonitasoft.com//answers/google-spreadsheet-connector#co...

http://community.bonitasoft.com//answers/google-maps#comment-39396

I need some help, please. What's happening?

Submitted by romain.bioteau on Tue, 06/23/2015 - 09:50

Are you behind a proxy ? I found those kind of whitelist

You may ask your IT if they allow those access.

Notifications