Hi all,
We are moving to Continuous integration with Jenkins. We use MKS Integrity
as our source code repository(SCM) and Piketech’s - TPT as a test tool.
I created a job and followed instructions available in Jenkins website. I
am getting an SQL Exception error with SCM plugin.
I have tried several troubleshooting steps but all went unsuccessful such
as downgrading the Integrity plugin version from V1.34 to V1.33 and looking
into my configuration setup to make sure no errors in my setup.
My setup:
Jenkins: V1.609.2 run as Windows package
MKS integrity software:
Integrity: 10
Build: 10.7.0.7925
API Version: 4.15.7925
Integrity Plugin: V1.34
OS: Windows
In Jenkins log there is an error, *ERROR 42Y55: 'DROP TABLE' cannot be
performed on 'SCM_3A91E968_5687_47A4_BA45_2AD99E8029F3' because it does not
exist*
PFA the Jenkins log and console output of the build.
Please let me know how to proceed further.
Thanks in advance!
Mit freundlichen Grüßen / Kind regards
*Vivek Yaragatti*
*TKI Automotive GmbH*
Ein Gemeinschaftsunternehmen der Audi Electronics Venture GmbH und der
Ipetronik Eichstätt GmbH
Wankelstraße 1
85080 Gaimersheim
Tel.: +49-841-89-710400
Mob.: +49 1525 / 7710400
--
You received this message because you are subscribed to the Google Groups
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jenkinsci-users/e25e406e-4027-4114-b12b-390f2b7d1abe%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Sep 04, 2015 12:10:05 PM SCHWERWIEGEND hudson.scm.DerbyUtils
cleanupProjectCacheSQLException
java.sql.SQLSyntaxErrorException: 'DROP TABLE' cannot be performed on
'SCM_3D728E47_5312_4ABD_9251_7B0A36E41456' because it does not exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at hudson.scm.DerbyUtils.executeStmt(DerbyUtils.java:189)
at hudson.scm.DerbyUtils.cleanupProjectCache(DerbyUtils.java:479)
at
hudson.scm.IntegrityRevisionState.<init>(IntegrityRevisionState.java:25)
at hudson.scm.IntegritySCM.calcRevisionsFromBuild(IntegritySCM.java:569)
at
hudson.scm.IntegritySCM.compareRemoteRevisionWith(IntegritySCM.java:896)
at hudson.scm.SCM.poll(SCM.java:397)
at hudson.model.AbstractProject._poll(AbstractProject.java:1450)
at hudson.model.AbstractProject.poll(AbstractProject.java:1353)
at hudson.triggers.SCMTrigger$Runner.runPolling(SCMTrigger.java:510)
at hudson.triggers.SCMTrigger$Runner.run(SCMTrigger.java:539)
at
hudson.util.SequentialExecutionQueue$QueueEntry.run(SequentialExecutionQueue.java:118)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: ERROR 42Y55: 'DROP TABLE' cannot be performed on
'SCM_3D728E47_5312_4ABD_9251_7B0A36E41456' because it does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.compile.DDLStatementNode.justGetDescriptor(Unknown
Source)
at
org.apache.derby.impl.sql.compile.DDLStatementNode.getTableDescriptor(Unknown
Source)
at
org.apache.derby.impl.sql.compile.DDLStatementNode.getTableDescriptor(Unknown
Source)
at
org.apache.derby.impl.sql.compile.DropTableNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
... 18 more
Gestartet durch Benutzer vivek yaragatti
Baue in Arbeitsbereich C:\Program Files
(x86)\Jenkins\jobs\BCM1_Klima_STM\workspace
Change Log: http://localhost:8080/job/BCM1_Klima_STM/42/changes
Build Log: http://localhost:8080/job/BCM1_Klima_STM/42/console
Preparing to execute si projectinfo for
#/Spielwiese#yaragattivivek/project.pj#CI_BCM1Klima/project.pj#STM/project.pj
Preparing to execute si viewproject for
#/Spielwiese#yaragattivivek/CI_BCM1Klima/STM
Checkout directory is C:\Program Files
(x86)\Jenkins\jobs\BCM1_Klima_STM\workspace
Successfully updated workspace with 0 updates and cleaned up 0 files!
Saving current Integrity Project configuration...
Writing build change log...
Change log successfully generated: C:\Program Files
(x86)\Jenkins\jobs\BCM1_Klima_STM\builds\42\changelog.xml
[Info 04.09.15 10:51:53]: *** Running TPT-File "STM - Kopie (8)" with
configuration "CItest1" now. ***
[Info 04.09.15 10:51:53]: Launching ""C:\Program Files\TPT-7\tpt.exe" "--run
build"
"D:\Sandboxes\Spielwiese\yaragattivivek\CI_BCM1Klima\STM\20_Produkt\40_TST\TST_STM\40_TST\10_TS\STM
- Kopie (8).tpt" "CItest1" --dataDir "C:\Program Files
(x86)\Jenkins\jobs\BCM1_Klima_STM\workspace" --reportDir "C:\Program Files
(x86)\Jenkins\jobs\BCM1_Klima_STM\workspace""
$ "C:\Program Files\TPT-7\tpt.exe" "--run build"
"D:\Sandboxes\Spielwiese\yaragattivivek\CI_BCM1Klima\STM\20_Produkt\40_TST\TST_STM\40_TST\10_TS\STM
- Kopie (8).tpt" CItest1 --dataDir "C:\Program Files
(x86)\Jenkins\jobs\BCM1_Klima_STM\workspace" --reportDir "C:\Program Files
(x86)\Jenkins\jobs\BCM1_Klima_STM\workspace"
CompilerOracle: exclude javax/swing/text/GlyphView.getBreakSpot
ERROR: Timeout after 6 hours
[Error 04.09.15 16:51:55]: TPT process stops with exit code -1
[Info 04.09.15 16:51:55]: *** Publishing results now ***
Finished: SUCCESS
