DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null

[XINGYI WEI, geändert vor 8 Jahren.]

Hi Liferay experts,

I am keeping hit this challenging when upgrading permissions.user.check.algorithm from 2 to 5. DB2 version 9.7.

Our system is 6.0.11 EE. In order to upgrade our Liferay, I have to upgarde permissions.user.check.algorithm first.

Set permissions.user.check.algorithm = 5, restart Liferay and click "Execute" in "Legacy Permissions Migration". It keeps failure.

Please help. Anyway to bypass?

02 二月 2016 00:50:56,213 INFO  [Table:432] Finished backup of ResourcePermissionView to C:\demandtec\ts-portal\portal\d
eploy\servers\tomcat\temp/temp-db-ResourcePermissionView-1454403056197 in 16 ms
02 二月 2016 00:50:56,215 WARN  [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswo
rdportlet#ADD_TO_PAGE
02 二月 2016 00:50:56,215 WARN  [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswo
rdportlet#ADD_TO_PAGE
02 二月 2016 00:50:56,215 WARN  [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswo
rdportlet#ADD_TO_PAGE
02 二月 2016 00:50:56,216 WARN  [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswo
rdportlet#ADD_TO_PAGE
02 二月 2016 00:50:56,216 DEBUG [SessionFactoryImpl:68] Session is using connection release mode on_close
02 二月 2016 00:50:56,216 DEBUG [SQLTransformer:163] Original SQL SELECT resourceAction FROM ResourceAction resourceActi
on WHERE resourceAction.name = ? ORDER BY resourceAction.name ASC, resourceAction.bitwiseValue ASC
02 二月 2016 00:50:56,216 DEBUG [SQLTransformer:164] Modified SQL SELECT resourceAction FROM ResourceAction resourceActi
on WHERE resourceAction.name = ? ORDER BY resourceAction.name ASC, resourceAction.bitwiseValue ASC
02 二月 2016 00:50:56,219 ERROR [JDBCExceptionReporter:234] DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null,
DRIVER=3.64.106
02 二月 2016 00:50:56,220 DEBUG [BasePersistenceImpl:187] com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.
exception.DataException: could not execute query
com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.DataException: could not execute query
        at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:78)
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:60)
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
        at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findByName(ResourceActionPersistenceImpl
.java:532)
        at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findByName(ResourceActionPersistenceImpl
.java:436)
        at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.checkResourceActions(ResourceActionLocalServic
eImpl.java:65)
        at sun.reflect.GeneratedMethodAccessor94.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 com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:86)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy67.checkResourceActions(Unknown Source)
        at com.liferay.portal.service.ResourceActionLocalServiceUtil.checkResourceActions(ResourceActionLocalServiceUtil
.java:240)
        at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertToBitwise(ConvertPermissionAlgorithm.java:153)
        at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:658)
        at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44)
        at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.ja
va:47)
        at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java
:32)
        at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
        at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:59)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
        at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.exception.DataException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2536)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
        at org.hibernate.loader.Loader.list(Loader.java:2271)
        at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:940)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:68)
        ... 32 more
Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.64.
106
        at com.ibm.db2.jcc.am.bd.a(bd.java:671)
        at com.ibm.db2.jcc.am.bd.a(bd.java:60)
        at com.ibm.db2.jcc.am.bd.a(bd.java:127)
        at com.ibm.db2.jcc.am.io.c(io.java:2706)
        at com.ibm.db2.jcc.am.io.a(io.java:2170)
        at com.ibm.db2.jcc.t4.ab.o(ab.java:844)
        at com.ibm.db2.jcc.t4.ab.j(ab.java:266)
        at com.ibm.db2.jcc.t4.ab.d(ab.java:55)
        at com.ibm.db2.jcc.t4.p.c(p.java:44)
        at com.ibm.db2.jcc.t4.qb.j(qb.java:147)
        at com.ibm.db2.jcc.am.io.ib(io.java:2165)
        at com.ibm.db2.jcc.am.jo.b(jo.java:4381)
        at com.ibm.db2.jcc.am.jo.b(jo.java:4511)
        at com.ibm.db2.jcc.am.jo.ec(jo.java:735)
        at com.ibm.db2.jcc.am.jo.executeQuery(jo.java:708)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2533)
        ... 39 more
