I could find the problem in the process. The response of the service task is saved in the process variable “Table”. After that, the engine would like write this variable in the history. But the “Table” variable contains the whole response of the soap call and this is to much for the defined database column.
The solution is to change the output parameter of the service task. For that, I renamed the output parameter from “Table” to “City”, changed the type to “Script” and call the external script “parseTemperature.js”.
It is necessary to change a bit the “parseTemperature.js”. It contains now the following code.
var table = S(response)
print('TABLE:' + table);
With these changes, you can set the “City” process variable directly from the script to the output parameter of the connector.
At least, delete the output parameter which is configured in the “Input/Output” tab.
To be sure, you can understand what I mean, look into the process file.
invokeSoapService_1.bpmn (8.9 KB)