topic Re: Urgent - Error deploying .BAR file, why? in Alfresco Archive

Urgent - Error deploying .BAR file, why?

sergiofigueras_ — Sat, 02 Feb 2013 21:06:41 GMT

Hi everyone, When I deploy my .BAR file in activiti-explorer, everything goes fine. But when I try to deploy on my application, I'm getting this error:Feb 2, 2013 5:59:51 PM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deployINFO: Processing resource AprovacaoCredito.bpmn20.xmlFeb 2, 2013 5:5

Re: Urgent - Error deploying .BAR file, why?

frederikherema1 — Mon, 04 Feb 2013 09:10:55 GMT


at org.apache.xerces.impl.XMLEntityManager.expandSystemId(XMLEntityManager.java:1140)
   at org.apache.xerces.impl.XMLEntityManager.resolveEntity(XMLEntityManager.java:581)
   at org.apache.xerces.impl.xs.XMLSchemaLoader.xsdToXMLInputSource(XMLSchemaLoader.java:625)
   at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:580)
   at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
   at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
   at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
   at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)

Stackoverflow in xerces, What does your BPMN-file look like?

Re: Urgent - Error deploying .BAR file, why?

sergiofigueras_ — Mon, 04 Feb 2013 18:52:57 GMT

Thanks,

That's my process file.

<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:activiti="http://activiti.org/bpmn" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:smileysurprised:mgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:smileysurprised:mgdi="http://www.omg.org/spec/DD/20100524/DI" typeLanguage="http://www.w3.org/2001/XMLSchema" expressionLanguage="http://www.w3.org/1999/XPath" targetNamespace="http://www.ye.com/bpmn">
  <process id="aprovacaoCredito" name="Revisar e aprovar Documentação para Carta de Crédito" isExecutable="true" activiti:candidateStarterGroups="Agente de Crédito,Agente Administrativo">
    <documentation>Fluxo para análise de documentação de carta de crédito, tal como análise do contrato.</documentation>
    <startEvent id="startevent1" name="Start">
      <extensionElements>
        <activiti:formProperty id="nomeCliente" name="Nome do Cliente" type="string" variable="nomeCliente" required="true"></activiti:formProperty>
        <activiti:formProperty id="valorSolicitado" name="Valor Solicitado" type="string" variable="valorSolicitado" required="true"></activiti:formProperty>
        <activiti:formProperty id="numeroParcelas" name="Numero de Parcelas" type="string" variable="numeroParcelas" required="true"></activiti:formProperty>
        <activiti:formProperty id="phoneNumber" name="Telefone Cliente" type="string" variable="telefoneCliente" required="true"></activiti:formProperty>
        <activiti:formProperty id="identidadeCliente" name="Documento com Foto" type="string" variable="identidadeCliente" required="true"></activiti:formProperty>
        <activiti:formProperty id="comprovanteEnderecoCliente" name="Comprovante de Endereço" type="string" variable="comprovanteEnderecoCliente" required="true"></activiti:formProperty>
        <activiti:formProperty id="comprovanteConsultaSpcSerasaCliente" name="Comprovante de Consulta SPC/Serasa" type="string" variable="comprovanteConsultaSpcSerasaCliente" required="true"></activiti:formProperty>
        <activiti:formProperty id="contrachequeCliente" name="Contracheque" type="string" variable="contrachequeCliente" required="true"></activiti:formProperty>
        <activiti:formProperty id="contratoEmprestimo" name="Contrato de Empréstimo" type="string" variable="contratoEmprestimo" required="true"></activiti:formProperty>
        <activiti:formProperty id="contratoCliente" name="Contrato de Empréstimo" type="yeAttachment" required="true"></activiti:formProperty>
      </extensionElements>
    </startEvent>
    <userTask id="reviewDocuments" name="Revisar Documentação" activiti:candidateGroups="Gerência">
      <extensionElements>
        <activiti:formProperty id="aprovarCredito" name="Deseja aprovar ou rejeitar a solicitação de Empréstimo?" type="boolean" variable="aprovarCredito" required="true">
          <activiti:value id="aprovarEmprestimo" name="Aprovar"></activiti:value>
          <activiti:value id="negarEmprestimo" name="Rejeitar"></activiti:value>
        </activiti:formProperty>
        <activiti:formProperty id="aprovacaoObservacao" name="Observação" type="string"></activiti:formProperty>
      </extensionElements>
    </userTask>
    <sequenceFlow id="flow1" sourceRef="startevent1" targetRef="reviewDocuments"></sequenceFlow>
    <serviceTask id="smsTask" name="Enviar SMS notificando Aprovação" activiti:class="com.ye.ye.bpm.tasks.SmsTask" activiti:resultVariableName="Sua solicitacao de crédito foi aprovada."></serviceTask>
    <serviceTask id="emailTask" name="Notifica o Agente de Crédito a rejeição do Empréstimo" activiti:class="com.ye.ye.bpm.tasks.EmailTask"></serviceTask>
    <endEvent id="terminateendevent1" name="TerminateEndEvent">
      <terminateEventDefinition></terminateEventDefinition>
    </endEvent>
    <sequenceFlow id="flow7" sourceRef="smsTask" targetRef="terminateendevent1"></sequenceFlow>
    <sequenceFlow id="flow8" sourceRef="emailTask" targetRef="terminateendevent1"></sequenceFlow>
    <exclusiveGateway id="exclusivegateway1" name="Exclusive Gateway"></exclusiveGateway>
    <sequenceFlow id="flow9" sourceRef="reviewDocuments" targetRef="exclusivegateway1"></sequenceFlow>
    <sequenceFlow id="flow10" sourceRef="exclusivegateway1" targetRef="smsTask">
      <conditionExpression xsi:type="tFormalExpression"><![CDATA[${aprovarCredito == 'true'}]]></conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="flow11" sourceRef="exclusivegateway1" targetRef="emailTask">
      <conditionExpression xsi:type="tFormalExpression"><![CDATA[${aprovarCredito == 'false'}]]></conditionExpression>
    </sequenceFlow>
    <textAnnotation id="textannotation1">
      <text>Para iniciar o Processo, é necessário anexar os seguintes documentos:
