topic Installation of Alfresco 2.1.0 on Sybase 1.5.02 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/installation-of-alfresco-2-1-0-on-sybase-1-5-02/m-p/151752#M106470 <HTML><HEAD></HEAD><BODY><SPAN>We are evaluating if we want to use Alfresco 2.1.0 as our website's cms, but when we try to deploy against Sybase ASE 1.5.02 with the most recent jConnect jdbc drivers (db.driver=com.sybase.jdbc3.jdbc.SybDriver) the bootstrapping fails.&nbsp; Any suggestions on how to fix this?</SPAN><BR /><BR /><BR /><SPAN>11:41:50,796 INFO&nbsp; [domain.schema.SchemaBootstrap] Schema managed by database di</SPAN><BR /><SPAN>alect org.alfresco.repo.domain.hibernate.dialect.AlfrescoSybaseAnywhereDialect.</SPAN><BR /><SPAN>11:41:50,968 INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script D:\</SPAN><BR /><SPAN>alfresco-community-tomcat-2.1.0\tomcat\temp\Alfresco\AlfrescoSchemaCreate-org.al</SPAN><BR /><SPAN>fresco.repo.domain.hibernate.dialect.AlfrescoSybaseAnywhereDialect-17293.sql (Ge</SPAN><BR /><SPAN>nerated).</SPAN><BR /><SPAN>11:41:51,187 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:</SPAN><BR /><SPAN>&nbsp;&nbsp; SQL:&nbsp; create table JBPM_PROCESSINSTANCE ( ID_ numeric(19,0) identity not null</SPAN><BR /><SPAN>, VERSION_ int not null, KEY_ text null, START_ datetime null, END_ datetime nul</SPAN><BR /><SPAN>l, ISSUSPENDED_ tinyint null, PROCESSDEFINITION_ numeric(19,0) null, ROOTTOKEN_</SPAN><BR /><SPAN>numeric(19,0) null, SUPERPROCESSTOKEN_ numeric(19,0) null, primary key (ID_), un</SPAN><BR /><SPAN>ique (KEY_, PROCESSDEFINITION_) )</SPAN><BR /><SPAN>&nbsp;&nbsp; Error: Column 'KEY_' – Can't create index on a column of TEXT, IMAGE or UNIT</SPAN><BR /><SPAN>EXT data type.</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; File: D:\alfresco-community-tomcat-2.1.0\tomcat\temp\Alfresco\AlfrescoSchemaC</SPAN><BR /><SPAN>reate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoSybaseAnywhereDialect-1</SPAN><BR /><SPAN>7293.sql</SPAN><BR /><SPAN>&nbsp;&nbsp; Line: 234</SPAN><BR /><SPAN>11:41:51,203 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed</SPAN><BR /><SPAN>com.sybase.jdbc3.jdbc.SybSQLException: Column 'KEY_' – Can't create index on a</SPAN><BR /><SPAN>column of TEXT, IMAGE or UNITEXT data type.</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sybase.jdbc3.tds.Tds.a(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStateme</SPAN><BR /><SPAN>nt.java:261)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(Sche</SPAN><BR /><SPAN>maBootstrap.java:700)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(Sch</SPAN><BR /><SPAN>emaBootstrap.java:675)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBo</SPAN><BR /><SPAN>otstrap.java:443)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBoo</SPAN><BR /><SPAN>tstrap.java:767)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi</SPAN><BR /><SPAN>fecycleBean.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.event.SimpleApplicationEventMulticaster$1</SPAN><BR /><SPAN>.run(SimpleApplicationEventMulticaster.java:77)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecut</SPAN><BR /><SPAN>or.java:49)</SPAN></BODY></HTML> Tue, 29 Apr 2008 16:03:07 GMT fazle 2008-04-29T16:03:07Z Installation of Alfresco 2.1.0 on Sybase 1.5.02 https://connect.hyland.com/t5/alfresco-archive/installation-of-alfresco-2-1-0-on-sybase-1-5-02/m-p/151752#M106470 We are evaluating if we want to use Alfresco 2.1.0 as our website's cms, but when we try to deploy against Sybase ASE 1.5.02 with the most recent jConnect jdbc drivers (db.driver=com.sybase.jdbc3.jdbc.SybDriver) the bootstrapping fails.&nbsp; Any suggestions on how to fix this?11:41:50,796 INFO&nbsp; [domain. Tue, 29 Apr 2008 16:03:07 GMT https://connect.hyland.com/t5/alfresco-archive/installation-of-alfresco-2-1-0-on-sybase-1-5-02/m-p/151752#M106470 fazle 2008-04-29T16:03:07Z Re: Installation of Alfresco 2.1.0 on Sybase 1.5.02 https://connect.hyland.com/t5/alfresco-archive/installation-of-alfresco-2-1-0-on-sybase-1-5-02/m-p/151753#M106471 <HTML><HEAD></HEAD><BODY><SPAN>Sybase is not supported on 2.1 Enterprise train, so i would not expect it to work with Community.&nbsp; </SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; </SPAN><A href="http://alfresco.com/services/support/stacks/2.1/" rel="nofollow noopener noreferrer">http://alfresco.com/services/support/stacks/2.1/</A><BR /><BR /><SPAN>Your best bet is to use a different database, one that's supported on the enterprise branch - obviously that will have a much higher chance of working.</SPAN></BODY></HTML> Tue, 29 Apr 2008 23:49:01 GMT https://connect.hyland.com/t5/alfresco-archive/installation-of-alfresco-2-1-0-on-sybase-1-5-02/m-p/151753#M106471 jbarmash 2008-04-29T23:49:01Z