Re: Migration from ubuntu mysql 5.7 to windows mysql 5.7
Posted by: calvin law
Date: September 15, 2020 10:53PM

Hi Peter, this is the activity logs.

PS. The CIFTBL is a very big table contains a lot of information.

Starting...
Prepare information for data copy...
Prepare information for data copy done
Determine number of rows to copy....
Counting number of rows in tables...
wbcopytables.exe --count-only --passwords-from-stdin --mysql-source="pgmuser@10.212.1.34:3306" --source-timeout= --target-timeout=None --table-file=c:\users\admini~1.ntn\appdata\local\temp\2\tmpgxtgys
--table `ntnsap` `tmpstk`
10:03:13 [INF][ copytable]: --table `ntnsap` `tmpprc`
10:03:13 [INF][ copytable]: --table `ntnsap` `mactbl`
10:03:13 [INF][ copytable]: --table `ntnsap` `tkntbl`
Blah Blah Blah...

10:03:13 [INF][ copytable]: Connecting to MySQL server at 10.212.1.34:3306 with user pgmuser
10:03:13 [INF][ copytable]: Connection to MySQL opened

9165140 total rows in 192 tables need to be copied:
- `ntnsap`.`tmpstk`: 0
- `ntnsap`.`tmpprc`: 19530
- `ntnsap`.`mactbl`: 0
- `ntnsap`.`tkntbl`: 80
- `ntnsap`.`sent_notices_bymail`: 77
- `ntnsap`.`pohsap`: 13981
- `ntnsap`.`ctqtbl`: 163173
- `ntnsap`.`ulhtbl`: 116
- `ntnsap`.`tmpeur`: 0
- `ntnsap`.`nptmas`: 248
- `ntnsap`.`shftbl`: 42
- `ntnsap`.`bintbl`: 3335
- `ntnsap`.`hwrtbl`: 1542
- `ntnsap`.`gthfil`: 1605
- `ntnsap`.`geumas`: 173
- `ntnsap`.`tmpctq`: 19528
- `ntnsap`.`ivdfil`: 433506
- `ntnsap`.`sthfil`: 102
- `ntnsap`.`dtrtbl`: 55
- `ntnsap`.`bgttbl`: 280637
- `ntnsap`.`dptmas`: 10
- `ntnsap`.`dlrtbl`: 130
- `ntnsap`.`tmptrt`: 116
- `ntnsap`.`rbttbl`: 13743
- `ntnsap`.`tihfil`: 8648
- `ntnsap`.`lidtbl`: 1593
- `ntnsap`.`demo`: 0
- `ntnsap`.`ciftbl`: 222047
- `ntnsap`.`partbl`: 12464
- `ntnsap`.`ctqmas`: 55571
- `ntnsap`.`tcdmas`: 548
- `ntnsap`.`rgntbl`: 76
- `ntnsap`.`hldtbl`: 133
- `ntnsap`.`tempods`: 0
- `ntnsap`.`hsctbl`: 154
- `ntnsap`.`eurfix`: 26
- `ntnsap`.`prtmas`: 260
- `ntnsap`.`acsmas`: 42
- `ntnsap`.`brhtbl`: 405
- `ntnsap`.`prdfil`: 77612
- `ntnsap`.`tmpacs`: 0
- `ntnsap`.`bpvtbl`: 28
- `ntnsap`.`knvv`: 1949
- `ntnsap`.`shfmas`: 6
- `ntnsap`.`syspermission`: 0
- `ntnsap`.`dpttbl`: 237
- `ntnsap`.`tmpbin`: 4303
- `ntnsap`.`sihfil`: 8507
- `ntnsap`.`thdtbl`: 769
- `ntnsap`.`vbrp`: 35658
- `ntnsap`.`sysrole`: 0
- `ntnsap`.`dodfil`: 62917
- `ntnsap`.`xrttbl`: 1893
- `ntnsap`.`demoinfo`: 0
- `ntnsap`.`roltbl`: 11729
- `ntnsap`.`scmfil`: 2207275
- `ntnsap`.`dohfil`: 4712
- `ntnsap`.`tmptest`: 1
- `ntnsap`.`logpac`: 861
- `ntnsap`.`pacdtl`: 154
- `ntnsap`.`tmphbntbl02`: 0
- `ntnsap`.`stsmas`: 16
- `ntnsap`.`vbrk`: 2974
- `ntnsap`.`hqhfil`: 78
- `ntnsap`.`tmpjpntbl`: 306
- `ntnsap`.`tmpstt`: 238
- `ntnsap`.`iqdfil`: 128632
- `ntnsap`.`brhmas`: 7
- `ntnsap`.`tmphbntbl`: 0
- `ntnsap`.`acrtbl`: 132
- `ntnsap`.`sahfil`: 195708
- `ntnsap`.`suptbl`: 61
- `ntnsap`.`pactyp`: 0
- `ntnsap`.`sysuserrole`: 0
- `ntnsap`.`saltbl`: 215
- `ntnsap`.`lvlmas`: 14
- `ntnsap`.`logtbl`: 10478
- `ntnsap`.`schfil`: 29555
- `ntnsap`.`stlmas`: 30
- `ntnsap`.`ctltbl`: 38
- `ntnsap`.`tmpprd`: 39305
- `ntnsap`.`pkctbl`: 181
- `ntnsap`.`otctbl`: 1290
- `ntnsap`.`tmpstd`: 14450
- `ntnsap`.`wlttbl`: 443
- `ntnsap`.`stftbl`: 260
- `ntnsap`.`hkabhkdexchangerates`: 458
- `ntnsap`.`frmtbl`: 50
- `ntnsap`.`salmas`: 206
- `ntnsap`.`rtgmas`: 11
- `ntnsap`.`idsmas`: 350
- `ntnsap`.`bgtmas`: 30
- `ntnsap`.`hbntbl`: 637765
- `ntnsap`.`sidfil`: 263189
- `ntnsap`.`tmptbl2`: 0
- `ntnsap`.`tmpbrg`: 4365
- `ntnsap`.`vbpa`: 14449
- `ntnsap`.`fsdfil`: 3304
- `ntnsap`.`tmptbl`: 16672
- `ntnsap`.`hwrtbltmp`: 1441
- `ntnsap`.`zmmr0040tmp`: 41468
- `ntnsap`.`sgnmas`: 54
- `ntnsap`.`prhfil`: 4
- `ntnsap`.`cifsap`: 414073
- `ntnsap`.`tmptext`: 265845
- `ntnsap`.`hqdfil`: 22847
- `ntnsap`.`tmpivd`: 3149
- `ntnsap`.`rsttbl`: 375
- `ntnsap`.`othatt`: 7
- `ntnsap`.`sysrolepermission`: 0
- `ntnsap`.`publicholiday`: 51
- `ntnsap`.`lmttbl`: 41
- `ntnsap`.`cpntbl`: 1415
- `ntnsap`.`pchtbl`: 35728
- `ntnsap`.`cpymas`: 111
- `ntnsap`.`tmpods`: 16130
- `ntnsap`.`ncftbl`: 49
- `ntnsap`.`mdggicmas`: 44
- `ntnsap`.`xhgpkctbl`: 79
- `ntnsap`.`hshtbl`: 8
- `ntnsap`.`ivhfil`: 31886
- `ntnsap`.`mtltbl`: 55518
- `ntnsap`.`knb1`: 611
- `ntnsap`.`qrctbl`: 41555
- `ntnsap`.`geutbl`: 310
- `ntnsap`.`sgntbl`: 1352
- `ntnsap`.`pidfil`: 0
- `ntnsap`.`tmpgtp`: 4473
- `ntnsap`.`fbptbl`: 75
- `ntnsap`.`orgmas`: 249
- `ntnsap`.`stdfil`: 275946
- `ntnsap`.`iqhfil`: 7089
- `ntnsap`.`ctlmas`: 7
- `ntnsap`.`custyptbl`: 5
- `ntnsap`.`cifmas`: 22
- `ntnsap`.`piktbl`: 1118
- `ntnsap`.`tmp111`: 31
- `ntnsap`.`gtpfil`: 383485
- `ntnsap`.`rgnmas`: 1544
- `ntnsap`.`curmas`: 187
- `ntnsap`.`gicmas`: 29
- `ntnsap`.`euctbl`: 908
- `ntnsap`.`xrttmp`: 932
- `ntnsap`.`fshfil`: 1267
- `ntnsap`.`podsap`: 299641
- `ntnsap`.`tempgtp`: 0
- `ntnsap`.`ctnmas`: 209
- `ntnsap`.`rolmas`: 222
- `ntnsap`.`brdmas`: 10
- `ntnsap`.`rmktbl`: 8
- `ntnsap`.`aremas`: 24
- `ntnsap`.`gtdfil`: 117207
- `ntnsap`.`kjumas`: 143
- `ntnsap`.`ccctbl`: 9
- `ntnsap`.`custbl`: 493
- `ntnsap`.`stmtbl`: 385699
- `ntnsap`.`czntbl`: 480
- `ntnsap`.`dlhtbl`: 258
- `ntnsap`.`binmas`: 496
- `ntnsap`.`lidmas`: 154
- `ntnsap`.`atbtbl`: 10
- `ntnsap`.`tidfil`: 88452
- `ntnsap`.`txtmas`: 413
- `ntnsap`.`clsmas`: 418
- `ntnsap`.`tmp20170802`: 3948
- `ntnsap`.`tmp123`: 5798
- `ntnsap`.`tmptblt`: 0
- `ntnsap`.`zmmr0160temp`: 5103
- `ntnsap`.`sapciftbl`: 47215
- `ntnsap`.`scbtbl`: 156
- `ntnsap`.`sadfil`: 458014
- `ntnsap`.`scdfil`: 384432
- `ntnsap`.`userinfo`: 0
- `ntnsap`.`oemtbl`: 21904
- `ntnsap`.`scdtmp`: 315
- `ntnsap`.`rvltbl`: 16401
- `ntnsap`.`pihfil`: 40
- `ntnsap`.`pohfil`: 183876
- `ntnsap`.`acstbl`: 121171
- `ntnsap`.`vbap`: 52581
- `ntnsap`.`podfil`: 274313
- `ntnsap`.`knvp`: 11685
- `ntnsap`.`vbak`: 5335
- `ntnsap`.`tknmas`: 2
- `ntnsap`.`txztbl`: 76
- `ntnsap`.`vbkd`: 18948
- `ntnsap`.`qrclog`: 198
- `ntnsap`.`pmttbl`: 73
- `ntnsap`.`pachdr`: 1861
- `ntnsap`.`tmpgit`: 2908
- `ntnsap`.`ctymas`: 245
- `ntnsap`.`stktbl`: 5111
Determine number of rows to copy finished
Copy data to target RDBMS....

Migrating data...
wbcopytables.exe --mysql-source="pgmuser@10.212.1.34:3306" --target="pgmuser1@localhost:3306" --progress --passwords-from-stdin --truncate-target --thread-count=2 --source-rdbms-type=Mysql --source-timeout= --target-timeout=None --table-file=c:\users\admini~1.ntn\appdata\local\temp\2\tmp5c7mnv
--table `ntnsap` `tmpstk` `ntnsap` `tmpstk` `STKSTL`,`STKBRG`,`STKORG`,`STKPKC`,`STKMTL` `STKSTL`,`STKBRG`,`STKORG`,`STKPKC`,`STKMTL` `STKSTL`, `STKBRG`, `STKORG`, `STKPKC`, `STKMTL`, `STKFRQ`, `PKCGRP`

Blah Blah Blah....

10:03:56 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user pgmuser1

10:03:56 [INF][ copytable]: Connection to MySQL opened

10:03:56 [INF][ copytable]: Connecting to MySQL server at 10.212.1.34:3306 with user pgmuser

10:03:56 [INF][ copytable]: Connection to MySQL opened

10:03:56 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user pgmuser1

10:03:56 [INF][ copytable]: Connection to MySQL opened

10:03:56 [INF][ copytable]: Connecting to MySQL server at 10.212.1.34:3306 with user pgmuser

10:03:56 [INF][ copytable]: Connection to MySQL opened

10:03:56 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user pgmuser1

10:03:56 [INF][ copytable]: Connection to MySQL opened

10:03:56 [IBEGIN:`ntnsap`.`tmpprc`:Copying 5 columns of 19530 rows from table `ntnsap`.`tmpprc`

`ntnsap`.`tmpstk`:Finished copying 0 rows in 0m01s
`ntnsap`.`mactbl`:Copying 9 columns of 0 rows from table `ntnsap`.`mactbl`
`ntnsap`.`mactbl`:Finished copying 0 rows in 0m01s
`ntnsap`.`tkntbl`:Copying 2 columns of 80 rows from table `ntnsap`.`tkntbl`
`ntnsap`.`tkntbl`:Finished copying 80 rows in 0m01s
`ntnsap`.`sent_notices_bymail`:Copying 2 columns of 77 rows from table `ntnsap`.`sent_notices_bymail`
`ntnsap`.`sent_notices_bymail`:Finished copying 77 rows in 0m00s
`ntnsap`.`pohsap`:Copying 14 columns of 13981 rows from table `ntnsap`.`pohsap`
`ntnsap`.`pohsap`:Finished copying 13981 rows in 0m13s
`ntnsap`.`ctqtbl`:Copying 9 columns of 163173 rows from table `ntnsap`.`ctqtbl`
`ntnsap`.`tmpprc`:Finished copying 19530 rows in 0m16s
`ntnsap`.`ulhtbl`:Copying 4 columns of 116 rows from table `ntnsap`.`ulhtbl`
`ntnsap`.`ulhtbl`:Finished copying 116 rows in 0m01s
`ntnsap`.`tmpeur`:Copying 30 columns of 0 rows from table `ntnsap`.`tmpeur`
`ntnsap`.`tmpeur`:Finished copying 0 rows in 0m01s
`ntnsap`.`nptmas`:Copying 4 columns of 248 rows from table `ntnsap`.`nptmas`
`ntnsap`.`nptmas`:Finished copying 248 rows in 0m01s
`ntnsap`.`shftbl`:Copying 6 columns of 42 rows from table `ntnsap`.`shftbl`
`ntnsap`.`shftbl`:Finished copying 42 rows in 0m01s
`ntnsap`.`bintbl`:Copying 10 columns of 3335 rows from table `ntnsap`.`bintbl`
`ntnsap`.`bintbl`:Finished copying 3335 rows in 0m05s
`ntnsap`.`hwrtbl`:Copying 14 columns of 1542 rows from table `ntnsap`.`hwrtbl`
`ntnsap`.`hwrtbl`:Finished copying 1542 rows in 0m05s
`ntnsap`.`gthfil`:Copying 19 columns of 1605 rows from table `ntnsap`.`gthfil`
`ntnsap`.`gthfil`:Finished copying 1605 rows in 0m03s
`ntnsap`.`geumas`:Copying 2 columns of 173 rows from table `ntnsap`.`geumas`
`ntnsap`.`geumas`:Finished copying 173 rows in 0m01s
`ntnsap`.`tmpctq`:Copying 9 columns of 19528 rows from table `ntnsap`.`tmpctq`
`ntnsap`.`tmpctq`:Finished copying 19528 rows in 0m12s
`ntnsap`.`ivdfil`:Copying 26 columns of 433506 rows from table `ntnsap`.`ivdfil`
`ntnsap`.`ctqtbl`:Finished copying 163173 rows in 1m55s
`ntnsap`.`sthfil`:Copying 7 columns of 102 rows from table `ntnsap`.`sthfil`
`ntnsap`.`sthfil`:Finished copying 102 rows in 0m00s
`ntnsap`.`dtrtbl`:Copying 3 columns of 55 rows from table `ntnsap`.`dtrtbl`
`ntnsap`.`dtrtbl`:Finished copying 55 rows in 0m01s
`ntnsap`.`bgttbl`:Copying 17 columns of 280637 rows from table `ntnsap`.`bgttbl`
`ntnsap`.`bgttbl`:Finished copying 280637 rows in 4m01s
`ntnsap`.`dptmas`:Copying 3 columns of 10 rows from table `ntnsap`.`dptmas`
`ntnsap`.`dptmas`:Finished copying 10 rows in 0m01s
`ntnsap`.`dlrtbl`:Copying 17 columns of 130 rows from table `ntnsap`.`dlrtbl`
`ntnsap`.`dlrtbl`:Finished copying 130 rows in 0m02s
`ntnsap`.`tmptrt`:Copying 3 columns of 116 rows from table `ntnsap`.`tmptrt`
`ntnsap`.`tmptrt`:Finished copying 116 rows in 0m01s
`ntnsap`.`rbttbl`:Copying 12 columns of 13743 rows from table `ntnsap`.`rbttbl`
`ntnsap`.`rbttbl`:Finished copying 13743 rows in 0m10s
`ntnsap`.`tihfil`:Copying 3 columns of 8648 rows from table `ntnsap`.`tihfil`
`ntnsap`.`ivdfil`:Finished copying 433506 rows in 5m42s
`ntnsap`.`lidtbl`:Copying 2 columns of 1593 rows from table `ntnsap`.`lidtbl`
`ntnsap`.`lidtbl`:Finished copying 1593 rows in 0m03s
`ntnsap`.`demo`:Copying 2 columns of 0 rows from table `ntnsap`.`demo`
`ntnsap`.`demo`:Finished copying 0 rows in 0m01s
`ntnsap`.`ciftbl`:Copying 9 columns of 222047 rows from table `ntnsap`.`ciftbl`
`ntnsap`.`tihfil`:Finished copying 8648 rows in 0m09s
`ntnsap`.`partbl`:Copying 9 columns of 12464 rows from table `ntnsap`.`partbl`
`ntnsap`.`partbl`:Finished copying 12464 rows in 0m14s
`ntnsap`.`ctqmas`:Copying 9 columns of 55571 rows from table `ntnsap`.`ctqmas`
`ntnsap`.`ctqmas`:Finished copying 55571 rows in 0m45s
`ntnsap`.`tcdmas`:Copying 8 columns of 548 rows from table `ntnsap`.`tcdmas`
`ntnsap`.`tcdmas`:Finished copying 548 rows in 0m01s
`ntnsap`.`rgntbl`:Copying 3 columns of 76 rows from table `ntnsap`.`rgntbl`
`ntnsap`.`rgntbl`:Finished copying 76 rows in 0m01s
`ntnsap`.`hldtbl`:Copying 3 columns of 133 rows from table `ntnsap`.`hldtbl`
`ntnsap`.`hldtbl`:Finished copying 133 rows in 0m01s
`ntnsap`.`tempods`:Copying 81 columns of 0 rows from table `ntnsap`.`tempods`
`ntnsap`.`tempods`:Finished copying 0 rows in 0m01s
`ntnsap`.`hsctbl`:Copying 4 columns of 154 rows from table `ntnsap`.`hsctbl`
`ntnsap`.`hsctbl`:Finished copying 154 rows in 0m01s
`ntnsap`.`eurfix`:Copying 1 columns of 26 rows from table `ntnsap`.`eurfix`
`ntnsap`.`eurfix`:Finished copying 26 rows in 0m01s
`ntnsap`.`prtmas`:Copying 4 columns of 260 rows from table `ntnsap`.`prtmas`
`ntnsap`.`prtmas`:Finished copying 260 rows in 0m01s
`ntnsap`.`acsmas`:Copying 3 columns of 42 rows from table `ntnsap`.`acsmas`
`ntnsap`.`acsmas`:Finished copying 42 rows in 0m01s
`ntnsap`.`brhtbl`:Copying 3 columns of 405 rows from table `ntnsap`.`brhtbl`
`ntnsap`.`brhtbl`:Finished copying 405 rows in 0m01s
`ntnsap`.`prdfil`:Copying 11 columns of 77612 rows from table `ntnsap`.`prdfil`
`ntnsap`.`ciftbl`:Finished copying 222047 rows in 3m02s
`ntnsap`.`tmpacs`:Copying 10 columns of 0 rows from table `ntnsap`.`tmpacs`
`ntnsap`.`tmpacs`:Finished copying 0 rows in 0m01s
`ntnsap`.`bpvtbl`:Copying 37 columns of 28 rows from table `ntnsap`.`bpvtbl`
`ntnsap`.`bpvtbl`:Finished copying 28 rows in 0m02s
`ntnsap`.`knvv`:Copying 18 columns of 1949 rows from table `ntnsap`.`knvv`
`ntnsap`.`knvv`:Finished copying 1949 rows in 0m03s
`ntnsap`.`shfmas`:Copying 3 columns of 6 rows from table `ntnsap`.`shfmas`
`ntnsap`.`shfmas`:Finished copying 6 rows in 0m01s
`ntnsap`.`syspermission`:Copying 7 columns of 0 rows from table `ntnsap`.`syspermission`
`ntnsap`.`syspermission`:Finished copying 0 rows in 0m02s
`ntnsap`.`dpttbl`:Copying 2 columns of 237 rows from table `ntnsap`.`dpttbl`
`ntnsap`.`dpttbl`:Finished copying 237 rows in 0m01s
`ntnsap`.`tmpbin`:Copying 13 columns of 4303 rows from table `ntnsap`.`tmpbin`
`ntnsap`.`prdfil`:Finished copying 77612 rows in 2m07s
`ntnsap`.`sihfil`:Copying 13 columns of 8507 rows from table `ntnsap`.`sihfil`
`ntnsap`.`tmpbin`:Finished copying 4303 rows in 0m07s
`ntnsap`.`thdtbl`:Copying 7 columns of 769 rows from table `ntnsap`.`thdtbl`
`ntnsap`.`thdtbl`:Finished copying 769 rows in 0m03s
`ntnsap`.`vbrp`:Copying 54 columns of 35658 rows from table `ntnsap`.`vbrp`
`ntnsap`.`sihfil`:Finished copying 8507 rows in 0m12s
`ntnsap`.`sysrole`:Copying 4 columns of 0 rows from table `ntnsap`.`sysrole`
`ntnsap`.`sysrole`:Finished copying 0 rows in 0m01s
`ntnsap`.`dodfil`:Copying 15 columns of 62917 rows from table `ntnsap`.`dodfil`
`ntnsap`.`vbrp`:Finished copying 35658 rows in 0m40s
`ntnsap`.`xrttbl`:Copying 5 columns of 1893 rows from table `ntnsap`.`xrttbl`
`ntnsap`.`xrttbl`:Finished copying 1893 rows in 0m02s
`ntnsap`.`demoinfo`:Copying 3 columns of 0 rows from table `ntnsap`.`demoinfo`
`ntnsap`.`demoinfo`:Finished copying 0 rows in 0m00s
`ntnsap`.`roltbl`:Copying 2 columns of 11729 rows from table `ntnsap`.`roltbl`
`ntnsap`.`roltbl`:Finished copying 11729 rows in 0m15s
`ntnsap`.`dodfil`:Finished copying 62917 rows in 0m51s
`ntnsap`.`dohfil`:Copying 16 columns of 4712 rows from table `ntnsap`.`dohfil`
`ntnsap`.`dohfil`:Finished copying 4712 rows in 0m05s
`ntnsap`.`tmptest`:Copying 10 columns of 1 rows from table `ntnsap`.`tmptest`
`ntnsap`.`tmptest`:Finished copying 1 rows in 0m00s
`ntnsap`.`logpac`:Copying 6 columns of 861 rows from table `ntnsap`.`logpac`
`ntnsap`.`logpac`:Finished copying 861 rows in 0m01s
`ntnsap`.`pacdtl`:Copying 10 columns of 154 rows from table `ntnsap`.`pacdtl`
`ntnsap`.`pacdtl`:Finished copying 154 rows in 0m01s
`ntnsap`.`tmphbntbl02`:Copying 55 columns of 0 rows from table `ntnsap`.`tmphbntbl02`
`ntnsap`.`tmphbntbl02`:Finished copying 0 rows in 0m00s
`ntnsap`.`stsmas`:Copying 3 columns of 16 rows from table `ntnsap`.`stsmas`
NF][ copytable]: Truncating table `ntnsap`.`tmpstk`

