500 - Internal Server Error on Connector

Q&A
1

I had a working connector to send select data from Bonita to an external database. Recently after restarting the server the connector has failed. (Other similar connectors are still working). 

I worked with the consultant who built the external part of the connector and he says that all is working correctly on his side and is adamant that the issue lies in Bonita or RAM. 
The machine's RAM is consistently < 60% so I doubt that this is the issue, but will increase RAM if required. 

 

The error on the Bonita side is as follows: 
 

2022-04-26 01:51:26.445 +0000 SEVERE: org.bonitasoft.engine.execution.work.InSessionBonitaWork THREAD_ID=170 | HOSTNAME=bonita-XXXXX | TENANT_ID=1 | The work [ExecuteConnectorOfActivity: flowNodeInstanceId = 347388, connectorDefinitionName = sendOrder] failed. The failure will be handled.
2022-04-26 01:51:26.461 +0000 SEVERE: org.bonitasoft.engine.execution.work.InSessionBonitaWork THREAD_ID=170 | HOSTNAME=bonita-XXXXX  TENANT_ID=1 | org.bonitasoft.engine.commons.exceptions.SBonitaRuntimeException : "org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: org.bonitasoft.engine.connector.ConnectorException: [POST] http://127.0.0.1/send-order response status is not successful: 500 - Internal Server Error"
org.bonitasoft.engine.commons.exceptions.SBonitaRuntimeException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: org.bonitasoft.engine.connector.ConnectorException: [POST] http://127.0.0.1/send-order response status is not successful: 500 - Internal Server Error
        at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.lambda$execute$0(ConnectorExecutorImpl.java:155)
        at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: org.bonitasoft.engine.connector.ConnectorException: [POST] http://127.0.0.1/send-order response status is not successful: 500 - Internal Server Error
        at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:75)
        at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:253)
        at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:212)
        at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.lambda$wrapForStats$1(ConnectorExecutorImpl.java:164)
        at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.lambda$execute$0(ConnectorExecutorImpl.java:152)
        ... 4 more
Caused by: org.bonitasoft.engine.connector.ConnectorException: org.bonitasoft.engine.connector.ConnectorException: [POST] http://127.0.0.1/send-order response status is not successful: 500 - Internal Server Error

 

Any help is greatly appreciated. 

2

Hello
Ping the remote / External server. Perform Traceroute or Telnet the ports.

regards

3

Both successful, no timeouts or error messages

4

Hello
Just a quick question. From the Error posted above , 127.0.0.1 is same as localhost . Any chance configuration / IP of server got changed.

http://127.0.0.1/send-order

regards

5

Have tried address with both localhost and 127.0.0.1 (neither successful). The IP of the server didn't change at any time. 

6

Maybe I am thinking wrong - Please do correct me.


if the request is originating inside Bonita and making a POST call to external system, then it should be the IP of the external system. not localhost or 127.0.01 
 

7

The POST call is to the same server of Bonita.