not able to upload rpd from windows to linux

3068122

Hi ,

I'm not able to upload .rpd from windows to linux. When i tried to upload rpd using ./data-model-cmd.sh , I received error that "Operation Failed. An exception occured during execution, please check server logs".

I checked logs and in log file "Repository password is wrong" message exist. However , i can open .rpd using the password that i used upload operation.

Is it possible to upload rpd from windows system to linux system ?

Is there anyone who meet the same error or have any idea ?

Regards

3310714

Hi,

Your error seems to point password issue.  Anyway, if you want to upload your RPD from your Windows client to the Linux server, take a look at this post:

downloadrpd -S -N

3068122

Hi ,

i have test BI system on windows and have production BI system which installed on Linux.

I downloaded rpd from test system(windows). For example : rpd password that is downloaded from windows system "test123". I am able to open rpd using password "test123".

When i try to upload rpd to production system(linux) using "test123" password , no luck.  I checked logs and found "Repository password is wrong".  However , i am able to open rpd using same password while uploading.  Maybe , it is bug.

3310714

So you are able to download and upload within your TEST and within your PROD.  But you can't upload from TEST to PROD.  Maybe it is some issue with cross platform...

Madasamy -Oracle

Can you post us the BIEE version ( 122100 or 122110 ) and the content from the bi-lcm-rest.log from $ORACLE_HOME/user_projects/domains/bi/servers/bi_server1/logs

Thanks,

Madasamy    

3068122

Hi, version is 12.2.1.0.0.

bi-lcm-rest.log is here

xtermxtermxtermxtermxtermxtermxtermxtermxtermDec 14,2016 09:43:11 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - upload                                            Rpd called for: ssi

Dec 14,2016 09:43:12 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - Deploying RPD file: /home/Oracle/Oracle/Middleware/                                            Oracle_Home/user_projects/domains/bifoundation_domain/config/fmwconfig/servers/bi_server1/tmp/lcmrest/temp-ssi-rpd61696                                            49513977561386/uploaded.rpd

Dec 14,2016 09:43:41 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 SEVERE - Exception during RPD file upload: oracle.bi.server.customization.utils.CustomizationException: Error converting rpd to xml.

        at oracle.bi.server.customization.utils.GenerateXmlFromRpdTask.execute(GenerateXmlFromRpdTask.java:101)

        at oracle.bi.server.customization.utils.UploadRpdTask.execute(UploadRpdTask.java:80)

        at oracle.bi.server.customization.utils.CallableProgress.call(CallableProgress.java:37)

        at oracle.bi.server.customization.utils.CallableProgress.call(CallableProgress.java:12)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

Dec 14,2016 09:43:41 oracle.bi.lcm.rest.app.LCMApplication INFO - 7 * Server responded with a response on thread [ACTIVE] ExecuteThread: '28' for queue: 'weblogic.kernel.Default (self-tuning)'

7 < 200

7 < Content-Type: application/vnd.siren+json

{"clazz":["rpd-response"],"links":[{"href":"http://10.0.1.128:9502/bi-lcm/v1/si/ssi/rpd/uploadrpd","rel":["self"]}],"properties":{"entry":[{"key":"si","value":{"type":"string","value":"ssi"}},{"key":"description","value":{"type":"string","value":"An exception occurred during execution, please check server logs, such as bi-lcm-rest.log.0 and obis1-diagnostic.log."}},{"key":"desc_code","value":{"type":"string","value":"DESC_CODE_SERVER_EXCEPTION"}},{"key":"status","value":{"type":"string","value":"ERROR"}}]},"title":"RPD-LCM response, SI=ssi, action=Upload RPD"}

Sagar Tippe

Hi,

from your log, I'm nowhere able to see the message stating "Pwd is wrong". Either you have not posted a complete log or this might be the old log. Please check.

For your reference, go through the below post for uploading and downloading a rpd in OBIEE 12c.

3068122

Hi ,

you're right there is no "Pwd is wrong" text in bi-lcm-rest.log now. But before when i tried to upload same rpd with same password, i am sure i received "Pwd is wrong" error message. I did not change anyting while uploading but now error message different.

Anyway , i tried 5 minutes before and bi-lcm-rest.log file content here :

