{"id":5266,"date":"2023-02-16T15:12:46","date_gmt":"2023-02-16T09:42:46","guid":{"rendered":"https:\/\/blog.tenthplanet.in\/?p=5266"},"modified":"2026-07-03T13:52:12","modified_gmt":"2026-07-03T08:22:12","slug":"how-to-migrate-compiere-erp-to-3-8-19-version","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/blogs\/how-to-migrate-compiere-erp-to-3-8-19-version\/","title":{"rendered":"How to Migrate Compiere ERP to 3.8.19 Version?"},"content":{"rendered":"

Use the instructions below to migrate <\/span>Compiere ERP<\/span><\/b><\/a> from any lower version to Compiere 3.8.19.<\/span>\u00a0<\/span><\/p>\n

Prerequisites<\/span><\/b>\u00a0<\/span><\/h2>\n

The following are the prerequisites for migrating Compiere 3.8.19:<\/span>\u00a0<\/span><\/p>\n

    \n
  • A valid support contract<\/span>\u00a0<\/span><\/li>\n
  • Java JDK 8 or OpenJDK 8 (Not just JRE)<\/span>\u00a0<\/span><\/li>\n
  • Database Oracle XE, Oracle 10g Release 2, Oracle 11g Release 2, Oracle 12c or EnterpriseDB Postgres Plus Advanced Server 8.4 or later<\/span><\/li>\n<\/ul>\n

    \"\"<\/p>\n

    Preserving Customizations in Compiere ERP<\/span><\/b>\u00a0<\/span><\/h2>\n

    Compiere ERP will not change any customizations you did if you have properly marked it as customizations. By default, all records added to the dictionary will have the entity type “User Maintained”.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

    \"\"<\/p>\n

    For changes to existing dictionary records, select Customizations in the Change Audit window to denote the updates which has to be preserved before initiating the migration process. To confirm whether all the updated dictionary records have been updated to preserve these customizations, run the process in test mode before commencing the migration.<\/span>\u00a0<\/span><\/p>\n

    Compiere ERP Migration Process<\/span><\/b>\u00a0<\/span><\/h2>\n

    Compiere ERP migration process consists of the following steps:<\/span>\u00a0<\/span><\/p>\n

      \n
    • Preparation<\/span>\u00a0<\/span><\/li>\n
    • Test Mode (optional)<\/span>\u00a0<\/span><\/li>\n
    • Migrate to a New Release<\/span>\u00a0<\/span><\/li>\n<\/ul>\n

      Preparation<\/span><\/b>\u00a0<\/span><\/h3>\n

      Verify the following before you initiate the migration process:<\/span><\/p>\n

        \n
      • Server access to internet for http (port 80) and https (port 443).<\/span>\u00a0<\/span><\/li>\n
      • Stop the application server by executing utils\/RUN_Server2Stop.<\/span>\u00a0<\/span><\/li>\n
      • Back up the database.<\/span>\u00a0<\/span><\/li>\n<\/ul>\n

        \u00a0<\/span>If you are running EnterpriseDB 8.2 or earlier, upgrade it to EnterpriseDB Postgres Plus Advanced Server 8.3.<\/span>\u00a0<\/span><\/p>\n

        Test Mode (optional)<\/span><\/b>\u00a0<\/span><\/h3>\n

        This is an optional step where you can run the migration task in test mode. This helps you to review and find out the precautionary steps to take while running it against the database in live.\u00a0<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

        Note:<\/span><\/b> In test mode, resolve ID conflicts will not show the correct future IDs<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

        You may encounter some errors in test mode because the database changes are not being executed. Also, you can evaluate the schema changes to be made.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

        For a regular migration, follow the \u201cRUN_setup\u201d steps as such given in the next section. In Step 18, do not forget to select the \u201cTest Only\u201d box.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

        If the program mentions some of the tables which you needed for deletion, just recreate those tables in the data dictionary (Window Table \/ Column) with the Entity Type as \u201cUser Defined\u201d or with an entity type of your own.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

        If the program marks few required columns for deletion, ensure that the column has the Entity Type as \u201cUser\u201d or \u201cApplication\u201d. If the required column has the Entity Type as \u201cData Dictionary\u201d or \u201cCompiere\u201d and marked for deletion as well, then copy it with some other name and mark the new column as \u201cCustom\u201d or \u201cApplication\u201d. The same applies to windows, tabs, fields, and so on.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

        The Mandatory User or Application Columns must have a default value defined.<\/span>\u00a0<\/span><\/p>\n

        Migrating Compiere ERP to 3.8.19<\/span><\/b>\u00a0<\/span><\/h2>\n

        Are you migrating to Compiere 3.8.19 by using JBoss as the application server? JBoss will not be available in the Compiere installation package. You have to remove the folder name \u201cJBoss\u201d from the \u201ccompiere2\u201d folder on your machine. Please refer to the screenshot given below.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

        For migrating from 3.0.x, you have to remove all the .car files from the folder Compiere2\/data too.<\/span>\u00a0<\/span><\/p>\n

        \"\"\u00a0<\/span><\/p>\n

        Steps to migrate to Compiere 3.8.19:<\/span><\/b><\/h3>\n
          \n
        1. Download and unzip\/untar the distribution file (Ex: Compiere_3.8.19.zip). Ensure to overwrite any existing files.<\/span><\/li>\n
        2. Execute \u201cRUN_setup\u201d.<\/span><\/li>\n
        3. In the Deployment field, ensure that the location where the application server is installed on your machine is specified. For example, C:\\wildfly-8.2.0.Final.<\/span><\/li>\n<\/ol>\n

          \u00a0<\/span>\u00a0\"\"<\/span><\/p>\n

            \n
          1. Review all the environment settings and click \u201cSave\u201d.<\/span><\/li>\n<\/ol>\n

            While validating the parameters, a red icon will show right next to the parameter that has error. Fix the error by making changes, click \u201cTest\u201d to validate again, and then click \u201cSave\u201d.<\/span>\u00a0<\/span><\/p>\n

            \u00a0\"\"<\/span><\/p>\n

              \n
            1. Click Yes, I Understand and Accept.<\/span><\/li>\n<\/ol>\n

              If security key file is not set, the following prompt appears.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

              \u00a0\"\"<\/span><\/p>\n

                \n
              1. Click OK.<\/span><\/li>\n
              2. If you are a new customer, fill in all the needed information. If you are an existing customer, provide all the subscriber information (System Name, Email and Password) same as while\u00a0 registering in the Compiere Web Store so that you can get a complete list of applications.<\/span><\/li>\n
              3. Click \u201cCheck available Applications\u201d to get a list of applications available for installation.<\/span><\/li>\n<\/ol>\n

                \u00a0\"\"<\/span><\/p>\n

                Note:<\/span><\/b> For installing additional applications in latest the Compiere Core version post-installation or migration, you have to choose Compiere Core plus and any additional applications to install, and then run the Migration process. Compiere Standard is the core application that must \u201calways\u201d be installed or migrated to the latest release, but you can also select additional applications provided by Compiere or any of our authorized partners.<\/span>\u00a0<\/span><\/p>\n

                  \n
                1. Choose the applications you would like to migrate and click \u201cReinstall\/Migrate\u201d. If you do not want to install or migrate any of the applications listed, change the action to \u201cNone\u201d. To install new applications, change the action to \u201cNew Install”.<\/span><\/li>\n<\/ol>\n

                  Note:<\/span><\/b> On giving incorrect email or password, or no internet connection, you can\u2019t select Compiere Enterprise, or any other optional components.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

                    \n
                  1. Next, read and accept the Compiere Public License Agreement. To accept, click \u201cYes, I Understand and Accept”.<\/span><\/li>\n<\/ol>\n

                    You might get more than one license agreement depending on the applications that you are installing.\u00a0 Note that XUOM is a sample application extension.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

                    \u00a0\"\"<\/span><\/p>\n

                      \n
                    1. For Compiere Enterprise edition installation, read and accept the commercial license agreement.<\/span><\/li>\n
                    2. Click Start File Installation.<\/span><\/li>\n<\/ol>\n

                      \u00a0\"\"<\/span><\/p>\n

                        \n
                      1. When the file installation is complete, click Start Migrate Database.<\/span><\/li>\n<\/ol>\n

                        \u00a0\"\"<\/span><\/p>\n

                          \n
                        1. Enter the System Name, Registered Email, and Password. The data entered must match the Compiere Web store registration details.<\/span><\/li>\n
                        2. Click \u201cCheck License\u201d to validate your asset information.<\/span><\/li>\n<\/ol>\n

                          Note:<\/span><\/b> The asset information may already be included if it was entered in the system window.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

                          \u00a0\"\"<\/span><\/p>\n

                          If you get the \u201cCore Invalid\u201d error after clicking “Check License”, it denotes that you did not select the appropriate action for the core component. If so, close the setup and support windows, and execute RUN_setup file again and select Standard plus or any other component for installation.<\/span>\u00a0<\/span><\/p>\n

                            \n
                          1. Click Start Migration.<\/span><\/li>\n<\/ol>\n

                            \"\"<\/span><\/p>\n

                              \n
                            1. Click \u201cYes” in the Compiere Version Migration Prompt.<\/span><\/li>\n<\/ol>\n

                              \u00a0\"\"<\/span><\/p>\n

                                \n
                              1. Click \u201cStart\u201d.\u00a0<\/span><\/li>\n<\/ol>\n

                                Note:<\/span><\/b> Do not select Test Only check box.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

                                \u00a0\"\"<\/span><\/p>\n

                                  \n
                                1. Click \u201cYes\u201d to confirm that you do have a backup of your database.<\/span><\/li>\n<\/ol>\n

                                  \"\"<\/span>\u00a0<\/span><\/p>\n

                                    \n
                                  1. Click \u201cYes\u201d to confirm that the Source and Target database versions from the Compiere Version Migration window are correct.<\/span><\/li>\n<\/ol>\n

                                    \u00a0\"\"<\/span><\/p>\n

                                      \n
                                    1. Check if the migration process has been finished without any errors and the message, \u201cMigration Done\u201d appears.<\/span><\/li>\n<\/ol>\n

                                      Note:<\/span><\/b> If you get any errors, review the <\/span>list of known issues<\/span><\/b> listed in this document before logging a service request.<\/span>\u00a0<\/span><\/p>\n

                                      \u00a0\"\"<\/span><\/p>\n

                                        \n
                                      1. Review the following log files for errors in the Compiere2 folder:<\/span><\/li>\n<\/ol>\n

                                        \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 a. Migrate_yyyy_mm_dd_hh_mi_ss.log: Complete logs file of the migration process.<\/span>
                                        \n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 b. Migrate_yyyy_mm_dd_hh_mi_ss.err.log: A subset of log with just errors.<\/span>
                                        \n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 c. yyyy-mm-dd_#.log: Possible additional errors not printed to the migration log. Ex: Search for the file with the text “Compiere Migration 3.8”)<\/span><\/p>\n

                                        Note:<\/span><\/b> If you get any errors, review the <\/span>list of known issues<\/span><\/b> listed in this document before logging a service request.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

                                          \n
                                        1. If you have a Compiere Enterprise Edition license, execute utils\/RUN_Support, and click \u201cCheck License\u201d to activate your license.<\/span><\/li>\n<\/ol>\n

                                          \"\"<\/span>\u00a0<\/span><\/p>\n

                                            \n
                                          1. Click the \u201cCheck License\u201d button to see whether your Enterprise License is activated.<\/span><\/li>\n<\/ol>\n

                                            \u00a0\"\"<\/span><\/p>\n

                                              \n
                                            1. Click \u201cClose\u201d after the Compiere Enterprise license is updated.<\/span><\/li>\n<\/ol>\n

                                              Note:<\/span><\/b> Do not click Start Migration.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

                                                \n
                                              1. Start the application server.<\/span><\/li>\n<\/ol>\n

                                                To start the Compiere web user interface after migration, empty the browser cache first.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

                                                Contact TenthPlanet, If you are Looking for a Service Provider to Migrate Your Compiere ERP to 3.8.19.<\/span><\/b><\/h2>\n","protected":false},"excerpt":{"rendered":"

                                                Get to know the steps to migrate your Compiere ERP from lower version to latest version 3.8.19<\/p>\n","protected":false},"author":23,"featured_media":5323,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[350],"tags":[420],"class_list":["post-5266","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-compiere","tag-compiere-erp-migration"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/5266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/comments?post=5266"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/5266\/revisions"}],"predecessor-version":[{"id":11379,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/5266\/revisions\/11379"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media\/5323"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media?parent=5266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/categories?post=5266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/tags?post=5266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}