Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

[Error] Export and import Barfiles

Received Response
41
Views
6
Comments
Claudio Torres Arbe
Claudio Torres Arbe Rank 3 - Community Apprentice
edited Aug 13, 2024 6:05PM in Oracle Analytics Cloud and Server

Hi everyone,
I'm in trouble when I import barfiles. In my OBIEE it imports correctly, but when I restart the services the RPD goes blank and the RPDs that were imported are deleted.
I want to export from OBIEE 12c version 12.2.1.0.0 to a new install of the same version
Any solution?

My step

I created the workdir folder

image

I gave permission to the workdir folder

image

I created the exportdir folder

image

I gave permission to the exportdir folder

image

I ran the wlst.sh file

image

image

I checked the instance key

image

image

I ran the exportserviceInstance command

image

And finally i imported with the command importServiceInstance

image

Att.

Cláudio Torres

Answers

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

    a) I would move on from that .0 release.

    b) Have you already opened the bar file and checked what's in it? I.e. does the export actually put everything in?

  • Claudio Torres Arbe
    Claudio Torres Arbe Rank 3 - Community Apprentice

    Hi Christian, export goes correctly in your folders, but after restarting the services it erases and this happens only in RPD.
    The exported RPD is accessed offline, I believe it is correct.

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

    What does the log say?

    .../user_projects/domains/bi/bilogs/service_instances/myinstance/metadata

  • Claudio Torres Arbe
    Claudio Torres Arbe Rank 3 - Community Apprentice

    In my si_history.log

    Date & Time : 2017-02-23_03-20-40 PM EST

    Framework Version : 1.0

    Command     : createServiceInstance()

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170223_152040.log

    Date & Time : 2017-03-01_01-04-01 PM EST

    Framework Version : 1.0

    Command     : exportServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracl/app/workdir', /ho, None, None, None, false, '********')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170301_130401.log

    Date & Time : 2017-03-01_01-05-37 PM EST

    Framework Version : 1.0

    Command     : exportServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/workDir', /home/oracle/app/exportDir, None, None, None, false, '********')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170301_130537.log

    Date & Time : 2017-03-01_01-12-21 PM EST

    Framework Version : 1.0

    Command     : exportServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/workDir', /home/oracle/app/exportDir, None, None, None, true, , '********')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170301_131221.log

    Date & Time : 2017-03-01_01-17-33 PM EST

    Framework Version : 1.0

    Command     : exportServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/workDir', /home/oracle/app/exportDir, None, None, None, true, , '********')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170301_131733.log

    Date & Time : 2017-03-01_01-49-06 PM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170301_134906.log

    Date & Time : 2017-03-01_01-51-07 PM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170301_135107.log

    Date & Time : 2017-03-01_02-46-17 PM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170301_144617.log

    Date & Time : 2017-03-01_03-44-19 PM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170301_154419.log

    Date & Time : 2017-03-02_07-10-14 AM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170302_071014.log

    Date & Time : 2017-03-02_08-03-43 AM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170302_080343.log

    Date & Time : 2017-03-02_08-49-12 AM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/Backup/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170302_084912.log

    Date & Time : 2017-03-02_09-07-56 AM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/Backup/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170302_090756.log

    Date & Time : 2017-03-02_11-56-57 AM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/Backup/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170302_115657.log

    Date & Time : 2017-03-02_01-51-59 PM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/Backup/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170302_135159.log

    Date & Time : 2017-03-02_02-14-20 PM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/Backup/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170302_141420.log

    Date & Time : 2017-03-03_09-04-28 AM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170303_090428.log

    Date & Time : 2017-03-03_09-53-51 AM EST

    Framework Version : 1.0

    Command     : importServiceInstance('/home/oracle/app/obiee/user_projects/domains/bi', 'ssi', '/home/oracle/app/exportDir/ssi.bar', true, true, true, '*******')

    Log File    : /home/oracle/app/obiee/user_projects/domains/bi/bilogs/service_instances/ssi/metadata/si20170303_095351.log

  • Claudio Torres Arbe
    Claudio Torres Arbe Rank 3 - Community Apprentice

    hi everyone,

    any solution?

    Att.

    Cláudio Torres

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

    The log looks fine:

    [2017-03-03T09:53:51.895-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.ServiceInstanceLifeCycleImpl] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Metadata to be imported RPD[2017-03-03T09:54:03.829-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.handler.RpdServiceInstanceHandler] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] shouldPluginRun is true. Hence running oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin[2017-03-03T09:54:03.829-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.handler.RpdServiceInstanceHandler] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Removed the old datamodel content from /home/oracle/app/obiee/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel[2017-03-03T09:54:03.831-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.handler.RpdServiceInstanceHandler] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Copied new datamodel content from /home/oracle/app/obiee/user_projects/domains/bi/bidata/service_instances/ssi/tmp/importbar/datamodel to /home/oracle/app/obiee/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel[2017-03-03T09:54:03.832-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Reading password for SI: ssi[2017-03-03T09:54:03.837-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Getting customization XMLs for datamodel: /home/oracle/app/obiee/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel[2017-03-03T09:54:03.838-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] /home/oracle/app/obiee/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/customizations/default/default_diff.xml[2017-03-03T09:54:03.838-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Processing /home/oracle/app/obiee/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/customizations/default/default_diff.xml[2017-03-03T09:54:03.841-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Decrypting password...[2017-03-03T09:54:03.841-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Executing Command: [/home/oracle/app/obiee/user_projects/domains/bi/bitools/bin/nqsecudmlgen.sh, -D][2017-03-03T09:54:03.850-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 33] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writer thread started[2017-03-03T09:54:03.851-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 33] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writing first input[2017-03-03T09:54:03.851-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 33] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writing second input[2017-03-03T09:54:04.478-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Encrypting password...[2017-03-03T09:54:04.478-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Executing Command: [/home/oracle/app/obiee/user_projects/domains/bi/bitools/bin/nqsecudmlgen.sh, -K][2017-03-03T09:54:04.482-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 34] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writer thread started[2017-03-03T09:54:04.482-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 34] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writing first input[2017-03-03T09:54:04.482-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 34] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writing second input[2017-03-03T09:54:04.944-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Decrypting password...[2017-03-03T09:54:04.945-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Executing Command: [/home/oracle/app/obiee/user_projects/domains/bi/bitools/bin/nqsecudmlgen.sh, -D][2017-03-03T09:54:04.969-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 35] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writer thread started[2017-03-03T09:54:04.970-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 35] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writing first input[2017-03-03T09:54:04.970-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 35] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writing second input[2017-03-03T09:54:05.475-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Encrypting password...[2017-03-03T09:54:05.475-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Executing Command: [/home/oracle/app/obiee/user_projects/domains/bi/bitools/bin/nqsecudmlgen.sh, -K][2017-03-03T09:54:05.480-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 36] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writer thread started[2017-03-03T09:54:05.481-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 36] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writing first input[2017-03-03T09:54:05.481-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin] [tid: 36] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Writing second input[2017-03-03T09:54:05.919-05:00] [bi] [NOTIFICATION] [] [oracle.bi.bar.si.framework.handler.RpdServiceInstanceHandler] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Successfully run importServiceInstance for plugin oracle.bi.bar.si.framework.plugin.RpdMetadataManagerPlugin[2017-03-03T09:54:05.920-05:00] [bi] [WARNING] [] [oracle.bi.bar.si.framework.handler.ServiceInstanceHandlerHelper] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] No warning messages found in the message list of status object.[2017-03-03T09:54:05.920-05:00] [bi] [WARNING] [] [oracle.bi.bar.si.framework.handler.ServiceInstanceHandlerHelper] [tid: 1] [ecid: ee87ff1c-24f4-4e75-b460-1dc7ffe99dd5-00000002,0] Log file provided by plugin = /home/oracle/app/obiee/user_projects/domains/bi/bilogs/metadata/datamodel/RpdMetadataManagerPlugin2017-03-03_09-54-03AM.log

    So I suggest you look into the detailed log:

    /home/oracle/app/obiee/user_projects/domains/bi/bilogs/metadata/datamodel/RpdMetadataManagerPlugin2017-03-03_09-54-03AM.log