The document is a database load report from July 19, 2015. It describes loading collar data from a file into a table called "collar" in the putra_database. There were numerous warnings reported about incorrect data types and field lengths during the load process. Values in certain fields like hole_id, x, y, z and max_depth were too long for the defined fields or were non-numeric when numeric values were expected. A total of 94 records were attempted to be loaded from the file.
The document is a database load report from July 19, 2015. It describes loading collar data from a file into a table called "collar" in the putra_database. There were numerous warnings reported about incorrect data types and field lengths during the load process. Values in certain fields like hole_id, x, y, z and max_depth were too long for the defined fields or were non-numeric when numeric values were expected. A total of 94 records were attempted to be loaded from the file.
The document is a database load report from July 19, 2015. It describes loading collar data from a file into a table called "collar" in the putra_database. There were numerous warnings reported about incorrect data types and field lengths during the load process. Values in certain fields like hole_id, x, y, z and max_depth were too long for the defined fields or were non-numeric when numeric values were expected. A total of 94 records were attempted to be loaded from the file.
The document is a database load report from July 19, 2015. It describes loading collar data from a file into a table called "collar" in the putra_database. There were numerous warnings reported about incorrect data types and field lengths during the load process. Values in certain fields like hole_id, x, y, z and max_depth were too long for the defined fields or were non-numeric when numeric values were expected. A total of 94 records were attempted to be loaded from the file.
Date : 19-Jul-15 Database : putra_database Format_file : putra_database.dsc =====================================================================
############# Loading Table : collar from file colar.csv ############# Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: NULL values not allowed for field y Warning: NULL values not allowed for field x Warning: NULL values not allowed for field z Warning: NULL values not allowed for field max_depth hole_id;x;y;z;max_depth;hole_path Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00366;327500,164;9825099,838;268,059;17,7;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00367;327500,075;9825149,902;273,559;15;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00368;327549,973;9825100,029;258,363;22;linear Page 1 of 11
Database Management - Database Load Report
Jul 19, 2015
Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00369;327552,435;9825142,473;253,783;21,5;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00370;327599,955;9825150,019;237,205;27,5;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00371;327650,002;9825150,009;236,129;22,86;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00372;327699,964;9825149,976;234,336;19,4;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00374;327750,076;9825099,939;244,573;22;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Page 2 of 11
Database Management - Database Load Report
Jul 19, 2015
Warning: "y" is not numeric
Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00375;327849,997;9825149,999;250,645;15;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00376;327800,046;9825149,982;252,143;13,5;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00377;327750,064;9825149,898;247,961;13,7;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00378;327849,834;9824800,227;191,334;14;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00379;327800,069;9824799,978;188,909;16;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Page 3 of 11
Database Management - Database Load Report
Jul 19, 2015
Warning: "z" is not numeric
Warning: NULL values not allowed for field max_depth CL00380;327750,015;9824799,988;192,649;9;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00381;327850,065;9824700,025;169,292;13;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00382;327800,016;9824699,961;171,649;14;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00383;327699,948;9824750,076;170,728;5;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00384;327650,029;9824700,006;172,056;10,5;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth Page 4 of 11
Database Management - Database Load Report
Jul 19, 2015
CL00385;327500,246;9824750,029;167,247;17;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00386;327449,768;9824750,085;161,234;17;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00387;327299,969;9824699,979;151,91;9,88;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00388;327249,999;9824700,007;142,471;14;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00389;327349,997;9824699,991;153,378;11;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00390;327399,829;9824750,01;159,323;5;linear
Page 5 of 11
Database Management - Database Load Report
Jul 19, 2015
Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00391;327150,009;9824800,003;143,433;23,5;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00392;327200,066;9824800,134;143,05;21;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00393;327149,997;9824700,02;123,756;15,5;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00394;327200,003;9824749,996;136,956;4;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00421;327600,036;9825049,975;258,48;13;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Page 6 of 11
Database Management - Database Load Report
Jul 19, 2015
Warning: "x" is not numeric
Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00422;327449,999;9825100,074;249,244;35;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00423;327399,969;9825100,011;257,658;13;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00424;327350,214;9825100,112;224,991;32,4;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00425;327749,985;9824999,928;231,958;20;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00426;327800,018;9824999,95;227,608;23;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: NULL values not allowed for field z Page 7 of 11
Database Management - Database Load Report
Jul 19, 2015
Warning: NULL values not allowed for field max_depth
CL00427;327849,992;9825000;235,233;13;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00428;327850,042;9825049,967;225,485;28;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00429;327849,999;9824950,002;216,302;25;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00430;327800,013;9824949,993;222,058;13;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00431;327749,855;9824949,957;217,903;15;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00432;327700,001;9824950,038;215,398;13,8;linear Page 8 of 11
Database Management - Database Load Report
Jul 19, 2015
Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00433;327650,023;9824800,145;193,471;14;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00434;327650,015;9824750,027;180,538;18;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00435;327599,986;9824750,048;173,122;24,5;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00436;327550,247;9824750,007;168,329;20;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00437;327499,996;9824800,023;178,986;18;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Page 9 of 11
Database Management - Database Load Report
Jul 19, 2015
Warning: "y" is not numeric
Warning: "x" is not numeric Warning: "z" is not numeric Warning: "max_depth" is not numeric CL00438;327449,991;9824800,06;174,176;10,7;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00439;327400,045;9824799,914;166,917;15;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00440;327349,996;9824799,945;165,901;17;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00441;327299,982;9824799,967;156,02;23;linear Warning: Length of value to load into field ''hole_id'' is too great for the defined field length Warning: "y" is not numeric Warning: "x" is not numeric Warning: "z" is not numeric Warning: NULL values not allowed for field max_depth CL00442;327399,978;9824700,085;132,626;13;linear Error: Too many load errors ... Discontinuing load 0 records were inserted. Page 10 of 11