Dec 14,2016 14:24:26 oracle.bi.lcm.rest.app.LCMApplication INFO - 9 * Server has received a request on thread [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'

9 > POST http://10.0.1.128:9502/bi-lcm/v1/si/ssi/rpd/uploadrpd

9 > Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2

9 > Authorization: Basic d2VibG9naWM6d2VibG9naWMxMjM=

9 > Connection: keep-alive

9 > Content-Length: 1764026

9 > Content-Type: multipart/form-data;boundary=Boundary_1_576020159_1481718266030

9 > Host: 10.0.1.128:9502

9 > MIME-Version: 1.0

9 > User-Agent: Jersey/2.21.1 (HttpUrlConnection 1.8.0_65)

--Boundary_1_576020159_1481718266030

Content-Type: text/plain

Content-Disposition: form-data; name="rpd-password"

Admin123

--Boundary_1_576020159_1481718266030

Content-Type: application/vnd.oracle.rpd

Content-Disposition: form-data; filename="OFIS67.rpd"; modification-date="Wed, 14 Dec 2016 12:22:32 GMT"; size=1763640; name="file"

xtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermDec 14,2016 14:24:26 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - uploadRpd called for: ssi

Dec 14,2016 14:24:26 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - Deploying RPD file: /home/Oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bifoundation_domain/config/fmwconfig/servers/bi_server1/tmp/lcmrest/temp-ssi-rpd9071487533280699034/uploaded.rpd

Dec 14,2016 14:24:39 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 SEVERE - Exception during RPD file upload: oracle.bi.server.customization.utils.CustomizationException: Error converting rpd to xml.

        at oracle.bi.server.customization.utils.GenerateXmlFromRpdTask.execute(GenerateXmlFromRpdTask.java:101)

        at oracle.bi.server.customization.utils.UploadRpdTask.execute(UploadRpdTask.java:80)

        at oracle.bi.server.customization.utils.CallableProgress.call(CallableProgress.java:37)

        at oracle.bi.server.customization.utils.CallableProgress.call(CallableProgress.java:12)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

Dec 14,2016 14:24:39 oracle.bi.lcm.rest.app.LCMApplication INFO - 9 * Server responded with a response on thread [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'

9 < 200

9 < Content-Type: application/vnd.siren+json

{"clazz":["rpd-response"],"links":[{"href":"http://10.0.1.128:9502/bi-lcm/v1/si/ssi/rpd/uploadrpd","rel":["self"]}],"properties":{"entry":[{"key":"si","value":{"type":"string","value":"ssi"}},{"key":"description","value":{"type":"string","value":"An exception occurred during execution, please check server logs, such as bi-lcm-rest.log.0 and obis1-diagnostic.log."}},{"key":"desc_code","value":{"type":"string","value":"DESC_CODE_SERVER_EXCEPTION"}},{"key":"status","value":{"type":"string","value":"ERROR"}}]},"title":"RPD-LCM response, SI=ssi, action=Upload RPD"}

Sagar Tippe

FYI.

To download a repository:

./data-model-cmd.sh downloadrpd -O /home/oracle/share/obieerpd.rpd -SI ssi -U weblogic -P Welcome1

Upon running, it prompts to enter a password for this RPD file.

It doesn’t ask to confirm this, so make sure we know what we entered or else you’ll need to re- run the command to download it again!

Now we can FTP this (newly created file) to local system and open it in the Administrator tool. Once done with the changes we want, we can upload it using the below command line utility.

./data-model-cmd.sh uploadrpd -I /home/oracle/share/obieerpd_modified.rpd -SI ssi -U weblogic -P Welcome1

Where,

I - specifies the name of the repository that we want to upload.

Here, are prompted to enter the RPD password, the same one we entered when we downloaded it.

Now we get to know that we have saved our valuable time in “Activating the Changes” and restarting our favorite (!!) OPMN.

Here with 12C, we can directly use the newly uploaded repository without restart of any services. Happy enough?? Wait, there's something waiting for you. Somewhat new you can say.

let me tell you that we can’t FTP the uploaded RPD file from server or the default repository location and open it in the Administrator tool thinking that you now know the password..

Obviously we know it, we entered it when uploading it, right? No, it's wrong; it changes the password during the upload. This is Oracle’s Intelligence. ;-)

Please mark if helpfull.

vai

did you opened the RPD in online mode &  tried to save it using "Copy As" option?