Topic: DbImport module missing channel data

Tagged: cnldata, DBEXPORT, module, OnCurDataCalculated, OnCurDataProcessed

This topic has 11 replies, 2 voices, and was last updated 2 years, 10 months ago by Mikhail.

Viewing 12 posts - 1 through 12 (of 12 total)

Author

Posts

June 3, 2021 at 7:55 am #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?

June 3, 2021 at 2:14 pm #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.

June 4, 2021 at 12:25 am #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

June 4, 2021 at 1:56 pm #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.

June 5, 2021 at 7:20 am #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

June 5, 2021 at 7:52 am #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

June 5, 2021 at 8:14 am #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 ?

June 5, 2021 at 9:09 am #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,

June 5, 2021 at 10:24 am #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 2 years, 10 months ago by zzz.

June 7, 2021 at 9:14 am #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.

June 8, 2021 at 3:33 am #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.

June 8, 2021 at 1:01 pm #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.

Author

Posts

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic.

Rapid SCADA Forum

Technical support of Rapid SCADA users

DbImport module missing channel data