8 Replies Latest reply on Jul 13, 2018 11:04 AM by Gianni Ceresa

    Customer intermitently fails to perform downrpd using "./datamodel.sh downloadrpd -O CurrentRPD.rpd -W RPDPass -SI ssi -U biadmin -P WLPass" command line

    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