Message-ID: <4734fe99c6091a9f7b45d17e76d8355e@localhost>
Date: Thu, 27 Oct 2016 12:28:56 +0800
Subject: Database Compare Log
From: it@grandtag.com
To: ryo.yeung@grandtag.com
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="_=_swift_v4_1477542536_cc3b27767a2e2b360ed346c1453c299f_=_"
--_=_swift_v4_1477542536_cc3b27767a2e2b360ed346c1453c299f_=_
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
[2016-10-27 12:28:48]=09INFO=09db4- dsn:mysql:host=3Dlocalhost;dbname=3Dgra=
ndtag_i;charset:utf8;[2016-10-27 12:28:48]=09INFO=09MIGA_i- dsn:mysql:host=
=3D172.16.10.9;dbname=3Dgrandtag_i;charset:utf8;[2016-10-27 12:28:48]=09INF=
O=09 sale_figure_ap (db4) Versus sale_figure_ap (MIGA_i)[2016-10-27 12:28=
:48]=09WARNING=09PK(ref 7) FK() "written_case": 4 | 3[2016-10-27 12:28:48]=
=09WARNING=09PK(ref 7) FK() "written_premium": 24000.00 | 12000.00[2016-10-=
27 12:28:48]=09WARNING=09PK(ref 7) FK() "written_ytd_case": 32 | 31[2016-10=
-27 12:28:48]=09WARNING=09PK(ref 7) FK() "written_ytd_premium": 152250.00 |=
140250.00[2016-10-27 12:28:48]=09WARNING=09PK(ref 7) FK() "submit_ytd_case=
": 33 | 32[2016-10-27 12:28:48]=09WARNING=09PK(ref 7) FK() "submit_ytd_prem=
ium": 154650.00 | 142650.00[2016-10-27 12:28:48]=09WARNING=09PK(ref 284) FK=
() "submit_case": 4 | 5[2016-10-27 12:28:48]=09WARNING=09PK(ref 284) FK() "=
submit_premium": 59589.77 | 69589.82[2016-10-27 12:28:48]=09WARNING=09PK(re=
f 308) FK() "written_ytd_premium": 302716.41 | 302716.40[2016-10-27 12:28:4=
8]=09WARNING=09PK(ref 322) FK() "written_premium": 52500.00 | 52499.99[2016=
-10-27 12:28:48]=09WARNING=09PK(ref 322) FK() "pending_premium": 52500.00 |=
52499.99[2016-10-27 12:28:48]=09WARNING=09PK(ref 356) FK() "written_ytd_pr=
emium": 46359.39 | 46359.40[2016-10-27 12:28:48]=09WARNING=09PK(ref 390) FK=
() "written_premium": 15553.76 | 15553.77[2016-10-27 12:28:48]=09WARNING=09=
PK(ref 390) FK() "written_ytd_premium": 147613.21 | 147613.22[2016-10-27 12=
:28:48]=09WARNING=09PK(ref 409) FK() "written_case": 58 | 55[2016-10-27 12:=
28:48]=09WARNING=09PK(ref 409) FK() "written_premium": 558529.30 | 512529.1=
0[2016-10-27 12:28:48]=09WARNING=09PK(ref 409) FK() "written_ytd_case": 100=
| 97[2016-10-27 12:28:48]=09WARNING=09PK(ref 409) FK() "written_ytd_premiu=
m": 1242614.67 | 1196614.46[2016-10-27 12:28:48]=09WARNING=09PK(ref 409) FK=
() "pending_case": 100 | 97[2016-10-27 12:28:48]=09WARNING=09PK(ref 409) FK=
() "pending_premium": 1242614.67 | 1196614.46[2016-10-27 12:28:48]=09WARNIN=
G=09PK(ref 413) FK() "written_ytd_premium": 114076.96 | 114076.97[2016-10-2=
7 12:28:48]=09WARNING=09PK(ref 413) FK() "last2_mtd": 59494.86 | 59494.87[2=
016-10-27 12:28:48]=09WARNING=09PK(ref 902) FK() "written_ytd_premium": 248=
37.12 | 24837.11[2016-10-27 12:28:48]=09WARNING=09PK(ref 902) FK() "submit_=
ytd_premium": 24837.12 | 24837.11[2016-10-27 12:28:48]=09WARNING=09PK(ref 1=
098) FK() "written_case": 5 | 4[2016-10-27 12:28:48]=09WARNING=09PK(ref 109=
8) FK() "written_premium": 36000.00 | 30000.00[2016-10-27 12:28:48]=09WARNI=
NG=09PK(ref 1098) FK() "written_ytd_case": 8 | 7[2016-10-27 12:28:48]=09WAR=
NING=09PK(ref 1098) FK() "written_ytd_premium": 50400.00 | 44400.00[2016-10=
-27 12:28:48]=09WARNING=09PK(ref 1098) FK() "pending_case": 1 | 0[2016-10-2=
7 12:28:48]=09WARNING=09PK(ref 1098) FK() "pending_premium": 6000.00 | 0.00=
[2016-10-27 12:28:48]=09WARNING=09PK(ref 1340) FK() "submit_ytd_premium": 1=
33729.48 | 133729.49[2016-10-27 12:28:48]=09INFO=09Excluded Fields: update_=
time,update_date[2016-10-27 12:28:48]=09INFO=09No Of Records:[2016-10-27 12=
:28:48]=09INFO=09Range From:[2016-10-27 12:28:48]=09INFO=09Range To:[2016-1=
0-27 12:28:48]=09INFO=09Total Compared Record Count: 1369[2016-10-27 12:28:=
48]=09INFO=09Status: Complete with Record Difference[2016-10-27 12:28:48]=
=09INFO=09Total Data Mismatch Count: 31
--_=_swift_v4_1477542536_cc3b27767a2e2b360ed346c1453c299f_=_
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
=
=20
[2016-10-27 12:28:48]=09INFO=09db4- dsn:mysql:host=3Dlocalhost;dbna=
me=3Dgrandtag_i;charset:utf8;
[2016-10-27 12:28:48]=09INFO=09MIGA_i- dsn=
:mysql:host=3D172.16.10.9;dbname=3Dgrandtag_i;charset:utf8;
[2016-10-27 =
12:28:48]=09INFO=09 sale_figure_ap (db4) Versus sale_figure_ap (MIGA_i)
[2016-10-27 12:28:48]=09WARNING=09PK(ref 7) FK() "written_case": 4 | =
3
[2016-10-27 12:28:48]=09WARNING=09PK(ref 7) FK() "written_premium": 24=
000.00 | 12000.00
[2016-10-27 12:28:48]=09WARNING=09PK(ref 7) FK() "writ=
ten_ytd_case": 32 | 31
[2016-10-27 12:28:48]=09WARNING=09PK(ref 7) FK() =
"written_ytd_premium": 152250.00 | 140250.00
[2016-10-27 12:28:48]=09WAR=
NING=09PK(ref 7) FK() "submit_ytd_case": 33 | 32
[2016-10-27 12:28:48]=
=09WARNING=09PK(ref 7) FK() "submit_ytd_premium": 154650.00 | 142650.00
=
[2016-10-27 12:28:48]=09WARNING=09PK(ref 284) FK() "submit_case": 4 | 5=
[2016-10-27 12:28:48]=09WARNING=09PK(ref 284) FK() "submit_premium": 59=
589.77 | 69589.82
[2016-10-27 12:28:48]=09WARNING=09PK(ref 308) FK()=
"written_ytd_premium": 302716.41 | 302716.40
[2016-10-27 12:28:48]=
=09WARNING=09PK(ref 322) FK() "written_premium": 52500.00 | 52499.99
[20=
16-10-27 12:28:48]=09WARNING=09PK(ref 322) FK() "pending_premium": 52500.00=
| 52499.99
[2016-10-27 12:28:48]=09WARNING=09PK(ref 356) FK() "writ=
ten_ytd_premium": 46359.39 | 46359.40
[2016-10-27 12:28:48]=09WARNIN=
G=09PK(ref 390) FK() "written_premium": 15553.76 | 15553.77
[2016-10-27 =
12:28:48]=09WARNING=09PK(ref 390) FK() "written_ytd_premium": 147613.21 | 1=
47613.22
[2016-10-27 12:28:48]=09WARNING=09PK(ref 409) FK() "written=
_case": 58 | 55
[2016-10-27 12:28:48]=09WARNING=09PK(ref 409) FK() "writ=
ten_premium": 558529.30 | 512529.10
[2016-10-27 12:28:48]=09WARNING=09PK=
(ref 409) FK() "written_ytd_case": 100 | 97
[2016-10-27 12:28:48]=09WARN=
ING=09PK(ref 409) FK() "written_ytd_premium": 1242614.67 | 1196614.46
[2=
016-10-27 12:28:48]=09WARNING=09PK(ref 409) FK() "pending_case": 100 | 97[2016-10-27 12:28:48]=09WARNING=09PK(ref 409) FK() "pending_premium": 124=
2614.67 | 1196614.46
[2016-10-27 12:28:48]=09WARNING=09PK(ref 413) F=
K() "written_ytd_premium": 114076.96 | 114076.97
[2016-10-27 12:28:48]=
=09WARNING=09PK(ref 413) FK() "last2_mtd": 59494.86 | 59494.87
[2016=
-10-27 12:28:48]=09WARNING=09PK(ref 902) FK() "written_ytd_premium": 24837.=
12 | 24837.11
[2016-10-27 12:28:48]=09WARNING=09PK(ref 902) FK() "submit=
_ytd_premium": 24837.12 | 24837.11
[2016-10-27 12:28:48]=09WARNING=
=09PK(ref 1098) FK() "written_case": 5 | 4
[2016-10-27 12:28:48]=09WARNI=
NG=09PK(ref 1098) FK() "written_premium": 36000.00 | 30000.00
[2016-10-2=
7 12:28:48]=09WARNING=09PK(ref 1098) FK() "written_ytd_case": 8 | 7
[201=
6-10-27 12:28:48]=09WARNING=09PK(ref 1098) FK() "written_ytd_premium": 5040=
0.00 | 44400.00
[2016-10-27 12:28:48]=09WARNING=09PK(ref 1098) FK() "pen=
ding_case": 1 | 0
[2016-10-27 12:28:48]=09WARNING=09PK(ref 1098) FK() "p=
ending_premium": 6000.00 | 0.00
[2016-10-27 12:28:48]=09WARNING=09PK=
(ref 1340) FK() "submit_ytd_premium": 133729.48 | 133729.49
[2016-10-27 =
12:28:48]=09INFO=09Excluded Fields: update_time,update_date
[2016-10-27 =
12:28:48]=09INFO=09No Of Records:
[2016-10-27 12:28:48]=09INFO=09Range F=
rom:
[2016-10-27 12:28:48]=09INFO=09Range To:
[2016-10-27 12:28:48]=
=09INFO=09Total Compared Record Count: 1369
[2016-10-27 12:28:48]=09INFO=
=09Status: Complete with Record Difference
[2016-10-27 12:28:48]=09INFO=
=09Total Data Mismatch Count: 31
--_=_swift_v4_1477542536_cc3b27767a2e2b360ed346c1453c299f_=_--