nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Error in uploading RPD file

Khalid Algrafi

Hello experts ..

After executing the RPD upload command using the data-model-cmd.sh file.

Command:

./data-model-cmd.sh uploadrpd -I /oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/K.rpd -SI ssi -U weblogic -P oracle12c

RPD Password:

i get the following error:

Service Instance: ssi

Operation failed.

An exception occurred during execution, please check server logs.

i tried restarting the bi server but nothing...

any idea about this?

(note that i consider myself as a beginner so providing details would be appreciated)

Thanks...

Find more posts tagged with

Accepted answers

All comments

FTisiot

Have you considered doing what the error is saying?

An exception occurred during execution, please check server logs.

obis1-diagnostic.log biserver1.log or other server logs?

[Deleted User]

Of course not you maniac. Are you insane?! :-P

Khalid Algrafi

Thanks FTisiot for replaying. I checked the logs as you mentioned but really can't get any ideas from it...

FTisiot

Is this

/oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/K.rpd

a valid RPD?

[Deleted User]

Then post their content here so we can try to make sense of them

3310714

Hi,

See if this post helps: 12c - upload/download rpd

Khalid Algrafi

I apologize for my late replay... i checked the global consistency for the RPD file and it shows 0 errors, 0 warnings and no best practice violations.

[Deleted User]

Translation: You are asking the OP If he is running 12.2.1.0.0 without any patchh.

@3e41a5e4-9ca1-4289-8170-296af4ba40ff The post he mentions just says that this could be due to a bug in the base 12c release - 12.2.1.0.0

Khalid Algrafi

Here's the biserver1.log after executing the upload command :

####<Apr 5, 2017 9:46:44 AM AST> <Info> <Common> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '35' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006c81> <1491374804889> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "mds-owsm", out of which "1" are available and "0" are unavailable.>

####<Apr 5, 2017 9:46:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491374818312> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <27% of the total memory in the server is free.>

####<Apr 5, 2017 9:48:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491374938314> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <44% of the total memory in the server is free.>

####<Apr 5, 2017 9:49:52 AM AST> <Info> <JDBC> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006cbf> <1491374992690> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "biplatform_datasource" has been closed.>

####<Apr 5, 2017 9:49:53 AM AST> <Info> <JDBC> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006cc0> <1491374993271> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "mds-owsm" has been closed.>

####<Apr 5, 2017 9:49:53 AM AST> <Info> <JDBC> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '35' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006cc1> <1491374993764> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "wlsservices_datasource" has been closed.>

####<Apr 5, 2017 9:49:54 AM AST> <Info> <Common> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <Essbase Agent Heartbeat Daemon> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000427e> <1491374994096> <[severity-value: 64] [rid: 0:44] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "biplatform_datasource", out of which "1" are available and "0" are unavailable.>

####<Apr 5, 2017 9:49:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491374998316> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <32% of the total memory in the server is free.>

####<Apr 5, 2017 9:49:58 AM AST> <Info> <Common> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006cc2> <1491374998790> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "wlsservices_datasource", out of which "1" are available and "0" are unavailable.>

####<Apr 5, 2017 9:51:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491375118318> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <50% of the total memory in the server is free.>

####<Apr 5, 2017 9:52:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491375178319> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <37% of the total memory in the server is free.>

####<Apr 5, 2017 9:54:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491375298321> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <22% of the total memory in the server is free.>

####<Apr 5, 2017 9:55:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491375358322> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <45% of the total memory in the server is free.>

####<Apr 5, 2017 9:57:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491375478324> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <31% of the total memory in the server is free.>

####<Apr 5, 2017 9:58:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491375538326> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <53% of the total memory in the server is free.>

####<Apr 5, 2017 10:00:24 AM AST> <Info> <Diagnostics> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '35' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006d87> <1491375624068> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320143> <Scheduled 1 data retirement tasks as per configuration.>

####<Apr 5, 2017 10:00:24 AM AST> <Info> <Diagnostics> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006d88> <1491375624071> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320144> <Size based data retirement operation started on archive HarvestedDataArchive.>

####<Apr 5, 2017 10:00:28 AM AST> <Info> <Diagnostics> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006d88> <1491375628318> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320145> <Size based data retirement operation completed on archive HarvestedDataArchive. Retired 10,020 records in 4,247 ms.>

####<Apr 5, 2017 10:00:28 AM AST> <Info> <Diagnostics> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006d88> <1491375628319> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320144> <Size based data retirement operation started on archive EventsDataArchive.>

####<Apr 5, 2017 10:00:28 AM AST> <Info> <Diagnostics> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006d88> <1491375628319> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320145> <Size based data retirement operation completed on archive EventsDataArchive. Retired 0 records in 0 ms.>

####<Apr 5, 2017 10:00:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491375658328> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <42% of the total memory in the server is free.>

####<Apr 5, 2017 10:01:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491375718329> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <30% of the total memory in the server is free.>

####<Apr 5, 2017 10:03:45 AM AST> <Info> <Common> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-00006dc6> <1491375825145> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "mds-owsm", out of which "1" are available and "0" are unavailable.>

####<Apr 5, 2017 10:03:58 AM AST> <Info> <Health> <ruh-bidv-01.swcc.gov.sa> <bi_server1> <weblogic.GCMonitor> <<anonymous>> <> <6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000b> <1491375838331> <[severity-value: 64] [rid: 0:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-310002> <41% of the total memory in the server is free.>

[Deleted User]

Thanks. That tells us precisely nothing

biserver1 is the managed server - we need the Oracle BI Server log Francesco mentioned: obis1-diagnostic.log