topic Failed to run Alfresco SDK sample -SDK FirstFoundationClient in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/failed-to-run-alfresco-sdk-sample-sdk-firstfoundationclient/m-p/34768#M18225 <HTML><HEAD></HEAD><BODY><SPAN>Hi Guys</SPAN><BR /><BR /><SPAN>I downloaded the Alfresco SDK and followed the instructions from the wiki site </SPAN><A href="http://wiki.alfresco.com/wiki/Alfresco_SDK" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Alfresco_SDK</A><BR /><BR /><SPAN>Following the "Running your first Alfresco Client" from the wiki site above</SPAN><BR /><BR /><SPAN>It gave me the following errors</SPAN><BR /><BR /><SPAN>I am using elipse 3.1,mysql database</SPAN><BR /><SPAN>I got no syntax errors but I got some runtime errors below</SPAN><BR /><SPAN>I already copied and pasted my properties below after the errors</SPAN><BR /><BR /><SPAN>Thanks for the help</SPAN><BR /><BR /><SPAN>01:43:38,955 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table access_control_list add index FK18486D3B7F2C8017 (node_id), add constraint FK18486D3B7F2C8017 foreign key (node_id) references node (id)</SPAN><BR /><SPAN>01:43:38,975 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)</SPAN><BR /><SPAN>01:43:39,076 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_assoc add index FKC6EFFF3274173FF4 (child_node_id), add constraint FKC6EFFF3274173FF4 foreign key (child_node_id) references node (id)</SPAN><BR /><SPAN>01:43:39,076 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)</SPAN><BR /><SPAN>01:43:39,186 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_assoc add index FKC6EFFF328E50E582 (parent_node_id), add constraint FKC6EFFF328E50E582 foreign key (parent_node_id) references node (id)</SPAN><BR /><SPAN>01:43:39,186 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)</SPAN><BR /><SPAN>01:43:39,286 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_aspects add index FK2B91A9DE7F2C8017 (node_id), add constraint FK2B91A9DE7F2C8017 foreign key (node_id) references node (id)</SPAN><BR /><SPAN>01:43:39,286 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)</SPAN><BR /><SPAN>01:43:39,386 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_assoc add index FK5BAEF398B69C43F3 (source_node_id), add constraint FK5BAEF398B69C43F3 foreign key (source_node_id) references node (id)</SPAN><BR /><SPAN>01:43:39,386 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)</SPAN><BR /><SPAN>01:43:39,516 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_assoc add index FK5BAEF398A8FC7769 (target_node_id), add constraint FK5BAEF398A8FC7769 foreign key (target_node_id) references node (id)</SPAN><BR /><SPAN>01:43:39,516 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)</SPAN><BR /><SPAN>01:43:39,656 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_properties add index FKC962BF907F2C8017 (node_id), add constraint FKC962BF907F2C8017 foreign key (node_id) references node (id)</SPAN><BR /><SPAN>01:43:39,656 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)</SPAN><BR /><SPAN>01:43:39,747 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_status add index FK38ECB8CF7F2C8017 (node_id), add constraint FK38ECB8CF7F2C8017 foreign key (node_id) references node (id)</SPAN><BR /><SPAN>01:43:39,747 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)</SPAN><BR /><SPAN>01:43:39,867 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table store add index FK68AF8E122DBA5BA (root_node_id), add constraint FK68AF8E122DBA5BA foreign key (root_node_id) references node (id)</SPAN><BR /><SPAN>01:43:39,867 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)</SPAN><BR /><SPAN>01:43:44,083 ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to execute command: imconvert "C:\DOCUME~1\Chi\LOCALS~1\Temp\Alfresco\ImageMagickContentTransformer_init_source_37943.gif"&nbsp; "C:\DOCUME~1\Chi\LOCALS~1\Temp\Alfresco\ImageMagickContentTransformer_init_target_37944.png"</SPAN><BR /><SPAN>Jun 16, 2006 1:43:44 AM net.sf.joott.uno.UnoConnection connect</SPAN><BR /><SPAN>INFO: connecting using "socket,host=localhost,port=8100,tcpNoDelay=1"…</SPAN><BR /><SPAN>Jun 16, 2006 1:43:45 AM net.sf.joott.uno.UnoConnection connect</SPAN><BR /><SPAN>SEVERE: connection failed: com.sun.star.connection.NoConnectException: java.net.ConnectException: Connection refused: connect</SPAN><BR /><SPAN>Jun 16, 2006 1:43:46 AM net.sf.joott.uno.UnoConnection connect</SPAN><BR /><SPAN>INFO: connecting using "socket,host=localhost,port=8100,tcpNoDelay=1"…</SPAN><BR /><SPAN>Jun 16, 2006 1:43:47 AM net.sf.joott.uno.UnoConnection connect</SPAN><BR /><SPAN>SEVERE: connection failed: com.sun.star.connection.NoConnectException: java.net.ConnectException: Connection refused: connect</SPAN><BR /><SPAN>01:43:47,808 ERROR [hibernate.util.JDBCExceptionReporter] Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><BR /><BR /><SPAN>—————————————————–</SPAN><BR /><SPAN>.properties file</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Sample custom content and index data location</SPAN><BR /><SPAN>#</SPAN><BR /><BR /><SPAN>dir.root=./alf_data</SPAN><BR /><BR /><BR /><SPAN>db.username=alfresco</SPAN><BR /><SPAN>db.password=alfresco</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># MySQL connection (This is default and requires mysql-connector-java-3.1.12-bin.jar, which ships with the Alfresco server)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.driver=org.gjt.mm.mysql.Driver</SPAN><BR /><SPAN>db.url=jdbc:mysql://localhost/alfresco</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=oracle.jdbc.OracleDriver</SPAN><BR /><SPAN>#db.url=jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@localhost:1521:alfresco</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=com.sybase.jdbc2.jdbc.SybDriver</SPAN><BR /><SPAN>#db.url=jdbc:sybase:Tds:localhost:2638/alfresco</SPAN></BODY></HTML> Fri, 16 Jun 2006 05:51:54 GMT chi 2006-06-16T05:51:54Z Failed to run Alfresco SDK sample -SDK FirstFoundationClient https://connect.hyland.com/t5/alfresco-archive/failed-to-run-alfresco-sdk-sample-sdk-firstfoundationclient/m-p/34768#M18225 Hi GuysI downloaded the Alfresco SDK and followed the instructions from the wiki site http://wiki.alfresco.com/wiki/Alfresco_SDKFollowing the "Running your first Alfresco Client" from the wiki site aboveIt gave me the following errorsI am using elipse 3.1,mysql databaseI got no syntax errors but I g Fri, 16 Jun 2006 05:51:54 GMT https://connect.hyland.com/t5/alfresco-archive/failed-to-run-alfresco-sdk-sample-sdk-firstfoundationclient/m-p/34768#M18225 chi 2006-06-16T05:51:54Z Re: Failed to run Alfresco SDK sample -SDK FirstFoundationClient https://connect.hyland.com/t5/alfresco-archive/failed-to-run-alfresco-sdk-sample-sdk-firstfoundationclient/m-p/34769#M18226 <HTML><HEAD></HEAD><BODY><SPAN>The messages imply an exising Alfresco database schema already exists and that the auto-schema migration has failed; this will be the case, if the existing schema was created with a pre-v1.3 release.</SPAN><BR /><BR /><SPAN>Can you try on a clean database, or (if you were using 1.2), upgrade the database to 1.3 using </SPAN><A href="http://wiki.alfresco.com/wiki/Upgrading_to_1.3.0" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Upgrading_to_1.3.0</A><SPAN>.</SPAN></BODY></HTML> Fri, 16 Jun 2006 08:31:11 GMT https://connect.hyland.com/t5/alfresco-archive/failed-to-run-alfresco-sdk-sample-sdk-firstfoundationclient/m-p/34769#M18226 davidc 2006-06-16T08:31:11Z