10:03:57 [INF][ copytable]: Truncating table `ntnsap`.`tmpprc`

10:03:57 [INF][ copytable]: Truncating table `ntnsap`.`mactbl`

10:03:58 [INF][ copytable]: Truncating table `ntnsap`.`tkntbl`

10:03:59 [INF][ copytable]: Truncating table `ntnsap`.`sent_notices_bymail`

10:03:59 [INF][ copytable]: Truncating table `ntnsap`.`pohsap`

10:04:12 [INF][ copytable]: Truncating table `ntnsap`.`ctqtbl`

10:04:12 [INF][ copytable]: Truncating table `ntnsap`.`ulhtbl`

10:04:13 [INF][ copytable]: Truncating table `ntnsap`.`tmpeur`

10:04:14 [INF][ copytable]: Truncating table `ntnsap`.`nptmas`

10:04:15 [INF][ copytable]: Truncating table `ntnsap`.`shftbl`

10:04:16 [INF][ copytable]: Truncating table `ntnsap`.`bintbl`

10:04:21 [INF][ copytable]: Truncating table `ntnsap`.`hwrtbl`

10:04:26 [INF][ copytable]: Truncating table `ntnsap`.`gthfil`

10:04:29 [INF][ copytable]: Truncating table `ntnsap`.`geumas`

10:04:30 [INF][ copytable]: Truncating table `ntnsap`.`tmpctq`

10:04:44 [INF][ copytable]: Truncating table `ntnsap`.`ivdfil`

10:06:07 [INF][ copytable]: Truncating table `ntnsap`.`sthfil`

10:06:07 [INF][ copytable]: Truncating table `ntnsap`.`dtrtbl`

10:06:10 [INF][ copytable]: Truncating table `ntnsap`.`bgttbl`

10:10:09 [INF][ copytable]: Truncating table `ntnsap`.`dptmas`

10:10:11 [INF][ copytable]: Truncating table `ntnsap`.`dlrtbl`

10:10:12 [INF][ copytable]: Truncating table `ntnsap`.`tmptrt`

10:10:13 [INF][ copytable]: Truncating table `ntnsap`.`rbttbl`

10:10:23 [INF][ copytable]: Truncating table `ntnsap`.`tihfil`

10:10:25 [INF][ copytable]: Truncating table `ntnsap`.`lidtbl`

10:10:27 [INF][ copytable]: Truncating table `ntnsap`.`demo`

10:10:29 [INF][ copytable]: Truncating table `ntnsap`.`ciftbl`

10:10:33 [INF][ copytable]: Truncating table `ntnsap`.`partbl`

10:10:47 [INF][ copytable]: Truncating table `ntnsap`.`ctqmas`

10:11:31 [INF][ copytable]: Truncating table `ntnsap`.`tcdmas`

10:11:32 [INF][ copytable]: Truncating table `ntnsap`.`rgntbl`

10:11:34 [INF][ copytable]: Truncating table `ntnsap`.`hldtbl`

10:11:34 [INF][ copytable]: Truncating table `ntnsap`.`tempods`

10:11:35 [INF][ copytable]: Truncating table `ntnsap`.`hsctbl`

10:11:36 [INF][ copytable]: Truncating table `ntnsap`.`eurfix`

10:11:37 [INF][ copytable]: Truncating table `ntnsap`.`prtmas`

10:11:38 [INF][ copytable]: Truncating table `ntnsap`.`acsmas`

10:11:39 [INF][ copytable]: Truncating table `ntnsap`.`brhtbl`

