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

Provide a more end user friendly way for the Spoon developer when deleting connections that are used (referential integrity violation)

    XMLWordPrintable

    Details

    • Story Points:
      0
    • 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.

      Description

      Use Case:
      Spoon developer is trying to delete some data sources, but is blocked due to some constraints.
      The Spoon developer only gets IDs:
      [cid:2e644a8d-8510-4ea2-a791-d2a1a2d6132c]
      [cid:2f5c6513-fc53-46da-8f1b-ec5509805979]
      [cid:e752545e-cb82-43d1-bafd-607ca1a4f564]

      Tailing the pentaho.log on the server reveals:

      2017-12-05 08:10:10,470 ERROR [org.pentaho.platform.dataaccess.datasource.wizard.service.impl.ConnectionServiceImpl] ConnectionServiceImpl.ERROR_0006 - Unable to delete connection name : connection name was mogul-tmf-userdata caused by DatasourceMgmtService.ERROR_0002 - Error occurred during deleting the datasource xxx.kdb. Cause: referential integrity error while deleting file with id "8bf41d7e-9ad7-4812-acec-1b420cc55e19"; (file /etc/pdi/databases/xxx.kdb is being referenced by file(s) [/home/ccc/Transformation 1.ktr])

      After deleting this transformation, the end user gets the next exception since the connection is also used in other transformations.

      This is a tedious process for the Spoon developer:

      • they dont have shell access to the server, nor the skills to monitor and decipher logs
      • they dont necessarily know or remember where they used a given data source

      We need a more end user friendly way to perform the task at hand here.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              gdev Gurudev
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: