Issue 88 in maven-alfresco-archetypes: Misc Issues while running mvn install -Prun on new archetypes version

[maven-alfres...@googlecode.com]

Status: Assigned
Owner: colum...@gmail.com
Labels: Type-Defect Priority-Medium Milestone-Release4x

New issue 88 by colum...@gmail.com: Misc Issues while running mvn install
-Prun on new archetypes version
http://code.google.com/p/maven-alfresco-archetypes/issues/detail?id=88

Using
http://maven-alfresco-archetypes.googlecode.com/svn/branches/experimental/alfresco-lifecycle-aggregator/
and running

mvn install -Prun (run Alfresco (with dependent amp), Solr, Share in
embedded Jetty, against H2 emulating Postrgresql)

All starts up fine, but I still get runtime errors.

Logging here all the different issues I found out at runtime.

[maven-alfres...@googlecode.com]

Comment #1 on issue 88 by colum...@gmail.com: Misc Issues while running

mvn install -Prun on new archetypes version
http://code.google.com/p/maven-alfresco-archetypes/issues/detail?id=88

SubIssue I --> iBatis

While, after some struggling, now it all works with one command, when I log
in in Share and try to remove the help dashlet, the click fails silently
and in the log I get the ugly iBatis exception below.

I'm guessing it's something related to being running an unsupported,
embedded Jetty against H2 emulation of Postgres via [1]. Am I on the right
track....Carlo ?

:)))

Thanks,

Gab

[1] https://github.com/skuro/alfresco-h2-support

~~~o0 alfresco.log 0o~~~
2012-06-04 10:52:52,872 ERROR [extensions.webscripts.AbstractRuntime]
[317099593@qtp-1830123223-13] Exception from executeScript - redirecting to
status template error: 05040101 Failed to execute query:
Namespace: alfresco.node
queryName: select_GetChildrenCannedQueryWithoutProps
Parameter:
org.alfresco.repo.node.getchildren.FilterSortNodeEntity@4179e322
Offset: 0
Limit: 2147483647
org.alfresco.repo.domain.query.QueryException: 05040101 Failed to execute
query:
Namespace: alfresco.node
queryName: select_GetChildrenCannedQueryWithoutProps
Parameter:
org.alfresco.repo.node.getchildren.FilterSortNodeEntity@4179e322
Offset: 0
Limit: 2147483647
at
org.alfresco.repo.domain.query.ibatis.CannedQueryDAOImpl.executeQuery(CannedQueryDAOImpl.java:218)
at
org.alfresco.repo.node.getchildren.GetChildrenCannedQuery.queryAndFilter(GetChildrenCannedQuery.java:274)
at
org.alfresco.query.AbstractCannedQuery.execute(AbstractCannedQuery.java:81)
at
org.alfresco.repo.model.filefolder.FileFolderServiceImpl.listImpl(FileFolderServiceImpl.java:493)
at
org.alfresco.repo.model.filefolder.FileFolderServiceImpl.list(FileFolderServiceImpl.java:467)
at sun.reflect.GeneratedMethodAccessor511.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.alfresco.repo.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:125)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.alfresco.repo.model.filefolder.MLTranslationInterceptor.invoke(MLTranslationInterceptor.java:267)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:147)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.alfresco.repo.model.filefolder.FilenameFilteringInterceptor.invoke(FilenameFilteringInterceptor.java:275)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy76.list(Unknown Source)
at
org.alfresco.repo.web.scripts.bean.ADMRemoteStore.outputFileNodes(ADMRemoteStore.java:842)
at
org.alfresco.repo.web.scripts.bean.ADMRemoteStore.access$600(ADMRemoteStore.java:80)
at
org.alfresco.repo.web.scripts.bean.ADMRemoteStore$6.doWork(ADMRemoteStore.java:566)
at
org.alfresco.repo.web.scripts.bean.ADMRemoteStore$6.doWork(ADMRemoteStore.java:524)
at
org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
at
org.alfresco.repo.web.scripts.bean.ADMRemoteStore.listDocuments(ADMRemoteStore.java:523)
at
org.alfresco.repo.web.scripts.bean.BaseRemoteStore.execute(BaseRemoteStore.java:276)
at
org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:393)
at
org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at
org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:462)
at
org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:500)
at
org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:275)
at
org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:372)
at
org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
at
org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1221)
at
org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.springframework.dao.DataIntegrityViolationException:
### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Error in
LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id =
childNode.store_id)

join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id
= ?)

where
assoc.parent_node_id = ?

and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)


and prop4.string_value like ?
escape '\\'



order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
### The error may involve
alfresco.node.select_GetChildrenCannedQueryWithoutProps-Inline
### The error occurred while setting parameters
### Cause: org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL
statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id =
childNode.store_id)

join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id
= ?)

where
assoc.parent_node_id = ?

and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)


and prop4.string_value like ?
escape '\\'



order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
; SQL []; Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id =
childNode.store_id)

join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id
= ?)

where
assoc.parent_node_id = ?

and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)


and prop4.string_value like ?
escape '\\'



order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]; nested exception is
org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id =
childNode.store_id)

join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id
= ?)

where
assoc.parent_node_id = ?

and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)


and prop4.string_value like ?
escape '\\'



order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
at $Proxy16.select(Unknown Source)
at
org.mybatis.spring.SqlSessionTemplate.select(SqlSessionTemplate.java:210)
at
org.alfresco.repo.domain.query.ibatis.CannedQueryDAOImpl.executeQuery(CannedQueryDAOImpl.java:204)
... 62 more
Caused by: org.h2.jdbc.JdbcSQLException: Error in LIKE ESCAPE: "\\"; SQL
statement:
select
childNode.id as id,
childStore.protocol as protocol,
childStore.identifier as identifier,
childNode.uuid as uuid
from
alf_child_assoc assoc
join alf_node childNode on (childNode.id = assoc.child_node_id)
join alf_store childStore on (childStore.id =
childNode.store_id)

join alf_node_properties prop4 on (prop4.node_id = childNode.id)
join alf_qname qname on (prop4.qname_id = qname.id and qname.id
= ?)

where
assoc.parent_node_id = ?

and childNode.type_qname_id in
(
?
,
?
,
?
,
?
,
?
,
?
)


and prop4.string_value like ?
escape '\\'



order by
assoc.assoc_index ASC,
assoc.id ASC [22025-158]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.expression.CompareLike.getEscapeChar(CompareLike.java:143)
at org.h2.expression.CompareLike.optimize(CompareLike.java:113)
at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:127)
at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:126)
at org.h2.command.dml.Select.prepare(Select.java:797)
at
org.h2.command.CommandContainer.recompileIfRequired(CommandContainer.java:61)
at org.h2.command.CommandContainer.query(CommandContainer.java:77)
at org.h2.command.Command.executeQuery(Command.java:181)
at
org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:177)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
at
org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120)
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:94)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:84)
at sun.reflect.GeneratedMethodAccessor218.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

[maven-alfres...@googlecode.com]

Comment #2 on issue 88 by colum...@gmail.com: Misc Issues while running

mvn install -Prun on new archetypes version
http://code.google.com/p/maven-alfresco-archetypes/issues/detail?id=88

The changes above happen randomly.

[maven-alfres...@googlecode.com]

Updates:
Status: Fixed
Labels: -Milestone-Release4x Milestone-Release-sdk-1.0.0

Comment #3 on issue 88 by colum...@gmail.com: Misc Issues while running

mvn install -Prun on new archetypes version
http://code.google.com/p/maven-alfresco-archetypes/issues/detail?id=88

fixed switching to 1.5 of h2-support.