topic Error on Executing SDK firstfountationclient in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-on-executing-sdk-firstfountationclient/m-p/205812#M158942 <HTML><HEAD></HEAD><BODY><SPAN>Hi i need help,</SPAN><BR /><SPAN>I downloaded sdk and configure with eclipse using the </SPAN><A href="http://wiki.alfresco.com/wiki/Alfresco_SDK" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Alfresco_SDK</A><SPAN>.</SPAN><BR /><SPAN>the oracle10g&nbsp; database configured with this environment. while executing the&nbsp; SDK firstfountationclient, i got this exeption.</SPAN><BR /><SPAN>please any one help me to resolve this issue. its really urgent.</SPAN><BR /><BR /><SPAN>custom-hibernate-dialect.properties </SPAN><BR /><BLOCKQUOTE class="jive-quote">hibernate.dialect=org.hibernate.dialect.Oracle9Dialect <BR />hibernate.default_schema=alfrescolab</BLOCKQUOTE><BR /><SPAN>custom-repository.properties</SPAN><BR /><BLOCKQUOTE class="jive-quote">db.driver=oracle.jdbc.OracleDriver<BR />db.name=alfrescolab<BR />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:@10.142.14.70:1521<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rcl<BR />db.username=alfrescolab<BR />db.password=alfrescolab</BLOCKQUOTE><BR /><SPAN>But still i got some Mysql exception.&nbsp; that i marked in red</SPAN><BR /><BR /><BR /><BR /><BR /><PRE class="language-none line-numbers"><CODE>16:42:54,501&nbsp; INFO&nbsp; [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]<BR />16:42:57,642&nbsp; WARN&nbsp; [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one<BR />[size=150][u][color=#800040]16:43:05,284&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.[/color][/u][/size]16:44:32,869&nbsp; ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed<BR />org.alfresco.error.AlfrescoRuntimeException: <BR />More than one Alfresco schema was found when querying the database metadata.<BR />&nbsp;&nbsp; Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:396)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:572)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1005)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:92)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:77)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:55)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:69)<BR />Exception in thread "main" org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1074)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:92)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:77)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:55)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:69)<BR />Caused by: org.alfresco.error.AlfrescoRuntimeException: <BR />More than one Alfresco schema was found when querying the database metadata.<BR />&nbsp;&nbsp; Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:396)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:572)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1005)<BR />&nbsp;&nbsp;&nbsp;… 10 more<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>‍</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><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>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Help would be highly appriciated. Thanks in advance.</SPAN><BR /><BR /><SPAN>-lenin</SPAN><UL></UL></BODY></HTML> Fri, 14 Nov 2008 11:22:45 GMT lmanoh 2008-11-14T11:22:45Z Error on Executing SDK firstfountationclient https://connect.hyland.com/t5/alfresco-archive/error-on-executing-sdk-firstfountationclient/m-p/205812#M158942 Hi i need help,I downloaded sdk and configure with eclipse using the http://wiki.alfresco.com/wiki/Alfresco_SDK.the oracle10g&nbsp; database configured with this environment. while executing the&nbsp; SDK firstfountationclient, i got this exeption.please any one help me to resolve this issue. its really urgen Fri, 14 Nov 2008 11:22:45 GMT https://connect.hyland.com/t5/alfresco-archive/error-on-executing-sdk-firstfountationclient/m-p/205812#M158942 lmanoh 2008-11-14T11:22:45Z Re: Error on Executing SDK firstfountationclient https://connect.hyland.com/t5/alfresco-archive/error-on-executing-sdk-firstfountationclient/m-p/205813#M158943 <HTML><HEAD></HEAD><BODY><SPAN>This problem has been fixed in Alfresco 3.1:</SPAN><BR /><A href="https://issues.alfresco.com/jira/browse/ETHREEOH-680" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/ETHREEOH-680</A></BODY></HTML> Mon, 18 Jan 2010 12:21:19 GMT https://connect.hyland.com/t5/alfresco-archive/error-on-executing-sdk-firstfountationclient/m-p/205813#M158943 nicolasraoul 2010-01-18T12:21:19Z Re: Error on Executing SDK firstfountationclient https://connect.hyland.com/t5/alfresco-archive/error-on-executing-sdk-firstfountationclient/m-p/205814#M158944 <HTML><HEAD></HEAD><BODY><SPAN>If you want to fix your installation, open tomcat/webapps/alfresco/WEB-INF/classes/alfresco/domain/hibernate-cfg.properties</SPAN><BR /><SPAN>and add the following line at the bottom of the file:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>hibernate.default_schema=alfresco2<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Replace alfresco2 with the name of your Oracle schema (aka tablespace, in Oracle it is usually the user name).</SPAN><BR /><BR /><SPAN>More information on </SPAN><A href="https://issues.alfresco.com/jira/browse/ETHREEOH-680" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/ETHREEOH-680</A></BODY></HTML> Mon, 18 Jan 2010 12:29:06 GMT https://connect.hyland.com/t5/alfresco-archive/error-on-executing-sdk-firstfountationclient/m-p/205814#M158944 nicolasraoul 2010-01-18T12:29:06Z