5 Replies Latest reply: May 14, 2013 4:46 AM by Alecsandru Bucur RSS

    Reload Fails Due to RTO

      Hello Everyone,

       

      I am using QlikView 10 only server not the publisher. My reload starts @ 5:45 AM. The problem which I am facing is sometimes Network is not so gud, on regular interval it shows RTO i.e Request Time Out and the ping status which I get is like this

       

      Ping Details 01-Dec-2012_2.bmp

      My question After how many RTO qlikview will get disconnected. OR My network is poor and I am getting RTO than it will be connected to Database or not.

        • Re: Reload Fails Due to RTO
          Daniel Rozental

          I think it's more a time thing, there are usually some timeouts in ODBC/OLEDB connection strings you can probably mess around with. You should also configure retries on your reloads if you have a publisher license.

            • Re: Reload Fails Due to RTO

              Dear Daniel ,

               

              Thanx for your reply , I don't have publisher license , i tried everything but issue is that DBA is saying that Table Timeout is Unlimited and from Qlikview side I have set 7 Hours so it should continue upto 7 Hrs but it is getting disconnected and errors which I am getting are like

               

              1.

              Error: SQL##f - SqlState: S1000, ErrorCode: 12170, ErrorMsg: [Oracle][ODBC][Ora]ORA-12170: TNS:Connect timeout occurred ;

              2.

              SQL##f - SqlState: 08S01, ErrorCode: 3113, ErrorMsg: [Oracle][ODBC][Ora]ORA-03113: end-of-file on communication channel ; Error: ODBC read failed

              3.

              SQL##f - SqlState: 08S01, ErrorCode: 12571, ErrorMsg: [Oracle][ODBC][Ora]ORA-12571: TNS:packet writer failure ; Error: ODBC read failed

              4.

              Error: SQL##f - SqlState: S1000, ErrorCode: 12547, ErrorMsg: [Oracle][ODBC][Ora]ORA-12547: TNS:lost contact ; General Script Error

               

              Can you help me regarding these errors.

               

              thanks in advance.

               

              Regards,

              Ankit Joshi