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

Size for column description in App table of Marketplace Plugin may not be enough in DB2

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Won't Fix
    • Affects Version/s: 6.2.10 EE GA1, 6.2.X EE, 7.0.0 M5
    • Fix Version/s: None
    • Labels:
      None
    • Fix Priority:
      3

      Description

      The column marketplace_app.description has a size of VARCHAR(4000) in DB2 (VARCHAR(750) in 6.2.x) and this length may not be enough since that field can contain an arbitrary amount of characters from the property description of the liferay-marketplace.properties file. An example of this is Ehcache Cluster EE plugin whose description length is 981.

      Steps to reproduce: (in 6.2)

      1. Configure the portal to use DB2 database.
      2. Install the Ehcache Cluster EE plugin.

      Actual behaviour:

      • Button shows the message Please Wait...
      • An exception similar to this is shown:
      14:27:02,309 ERROR [http-bio-8080-exec-16][JDBCExceptionReporter:82] [jcc][t4][102][10040][3.63.123] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch._Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null [Sanitized]
      14:27:02,311 ERROR [http-bio-8080-exec-16][JDBCExceptionReporter:82] Error for batch element #1: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.63.123
      

      Expected behaviour:
      Plugin is installed successfully

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ryan.park Ryan Park
                Reporter:
                daniel.couso Daniel Couso
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 44 weeks, 2 days ago

                  Packages

                  Version Package