Customer intermitently fails to perform downrpd using "./datamodel.sh downloadrpd -O CurrentRPD.rpd — Oracle Analytics

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

Customer intermitently fails to perform downrpd using "./datamodel.sh downloadrpd -O CurrentRPD.rpd

Received Response
42
Views
8
Comments
Hailun-Oracle
Hailun-Oracle Rank 2 - Community Beginner
edited Aug 13, 2024 5:46PM in Oracle Analytics Cloud and Server

Hi Experts,

Problem description:

One top account customer is intermittently facing issue when perform downrpd using "./datamodel.sh downloadrpd -O CurrentRPD.rpd -W RPDPass -SI ssi -U biadmin -P WLPass" command line.

Customer is getting error message “Concurrency error, please try again later. Could not acquire RPD lock for service instance ssi, please try again later.”

In log file 20180712_bi-lcm-rest.log.0, the following erro message could be observed.

Jul 10,2018 17:01:16 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 SEVERE - Exception preparing RPD file for download: oracle.bi.server.customization.utils.ServerException: java.sql.SQLException: java.io.IOException: [nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.
at oracle.bi.server.customization.utils.BiProcedureExecutor.getConnection(BiProcedureExecutor.java:335)
at oracle.bi.server.customization.utils.BiProcedureExecutor.extractMetadataProject(BiProcedureExecutor.java:231)
at oracle.bi.server.customization.utils.DownloadRpdTask.execute(DownloadRpdTask.java:36)
at oracle.bi.server.customization.utils.CallableProgress.call(CallableProgress.java:37)
at oracle.bi.server.customization.utils.OnlineTask.call(OnlineTask.java:16)
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:748)
Caused by: java.sql.SQLException: java.io.IOException: [nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.
at oracle.bi.jdbc.AnaJdbcDriver.connectToNQSNode(AnaJdbcDriver.java:404)
at oracle.bi.jdbc.AnaJdbcDriver.connect(AnaJdbcDriver.java:460)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at oracle.bi.jdbc.AnaJdbcDataSourceImpl.getConnection(AnaJdbcDataSourceImpl.java:28)
at oracle.bi.jdbc.AnaJdbcDataSourceImpl.getConnection(AnaJdbcDataSourceImpl.java:38)
at oracle.bi.server.customization.utils.BiProcedureExecutor.getConnection(BiProcedureExecutor.java:332)
... 9 more

Jul 10,2018 17:07:41 oracle.bi.lcm.rest.logging.LogConfig INFO - BI Service Instance LCM will log to: /u01/app/oracle/product/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/servers/bi_server1/logs/bi-lcm-rest.log
Jul 10,2018 17:49:16 oracle.bi.lcm.rest.logging.LogConfig INFO - BI Service Instance LCM will log to: /u01/app/oracle/product/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/servers/bi_server1/logs/bi-lcm-rest.log

My Question:

What are causes to the issue?

How to get the issue fixed for customer?

Thanks & Regards

Answers

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    You have seen this error in your log?

    [nQSError: 43126] Authentication failed: invalid user/password.

  • Hailun-Oracle
    Hailun-Oracle Rank 2 - Community Beginner

    Hi Michael Verzijl，

    Thanks for update.

    Yes, in the  bi-lcm-rest.log.0 file, the following error message could be seen.  [nQSError: 43126] Authentication failed: invalid user/password.

    What does the error message refer to? How to fix the issue?

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    You are sure the username and password provided in the -U and -P parameter are correct? Can you login to EM/Console with these?

  • handat
    handat Rank 5 - Community Champion

    [nQSError: 43126] Authentication failed: invalid user/password. is an indication that your BISystemUser is locked. If your problem is intermittent, then it means that the BISystemUser somehow gets locked (most likely someone or some process it attempting to login as that user with the wrong password consecutively). Once that account is locked, downrpd will fail. By default, weblogic will unlock the account automatically after a period of time (30 mins if I remember correctly) and once that happens downrpd will work again.

    What you need to do is either create a separate account with the same privileges of BISystemUser and reconfigure your system to use that account instead, or find out who or which process is regularly logging in using an invalid password and stop that from happening constantly.

  • Hailun-Oracle
    Hailun-Oracle Rank 2 - Community Beginner

    Hi handat,

    Thanks for advice.

    I searched keyword "BISystemUser"  and found in OBIEE 11g there is an option to create a trusted user for system components communicate with each other with link https://docs.oracle.com/cd/E28280_01/bi.1111/e10543/privileges.htm#BIESC534 .

    But I could not find such knowledge for OBIEE 12c, customer is using OBIEE 12c.

    Could you please give some advice? Thanks.

  • 842395
    842395 Rank 3 - Community Apprentice

    Hi,

    please down the all services and after that downgrade the rpd

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Downgrade the RPD? That is not something you want..

  • Gianni Ceresa
    Gianni Ceresa Mod 
    842395 wrote:Hi,please down the all services and after that downgrade the rpd

    Nobody ever asked about downgrading the RPD, and if the system is down there is literally no chance to be able to download the RPD as it's a webservice call.