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

Cannot add organizations in certain casese caused by Numeric Overflow exception

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: No Longer Reproducible
    • Affects Version/s: 5.2.3
    • Fix Version/s: 6.0.6 GA
    • Component/s: Environments > Databases
    • Labels:
      None

      Description

      For example below in a sample of our production data, the leftOrganizationId and rightOrganizationId column values are so large I believe they are throwing an exception in the getLastRightOrganizationId method of the com.liferay.portal.service.persistence.OrganizationPersistenceImpl class:

      7492237,10121,11717,1990,1991,01769000,regular-organization,1,0,0,12017,

      7492245,10121,7492237,1.29385074514233E19,8.93731168670628E16,01769000-YL-7,regular-organization,1,0,0,12017,

      7492254,10121,7492237,1.3091341456612E19,8.93731168670628E16,01769000-YL-8,regular-organization,1,0,0,12017,

      7492266,10121,7492237,1.29385074514233E19,8.93731168670628E16,01769000-YL-9,regular-organization,1,0,0,12017,

      First problem, how did the leftOrganizationId and rightOrganizationId column values get so large when the parent organization id 7492237 leftOrganizationId and rightOrganizationId column values are only 1990 and 1991.

      Second problem, the numeric overflow exception might possibly be caused in the getLastRightOrganizationId method of the com.liferay.portal.service.persistence.OrganizationPersistenceImpl class when converting a value 8.93731168670628E16 to a long?

        Attachments

          Activity

            People

            Assignee:
            zsolt.balogh Zsolt Balogh
            Reporter:
            adorjan.nagy Adorjan Nagy (Inactive)
            Participants of an Issue:
            Recent user:
            Esther Sanz
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              11 years, 1 week, 3 days ago

                Packages

                Version Package
                6.0.6 GA