PROBLEM WITH INSERT
Posted by: John Sohn
Date: November 15, 2006 10:34AM
Date: November 15, 2006 10:34AM
Hi,
I am using Delphi 2006, and having a problem with INSERT statements when using tADOQuery.
I execute code which generates literal syntactically correct SQL statements and executes them by the thousands, but for some reason its returning an EOLEException with the message "Parameter object is improperly defined. Inconsistent or incomplete information was provided".
What is puzzling me is the generated sql statements, when pasted directly into the Mysql command line tool, are syntactically correct and execute with no problem, that and 1000's of SQL statements generated by the same code are executing no problem, with the excepton of maybe 4 or 5 that fail with this exception for whatever reason.
Here is some sample data.
The problematic code snippet is as follows:
S:='';
t:='';
// GENERATE MYSQL SAFE PARAMETER STRINGS
for X := 1 to Count do
BEGIN
// tosql substitutes escape characters for reserved characters such as nulls and //quotes etc.
ARR[X]:=TOSQLSTRING(TRIM(ARR[X]));
s:=s+ '"' + arr[x] + '"';
if x<> count then s:=s+',';
end;
// GENERATE A COMMAS SEPERATED LIST OF COLUMN NAMES
for x := 0 to f.fieldcount- 1 do
begin
r:=f.getfield(x);
t:=t+r.NAME;
if X <> F.FIELDCOUNT-1 then T:=T+',';
end;
// CREATE SQL STATEMENT
with adoquery1.SQL do
begin
clear;
add('INSERT INTO '+TABLE+ '(' + t +') VALUES('+ s +');');
end;
TRY
adoquery1.ExecSQL;
EXCEPT ON E:EOLEEXCEPTION DO
BEGIN
memo1.lines.add(' ');
memo1.lines.add('>>>>EXCEPTION<<<<');
memo1.lines.add(E.message);
memo1.lines.ADD('ERROR FROM EXECUTING: '+ADOQUERY1.SQL.TEXT);
memo1.lines.add('Param Count: '+ inttostr(count));
memo1.lines.add('Column Count: ' +inttostr(f.fieldcount));
memo1.lines.add('Params:'+t);
memo1.lines.add('Values:'+s);
end;
end;
The program output is as follows:
Memo1
USE RAWDATA RETURNED: 0
EXECUTING: DROP TABLE IF EXISTS CINLIST;
DROP OF CINLIST: 0
EXECUTING: DROP TABLE IF EXISTS ZIPCIN;
DROP OF ZIPCIN: 0
EXECUTING: DROP TABLE IF EXISTS PACKAGESERVICES;
DROP OF PACKAGESERVICES: 0
EXECUTING: DROP TABLE IF EXISTS DROPADDRESSES;
DROP OF DROPADDRESSES: 0
EXECUTING: DROP TABLE IF EXISTS SUPPLEMENTARY;
DROP OF SUPPLEMENTARY: 0
EXECUTING: DROP TABLE IF EXISTS MAILDIRECTION;
DROP OF MAILDIRECTION: 0
EXECUTING: DROP TABLE IF EXISTS DELSTAT;
DROP OF DELSTAT: 0
EXECUTING: DROP TABLE IF EXISTS GEOCODE;
DROP OF GEOCODE: 0
11/15/2006 11:09:30 AM BEGINNING EXTRACTION OF FACILITY ADDRESSES
EXECUTING: CREATE TABLE IF NOT EXISTS DROPADDRESSES(type VARCHAR(1), sitekey VARCHAR(9), sitename VARCHAR(28), Discountcode VARCHAR(1), deladd VARCHAR(58), delcity VARCHAR(28), delstate VARCHAR(2), delzip VARCHAR(9), physadd VARCHAR(58), physstate VARCHAR(2), physzip VARCHAR(9), mailadd VARCHAR(58), mailcity VARCHAR(28), mailstate VARCHAR(2), mailzip VARCHAR(9), dopsitephone VARCHAR(10), logisticsphone VARCHAR(10), commercialphone VARCHAR(10), faxnumber VARCHAR(10) );
CREATE OF DROPADDRESSES RETURNED: 0
11/15/2006 11:09:52 AM ADDRESS EXTRACTION COMPLETE
11/15/2006 11:09:52 AM BEGINNING SUPPLEMENTARY EXTRACTION
EXECUTING: CREATE TABLE IF NOT EXISTS SUPPLEMENTARY(rec_type VARCHAR(1), site_key VARCHAR(9), dock_width VARCHAR(6), dock_depth VARCHAR(6), dock_height VARCHAR(6), canopy_clearance_ft VARCHAR(4), canopy_clearance_in VARCHAR(2), filler VARCHAR(8), manual_load_lift VARCHAR(1), electric_load_lift VARCHAR(1), cage_load_lift VARCHAR(1), roller_load_lift VARCHAR(1), inclined_ramps VARCHAR(2), widest_inclined_ramp VARCHAR(6), accept_class_sacks VARCHAR(1), accept_class_pallets VARCHAR(1), accept_class_bmc VARCHAR(1), accept_class_gpmc_ermc VARCHAR(1), accept_class_others VARCHAR(1), truck_area_length VARCHAR(6), truck_area_width VARCHAR(6), surface_asphalt VARCHAR(1), surface_dirr VARCHAR(1), surface_concrete VARCHAR(1), surface_gravel VARCHAR(1), surface_other VARCHAR(1), overpass_site VARCHAR(1), lowest_overpass VARCHAR(6), access_road_weight VARCHAR(5), directions_p1 VARCHAR(75), directions_p2 VARCHAR(75), directions_p3 VARCHAR(75), directions_p4 VARCHAR(75), proc_hours_sat_am VARCHAR(4), proc_hours_sat_pm VARCHAR(4), proc_hours_sun_am VARCHAR(4), proc_hours_sun_pm VARCHAR(4), proc_hours_mon_am VARCHAR(4), proc_hours_mon_pm VARCHAR(4), proc_hours_tue_am VARCHAR(4), proc_hours_tue_pm VARCHAR(4), proc_hours_wed_am VARCHAR(4), proc_hours_wed_pm VARCHAR(4), proc_hours_thu_am VARCHAR(4), proc_hours_thu_pm VARCHAR(4), proc_hours_fri_am VARCHAR(4), proc_hours_fri_pm VARCHAR(4), latest_time_rcv_for_process VARCHAR(4), bma_system VARCHAR(1), bulk_mail_automated_permit VARCHAR(1), bulk_mail_automated_bravis VARCHAR(1), bulk_mail_automated_other VARCHAR(25), 1stbulk_mail_acceptance_sat_am VARCHAR(4), 1stbulk_mail_acceptance_sat_pm VARCHAR(4), 1stbulk_mail_acceptance_sun_am VARCHAR(4), 1stbulk_mail_acceptance_sun_pm VARCHAR(4), 1stbulk_mail_acceptance_week_am VARCHAR(4), 1stbulk_mail_acceptance_week_pm VARCHAR(4), perbulk_mail_acceptance_sat_am VARCHAR(4), perbulk_mail_acceptance_sat_pm VARCHAR(4), perbulk_mail_acceptance_sun_am VARCHAR(4), perbulk_mail_acceptance_sun_pm VARCHAR(4), perbulk_mail_acceptance_week_am VARCHAR(4), perbulk_mail_acceptance_week_pm VARCHAR(4), stdbulk_mail_acceptance_sat_am VARCHAR(4), stdbulk_mail_acceptance_sat_pm VARCHAR(4), stdbulk_mail_acceptance_sun_am VARCHAR(4), stdbulk_mail_acceptance_sun_pm VARCHAR(4), stdbulk_mail_acceptance_week_am VARCHAR(4), stdbulk_mail_acceptance_week_pm VARCHAR(4), bpmbulk_mail_acceptance_sat_am VARCHAR(4), bpmbulk_mail_acceptance_sat_pm VARCHAR(4), bpmbulk_mail_acceptance_sun_am VARCHAR(4), bpmbulk_mail_acceptance_sun_pm VARCHAR(4), bpmbulk_mail_acceptance_week_am VARCHAR(4), bpmbulk_mail_acceptance_week_pm VARCHAR(4), comment_part_I VARCHAR(75), comment_part_II VARCHAR(75), comment_part_III VARCHAR(75), comment_part_IV VARCHAR(75), comment_part_V VARCHAR(75), max_truck_length VARCHAR(3), number_levelers VARCHAR(4), number_manual_levelers VARCHAR(3), number_hydrau_levelers VARCHAR(3), number_scissor_levelers VARCHAR(3), door_height_feet1 VARCHAR(3), filler2 VARCHAR(1), door_height_feet2 VARCHAR(2), door_height_inches VARCHAR(6), door_steps VARCHAR(6), extended_parcel_hours_early_mon_fri_begin VARCHAR(4), extended_parcel_hours_early_mon_fri_end VARCHAR(4), extended_parcel_hours_add_mon_fri_begin VARCHAR(4), extended_parcel_hours_add_mon_fri_end VARCHAR(4), extended_parcel_hours_parcel_sat_begin VARCHAR(4), extended_parcel_hours_parcel_sat_end VARCHAR(4) );
CREATE OF SUPPLEMENTARY RETURNED: 0
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","EX10273","000207","000035","000120","0011","00","","Y","Y","N","N","01","000009","Y","Y","Y","Y","Y","000236","000098","Y","N","N","N","N","N","000000","00000","185 SOUTH TO EXIT 7. LEFT ONTO MANCHESTER EXPW. LEFT ONTO REESE RD., RIGH","T ONTO MILGEN RD. PO IS ON THE RIGHT APPROX. 1/4 MI.","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","MONDAY-FRIDAY BETWEEN THE HOURS OF 0800-1700 SATURDAY\'S FROM 1200-1600 HRS","SUNDAY FROM 15:50-1900 HRS","","","","065","0002","002","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","EX10273","000207","000035","000120","0011","00","","Y","Y","N","N","01","000009","Y","Y","Y","Y","Y","000236","000098","Y","N","N","N","N","N","000000","00000","185 SOUTH TO EXIT 7. LEFT ONTO MANCHESTER EXPW. LEFT ONTO REESE RD., RIGH","T ONTO MILGEN RD. PO IS ON THE RIGHT APPROX. 1/4 MI.","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","MONDAY-FRIDAY BETWEEN THE HOURS OF 0800-1700 SATURDAY\'S FROM 1200-1600 HRS","SUNDAY FROM 15:50-1900 HRS","","","","065","0002","002","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","EX15573","000300","000035","000048","0018","00","","Y","Y","N","N","01","000008","N","Y","Y","Y","N","000700","000126","Y","N","N","N","N","N","000000","80000","","","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","53\' TRAILER IS MAX ACCOMMODATED. BEST DROP SHIP HOURS ARE 9:00 AM-2:00PM.","NO DROP SHIPS ON SUNDAY FROM 0400 TO 1600 NOT STAFFED.","","","","053","0006","004","006","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","EX15573","000300","000035","000048","0018","00","","Y","Y","N","N","01","000008","N","Y","Y","Y","N","000700","000126","Y","N","N","N","N","N","000000","80000","","","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","53\' TRAILER IS MAX ACCOMMODATED. BEST DROP SHIP HOURS ARE 9:00 AM-2:00PM.","NO DROP SHIPS ON SUNDAY FROM 0400 TO 1600 NOT STAFFED.","","","","053","0006","004","006","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PV22998","000039","000015","000131","0017","00","","N","N","N","N","00","000000","Y","Y","Y","N","N","000020","000040","Y","N","N","N","N","N","000000","80000","FROM I-95 OR THE B/W PARKWAY: TAKE ANNAPOLIS RD.(RT.450W.) OR LANDOVER RD.(","RT 202N.), INTO THE TOWN OF BLADENSBURG, TURN (NORTH)RIGHT ON EDMONSTON RD.","@ THE CHECKER\'S RESTAURANT,TURN (EAST)RIGHT ON TILDEN RD., POST OFFICE IS","2ND BLDG ON RIGHT. FROM SOUTH KENILWORTH AVE. OR I-295S.: FOLLOW KENILWO","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0000","000","000","001","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PV22998","000039","000015","000131","0017","00","","N","N","N","N","00","000000","Y","Y","Y","N","N","000020","000040","Y","N","N","N","N","N","000000","80000","FROM I-95 OR THE B/W PARKWAY: TAKE ANNAPOLIS RD.(RT.450W.) OR LANDOVER RD.(","RT 202N.), INTO THE TOWN OF BLADENSBURG, TURN (NORTH)RIGHT ON EDMONSTON RD.","@ THE CHECKER\'S RESTAURANT,TURN (EAST)RIGHT ON TILDEN RD., POST OFFICE IS","2ND BLDG ON RIGHT. FROM SOUTH KENILWORTH AVE. OR I-295S.: FOLLOW KENILWO","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0000","000","000","001","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PW1B093","000000","000000","000000","0000","00","","N","N","N","N","00","000000","Y","N","N","N","N","000036","000018","N","N","N","Y","N","N","000000","00000","\"HIGHWAY 44 SOUTH TO MAIN ST LEFT AND THEN : LEFT ON SECOND STREET TO THE R","IGHT TO POST OFFICE.","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","036","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PW1B093","000000","000000","000000","0000","00","","N","N","N","N","00","000000","Y","N","N","N","N","000036","000018","N","N","N","Y","N","N","000000","00000","\"HIGHWAY 44 SOUTH TO MAIN ST LEFT AND THEN : LEFT ON SECOND STREET TO THE R","IGHT TO POST OFFICE.","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","036","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PX28244","000015","000008","000097","0008","00","","N","N","N","N","00","000000","Y","N","N","N","N","000048","000047","Y","N","N","N","N","N","000000","80000","EAST ON RT 50: TURN RIGHT ON PATTERSON\'S CREEK RD S OFFICE ON LEFT","WEST ON RT 50: TURN LEFT ON PATTERSON\'S CREEK RD S OFFICE ON LEFT","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","025","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PX28244","000015","000008","000097","0008","00","","N","N","N","N","00","000000","Y","N","N","N","N","000048","000047","Y","N","N","N","N","N","000000","80000","EAST ON RT 50: TURN RIGHT ON PATTERSON\'S CREEK RD S OFFICE ON LEFT","WEST ON RT 50: TURN LEFT ON PATTERSON\'S CREEK RD S OFFICE ON LEFT","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","025","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PY12970","000008","000006","000008","0011","00","","N","N","N","N","00","000000","Y","N","N","N","N","000075","000012","N","Y","N","N","N","N","000000","80000","FROM THE NORTH: US 31 AND 669 (S T\'VILLE HWY), SOUTH ON 669 10 MILES TO WAT","ERTOWER. RIGHT AT TOWER (THOMPSON AVE) 2 BLOCKS TO PO. FROM THE SOUTH: M11","5 AND 669 (THOMPSONVILLE RD), NORTH ON 669 TO WATERTOWER. LEFT AT TOWER (TH","OMPSONV AVE) 2 BLOCKS TO PO.","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","075","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PY12970","000008","000006","000008","0011","00","","N","N","N","N","00","000000","Y","N","N","N","N","000075","000012","N","Y","N","N","N","N","000000","80000","FROM THE NORTH: US 31 AND 669 (S T\'VILLE HWY), SOUTH ON 669 10 MILES TO WAT","ERTOWER. RIGHT AT TOWER (THOMPSON AVE) 2 BLOCKS TO PO. FROM THE SOUTH: M11","5 AND 669 (THOMPSONVILLE RD), NORTH ON 669 TO WATERTOWER. LEFT AT TOWER (TH","OMPSONV AVE) 2 BLOCKS TO PO.","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","075","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PZ16079","000008","000002","000004","0018","00","","Y","N","N","N","00","000000","Y","Y","Y","Y","N","000120","000055","N","N","Y","N","N","Y","000018","80000","CUSTOMERS: EXIT I-15 AT KAYSVILLE. GO EAST ON 200 N TO MAIN ST. TURN LEFT","AT LIGHT. THE POST OFFICE IS NORTH OF ALBERTSTON\'S. TRUCKS: EXIT I-15 A","T KAYSVILLE. GO EAST ON 200 N TO 200 W. GO NORTH ON 200 W TO THE POST OFFI","CE PARKING LOT.","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0002","000","002","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PZ16079","000008","000002","000004","0018","00","","Y","N","N","N","00","000000","Y","Y","Y","Y","N","000120","000055","N","N","Y","N","N","Y","000018","80000","CUSTOMERS: EXIT I-15 AT KAYSVILLE. GO EAST ON 200 N TO MAIN ST. TURN LEFT","AT LIGHT. THE POST OFFICE IS NORTH OF ALBERTSTON\'S. TRUCKS: EXIT I-15 A","T KAYSVILLE. GO EAST ON 200 N TO 200 W. GO NORTH ON 200 W TO THE POST OFFI","CE PARKING LOT.","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0002","000","002","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PZ22153","000000","000000","000000","0000","00","","N","N","N","N","00","000000","N","N","N","N","Y","000150","000150","Y","N","N","N","N","N","000000","80000","20 MILES E OF BARSTOW ON I-40 EASTBOUND. EXIT AT 1ST NEWBERRY SPRINGS. TU","RN RIGHT. THIS IS NAT\'L TRAILS HWY OR RTE-66. GO ABOUT 2 MILES TO NEWBERR","Y RD & TURN LEFT. PO IS 2ND BLDG ON RIGHT. I-40 WESTBOUND: EXIT AT THE 1S","T NEWBERRY SPRINGS, TURN LEFT. AT 1ST STOP SIGN, TURN RIGHT ON NAT\'L TRAIL","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PZ22153","000000","000000","000000","0000","00","","N","N","N","N","00","000000","N","N","N","N","Y","000150","000150","Y","N","N","N","N","N","000000","80000","20 MILES E OF BARSTOW ON I-40 EASTBOUND. EXIT AT 1ST NEWBERRY SPRINGS. TU","RN RIGHT. THIS IS NAT\'L TRAILS HWY OR RTE-66. GO ABOUT 2 MILES TO NEWBERR","Y RD & TURN LEFT. PO IS 2ND BLDG ON RIGHT. I-40 WESTBOUND: EXIT AT THE 1S","T NEWBERRY SPRINGS, TURN LEFT. AT 1ST STOP SIGN, TURN RIGHT ON NAT\'L TRAIL","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
11/15/2006 11:12:19 AM ENDING EXTRACTION OF SUPPLEMENTARY FILES
11/15/2006 11:12:19 AM BEGINNING EXTRACTION OF PACKAGE SERVICES DETAIL
EXECUTING: CREATE TABLE IF NOT EXISTS PACKAGESERVICES(type VARCHAR(1), ZIPCODE VARCHAR(5), FILLER VARCHAR(2), DDU_KEY VARCHAR(8), DSCF_KEY VARCHAR(8), SCF_EXCEPTION VARCHAR(1), FILLER2 VARCHAR(30) );
CREATE OF PACKAGESERVICES RETURNED: 0
11/15/2006 11:12:35 AM BEGINNING EXTRACTION OF ZIP CIN DETAIL
EXECUTING: CREATE TABLE IF NOT EXISTS ZIPCIN(type VARCHAR(1), ZIPCODE VARCHAR(5), crrt VARCHAR(4), dropshop_key VARCHAR(9), discount_type VARCHAR(1), cin_code VARCHAR(3), pallet_code VARCHAR(1), FILLER VARCHAR(9) );
CREATE OF ZIPCIN RETURNED: 0
ending extraction...
11/15/2006 11:14:14 AM BEGINNING EXTRACTION OF CIN LIST DETAIL
EXECUTING: CREATE TABLE IF NOT EXISTS CINLIST(type VARCHAR(1), CIN_CODE VARCHAR(3), PALLET_CODE VARCHAR(1), PRIMARY_MAIL_CLASS VARCHAR(10), SECONDARY_MAIL_CLASS VARCHAR(10), MAIL_SHAPE VARCHAR(10), DISCOUNT_TYPE_CODE VARCHAR(1), SORT_TYPE VARCHAR(50) );
CREATE OF CINLIST RETURNED: 0
ending extraction...
11/15/2006 11:14:14 AM BEGINNING EXTRACTION OF MAIL DIRECTION DETAIL
EXECUTING: CREATE TABLE IF NOT EXISTS MAILDIRECTION(type VARCHAR(1), DROPSHIP_ZIP_CODE VARCHAR(5), CRRT VARCHAR(4), DROPSHIP_KEY VARCHAR(9), DISCOUNT_TYPE_CODE1 VARCHAR(1), PALLET_CODE VARCHAR(1), DISCOUNT_TYPE_CODE2 VARCHAR(1), MAIL_CLASS VARCHAR(10), MAIL_SHAPE VARCHAR(10), START_DATE VARCHAR(8), END_DATE VARCHAR(8), ACTUAL_DROP_END_DATE VARCHAR(8), DEFAULT_DROP_END_DATE VARCHAR(8), NASS_CODE VARCHAR(5), LAST_UPDATE_DATE VARCHAR(8) );
CREATE OF MAILDIRECTION RETURNED: 0
ending extraction...
I am using Delphi 2006, and having a problem with INSERT statements when using tADOQuery.
I execute code which generates literal syntactically correct SQL statements and executes them by the thousands, but for some reason its returning an EOLEException with the message "Parameter object is improperly defined. Inconsistent or incomplete information was provided".
What is puzzling me is the generated sql statements, when pasted directly into the Mysql command line tool, are syntactically correct and execute with no problem, that and 1000's of SQL statements generated by the same code are executing no problem, with the excepton of maybe 4 or 5 that fail with this exception for whatever reason.
Here is some sample data.
The problematic code snippet is as follows:
S:='';
t:='';
// GENERATE MYSQL SAFE PARAMETER STRINGS
for X := 1 to Count do
BEGIN
// tosql substitutes escape characters for reserved characters such as nulls and //quotes etc.
ARR[X]:=TOSQLSTRING(TRIM(ARR[X]));
s:=s+ '"' + arr[x] + '"';
if x<> count then s:=s+',';
end;
// GENERATE A COMMAS SEPERATED LIST OF COLUMN NAMES
for x := 0 to f.fieldcount- 1 do
begin
r:=f.getfield(x);
t:=t+r.NAME;
if X <> F.FIELDCOUNT-1 then T:=T+',';
end;
// CREATE SQL STATEMENT
with adoquery1.SQL do
begin
clear;
add('INSERT INTO '+TABLE+ '(' + t +') VALUES('+ s +');');
end;
TRY
adoquery1.ExecSQL;
EXCEPT ON E:EOLEEXCEPTION DO
BEGIN
memo1.lines.add(' ');
memo1.lines.add('>>>>EXCEPTION<<<<');
memo1.lines.add(E.message);
memo1.lines.ADD('ERROR FROM EXECUTING: '+ADOQUERY1.SQL.TEXT);
memo1.lines.add('Param Count: '+ inttostr(count));
memo1.lines.add('Column Count: ' +inttostr(f.fieldcount));
memo1.lines.add('Params:'+t);
memo1.lines.add('Values:'+s);
end;
end;
The program output is as follows:
Memo1
USE RAWDATA RETURNED: 0
EXECUTING: DROP TABLE IF EXISTS CINLIST;
DROP OF CINLIST: 0
EXECUTING: DROP TABLE IF EXISTS ZIPCIN;
DROP OF ZIPCIN: 0
EXECUTING: DROP TABLE IF EXISTS PACKAGESERVICES;
DROP OF PACKAGESERVICES: 0
EXECUTING: DROP TABLE IF EXISTS DROPADDRESSES;
DROP OF DROPADDRESSES: 0
EXECUTING: DROP TABLE IF EXISTS SUPPLEMENTARY;
DROP OF SUPPLEMENTARY: 0
EXECUTING: DROP TABLE IF EXISTS MAILDIRECTION;
DROP OF MAILDIRECTION: 0
EXECUTING: DROP TABLE IF EXISTS DELSTAT;
DROP OF DELSTAT: 0
EXECUTING: DROP TABLE IF EXISTS GEOCODE;
DROP OF GEOCODE: 0
11/15/2006 11:09:30 AM BEGINNING EXTRACTION OF FACILITY ADDRESSES
EXECUTING: CREATE TABLE IF NOT EXISTS DROPADDRESSES(type VARCHAR(1), sitekey VARCHAR(9), sitename VARCHAR(28), Discountcode VARCHAR(1), deladd VARCHAR(58), delcity VARCHAR(28), delstate VARCHAR(2), delzip VARCHAR(9), physadd VARCHAR(58), physstate VARCHAR(2), physzip VARCHAR(9), mailadd VARCHAR(58), mailcity VARCHAR(28), mailstate VARCHAR(2), mailzip VARCHAR(9), dopsitephone VARCHAR(10), logisticsphone VARCHAR(10), commercialphone VARCHAR(10), faxnumber VARCHAR(10) );
CREATE OF DROPADDRESSES RETURNED: 0
11/15/2006 11:09:52 AM ADDRESS EXTRACTION COMPLETE
11/15/2006 11:09:52 AM BEGINNING SUPPLEMENTARY EXTRACTION
EXECUTING: CREATE TABLE IF NOT EXISTS SUPPLEMENTARY(rec_type VARCHAR(1), site_key VARCHAR(9), dock_width VARCHAR(6), dock_depth VARCHAR(6), dock_height VARCHAR(6), canopy_clearance_ft VARCHAR(4), canopy_clearance_in VARCHAR(2), filler VARCHAR(8), manual_load_lift VARCHAR(1), electric_load_lift VARCHAR(1), cage_load_lift VARCHAR(1), roller_load_lift VARCHAR(1), inclined_ramps VARCHAR(2), widest_inclined_ramp VARCHAR(6), accept_class_sacks VARCHAR(1), accept_class_pallets VARCHAR(1), accept_class_bmc VARCHAR(1), accept_class_gpmc_ermc VARCHAR(1), accept_class_others VARCHAR(1), truck_area_length VARCHAR(6), truck_area_width VARCHAR(6), surface_asphalt VARCHAR(1), surface_dirr VARCHAR(1), surface_concrete VARCHAR(1), surface_gravel VARCHAR(1), surface_other VARCHAR(1), overpass_site VARCHAR(1), lowest_overpass VARCHAR(6), access_road_weight VARCHAR(5), directions_p1 VARCHAR(75), directions_p2 VARCHAR(75), directions_p3 VARCHAR(75), directions_p4 VARCHAR(75), proc_hours_sat_am VARCHAR(4), proc_hours_sat_pm VARCHAR(4), proc_hours_sun_am VARCHAR(4), proc_hours_sun_pm VARCHAR(4), proc_hours_mon_am VARCHAR(4), proc_hours_mon_pm VARCHAR(4), proc_hours_tue_am VARCHAR(4), proc_hours_tue_pm VARCHAR(4), proc_hours_wed_am VARCHAR(4), proc_hours_wed_pm VARCHAR(4), proc_hours_thu_am VARCHAR(4), proc_hours_thu_pm VARCHAR(4), proc_hours_fri_am VARCHAR(4), proc_hours_fri_pm VARCHAR(4), latest_time_rcv_for_process VARCHAR(4), bma_system VARCHAR(1), bulk_mail_automated_permit VARCHAR(1), bulk_mail_automated_bravis VARCHAR(1), bulk_mail_automated_other VARCHAR(25), 1stbulk_mail_acceptance_sat_am VARCHAR(4), 1stbulk_mail_acceptance_sat_pm VARCHAR(4), 1stbulk_mail_acceptance_sun_am VARCHAR(4), 1stbulk_mail_acceptance_sun_pm VARCHAR(4), 1stbulk_mail_acceptance_week_am VARCHAR(4), 1stbulk_mail_acceptance_week_pm VARCHAR(4), perbulk_mail_acceptance_sat_am VARCHAR(4), perbulk_mail_acceptance_sat_pm VARCHAR(4), perbulk_mail_acceptance_sun_am VARCHAR(4), perbulk_mail_acceptance_sun_pm VARCHAR(4), perbulk_mail_acceptance_week_am VARCHAR(4), perbulk_mail_acceptance_week_pm VARCHAR(4), stdbulk_mail_acceptance_sat_am VARCHAR(4), stdbulk_mail_acceptance_sat_pm VARCHAR(4), stdbulk_mail_acceptance_sun_am VARCHAR(4), stdbulk_mail_acceptance_sun_pm VARCHAR(4), stdbulk_mail_acceptance_week_am VARCHAR(4), stdbulk_mail_acceptance_week_pm VARCHAR(4), bpmbulk_mail_acceptance_sat_am VARCHAR(4), bpmbulk_mail_acceptance_sat_pm VARCHAR(4), bpmbulk_mail_acceptance_sun_am VARCHAR(4), bpmbulk_mail_acceptance_sun_pm VARCHAR(4), bpmbulk_mail_acceptance_week_am VARCHAR(4), bpmbulk_mail_acceptance_week_pm VARCHAR(4), comment_part_I VARCHAR(75), comment_part_II VARCHAR(75), comment_part_III VARCHAR(75), comment_part_IV VARCHAR(75), comment_part_V VARCHAR(75), max_truck_length VARCHAR(3), number_levelers VARCHAR(4), number_manual_levelers VARCHAR(3), number_hydrau_levelers VARCHAR(3), number_scissor_levelers VARCHAR(3), door_height_feet1 VARCHAR(3), filler2 VARCHAR(1), door_height_feet2 VARCHAR(2), door_height_inches VARCHAR(6), door_steps VARCHAR(6), extended_parcel_hours_early_mon_fri_begin VARCHAR(4), extended_parcel_hours_early_mon_fri_end VARCHAR(4), extended_parcel_hours_add_mon_fri_begin VARCHAR(4), extended_parcel_hours_add_mon_fri_end VARCHAR(4), extended_parcel_hours_parcel_sat_begin VARCHAR(4), extended_parcel_hours_parcel_sat_end VARCHAR(4) );
CREATE OF SUPPLEMENTARY RETURNED: 0
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","EX10273","000207","000035","000120","0011","00","","Y","Y","N","N","01","000009","Y","Y","Y","Y","Y","000236","000098","Y","N","N","N","N","N","000000","00000","185 SOUTH TO EXIT 7. LEFT ONTO MANCHESTER EXPW. LEFT ONTO REESE RD., RIGH","T ONTO MILGEN RD. PO IS ON THE RIGHT APPROX. 1/4 MI.","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","MONDAY-FRIDAY BETWEEN THE HOURS OF 0800-1700 SATURDAY\'S FROM 1200-1600 HRS","SUNDAY FROM 15:50-1900 HRS","","","","065","0002","002","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","EX10273","000207","000035","000120","0011","00","","Y","Y","N","N","01","000009","Y","Y","Y","Y","Y","000236","000098","Y","N","N","N","N","N","000000","00000","185 SOUTH TO EXIT 7. LEFT ONTO MANCHESTER EXPW. LEFT ONTO REESE RD., RIGH","T ONTO MILGEN RD. PO IS ON THE RIGHT APPROX. 1/4 MI.","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","MONDAY-FRIDAY BETWEEN THE HOURS OF 0800-1700 SATURDAY\'S FROM 1200-1600 HRS","SUNDAY FROM 15:50-1900 HRS","","","","065","0002","002","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","EX15573","000300","000035","000048","0018","00","","Y","Y","N","N","01","000008","N","Y","Y","Y","N","000700","000126","Y","N","N","N","N","N","000000","80000","","","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","53\' TRAILER IS MAX ACCOMMODATED. BEST DROP SHIP HOURS ARE 9:00 AM-2:00PM.","NO DROP SHIPS ON SUNDAY FROM 0400 TO 1600 NOT STAFFED.","","","","053","0006","004","006","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","EX15573","000300","000035","000048","0018","00","","Y","Y","N","N","01","000008","N","Y","Y","Y","N","000700","000126","Y","N","N","N","N","N","000000","80000","","","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","53\' TRAILER IS MAX ACCOMMODATED. BEST DROP SHIP HOURS ARE 9:00 AM-2:00PM.","NO DROP SHIPS ON SUNDAY FROM 0400 TO 1600 NOT STAFFED.","","","","053","0006","004","006","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PV22998","000039","000015","000131","0017","00","","N","N","N","N","00","000000","Y","Y","Y","N","N","000020","000040","Y","N","N","N","N","N","000000","80000","FROM I-95 OR THE B/W PARKWAY: TAKE ANNAPOLIS RD.(RT.450W.) OR LANDOVER RD.(","RT 202N.), INTO THE TOWN OF BLADENSBURG, TURN (NORTH)RIGHT ON EDMONSTON RD.","@ THE CHECKER\'S RESTAURANT,TURN (EAST)RIGHT ON TILDEN RD., POST OFFICE IS","2ND BLDG ON RIGHT. FROM SOUTH KENILWORTH AVE. OR I-295S.: FOLLOW KENILWO","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0000","000","000","001","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PV22998","000039","000015","000131","0017","00","","N","N","N","N","00","000000","Y","Y","Y","N","N","000020","000040","Y","N","N","N","N","N","000000","80000","FROM I-95 OR THE B/W PARKWAY: TAKE ANNAPOLIS RD.(RT.450W.) OR LANDOVER RD.(","RT 202N.), INTO THE TOWN OF BLADENSBURG, TURN (NORTH)RIGHT ON EDMONSTON RD.","@ THE CHECKER\'S RESTAURANT,TURN (EAST)RIGHT ON TILDEN RD., POST OFFICE IS","2ND BLDG ON RIGHT. FROM SOUTH KENILWORTH AVE. OR I-295S.: FOLLOW KENILWO","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0000","000","000","001","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PW1B093","000000","000000","000000","0000","00","","N","N","N","N","00","000000","Y","N","N","N","N","000036","000018","N","N","N","Y","N","N","000000","00000","\"HIGHWAY 44 SOUTH TO MAIN ST LEFT AND THEN : LEFT ON SECOND STREET TO THE R","IGHT TO POST OFFICE.","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","036","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PW1B093","000000","000000","000000","0000","00","","N","N","N","N","00","000000","Y","N","N","N","N","000036","000018","N","N","N","Y","N","N","000000","00000","\"HIGHWAY 44 SOUTH TO MAIN ST LEFT AND THEN : LEFT ON SECOND STREET TO THE R","IGHT TO POST OFFICE.","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","036","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PX28244","000015","000008","000097","0008","00","","N","N","N","N","00","000000","Y","N","N","N","N","000048","000047","Y","N","N","N","N","N","000000","80000","EAST ON RT 50: TURN RIGHT ON PATTERSON\'S CREEK RD S OFFICE ON LEFT","WEST ON RT 50: TURN LEFT ON PATTERSON\'S CREEK RD S OFFICE ON LEFT","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","025","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PX28244","000015","000008","000097","0008","00","","N","N","N","N","00","000000","Y","N","N","N","N","000048","000047","Y","N","N","N","N","N","000000","80000","EAST ON RT 50: TURN RIGHT ON PATTERSON\'S CREEK RD S OFFICE ON LEFT","WEST ON RT 50: TURN LEFT ON PATTERSON\'S CREEK RD S OFFICE ON LEFT","","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","025","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PY12970","000008","000006","000008","0011","00","","N","N","N","N","00","000000","Y","N","N","N","N","000075","000012","N","Y","N","N","N","N","000000","80000","FROM THE NORTH: US 31 AND 669 (S T\'VILLE HWY), SOUTH ON 669 10 MILES TO WAT","ERTOWER. RIGHT AT TOWER (THOMPSON AVE) 2 BLOCKS TO PO. FROM THE SOUTH: M11","5 AND 669 (THOMPSONVILLE RD), NORTH ON 669 TO WATERTOWER. LEFT AT TOWER (TH","OMPSONV AVE) 2 BLOCKS TO PO.","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","075","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PY12970","000008","000006","000008","0011","00","","N","N","N","N","00","000000","Y","N","N","N","N","000075","000012","N","Y","N","N","N","N","000000","80000","FROM THE NORTH: US 31 AND 669 (S T\'VILLE HWY), SOUTH ON 669 10 MILES TO WAT","ERTOWER. RIGHT AT TOWER (THOMPSON AVE) 2 BLOCKS TO PO. FROM THE SOUTH: M11","5 AND 669 (THOMPSONVILLE RD), NORTH ON 669 TO WATERTOWER. LEFT AT TOWER (TH","OMPSONV AVE) 2 BLOCKS TO PO.","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","075","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PZ16079","000008","000002","000004","0018","00","","Y","N","N","N","00","000000","Y","Y","Y","Y","N","000120","000055","N","N","Y","N","N","Y","000018","80000","CUSTOMERS: EXIT I-15 AT KAYSVILLE. GO EAST ON 200 N TO MAIN ST. TURN LEFT","AT LIGHT. THE POST OFFICE IS NORTH OF ALBERTSTON\'S. TRUCKS: EXIT I-15 A","T KAYSVILLE. GO EAST ON 200 N TO 200 W. GO NORTH ON 200 W TO THE POST OFFI","CE PARKING LOT.","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0002","000","002","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PZ16079","000008","000002","000004","0018","00","","Y","N","N","N","00","000000","Y","Y","Y","Y","N","000120","000055","N","N","Y","N","N","Y","000018","80000","CUSTOMERS: EXIT I-15 AT KAYSVILLE. GO EAST ON 200 N TO MAIN ST. TURN LEFT","AT LIGHT. THE POST OFFICE IS NORTH OF ALBERTSTON\'S. TRUCKS: EXIT I-15 A","T KAYSVILLE. GO EAST ON 200 N TO 200 W. GO NORTH ON 200 W TO THE POST OFFI","CE PARKING LOT.","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","Y","N","","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0002","000","002","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
>>>>EXCEPTION<<<<
Parameter object is improperly defined. Inconsistent or incomplete information was provided
ERROR FROM EXECUTING: INSERT INTO SUPPLEMENTARY(rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end) VALUES("D","PZ22153","000000","000000","000000","0000","00","","N","N","N","N","00","000000","N","N","N","N","Y","000150","000150","Y","N","N","N","N","N","000000","80000","20 MILES E OF BARSTOW ON I-40 EASTBOUND. EXIT AT 1ST NEWBERRY SPRINGS. TU","RN RIGHT. THIS IS NAT\'L TRAILS HWY OR RTE-66. GO ABOUT 2 MILES TO NEWBERR","Y RD & TURN LEFT. PO IS 2ND BLDG ON RIGHT. I-40 WESTBOUND: EXIT AT THE 1S","T NEWBERRY SPRINGS, TURN LEFT. AT 1ST STOP SIGN, TURN RIGHT ON NAT\'L TRAIL","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000");
Param Count: 97
Column Count: 97
Params:rec_type,site_key,dock_width,dock_depth,dock_height,canopy_clearance_ft,canopy_clearance_in,filler,manual_load_lift,electric_load_lift,cage_load_lift,roller_load_lift,inclined_ramps,widest_inclined_ramp,accept_class_sacks,accept_class_pallets,accept_class_bmc,accept_class_gpmc_ermc,accept_class_others,truck_area_length,truck_area_width,surface_asphalt,surface_dirr,surface_concrete,surface_gravel,surface_other,overpass_site,lowest_overpass,access_road_weight,directions_p1,directions_p2,directions_p3,directions_p4,proc_hours_sat_am,proc_hours_sat_pm,proc_hours_sun_am,proc_hours_sun_pm,proc_hours_mon_am,proc_hours_mon_pm,proc_hours_tue_am,proc_hours_tue_pm,proc_hours_wed_am,proc_hours_wed_pm,proc_hours_thu_am,proc_hours_thu_pm,proc_hours_fri_am,proc_hours_fri_pm,latest_time_rcv_for_process,bma_system,bulk_mail_automated_permit,bulk_mail_automated_bravis,bulk_mail_automated_other,1stbulk_mail_acceptance_sat_am,1stbulk_mail_acceptance_sat_pm,1stbulk_mail_acceptance_sun_am,1stbulk_mail_acceptance_sun_pm,1stbulk_mail_acceptance_week_am,1stbulk_mail_acceptance_week_pm,perbulk_mail_acceptance_sat_am,perbulk_mail_acceptance_sat_pm,perbulk_mail_acceptance_sun_am,perbulk_mail_acceptance_sun_pm,perbulk_mail_acceptance_week_am,perbulk_mail_acceptance_week_pm,stdbulk_mail_acceptance_sat_am,stdbulk_mail_acceptance_sat_pm,stdbulk_mail_acceptance_sun_am,stdbulk_mail_acceptance_sun_pm,stdbulk_mail_acceptance_week_am,stdbulk_mail_acceptance_week_pm,bpmbulk_mail_acceptance_sat_am,bpmbulk_mail_acceptance_sat_pm,bpmbulk_mail_acceptance_sun_am,bpmbulk_mail_acceptance_sun_pm,bpmbulk_mail_acceptance_week_am,bpmbulk_mail_acceptance_week_pm,comment_part_I,comment_part_II,comment_part_III,comment_part_IV,comment_part_V,max_truck_length,number_levelers,number_manual_levelers,number_hydrau_levelers,number_scissor_levelers,door_height_feet1,filler2,door_height_feet2,door_height_inches,door_steps,extended_parcel_hours_early_mon_fri_begin,extended_parcel_hours_early_mon_fri_end,extended_parcel_hours_add_mon_fri_begin,extended_parcel_hours_add_mon_fri_end,extended_parcel_hours_parcel_sat_begin,extended_parcel_hours_parcel_sat_end
Values:"D","PZ22153","000000","000000","000000","0000","00","","N","N","N","N","00","000000","N","N","N","N","Y","000150","000150","Y","N","N","N","N","N","000000","80000","20 MILES E OF BARSTOW ON I-40 EASTBOUND. EXIT AT 1ST NEWBERRY SPRINGS. TU","RN RIGHT. THIS IS NAT\'L TRAILS HWY OR RTE-66. GO ABOUT 2 MILES TO NEWBERR","Y RD & TURN LEFT. PO IS 2ND BLDG ON RIGHT. I-40 WESTBOUND: EXIT AT THE 1S","T NEWBERRY SPRINGS, TURN LEFT. AT 1ST STOP SIGN, TURN RIGHT ON NAT\'L TRAIL","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","N","N","N","0","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","0000","","","","","","000","0000","000","000","000","000","","00","000000","000000","0000","0000","0000","0000","0000","0000"
11/15/2006 11:12:19 AM ENDING EXTRACTION OF SUPPLEMENTARY FILES
11/15/2006 11:12:19 AM BEGINNING EXTRACTION OF PACKAGE SERVICES DETAIL
EXECUTING: CREATE TABLE IF NOT EXISTS PACKAGESERVICES(type VARCHAR(1), ZIPCODE VARCHAR(5), FILLER VARCHAR(2), DDU_KEY VARCHAR(8), DSCF_KEY VARCHAR(8), SCF_EXCEPTION VARCHAR(1), FILLER2 VARCHAR(30) );
CREATE OF PACKAGESERVICES RETURNED: 0
11/15/2006 11:12:35 AM BEGINNING EXTRACTION OF ZIP CIN DETAIL
EXECUTING: CREATE TABLE IF NOT EXISTS ZIPCIN(type VARCHAR(1), ZIPCODE VARCHAR(5), crrt VARCHAR(4), dropshop_key VARCHAR(9), discount_type VARCHAR(1), cin_code VARCHAR(3), pallet_code VARCHAR(1), FILLER VARCHAR(9) );
CREATE OF ZIPCIN RETURNED: 0
ending extraction...
11/15/2006 11:14:14 AM BEGINNING EXTRACTION OF CIN LIST DETAIL
EXECUTING: CREATE TABLE IF NOT EXISTS CINLIST(type VARCHAR(1), CIN_CODE VARCHAR(3), PALLET_CODE VARCHAR(1), PRIMARY_MAIL_CLASS VARCHAR(10), SECONDARY_MAIL_CLASS VARCHAR(10), MAIL_SHAPE VARCHAR(10), DISCOUNT_TYPE_CODE VARCHAR(1), SORT_TYPE VARCHAR(50) );
CREATE OF CINLIST RETURNED: 0
ending extraction...
11/15/2006 11:14:14 AM BEGINNING EXTRACTION OF MAIL DIRECTION DETAIL
EXECUTING: CREATE TABLE IF NOT EXISTS MAILDIRECTION(type VARCHAR(1), DROPSHIP_ZIP_CODE VARCHAR(5), CRRT VARCHAR(4), DROPSHIP_KEY VARCHAR(9), DISCOUNT_TYPE_CODE1 VARCHAR(1), PALLET_CODE VARCHAR(1), DISCOUNT_TYPE_CODE2 VARCHAR(1), MAIL_CLASS VARCHAR(10), MAIL_SHAPE VARCHAR(10), START_DATE VARCHAR(8), END_DATE VARCHAR(8), ACTUAL_DROP_END_DATE VARCHAR(8), DEFAULT_DROP_END_DATE VARCHAR(8), NASS_CODE VARCHAR(5), LAST_UPDATE_DATE VARCHAR(8) );
CREATE OF MAILDIRECTION RETURNED: 0
ending extraction...
Subject
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.