Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-19177

Web Service Lookup fails in 9.1 with Connection pool shut down error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 9.0.0 GA, 9.1.0 GA
    • Fix Version/s: Backlog
    • Component/s: Step
    • Labels:
    • Story Points:
      0
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide
      1. Install PDI 9.1
      2. Download the sample KTR WEB_Lookup_Only.ktr located in ESR-7343
      3. Open 9.1 Spoon and run the KTR.

      Actual Results:  The web service lookup fails with an error that the connection pool has shut down.

      Expected Results:  The web service lookup should succeed.

      Show
      Install PDI 9.1 Download the sample KTR WEB_Lookup_Only.ktr located in ESR-7343 Open 9.1 Spoon and run the KTR. Actual Results:   The web service lookup fails with an error that the connection pool has shut down. Expected Results:   The web service lookup should succeed.

      Description

      Some Web Service URLs will fail in 9.x with a Connection pool shut down error.

      The sample KTR in ESR-7343 will fail every time, even if it is the first KTR that is ran. 

      Our sample KTRs will run successfully if no Web Service Lookup requests have failed before it.  However, once a lookup has failed, no other lookups will be successful until the JVM is restarted.

      This is working as expected in the latest 8.3 service pack and only starts failing in 9.0GA and above.

      More information, the sample KTR WEB_Lookup_Only.ktr, and logs are located in ESR-7343.

        Attachments

          Activity

            People

            Assignee:
            ttreat Tammy Treat
            Reporter:
            bowens Brittany Owens
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: