7 Replies Latest reply: Apr 5, 2013 8:03 AM by DavidGreenfield RSS

    Multiple Cubes refresh in parallel

    user9134685
      Hi

      I have an analytical workspace where i have modelled a set of conformed dimensions and some dimensions specific to specific subject areas. There will be multiple cubes (Partitioned and some non partitioned) in this analytical workspace.

      Would like to know if these cubes can be refreshed in parallel. I have tried using DBMS_CUBE provided parallelism parameter and kicked off 2 cubes refresh but when i check the cube_build_log, the slave process is always 0 and the execution seems to have happened in serial.

      Please suggest how these cubes can be refreshed in parallel.

      Thanks
        • 1. Re: Multiple Cubes refresh in parallel
          Nasar-Oracle
          Post the DBMS_CUBE.BUILD statement that you used,
          as well some information about cubes (their dimensionality and partitions).
          .
          • 2. Re: Multiple Cubes refresh in parallel
            user9134685
            Thanks Nazar for your reply.

            I used the sample cube based MV related app provided by oracle on my local machine. Here is what i executed as my latest attempt and it finally failed.

            begin
            DBMS_CUBE.BUILD(
            'price_cube, units_cube',
            'S', -- solve
            true, -- refresh after errors
            10, -- parallelism
            false, -- atomic refresh
            true, -- automatic order
            true, -- add dimensions
            'IncrMyCBMV'-- identify job
            );
            end;


            I am not able to attach the CUBE_BUILD_LOG here for this run. Is there an alternate way I can upload it.

            Thanks
            • 3. Re: Multiple Cubes refresh in parallel
              DavidGreenfield
              How did it fail? Can you please post the error message you received from this procedure?
              • 4. Re: Multiple Cubes refresh in parallel
                user9134685
                FAILED RECORDS FROM THE LOG :
                ==========================

                127     0     FAILED     BUILD          BUILD     "(CLOB) <ERROR>
                <![CDATA[
                XOQ-01707: Oracle job "IncrMyCBMV_JOB$_812" failed while executing slave build "GLOBAL.UNITS_CUBE USING (CLEAR LEAVES, LOAD, SOLVE) AS OF SCN 1533406" with error "37162: ORA-37162: OLAP error
                XOQ-00703: error executing OLAP DML command "(UPDATE GLOBAL.GLOBAL : ORA-37605: error during OLAP AW UPDATE
                ORA-00600: internal error code, arguments: [kdliLockBlock], [9708], [16859386], [0], [0], [0], [0], [], [], [], [], []
                )"
                ORA-06512: at "SYS.DBMS_CUBE", line 234
                ORA-06512: at "SYS.DBMS_CUBE", line 316
                ORA-06512: at line 1
                ".]]>>
                </ERROR>"     GLOBAL     GLOBAL               02-APR-13 12.25.43.702000000 PM ASIA/CALCUTTA     (CLOB) BUILD price_cube, units_cube     DBMS_CUBE     0               4542     0     0     2     IncrMyCBMV
                127     0     FAILED     SLAVE     UNITS_CUBE     CUBE          GLOBAL     GLOBAL     P22:1999.10     IncrMyCBMV_JOB$_821     02-APR-13 12.25.42.673000000 PM ASIA/CALCUTTA     (CLOB) GLOBAL.UNITS_CUBE USING (CLEAR LEAVES, LOAD, SOLVE) AS OF SCN 1533406     DBMS_CUBE     1          S     6288     230     0     3     IncrMyCBMV
                127     0     FAILED     SLAVE     UNITS_CUBE     CUBE          GLOBAL     GLOBAL     P24:1999.12     IncrMyCBMV_JOB$_819     02-APR-13 12.25.32.533000000 PM ASIA/CALCUTTA     (CLOB) GLOBAL.UNITS_CUBE USING (CLEAR LEAVES, LOAD, SOLVE) AS OF SCN 1533406     DBMS_CUBE     1          S     6272     228     0     3     IncrMyCBMV
                127     0     FAILED     SLAVE     UNITS_CUBE     CUBE          GLOBAL     GLOBAL     P25:2000.01     IncrMyCBMV_JOB$_818     02-APR-13 12.25.30.505000000 PM ASIA/CALCUTTA     (CLOB) GLOBAL.UNITS_CUBE USING (CLEAR LEAVES, LOAD, SOLVE) AS OF SCN 1533406     DBMS_CUBE     1          S     6259     227     0     3     IncrMyCBMV
                127     0     FAILED     SLAVE     UNITS_CUBE     CUBE          GLOBAL     GLOBAL     P26:2000.02     IncrMyCBMV_JOB$_817     02-APR-13 12.25.28.477000000 PM ASIA/CALCUTTA     (CLOB) GLOBAL.UNITS_CUBE USING (CLEAR LEAVES, LOAD, SOLVE) AS OF SCN 1533406     DBMS_CUBE     1          S     6258     226     0     3     IncrMyCBMV
                127     0     FAILED     SLAVE     UNITS_CUBE     CUBE          GLOBAL     GLOBAL     P27:2000.03     IncrMyCBMV_JOB$_816     02-APR-13 12.25.26.449000000 PM ASIA/CALCUTTA     (CLOB) GLOBAL.UNITS_CUBE USING (CLEAR LEAVES, LOAD, SOLVE) AS OF SCN 1533406     DBMS_CUBE     1          S     6237     225     0     3     IncrMyCBMV
                127     0     FAILED     SLAVE     UNITS_CUBE     CUBE          GLOBAL     GLOBAL     P28:2000.04     IncrMyCBMV_JOB$_815     02-APR-13 12.25.24.421000000 PM ASIA/CALCUTTA     (CLOB) GLOBAL.UNITS_CUBE USING (CLEAR LEAVES, LOAD, SOLVE) AS OF SCN 1533406     DBMS_CUBE     1          S     6235     224     0     3     IncrMyCBMV
                127     0     FAILED     SLAVE     UNITS_CUBE     CUBE          GLOBAL     GLOBAL     P29:2000.05     IncrMyCBMV_JOB$_814     02-APR-13 12.25.22.393000000 PM ASIA/CALCUTTA     (CLOB) GLOBAL.UNITS_CUBE USING (CLEAR LEAVES, LOAD, SOLVE) AS OF SCN 1533406     DBMS_CUBE     1          S     6234     223     0     3     IncrMyCBMV
                127     0     FAILED     SLAVE     UNITS_CUBE     CUBE          GLOBAL     GLOBAL     P30:2000.06     IncrMyCBMV_JOB$_813     02-APR-13 12.25.20.349000000 PM ASIA/CALCUTTA     (CLOB) GLOBAL.UNITS_CUBE USING (CLEAR LEAVES, LOAD, SOLVE) AS OF SCN 1533406     DBMS_CUBE     1          S     6232     222     0     3     IncrMyCBMV
                • 5. Re: Multiple Cubes refresh in parallel
                  DavidGreenfield
                  I would open a service request on this problem. Mention my name in the SR and it will be forwarded to me. I have already written to the relevant developers asking for their opinion.
                  • 6. Re: Multiple Cubes refresh in parallel
                    user9134685
                    Thanks David. How do I log a SR?
                    • 7. Re: Multiple Cubes refresh in parallel
                      DavidGreenfield
                      You should be able to create a Service Request on support.oracle.com.