Uploaded image for project: 'Jenkins'
  1. Jenkins
  2. JENKINS-14703

PTC Integrity Plugin throws/catches SQL Exception in Combination with Locale Plugin

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • integrity-plugin
    • Windows 7 64 bit, MKS Integrity Client 2009 (Build: 4.10.0.9049), Jenkins 1.476, integrity-plugin 1.14

      Company language is English so we want to use the locale plugin to force Jenkins frontend to English. But if we do so, we get the following error message during SCM polling with integrity plugin:

      Started by an SCM change
      Building in workspace d:\Jenkins\jobs\xxx\workspace
      Change Log: http://xxxjenkinsxxx/job/xxx/38/changes
      Build Log: http://xxxjenkinsxxx/job/xxx/38/console
      Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL
      Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxBAL
      A SQL Exception was caught!
      Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-06_11-02-18/IntegritySCM', see the next exception for details.
      Archiving artifacts
      Skipping Cobertura coverage report as build was not UNSTABLE or better ...
      Recording test results
      Finished: FAILURE

      Here the requested debug output:

      Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Start execution of checkout() routine...!
      Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Creating Integrity API Session...
      Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - api ping --user=xxx --port=xxx --hostname=xxx – returned exit code 0
      Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Successfully established connection xxx@xxx:xxx
      Aug 13, 2012 3:56:09 PM [DEBUG] IntegritySCM - Preparing to execute si projectinfo for #p=d:/mks/archives/src/xxx.pj#d=xxxxxx
      Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - si projectinfo --user=xxx --port=xxx --hostname=xxx --project=#p=d:/mks/archives/src/xxx.pj#d=xxx – returned exit code 0

      Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - si projectinfo --user=xxx --port=xxx --hostname=xxx --project=#p=d:/mks/archives/src/xxx.pj#d=xxxxxx – returned 0
      Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Preparing to execute si viewproject for #p=d:/mks/archives/src/xxx.pj#d=xxxxxx
      Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Executed si viewproject --user=xxx --port=7001 --hostname=xxx --recurse --project=#p=d:/mks/archives/src/xxx.pj#d=xxxxxx --fi
      elds=name,context,cpid,memberrev,membertimestamp,memberdescription – with interim
      Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Attempting to open connection to database: d:\Jenkins\jobs\xxx\builds\2012-08-13_15-56-09\IntegritySCM
      Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - SQL Exception caught...
      Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - java.sql.SQLException: Failed to create database 'd:/Jenkins/jobs/xxx/builds/2012-08-13_15-56-09/IntegritySCM', see the next exception for
      details.
      Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Attempting to shut down database: d:\Jenkins\jobs\xxx\builds\2012-08-13_15-56-09\IntegritySCM
      Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - Failed to shutdown database connection!
      Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - Database 'd:/Jenkins/jobs/xxx/builds/2012-08-13_15-56-09/IntegritySCM' not found.
      Aug 13, 2012 3:56:10 PM [INFO] IntegritySCM - java.sql.SQLException: Database 'd:/Jenkins/jobs/xxx/builds/2012-08-13_15-56-09/IntegritySCM' not found.
      ?[33mAug 13, 2012 3:56:10 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody
      WARNING: Unsupported transfer encoding:
      ?[0mAug 13, 2012 3:56:10 PM org.apache.commons.httpclient.HttpMethodBase readResponseBody
      INFO: Response content is not chunk-encoded
      Aug 13, 2012 3:56:10 PM [DEBUG] IntegritySCM - Successfully disconnected connection xxx@xxx:7001

          [JENKINS-14703] PTC Integrity Plugin throws/catches SQL Exception in Combination with Locale Plugin

            cdsouza Cletus D'Souza
            xxthunder Karsten Günther
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: