Message-ID: <3a4649c11c4e52a094d43c738c88da6b@localhost>
Date: Wed, 19 Oct 2016 18:36:11 +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_1476873371_ed5e54c66b76dae5cad969143f2d4b4a_=_"
--_=_swift_v4_1476873371_ed5e54c66b76dae5cad969143f2d4b4a_=_
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
[2016-10-19 18:35:36]=09INFO=09db4- dsn:mysql:host=3Dlocalhost;dbname=3Dgra=
ndtag_i;charset:utf8;[2016-10-19 18:35:36]=09INFO=09MIGA_i- dsn:mysql:host=
=3D172.16.10.9;dbname=3Dgrandtag_i;charset:utf8;[2016-10-19 18:35:36]=09INF=
O=09 sale_figure_ap (db4) Versus sale_figure_ap (MIGA_i)[2016-10-19 18:35=
:36]=09WARNING=09PK(ref 16) FK() "written_ytd_premium": 151314.08 | 151188.=
80[2016-10-19 18:35:36]=09WARNING=09PK(ref 16) FK() "submit_ytd_premium": 1=
63314.08 | 163188.80[2016-10-19 18:35:36]=09WARNING=09PK(ref 232) FK() "wri=
tten_ytd_premium": 72130.00 | 72190.00[2016-10-19 18:35:36]=09WARNING=09PK(=
ref 232) FK() "submit_ytd_premium": 72130.00 | 72190.00[2016-10-19 18:35:36=
]=09WARNING=09PK(ref 284) FK() "written_premium": 705222.66 | 705222.65[201=
6-10-19 18:35:36]=09WARNING=09PK(ref 284) FK() "written_ytd_premium": 70758=
9.16 | 707589.15[2016-10-19 18:35:36]=09WARNING=09PK(ref 284) FK() "submit_=
ytd_premium": 250193.02 | 250193.01[2016-10-19 18:35:36]=09WARNING=09PK(ref=
308) FK() "written_ytd_premium": 302716.41 | 302716.40[2016-10-19 18:35:36=
]=09WARNING=09PK(ref 356) FK() "written_ytd_premium": 46359.39 | 46359.40[2=
016-10-19 18:35:36]=09WARNING=09PK(ref 390) FK() "written_premium": 10551.8=
4 | 10551.85[2016-10-19 18:35:36]=09WARNING=09PK(ref 403) FK() "written_pre=
mium": 80803.04 | 80803.05[2016-10-19 18:35:36]=09WARNING=09PK(ref 403) FK(=
) "pending_premium": 351603.77 | 351603.76[2016-10-19 18:35:36]=09WARNING=
=09PK(ref 413) FK() "written_ytd_premium": 114076.96 | 114076.97[2016-10-19=
18:35:36]=09WARNING=09PK(ref 413) FK() "submit_ytd_premium": 59494.86 | 59=
494.87[2016-10-19 18:35:36]=09WARNING=09PK(ref 413) FK() "last2_mtd": 59494=
.86 | 59494.87[2016-10-19 18:35:36]=09WARNING=09PK(ref 494) FK() "written_p=
remium": 70758.18 | 70091.14[2016-10-19 18:35:36]=09WARNING=09PK(ref 494) F=
K() "written_ytd_premium": 70758.18 | 70091.14[2016-10-19 18:35:36]=09WARNI=
NG=09PK(ref 494) FK() "submit_premium": 70758.18 | 70091.14[2016-10-19 18:3=
5:36]=09WARNING=09PK(ref 494) FK() "submit_ytd_premium": 70758.18 | 70091.1=
4[2016-10-19 18:35:36]=09WARNING=09PK(ref 901) FK() "written_ytd_premium": =
17637.12 | 17637.11[2016-10-19 18:35:36]=09WARNING=09PK(ref 901) FK() "subm=
it_ytd_premium": 17637.12 | 17637.11[2016-10-19 18:35:37]=09WARNING=09PK(re=
f 1238) FK() "written_ytd_premium": 1320730.43 | 1316812.62[2016-10-19 18:3=
5:37]=09WARNING=09PK(ref 1238) FK() "submit_ytd_premium": 2348643.80 | 2344=
351.80[2016-10-19 18:35:37]=09INFO=09Total Data Mismatch Count: 23
--_=_swift_v4_1476873371_ed5e54c66b76dae5cad969143f2d4b4a_=_
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
=
=20
[2016-10-19 18:35:36]=09INFO=09db4- dsn:mysql:host=3Dlocalhost;dbna=
me=3Dgrandtag_i;charset:utf8;
[2016-10-19 18:35:36]=09INFO=09MIGA_i- dsn=
:mysql:host=3D172.16.10.9;dbname=3Dgrandtag_i;charset:utf8;
[2016-10-19 =
18:35:36]=09INFO=09 sale_figure_ap (db4) Versus sale_figure_ap (MIGA_i)
[2016-10-19 18:35:36]=09WARNING=09PK(ref 16) FK() "written_ytd_premiu=
m": 151314.08 | 151188.80
[2016-10-19 18:35:36]=09WARNING=09PK(ref 16) F=
K() "submit_ytd_premium": 163314.08 | 163188.80
[2016-10-19 18:35:36=
]=09WARNING=09PK(ref 232) FK() "written_ytd_premium": 72130.00 | 72190.00[2016-10-19 18:35:36]=09WARNING=09PK(ref 232) FK() "submit_ytd_premium": =
72130.00 | 72190.00
[2016-10-19 18:35:36]=09WARNING=09PK(ref 284) FK=
() "written_premium": 705222.66 | 705222.65
[2016-10-19 18:35:36]=09WARN=
ING=09PK(ref 284) FK() "written_ytd_premium": 707589.16 | 707589.15
[201=
6-10-19 18:35:36]=09WARNING=09PK(ref 284) FK() "submit_ytd_premium": 250193=
.02 | 250193.01
[2016-10-19 18:35:36]=09WARNING=09PK(ref 308) FK() "=
written_ytd_premium": 302716.41 | 302716.40
[2016-10-19 18:35:36]=09=
WARNING=09PK(ref 356) FK() "written_ytd_premium": 46359.39 | 46359.40
[2016-10-19 18:35:36]=09WARNING=09PK(ref 390) FK() "written_premium": 105=
51.84 | 10551.85
[2016-10-19 18:35:36]=09WARNING=09PK(ref 403) FK() =
"written_premium": 80803.04 | 80803.05
[2016-10-19 18:35:36]=09WARNING=
=09PK(ref 403) FK() "pending_premium": 351603.77 | 351603.76
[2016-1=
0-19 18:35:36]=09WARNING=09PK(ref 413) FK() "written_ytd_premium": 114076.9=
6 | 114076.97
[2016-10-19 18:35:36]=09WARNING=09PK(ref 413) FK() "submit=
_ytd_premium": 59494.86 | 59494.87
[2016-10-19 18:35:36]=09WARNING=09PK(=
ref 413) FK() "last2_mtd": 59494.86 | 59494.87
[2016-10-19 18:35:36]=
=09WARNING=09PK(ref 494) FK() "written_premium": 70758.18 | 70091.14
[20=
16-10-19 18:35:36]=09WARNING=09PK(ref 494) FK() "written_ytd_premium": 7075=
8.18 | 70091.14
[2016-10-19 18:35:36]=09WARNING=09PK(ref 494) FK() "subm=
it_premium": 70758.18 | 70091.14
[2016-10-19 18:35:36]=09WARNING=09PK(re=
f 494) FK() "submit_ytd_premium": 70758.18 | 70091.14
[2016-10-19 18=
:35:36]=09WARNING=09PK(ref 901) FK() "written_ytd_premium": 17637.12 | 1763=
7.11
[2016-10-19 18:35:36]=09WARNING=09PK(ref 901) FK() "submit_ytd_prem=
ium": 17637.12 | 17637.11
[2016-10-19 18:35:37]=09WARNING=09PK(ref 1=
238) FK() "written_ytd_premium": 1320730.43 | 1316812.62
[2016-10-19 18:=
35:37]=09WARNING=09PK(ref 1238) FK() "submit_ytd_premium": 2348643.80 | 234=
4351.80
[2016-10-19 18:35:37]=09INFO=09Total Data Mismatch Count: 23
--_=_swift_v4_1476873371_ed5e54c66b76dae5cad969143f2d4b4a_=_--