Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you have DISCONNECT after your first load?
what do u mean discconnect
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.
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
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?