topic Re: weird issue with a schedule job in QlikView

weird issue with a schedule job

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

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_woolf — Wed, 03 Jun 2015 14:27:19 GMT

Do you have DISCONNECT after your first load?

Re: weird issue with a schedule job

Anonymous — Wed, 03 Jun 2015 14:38:26 GMT

what do u mean discconnect

Re: weird issue with a schedule job

m_woolf — Wed, 03 Jun 2015 14:43:39 GMT

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

Anonymous — Wed, 03 Jun 2015 15:14:19 GMT

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

Anonymous — Thu, 04 Jun 2015 22:23:45 GMT

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

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?