Subject: Database Compare Log
From: [email-masked]
To: [email-masked]
Date: Wed, 19 Oct 2016 16:42:54 +0800

[2016-10-19 16:39:43]	INFO	db4- dsn:mysql:host=localhost;dbname=grandtag_i;charset:utf8;[2016-10-19 16:39:43]	INFO	MIGA_i- dsn:mysql:host=172.16.10.9;dbname=grandtag_i;charset:utf8;[2016-10-19 16:39:43]	INFO	 sale_figure_ap (db4)  Versus  sale_figure_ap (MIGA_i)[2016-10-19 16:39:43]	WARNING	PK(ref 7) FK() "last_mtd": 0.00 | 11400.00[2016-10-19 16:39:43]	WARNING	PK(ref 7) FK() "last2_mtd": 0.00 | 6000.00[2016-10-19 16:39:43]	WARNING	PK(ref 7) FK() "last3_mtd": 0.00 | 8400.00[2016-10-19 16:39:43]	WARNING	PK(ref 7) FK() "last4_mtd": 0.00 | 27000.00[2016-10-19 16:39:43]	WARNING	PK(ref 9) FK() "last_mtd": 0.00 | 142472.80[2016-10-19 16:39:43]	WARNING	PK(ref 9) FK() "last2_mtd": 0.00 | 224715.40[2016-10-19 16:39:43]	WARNING	PK(ref 9) FK() "last3_mtd": 0.00 | 22989.12[2016-10-19 16:39:43]	WARNING	PK(ref 9) FK() "last4_mtd": 0.00 | 80226.55[2016-10-19 16:39:43]	WARNING	PK(ref 15) FK() "last_mtd": 0.00 | 31821.48[2016-10-19 16:39:43]	WARNING	PK(ref 15) FK() "last3_mtd": 0.00 | 6273.83[2016-10-19 16:39:43]	WARNING	PK(ref 15) FK() "last4_mtd": 0.00 | 4040.94[2016-10-19 16:39:43]	WARNING	PK(ref 16) FK() "written_ytd_premium": 151314.08 | 151188.80[2016-10-19 16:39:43]	WARNING	PK(ref 16) FK() "submit_ytd_premium": 163314.08 | 163188.80[2016-10-19 16:39:43]	WARNING	PK(ref 16) FK() "last_mtd": 0.00 | 7500.00[2016-10-19 16:39:43]	WARNING	PK(ref 16) FK() "last2_mtd": 0.00 | 13200.00[2016-10-19 16:39:43]	WARNING	PK(ref 16) FK() "last3_mtd": 0.00 | 16322.53[2016-10-19 16:39:43]	WARNING	PK(ref 16) FK() "last4_mtd": 0.00 | 18232.00[2016-10-19 16:39:43]	WARNING	PK(ref 64) FK() "last_mtd": 0.00 | 33755.13[2016-10-19 16:39:43]	WARNING	PK(ref 64) FK() "last2_mtd": 0.00 | 18067.53[2016-10-19 16:39:43]	WARNING	PK(ref 64) FK() "last3_mtd": 0.00 | 10036.25[2016-10-19 16:39:43]	WARNING	PK(ref 79) FK() "last_mtd": 0.00 | 135000.00[2016-10-19 16:39:43]	WARNING	PK(ref 97) FK() "last4_mtd": 0.00 | 2967.55[2016-10-19 16:39:43]	WARNING	PK(ref 147) FK() "last2_mtd": 0.00 | 25034.42[2016-10-19 16:39:43]	WARNING	PK(ref 147) FK() "last4_mtd": 0.00 | 10000.00[2016-10-19 16:39:43]	WARNING	PK(ref 229) FK() "last2_mtd": 0.00 | 10200.00[2016-10-19 16:39:43]	WARNING	PK(ref 232) FK() "written_ytd_premium": 72130.00 | 72190.00[2016-10-19 16:39:43]	WARNING	PK(ref 232) FK() "submit_ytd_premium": 72130.00 | 72190.00[2016-10-19 16:39:43]	WARNING	PK(ref 234) FK() "last4_mtd": 0.00 | 33422.50[2016-10-19 16:39:43]	WARNING	PK(ref 246) FK() "last_mtd": 0.00 | 5034.40[2016-10-19 16:39:43]	WARNING	PK(ref 246) FK() "last4_mtd": 0.00 | 15000.94[2016-10-19 16:39:43]	WARNING	PK(ref 264) FK() "last2_mtd": 0.00 | 39487.04[2016-10-19 16:39:43]	WARNING	PK(ref 265) FK() "last4_mtd": 0.00 | 36059.28[2016-10-19 16:39:43]	WARNING	PK(ref 275) FK() "last_mtd": 0.00 | 22213.11[2016-10-19 16:39:43]	WARNING	PK(ref 284) FK() "written_premium": 705222.66 | 705222.65[2016-10-19 16:39:43]	WARNING	PK(ref 284) FK() "written_ytd_premium": 707589.16 | 707589.15[2016-10-19 16:39:43]	WARNING	PK(ref 284) FK() "submit_ytd_premium": 250193.02 | 250193.01[2016-10-19 16:39:43]	WARNING	PK(ref 284) FK() "last_mtd": 0.00 | 2366.50[2016-10-19 16:39:43]	WARNING	PK(ref 308) FK() "written_ytd_premium": 302716.41 | 302716.40[2016-10-19 16:39:43]	WARNING	PK(ref 308) FK() "last2_mtd": 0.00 | 45880.00[2016-10-19 16:39:43]	WARNING	PK(ref 308) FK() "last4_mtd": 0.00 | 18080.00[2016-10-19 16:39:43]	WARNING	PK(ref 320) FK() "last3_mtd": 0.00 | 10127.00[2016-10-19 16:39:43]	WARNING	PK(ref 322) FK() "last4_mtd": 0.00 | 25713.70[2016-10-19 16:39:43]	WARNING	PK(ref 325) FK() "last3_mtd": 0.00 | 94524.00[2016-10-19 16:39:43]	WARNING	PK(ref 327) FK() "last_mtd": 0.00 | 3306.40[2016-10-19 16:39:43]	WARNING	PK(ref 327) FK() "last3_mtd": 0.00 | 4654.86[2016-10-19 16:39:43]	WARNING	PK(ref 356) FK() "written_ytd_premium": 46359.39 | 46359.40[2016-10-19 16:39:43]	WARNING	PK(ref 356) FK() "last4_mtd": 0.00 | 1919.68[2016-10-19 16:39:43]	WARNING	PK(ref 357) FK() "last_mtd": 0.00 | 84944.99[2016-10-19 16:39:43]	WARNING	PK(ref 357) FK() "last2_mtd": 0.00 | 19999.95[2016-10-19 16:39:43]	WARNING	PK(ref 357) FK() "last3_mtd": 0.00 | 84484.98[2016-10-19 16:39:43]	WARNING	PK(ref 357) FK() "last4_mtd": 0.00 | 50000.47[2016-10-19 16:39:43]	WARNING	PK(ref 359) FK() "last_mtd": 0.00 | 26265.15[2016-10-19 16:39:43]	WARNING	PK(ref 359) FK() "last2_mtd": 0.00 | 16198.14[2016-10-19 16:39:43]	WARNING	PK(ref 359) FK() "last4_mtd": 0.00 | 3141.50[2016-10-19 16:39:43]	WARNING	PK(ref 360) FK() "last4_mtd": 0.00 | 112782.47[2016-10-19 16:39:43]	WARNING	PK(ref 367) FK() "last2_mtd": 0.00 | 4123.50[2016-10-19 16:39:43]	WARNING	PK(ref 373) FK() "last2_mtd": 0.00 | 3896.24[2016-10-19 16:39:43]	WARNING	PK(ref 379) FK() "last2_mtd": 0.00 | 1937.47[2016-10-19 16:39:43]	WARNING	PK(ref 381) FK() "last3_mtd": 0.00 | 18000.00[2016-10-19 16:39:43]	WARNING	PK(ref 381) FK() "last4_mtd": 0.00 | 18207.72[2016-10-19 16:39:43]	WARNING	PK(ref 387) FK() "last2_mtd": 0.00 | 10000.00[2016-10-19 16:39:43]	WARNING	PK(ref 387) FK() "last3_mtd": 0.00 | 10000.00[2016-10-19 16:39:43]	WARNING	PK(ref 388) FK() "last4_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 389) FK() "last_mtd": 0.00 | 27987.00[2016-10-19 16:39:43]	WARNING	PK(ref 390) FK() "written_premium": 10551.84 | 10551.85[2016-10-19 16:39:43]	WARNING	PK(ref 390) FK() "last_mtd": 0.00 | 20007.75[2016-10-19 16:39:43]	WARNING	PK(ref 390) FK() "last2_mtd": 0.00 | 67550.22[2016-10-19 16:39:43]	WARNING	PK(ref 390) FK() "last3_mtd": 0.00 | 40419.33[2016-10-19 16:39:43]	WARNING	PK(ref 390) FK() "last4_mtd": 0.00 | 4082.15[2016-10-19 16:39:43]	WARNING	PK(ref 391) FK() "last2_mtd": 0.00 | 14964.78[2016-10-19 16:39:43]	WARNING	PK(ref 391) FK() "last4_mtd": 0.00 | 16403.03[2016-10-19 16:39:43]	WARNING	PK(ref 392) FK() "last4_mtd": 0.00 | 50000.04[2016-10-19 16:39:43]	WARNING	PK(ref 393) FK() "last3_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 394) FK() "last4_mtd": 0.00 | 5135.15[2016-10-19 16:39:43]	WARNING	PK(ref 398) FK() "last3_mtd": 0.00 | 5250.05[2016-10-19 16:39:43]	WARNING	PK(ref 401) FK() "last2_mtd": 0.00 | 19275.00[2016-10-19 16:39:43]	WARNING	PK(ref 403) FK() "written_premium": 80803.04 | 80803.05[2016-10-19 16:39:43]	WARNING	PK(ref 403) FK() "pending_premium": 351603.77 | 351603.76[2016-10-19 16:39:43]	WARNING	PK(ref 403) FK() "last_mtd": 0.00 | 188065.78[2016-10-19 16:39:43]	WARNING	PK(ref 403) FK() "last2_mtd": 0.00 | 101265.92[2016-10-19 16:39:43]	WARNING	PK(ref 408) FK() "last_mtd": 0.00 | 769.98[2016-10-19 16:39:43]	WARNING	PK(ref 409) FK() "last_mtd": 0.00 | 684085.37[2016-10-19 16:39:43]	WARNING	PK(ref 413) FK() "written_ytd_premium": 114076.96 | 114076.97[2016-10-19 16:39:43]	WARNING	PK(ref 413) FK() "submit_ytd_premium": 59494.86 | 59494.87[2016-10-19 16:39:43]	WARNING	PK(ref 413) FK() "last_mtd": 0.00 | 24582.02[2016-10-19 16:39:43]	WARNING	PK(ref 413) FK() "last2_mtd": 0.00 | 59494.87[2016-10-19 16:39:43]	WARNING	PK(ref 420) FK() "last_mtd": 0.00 | 39126.97[2016-10-19 16:39:43]	WARNING	PK(ref 420) FK() "last2_mtd": 0.00 | 23113.50[2016-10-19 16:39:43]	WARNING	PK(ref 420) FK() "last3_mtd": 0.00 | 21328.42[2016-10-19 16:39:43]	WARNING	PK(ref 420) FK() "last4_mtd": 0.00 | 26740.98[2016-10-19 16:39:43]	WARNING	PK(ref 428) FK() "last3_mtd": 0.00 | 7162.50[2016-10-19 16:39:43]	WARNING	PK(ref 428) FK() "last4_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 442) FK() "last_mtd": 0.00 | 123000.00[2016-10-19 16:39:43]	WARNING	PK(ref 442) FK() "last2_mtd": 0.00 | 40800.08[2016-10-19 16:39:43]	WARNING	PK(ref 442) FK() "last3_mtd": 0.00 | 68703.00[2016-10-19 16:39:43]	WARNING	PK(ref 442) FK() "last4_mtd": 0.00 | 43200.00[2016-10-19 16:39:43]	WARNING	PK(ref 494) FK() "written_premium": 70758.18 | 70091.14[2016-10-19 16:39:43]	WARNING	PK(ref 494) FK() "written_ytd_premium": 70758.18 | 70091.14[2016-10-19 16:39:43]	WARNING	PK(ref 494) FK() "submit_premium": 70758.18 | 70091.14[2016-10-19 16:39:43]	WARNING	PK(ref 494) FK() "submit_ytd_premium": 70758.18 | 70091.14[2016-10-19 16:39:43]	WARNING	PK(ref 564) FK() "last2_mtd": 0.00 | 13999.98[2016-10-19 16:39:43]	WARNING	PK(ref 901) FK() "written_ytd_premium": 17637.12 | 17637.11[2016-10-19 16:39:43]	WARNING	PK(ref 901) FK() "submit_ytd_premium": 17637.12 | 17637.11[2016-10-19 16:39:43]	WARNING	PK(ref 901) FK() "last_mtd": 0.00 | 15477.11[2016-10-19 16:39:43]	WARNING	PK(ref 901) FK() "last2_mtd": 0.00 | 2160.00[2016-10-19 16:39:43]	WARNING	PK(ref 923) FK() "last2_mtd": 0.00 | 97776.34[2016-10-19 16:39:43]	WARNING	PK(ref 938) FK() "last4_mtd": 0.00 | 12000.00[2016-10-19 16:39:43]	WARNING	PK(ref 972) FK() "last3_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 976) FK() "last2_mtd": 0.00 | 75460.44[2016-10-19 16:39:43]	WARNING	PK(ref 976) FK() "last4_mtd": 0.00 | 4294.56[2016-10-19 16:39:43]	WARNING	PK(ref 978) FK() "last2_mtd": 0.00 | 6000.00[2016-10-19 16:39:43]	WARNING	PK(ref 984) FK() "last2_mtd": 0.00 | 4999.96[2016-10-19 16:39:43]	WARNING	PK(ref 984) FK() "last3_mtd": 0.00 | 43636.83[2016-10-19 16:39:43]	WARNING	PK(ref 1040) FK() "last_mtd": 0.00 | 4999.96[2016-10-19 16:39:43]	WARNING	PK(ref 1040) FK() "last2_mtd": 0.00 | 42000.08[2016-10-19 16:39:43]	WARNING	PK(ref 1053) FK() "last_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 1054) FK() "last3_mtd": 0.00 | 14000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1088) FK() "last2_mtd": 0.00 | 3000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1088) FK() "last3_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 1097) FK() "last2_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 1143) FK() "last_mtd": 0.00 | 12000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1150) FK() "last4_mtd": 0.00 | 6000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1163) FK() "last4_mtd": 0.00 | 3000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1164) FK() "last3_mtd": 0.00 | 24000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1178) FK() "last3_mtd": 0.00 | 2305291.88[2016-10-19 16:39:43]	WARNING	PK(ref 1185) FK() "last4_mtd": 0.00 | 15753.11[2016-10-19 16:39:43]	WARNING	PK(ref 1193) FK() "last_mtd": 0.00 | 18000.04[2016-10-19 16:39:43]	WARNING	PK(ref 1197) FK() "last2_mtd": 0.00 | 80480.00[2016-10-19 16:39:43]	WARNING	PK(ref 1202) FK() "last4_mtd": 0.00 | 14500.50[2016-10-19 16:39:43]	WARNING	PK(ref 1212) FK() "last_mtd": 0.00 | 9943.98[2016-10-19 16:39:43]	WARNING	PK(ref 1212) FK() "last2_mtd": 0.00 | 1799.98[2016-10-19 16:39:43]	WARNING	PK(ref 1232) FK() "last4_mtd": 0.00 | 28353.77[2016-10-19 16:39:43]	WARNING	PK(ref 1233) FK() "last4_mtd": 0.00 | 265000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1238) FK() "written_ytd_premium": 1320730.43 | 1316812.62[2016-10-19 16:39:43]	WARNING	PK(ref 1238) FK() "submit_ytd_premium": 2348643.80 | 2344351.80[2016-10-19 16:39:43]	WARNING	PK(ref 1242) FK() "last4_mtd": 0.00 | 1919.00[2016-10-19 16:39:43]	WARNING	PK(ref 1244) FK() "last_mtd": 0.00 | 3997.50[2016-10-19 16:39:43]	WARNING	PK(ref 1250) FK() "last_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 1250) FK() "last3_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 1263) FK() "last3_mtd": 0.00 | 5034.40[2016-10-19 16:39:43]	WARNING	PK(ref 1264) FK() "last_mtd": 0.00 | 127093.65[2016-10-19 16:39:43]	WARNING	PK(ref 1264) FK() "last2_mtd": 0.00 | 71655.50[2016-10-19 16:39:43]	WARNING	PK(ref 1264) FK() "last3_mtd": 0.00 | 198323.10[2016-10-19 16:39:43]	WARNING	PK(ref 1264) FK() "last4_mtd": 0.00 | 5000.10[2016-10-19 16:39:43]	WARNING	PK(ref 1265) FK() "last4_mtd": 0.00 | 577435.24[2016-10-19 16:39:43]	WARNING	PK(ref 1276) FK() "last2_mtd": 0.00 | 3599.96[2016-10-19 16:39:43]	WARNING	PK(ref 1276) FK() "last3_mtd": 0.00 | 10919.98[2016-10-19 16:39:43]	WARNING	PK(ref 1278) FK() "last4_mtd": 0.00 | 1800.05[2016-10-19 16:39:43]	WARNING	PK(ref 1290) FK() "last2_mtd": 0.00 | 5000.10[2016-10-19 16:39:43]	WARNING	PK(ref 1290) FK() "last3_mtd": 0.00 | 8389.12[2016-10-19 16:39:43]	WARNING	PK(ref 1300) FK() "last2_mtd": 0.00 | 12126.00[2016-10-19 16:39:43]	WARNING	PK(ref 1300) FK() "last3_mtd": 0.00 | 2434.00[2016-10-19 16:39:43]	WARNING	PK(ref 1303) FK() "last2_mtd": 0.00 | 19999.95[2016-10-19 16:39:43]	WARNING	PK(ref 1308) FK() "last4_mtd": 0.00 | 124298.55[2016-10-19 16:39:43]	WARNING	PK(ref 1309) FK() "last4_mtd": 0.00 | 1298.30[2016-10-19 16:39:43]	WARNING	PK(ref 1310) FK() "last2_mtd": 0.00 | 6000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1310) FK() "last4_mtd": 0.00 | 7200.00[2016-10-19 16:39:43]	WARNING	PK(ref 1311) FK() "last4_mtd": 0.00 | 3600.00[2016-10-19 16:39:43]	WARNING	PK(ref 1312) FK() "last2_mtd": 0.00 | 7504.34[2016-10-19 16:39:43]	WARNING	PK(ref 1313) FK() "last_mtd": 0.00 | 5001.92[2016-10-19 16:39:43]	WARNING	PK(ref 1313) FK() "last2_mtd": 0.00 | 5001.92[2016-10-19 16:39:43]	WARNING	PK(ref 1313) FK() "last3_mtd": 0.00 | 10001.93[2016-10-19 16:39:43]	WARNING	PK(ref 1315) FK() "last3_mtd": 0.00 | 38439.90[2016-10-19 16:39:43]	WARNING	PK(ref 1315) FK() "last4_mtd": 0.00 | 30642.02[2016-10-19 16:39:43]	WARNING	PK(ref 1317) FK() "last3_mtd": 0.00 | 366982.14[2016-10-19 16:39:43]	WARNING	PK(ref 1324) FK() "last4_mtd": 0.00 | 6000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1325) FK() "last4_mtd": 0.00 | 7200.00[2016-10-19 16:39:43]	WARNING	PK(ref 1334) FK() "last3_mtd": 0.00 | 6000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1335) FK() "last3_mtd": 0.00 | 10000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1336) FK() "last2_mtd": 0.00 | 10200.00[2016-10-19 16:39:43]	WARNING	PK(ref 1336) FK() "last4_mtd": 0.00 | 5000.02[2016-10-19 16:39:43]	WARNING	PK(ref 1337) FK() "last4_mtd": 0.00 | 15000.02[2016-10-19 16:39:43]	WARNING	PK(ref 1338) FK() "last4_mtd": 0.00 | 16200.00[2016-10-19 16:39:43]	WARNING	PK(ref 1339) FK() "last_mtd": 0.00 | 1369.50[2016-10-19 16:39:43]	WARNING	PK(ref 1339) FK() "last2_mtd": 0.00 | 132359.98[2016-10-19 16:39:43]	WARNING	PK(ref 1341) FK() "last2_mtd": 0.00 | 50002.00[2016-10-19 16:39:43]	WARNING	PK(ref 1343) FK() "last3_mtd": 0.00 | 5760.00[2016-10-19 16:39:43]	WARNING	PK(ref 1344) FK() "last3_mtd": 0.00 | 16598.15[2016-10-19 16:39:43]	WARNING	PK(ref 1346) FK() "last_mtd": 0.00 | 6000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1346) FK() "last2_mtd": 0.00 | 6000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1348) FK() "last3_mtd": 0.00 | 3000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1349) FK() "last_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 1349) FK() "last4_mtd": 0.00 | 2400.00[2016-10-19 16:39:43]	WARNING	PK(ref 1356) FK() "last3_mtd": 0.00 | 5760.00[2016-10-19 16:39:43]	WARNING	PK(ref 1358) FK() "last3_mtd": 0.00 | 5760.00[2016-10-19 16:39:43]	WARNING	PK(ref 1360) FK() "last2_mtd": 0.00 | 4317.50[2016-10-19 16:39:43]	WARNING	PK(ref 1362) FK() "last_mtd": 0.00 | 6000.00[2016-10-19 16:39:43]	WARNING	PK(ref 1363) FK() "last_mtd": 0.00 | 3599.96[2016-10-19 16:39:43]	WARNING	PK(ref 1364) FK() "last_mtd": 0.00 | 6097.87[2016-10-19 16:39:43]	WARNING	PK(ref 1365) FK() "last_mtd": 0.00 | 7447.50[2016-10-19 16:39:43]	WARNING	PK(ref 1366) FK() "last_mtd": 0.00 | 3840.00[2016-10-19 16:39:43]	WARNING	PK(ref 1367) FK() "last_mtd": 0.00 | 3840.00[2016-10-19 16:39:43]	WARNING	PK(ref 1368) FK() "last_mtd": 0.00 | 3840.00[2016-10-19 16:39:43]	INFO	Total Data Mismatch Count: 193