9 Replies Latest reply: Oct 15, 2013 9:05 AM by Michael Solomovich RSS

    Scheduled reloads fail intermittently

    Josephine Campbell

      Hello,

       

      We have a number of scheduled reloads that run each morning around 3 - 5am. At least once a week, one or more of these fail and it's usually a similar error. I think it is something to do with the connection to the database - this is an example of a log. Has anyone else experienced this before? Is there anything we can do to stop the whole document failing? Some of them take around 2.5 hours to reload so it is becoming a big problem for users who want up to date data in the morning.

       

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32: 0269     if(index('Mach:ALAR:CLEA:GUI::DATA:ACTI:#Dat:Effe:Manu:Auto:Eagl:Modu:Spyd:',

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32: 0270      left(EVENT_TEXT,4)&':')=0 and IsDateFunc(left(EVENT_TEXT,10))=0,EVENT_TEXT) as EVENT_TEXT,

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32: 0271     

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32: 0272     1 as ScanRecord,

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32: 0273     MESSAGE_ID

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32: 0274   

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32: 0275    

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32: 0276   

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32: 0279    OLEDB CONNECT*Provider*XPassword*

      13/10/2013 03:33:32.6992540 Information 13/10/2013 03:33:32:         Error: Failed to connect to QlikView Connector.

      13/10/2013 03:33:33.9180888 Information 13/10/2013 03:33:32:         General Script Error

      13/10/2013 03:33:33.9180888 Information 13/10/2013 03:33:33:         Execution Failed

      13/10/2013 03:33:33.9180888 Information 13/10/2013 03:33:33:      Execution finished.