Scribd
Upload
91 views11 pages

Putra Database

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.

Uploaded by

khaka putra outsider
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
91 views11 pages

Putra Database

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.

Uploaded by

khaka putra outsider
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Database Management - Database Load Report

Jul 19, 2015

Date
: 19-Jul-15
Database : putra_database
Format_file : putra_database.dsc
=====================================================================

#############
Loading Table : collar from file [Link]
#############
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

Database Management - Database Load Report

Jul 19, 2015

0 records were updated.


51 records were rejected.

Page 11 of 11

You might also like