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

Table ResourcePermission contains 1 records with an invalid company ID

    Details

    • Fix Priority:
      4

      Description

      Steps to Reproduce:

      1. Start portal connected to MySQL with portal property "database.partition.enabled=true"
      2. Create a new virtual instance
      3. Navigate to portal source directory on your local system
      4. Execute
      ant -f build-test.xml validate-db-partition-schemas -Dschema.name.prefix=lpartition_

      Expected Result:
      DB partition schema validation passes.

      Actual Result:
      Validation fails

      Validating schema lportal for company ID 20100
      Table ResourcePermission contains 1 records with an invalid company ID
      Validating schema lpartition_41242 for company ID 41242
      Validation passed successfully for schema lpartition_41242
      

      I checked for different company ID with

      SELECT companyId,name FROM ResourcePermission WHERE companyId NOT LIKE '%20100%';
      

      Returns

      +-----------+-------------------------------------------------------------------+
      | companyId | Name                                                              |
      +-----------+-------------------------------------------------------------------+
      |     41242 | com_liferay_staging_processes_web_portlet_StagingProcessesPortlet |
      +-----------+-------------------------------------------------------------------+
      1 row in set (0.00 sec)
      

      Known failure range
      https://github.com/liferay/liferay-portal/compare/2102855b9b950e1f198cb9f83840dc928d16766f...7c901ebe856d24d1b410d059938d12ac0b5de099

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              victor.ware Victor Ware
              Reporter:
              victor.ware Victor Ware
              Participants of an Issue:
              Recent user:
              Maria Muriel
              Engineering Assignee:
              Kevin Lee
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                2 weeks, 5 days ago

                  Packages

                  Version Package
                  Master