topic Unknown column 'content_url_short' in 'where clause' in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unknown-column-content-url-short-in-where-clause/m-p/221952#M175082 <HTML><HEAD></HEAD><BODY><SPAN>Hi folks,</SPAN><BR /><SPAN>I hope this is the right place to post this question, if not, my apologies!</SPAN><BR /><SPAN>I've finally got things sort of working but when I try and run the "SDK FirstFoundationClient" app I'm faced with the following error:</SPAN><BR /><SPAN>Any ideas?</SPAN><BR /><SPAN>Thanks, </SPAN><BR /><SPAN>Eric.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>Exception in thread "main" org.alfresco.error.AlfrescoRuntimeException: 08120040 Bootstrap failed<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:352)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:709)<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:246)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:122)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:76)<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.service.cmr.view.ImporterException: Failed to import package at line 24; column 19 due to error: 08120039 Failed to set content property on stream closure: <BR />&nbsp;&nbsp; node: system://system/8ade4c3a-badd-4322-8c71-f7b48d47ee58<BR />&nbsp;&nbsp; property: {<A href="http://www.alfresco.org/model/system/1.0}versionProperties" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/system/1.0}versionProperties</A><BR />&nbsp;&nbsp; writer: ContentAccessor[ contentUrl=store://2009/9/12/0/27/7c503f1b-5b8e-487e-88f6-386a7ce1ede2.bin, mimetype=text/plain, size=259, encoding=UTF8, locale=en_US]<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:196)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:359)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:223)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.doImport(ImporterBootstrap.java:466)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.access$000(ImporterBootstrap.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap$1$1.execute(ImporterBootstrap.java:341)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstrap.java:345)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:348)<BR />&nbsp;&nbsp;&nbsp;… 12 more<BR />Caused by: org.alfresco.service.cmr.repository.ContentIOException: 08120039 Failed to set content property on stream closure: <BR />&nbsp;&nbsp; node: system://system/8ade4c3a-badd-4322-8c71-f7b48d47ee58<BR />&nbsp;&nbsp; property: {<A href="http://www.alfresco.org/model/system/1.0}versionProperties" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/system/1.0}versionProperties</A><BR />&nbsp;&nbsp; writer: ContentAccessor[ contentUrl=store://2009/9/12/0/27/7c503f1b-5b8e-487e-88f6-386a7ce1ede2.bin, mimetype=text/plain, size=259, encoding=UTF8, locale=en_US]<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.content.ContentServiceImpl$WriteStreamListener.contentStreamClosed(ContentServiceImpl.java:656)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel$1.execute(AbstractContentAccessor.java:359)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:252)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.fireChannelClosed(AbstractContentAccessor.java:369)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.implCloseChannel(AbstractContentAccessor.java:338)<BR />&nbsp;&nbsp;&nbsp;at java.nio.channels.spi.AbstractInterruptibleChannel.close(AbstractInterruptibleChannel.java:97)<BR />&nbsp;&nbsp;&nbsp;at java.nio.channels.Channels$1.close(Channels.java:138)<BR />&nbsp;&nbsp;&nbsp;at java.io.FilterOutputStream.close(FilterOutputStream.java:143)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.util.FileCopyUtils.copy(FileCopyUtils.java:132)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.content.AbstractContentWriter.putContent(AbstractContentWriter.java:423)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importContent(ImporterComponent.java:674)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importNode(ImporterComponent.java:577)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.view.ViewParser.importNode(ViewParser.java:914)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.view.ViewParser.processEndType(ViewParser.java:878)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.view.ViewParser.processEndElement(ViewParser.java:858)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:188)<BR />&nbsp;&nbsp;&nbsp;… 21 more<BR />Caused by: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; <BR />— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml.&nbsp; <BR />— The error occurred while applying a parameter map.&nbsp; <BR />— Check the select.ContentUrlByKey-InlineParameterMap.&nbsp; <BR />— Check the statement (query failed).&nbsp; <BR />— Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'content_url_short' in 'where clause'<BR />&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:230)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:197)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:242)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.contentdata.ibatis.ContentDataDAOImpl.getContentUrlEntity(ContentDataDAOImpl.java:95)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.getOrCreateContentUrlEntity(AbstractContentDataDAOImpl.java:260)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.createContentDataEntity(AbstractContentDataDAOImpl.java:221)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.createContentData(AbstractContentDataDAOImpl.java:137)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addValueToPersistedProperties(HibernateNodeDaoServiceImpl.java:4429)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addNodePropertyImpl(HibernateNodeDaoServiceImpl.java:1446)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addNodeProperty(HibernateNodeDaoServiceImpl.java:1485)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:381)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy3.addNodeProperty(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.setPropertyImpl(DbNodeServiceImpl.java:1251)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1215)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy5.setProperty(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy5.setProperty(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor185.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)<BR />&nbsp;&nbsp;&nbsp;at $Proxy6.setProperty(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:252)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:265)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:265)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy5.setProperty(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.content.ContentServiceImpl$WriteStreamListener.contentStreamClosed(ContentServiceImpl.java:636)<BR />&nbsp;&nbsp;&nbsp;… 37 more<BR />Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; <BR />— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml.&nbsp; <BR />— The error occurred while applying a parameter map.&nbsp; <BR />— Check the select.ContentUrlByKey-InlineParameterMap.&nbsp; <BR />— Check the statement (query failed).&nbsp; <BR />— Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'content_url_short' in 'where clause'<BR />&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)<BR />&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)<BR />&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)<BR />&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)<BR />&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:244)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)<BR />&nbsp;&nbsp;&nbsp;… 94 more<BR />Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'content_url_short' in 'where clause'<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedConstructorAccessor75.newInstance(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.getInstance(Util.java:381)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)<BR />&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:229)<BR />&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)<BR />&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)<BR />&nbsp;&nbsp;&nbsp;… 100 more<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>‍</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><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>‍</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><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></BODY></HTML> Sat, 12 Sep 2009 07:34:29 GMT echidna 2009-09-12T07:34:29Z Unknown column 'content_url_short' in 'where clause' https://connect.hyland.com/t5/alfresco-archive/unknown-column-content-url-short-in-where-clause/m-p/221952#M175082 Hi folks,I hope this is the right place to post this question, if not, my apologies!I've finally got things sort of working but when I try and run the "SDK FirstFoundationClient" app I'm faced with the following error:Any ideas?Thanks, Eric.Exception in thread "main" org.alfresco.error.AlfrescoRunti Sat, 12 Sep 2009 07:34:29 GMT https://connect.hyland.com/t5/alfresco-archive/unknown-column-content-url-short-in-where-clause/m-p/221952#M175082 echidna 2009-09-12T07:34:29Z Re: Unknown column 'content_url_short' in 'where clause' https://connect.hyland.com/t5/alfresco-archive/unknown-column-content-url-short-in-where-clause/m-p/221953#M175083 <HTML><HEAD></HEAD><BODY><SPAN>Are you running it in Eclipse? Does it compile in the IDE?&nbsp; </SPAN><BR /><SPAN>It seems like it can't find a library .jar it needs.</SPAN></BODY></HTML> Wed, 14 Oct 2009 23:59:52 GMT https://connect.hyland.com/t5/alfresco-archive/unknown-column-content-url-short-in-where-clause/m-p/221953#M175083 tara_b 2009-10-14T23:59:52Z