topic Fail to run FirstFoundationClient.java in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/fail-to-run-firstfoundationclient-java/m-p/184718#M137848 <HTML><HEAD></HEAD><BODY><SPAN>I have a brand new installation of Labs3 with MySql 5.1.30, and sdk-3a.1032. I got the following exception when I run FirstFoundationClient. Is there anybody met such problem before?</SPAN><BR /><BR /><SPAN>—————————————–</SPAN><BR /><BR /><SPAN>13:14:18,313&nbsp; ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation: </SPAN><BR /><SPAN>Execution result: </SPAN><BR /><SPAN>&nbsp;&nbsp; os:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Windows XP</SPAN><BR /><SPAN>&nbsp;&nbsp; command:&nbsp;&nbsp;&nbsp; imconvert "C:\Temp\Alfresco\ImageMagickContentTransformer_init_source_8639.gif"&nbsp; "C:\Temp\Alfresco\ImageMagickContentTransformer_init_target_8640.png"</SPAN><BR /><SPAN>&nbsp;&nbsp; succeeded:&nbsp; false</SPAN><BR /><SPAN>&nbsp;&nbsp; exit code:&nbsp; 1</SPAN><BR /><SPAN>&nbsp;&nbsp; out:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp; err:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CreateProcess: imconvert "C:\Temp\Alfresco\ImageMagickContentTransformer_init_source_8639.gif" "C:\Temp\Alfresco\ImageMagickContentTransformer_init_target_8640.png" error=2</SPAN><BR /><SPAN>13:14:18,781&nbsp; INFO&nbsp; [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]</SPAN><BR /><SPAN>13:14:21,250&nbsp; ERROR [transform.swf.PDFToSWFContentTransformer] Failed to start SWF2PDF transformer: </SPAN><BR /><SPAN>Execution result: </SPAN><BR /><SPAN>&nbsp;&nbsp; os:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Windows XP</SPAN><BR /><SPAN>&nbsp;&nbsp; command:&nbsp;&nbsp;&nbsp; pdf2swf -V</SPAN><BR /><SPAN>&nbsp;&nbsp; succeeded:&nbsp; false</SPAN><BR /><SPAN>&nbsp;&nbsp; exit code:&nbsp; 1</SPAN><BR /><SPAN>&nbsp;&nbsp; out:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp; err:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CreateProcess: pdf2swf -V error=2</SPAN><BR /><SPAN>13:14:21,610&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.</SPAN><BR /><SPAN>13:14:23,141&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script C:\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-8641.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-1-drop-indexes-and-constraints.sql).</SPAN><BR /><SPAN>13:14:25,906&nbsp; ERROR [domain.schema.SchemaBootstrap] Statement execution failed:</SPAN><BR /><SPAN>&nbsp;&nbsp; SQL:&nbsp; ALTER TABLE alf_audit_fact DROP INDEX FKEAD18174A0F9B8D9, DROP FOREIGN KEY FKEAD18174A0F9B8D9</SPAN><BR /><SPAN>&nbsp;&nbsp; Error: Can't DROP 'FKEAD18174A0F9B8D9'; check that column/key exists</SPAN><BR /><SPAN>&nbsp;&nbsp; File: C:\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-8641.sql</SPAN><BR /><SPAN>&nbsp;&nbsp; Line: 51</SPAN><BR /><SPAN>13:14:25,906&nbsp; ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed</SPAN><BR /><SPAN>com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Can't DROP 'FKEAD18174A0F9B8D9'; check that column/key exists</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Statement.execute(Statement.java:692)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:872)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:841)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:707)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:678)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:600)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1005)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:92)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:77)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:55)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:69)</SPAN><BR /><SPAN>Exception in thread "main" org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1074)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:92)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:77)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:55)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:69)</SPAN><BR /><SPAN style="color:#FF0000;">Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Can't DROP '<STRONG>FKEAD18174A0F9B8D9</STRONG>'; check that column/key exists</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Statement.execute(Statement.java:692)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:872)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:841)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:707)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:678)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:600)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1005)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 10 more</SPAN></BODY></HTML> Thu, 26 Feb 2009 18:41:53 GMT jeffwji 2009-02-26T18:41:53Z Fail to run FirstFoundationClient.java https://connect.hyland.com/t5/alfresco-archive/fail-to-run-firstfoundationclient-java/m-p/184718#M137848 I have a brand new installation of Labs3 with MySql 5.1.30, and sdk-3a.1032. I got the following exception when I run FirstFoundationClient. Is there anybody met such problem before?—————————————–13:14:18,313&nbsp; ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransform Thu, 26 Feb 2009 18:41:53 GMT https://connect.hyland.com/t5/alfresco-archive/fail-to-run-firstfoundationclient-java/m-p/184718#M137848 jeffwji 2009-02-26T18:41:53Z Re: Fail to run FirstFoundationClient.java https://connect.hyland.com/t5/alfresco-archive/fail-to-run-firstfoundationclient-java/m-p/184719#M137849 <HTML><HEAD></HEAD><BODY><SPAN>I've exactly the same problem as jeffwji and also others as I've seen in the Forum. Anybody got some solutionn???</SPAN><BR /><BR /><SPAN>Greetings from Italy</SPAN><BR /><SPAN>Johannes</SPAN></BODY></HTML> Fri, 27 Feb 2009 14:02:53 GMT https://connect.hyland.com/t5/alfresco-archive/fail-to-run-firstfoundationclient-java/m-p/184719#M137849 john84 2009-02-27T14:02:53Z Re: Fail to run FirstFoundationClient.java https://connect.hyland.com/t5/alfresco-archive/fail-to-run-firstfoundationclient-java/m-p/184720#M137850 <HTML><HEAD></HEAD><BODY><SPAN>is it too late?</SPAN><BR /><BR /><SPAN>Try to add the imageMagick root folder to the system path and rename the file from convert.exe to imconvert.exe</SPAN></BODY></HTML> Wed, 18 Mar 2009 16:09:06 GMT https://connect.hyland.com/t5/alfresco-archive/fail-to-run-firstfoundationclient-java/m-p/184720#M137850 dacedos 2009-03-18T16:09:06Z