topic Table already exists [RESOLVED] in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/table-already-exists-resolved/m-p/35720#M18785 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to get Activiti installed. After following the advice in </SPAN><A href="http://forums.activiti.org/en/viewtopic.php?f=3&amp;t=440&amp;p=1773&amp;hilit=proxy#p1773" rel="nofollow noopener noreferrer">this post</A><SPAN>, by deleting the runtime and test library folders, it actually downloads everything.</SPAN><BR /><BR /><SPAN>I receive a SQL exception that the tables already exist:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />db.create.engine:<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [sql] Executing resource: org/activiti/db/create/activiti.h2.create.sql<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [sql] Failed to execute:&nbsp; create table ACT_GE_PROPERTY ( NAME_ varchar(64)<BR />, VALUE_ varchar(300), REV_ integer, primary key (NAME_) )<BR /><BR />BUILD FAILED<BR />C:\activiti-5.0.rc1\setup\build.xml:180: org.h2.jdbc.JdbcSQLException: Table "AC<BR />T_GE_PROPERTY" already exists; SQL statement:<BR /> create table ACT_GE_PROPERTY ( NAME_ varchar(64), VALUE_ varchar(300), REV_ int<BR />eger, primary key (NAME_) ) [42101-124]<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I am guessing this is due to a failed installation previously. How can I clear out the h2 database?</SPAN><BR /><BR /><SPAN>I've also noticed that a java persists after the build script fails. I know this is h2 because if I restart the build script it says port in use and it cannot bind. (The port used for h2)</SPAN><BR /><BR /><SPAN>I think the demo script and toolchain is quite complicated for what you are trying to accomplish and seems to be prone to falling over if the environment has a proxy or if the installation fails.</SPAN></BODY></HTML> Mon, 22 Nov 2010 10:29:28 GMT experimental 2010-11-22T10:29:28Z Table already exists [RESOLVED] https://connect.hyland.com/t5/alfresco-archive/table-already-exists-resolved/m-p/35720#M18785 I am trying to get Activiti installed. After following the advice in this post, by deleting the runtime and test library folders, it actually downloads everything.I receive a SQL exception that the tables already exist:db.create.engine:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [sql] Executing resource: org/activiti/db/create/activiti. Mon, 22 Nov 2010 10:29:28 GMT https://connect.hyland.com/t5/alfresco-archive/table-already-exists-resolved/m-p/35720#M18785 experimental 2010-11-22T10:29:28Z Re: Table already exists [RESOLVED] https://connect.hyland.com/t5/alfresco-archive/table-already-exists-resolved/m-p/35721#M18786 <HTML><HEAD></HEAD><BODY><SPAN>Try running 'ant db.drop' to clear the tables and run the demo.setup again, this should do the trick.</SPAN><BR /><BR /><SPAN>To make sure H2 is stopped, you can run 'ant demo.teardown'</SPAN></BODY></HTML> Mon, 22 Nov 2010 10:48:12 GMT https://connect.hyland.com/t5/alfresco-archive/table-already-exists-resolved/m-p/35721#M18786 frederikherema1 2010-11-22T10:48:12Z Re: Table already exists [RESOLVED] https://connect.hyland.com/t5/alfresco-archive/table-already-exists-resolved/m-p/35722#M18787 <HTML><HEAD></HEAD><BODY><SPAN>The demo-setup has been reviewed and no longer uses maven, which can cause some issues depending on the environment (proxy etc.) and render the setup in a "stale" state when downloading dependencies failed the first time.</SPAN></BODY></HTML> Mon, 22 Nov 2010 10:52:44 GMT https://connect.hyland.com/t5/alfresco-archive/table-already-exists-resolved/m-p/35722#M18787 frederikherema1 2010-11-22T10:52:44Z