Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-141945

DB2 SQL Error after publishing publications with message board on DB2 11.1

Details

    Description

      Steps to reproduce

      1. Enable Publications
      2. Add a new publication "P1"
      3. Add a new message board
      4. Add a reply for the message board
      5. Navigate to Publications Admin
      6. Review the Changes
      7. Publish the publication with JSONWS API
        curl -X POST -u '[email protected]:test' -d 'ctCollectionId=1' -d 'userId=20127' http://localhost:8080/api/jsonws/ct.ctcollection/publish-ct-collection
      8. Navigate to Publications History tab with URL
        http://localhost:8080/group/control_panel/manage?p_p_id=com_liferay_change_tracking_web_portlet_PublicationsPortlet&p_p_lifecycle=0&p_p_state=maximized&p_p_mode=view&_com_liferay_change_tracking_web_portlet_PublicationsPortlet_mvcRenderCommandName=%2Fchange_tracking%2Fview_history

      Actual Result:
      Publication fails to publishe and DB2 SQL Error throws.

      2021-11-01 23:28:29.884 ERROR [liferay/background_task-8][BackgroundTaskMessageListener:182] Unable to execute background task
      com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=5;ROOT.PORTLETPREFERENCES, DRIVER=4.24.92
      	at com.ibm.db2.jcc.am.b6.a(b6.java:806) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.am.b6.a(b6.java:66) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.am.b6.a(b6.java:140) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.am.k3.b(k3.java:2464) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.am.k3.c(k3.java:2445) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.t4.ab.n(ab.java:894) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.t4.ab.a(ab.java:119) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.t4.p.a(p.java:50) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.t4.aw.b(aw.java:220) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.am.k4.bm(k4.java:3571) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.am.k4.a(k4.java:4616) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.am.k4.b(k4.java:4154) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.am.k4.be(k4.java:821) ~[db2jcc4.jar:?]
      	at com.ibm.db2.jcc.am.k4.executeUpdate(k4.java:795) ~[db2jcc4.jar:?]
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[hikaricp.jar:?]
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?]
      	at com.liferay.change.tracking.internal.background.task.CTServicePublisher._updateCTCollectionId(CTServicePublisher.java:324) ~[?:?]
      	at com.liferay.change.tracking.internal.background.task.CTServicePublisher._publish(CTServicePublisher.java:185) ~[?:?]
      	at com.liferay.portal.service.base.PortletPreferencesLocalServiceBaseImpl.updateWithUnsafeFunction(PortletPreferencesLocalServiceBaseImpl.java:526) ~[portal-impl.jar:?]
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_121]
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_121]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_121]
      	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_121]
      	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
      	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
      	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
      	at com.sun.proxy.$Proxy79.updateWithUnsafeFunction(Unknown Source) ~[?:?]
      	at com.liferay.change.tracking.internal.background.task.CTServicePublisher.publish(CTServicePublisher.java:86) ~[?:?]
      	at com.liferay.change.tracking.internal.background.task.CTPublishBackgroundTaskExecutor.execute(CTPublishBackgroundTaskExecutor.java:169) ~[?:?]
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_121]
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_121]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_121]
      	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_121]
      	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
      	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
      	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80) ~[?:?]
      	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
      	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
      	at com.sun.proxy.$Proxy654.execute(Unknown Source) ~[?:?]
      	at com.liferay.portal.background.task.internal.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:63) ~[?:?]
      	at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:41) ~[portal-kernel.jar:?]
      	at com.liferay.portal.background.task.internal.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:72) ~[bundleFile:?]
      	at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:136) [bundleFile:?]
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.doReceive(BaseMessageListener.java:48) [portal-kernel.jar:?]
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:34) [portal-kernel.jar:?]
      	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74) [portal-kernel.jar:?]
      	at com.liferay.portal.messaging.internal.ParallelDestination$1.run(ParallelDestination.java:56) [bundleFile:?]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_121]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_121]
      

      Attachments

        Activity

          People

            linda.sui Linda Sui
            linda.sui Linda Sui
            Kiyoshi Lee Kiyoshi Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              40 weeks, 1 day ago

              Packages

                Version Package
                Master