5 Replies Latest reply: Jun 4, 2015 6:23 PM by Jackie fung RSS

    weird issue with a schedule job

    Jackie fung

      hello

       

      i have a sql load prep job that loads a bunch of info into a qvd to be used on another qvw later..

       

      but this one keeps giving the error below randomly..

       

      the qvw before it hits the same db and table so i set a break of 5 min between to see if thats the issue

       

      still happens..

       

      but after the error below.. when i just go in and click reload it works fine with no issues.

       

      this is on qv 11 currently. but the load was developed in qv9.. not sure if that has any relevance

       

      6/3/2015 09:12:03.2832541    Information    6/3/2015 9:12:03 AM:   Error: Did not recognise connector reply
      6/3/2015 09:12:03.2842310    Information    6/3/2015 9:12:03 AM:   General Script Error
      6/3/2015 09:12:03.2852079    Information    6/3/2015 9:12:03 AM:   Execution Failed
      6/3/2015 09:12:03.2852079    Information    6/3/2015 9:12:03 AM:  Execution finished.

       

       

      thanks

        • Re: weird issue with a schedule job
          m w

          Do you have DISCONNECT after your first load?

            • Re: weird issue with a schedule job
              Jackie fung

              what do u mean discconnect

                • Re: weird issue with a schedule job
                  m w

                  At the end of your load script.

                   

                  DISCONNECT;     //Terminates the current ODBC/OLEDB/Custom connection.

                   

                  According to Help, DISCONNECT is optional, but we have experience some problems with data loads (especially Lotus Notes) if the DISCONNECT statement is absent.

                    • Re: weird issue with a schedule job
                      Jackie fung

                      so this should be placed im guessing in the one before this script runs..

                       

                      and ill try this at the end of this script will try it and update you

                       

                      thanks so much

                        • Re: weird issue with a schedule job
                          Jackie fung

                          hi

                           

                          i put the disconnect in load previous.. and it the thing still failed today with the same error...

                           

                           

                          6/4/2015 09:04:57.2577245    Information    6/4/2015 9:04:57 AM: 0043  where StyleType='RM'

                          6/4/2015 09:04:57.2577245    Information    6/4/2015 9:04:57 AM:        | 24 fields found: Division, Style, Color, Label, DmPk, SizeBucket, Size, QOH Qty, Qty, WIP Qty, OTS Prod Qty, Returned Qty, Stock Adj Qty, Open Qty, Cancel Qty, Pick Qty, Invoice Qty, Received Qty, ProductKey_RM_CNS, Source, SizeCode, StyleType, CNS.Delivery Code,

                          6/4/2015 09:04:58.1642877    Information    CNS.Delivery, 49,238 lines fetched

                          6/4/2015 09:04:58.4661498    Information    6/4/2015 9:04:58 AM: 0045  Store CNS_SQL_RM into [E:\Documents and Settings\qlickview\My Documents\Qlikview Development\DataSources\CNS_SQL_RM.qvd]

                          6/4/2015 09:04:58.4690805    Information    6/4/2015 9:04:58 AM: 0047  DISCONNECT

                          6/4/2015 09:04:58.4690805    Information    6/4/2015 9:04:58 AM:      Execution finished.

                           

                          this is the script before the one that fails.

                           

                          also i put a wait of 6 mins between this finish and the next one start and it still fails with the error below.

                           

                          6/3/2015 09:12:03.2832541    Information    6/3/2015 9:12:03 AM:   Error: Did not recognise connector reply
                          6/3/2015 09:12:03.2842310    Information    6/3/2015 9:12:03 AM:   General Script Error
                          6/3/2015 09:12:03.2852079    Information    6/3/2015 9:12:03 AM:   Execution Failed
                          6/3/2015 09:12:03.2852079    Information    6/3/2015 9:12:03 AM:  Execution finished.

                           

                          any other ideas?