- Documento de Identificação com Foto
- Comprovante de Endereço
- Comprovante de consulta SPC/Serasa
- Contracheque
- Contrato assinado</text>
    </textAnnotation>
  </process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_aprovacaoCredito">
    <bpmndi:BPMNPlane bpmnElement="aprovacaoCredito" id="BPMNPlane_aprovacaoCredito">
      <bpmndi:BPMNShape bpmnElement="startevent1" id="BPMNShape_startevent1">
        <omgdc:Bounds height="35.0" width="35.0" x="60.0" y="224.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="reviewDocuments" id="BPMNShape_reviewDocuments">
        <omgdc:Bounds height="55.0" width="105.0" x="180.0" y="214.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="smsTask" id="BPMNShape_smsTask">
        <omgdc:Bounds height="55.0" width="161.0" x="472.0" y="110.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="emailTask" id="BPMNShape_emailTask">
        <omgdc:Bounds height="55.0" width="161.0" x="472.0" y="320.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="textannotation1" id="BPMNShape_textannotation1">
        <omgdc:Bounds height="131.0" width="211.0" x="94.0" y="50.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="terminateendevent1" id="BPMNShape_terminateendevent1">
        <omgdc:Bounds height="35.0" width="35.0" x="770.0" y="224.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="exclusivegateway1" id="BPMNShape_exclusivegateway1">
        <omgdc:Bounds height="40.0" width="40.0" x="370.0" y="221.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNEdge bpmnElement="flow1" id="BPMNEdge_flow1">
        <omgdi:waypoint x="95.0" y="241.0"></omgdi:waypoint>
        <omgdi:waypoint x="180.0" y="241.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="flow7" id="BPMNEdge_flow7">
        <omgdi:waypoint x="633.0" y="137.0"></omgdi:waypoint>
        <omgdi:waypoint x="787.0" y="137.0"></omgdi:waypoint>
        <omgdi:waypoint x="787.0" y="224.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="flow8" id="BPMNEdge_flow8">
        <omgdi:waypoint x="633.0" y="347.0"></omgdi:waypoint>
        <omgdi:waypoint x="787.0" y="347.0"></omgdi:waypoint>
        <omgdi:waypoint x="787.0" y="259.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="flow9" id="BPMNEdge_flow9">
        <omgdi:waypoint x="285.0" y="241.0"></omgdi:waypoint>
        <omgdi:waypoint x="370.0" y="241.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="flow10" id="BPMNEdge_flow10">
        <omgdi:waypoint x="390.0" y="221.0"></omgdi:waypoint>
        <omgdi:waypoint x="390.0" y="137.0"></omgdi:waypoint>
        <omgdi:waypoint x="472.0" y="137.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="flow11" id="BPMNEdge_flow11">
        <omgdi:waypoint x="390.0" y="261.0"></omgdi:waypoint>
        <omgdi:waypoint x="390.0" y="347.0"></omgdi:waypoint>
        <omgdi:waypoint x="472.0" y="347.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</definitions>