02 二月 2016 00:50:56,227 DEBUG [EventsProcessorImpl:53] Process event com.liferay.portal.events.SessionDestroyAction
02 二月 2016 00:50:56,228 DEBUG [SessionDestroyAction:30] CEEE903BBBB55834416B8AD0D2C03CC4
02 二月 2016 00:50:56,228 FATAL [ConvertProcessMessageListener:35] Unable to process message {destinationName=liferay/co
nvert_process, response=null, responseDestinationName=null, responseId=null, payload=com.liferay.portal.convert.ConvertP
ermissionAlgorithm, values=null}
com.liferay.portal.convert.ConvertException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.ker
nel.dao.orm.ORMException: org.hibernate.exception.DataException: could not execute query
        at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:53)
        at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.ja
va:47)
        at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java
:32)
        at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
        at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:59)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
        at java.lang.Thread.run(Thread.java:662)
Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibe
rnate.exception.DataException: could not execute query
        at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:190
)
        at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findByName(ResourceActionPersistenceImpl
.java:536)
        at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findByName(ResourceActionPersistenceImpl
.java:436)
        at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.checkResourceActions(ResourceActionLocalServic
eImpl.java:65)
        at sun.reflect.GeneratedMethodAccessor94.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 com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:86)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy67.checkResourceActions(Unknown Source)
        at com.liferay.portal.service.ResourceActionLocalServiceUtil.checkResourceActions(ResourceActionLocalServiceUtil
.java:240)
        at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertToBitwise(ConvertPermissionAlgorithm.java:153)
        at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:658)
        at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44)
        ... 7 more
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.DataException: could not execute quer
y
        at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:78)
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:60)
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:52)
        at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findByName(ResourceActionPersistenceImpl
.java:532)
        ... 29 more
Caused by: org.hibernate.exception.DataException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2536)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
        at org.hibernate.loader.Loader.list(Loader.java:2271)
        at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:940)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:68)
        ... 32 more
Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.64.
106
        at com.ibm.db2.jcc.am.bd.a(bd.java:671)
        at com.ibm.db2.jcc.am.bd.a(bd.java:60)
        at com.ibm.db2.jcc.am.bd.a(bd.java:127)
        at com.ibm.db2.jcc.am.io.c(io.java:2706)
        at com.ibm.db2.jcc.am.io.a(io.java:2170)
        at com.ibm.db2.jcc.t4.ab.o(ab.java:844)
        at com.ibm.db2.jcc.t4.ab.j(ab.java:266)
        at com.ibm.db2.jcc.t4.ab.d(ab.java:55)
        at com.ibm.db2.jcc.t4.p.c(p.java:44)
        at com.ibm.db2.jcc.t4.qb.j(qb.java:147)
        at com.ibm.db2.jcc.am.io.ib(io.java:2165)
        at com.ibm.db2.jcc.am.jo.b(jo.java:4381)
        at com.ibm.db2.jcc.am.jo.b(jo.java:4511)
        at com.ibm.db2.jcc.am.jo.ec(jo.java:735)
        at com.ibm.db2.jcc.am.jo.executeQuery(jo.java:708)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2533)
        ... 39 more

[Jonas Choi, geändert vor 8 Jahren.]

The error message seems to indicate that it tried to make a change to something, but it's not of sufficient size. Most likely the last SQL statement

Modified SQL SELECT resourceAction FROM ResourceAction resourceAction WHERE resourceAction.name = ? ORDER BY resourceAction.name ASC, resourceAction.bitwiseValue ASC

IBM documentation explaining the issue. I doubt it's the exact same column/field but the principles are there.
http://www-01.ibm.com/support/docview.wss?uid=swg21663236

As mentioned in the link, the default column length in DB2 is 3000 characters, and what's being changed here is bigger than that.

If you have 6.0.11 EE, you should also have access to Liferay Customer Portal, so grab any and all patches available for 6.0.11 (6.0 EE SP1). If you have a Subscription Support Level of Gold or Platinum, open a ticket with Liferay Support.