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

uploading a repository to bi server

Received Response
1
Views
7
Comments
Maahjoor
Maahjoor Rank 3 - Community Apprentice
edited Aug 13, 2024 6:01PM in Oracle Analytics Cloud and Server

Dear all,

i am using BI Administration tool. i want to upload a repository.

previously, the following command was working fine. look at the previous result.

Cd C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bindatamodel.cmd uploadrpd -I C:\Oracle\Middleware\Oracle_Home2\bi\bifoundation\server\Student_Repository.rpd -W Oracle_123 -U weblogic -P Oracle_123 -SI pdborclService Instance: ssiOperation successful.RPD upload completed successfully.

now, after three days, i am running the same command, but nothing is happening. look at the result below.

pastedImage_2.png

i remember only one thing which i do to my computer which is resetting the network wifi adapter and restarting my computer. after that it is not working,

could somebody please guide me with the issue above?

i am using OBIEE 12c on windows 64bit with oracle database 12c.

Regards.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Maahjoor wrote:i am using OBIEE 12c on windows 64bit with oracle database 12c.

    1.) "windows 64bit" can be anything since Windows NT

    2.) "12c" can be 12.2.1.0.0 or 12.2.1.1.0 or 12.2.1.2.0 so please be precise when asking questions

    3.) If you look at the certification matrix you will see that only 2 of Microsofts server OSs are certified with the current version 12.2.1.2.0:

    http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-122120-certmatrix-3254735.xlsx

    So if you are using any desktop Windows (like 7, 8 or 10) then you are outside of any certified setup. Get a real server OS and run things there. Or if you want to do it the simple way like most people in here - get the preconfigured OEL-based SampleApp VM: http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

  • Gianni Ceresa
    Gianni Ceresa Mod 
    Maahjoor wrote:-SI pdborcl

    Why are you passing the service instance of your DB to OBIEE? Did you really changed the service instance from SSI to pdborcl? (the screenshot says it's SSI ...).

    Maahjoor wrote:only one thing which i do to my computer which is resetting the network wifi adapter and restarting my computer

    So I guess you are a client OS (what Christian was saying, never saw a server with a wifi card). By "resetting" your network you probably got a new IP and so the name/ip used during the install doesn't match anymore and commands aren't finding your server anymore.

    If you use any network capture tool you will see exactly what IP/domain the command try to connect to and you will maybe find your answer there.

  • Maahjoor
    Maahjoor Rank 3 - Community Apprentice

    hi,

    i have already mark this thread as correct. but just once strange thing i want to share is that the datamodel.cmd file under  C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin> is complete empty. there is nothing in it. the datamodel.sh file contain the following text but i think it is for linux.

    #!/bin/sh# WARNING: This file is created by the Configuration Wizard.# Any changes to this script may be lost when adding extensions to this configuration.DOMAIN_HOME="C:/Oracle/Middleware/Oracle_Home/bi/bin/../../user_projects/domains/bi"export DOMAIN_HOMEC:/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.commandline.tools/scripts/datamodel.sh "$@"

    could i recreate this datamodel.cmd file by any mean?

    Regards

  • Gianni Ceresa
    Gianni Ceresa Mod

    You can use the one provided by your Admin tool so you even don't need to first copy a RPD file to the server to then upload it.

    But my Admin tool install doesn't have a /user_projects inside, so I'm not sure of what kind of install you have ...

    Are you still trying to install OBIEE 12c on your Windows desktop OS? If your install isn't done and your OBIEE configured the scripts are useless. On a Windows Desktop OS you install the Admin tool, and this one has a datamodel.cmd inside which works just fine.

  • Maahjoor
    Maahjoor Rank 3 - Community Apprentice

    i already had installed it and it was working fine, till this problem occur. i will never install it on my laptop again in future. i will use vitual images as you already guided and thank you very much for that. i have already download the virtual machine image and install it. configuration is pending which should not take that much time.

    i was just currious about the datamodel.cmd file and just think to share this issue here. for my future practices, i will use virtual image instead. it is safe and clean.

    Regards.

  • Maahjoor
    Maahjoor Rank 3 - Community Apprentice

    i just tried the solution you provided and look at the output.

    C:\Oracle\Middleware\Oracle_Home2\bi\bitools\bin>datamodel.cmd uploadrpd -I D:\StugradBI\Repository\StugradRepo.rpd -W Oracle_123 -U weblogic -P Oracle_123 -SI pdborcl -S localhostWARNING: Trust store is not defined. SSL connections will not be available.usage: uploadrpd -I <RPD filename> [-W <RPD password>] [ -V enable validation of rpd] [-D] [-KG <groups>] [-RG <groups>] -U <cred user> [-P <cred password>] [-SI <service instance>] [-S <host>] [-N <port>] [-SSL] [-TS trustStore jks filename] [-TSP trust store password]Options for removing existing customization groups on the server:-D                   : Remove all customization groups.-D -KG group1,group2 : Remove all customization groups exception of group1 and group2.-D -RG group1,group2 : Remove group1 and group2 but keep all others.C:\Oracle\Middleware\Oracle_Home2\bi\bitools\bin>
  • Gianni Ceresa
    Gianni Ceresa Mod 
    Maahjoor wrote:C:\Oracle\Middleware\Oracle_Home2\bi\bitools\bin>datamodel.cmd uploadrpd -I D:\StugradBI\Repository\StugradRepo.rpd -W Oracle_123 -U weblogic -P Oracle_123 -SI pdborcl -S localhost

    Apparently you didn't really get the syntax and the values of the parameters.

    localhost: as the OBIEE server isn't running on your Windows Desktop, why are you using localhost?

    pdborcl: as said already the service instance is "ssi", the default value and I really don't believe you changed it! pdborcl sounds like your database instance

    To use "datamodel.cmd uploadrpd" you first need an OBIEE server up and running somewhere, once you get it use that command pointing to that OBIEE environment.