Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIEE12 migration-tool - import process FAILED and increases s.o. LOAD excessively

Received Response
31
Views
4
Comments
User_U0LN6
User_U0LN6 Rank 3 - Community Apprentice

Hi Experts,

The problem is: BIEE12  migration-tool - import process FAILED and increases s.o. LOAD excessively

BIEE12 is last version: 12.2.1.4.0 installed and patch (3 recommended patches).

Java is:

$java -version

java version "1.7.0_80"

Java(TM) SE Runtime Environment (build 1.7.0_80-b15)

Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)

Step 1: stop biee 12.

$ ./stop.sh

Step 2: ./migration-tool.sh package bi-migrationt-tool.jar

$ ./migration-tool.sh package bi-migrationt-tool.jar

generate sucessful bi-migrationt-tool.jar

ls -la 33141679 Nov  5 14:43 bi-migrationt-tool.jar

Step 3:

in biee11, lastest version 11.1.1.9.

$ java -version

java version "1.7.0_80"

Java(TM) SE Runtime Environment (build 1.7.0_80-b15)

Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)

java -jar ./bi-migrationt-tool.jar out $ORACLE_HOME $DOMAIN_HOME ./ccee_prod_dri.jar

generate sucessfull

$  ls -la ccee_prod_dri.jar

304181048 Nov  5 14:54 ccee_prod_dri.jar

Step 4 - This step generate LOAD excessively.

photo1:

pastedImage_2.png

$ ./migration-tool.sh in ccee_prod_dri.jar ssi (running)

photo 2 after 5 minutes:

pastedImage_3.png

The STAR is over load.

And in the log >

2019-11-05 16:18:00 SEVERE biserverxmlgen Failed to generate /opt/user_projects/domains/dom_bi/tmp/bi/migration-tool/migration-bundle-plugin-data1572977811304/PerPluginTemp/metadata/rpd/live.rpd/datamodel/customizations/default/default_diff.xml <oracle.bi.metadata.util.TransformRpdUtil generateXml>

2019-11-05 16:18:00 SEVERE Runtime RPD transformation failed <oracle.bi.migration.RPDTransformPlugin doTransform>

2019-11-05 16:18:00 INFO    RPD Transformation plugin exited with result: false <oracle.bi.migration.plugin.metadata.MetadataPlugin run>

Error in RPD generation.

If you experience is this scenario send me any sugestion.

Thank You.

Answers

  • 3849347 wrote:BIEE12 is last version: 12.2.1.4.0 installed and patch (3 recommended patches).Java is:$java -versionjava version "1.7.0_80"Java(TM) SE Runtime Environment (build 1.7.0_80-b15)Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)

    I'm not going to read any further than this part of your post.

    Certification matrix exist for a good reason.

    OBIEE 12.2.1.4 requires at least Oracle JDK 1.8.0_131.

    I'm not even sure how you managed to have a working install with JDK 1.7.0_80 as there is a check for that (in theory).

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1'000'000

  • User_U0LN6
    User_U0LN6 Rank 3 - Community Apprentice

    Hi create a new process to test with last jdk version.

    See:

    $ java -version

    java version "1.8.0_231"

    Java(TM) SE Runtime Environment (build 1.8.0_231-b11)

    Java HotSpot(TM) 64-Bit Server VM (build 25.231-b11, mixed mode)

    [oracle@hxbi ~]$

    [oracle@hxbi ~]$ cd /opt/oracle/hombi/user_projects/domains/hombi/bitools/bin

    [oracle@hxbi bin]$

    [oracle@hxbi bin]$ ./migration-tool.sh package bi-migrationt-tool2.jar

    Oracle BI Migration Tool

    Copyright © 2015, 2016, 2017, 2018, Oracle and/or its affiliates. All rights reserved.

    Logging to: /opt/oracle/hombi//user_projects/domains/hombi/bilogs/migration/migration-2019-11-05-17-54-31.log with level INFO

    Packaging migration tool

    Created migration tool JAR: bi-migrationt-tool2.jar

    Migration action succeeded.

    Copy to 11 enviroment.

    $ scp -p bi-migrationt-tool2.jar oracle@pxbi:/opt/oracle/biee/user_projects/domains/biee/tmp

    Generate new jar

    $ java -version

    java version "1.7.0_80"

    Java(TM) SE Runtime Environment (build 1.7.0_80-b15)

    Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)

    [oracle@pxbi tmp]$

    [oracle@pxbi tmp]$ java -jar ./bi-migrationt-tool2.jar out $ORACLE_HOME $DOMAIN_HOME ./biee2.jar

    Oracle BI Migration Tool

    Copyright © 2015, 2016, 2017, 2018, Oracle and/or its affiliates. All rights reserved.

    Logging to: /opt/oracle/biee/user_projects/domains/biee/bilogs/migration/migration-2019-11-05-17-04-47.log with level INFO

    Creating a migration bundle

    Top-level install directory is: /opt/oracle/biee

    Domain home directory is: /opt/oracle/biee/user_projects/domains/biee

    Instance directory is: /opt/biee/oracle/biee/instances/instance1

    Output migration bundle file is: ./biee2.jar

    Export complete

    Migration action succeeded

    SCP to biee 12 enviroment

    scp -p biee2.jar oracle@hxbi:/opt/oracle/hombi/user_projects/domains/hombi/bitools/bin

    $ ls -la biee2.jar

    -rw-r--r-- 1 oracle aplicacoes 304309587 Nov  5 17:08 biee2.jar

    import in BIEE12 enviroment >

    $ java -version

    java version "1.8.0_231"

    Java(TM) SE Runtime Environment (build 1.8.0_231-b11)

    Java HotSpot(TM) 64-Bit Server VM (build 25.231-b11, mixed mode)

    [oracle@hxbi50 bin]$

    [oracle@hxbi50 bin]$ ./migration-tool.sh in biee2.jar ssi

    Oracle BI Migration Tool

    Copyright © 2015, 2016, 2017, 2018, Oracle and/or its affiliates. All rights reserved.

    Logging to: /opt/oracle/hombi/user_projects/domains/hombi/bilogs/migration/migration-2019-11-05-18-20-26.log with level INFO

    Attempting to import a migration bundle

    Top-level install directory is: /opt/oracle/hombi

    Domain home directory is: /opt/hombi/oracle/hombi/user_projects/domains/hombi

    Input migration bundle file is: biee2.jar

    Enter RPD password:

    perform run

    and after  1 min  >>

    the TOP command demonstrated the LOAD encrease

    pastedImage_32.png

    aft 1 min

    pastedImage_33.png

    in the log

    pastedImage_34.png

    pastedImage_35.png

    is this expected?

    Thank You,

  • User_U0LN6
    User_U0LN6 Rank 3 - Community Apprentice

    After the load hit 285 it completed successfully.