Re: Urgent - Error deploying .BAR file, why?

sergiofigueras_ — Mon, 04 Feb 2013 18:54:23 GMT

(i've used one activiti default template to generate it, and then I've changed the properties)

Re: Urgent - Error deploying .BAR file, why?

jbarrez — Tue, 05 Feb 2013 12:28:04 GMT

I imported your process and tried to deploy it.

Following issues were encountered:

Caused by: org.activiti.engine.ActivitiIllegalArgumentException: unknown type 'yeAttachment' contratoCliente

Removed that line, since I don't know what yeAttachment is

org.activiti.engine.ActivitiException: Errors while parsing:
'resultVariableName' not supported for service tasks using 'class' or 'delegateExpression | serviceTask | line 28 | column 187

Removed the resultVariableName.

Then, I can deploy it succesfully.

Re: Urgent - Error deploying .BAR file, why?

sergiofigueras_ — Tue, 05 Feb 2013 15:51:59 GMT

Hi jbarrez,

Thanks for your reply. I've removed the same lines, but the problem is still ocurring… Any process that I try to deploy causes this error. Any idea?

Caused by: com.vaadin.event.ListenerMethod$MethodException
Cause: java.lang.StackOverflowError
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:532)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:164)
at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1219)
at com.vaadin.ui.Upload.fireUploadSuccess(Upload.java:744)
at com.vaadin.ui.Upload$1.streamingFinished(Upload.java:1022)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.streamToReceiver(AbstractCommunicationManager.java:603)
… 16 more
Caused by: java.lang.StackOverflowError
at org.apache.xerces.util.URI.isConformantSchemeName(URI.java:1213)
at org.apache.xerces.util.URI.setScheme(URI.java:904)
at org.apache.xerces.util.URI.initializeScheme(URI.java:576)
at org.apache.xerces.util.URI.initialize(URI.java:400)
at org.apache.xerces.util.URI.<init>(URI.java:211)
at org.apache.xerces.util.URI.<init>(URI.java:195)
at org.apache.xerces.impl.XMLEntityManager.expandSystemId(XMLEntityManager.java:1140)
at org.apache.xerces.impl.XMLEntityManager.resolveEntity(XMLEntityManager.java:581)
at org.apache.xerces.impl.xs.XMLSchemaLoader.xsdToXMLInputSource(XMLSchemaLoader.java:625)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:580)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)
at org.apache.xerces.impl.xs.XMLSchemaLoader.loadSchema(XMLSchemaLoader.java:489)
at org.apache.xerces.impl.xs.XMLSchemaLoader.processJAXPSchemaSource(XMLSchemaLoader.java:588)

Re: Urgent - Error deploying .BAR file, why?

sergiofigueras_ — Tue, 05 Feb 2013 17:49:18 GMT

The same error is ocurring if I try to deploy activiti-engine-examples.bar .

EVERE: Terminal error:
com.vaadin.event.ListenerMethod$MethodException
Cause: java.lang.StackOverflowError
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:532)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:164)
at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1219)
at com.vaadin.ui.Upload.fireUploadInterrupted(Upload.java:731)
at com.vaadin.ui.Upload$1.streamingFailed(Upload.java:1037)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.streamToReceiver(AbstractCommunicationManager.java:622)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleSimpleMultipartFileUpload(AbstractCommunicationManager.java:479)
at com.vaadin.terminal.gwt.server.CommunicationManager.handleFileUpload(CommunicationManager.java:257)
at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:495)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:679)
Caused by: java.lang.StackOverflowError
at java.lang.Character.toLowerCase(Character.java:3709)
at java.lang.Character.toLowerCase(Character.java:3680)
at java.lang.String.toLowerCase(String.java:2420)
at java.lang.String.toLowerCase(String.java:2508)
at org.apache.xerces.util.URI.setScheme(URI.java:908)
at org.apache.xerces.util.URI.initializeScheme(URI.java:576)
at org.apache.xerces.util.URI.initialize(URI.java:400)
at org.apache.xerces.util.URI.<init>(URI.java:211)
at org.apache.xerces.util.URI.<init>(URI.java:195)

