Uploaded image for project: 'Alfresco One Platform'
  1. Alfresco One Platform
  2. ACE-3418

Oracle 12c: ALF: 48 unexpected differences are returned after schema bootstrap (clean start)

    Details

    • Type: Bug
    • Status: Verified (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 5.0
    • Fix Version/s: 5.0
    • Labels:
    • Environment:
      Alfresco Enterprise v5.0.0 (r89901-b282).
      Server: RHEL 6.5 X64, Oracle 12c (v12.1.0.2.0), ojdbc7.jar, Apache Tomcat 7.0.53, JDK 7 U67 X64

      Description

      48 unexpected differences are returned after schema bootstrap (clean start):

       2014-11-05 14:35:19,402  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 48 potential problems, results written to: /data/upgrade/500/tomcat/temp/Alfresco/Alfresco-AlfrescoOracle9Dialect-Validation-Post-Upgrade-alf_-29470968538667301.txt
      
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_ACCESS_CONTROL_ENTRY_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_ACCESS_CONTROL_LIST_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_ACE_CONTEXT_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_ACL_CHANGE_SET_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_ACL_MEMBER_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_ACTIVITY_FEED_CONTROL_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_ACTIVITY_FEED_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_ACTIVITY_POST_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_AUDIT_APP_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_AUDIT_ENTRY_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_AUDIT_MODEL_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_AUTHORITY_ALIAS_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_AUTHORITY_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_CHILD_ASSOC_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_CONTENT_DATA_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_CONTENT_URL_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_CONTENT_URL_ENC_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_ENCODING_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_LOCALE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_LOCK_RESOURCE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_LOCK_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_MIMETYPE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_NAMESPACE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_NODE_ASSOC_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_NODE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PERMISSION_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PROP_CLASS_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PROP_DATE_VALUE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PROP_DOUBLE_VALUE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PROP_LINK_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PROP_ROOT_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PROP_SERIAL_VALUE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PROP_STRING_VALUE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PROP_UNIQUE_CTX_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_PROP_VALUE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_QNAME_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_SERVER_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_STORE_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_TRANSACTION_SEQ
      Difference: missing sequence from database, expected at path: ALFRESCO.ALF_USAGE_DELTA_SEQ
      Difference: expected primary key ALFRESCO.alf_content_url_encryption.PRIMARY.name="PRIMARY", but was ALFUPG.ALF_CONTENT_URL_ENCRYPTION.SYS_C0026013.name="SYS_C0026013"
      Difference: expected primary key ALFRESCO.alf_content_url_encryption.PRIMARY.columnNames[0]="id", but was ALFUPG.ALF_CONTENT_URL_ENCRYPTION.SYS_C0026013.columnNames[0]="ID"
      Difference: missing foreign key from database, expected at path: ALFRESCO.alf_content_url_encryption.fk_alf_cont_enc_url
      Difference: unexpected foreign key found in database with path: ALFUPG.ALF_CONTENT_URL_ENCRYPTION.FK_ALF_CONT_ENC_URL
      Difference: missing index from database, expected at path: ALFRESCO.alf_content_url_encryption.idx_alf_cont_enc_url
      Difference: missing index from database, expected at path: ALFRESCO.alf_content_url_encryption.idx_alf_cont_enc_mka
      Difference: unexpected index found in database with path: ALFUPG.ALF_CONTENT_URL_ENCRYPTION.IDX_ALF_CONT_ENC_URL
      Difference: unexpected index found in database with path: ALFUPG.ALF_CONTENT_URL_ENCRYPTION.IDX_ALF_CONT_ENC_MKA
      


      ChristinaSh

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs
                  Reporter:
                  alfrescoqa Alfresco QA Team
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  12 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 1 day, 4 hours
                    1d 4h

                      Structure Helper Panel