1 2 Previous Next 16 Replies Latest reply on Apr 5, 2017 9:14 AM by Khalid Algrafi

    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...

        • 1. Re: Error in uploading RPD file
          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?

          • 2. Re: Error in uploading RPD file
            Christian Berg

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

            • 3. Re: Error in uploading RPD file
              Khalid Algrafi

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

              • 4. Re: Error in uploading RPD file
                FTisiot

                Is this

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

                a valid RPD?

                • 5. Re: Error in uploading RPD file
                  Christian Berg

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

                  • 6. Re: Error in uploading RPD file
                    3310714

                    Hi,

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

                    • 7. Re: Error in uploading RPD file
                      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.

                      • 8. Re: Error in uploading RPD file
                        Christian Berg

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

                         

                        Khalid Algrafi The post he mentions just says that this could be due to a bug in the base 12c release - 12.2.1.0.0

                        • 9. Re: Error in uploading RPD file
                          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.>

                          • 10. Re: Error in uploading RPD file
                            Christian Berg

                            Thanks. That tells us precisely nothing

                             

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

                            • 11. Re: Error in uploading RPD file
                              Khalid Algrafi

                              hehe, here you go..  obis1-diagnostic.log

                               

                              [2017-04-05T08:21:26.486+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6IGP45n5i^WpxwO5yW0003LJ000OkF,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.43058 was lost.

                              [2017-04-05T08:51:44.339+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6Jwjc9a5i^WpxwO5yW0003LJ000PKM,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.44504 was lost.

                              [2017-04-05T09:19:00.206+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6LUFxXN5i^WpxwO5yW0003LJ000Pot,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.45800 was lost.

                              [2017-04-05T09:25:03.435+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6Lnt^WF5i^WpxwO5yW0003LJ000Pw7,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.46093 was lost.

                              [2017-04-05T09:34:08.690+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6MKPZQO5i^WpxwO5yW0003LJ000Q6v,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.46523 was lost.

                              [2017-04-05T09:40:12.34+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6Me3aCM5i^WpxwO5yW0003LJ000QE9,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.46813 was lost.

                              [2017-04-05T09:43:13.602+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6MosF2I5i^WpxwO5yW0003LJ000QHi,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.46956 was lost.

                              [2017-04-05T09:52:18.372+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6NLMMR25i^WpxwO5yW0003LJ000QS^,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.47390 was lost.

                              [2017-04-05T10:01:23.571+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6Npq8Ml5i^WpxwO5yW0003LJ000QbQ,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.47826 was lost.

                              [2017-04-05T10:04:25.31+03:00] [OBIS] [ERROR:1] [] [] [ecid: 005J6O0eMH35i^WpxwO5yW0003LJ000Qf2,0] [sik: ssi] [tid: 9048a700]  [43065] The connection with Cluster Controller ::ffff:10.8.107.21.47970 was lost.

                              [2017-04-05T10:06:12.213+03:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: 6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000c,0:1821:14:6:1:6] [sik: ssi] [tid: 7a1dd700] LCMAPIsUtil.GetSDD-> /oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata

                              [2017-04-05T10:06:12.347+03:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: 6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000c,0:1821:14:8:6] [sik: ssi] [tid: 7a1dd700] LCMAPIsUtil.GetSDD-> /oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata

                              [2017-04-05T10:06:12.481+03:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: 6bfc72b2-365c-43f6-86ac-3b3c749926e0-0000000c,0:1821:14:11:1:6] [sik: ssi] [tid: 7a1dd700] LCMAPIsUtil.GetSDD-> /oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata

                              • 12. Re: Error in uploading RPD file
                                FTisiot

                                Also this doesn't tell much.

                                Can you try to restart the component and check the logs while it's restarting?

                                • 13. Re: Error in uploading RPD file
                                  Christian Berg

                                  Thanks  FTisiot my screen is covered in coffee now

                                  • 14. Re: Error in uploading RPD file
                                    Khalid Algrafi

                                    Could it be due to a bug as you mentioned Christian Berg?? Cause i have the base 12c release aka 12.2.1.0.0 ...

                                     

                                     

                                    1 2 Previous Next