10:11:40 [INF][ copytable]: Truncating table `ntnsap`.`prdfil`

10:13:30 [INF][ copytable]: Truncating table `ntnsap`.`tmpacs`

10:13:31 [INF][ copytable]: Truncating table `ntnsap`.`bpvtbl`

10:13:33 [INF][ copytable]: Truncating table `ntnsap`.`knvv`

10:13:36 [INF][ copytable]: Truncating table `ntnsap`.`shfmas`

10:13:37 [INF][ copytable]: Truncating table `ntnsap`.`syspermission`

10:13:39 [INF][ copytable]: Truncating table `ntnsap`.`dpttbl`

10:13:40 [INF][ copytable]: Truncating table `ntnsap`.`tmpbin`

10:13:47 [INF][ copytable]: Truncating table `ntnsap`.`sihfil`

10:13:47 [INF][ copytable]: Truncating table `ntnsap`.`thdtbl`

10:13:51 [INF][ copytable]: Truncating table `ntnsap`.`vbrp`

10:13:59 [INF][ copytable]: Truncating table `ntnsap`.`sysrole`

10:14:00 [INF][ copytable]: Truncating table `ntnsap`.`dodfil`

10:14:30 [INF][ copytable]: Truncating table `ntnsap`.`xrttbl`

10:14:32 [INF][ copytable]: Truncating table `ntnsap`.`demoinfo`

10:14:32 [INF][ copytable]: Truncating table `ntnsap`.`roltbl`

10:14:51 [INF][ copytable]: Truncating table `ntnsap`.`dohfil`

10:14:56 [INF][ copytable]: Truncating table `ntnsap`.`tmptest`

10:14:56 [INF][ copytable]: Truncating table `ntnsap`.`logpac`

10:14:57 [INF][ copytable]: Truncating table `ntnsap`.`pacdtl`

10:14:58 [INF][ copytable]: Truncating table `ntnsap`.`tmphbntbl02`

10:PROGRESS:`ntnsap`.`stsmas`:16:16

`ntnsap`.`stsmas`:Finished copying 16 rows in 0m01s
`ntnsap`.`vbrk`:Copying 52 columns of 2974 rows from table `ntnsap`.`vbrk`
`ntnsap`.`scmfil`:Copying 23 columns of 2207275 rows from table `ntnsap`.`scmfil`
`ntnsap`.`vbrk`:Finished copying 2974 rows in 0m06s
`ntnsap`.`hqhfil`:Copying 5 columns of 78 rows from table `ntnsap`.`hqhfil`
`ntnsap`.`hqhfil`:Finished copying 78 rows in 0m01s
`ntnsap`.`tmpjpntbl`:Copying 2 columns of 306 rows from table `ntnsap`.`tmpjpntbl`
`ntnsap`.`tmpjpntbl`:Finished copying 306 rows in 0m01s
`ntnsap`.`tmpstt`:Copying 4 columns of 238 rows from table `ntnsap`.`tmpstt`
`ntnsap`.`tmpstt`:Finished copying 238 rows in 0m02s
`ntnsap`.`iqdfil`:Copying 14 columns of 128632 rows from table `ntnsap`.`iqdfil`
`ntnsap`.`iqdfil`:Finished copying 128632 rows in 1m41s
`ntnsap`.`brhmas`:Copying 10 columns of 7 rows from table `ntnsap`.`brhmas`
`ntnsap`.`brhmas`:Finished copying 7 rows in 0m01s
`ntnsap`.`tmphbntbl`:Copying 57 columns of 0 rows from table `ntnsap`.`tmphbntbl`
`ntnsap`.`tmphbntbl`:Finished copying 0 rows in 0m00s
`ntnsap`.`acrtbl`:Copying 11 columns of 132 rows from table `ntnsap`.`acrtbl`
`ntnsap`.`acrtbl`:Finished copying 132 rows in 0m01s
`ntnsap`.`sahfil`:Copying 4 columns of 195708 rows from table `ntnsap`.`sahfil`
`ntnsap`.`sahfil`:Finished copying 195708 rows in 2m20s
`ntnsap`.`suptbl`:Copying 12 columns of 61 rows from table `ntnsap`.`suptbl`
`ntnsap`.`suptbl`:Finished copying 61 rows in 0m01s
`ntnsap`.`pactyp`:Copying 3 columns of 0 rows from table `ntnsap`.`pactyp`
`ntnsap`.`pactyp`:Finished copying 0 rows in 0m01s
`ntnsap`.`sysuserrole`:Copying 2 columns of 0 rows from table `ntnsap`.`sysuserrole`
`ntnsap`.`sysuserrole`:Finished copying 0 rows in 0m01s
`ntnsap`.`saltbl`:Copying 6 columns of 215 rows from table `ntnsap`.`saltbl`
`ntnsap`.`saltbl`:Finished copying 215 rows in 0m00s
`ntnsap`.`lvlmas`:Copying 2 columns of 14 rows from table `ntnsap`.`lvlmas`
`ntnsap`.`lvlmas`:Finished copying 14 rows in 0m02s
`ntnsap`.`logtbl`:Copying 9 columns of 10478 rows from table `ntnsap`.`logtbl`
`ntnsap`.`logtbl`:Finished copying 10478 rows in 0m09s
`ntnsap`.`schfil`:Copying 24 columns of 29555 rows from table `ntnsap`.`schfil`
`ntnsap`.`schfil`:Finished copying 29555 rows in 0m24s
`ntnsap`.`stlmas`:Copying 11 columns of 30 rows from table `ntnsap`.`stlmas`
`ntnsap`.`stlmas`:Finished copying 30 rows in 0m01s
`ntnsap`.`ctltbl`:Copying 8 columns of 38 rows from table `ntnsap`.`ctltbl`
`ntnsap`.`ctltbl`:Finished copying 38 rows in 0m01s
`ntnsap`.`tmpprd`:Copying 6 columns of 39305 rows from table `ntnsap`.`tmpprd`
`ntnsap`.`tmpprd`:Finished copying 39305 rows in 0m35s
`ntnsap`.`pkctbl`:Copying 3 columns of 181 rows from table `ntnsap`.`pkctbl`
`ntnsap`.`pkctbl`:Finished copying 181 rows in 0m02s
`ntnsap`.`otctbl`:Copying 10 columns of 1290 rows from table `ntnsap`.`otctbl`
`ntnsap`.`otctbl`:Finished copying 1290 rows in 0m04s
`ntnsap`.`tmpstd`:Copying 12 columns of 14450 rows from table `ntnsap`.`tmpstd`
`ntnsap`.`tmpstd`:Finished copying 14450 rows in 0m17s
`ntnsap`.`wlttbl`:Copying 6 columns of 443 rows from table `ntnsap`.`wlttbl`
`ntnsap`.`wlttbl`:Finished copying 443 rows in 0m02s
`ntnsap`.`stftbl`:Copying 22 columns of 260 rows from table `ntnsap`.`stftbl`
`ntnsap`.`stftbl`:Finished copying 260 rows in 0m01s
`ntnsap`.`hkabhkdexchangerates`:Copying 19 columns of 458 rows from table `ntnsap`.`hkabhkdexchangerates`
`ntnsap`.`hkabhkdexchangerates`:Finished copying 458 rows in 0m02s
`ntnsap`.`frmtbl`:Copying 4 columns of 50 rows from table `ntnsap`.`frmtbl`
`ntnsap`.`frmtbl`:Finished copying 50 rows in 0m01s
`ntnsap`.`salmas`:Copying 6 columns of 206 rows from table `ntnsap`.`salmas`
`ntnsap`.`salmas`:Finished copying 206 rows in 0m02s
`ntnsap`.`rtgmas`:Copying 3 columns of 11 rows from table `ntnsap`.`rtgmas`
`ntnsap`.`rtgmas`:Finished copying 11 rows in 0m00s
`ntnsap`.`idsmas`:Copying 10 columns of 350 rows from table `ntnsap`.`idsmas`
`ntnsap`.`idsmas`:Finished copying 350 rows in 0m02s
`ntnsap`.`bgtmas`:Copying 5 columns of 30 rows from table `ntnsap`.`bgtmas`
`ntnsap`.`bgtmas`:Finished copying 30 rows in 0m01s
`ntnsap`.`hbntbl`:Copying 41 columns of 637765 rows from table `ntnsap`.`hbntbl`
`ntnsap`.`hbntbl`:Finished copying 637765 rows in 10m04s
`ntnsap`.`sidfil`:Copying 13 columns of 263189 rows from table `ntnsap`.`sidfil`
`ntnsap`.`sidfil`:Finished copying 263189 rows in 3m39s
`ntnsap`.`tmptbl2`:Copying 3 columns of 0 rows from table `ntnsap`.`tmptbl2`
`ntnsap`.`tmptbl2`:Finished copying 0 rows in 0m01s
`ntnsap`.`tmpbrg`:Copying 2 columns of 4365 rows from table `ntnsap`.`tmpbrg`
`ntnsap`.`tmpbrg`:Finished copying 4365 rows in 0m05s
`ntnsap`.`vbpa`:Copying 5 columns of 14449 rows from table `ntnsap`.`vbpa`
`ntnsap`.`vbpa`:Finished copying 14449 rows in 0m15s
`ntnsap`.`fsdfil`:Copying 9 columns of 3304 rows from table `ntnsap`.`fsdfil`
`ntnsap`.`fsdfil`:Finished copying 3304 rows in 0m06s
ERROR: `ntnsap`.`tmptbl`:mysql_query(SELECT count(*) FROM `tmptbl`): Table 'ntnsap.tmptbl' doesn't exist
`ntnsap`.`tmptbl`:Finished copying 0 rows in 0m00s
`ntnsap`.`hwrtbltmp`:Copying 13 columns of 1441 rows from table `ntnsap`.`hwrtbltmp`
`ntnsap`.`hwrtbltmp`:Finished copying 1441 rows in 0m05s
`ntnsap`.`zmmr0040tmp`:Copying 77 columns of 41468 rows from table `ntnsap`.`zmmr0040tmp`
`ntnsap`.`zmmr0040tmp`:Finished copying 41468 rows in 0m48s
`ntnsap`.`sgnmas`:Copying 5 columns of 54 rows from table `ntnsap`.`sgnmas`
`ntnsap`.`sgnmas`:Finished copying 54 rows in 0m00s
`ntnsap`.`prhfil`:Copying 5 columns of 4 rows from table `ntnsap`.`prhfil`
`ntnsap`.`prhfil`:Finished copying 4 rows in 0m01s
`ntnsap`.`cifsap`:Copying 21 columns of 414073 rows from table `ntnsap`.`cifsap`
ERROR: `ntnsap`.`cifsap`:Failed copying 348947 rows
ERROR: `ntnsap`.`tmptext`:mysql_query(SELECT count(*) FROM `tmptext`): MySQL server has gone away
`ntnsap`.`tmptext`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`hqdfil`:mysql_query(SELECT count(*) FROM `hqdfil`): MySQL server has gone away



