Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-13942

Perforce Job Integration is not working properly in JIRA 6 onwards

    XMLWordPrintable

Details

    Description

      Basically, there is few fault behaviour when try to use Perforce Job Integration (bundled with Fisheye plugin in JIRA 6.0.2)

      Steps to reproduce:

      1. Fresh install JIRA 6 and connect it with Fisheye 3.0.2
      2. Install Perforce and configure it all the necessary connectioon
      3. Then set-up the Perforce Job Integration in (Administration > Add-ons)

      The following is the fault behaviour after you successfully connect JIRA with Perforce:

      1. Editing p4 configuration 1.jpg leads to new p4 integration creation 2.jpg(whereby the exisiting value of the configuration will be missing).
      2. Test connection doesn't do anything 3.jpg (when click either one of the link it doesn't show anything, basically the page will just refresh itself and there is no changes at all)
      3. It is not possible to select perforce config under project config. It always select the option none. 4.jpg
      4. Unable to delete configurations created in the first step 5.jpg (it will show the stack traces in the screenshot)

      Side Note: I have done further testing and all of these is working absolutely fine for the Perforce Job Integration in JIRA 4.4 and JIRA 5.2.11

      Workaround to delete Perforce configuration

      Please note this procedure will make changes directly in your database. Please make sure you take a backup before applying this procedure

      1. Shutdown JIRA.
      2. Run the following SQL queries in your database:
        delete from propertydata where id in (select id from propertyentry where property_key like 'fisheye.p4%');
        delete from propertydate where id in (select id from propertyentry where property_key like 'fisheye.p4%');
        delete from propertydecimal where id in (select id from propertyentry where property_key like 'fisheye.p4%');
        delete from propertynumber where id in (select id from propertyentry where property_key like 'fisheye.p4%');
        delete from propertystring where id in (select id from propertyentry where property_key like 'fisheye.p4%');
        delete from propertytext where id in (select id from propertyentry where property_key like 'fisheye.p4%');
        delete from propertyentry where property_key like 'fisheye.p4%';
      3. Start JIRA.

      Attachments

        1. 5.jpg
          5.jpg
          84 kB
        2. 4.jpg
          4.jpg
          75 kB
        3. 3.jpg
          3.jpg
          168 kB
        4. 2.jpg
          2.jpg
          122 kB
        5. 1.jpg
          1.jpg
          150 kB

        Issue Links

          Activity

            People

              ohernandez@atlassian.com Oswaldo Hernandez (Inactive)
              dchua Daryl Chuah (Inactive)
              Votes:
              14 Vote for this issue
              Watchers:
              19 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: