I have done some more investigation... After switching on the logging of SQL for the Derby DB (in etc/artifactory.system.properties, derby.language.logStatementText=true) I find the issue is an insert into the build_dependencies table...
2013-05-22 12:37:33,250 [http-bio-8080-exec-2] [DEBUG] (o.a.s.d.u.JdbcHelper:220) - Executing SQL: 'INSERT INTO build_dependencies VALUES(431489, 431446,'p2.eclipse-plugin:axe-jboss71-plugin:1.0.1', ' system', 'jboss-as/modules/org/jboss/remoting3/main/jboss-remoting-3.2.3.GA.jar','b847184fa6d6c0b88f871f5bb41572169b798ace', 'c36e605a3242d245ff273e984d1fca74')'. 2013-05-22 12:37:33,266 [http-bio-8080-exec-2] [DEBUG] (o.a.s.d.s.DbTransactionManager:843) - Initiating transaction rollback 2013-05-22 12:37:33,266 [http-bio-8080-exec-2] [DEBUG] (o.a.s.d.s.DbTransactionManager:279) - Rolling back JDBC transaction on Connection [jdbc:derby:D:/artifactory-3.0.1/bin/../data/derby, UserName=A PP, Apache Derby Embedded JDBC Driver] 2013-05-22 12:37:33,547 [http-bio-8080-exec-2] [DEBUG] (o.a.s.d.s.DbTransactionManager:322) - Releasing JDBC Connection [jdbc:derby:D:/artifactory-3.0.1/bin/../data/derby, UserName=APP, Apache Derby E mbedded JDBC Driver] after transaction 2013-05-22 12:37:33,563 [http-bio-8080-exec-2] [DEBUG] (o.a.s.f.l.a.LockingAdvice:69) - Received exception on method invocation: ReflectiveMethodInvocation: public abstract void org.artifactory.api.bu ild.BuildService.addBuild(org.jfrog.build.api.Build); target is of class [org.artifactory.build.BuildServiceImpl] org.artifactory.storage.StorageException: Could not insert build org.jfrog.build.api.Build@7b974d0d So the insert: INSERT INTO build_dependencies VALUES( 431489, --DEPENDENCY_ID 431446, --MODULE_ID 'p2.eclipse-plugin:axe-jboss71-plugin:1.0.1', --DEPENDENCY_NAME_ID 'system', -- DEPENDENCY_SCOPES 'jboss-as/modules/org/jboss/remoting3/main/jboss-remoting-3.2.3.GA.jar', -- DEPENDENCY_TYPE 'b847184fa6d6c0b88f871f5bb41572169b798ace', -- SHA1 'c36e605a3242d245ff273e984d1fca74')'. -- MD5 is causing the problem because the DEPENDENCY_TYPE is bonkers! So I know what the problems is but not how to fix it. Regards Paul Derby ij output Connecting directly to the Derby DB: D:\artifactory-3.0.1>ij ij version 10.10 ij> connect 'jdbc:derby:derby'; ij> show schemas; TABLE_SCHEM ------------------------------ APP NULLID SQLJ SYS SYSCAT SYSCS_DIAG SYSCS_UTIL SYSFUN SYSIBM SYSPROC SYSSTAT 11 rows selected ij> set schema app; 0 rows inserted/updated/deleted ij> describe build_dependencies; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& ------------------------------------------------------------------------------ DEPENDENCY_ID |BIGINT |0 |10 |19 |NULL |NULL |NO MODULE_ID |BIGINT |0 |10 |19 |NULL |NULL |NO DEPENDENCY_NAME_ID |VARCHAR |NULL|NULL|1024 |NULL |2048 |NO DEPENDENCY_SCOPES |VARCHAR |NULL|NULL|1024 |NULL |2048 |YES DEPENDENCY_TYPE |VARCHAR |NULL|NULL|64 |NULL |128 |YES SHA1 |CHAR |NULL|NULL|40 |NULL |80 |YES MD5 |CHAR |NULL|NULL|32 |NULL |64 |YES 7 rows selected ij> select distinct dependency_type from build_dependencies; DEPENDENCY_TYPE ---------------------------------------------------------------- zip client-jar eclipse-plugin-jar ear pom tests-jar jar win32.win32.x86-jar jdk15-jar war ejb-jar 11 rows selected -- View this message in context: http://forums.jfrog.org/Jenkins-artifactory-deploy-build-info-fails-with-ERROR-22001-tp7578810p7578812.html Sent from the Artifactory - Users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Try New Relic Now & We'll Send You this Cool Shirt New Relic is the only SaaS-based application performance monitoring service that delivers powerful full stack analytics. Optimize and monitor your browser, app, & servers with just a few lines of code. Try New Relic and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may _______________________________________________ Artifactory-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/artifactory-users