Copy helper has finished

Data copy results:
- `ntnsap`.`tmpstk` has succeeded (0 of 0 rows copied)
- `ntnsap`.`tmpprc` has succeeded (19530 of 19530 rows copied)
- `ntnsap`.`mactbl` has succeeded (0 of 0 rows copied)
- `ntnsap`.`tkntbl` has succeeded (80 of 80 rows copied)
- `ntnsap`.`sent_notices_bymail` has succeeded (77 of 77 rows copied)
- `ntnsap`.`pohsap` has succeeded (13981 of 13981 rows copied)
- `ntnsap`.`ctqtbl` has succeeded (163173 of 163173 rows copied)
- `ntnsap`.`ulhtbl` has succeeded (116 of 116 rows copied)
- `ntnsap`.`tmpeur` has succeeded (0 of 0 rows copied)
- `ntnsap`.`nptmas` has succeeded (248 of 248 rows copied)
- `ntnsap`.`shftbl` has succeeded (42 of 42 rows copied)
- `ntnsap`.`bintbl` has succeeded (3335 of 3335 rows copied)
- `ntnsap`.`hwrtbl` has succeeded (1542 of 1542 rows copied)
- `ntnsap`.`gthfil` has succeeded (1605 of 1605 rows copied)
- `ntnsap`.`geumas` has succeeded (173 of 173 rows copied)
- `ntnsap`.`tmpctq` has succeeded (19528 of 19528 rows copied)
- `ntnsap`.`ivdfil` has succeeded (433506 of 433506 rows copied)
- `ntnsap`.`sthfil` has succeeded (102 of 102 rows copied)
- `ntnsap`.`dtrtbl` has succeeded (55 of 55 rows copied)
- `ntnsap`.`bgttbl` has succeeded (280637 of 280637 rows copied)
- `ntnsap`.`dptmas` has succeeded (10 of 10 rows copied)
- `ntnsap`.`dlrtbl` has succeeded (130 of 130 rows copied)
- `ntnsap`.`tmptrt` has succeeded (116 of 116 rows copied)
- `ntnsap`.`rbttbl` has succeeded (13743 of 13743 rows copied)
- `ntnsap`.`tihfil` has succeeded (8648 of 8648 rows copied)
- `ntnsap`.`lidtbl` has succeeded (1593 of 1593 rows copied)
- `ntnsap`.`demo` has succeeded (0 of 0 rows copied)
- `ntnsap`.`ciftbl` has succeeded (222047 of 222047 rows copied)
- `ntnsap`.`partbl` has succeeded (12464 of 12464 rows copied)
- `ntnsap`.`ctqmas` has succeeded (55571 of 55571 rows copied)
- `ntnsap`.`tcdmas` has succeeded (548 of 548 rows copied)
- `ntnsap`.`rgntbl` has succeeded (76 of 76 rows copied)
- `ntnsap`.`hldtbl` has succeeded (133 of 133 rows copied)
- `ntnsap`.`tempods` has succeeded (0 of 0 rows copied)
- `ntnsap`.`hsctbl` has succeeded (154 of 154 rows copied)
- `ntnsap`.`eurfix` has succeeded (26 of 26 rows copied)
- `ntnsap`.`prtmas` has succeeded (260 of 260 rows copied)
- `ntnsap`.`acsmas` has succeeded (42 of 42 rows copied)
- `ntnsap`.`brhtbl` has succeeded (405 of 405 rows copied)
- `ntnsap`.`prdfil` has succeeded (77612 of 77612 rows copied)
- `ntnsap`.`tmpacs` has succeeded (0 of 0 rows copied)
- `ntnsap`.`bpvtbl` has succeeded (28 of 28 rows copied)
- `ntnsap`.`knvv` has succeeded (1949 of 1949 rows copied)
- `ntnsap`.`shfmas` has succeeded (6 of 6 rows copied)
- `ntnsap`.`syspermission` has succeeded (0 of 0 rows copied)
- `ntnsap`.`dpttbl` has succeeded (237 of 237 rows copied)
- `ntnsap`.`tmpbin` has succeeded (4303 of 4303 rows copied)
- `ntnsap`.`sihfil` has succeeded (8507 of 8507 rows copied)
- `ntnsap`.`thdtbl` has succeeded (769 of 769 rows copied)
- `ntnsap`.`vbrp` has succeeded (35658 of 35658 rows copied)
- `ntnsap`.`sysrole` has succeeded (0 of 0 rows copied)
- `ntnsap`.`dodfil` has succeeded (62917 of 62917 rows copied)
- `ntnsap`.`xrttbl` has succeeded (1893 of 1893 rows copied)
- `ntnsap`.`demoinfo` has succeeded (0 of 0 rows copied)
- `ntnsap`.`roltbl` has succeeded (11729 of 11729 rows copied)
- `ntnsap`.`scmfil` has succeeded (2207275 of 2207275 rows copied)
- `ntnsap`.`dohfil` has succeeded (4712 of 4712 rows copied)
- `ntnsap`.`tmptest` has succeeded (1 of 1 rows copied)
- `ntnsap`.`logpac` has succeeded (861 of 861 rows copied)
- `ntnsap`.`pacdtl` has succeeded (154 of 154 rows copied)
- `ntnsap`.`tmphbntbl02` has succeeded (0 of 0 rows copied)
- `ntnsap`.`stsmas` has FAILED (0 of 16 rows copied)
- `ntnsap`.`vbrk` has succeeded (2974 of 2974 rows copied)
- `ntnsap`.`hqhfil` has succeeded (78 of 78 rows copied)
- `ntnsap`.`tmpjpntbl` has succeeded (306 of 306 rows copied)
- `ntnsap`.`tmpstt` has succeeded (238 of 238 rows copied)
- `ntnsap`.`iqdfil` has succeeded (128632 of 128632 rows copied)
- `ntnsap`.`brhmas` has succeeded (7 of 7 rows copied)
- `ntnsap`.`tmphbntbl` has succeeded (0 of 0 rows copied)
- `ntnsap`.`acrtbl` has succeeded (132 of 132 rows copied)
- `ntnsap`.`sahfil` has succeeded (195708 of 195708 rows copied)
- `ntnsap`.`suptbl` has succeeded (61 of 61 rows copied)
- `ntnsap`.`pactyp` has succeeded (0 of 0 rows copied)
- `ntnsap`.`sysuserrole` has succeeded (0 of 0 rows copied)
- `ntnsap`.`saltbl` has succeeded (215 of 215 rows copied)
- `ntnsap`.`lvlmas` has succeeded (14 of 14 rows copied)
- `ntnsap`.`logtbl` has succeeded (10478 of 10478 rows copied)
- `ntnsap`.`schfil` has succeeded (29555 of 29555 rows copied)
- `ntnsap`.`stlmas` has succeeded (30 of 30 rows copied)
- `ntnsap`.`ctltbl` has succeeded (38 of 38 rows copied)
- `ntnsap`.`tmpprd` has succeeded (39305 of 39305 rows copied)
- `ntnsap`.`pkctbl` has succeeded (181 of 181 rows copied)
- `ntnsap`.`otctbl` has succeeded (1290 of 1290 rows copied)
- `ntnsap`.`tmpstd` has succeeded (14450 of 14450 rows copied)
- `ntnsap`.`wlttbl` has succeeded (443 of 443 rows copied)
- `ntnsap`.`stftbl` has succeeded (260 of 260 rows copied)
- `ntnsap`.`hkabhkdexchangerates` has succeeded (458 of 458 rows copied)
- `ntnsap`.`frmtbl` has succeeded (50 of 50 rows copied)
- `ntnsap`.`salmas` has succeeded (206 of 206 rows copied)
- `ntnsap`.`rtgmas` has succeeded (11 of 11 rows copied)
- `ntnsap`.`idsmas` has succeeded (350 of 350 rows copied)
- `ntnsap`.`bgtmas` has succeeded (30 of 30 rows copied)
- `ntnsap`.`hbntbl` has succeeded (637765 of 637765 rows copied)
- `ntnsap`.`sidfil` has succeeded (263189 of 263189 rows copied)
- `ntnsap`.`tmptbl2` has succeeded (0 of 0 rows copied)
- `ntnsap`.`tmpbrg` has succeeded (4365 of 4365 rows copied)
- `ntnsap`.`vbpa` has succeeded (14449 of 14449 rows copied)
- `ntnsap`.`fsdfil` has succeeded (3304 of 3304 rows copied)
- `ntnsap`.`tmptbl` has FAILED (0 of 16672 rows copied)
- `ntnsap`.`hwrtbltmp` has succeeded (1441 of 1441 rows copied)
- `ntnsap`.`zmmr0040tmp` has succeeded (41468 of 41468 rows copied)
- `ntnsap`.`sgnmas` has succeeded (54 of 54 rows copied)
- `ntnsap`.`prhfil` has succeeded (4 of 4 rows copied)
- `ntnsap`.`cifsap` has FAILED (65126 of 414073 rows copied)
- `ntnsap`.`tmptext` has FAILED (0 of 265845 rows copied)
- `ntnsap`.`hqdfil` has FAILED (0 of 22847 rows copied)
- `ntnsap`.`tmpivd` has FAILED (0 of 3149 rows copied)
- `ntnsap`.`rsttbl` has FAILED (0 of 375 rows copied)
- `ntnsap`.`othatt` has FAILED (0 of 7 rows copied)
- `ntnsap`.`sysrolepermission` has succeeded (0 of 0 rows copied)
- `ntnsap`.`publicholiday` has FAILED (0 of 51 rows copied)
- `ntnsap`.`lmttbl` has FAILED (0 of 41 rows copied)
- `ntnsap`.`cpntbl` has FAILED (0 of 1415 rows copied)
- `ntnsap`.`pchtbl` has FAILED (0 of 35728 rows copied)
- `ntnsap`.`cpymas` has FAILED (0 of 111 rows copied)
- `ntnsap`.`tmpods` has FAILED (0 of 16130 rows copied)
- `ntnsap`.`ncftbl` has FAILED (0 of 49 rows copied)
- `ntnsap`.`mdggicmas` has FAILED (0 of 44 rows copied)
- `ntnsap`.`xhgpkctbl` has FAILED (0 of 79 rows copied)
- `ntnsap`.`hshtbl` has FAILED (0 of 8 rows copied)
- `ntnsap`.`ivhfil` has FAILED (0 of 31886 rows copied)
- `ntnsap`.`mtltbl` has FAILED (0 of 55518 rows copied)
- `ntnsap`.`knb1` has FAILED (0 of 611 rows copied)
- `ntnsap`.`qrctbl` has FAILED (0 of 41555 rows copied)
- `ntnsap`.`geutbl` has FAILED (0 of 310 rows copied)
- `ntnsap`.`sgntbl` has FAILED (0 of 1352 rows copied)
- `ntnsap`.`pidfil` has succeeded (0 of 0 rows copied)
- `ntnsap`.`tmpgtp` has FAILED (0 of 4473 rows copied)
- `ntnsap`.`fbptbl` has FAILED (0 of 75 rows copied)
- `ntnsap`.`orgmas` has FAILED (0 of 249 rows copied)
- `ntnsap`.`stdfil` has FAILED (0 of 275946 rows copied)
- `ntnsap`.`iqhfil` has FAILED (0 of 7089 rows copied)
- `ntnsap`.`ctlmas` has FAILED (0 of 7 rows copied)
- `ntnsap`.`custyptbl` has FAILED (0 of 5 rows copied)
- `ntnsap`.`cifmas` has FAILED (0 of 22 rows copied)
- `ntnsap`.`piktbl` has FAILED (0 of 1118 rows copied)
- `ntnsap`.`tmp111` has FAILED (0 of 31 rows copied)
- `ntnsap`.`gtpfil` has FAILED (0 of 383485 rows copied)
- `ntnsap`.`rgnmas` has FAILED (0 of 1544 rows copied)
- `ntnsap`.`curmas` has FAILED (0 of 187 rows copied)
- `ntnsap`.`gicmas` has FAILED (0 of 29 rows copied)
- `ntnsap`.`euctbl` has FAILED (0 of 908 rows copied)
- `ntnsap`.`xrttmp` has FAILED (0 of 932 rows copied)
- `ntnsap`.`fshfil` has FAILED (0 of 1267 rows copied)
- `ntnsap`.`podsap` has FAILED (0 of 299641 rows copied)
- `ntnsap`.`tempgtp` has succeeded (0 of 0 rows copied)
- `ntnsap`.`ctnmas` has FAILED (0 of 209 rows copied)
- `ntnsap`.`rolmas` has FAILED (0 of 222 rows copied)
- `ntnsap`.`brdmas` has FAILED (0 of 10 rows copied)
- `ntnsap`.`rmktbl` has FAILED (0 of 8 rows copied)
- `ntnsap`.`aremas` has FAILED (0 of 24 rows copied)
- `ntnsap`.`gtdfil` has FAILED (0 of 117207 rows copied)
- `ntnsap`.`kjumas` has FAILED (0 of 143 rows copied)
- `ntnsap`.`ccctbl` has FAILED (0 of 9 rows copied)
- `ntnsap`.`custbl` has FAILED (0 of 493 rows copied)
- `ntnsap`.`stmtbl` has FAILED (0 of 385699 rows copied)
- `ntnsap`.`czntbl` has FAILED (0 of 480 rows copied)
- `ntnsap`.`dlhtbl` has FAILED (0 of 258 rows copied)
- `ntnsap`.`binmas` has FAILED (0 of 496 rows copied)
- `ntnsap`.`lidmas` has FAILED (0 of 154 rows copied)
- `ntnsap`.`atbtbl` has FAILED (0 of 10 rows copied)
- `ntnsap`.`tidfil` has FAILED (0 of 88452 rows copied)
- `ntnsap`.`txtmas` has FAILED (0 of 413 rows copied)
- `ntnsap`.`clsmas` has FAILED (0 of 418 rows copied)
- `ntnsap`.`tmp20170802` has FAILED (0 of 3948 rows copied)
- `ntnsap`.`tmp123` has FAILED (0 of 5798 rows copied)
- `ntnsap`.`tmptblt` has succeeded (0 of 0 rows copied)
- `ntnsap`.`zmmr0160temp` has FAILED (0 of 5103 rows copied)
- `ntnsap`.`sapciftbl` has FAILED (0 of 47215 rows copied)
- `ntnsap`.`scbtbl` has FAILED (0 of 156 rows copied)
- `ntnsap`.`sadfil` has FAILED (0 of 458014 rows copied)
- `ntnsap`.`scdfil` has FAILED (0 of 384432 rows copied)
- `ntnsap`.`userinfo` has succeeded (0 of 0 rows copied)
- `ntnsap`.`oemtbl` has FAILED (0 of 21904 rows copied)
- `ntnsap`.`scdtmp` has FAILED (0 of 315 rows copied)
- `ntnsap`.`rvltbl` has FAILED (0 of 16401 rows copied)
- `ntnsap`.`pihfil` has FAILED (0 of 40 rows copied)
- `ntnsap`.`pohfil` has FAILED (0 of 183876 rows copied)
- `ntnsap`.`acstbl` has FAILED (0 of 121171 rows copied)
- `ntnsap`.`vbap` has FAILED (0 of 52581 rows copied)
- `ntnsap`.`podfil` has FAILED (0 of 274313 rows copied)
- `ntnsap`.`knvp` has FAILED (0 of 11685 rows copied)
- `ntnsap`.`vbak` has FAILED (0 of 5335 rows copied)
- `ntnsap`.`tknmas` has FAILED (0 of 2 rows copied)
- `ntnsap`.`txztbl` has FAILED (0 of 76 rows copied)
- `ntnsap`.`vbkd` has FAILED (0 of 18948 rows copied)
- `ntnsap`.`qrclog` has FAILED (0 of 198 rows copied)
- `ntnsap`.`pmttbl` has FAILED (0 of 73 rows copied)
- `ntnsap`.`pachdr` has FAILED (0 of 1861 rows copied)
- `ntnsap`.`tmpgit` has FAILED (0 of 2908 rows copied)
- `ntnsap`.`ctymas` has FAILED (0 of 245 rows copied)
- `ntnsap`.`stktbl` has FAILED (0 of 5111 rows copied)
106 tables of 192 were fully copied
Click [Retry] to retry copying remaining data from tables
Copy data to target RDBMS finished
Tasks finished with warnings and/or errors; view the logs for details
Finished performing tasks.


Can you figure out what is the root cause of this issue?
I had changed the allow packet sizing to 256mb in the my.ini file.

Options: ReplyQuote


Subject
Written By
Posted
Re: Migration from ubuntu mysql 5.7 to windows mysql 5.7
September 15, 2020 10:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.