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

VerifyCalendar in Liferay 6.2 fails during an Oracle upgrade when recurrence of the Calendar portlet contains a value over 4000 characters in length

    Details

      Description

      Upgrade Steps:
      1. in 6.1.20 (6.1 GA2) sign in as test@liferay.com and navigate to "Manage My Account"
      2. go to the Display Settings and set Time Zone to "(UTC -09:00) Alaska Standard Time"
      3. on localhost:8080/web/guest/home, add a Calendar portlet to the page
      4. create an event with Time Zone Sensitive enabled and daily repeating event with an end date
      5. run the following in the Oracle database, over 4000 characters should be the result:

      select length(recurrence) from calevent;
      

      6. shut down the server, and run an upgrade to a 6.2.10 server with following portal-ext.properties:

      jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
      jdbc.default.url=jdbc:oracle:thin:@[ip-address]:1521:orcl
      jdbc.default.username=username
      jdbc.default.password=password
      jdbc.default.liferay.pool.provider=dbcp
      
      passwords.encryption.algorithm.legacy=SHA
      

      Actual Behavior: After the upgrade process, the verify fails due to CAST_TEXT being used within the verifyEndDate() method. A CLOB value is unable to be compared against a VARCHAR(4000) which causes:

      ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4371, maximum: 4000)_ [Sanitized]
      

      Expected Behavior: Verify process should be successful and the portal should be able to start up.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  5 years, 48 weeks ago

                  Packages

                  Version Package
                  6.1.X EE
                  6.2.1 CE GA2
                  6.2.X EE