DbImport module missing channel data

Forum Home Forums Runtime Bugs Server Bugs DbImport module missing channel data

Viewing 12 posts - 1 through 12 (of 12 total)
  • Author
    Posts
  • #9028
    zzz
    Participant

    Hi MikHail,

    In my previous setup, there is such problem with wich dbexport.dll module randomly missing data pints for some channel.

    Since the module is not using bulk insertion, initialy I thought there could be (/will be efficiency issue at somepoint), so I changed the code to do bulk insertion (pgsql):
    instead of insert into ... value (row1) on conflict do nothing; insert ...(row2)... repeat..,
    now it does insert into ... value (.row1..),(.row2..),...repeat...(.rowN.) on conflict do nothing;

    But apparently it’s not the case here, now there still are missing data points, and I noticed that, after srezs are dequeued, some of them does not return CnlData object. The orginal code in question is located in ExportSrez
    If instead of simply ignore, I replace them with insert(time,cnlnum, null,null), the number of records per channel in table looks much better (though with useless data…).

    I have only chiped in a small chunk of the project. Do you have any suggestions about why this could possibly happend ? or where to look at for clues in further debug?

    #9030
    Mikhail
    Moderator

    Hi,

    We will release a fully new ModDbExport which can insert several channels in a one SQL request. My suggestion is to wait for the release.

    #9033
    zzz
    Participant

    Hi MikHail,

    That’s a good news, but the problem doesn’t seem to be a insertion performance issue. With bulk insertion the queue size is usually <3 srez, though with peaks like 7 sometimes, performance shouldn’t be an issue compared to prev level.

    I compared the results after 1 night run. In the debug log I see some channels with >50% empty rate, those channel have signficantly less data in database analysis. While the graph in RS webstation shows complete dataset for these channels. Could you provide any clue why this could happen?

    PS: Will the new plugin be pushed to scada git repo? I’d like to compile and test.

    Regards

    #9037
    Mikhail
    Moderator

    Hi,

    In the debug log I see some channels with >50% empty rate, those channel have signficantly less data in database analysis. While the graph in RS webstation shows complete dataset for these channels.

    Could you provide data examples?

    Will the new plugin be pushed to scada git repo?

    Yes.

    #9039
    zzz
    Participant

    Hi Mik,

    Thanks for responding, Below is a log I added to the module.
    EnqueueCurData() is modified to flatten incoming curSrez into string like (ch1.col1, ch1.col2, ch1.col3),(ch2.col1, ch2.col2,ch2.col3)... based on the sql template after VALUES, such string is enqueued instead of the srez object. A Missing cnlData... is logged if the CnlData in curSrez is null.

    
    Missing cnlData[1207] @2021/6/5 14:44:50
    Missing cnlData[1219] @2021/6/5 14:44:50
    Missing cnlData[1215] @2021/6/5 14:44:50
    Missing cnlData[11300] @2021/6/5 14:44:50
    CurQ.SrezCnt=11   // logged Upon the entry of ExportCurData() function
    2021-06-05 14:44:50 MkInsCmd empty cnldata: 11/20  //batch stat before commit;
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:44:51
    Missing cnlData[1220] @2021/6/5 14:44:51
    Missing cnlData[1420] @2021/6/5 14:44:51
    CurQ.SrezCnt=9
    2021-06-05 14:44:51 MkInsCmd empty cnldata: 9/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:44:51
    Missing cnlData[1403] @2021/6/5 14:44:52
    Missing cnlData[1203] @2021/6/5 14:44:52
    Missing cnlData[1215] @2021/6/5 14:44:52
    Missing cnlData[1216] @2021/6/5 14:44:52
    Missing cnlData[1217] @2021/6/5 14:44:52
    CurQ.SrezCnt=13
    2021-06-05 14:44:52 MkInsCmd empty cnldata: 13/22
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:44:53
    Missing cnlData[11200] @2021/6/5 14:44:53
    Missing cnlData[1220] @2021/6/5 14:44:53
    CurQ.SrezCnt=11
    2021-06-05 14:44:53 MkInsCmd empty cnldata: 11/21
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11300] @2021/6/5 14:44:53
    Missing cnlData[703] @2021/6/5 14:44:53
    Missing cnlData[1420] @2021/6/5 14:44:54
    CurQ.SrezCnt=10
    2021-06-05 14:44:54 MkInsCmd empty cnldata: 10/15
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:44:54
    Missing cnlData[703] @2021/6/5 14:44:55
    Missing cnlData[1207] @2021/6/5 14:44:55
    Missing cnlData[1219] @2021/6/5 14:44:55
    Missing cnlData[1215] @2021/6/5 14:44:55
    Missing cnlData[703] @2021/6/5 14:44:55
    CurQ.SrezCnt=10
    2021-06-05 14:44:55 MkInsCmd empty cnldata: 10/18
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11200] @2021/6/5 14:44:56
    Missing cnlData[1220] @2021/6/5 14:44:56
    CurQ.SrezCnt=8
    2021-06-05 14:44:56 MkInsCmd empty cnldata: 8/10
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:44:57
    Missing cnlData[11300] @2021/6/5 14:44:57
    Missing cnlData[703] @2021/6/5 14:44:57
    Missing cnlData[1207] @2021/6/5 14:44:57
    Missing cnlData[1219] @2021/6/5 14:44:57
    Missing cnlData[1224] @2021/6/5 14:44:57
    Missing cnlData[1403] @2021/6/5 14:44:57
    Missing cnlData[703] @2021/6/5 14:44:57
    CurQ.SrezCnt=10
    2021-06-05 14:44:57 MkInsCmd empty cnldata: 10/22
    DEBUG: ExportCurData COMMITed
    Missing cnlData[2603] @2021/6/5 14:44:57
    Missing cnlData[1220] @2021/6/5 14:44:58
    CurQ.SrezCnt=11
    2021-06-05 14:44:58 MkInsCmd empty cnldata: 11/15
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:44:59
    Missing cnlData[1207] @2021/6/5 14:44:59
    Missing cnlData[1219] @2021/6/5 14:44:59
    Missing cnlData[1224] @2021/6/5 14:44:59
    Missing cnlData[11200] @2021/6/5 14:44:59
    Missing cnlData[1420] @2021/6/5 14:44:59
    CurQ.SrezCnt=10
    2021-06-05 14:44:59 MkInsCmd empty cnldata: 10/21
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11300] @2021/6/5 14:45:00
    Missing cnlData[1403] @2021/6/5 14:45:00
    Missing cnlData[703] @2021/6/5 14:45:00
    Missing cnlData[2603] @2021/6/5 14:45:00
    CurQ.SrezCnt=11
    2021-06-05 14:45:00 MkInsCmd empty cnldata: 11/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:01
    Missing cnlData[1220] @2021/6/5 14:45:01
    CurQ.SrezCnt=9
    2021-06-05 14:45:01 MkInsCmd empty cnldata: 9/11
    DEBUG: ExportCurData COMMITed
    Missing cnlData[803] @2021/6/5 14:45:02
    Missing cnlData[1207] @2021/6/5 14:45:02
    Missing cnlData[1219] @2021/6/5 14:45:02
    Missing cnlData[1215] @2021/6/5 14:45:02
    Missing cnlData[703] @2021/6/5 14:45:02
    Missing cnlData[1420] @2021/6/5 14:45:02
    Missing cnlData[11200] @2021/6/5 14:45:02
    CurQ.SrezCnt=11
    2021-06-05 14:45:02 MkInsCmd empty cnldata: 11/21
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:03
    Missing cnlData[1403] @2021/6/5 14:45:03
    Missing cnlData[11300] @2021/6/5 14:45:03
    Missing cnlData[1220] @2021/6/5 14:45:03
    Missing cnlData[703] @2021/6/5 14:45:03
    CurQ.SrezCnt=7
    2021-06-05 14:45:03 MkInsCmd empty cnldata: 7/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1203] @2021/6/5 14:45:04
    Missing cnlData[1215] @2021/6/5 14:45:04
    Missing cnlData[1216] @2021/6/5 14:45:04
    Missing cnlData[1217] @2021/6/5 14:45:04
    CurQ.SrezCnt=11
    2021-06-05 14:45:04 MkInsCmd empty cnldata: 11/37
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:05
    Missing cnlData[1420] @2021/6/5 14:45:05
    CurQ.SrezCnt=8
    2021-06-05 14:45:05 MkInsCmd empty cnldata: 8/12
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:45:05
    Missing cnlData[703] @2021/6/5 14:45:05
    Missing cnlData[11200] @2021/6/5 14:45:06
    Missing cnlData[1203] @2021/6/5 14:45:06
    Missing cnlData[11300] @2021/6/5 14:45:06
    Missing cnlData[10101] @2021/6/5 14:45:06
    Missing cnlData[10102] @2021/6/5 14:45:06
    Missing cnlData[1] @2021/6/5 14:45:06
    Missing cnlData[31] @2021/6/5 14:45:06
    CurQ.SrezCnt=10
    2021-06-05 14:45:06 MkInsCmd empty cnldata: 10/19
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:07
    Missing cnlData[1215] @2021/6/5 14:45:07
    Missing cnlData[10201] @2021/6/5 14:45:07
    Missing cnlData[10202] @2021/6/5 14:45:07
    Missing cnlData[2] @2021/6/5 14:45:07
    Missing cnlData[32] @2021/6/5 14:45:07
    CurQ.SrezCnt=8
    2021-06-05 14:45:07 MkInsCmd empty cnldata: 8/18
    Missing cnlData[703] @2021/6/5 14:45:07
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:45:07
    Missing cnlData[10301] @2021/6/5 14:45:08
    Missing cnlData[10302] @2021/6/5 14:45:08
    Missing cnlData[3] @2021/6/5 14:45:08
    Missing cnlData[33] @2021/6/5 14:45:08
    Missing cnlData[1221] @2021/6/5 14:45:08
    Missing cnlData[1220] @2021/6/5 14:45:08
    Missing cnlData[1203] @2021/6/5 14:45:08
    Missing cnlData[1224] @2021/6/5 14:45:08
    Missing cnlData[1215] @2021/6/5 14:45:08
    Missing cnlData[1216] @2021/6/5 14:45:08
    Missing cnlData[1217] @2021/6/5 14:45:08
    Missing cnlData[1403] @2021/6/5 14:45:08
    CurQ.SrezCnt=9
    2021-06-05 14:45:08 MkInsCmd empty cnldata: 9/27
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:09
    Missing cnlData[11001] @2021/6/5 14:45:09
    Missing cnlData[11002] @2021/6/5 14:45:09
    Missing cnlData[10] @2021/6/5 14:45:09
    Missing cnlData[40] @2021/6/5 14:45:09
    Missing cnlData[11200] @2021/6/5 14:45:09
    Missing cnlData[1207] @2021/6/5 14:45:09
    Missing cnlData[1219] @2021/6/5 14:45:09
    Missing cnlData[1224] @2021/6/5 14:45:09
    Missing cnlData[703] @2021/6/5 14:45:09
    Missing cnlData[11300] @2021/6/5 14:45:09
    CurQ.SrezCnt=11
    2021-06-05 14:45:09 MkInsCmd empty cnldata: 11/25
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1003] @2021/6/5 14:45:10
    Missing cnlData[1220] @2021/6/5 14:45:10
    Missing cnlData[1420] @2021/6/5 14:45:10
    CurQ.SrezCnt=10
    2021-06-05 14:45:10 MkInsCmd empty cnldata: 10/15
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:11
    Missing cnlData[1403] @2021/6/5 14:45:11
    Missing cnlData[1207] @2021/6/5 14:45:11
    Missing cnlData[1219] @2021/6/5 14:45:11
    Missing cnlData[1224] @2021/6/5 14:45:11
    Missing cnlData[703] @2021/6/5 14:45:11
    CurQ.SrezCnt=8
    2021-06-05 14:45:11 MkInsCmd empty cnldata: 8/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:45:12
    Missing cnlData[11200] @2021/6/5 14:45:12
    CurQ.SrezCnt=8
    2021-06-05 14:45:12 MkInsCmd empty cnldata: 8/12
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11300] @2021/6/5 14:45:13
    Missing cnlData[703] @2021/6/5 14:45:13
    Missing cnlData[1420] @2021/6/5 14:45:13
    Missing cnlData[703] @2021/6/5 14:45:13
    CurQ.SrezCnt=9
    2021-06-05 14:45:13 MkInsCmd empty cnldata: 9/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:45:14
    Missing cnlData[1207] @2021/6/5 14:45:14
    Missing cnlData[1219] @2021/6/5 14:45:14
    Missing cnlData[1215] @2021/6/5 14:45:14
    CurQ.SrezCnt=6
    2021-06-05 14:45:14 MkInsCmd empty cnldata: 6/13
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:15
    Missing cnlData[1220] @2021/6/5 14:45:15
    Missing cnlData[11200] @2021/6/5 14:45:15
    CurQ.SrezCnt=11
    2021-06-05 14:45:15 MkInsCmd empty cnldata: 11/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11300] @2021/6/5 14:45:16
    Missing cnlData[1203] @2021/6/5 14:45:16
    Missing cnlData[1215] @2021/6/5 14:45:16
    Missing cnlData[1216] @2021/6/5 14:45:16
    Missing cnlData[1217] @2021/6/5 14:45:16
    Missing cnlData[1420] @2021/6/5 14:45:16
    Missing cnlData[703] @2021/6/5 14:45:16
    Missing cnlData[11401] @2021/6/5 14:45:16
    Missing cnlData[11402] @2021/6/5 14:45:16
    Missing cnlData[11400] @2021/6/5 14:45:16
    Missing cnlData[11403] @2021/6/5 14:45:16
    Missing cnlData[10703] @2021/6/5 14:45:16
    Missing cnlData[10700] @2021/6/5 14:45:16
    Missing cnlData[7] @2021/6/5 14:45:16
    CurQ.SrezCnt=8
    2021-06-05 14:45:16 MkInsCmd empty cnldata: 8/27
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:45:17
    Missing cnlData[703] @2021/6/5 14:45:17
    Missing cnlData[11401] @2021/6/5 14:45:17
    Missing cnlData[11402] @2021/6/5 14:45:17
    Missing cnlData[11400] @2021/6/5 14:45:17
    Missing cnlData[11403] @2021/6/5 14:45:17
    Missing cnlData[1220] @2021/6/5 14:45:17
    Missing cnlData[10801] @2021/6/5 14:45:17
    Missing cnlData[10802] @2021/6/5 14:45:17
    Missing cnlData[8] @2021/6/5 14:45:17
    Missing cnlData[38] @2021/6/5 14:45:17
    CurQ.SrezCnt=9
    2021-06-05 14:45:17 MkInsCmd empty cnldata: 9/25
    DEBUG: ExportCurData COMMITed
    Missing cnlData[10603] @2021/6/5 14:45:18
    Missing cnlData[10600] @2021/6/5 14:45:18
    Missing cnlData[6] @2021/6/5 14:45:18
    Missing cnlData[11103] @2021/6/5 14:45:18
    Missing cnlData[11100] @2021/6/5 14:45:18
    Missing cnlData[11] @2021/6/5 14:45:18
    Missing cnlData[703] @2021/6/5 14:45:18
    Missing cnlData[1207] @2021/6/5 14:45:18
    Missing cnlData[1219] @2021/6/5 14:45:18
    Missing cnlData[1215] @2021/6/5 14:45:18
    Missing cnlData[10503] @2021/6/5 14:45:18
    Missing cnlData[10500] @2021/6/5 14:45:18
    Missing cnlData[5] @2021/6/5 14:45:18
    Missing cnlData[11203] @2021/6/5 14:45:18
    Missing cnlData[11209] @2021/6/5 14:45:18
    Missing cnlData[11200] @2021/6/5 14:45:18
    Missing cnlData[12] @2021/6/5 14:45:18
    CurQ.SrezCnt=11
    2021-06-05 14:45:18 MkInsCmd empty cnldata: 11/36
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:19
    Missing cnlData[1420] @2021/6/5 14:45:19
    Missing cnlData[10403] @2021/6/5 14:45:19
    Missing cnlData[10400] @2021/6/5 14:45:19
    Missing cnlData[4] @2021/6/5 14:45:19
    Missing cnlData[11303] @2021/6/5 14:45:19
    Missing cnlData[11309] @2021/6/5 14:45:19
    Missing cnlData[11300] @2021/6/5 14:45:19
    Missing cnlData[13] @2021/6/5 14:45:19
    Missing cnlData[1403] @2021/6/5 14:45:19
    CurQ.SrezCnt=8
    2021-06-05 14:45:19 MkInsCmd empty cnldata: 8/22
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:45:20
    Missing cnlData[2603] @2021/6/5 14:45:20
    Missing cnlData[703] @2021/6/5 14:45:20
    CurQ.SrezCnt=11
    2021-06-05 14:45:20 MkInsCmd empty cnldata: 11/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:21
    Missing cnlData[1207] @2021/6/5 14:45:21
    Missing cnlData[1219] @2021/6/5 14:45:21
    Missing cnlData[1215] @2021/6/5 14:45:21
    Missing cnlData[1420] @2021/6/5 14:45:21
    CurQ.SrezCnt=8
    2021-06-05 14:45:21 MkInsCmd empty cnldata: 8/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11200] @2021/6/5 14:45:22
    Missing cnlData[703] @2021/6/5 14:45:22
    Missing cnlData[1220] @2021/6/5 14:45:22
    Missing cnlData[1403] @2021/6/5 14:45:22
    Missing cnlData[11300] @2021/6/5 14:45:22
    CurQ.SrezCnt=15
    2021-06-05 14:45:22 MkInsCmd empty cnldata: 15/23
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:23
    Missing cnlData[1207] @2021/6/5 14:45:23
    Missing cnlData[1219] @2021/6/5 14:45:23
    Missing cnlData[1224] @2021/6/5 14:45:23
    CurQ.SrezCnt=10
    2021-06-05 14:45:23 MkInsCmd empty cnldata: 10/21
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:24
    Missing cnlData[1220] @2021/6/5 14:45:24
    Missing cnlData[1420] @2021/6/5 14:45:24
    CurQ.SrezCnt=11
    2021-06-05 14:45:24 MkInsCmd empty cnldata: 11/18
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:25
    Missing cnlData[1403] @2021/6/5 14:45:25
    Missing cnlData[11200] @2021/6/5 14:45:25
    Missing cnlData[1207] @2021/6/5 14:45:25
    Missing cnlData[1219] @2021/6/5 14:45:25
    Missing cnlData[1215] @2021/6/5 14:45:25
    Missing cnlData[11300] @2021/6/5 14:45:25
    CurQ.SrezCnt=11
    2021-06-05 14:45:25 MkInsCmd empty cnldata: 11/21
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:26
    CurQ.SrezCnt=6
    2021-06-05 14:45:26 MkInsCmd empty cnldata: 6/7
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:27
    Missing cnlData[1420] @2021/6/5 14:45:27
    Missing cnlData[1220] @2021/6/5 14:45:27
    Missing cnlData[1403] @2021/6/5 14:45:27
    CurQ.SrezCnt=10
    2021-06-05 14:45:27 MkInsCmd empty cnldata: 10/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[2603] @2021/6/5 14:45:28
    Missing cnlData[703] @2021/6/5 14:45:28
    Missing cnlData[1207] @2021/6/5 14:45:28
    Missing cnlData[1219] @2021/6/5 14:45:28
    Missing cnlData[1224] @2021/6/5 14:45:28
    Missing cnlData[11200] @2021/6/5 14:45:28
    CurQ.SrezCnt=11
    2021-06-05 14:45:28 MkInsCmd empty cnldata: 11/20
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:29
    Missing cnlData[11300] @2021/6/5 14:45:29
    Missing cnlData[1220] @2021/6/5 14:45:29
    CurQ.SrezCnt=8
    2021-06-05 14:45:29 MkInsCmd empty cnldata: 8/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:45:29
    Missing cnlData[703] @2021/6/5 14:45:30
    Missing cnlData[1207] @2021/6/5 14:45:30
    Missing cnlData[1219] @2021/6/5 14:45:30
    Missing cnlData[1215] @2021/6/5 14:45:30
    Missing cnlData[1403] @2021/6/5 14:45:30
    Missing cnlData[703] @2021/6/5 14:45:30
    CurQ.SrezCnt=9
    2021-06-05 14:45:30 MkInsCmd empty cnldata: 9/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:45:31
    Missing cnlData[11200] @2021/6/5 14:45:31
    CurQ.SrezCnt=10
    2021-06-05 14:45:31 MkInsCmd empty cnldata: 10/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:32
    Missing cnlData[1203] @2021/6/5 14:45:32
    Missing cnlData[11300] @2021/6/5 14:45:32
    Missing cnlData[703] @2021/6/5 14:45:32
    Missing cnlData[1420] @2021/6/5 14:45:32
    CurQ.SrezCnt=8
    2021-06-05 14:45:32 MkInsCmd empty cnldata: 8/15
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1215] @2021/6/5 14:45:33
    Missing cnlData[1403] @2021/6/5 14:45:33
    CurQ.SrezCnt=8
    2021-06-05 14:45:33 MkInsCmd empty cnldata: 8/12
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:34
    Missing cnlData[1220] @2021/6/5 14:45:34
    Missing cnlData[703] @2021/6/5 14:45:34
    CurQ.SrezCnt=11
    2021-06-05 14:45:34 MkInsCmd empty cnldata: 11/36
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11200] @2021/6/5 14:45:35
    Missing cnlData[1203] @2021/6/5 14:45:35
    Missing cnlData[1215] @2021/6/5 14:45:35
    Missing cnlData[1216] @2021/6/5 14:45:35
    Missing cnlData[1217] @2021/6/5 14:45:35
    Missing cnlData[703] @2021/6/5 14:45:35
    Missing cnlData[11300] @2021/6/5 14:45:35
    Missing cnlData[1420] @2021/6/5 14:45:35
    CurQ.SrezCnt=9
    2021-06-05 14:45:35 MkInsCmd empty cnldata: 9/18
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:36
    Missing cnlData[1403] @2021/6/5 14:45:36
    Missing cnlData[1220] @2021/6/5 14:45:36
    Missing cnlData[703] @2021/6/5 14:45:36
    CurQ.SrezCnt=7
    2021-06-05 14:45:36 MkInsCmd empty cnldata: 7/13
    DEBUG: ExportCurData COMMITed
    Missing cnlData[10101] @2021/6/5 14:45:37
    Missing cnlData[10102] @2021/6/5 14:45:37
    Missing cnlData[1] @2021/6/5 14:45:37
    Missing cnlData[31] @2021/6/5 14:45:37
    Missing cnlData[1207] @2021/6/5 14:45:37
    Missing cnlData[1219] @2021/6/5 14:45:37
    Missing cnlData[1215] @2021/6/5 14:45:37
    CurQ.SrezCnt=11
    2021-06-05 14:45:37 MkInsCmd empty cnldata: 11/21
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:38
    Missing cnlData[11200] @2021/6/5 14:45:38
    Missing cnlData[10201] @2021/6/5 14:45:38
    Missing cnlData[10202] @2021/6/5 14:45:38
    Missing cnlData[2] @2021/6/5 14:45:38
    Missing cnlData[32] @2021/6/5 14:45:38
    Missing cnlData[1420] @2021/6/5 14:45:38
    Missing cnlData[1220] @2021/6/5 14:45:38
    Missing cnlData[1221] @2021/6/5 14:45:38
    Missing cnlData[1220] @2021/6/5 14:45:38
    Missing cnlData[1203] @2021/6/5 14:45:38
    Missing cnlData[1224] @2021/6/5 14:45:38
    Missing cnlData[1215] @2021/6/5 14:45:38
    Missing cnlData[1216] @2021/6/5 14:45:38
    Missing cnlData[1217] @2021/6/5 14:45:38
    Missing cnlData[11300] @2021/6/5 14:45:38
    Missing cnlData[1403] @2021/6/5 14:45:38
    CurQ.SrezCnt=11
    2021-06-05 14:45:39 MkInsCmd empty cnldata: 11/32
    DEBUG: ExportCurData COMMITed
    Missing cnlData[10301] @2021/6/5 14:45:39
    Missing cnlData[10302] @2021/6/5 14:45:39
    Missing cnlData[3] @2021/6/5 14:45:39
    Missing cnlData[33] @2021/6/5 14:45:39
    Missing cnlData[703] @2021/6/5 14:45:39
    Missing cnlData[11001] @2021/6/5 14:45:39
    Missing cnlData[11002] @2021/6/5 14:45:39
    Missing cnlData[10] @2021/6/5 14:45:39
    Missing cnlData[40] @2021/6/5 14:45:39
    CurQ.SrezCnt=8
    2021-06-05 14:45:40 MkInsCmd empty cnldata: 8/19
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:40
    Missing cnlData[1003] @2021/6/5 14:45:40
    Missing cnlData[2603] @2021/6/5 14:45:40
    Missing cnlData[1203] @2021/6/5 14:45:40
    Missing cnlData[1215] @2021/6/5 14:45:40
    Missing cnlData[1216] @2021/6/5 14:45:40
    Missing cnlData[703] @2021/6/5 14:45:40
    CurQ.SrezCnt=11
    2021-06-05 14:45:41 MkInsCmd empty cnldata: 11/19
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:45:41
    Missing cnlData[11200] @2021/6/5 14:45:41
    Missing cnlData[1220] @2021/6/5 14:45:41
    Missing cnlData[1403] @2021/6/5 14:45:41
    Missing cnlData[11300] @2021/6/5 14:45:41
    CurQ.SrezCnt=8
    2021-06-05 14:45:42 MkInsCmd empty cnldata: 8/15
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:42
    Missing cnlData[1203] @2021/6/5 14:45:42
    Missing cnlData[1215] @2021/6/5 14:45:42
    Missing cnlData[1217] @2021/6/5 14:45:42
    CurQ.SrezCnt=11
    2021-06-05 14:45:43 MkInsCmd empty cnldata: 11/19
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:43
    Missing cnlData[1220] @2021/6/5 14:45:43
    Missing cnlData[703] @2021/6/5 14:45:43
    Missing cnlData[1420] @2021/6/5 14:45:43
    CurQ.SrezCnt=11
    2021-06-05 14:45:44 MkInsCmd empty cnldata: 11/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:45:44
    Missing cnlData[1207] @2021/6/5 14:45:44
    Missing cnlData[1219] @2021/6/5 14:45:44
    Missing cnlData[1215] @2021/6/5 14:45:44
    Missing cnlData[11200] @2021/6/5 14:45:44
    CurQ.SrezCnt=8
    2021-06-05 14:45:45 MkInsCmd empty cnldata: 8/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:45
    Missing cnlData[11300] @2021/6/5 14:45:45
    CurQ.SrezCnt=9
    2021-06-05 14:45:46 MkInsCmd empty cnldata: 9/11
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:45:46
    Missing cnlData[703] @2021/6/5 14:45:46
    Missing cnlData[1420] @2021/6/5 14:45:46
    Missing cnlData[703] @2021/6/5 14:45:47
    CurQ.SrezCnt=8
    2021-06-05 14:45:47 MkInsCmd empty cnldata: 8/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:45:47
    Missing cnlData[1203] @2021/6/5 14:45:47
    Missing cnlData[1215] @2021/6/5 14:45:47
    Missing cnlData[1216] @2021/6/5 14:45:47
    Missing cnlData[1217] @2021/6/5 14:45:47
    Missing cnlData[11401] @2021/6/5 14:45:47
    Missing cnlData[11402] @2021/6/5 14:45:47
    Missing cnlData[11400] @2021/6/5 14:45:47
    Missing cnlData[11403] @2021/6/5 14:45:47
    Missing cnlData[11200] @2021/6/5 14:45:47
    CurQ.SrezCnt=8
    2021-06-05 14:45:48 MkInsCmd empty cnldata: 8/23
    DEBUG: ExportCurData COMMITed
    Missing cnlData[10603] @2021/6/5 14:45:48
    Missing cnlData[10600] @2021/6/5 14:45:48
    Missing cnlData[6] @2021/6/5 14:45:48
    Missing cnlData[703] @2021/6/5 14:45:48
    Missing cnlData[11300] @2021/6/5 14:45:48
    Missing cnlData[1220] @2021/6/5 14:45:48
    Missing cnlData[10503] @2021/6/5 14:45:48
    Missing cnlData[10500] @2021/6/5 14:45:48
    Missing cnlData[5] @2021/6/5 14:45:48
    Missing cnlData[703] @2021/6/5 14:45:48
    Missing cnlData[10703] @2021/6/5 14:45:48
    Missing cnlData[10700] @2021/6/5 14:45:48
    Missing cnlData[7] @2021/6/5 14:45:48
    CurQ.SrezCnt=12
    2021-06-05 14:45:49 MkInsCmd empty cnldata: 12/31
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:45:49
    Missing cnlData[10403] @2021/6/5 14:45:49
    Missing cnlData[10400] @2021/6/5 14:45:49
    Missing cnlData[4] @2021/6/5 14:45:49
    Missing cnlData[1219] @2021/6/5 14:45:49
    Missing cnlData[1215] @2021/6/5 14:45:49
    Missing cnlData[10801] @2021/6/5 14:45:49
    Missing cnlData[10802] @2021/6/5 14:45:49
    Missing cnlData[8] @2021/6/5 14:45:49
    Missing cnlData[38] @2021/6/5 14:45:49
    Missing cnlData[1403] @2021/6/5 14:45:49
    CurQ.SrezCnt=8
    2021-06-05 14:45:50 MkInsCmd empty cnldata: 8/24
    DEBUG: ExportCurData COMMITed
    Missing cnlData[803] @2021/6/5 14:45:50
    Missing cnlData[703] @2021/6/5 14:45:50
    Missing cnlData[1220] @2021/6/5 14:45:50
    Missing cnlData[11103] @2021/6/5 14:45:50
    Missing cnlData[11100] @2021/6/5 14:45:50
    Missing cnlData[11] @2021/6/5 14:45:50
    Missing cnlData[703] @2021/6/5 14:45:50
    Missing cnlData[11203] @2021/6/5 14:45:50
    Missing cnlData[11209] @2021/6/5 14:45:50
    Missing cnlData[11200] @2021/6/5 14:45:50
    Missing cnlData[12] @2021/6/5 14:45:50
    CurQ.SrezCnt=10
    2021-06-05 14:45:51 MkInsCmd empty cnldata: 10/23
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11303] @2021/6/5 14:45:51
    Missing cnlData[11309] @2021/6/5 14:45:51
    Missing cnlData[11300] @2021/6/5 14:45:51
    Missing cnlData[13] @2021/6/5 14:45:51
    Missing cnlData[1203] @2021/6/5 14:45:51
    Missing cnlData[1215] @2021/6/5 14:45:51
    Missing cnlData[1216] @2021/6/5 14:45:51
    CurQ.SrezCnt=8
    2021-06-05 14:45:52 MkInsCmd empty cnldata: 8/19
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:45:52
    Missing cnlData[703] @2021/6/5 14:45:52
    Missing cnlData[1403] @2021/6/5 14:45:52
    Missing cnlData[703] @2021/6/5 14:45:52
    CurQ.SrezCnt=13
    2021-06-05 14:45:53 MkInsCmd empty cnldata: 13/20
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:45:53
    CurQ.SrezCnt=11
    2021-06-05 14:45:54 MkInsCmd empty cnldata: 11/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:54
    Missing cnlData[11200] @2021/6/5 14:45:54
    Missing cnlData[1207] @2021/6/5 14:45:54
    Missing cnlData[1219] @2021/6/5 14:45:54
    Missing cnlData[1224] @2021/6/5 14:45:54
    Missing cnlData[11300] @2021/6/5 14:45:54
    Missing cnlData[703] @2021/6/5 14:45:54
    Missing cnlData[1420] @2021/6/5 14:45:54
    CurQ.SrezCnt=12
    2021-06-05 14:45:55 MkInsCmd empty cnldata: 12/26
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:45:55
    Missing cnlData[1220] @2021/6/5 14:45:55
    Missing cnlData[703] @2021/6/5 14:45:56
    CurQ.SrezCnt=9
    2021-06-05 14:45:56 MkInsCmd empty cnldata: 9/12
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1219] @2021/6/5 14:45:56
    Missing cnlData[1215] @2021/6/5 14:45:56
    CurQ.SrezCnt=9
    2021-06-05 14:45:57 MkInsCmd empty cnldata: 9/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11200] @2021/6/5 14:45:57
    Missing cnlData[703] @2021/6/5 14:45:57
    Missing cnlData[1220] @2021/6/5 14:45:57
    Missing cnlData[1420] @2021/6/5 14:45:57
    Missing cnlData[11300] @2021/6/5 14:45:57
    Missing cnlData[703] @2021/6/5 14:45:57
    CurQ.SrezCnt=10
    2021-06-05 14:45:58 MkInsCmd empty cnldata: 10/18
    Missing cnlData[1403] @2021/6/5 14:45:58
    DEBUG: ExportCurData COMMITed
    Missing cnlData[2603] @2021/6/5 14:45:58
    Missing cnlData[1203] @2021/6/5 14:45:58
    CurQ.SrezCnt=10
    2021-06-05 14:45:59 MkInsCmd empty cnldata: 10/15
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:45:59
    Missing cnlData[1215] @2021/6/5 14:45:59
    Missing cnlData[1217] @2021/6/5 14:45:59
    Missing cnlData[703] @2021/6/5 14:45:59
    CurQ.SrezCnt=10
    2021-06-05 14:46:00 MkInsCmd empty cnldata: 10/19
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:46:00
    Missing cnlData[2603] @2021/6/5 14:46:00
    Missing cnlData[1220] @2021/6/5 14:46:00
    Missing cnlData[11200] @2021/6/5 14:46:00
    Missing cnlData[1403] @2021/6/5 14:46:00
    CurQ.SrezCnt=7
    2021-06-05 14:46:01 MkInsCmd empty cnldata: 7/12
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11300] @2021/6/5 14:46:01
    Missing cnlData[1219] @2021/6/5 14:46:01
    Missing cnlData[1215] @2021/6/5 14:46:01
    Missing cnlData[703] @2021/6/5 14:46:01
    CurQ.SrezCnt=11
    2021-06-05 14:46:02 MkInsCmd empty cnldata: 11/18
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:02
    Missing cnlData[1220] @2021/6/5 14:46:02
    Missing cnlData[703] @2021/6/5 14:46:03
    CurQ.SrezCnt=8
    2021-06-05 14:46:03 MkInsCmd empty cnldata: 8/13
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:46:03
    Missing cnlData[1203] @2021/6/5 14:46:03
    Missing cnlData[11200] @2021/6/5 14:46:03
    Missing cnlData[1403] @2021/6/5 14:46:03
    CurQ.SrezCnt=11
    2021-06-05 14:46:04 MkInsCmd empty cnldata: 11/18
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11300] @2021/6/5 14:46:04
    Missing cnlData[703] @2021/6/5 14:46:04
    Missing cnlData[1220] @2021/6/5 14:46:04
    Missing cnlData[703] @2021/6/5 14:46:05
    CurQ.SrezCnt=10
    2021-06-05 14:46:05 MkInsCmd empty cnldata: 10/34
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1203] @2021/6/5 14:46:05
    Missing cnlData[703] @2021/6/5 14:46:05
    Missing cnlData[1420] @2021/6/5 14:46:05
    CurQ.SrezCnt=9
    2021-06-05 14:46:06 MkInsCmd empty cnldata: 9/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:06
    Missing cnlData[1224] @2021/6/5 14:46:06
    Missing cnlData[1403] @2021/6/5 14:46:06
    Missing cnlData[11200] @2021/6/5 14:46:06
    Missing cnlData[703] @2021/6/5 14:46:06
    CurQ.SrezCnt=10
    2021-06-05 14:46:07 MkInsCmd empty cnldata: 10/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:46:07
    Missing cnlData[11300] @2021/6/5 14:46:07
    Missing cnlData[10101] @2021/6/5 14:46:07
    Missing cnlData[10102] @2021/6/5 14:46:07
    Missing cnlData[1] @2021/6/5 14:46:07
    Missing cnlData[31] @2021/6/5 14:46:07
    CurQ.SrezCnt=10
    2021-06-05 14:46:08 MkInsCmd empty cnldata: 11/19
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:08
    Missing cnlData[1207] @2021/6/5 14:46:08
    Missing cnlData[1219] @2021/6/5 14:46:08
    Missing cnlData[1215] @2021/6/5 14:46:08
    Missing cnlData[1221] @2021/6/5 14:46:08
    Missing cnlData[1220] @2021/6/5 14:46:08
    Missing cnlData[1203] @2021/6/5 14:46:08
    Missing cnlData[1224] @2021/6/5 14:46:08
    Missing cnlData[1215] @2021/6/5 14:46:08
    Missing cnlData[1216] @2021/6/5 14:46:08
    Missing cnlData[1217] @2021/6/5 14:46:08
    Missing cnlData[1420] @2021/6/5 14:46:08
    Missing cnlData[10201] @2021/6/5 14:46:08
    Missing cnlData[10202] @2021/6/5 14:46:08
    Missing cnlData[2] @2021/6/5 14:46:08
    Missing cnlData[32] @2021/6/5 14:46:08
    Missing cnlData[703] @2021/6/5 14:46:08
    CurQ.SrezCnt=10
    2021-06-05 14:46:09 MkInsCmd empty cnldata: 10/32
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:46:09
    Missing cnlData[1220] @2021/6/5 14:46:09
    Missing cnlData[10301] @2021/6/5 14:46:09
    Missing cnlData[10302] @2021/6/5 14:46:09
    Missing cnlData[3] @2021/6/5 14:46:09
    Missing cnlData[33] @2021/6/5 14:46:09
    Missing cnlData[11200] @2021/6/5 14:46:10
    CurQ.SrezCnt=9
    2021-06-05 14:46:10 MkInsCmd empty cnldata: 9/18
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1003] @2021/6/5 14:46:10
    Missing cnlData[703] @2021/6/5 14:46:10
    Missing cnlData[1203] @2021/6/5 14:46:10
    Missing cnlData[1215] @2021/6/5 14:46:10
    Missing cnlData[1216] @2021/6/5 14:46:10
    Missing cnlData[1217] @2021/6/5 14:46:10
    Missing cnlData[11001] @2021/6/5 14:46:10
    Missing cnlData[11002] @2021/6/5 14:46:10
    Missing cnlData[10] @2021/6/5 14:46:10
    Missing cnlData[40] @2021/6/5 14:46:10
    Missing cnlData[11300] @2021/6/5 14:46:10
    Missing cnlData[703] @2021/6/5 14:46:10
    CurQ.SrezCnt=9
    2021-06-05 14:46:11 MkInsCmd empty cnldata: 9/23
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:46:11
    Missing cnlData[1220] @2021/6/5 14:46:11
    Missing cnlData[1403] @2021/6/5 14:46:11
    CurQ.SrezCnt=11
    2021-06-05 14:46:12 MkInsCmd empty cnldata: 11/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:12
    Missing cnlData[703] @2021/6/5 14:46:12
    CurQ.SrezCnt=10
    2021-06-05 14:46:13 MkInsCmd empty cnldata: 10/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11200] @2021/6/5 14:46:13
    Missing cnlData[1219] @2021/6/5 14:46:13
    Missing cnlData[1215] @2021/6/5 14:46:13
    Missing cnlData[11300] @2021/6/5 14:46:13
    Missing cnlData[1420] @2021/6/5 14:46:13
    CurQ.SrezCnt=9
    2021-06-05 14:46:14 MkInsCmd empty cnldata: 9/18
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:14
    Missing cnlData[1220] @2021/6/5 14:46:14
    Missing cnlData[1403] @2021/6/5 14:46:14
    Missing cnlData[703] @2021/6/5 14:46:14
    CurQ.SrezCnt=10
    2021-06-05 14:46:15 MkInsCmd empty cnldata: 10/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1207] @2021/6/5 14:46:15
    Missing cnlData[1219] @2021/6/5 14:46:15
    Missing cnlData[1224] @2021/6/5 14:46:15
    CurQ.SrezCnt=7
    2021-06-05 14:46:16 MkInsCmd empty cnldata: 7/13
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:16
    Missing cnlData[1220] @2021/6/5 14:46:16
    Missing cnlData[11200] @2021/6/5 14:46:16
    Missing cnlData[1420] @2021/6/5 14:46:16
    Missing cnlData[703] @2021/6/5 14:46:16
    Missing cnlData[11300] @2021/6/5 14:46:17
    CurQ.SrezCnt=9
    2021-06-05 14:46:17 MkInsCmd empty cnldata: 9/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:46:17
    Missing cnlData[1203] @2021/6/5 14:46:17
    Missing cnlData[1215] @2021/6/5 14:46:17
    Missing cnlData[1217] @2021/6/5 14:46:17
    CurQ.SrezCnt=9
    2021-06-05 14:46:18 MkInsCmd empty cnldata: 9/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:18
    Missing cnlData[703] @2021/6/5 14:46:18
    CurQ.SrezCnt=12
    2021-06-05 14:46:19 MkInsCmd empty cnldata: 12/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:46:19
    Missing cnlData[1220] @2021/6/5 14:46:19
    Missing cnlData[11200] @2021/6/5 14:46:19
    Missing cnlData[1403] @2021/6/5 14:46:20
    CurQ.SrezCnt=9
    2021-06-05 14:46:20 MkInsCmd empty cnldata: 9/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11300] @2021/6/5 14:46:20
    Missing cnlData[803] @2021/6/5 14:46:20
    Missing cnlData[11401] @2021/6/5 14:46:20
    Missing cnlData[11402] @2021/6/5 14:46:20
    Missing cnlData[11400] @2021/6/5 14:46:20
    Missing cnlData[11403] @2021/6/5 14:46:20
    Missing cnlData[703] @2021/6/5 14:46:20
    Missing cnlData[1215] @2021/6/5 14:46:20
    Missing cnlData[2603] @2021/6/5 14:46:20
    Missing cnlData[10703] @2021/6/5 14:46:20
    Missing cnlData[10700] @2021/6/5 14:46:20
    Missing cnlData[7] @2021/6/5 14:46:20
    Missing cnlData[703] @2021/6/5 14:46:20
    CurQ.SrezCnt=11
    2021-06-05 14:46:21 MkInsCmd empty cnldata: 11/28
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11401] @2021/6/5 14:46:21
    Missing cnlData[11402] @2021/6/5 14:46:21
    Missing cnlData[11400] @2021/6/5 14:46:21
    Missing cnlData[11403] @2021/6/5 14:46:21
    Missing cnlData[1220] @2021/6/5 14:46:21
    Missing cnlData[10801] @2021/6/5 14:46:21
    Missing cnlData[10802] @2021/6/5 14:46:21
    Missing cnlData[8] @2021/6/5 14:46:21
    Missing cnlData[38] @2021/6/5 14:46:21
    Missing cnlData[10603] @2021/6/5 14:46:21
    Missing cnlData[10600] @2021/6/5 14:46:21
    Missing cnlData[6] @2021/6/5 14:46:21
    Missing cnlData[1420] @2021/6/5 14:46:22
    CurQ.SrezCnt=9
    2021-06-05 14:46:22 MkInsCmd empty cnldata: 9/28
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11103] @2021/6/5 14:46:22
    Missing cnlData[11100] @2021/6/5 14:46:22
    Missing cnlData[11] @2021/6/5 14:46:22
    Missing cnlData[1206] @2021/6/5 14:46:22
    Missing cnlData[1207] @2021/6/5 14:46:22
    Missing cnlData[1219] @2021/6/5 14:46:22
    Missing cnlData[1224] @2021/6/5 14:46:22
    Missing cnlData[10503] @2021/6/5 14:46:22
    Missing cnlData[10500] @2021/6/5 14:46:22
    Missing cnlData[5] @2021/6/5 14:46:22
    Missing cnlData[703] @2021/6/5 14:46:22
    Missing cnlData[1403] @2021/6/5 14:46:22
    Missing cnlData[11203] @2021/6/5 14:46:22
    Missing cnlData[11209] @2021/6/5 14:46:22
    Missing cnlData[11200] @2021/6/5 14:46:22
    Missing cnlData[12] @2021/6/5 14:46:22
    Missing cnlData[10403] @2021/6/5 14:46:23
    Missing cnlData[10400] @2021/6/5 14:46:23
    Missing cnlData[4] @2021/6/5 14:46:23
    CurQ.SrezCnt=16
    2021-06-05 14:46:23 MkInsCmd empty cnldata: 16/45
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:23
    Missing cnlData[11303] @2021/6/5 14:46:23
    Missing cnlData[11309] @2021/6/5 14:46:23
    Missing cnlData[11300] @2021/6/5 14:46:23
    Missing cnlData[13] @2021/6/5 14:46:23
    Missing cnlData[1220] @2021/6/5 14:46:23
    Missing cnlData[703] @2021/6/5 14:46:24
    CurQ.SrezCnt=13
    2021-06-05 14:46:24 MkInsCmd empty cnldata: 13/26
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1215] @2021/6/5 14:46:24
    Missing cnlData[1420] @2021/6/5 14:46:24
    CurQ.SrezCnt=10
    2021-06-05 14:46:25 MkInsCmd empty cnldata: 10/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:25
    Missing cnlData[1403] @2021/6/5 14:46:25
    Missing cnlData[11200] @2021/6/5 14:46:25
    CurQ.SrezCnt=8
    2021-06-05 14:46:26 MkInsCmd empty cnldata: 8/11
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:26
    Missing cnlData[1220] @2021/6/5 14:46:26
    Missing cnlData[11300] @2021/6/5 14:46:26
    Missing cnlData[703] @2021/6/5 14:46:26
    CurQ.SrezCnt=9
    2021-06-05 14:46:27 MkInsCmd empty cnldata: 9/15
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1206] @2021/6/5 14:46:27
    Missing cnlData[1219] @2021/6/5 14:46:27
    Missing cnlData[1215] @2021/6/5 14:46:27
    Missing cnlData[1420] @2021/6/5 14:46:27
    Missing cnlData[1403] @2021/6/5 14:46:28
    CurQ.SrezCnt=9
    2021-06-05 14:46:28 MkInsCmd empty cnldata: 9/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:28
    Missing cnlData[2603] @2021/6/5 14:46:28
    Missing cnlData[1220] @2021/6/5 14:46:28
    Missing cnlData[703] @2021/6/5 14:46:28
    CurQ.SrezCnt=14
    2021-06-05 14:46:29 MkInsCmd empty cnldata: 14/19
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11200] @2021/6/5 14:46:29
    Missing cnlData[1207] @2021/6/5 14:46:29
    Missing cnlData[1219] @2021/6/5 14:46:29
    Missing cnlData[1215] @2021/6/5 14:46:29
    Missing cnlData[11300] @2021/6/5 14:46:29
    CurQ.SrezCnt=7
    2021-06-05 14:46:30 MkInsCmd empty cnldata: 7/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:46:30
    Missing cnlData[1220] @2021/6/5 14:46:30
    Missing cnlData[1403] @2021/6/5 14:46:30
    CurQ.SrezCnt=6
    2021-06-05 14:46:31 MkInsCmd empty cnldata: 6/9
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:31
    Missing cnlData[703] @2021/6/5 14:46:31
    CurQ.SrezCnt=10
    2021-06-05 14:46:32 MkInsCmd empty cnldata: 10/14
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11200] @2021/6/5 14:46:32
    Missing cnlData[1206] @2021/6/5 14:46:32
    Missing cnlData[1219] @2021/6/5 14:46:32
    Missing cnlData[1215] @2021/6/5 14:46:32
    Missing cnlData[11300] @2021/6/5 14:46:32
    CurQ.SrezCnt=10
    2021-06-05 14:46:33 MkInsCmd empty cnldata: 10/18
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:33
    Missing cnlData[1220] @2021/6/5 14:46:33
    Missing cnlData[1420] @2021/6/5 14:46:33
    Missing cnlData[703] @2021/6/5 14:46:33
    Missing cnlData[1403] @2021/6/5 14:46:34
    CurQ.SrezCnt=10
    2021-06-05 14:46:34 MkInsCmd empty cnldata: 10/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1207] @2021/6/5 14:46:34
    Missing cnlData[1219] @2021/6/5 14:46:34
    Missing cnlData[1224] @2021/6/5 14:46:34
    Missing cnlData[703] @2021/6/5 14:46:35
    CurQ.SrezCnt=12
    2021-06-05 14:46:35 MkInsCmd empty cnldata: 12/38
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:46:35
    Missing cnlData[11200] @2021/6/5 14:46:35
    Missing cnlData[703] @2021/6/5 14:46:35
    Missing cnlData[11300] @2021/6/5 14:46:36
    Missing cnlData[1420] @2021/6/5 14:46:36
    CurQ.SrezCnt=9
    2021-06-05 14:46:36 MkInsCmd empty cnldata: 9/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1207] @2021/6/5 14:46:36
    Missing cnlData[1219] @2021/6/5 14:46:36
    Missing cnlData[1215] @2021/6/5 14:46:36
    Missing cnlData[1403] @2021/6/5 14:46:36
    CurQ.SrezCnt=5
    2021-06-05 14:46:37 MkInsCmd empty cnldata: 5/12
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:37
    Missing cnlData[703] @2021/6/5 14:46:38
    CurQ.SrezCnt=12
    2021-06-05 14:46:38 MkInsCmd empty cnldata: 12/15
    DEBUG: ExportCurData COMMITed
    Missing cnlData[10101] @2021/6/5 14:46:38
    Missing cnlData[10102] @2021/6/5 14:46:38
    Missing cnlData[1] @2021/6/5 14:46:38
    Missing cnlData[31] @2021/6/5 14:46:38
    Missing cnlData[1220] @2021/6/5 14:46:38
    Missing cnlData[1221] @2021/6/5 14:46:38
    Missing cnlData[1220] @2021/6/5 14:46:38
    Missing cnlData[1203] @2021/6/5 14:46:38
    Missing cnlData[1224] @2021/6/5 14:46:38
    Missing cnlData[1215] @2021/6/5 14:46:38
    Missing cnlData[1216] @2021/6/5 14:46:38
    Missing cnlData[1217] @2021/6/5 14:46:38
    Missing cnlData[11200] @2021/6/5 14:46:38
    Missing cnlData[1420] @2021/6/5 14:46:38
    CurQ.SrezCnt=8
    2021-06-05 14:46:39 MkInsCmd empty cnldata: 8/26
    DEBUG: ExportCurData COMMITed
    Missing cnlData[10201] @2021/6/5 14:46:39
    Missing cnlData[10202] @2021/6/5 14:46:39
    Missing cnlData[2] @2021/6/5 14:46:39
    Missing cnlData[32] @2021/6/5 14:46:39
    Missing cnlData[11300] @2021/6/5 14:46:39
    Missing cnlData[703] @2021/6/5 14:46:39
    Missing cnlData[1403] @2021/6/5 14:46:39
    Missing cnlData[1219] @2021/6/5 14:46:39
    Missing cnlData[1215] @2021/6/5 14:46:39
    Missing cnlData[10301] @2021/6/5 14:46:40
    Missing cnlData[10302] @2021/6/5 14:46:40
    Missing cnlData[3] @2021/6/5 14:46:40
    Missing cnlData[33] @2021/6/5 14:46:40
    Missing cnlData[703] @2021/6/5 14:46:40
    CurQ.SrezCnt=11
    2021-06-05 14:46:40 MkInsCmd empty cnldata: 11/28
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1003] @2021/6/5 14:46:40
    Missing cnlData[2603] @2021/6/5 14:46:40
    Missing cnlData[1220] @2021/6/5 14:46:40
    Missing cnlData[11001] @2021/6/5 14:46:40
    Missing cnlData[11002] @2021/6/5 14:46:40
    Missing cnlData[10] @2021/6/5 14:46:40
    Missing cnlData[40] @2021/6/5 14:46:40
    CurQ.SrezCnt=8
    2021-06-05 14:46:41 MkInsCmd empty cnldata: 8/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1203] @2021/6/5 14:46:41
    Missing cnlData[1215] @2021/6/5 14:46:41
    Missing cnlData[1216] @2021/6/5 14:46:41
    Missing cnlData[1217] @2021/6/5 14:46:41
    Missing cnlData[703] @2021/6/5 14:46:41
    Missing cnlData[1420] @2021/6/5 14:46:41
    Missing cnlData[11200] @2021/6/5 14:46:41
    Missing cnlData[703] @2021/6/5 14:46:42
    CurQ.SrezCnt=9
    2021-06-05 14:46:42 MkInsCmd empty cnldata: 9/20
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:46:42
    Missing cnlData[1220] @2021/6/5 14:46:42
    Missing cnlData[11300] @2021/6/5 14:46:42
    Missing cnlData[703] @2021/6/5 14:46:42
    CurQ.SrezCnt=12
    2021-06-05 14:46:43 MkInsCmd empty cnldata: 12/18
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1207] @2021/6/5 14:46:43
    Missing cnlData[1219] @2021/6/5 14:46:43
    Missing cnlData[1215] @2021/6/5 14:46:43
    Missing cnlData[703] @2021/6/5 14:46:44
    CurQ.SrezCnt=9
    2021-06-05 14:46:44 MkInsCmd empty cnldata: 9/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1420] @2021/6/5 14:46:44
    Missing cnlData[1403] @2021/6/5 14:46:44
    Missing cnlData[703] @2021/6/5 14:46:44
    Missing cnlData[11200] @2021/6/5 14:46:45
    CurQ.SrezCnt=11
    2021-06-05 14:46:45 MkInsCmd empty cnldata: 11/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:46:45
    Missing cnlData[11300] @2021/6/5 14:46:45
    Missing cnlData[703] @2021/6/5 14:46:46
    CurQ.SrezCnt=8
    2021-06-05 14:46:46 MkInsCmd empty cnldata: 8/12
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1215] @2021/6/5 14:46:46
    Missing cnlData[1217] @2021/6/5 14:46:46
    Missing cnlData[703] @2021/6/5 14:46:46
    Missing cnlData[1420] @2021/6/5 14:46:46
    CurQ.SrezCnt=9
    2021-06-05 14:46:47 MkInsCmd empty cnldata: 9/17
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:46:47
    Missing cnlData[1403] @2021/6/5 14:46:47
    Missing cnlData[703] @2021/6/5 14:46:48
    CurQ.SrezCnt=8
    2021-06-05 14:46:48 MkInsCmd empty cnldata: 8/13
    DEBUG: ExportCurData COMMITed
    Missing cnlData[11200] @2021/6/5 14:46:48
    Missing cnlData[1206] @2021/6/5 14:46:48
    Missing cnlData[1219] @2021/6/5 14:46:48
    Missing cnlData[1215] @2021/6/5 14:46:48
    Missing cnlData[703] @2021/6/5 14:46:48
    Missing cnlData[11300] @2021/6/5 14:46:48
    CurQ.SrezCnt=10
    2021-06-05 14:46:49 MkInsCmd empty cnldata: 10/20
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:46:49
    Missing cnlData[1420] @2021/6/5 14:46:49
    CurQ.SrezCnt=8
    2021-06-05 14:46:50 MkInsCmd empty cnldata: 8/12
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:46:50
    Missing cnlData[1219] @2021/6/5 14:46:50
    CurQ.SrezCnt=7
    2021-06-05 14:46:51 MkInsCmd empty cnldata: 7/10
    DEBUG: ExportCurData COMMITed
    Missing cnlData[703] @2021/6/5 14:46:51
    Missing cnlData[11200] @2021/6/5 14:46:51
    CurQ.SrezCnt=9
    2021-06-05 14:46:52 MkInsCmd empty cnldata: 9/13
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:46:52
    Missing cnlData[1420] @2021/6/5 14:46:52
    Missing cnlData[11300] @2021/6/5 14:46:53
    CurQ.SrezCnt=11
    2021-06-05 14:46:53 MkInsCmd empty cnldata: 11/16
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1403] @2021/6/5 14:46:53
    Missing cnlData[703] @2021/6/5 14:46:53
    Missing cnlData[1203] @2021/6/5 14:46:53
    Missing cnlData[1215] @2021/6/5 14:46:53
    Missing cnlData[1216] @2021/6/5 14:46:53
    Missing cnlData[1217] @2021/6/5 14:46:53
    Missing cnlData[10703] @2021/6/5 14:46:53
    Missing cnlData[10700] @2021/6/5 14:46:53
    Missing cnlData[7] @2021/6/5 14:46:53
    Missing cnlData[11401] @2021/6/5 14:46:54
    Missing cnlData[11402] @2021/6/5 14:46:54
    Missing cnlData[11400] @2021/6/5 14:46:54
    Missing cnlData[11403] @2021/6/5 14:46:54
    Missing cnlData[703] @2021/6/5 14:46:54
    CurQ.SrezCnt=11
    2021-06-05 14:46:54 MkInsCmd empty cnldata: 11/31
    DEBUG: ExportCurData COMMITed
    Missing cnlData[1220] @2021/6/5 14:46:54
    Missing cnlData[10603] @2021/6/5 14:46:54
    Missing cnlData[10600] @2021/6/5 14:46:54
    Missing cnlData[6] @2021/6/5 14:46:54
    Missing cnlData[10801] @2021/6/5 14:46:54
    Missing cnlData[10802] @2021/6/5 14:46:54
    Missing cnlData[8] @2021/6/5 14:46:54
    Missing cnlData[38] @2021/6/5 14:46:54
    

    Take channel 1403 e.g.
    In the exported db:
    https://snipboard.io/ngkECp.jpg
    In the WebStation:
    https://snipboard.io/RhLIsi.jpg

    I suspect this has something to do with extensive use of formulas. But I am not sure where to look further for meaningful clues.

    Regards

    #9040
    zzz
    Participant

    Hi Mik,

    A small suggestion, could you add timestamp to the Srez object upon server reception? I think for some reason, the module self-added timestamp and webstation data timestamp does not align very well…

    Uh, I guess I should confirm this before assumption, does OnCurDataProcessed() hook guarantees formula processing completion ?

    Regards

    #9041
    zzz
    Participant

    PS: If I write external client using Scada.Client to connect to server externally, rertive data via TCP and export to database, do you think this will solve the formula-enabled cnldata with empty data problem ?

    Or is this solved in the new export module already ?

    #9043
    zzz
    Participant

    After a bit reading, I get the impression that

    OnCurDataProcessed() is event based, and provides both plain and calculated data. (Judging from the current issue, it seems that) based on the loop and event timing, the calculated data may be incomplete.

    OnCurDataCalculated() is loop based (and paced).
    it provide calculated data only (but one has to know the way to tell if the calculated data is averaged, per min, per hour, or original data, not clear how to do it, so I created another question).

    It seems that if I want to get this fixed now in the current module way,
    I need to
    – get all calcualted channel number
    – subscribe to both OnCurDataProcessed() and OnCurDataCalculated event,
    – skip calcuated data in OnCurDataProcessed()
    – figure out how to tell hour/minute data from current data ?

    Do you think the above changes will solve the missing data problem for formula-enabled channels for this module?

    Regards,

    #9044
    zzz
    Participant

    I have updated the code to subcribe to both OnCurDataProcessed() and OnCurDataCalculated(), I didn’t check all the channels, but for channel 1403, its very weird: there is no change. The WebStation data looks perfect as usual, and the db data remain scarce.

    I also tried replacing OnCurDataProcessed() with OnCurDataCalculated().
    Only difference is empty cnldata count in log now is constantly 0.
    The issue remains, 1403 channel has perfect graph in webstation, but export data remains little, only has commited data when it appraches 0, and goes back up after sometime.

    I suspected I made any mistake in the commit process esp. the ON CONFLICT DO NOTHING in sql looks dubous. Thus I hardcoded checks for channel 1403 in EnqueueCurData() function, there is no 1403 shown in log at all.

    1403 is a calculation enabled channel, like 1407, but 1407’s data in db looks very OK. I am running out of ideas to try or invesigate. 🙁

    • This reply was modified 11 months, 3 weeks ago by zzz.
    #9047
    Mikhail
    Moderator

    Hello,

    To find the cause of the issue in the modified module, debugging is needed. This is not included in free support. You should debug the modified module by yourself or wait for a release of the new module version.

    #9053
    zzz
    Participant

    Hi Mik,

    I am just looking for cludes or direction for further debugging the issue. The investigation, coding, debuging are all done on my own, and the discussion is on public domain. I don’t see why it has to be charged.

    Plus the modautocontrol I already paid did not work as expected. It has problem (now I realized of the same pattern), certain channels in triggered doesn’t work, or not triggered sometimes, while other channels works perfectly. We overcame the problem by removing channels from modautocontrol and resolving the logics only in formular, leaving modautocontrol blindingly forwarding resulting data to output channel.

    I think both module are experincing problem of the same nature. Even if I write my own module, or using your new moddbexport module, it’s dubiou this problem can be solved.

    #9056
    Mikhail
    Moderator

    Hi,

    Plus the modautocontrol I already paid did not work as expected

    If you create a new topic and provide an example that reproduces the issue, I will check it and fix if there is a error in the source code.

Viewing 12 posts - 1 through 12 (of 12 total)
  • You must be logged in to reply to this topic.