Re: Urgent - Error deploying .BAR file, why?

jbarrez — Wed, 06 Feb 2013 08:42:50 GMT

Are you using a vanilla tomcat? It seems that there could be a mismatch in xml parsers versions.

Re: Urgent - Error deploying .BAR file, why?

sergiofigueras_ — Wed, 06 Feb 2013 11:33:28 GMT

Hi jbarrez,

I don't know what Tomcat Vanilla means, is it a lightweight version or old version?

Anyway, I'm using the Apache Tomcat 6.0.35. I've just downloaded and extracted, then, I've added it to Eclipse with Eclipse Servers Wizard.

Thanks!

Re: Urgent - Error deploying .BAR file, why?

frederikherema1 — Wed, 06 Feb 2013 14:36:10 GMT

Can you check what xerces version is shipped with this tomcat? And make sure no other xerces implementations are in the container class path, nor in your "endorsed-jvm" folder…

Re: Urgent - Error deploying .BAR file, why?

sergiofigueras_ — Thu, 07 Feb 2013 13:01:03 GMT

Hi folks,

I've verified and in my workspace exists two classes named XMLSchemaLoader. One inside java-6-openjdk, in the package com.sun.org.apache.xerces.internal.impl.xs, and other inside XercesImpl-2.0.2, in the package org.apache.xerces.impl.xs, that one is being used with Activiti. There's no other class or Xerces package.

Any idea?

Regards,

Re: Urgent - Error deploying .BAR file, why?

trademak — Fri, 08 Feb 2013 07:53:13 GMT

Is there a specific reason for using OpenJDK 6?
Could you try and use the Oracle JDK just to see if that solves the issue?

Best regards,

Re: Urgent - Error deploying .BAR file, why?

sergiofigueras_ — Fri, 08 Feb 2013 14:28:04 GMT

Hi trademak,

I've changed the runtime environment to Oracle JDK 1.6.0u35, but the same error has occurred.

Just to remember: I'm using the Activiti code to deploy.

protected void deployUploadedFile() {
    DeploymentBuilder deploymentBuilder = repositoryService.createDeployment().name(fileName);
    try {
      try {
        if (fileName.endsWith(".bpmn20.xml")) {
          validFile = true;
          deployment = deploymentBuilder
            .addInputStream(fileName, new ByteArrayInputStream(outputStream.toByteArray()))
            .deploy();
        } else if (fileName.endsWith(".bar") || fileName.endsWith(".zip")) {
          validFile = true;
          deployment = deploymentBuilder
            .addZipInputStream(new ZipInputStream(new ByteArrayInputStream(outputStream.toByteArray())))
            .deploy();
        } else {
          notificationManager.showErrorNotification("deployment.upload.invalid.file",
            MessagesUtility.getMessage("deployment.upload.invalid.desc"));
        }
      } catch (ActivitiException e) {
        String errorMsg = e.getMessage().replace(System.getProperty("line.separator"), "<br/>");
        notificationManager.showErrorNotification("deployment.upload.failed", errorMsg);
      }
    } finally {
      if (outputStream != null) {
        try {
          outputStream.close();
        } catch (IOException e) {
          notificationManager.showErrorNotification("Server-side error", e.getMessage());
        }
      }
    }
  }

Re: Urgent - Error deploying .BAR file, why?

jbarrez — Mon, 11 Feb 2013 07:21:49 GMT

Phew … I'm almost out of options.

Is it possible to put your bar file somewhere online (or a bar file that fails, at least), so we can test it ourselves?

Re: Urgent - Error deploying .BAR file, why?

sergiofigueras_ — Mon, 11 Feb 2013 13:32:41 GMT

Hi jbarrez,

Thanks for your patience. I've discovered the problem. I was using commons-dbcp 1.2.1 , but it's not supported. Then, I changed to 1.4 version and everything is going fine now.

Thanks!

Re: Urgent - Error deploying .BAR file, why?

jbarrez — Wed, 13 Feb 2013 13:09:18 GMT

Okay, that is a really strange solution … would never have expected the connection pool to be the culprit….

Thanks for posting back!