slow saving of records
Aldevinas Katkus
4-19-17
Our client has on premises CN and sometimes complains about slow saving of Orders and Invoice records. Here is an excerpt from the timings.log. Am I right that saving an order took 60 seconds?
JDI    mpInsertPost    ORVc    24128    2017-04-05 09:16    60785    60785    60870
JDI    mpInsertPost    ORVc    23383    2017-04-05 08:50    59403    59403    59491
RT    mpUpdatePost2    IVVc    2480    2017-03-31 10:58    54909    54909    54990
JDI    mpUpdatePost2    IVVc    7915    2017-04-03 10:49    53758    53758    53764
SJ    mpUpdatePost2    IVVc    20843    2017-04-10 13:26    52607    52607    52698
TG    mpUpdatePost2    IVVc    21528    2017-04-10 14:07    48593    48593    48621
SJ    mpUpdatePost2    IVVc    21247    2017-04-10 13:40    46464    46464    46497
RT    mpUpdatePost2    IVVc    8030    2017-04-03 10:52    45057    45057    45125
..
JDI    mpInsertPost    ORVc    24128    2017-04-05 09:16    60785    60785    60870
JDI    mpInsertPost    ORVc    23383    2017-04-05 08:50    59403    59403    59491
RT    mpUpdatePost2    IVVc    2480    2017-03-31 10:58    54909    54909    54990
JDI    mpUpdatePost2    IVVc    7915    2017-04-03 10:49    53758    53758    53764
SJ    mpUpdatePost2    IVVc    20843    2017-04-10 13:26    52607    52607    52698
TG    mpUpdatePost2    IVVc    21528    2017-04-10 14:07    48593    48593    48621
SJ    mpUpdatePost2    IVVc    21247    2017-04-10 13:40    46464    46464    46497
RT    mpUpdatePost2    IVVc    8030    2017-04-03 10:52    45057    45057    45125
Aldevinas Katkus
4-19-17
for some other clients we have noticed that the speed improves after getting an enabler key, even though there was no "restricted" mode caption in the Navigation window.
Nadezda Kuzmich
4-19-17
Created byAldevinas Katkus08:10 19 Apr 2017
for some other clients we have noticed that the speed improves after getting an enabler key, even though there was no "restricted" mode caption in the Navigation window.
From programming point of view, time, spent on save or on update, depends on the number of items on the order or invoice matrix.
As for every row you have to run record check , to update support registers, to create invoice transaction and etc.
Do they usually have many items in one record ? Do they have some customization with order/invoice record actions ?
Aldevinas Katkus
4-20-17
No they don't usually have many items on the invoice, but the fact is that at least 2 customers solved this problem by getting an enabler key (even though they could print invoices and had no complaints about the key).
Aldevinas Katkus
4-21-17
today's log:

AB    mpRemoteCall    RECORDACTION_RAPASTEORDININV    14848    2017-04-21 09:29:54    10656    10656    10697

Is it normal that paste an order into the invoice takes ten seconds?
Aldevinas Katkus
4-21-17
On the same server (Windows Server 2003 SP2, 3GB RAM Xeon E5520 CPU) I can see
2017-04-21 12:50:30 VM Filtering records on the main thread!


even though threads are set to 4 in the optional features. Is thi related to the slow saving of records?
Aldevinas Katkus
4-21-17
more interesting lines from the log:
2017-04-21 13:51:11 RS/THREAD(16) 1 running reports, duration for InvValRn was 4.17 seconds, of which 0.00 was used in 0 steps
2017-04-21 13:51:26 RS/THREAD(16) Ataskaita Prekių likučiai
2017-04-21 13:51:26 RS/THREAD(16) 1 running reports, duration for InvValRn was 0.00 seconds, of which 0.00 was used in 0 steps
2017-04-21 14:30:31 /THREAD(19) Web file not found: http:/clientapi.ipip.net/echo.php <<<<<< what is this???
2017-04-21 14:30:48 /THREAD(18) web function blocked: WebMain.hal
Aldevinas Katkus
4-21-17
Created byAldevinas Katkus12:06 21 Apr 2017
more interesting lines from the log: 2017-04-21 13:51:11 RS/THREAD(16) 1 running reports, duration for InvValRn was 4.17 seconds, of which 0.00 was used in 0 steps 2017-04-21 13:51:26 RS/THREAD(16) Ataskaita Prekių likučiai 2017-04-21 13:51:26 RS/THREAD
2017-04-12 09:17:28 /THREAD(19) Web file not found: 203.188.197.111:25
...
2017-04-14 02:20:46 /THREAD(19) Web file not found: http:/httpheader.net/
2017-04-14 08:19:02 /THREAD(18) Web file not found: http:/www.17track.net/restapi/handlertest.ashx
Paul Timms
4-25-17
Some nasty computer can see that there's a web port open and is trying to install PHP or other scripts. Do this customer have a webshop? If not, try changing the web port. Or even block it on the firewall for the moment, although be aware that client autoupdates from outside the LAN require it.
Aldevinas Katkus
4-27-17
Yes, I have figured out that too.
Aldevinas Katkus
5-8-17
on the same server:
"MatRowGet with rowno < 0" should not happen?

2017-05-07 23:00:20 /THREAD(14) Duration in seconds: 17
2017-05-08 00:00:54 Iškviesta internetinių raktų funkcija: TheFindIntEnablerAddress
2017-05-08 00:00:55 TheFindIntEnablerAddress = 0
2017-05-08 09:02:49 Įeinanti jungtis 192.168.0.36:55573
2017-05-08 09:02:51 Prisijungimas nutrūko 192.168.0.36:55573: TG
2017-05-08 09:02:52 TG Prisijungti @192.168.0.36

2017-05-08 09:02:52 TG Prisijungti Slot: 4242821 Session: -2
2017-05-08 09:04:32 TG CompareMatrix (vc name on next line) sizes differs arsz: 632, h1: 632, h2: 632
2017-05-08 09:06:07 TG MatRowGet with rowno < 0
2017-05-08 09:06:24 TG Atsijungti @192.168.0.36
2017-05-08 09:06:24 TG Atsijungti Do_LogOffUser Slot: 4242821 Session: -2
2017-05-08 09:06:26 TG Atsijungti
2017-05-08 09:06:26 TG Atsijungti LogoutSlot Slot: 4242821
2017-05-08 09:06:26 SYSTEM Atsijungti 192.168.0.36:55573: the client closed the connection (2)
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Reino Botha
Please check your version of android if it is the same as the server you are connecting too. ...
08:24 21 Nov 2024
Bror-Erik Kotiranta
In NC you hace operations&gt;&gt;ai chats. They are used for these Br, Bror-Erik...
05:12 21 Nov 2024