weird issue with a schedule job

[Anonymous]

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

[m_woolf]

Do you have DISCONNECT after your first load?

[Anonymous]

what do u mean discconnect

[m_woolf]

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.

[Anonymous]

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

[Anonymous]

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

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?