Subject: Database Compare Log
From: [email-masked]
To: [email-masked]
Date: Wed, 26 Oct 2016 12:33:58 +0800

[2016-10-26 12:33:47] INFO db4- dsn:mysql:host=localhost;dbname=grandtag_i;charset:utf8;
[2016-10-26 12:33:47] INFO db3- dsn:mysql:host=172.16.10.3;dbname=louislee_dev;charset:utf8;
[2016-10-26 12:33:47] INFO bo_sales_report_display (db4) Versus bo_sales_report_display (db3)

[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1) FK() "sc_mtd_pu": 8000.35 | 8000.36
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1) FK() "sc_ytd_pu": 8000.35 | 8000.36
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 21) FK() "wc_ytd_pu": 302716.40 | 302716.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 21) FK() "sc_mtd_pu": 35903.90 | 35903.91
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 21) FK() "sc_ytd_pu": 35903.90 | 35903.91
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 21) FK() "sc_pipeline_pu": 255936.40 | 255936.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 54) FK() "wc_ytd_pu": 439238.89 | 439238.90
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 55) FK() "wc_ytd_pu": 106352.40 | 106352.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 55) FK() "sc_pipeline_pu": 106352.40 | 106352.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 477) FK() "wc_ytd_pu": 17637.11 | 17637.12
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 477) FK() "sc_pipeline_pu": 17637.11 | 17637.12
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 548) FK() "sc_mtd_pu": 90795.04 | 90795.05
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 548) FK() "sc_ytd_pu": 90795.04 | 90795.05
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 730) FK() "wc_ytd_pu": 50002.00 | 50002.01
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 730) FK() "pc_mtd_pu": 30000.04 | 30000.05
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 735) FK() "wc_ytd_pu": 46359.39 | 46359.40
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 735) FK() "sc_pipeline_pu": 46359.39 | 46359.40
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 738) FK() "sc_pipeline_pu": 123454.66 | 123454.67
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 769) FK() "pc_mtd_pu": 52499.99 | 52500.00
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 771) FK() "wc_mtd_pu": 10013.12 | 10013.13
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 771) FK() "wc_ytd_pu": 345087.05 | 345087.06
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 826) FK() "wc_ytd_pu": 2685645.98 | 2685645.99
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 826) FK() "pc_mtd_pu": 2305291.98 | 2305291.99
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 836) FK() "sc_pipeline_pu": 26233.53 | 26233.54
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 838) FK() "wc_ytd_pu": 133729.48 | 133729.49
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 838) FK() "sc_pipeline_pu": 133729.48 | 133729.49
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 870) FK() "wc_ytd_pu": 894381.65 | 894381.66
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 870) FK() "sc_mtd_pu": 44347.35 | 44347.36
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 870) FK() "sc_ytd_pu": 44347.35 | 44347.36
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 890) FK() "wc_ytd_pu": 669698.54 | 669698.55
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 890) FK() "sc_mtd_pu": 35903.90 | 35903.91
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 890) FK() "sc_ytd_pu": 35903.90 | 35903.91
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 890) FK() "sc_pipeline_pu": 355936.29 | 355936.30
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 899) FK() "wc_ytd_pu": 138222.80 | 138222.81
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 899) FK() "sc_pipeline_pu": 138222.80 | 138222.81
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 923) FK() "wc_ytd_pu": 439238.89 | 439238.90
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 924) FK() "wc_ytd_pu": 106352.40 | 106352.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 924) FK() "sc_pipeline_pu": 106352.40 | 106352.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1289) FK() "wc_ytd_pu": 1473793.40 | 1473793.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1289) FK() "sc_pipeline_pu": 1306154.00 | 1306154.01
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1346) FK() "wc_ytd_pu": 17637.11 | 17637.12
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1346) FK() "sc_pipeline_pu": 17637.11 | 17637.12
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1417) FK() "sc_mtd_pu": 90795.04 | 90795.05
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1417) FK() "sc_ytd_pu": 90795.04 | 90795.05
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1513) FK() "wc_ytd_pu": 137587.54 | 137587.55
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1513) FK() "pc_mtd_pu": 30000.04 | 30000.05
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1599) FK() "wc_ytd_pu": 50002.00 | 50002.01
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1599) FK() "pc_mtd_pu": 30000.04 | 30000.05
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1604) FK() "wc_ytd_pu": 623794.63 | 623794.64
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1604) FK() "sc_pipeline_pu": 446359.43 | 446359.44
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1606) FK() "wc_ytd_pu": 627918.13 | 627918.14
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1606) FK() "sc_pipeline_pu": 446359.43 | 446359.44
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1607) FK() "sc_pipeline_pu": 123454.66 | 123454.67
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1638) FK() "pc_mtd_pu": 52499.99 | 52500.00
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1640) FK() "wc_mtd_pu": 10013.12 | 10013.13
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1640) FK() "wc_ytd_pu": 425255.19 | 425255.20
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1652) FK() "pc_mtd_pu": 52499.99 | 52500.00
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1689) FK() "wc_ytd_pu": 4279238.87 | 4279238.88
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1689) FK() "pc_mtd_pu": 2691156.32 | 2691156.33
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1695) FK() "wc_ytd_pu": 2685645.98 | 2685645.99
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1695) FK() "pc_mtd_pu": 2305291.98 | 2305291.99
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1704) FK() "wc_ytd_pu": 198413.62 | 198413.63
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1704) FK() "sc_pipeline_pu": 187952.33 | 187952.35
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1705) FK() "sc_pipeline_pu": 26233.53 | 26233.54
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1707) FK() "wc_ytd_pu": 133729.48 | 133729.49
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1707) FK() "sc_pipeline_pu": 133729.48 | 133729.49
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1739) FK() "wc_ytd_pu": 1726494.92 | 1726494.95
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1739) FK() "sc_mtd_pu": 85843.13 | 85843.15
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1739) FK() "sc_ytd_pu": 85843.13 | 85843.15
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1739) FK() "sc_pipeline_pu": 956635.37 | 956635.39
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1743) FK() "wc_ytd_pu": 2778668.08 | 2778668.09
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1743) FK() "sc_pipeline_pu": 2491147.73 | 2491147.74
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1745) FK() "sc_mtd_pu": 154248.63 | 154248.64
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1745) FK() "sc_ytd_pu": 154248.63 | 154248.64
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1746) FK() "wc_ytd_pu": 982396.76 | 982396.77
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1746) FK() "pc_mtd_pu": 62000.10 | 62000.11
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1747) FK() "wc_ytd_pu": 2523740.92 | 2523740.93
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1747) FK() "sc_pipeline_pu": 624820.61 | 624820.63
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1751) FK() "wc_mtd_pu": 21695.11 | 21695.12
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1751) FK() "wc_ytd_pu": 927393.06 | 927393.07
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1751) FK() "pc_mtd_pu": 141739.86 | 141739.87
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1752) FK() "wc_ytd_pu": 4298513.87 | 4298513.88
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1752) FK() "pc_mtd_pu": 2691156.32 | 2691156.33
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1753) FK() "wc_ytd_pu": 198413.62 | 198413.63
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1753) FK() "sc_pipeline_pu": 187952.33 | 187952.35
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1757) FK() "sc_ytd_pu": 11034.01 | 11034.02
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1777) FK() "wc_ytd_pu": 302716.40 | 302716.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1777) FK() "sc_ytd_pu": 35903.90 | 35903.91
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1777) FK() "sc_pipeline_pu": 255936.40 | 255936.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1810) FK() "wc_ytd_pu": 439238.89 | 439238.90
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1811) FK() "wc_ytd_pu": 106352.40 | 106352.41
[2016-10-26 12:33:49] WARNING PK(sales_report_ref 1811) FK() "sc_pipeline_pu": 106352.40 | 106352.41
[2016-10-26 12:33:49] INFO Excluded Fields: create_timestamp
[2016-10-26 12:33:49] INFO No Of Records: 2000
[2016-10-26 12:33:49] INFO Range From:
[2016-10-26 12:33:49] INFO Range To:
[2016-10-26 12:33:49] INFO Total Compared Record Count: 2000
[2016-10-26 12:33:49] INFO Status: Complete with Record Difference
[2016-10-26 12:33:49] INFO Total Data Mismatch Count: 92