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

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

Hailun-Oracle

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

Find more posts tagged with

Accepted answers

All comments

Michael Verzijl

You have seen this error in your log?

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

Hailun-Oracle

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

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

[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

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

Hi,

please down the all services and after that downgrade the rpd

Michael Verzijl

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

Gianni Ceresa

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.