RE: Web Server Freeze

[JBellos via 4D_Tech]

Steve - are you sending the SOAP requests to the HTTPS port on the web
server, or HTTP? We saw 4D server freezing on the SENDING server recently
when we were sending our SOAP requests over https. We're still in a
monitoring phase to ensure the problem is gone, but so far so good.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Clients cannot see v16 R6 on windows server

[John Baughman via 4D_Tech]

Maybe I was not clear about the problem. 

In R5 the clients can connect to the servers. The server with 19813 shows in 
Available as expected, and connections with custom IPs to either sever work 
just fine.
In R6 the clients cannot connect to the servers at all, nothing is in the 
available tab and custom IPs do not work.

> On Apr 12, 2018, at 3:32 PM, John Baughman  wrote:
> 
> I am not a very smart network guy, but if the R5 clients can connect to to 
> the R5 server:19815, wouldn’t the UDP port be open? Otherwise would not R5 
> have the same problem that R6 is having. What am I not understanding here.
> 
> John
> 
>> On Apr 12, 2018, at 3:12 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com 
>> > wrote:
>> 
>> John,
>> 
>> Have you opened the UDP ports for 19815?
>> 
>> Randy Engle, Director
>> XC2 Software LLC – XC2LIVE!
>> 
>> 
>> I am trying to update a client running windows 2008 Server R2 Enterprise 
>> Service Pack 1 to R6. 
>> 
>> R5 works just fine, but in R6 clients cannot see the server. they are 
>> connecting using custom addresses as there are 2 servers listening on 
>> different ports, 19815 and 19813. In R5 19813 showa up in available and they 
>> can connect to both using custom IP:port.
>> 
>> I have put them back to R5 until I can figure this out. Any ideas?
>> 
>> John
>> 
>> 
>> John Baughman
>> Kailua, Hawaii
>> (808) 262-0328
>> john...@hawaii.rr.com 
>> 
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.com 
> 
> 
> 
> 
> 

John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.com





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Clients cannot see v16 R6 on windows server

[John Baughman via 4D_Tech]

I am not a very smart network guy, but if the R5 clients can connect to to the 
R5 server:19815, wouldn’t the UDP port be open? Otherwise would not R5 have the 
same problem that R6 is having. What am I not understanding here.

John

> On Apr 12, 2018, at 3:12 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> John,
> 
> Have you opened the UDP ports for 19815?
> 
> Randy Engle, Director
> XC2 Software LLC – XC2LIVE!
> 
> 
> I am trying to update a client running windows 2008 Server R2 Enterprise 
> Service Pack 1 to R6. 
> 
> R5 works just fine, but in R6 clients cannot see the server. they are 
> connecting using custom addresses as there are 2 servers listening on 
> different ports, 19815 and 19813. In R5 19813 showa up in available and they 
> can connect to both using custom IP:port.
> 
> I have put them back to R5 until I can figure this out. Any ideas?
> 
> John
> 
> 
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.com
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.com





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Clients cannot see v16 R6 on windows server

[John Baughman via 4D_Tech]

I am trying to update a client running windows 2008 Server R2 Enterprise 
Service Pack 1 to R6. 

R5 works just fine, but in R6 clients cannot see the server. they are 
connecting using custom addresses as there are 2 servers listening on different 
ports, 19815 and 19813. In R5 19813 showa up in available and they can connect 
to both using custom IP:port.

I have put them back to R5 until I can figure this out. Any ideas?

John


John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.com





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: ORDA on switch?

[Keith Culotta via 4D_Tech]

The table must have a primary key field to be seen.  The old table was created 
before primary keys were used.

Keith - CDI

> On Apr 12, 2018, at 10:33 AM, Keith Culotta  wrote:
> 
> C_OBJECT($entAll)
> $entAll:=ds.Table_1.all()
> 
> The code works in a new structure.  
> It fails in a converted structure with the error "Unknown Member Function".
> 
> Compatibility: "Use object notation..." is checked.
> "Expose with 4D Mobile Service" is checked for the Table and Fields.
> The database was restarted after the settings changes.
> The compiler has no problem with the code.
> 
> Is there another compatibility switch somewhere to set?
> 
> Thanks - Keith - CDI

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Server Freeze

[Stephen J. Orth via 4D_Tech]

Tim,

Sorry, was in a conference call...Thanks!

Steve

*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*


-Original Message-
From: Timothy Penner [mailto:tpen...@4d.com] 
Sent: Thursday, April 12, 2018 2:45 PM
To: s.o...@the-aquila-group.com; '4D iNug Technical' <4d_tech@lists.4d.com>
Subject: RE: Web Server Freeze

Hi Steve,

> Let me know if you need more details as this particular customer is not happy.

I would like to work with you on this issue but I don't want to bombard 
everyone's mailbox; so I will open a case for you on TAOW and work with you 
there.

-Tim



Timothy Penner
Senior Technical Services Engineer

4D Inc
95 S. Market Street, Suite #240
San Jose,CA 95113
United States

Telephone: +1-408-557-4600
Fax:   +1-408-271-5080
Email: tpen...@4d.com
Web:   www.4D.com


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Server Freeze

[Timothy Penner via 4D_Tech]

Hi Steve,

> Let me know if you need more details as this particular customer is not happy.

I would like to work with you on this issue but I don't want to bombard 
everyone's mailbox; so I will open a case for you on TAOW and work with you 
there.

-Tim



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Server Freeze

[Stephen J. Orth via 4D_Tech]

Tim,

Sorry, forgot to respond to one of your statements...

Both applications, DMM Server and the middleware are both running as a service.


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*


-Original Message-
From: Timothy Penner [mailto:tpen...@4d.com] 
Sent: Thursday, April 12, 2018 2:17 PM
To: s.o...@the-aquila-group.com; 4D iNug Technical <4d_tech@lists.4d.com>
Subject: RE: Web Server Freeze

Hi Steve,

> Also, the two applications reside on the same box, meaning the DMM Server and 
> the "middleware" application (running as a service) are on the same box.

If they are on the same box, are using a local loopback address like 127.0.0.1 
or localhost, or are you using a real ip address or dns name?

If you are not already using a local loopback address like 127.0.0.1 then I 
would suggest trying that because, technically, this situation is what it is 
designed for.

The two apps being on the same machine make wireshark seem less important, but 
you could still perform the packet capture and limit the interface to the local 
loopback, and even further limit wireshark to only capture packets destined for 
port 80 (or whatever port you are using). This should reduce the amount of data 
that is logged.

Also, if one of the apps is running as a service, make sure it is running as a 
named user account and not as the LocalSystem account; the LocalSystem account 
doesn't have full access to the network and our documentation specifically 
suggests using a named user: http://kb.4d.com/assetid=77847

-Tim




Timothy Penner
Senior Technical Services Engineer

4D Inc
95 S. Market Street, Suite #240
San Jose,CA 95113
United States

Telephone: +1-408-557-4600
Fax:   +1-408-271-5080
Email: tpen...@4d.com
Web:   www.4D.com


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Server Freeze

[Stephen J. Orth via 4D_Tech]

Tim,

Yes, we are using the local looback address.  Here are some samples from the 
log file being generated by the middleware service:


Example #1:

[08:31:03.05] Sending DMM WS Call: TTX-BRP;AUTO_BOOTH_2_OUTGOING;526
[08:31:03.07] Received WS Response: Success: Carrier=526;
[08:31:22.19] Sending DMM WS Call: TTX-BRP;AUTO_BOOTH_OUTGOING;391
[08:31:22.21] Received WS Response: Success: Carrier=391;
[08:31:51.96] Sending DMM WS Call: TTX-BRP;AUTO_BOOTH_2_INCOMING;391
[08:31:53.04] Received WS Response: Success: Carrier=391;
[08:32:08.93] Sending DMM WS Call: TTX-BRP;VACUUM_MASK;603
[08:32:09.62] Error sending WS call, Attempt resend in 600 ms: The underlying 
connection was closed: The connection was closed unexpectedly.
[08:32:43.12] Sending DMM WS Call: TTX-BRP;AUTO_BOOTH_OUTGOING;709
[08:32:43.18] Received WS Response: Success: Carrier=709;



Example #2:

[20:17:39.00] Sending DMM WS Call: TTX-BRP;AUTO_BOOTH_2_INCOMING;667
[20:17:40.10] Received WS Response: Success: Carrier=667;
[20:18:13.33] Sending DMM WS Call: TTX-BRP;AUTO_BOOTH_INCOMING;525
[20:18:14.39] Received WS Response: Success: Carrier=525;
[20:18:30.17] Sending DMM WS Call: TTX-BRP;AUTO_BOOTH_OUTGOING;204
[20:18:30.80] Error sending WS call, Attempt resend in 600 ms: An error 
occurred while receiving the HTTP response to http://127.0.0.1/4DSOAP/. This 
could be due to the service endpoint binding not using the HTTP protocol. This 
could also be due to an HTTP request context being aborted by the server 
(possibly due to the service shutting down). See server logs for more details.
[20:18:30.80] Sending DMM WS Call: TTX-BRP;AUTO_BOOTH_2_OUTGOING;857
[20:18:30.81] Received WS Response: Success: Carrier=857;
[20:18:49.03] Sending DMM WS Call: TTX-BRP;LOAD_AREA;867
[20:18:50.13] Received WS Response: Success: Carrier=867;


The log files are scattered full of these two types of entries, where the 
middleware service is trying to talk to our Server.  We also have the web 
server log file active, but don't see anything funky in those.

Just look at the timing between good calls and errors, as how does it just 
randomly have good "receipts", followed by a bad "receipt" and then immediately 
followed by more good "receipts"?

Let me know if you need more details as this particular customer is not happy.


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*

-Original Message-
From: Timothy Penner [mailto:tpen...@4d.com] 
Sent: Thursday, April 12, 2018 2:17 PM
To: s.o...@the-aquila-group.com; 4D iNug Technical <4d_tech@lists.4d.com>
Subject: RE: Web Server Freeze

Hi Steve,

> Also, the two applications reside on the same box, meaning the DMM Server and 
> the "middleware" application (running as a service) are on the same box.

If they are on the same box, are using a local loopback address like 127.0.0.1 
or localhost, or are you using a real ip address or dns name?

If you are not already using a local loopback address like 127.0.0.1 then I 
would suggest trying that because, technically, this situation is what it is 
designed for.

The two apps being on the same machine make wireshark seem less important, but 
you could still perform the packet capture and limit the interface to the local 
loopback, and even further limit wireshark to only capture packets destined for 
port 80 (or whatever port you are using). This should reduce the amount of data 
that is logged.

Also, if one of the apps is running as a service, make sure it is running as a 
named user account and not as the LocalSystem account; the LocalSystem account 
doesn't have full access to the network and our documentation specifically 
suggests using a named user: http://kb.4d.com/assetid=77847

-Tim




Timothy Penner
Senior Technical Services Engineer

4D Inc
95 S. Market Street, Suite #240
San Jose,CA 95113
United States

Telephone: +1-408-557-4600
Fax:   +1-408-271-5080
Email: tpen...@4d.com
Web:   www.4D.com


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Server Freeze

[Timothy Penner via 4D_Tech]

Hi Steve,

> Also, the two applications reside on the same box, meaning the DMM Server and 
> the "middleware" application (running as a service) are on the same box.

If they are on the same box, are using a local loopback address like 127.0.0.1 
or localhost, or are you using a real ip address or dns name?

If you are not already using a local loopback address like 127.0.0.1 then I 
would suggest trying that because, technically, this situation is what it is 
designed for.

The two apps being on the same machine make wireshark seem less important, but 
you could still perform the packet capture and limit the interface to the local 
loopback, and even further limit wireshark to only capture packets destined for 
port 80 (or whatever port you are using). This should reduce the amount of data 
that is logged.

Also, if one of the apps is running as a service, make sure it is running as a 
named user account and not as the LocalSystem account; the LocalSystem account 
doesn't have full access to the network and our documentation specifically 
suggests using a named user: http://kb.4d.com/assetid=77847

-Tim




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Server Freeze

[Stephen J. Orth via 4D_Tech]

Tim,

We have already been asking these questions, and they say there is nothing.

We have tried to use Wireshark before, but it collects so much information it 
is overwhelming.  Are there any suggestions on what events to trap on?

Also, the two applications reside on the same box, meaning the DMM Server and 
the "middleware" application (running as a service) are on the same box.

Thanks!


Steve

-Original Message-
From: Timothy Penner [mailto:tpen...@4d.com] 
Sent: Thursday, April 12, 2018 2:05 PM
To: s.o...@the-aquila-group.com; 4D iNug Technical <4d_tech@lists.4d.com>
Subject: RE: Web Server Freeze

Steve,

> For example, we receive a call, then 10 seconds later another call comes in 
> and it's not received, then 10 seconds later another call comes in and it 
> works fine.  The other system that is trying to contact via web services 
> records a log entry saying their request was forcibly terminated, or it 
> received no response.

Is there any chance there is some antivirus or malware protection sitting 
between the client and server (on either end)?

You could potentially do some packet capturing with wireshark to determine if 
the request from the client hits the server's network interface at all.

-Tim



Timothy Penner
Senior Technical Services Engineer

4D Inc
95 S. Market Street, Suite #240
San Jose,CA 95113
United States

Telephone: +1-408-557-4600
Fax:   +1-408-271-5080
Email: tpen...@4d.com
Web:   www.4D.com


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Server Freeze

[Timothy Penner via 4D_Tech]

Steve,

> For example, we receive a call, then 10 seconds later another call comes in 
> and it's not received, then 10 seconds later another call comes in and it 
> works fine.  The other system that is trying to contact via web services 
> records a log entry saying their request was forcibly terminated, or it 
> received no response.

Is there any chance there is some antivirus or malware protection sitting 
between the client and server (on either end)?

You could potentially do some packet capturing with wireshark to determine if 
the request from the client hits the server's network interface at all.

-Tim



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

[ANN] Q2Pix 1.0b1 -- Public Beta

[Danis Georgiadis via 4D_Tech]

We are excited to present Q2Pix 1.0b1, the first public beta release of the 
modern successor to QPix.


About Q2Pix
===

Q2Pix is the first of a new generation of 4D Extensions. We no longer call them 
"plug-ins" because they are more than that. The architecture of these new 
products comprises 4D plug-ins, components, frameworks, open-source libraries; 
they work with the latest 4D versions; they make extensive use of modern 4D 
features such as subforms, objects and JSON.


Key features


- Full 32/64-bit, 4D v16/64 recommended.
- QuickTime-free.
- Exposes an object model.
- Document-based programming interface.
- A rich viewer widget with menubar, toolbar and sidebar written in pure 4D.
- Full support of XMP metadata.
- A generic XMP data editor written in pure 4D.
- Extensive PDF support.
- Extensive acquisition capabilities: TWAIN, ImageCapture, WIA.
- Batteries included: no third-party stuff to install.


Disclaimer
==

The few things which are missing in Q2Pix 1.0b1 will be completed in the next 
beta round. In the meantime, please use the demo database and documentation to 
familiarize yourself with the new programming style and be ready for porting 
your existing projects to Q2Pix.


Download location
=

Please visit  and follow the download link.

—

Hoping you will like Q2Pix as much as we do, we look forward to hearing from 
you.


Kind regards,

- Escape Tech


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Avalera

[Jeffrey Kain via 4D_Tech]

Has anyone done a REST interface with Avalera and 4D?

It looks easy enough but thought I’d ask to see if a component may already 
exist...

Thanks,
Jeff. 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Server Fail When Converting from v15.2 to v16R5

[Jeffrey Kain via 4D_Tech]

> On Apr 12, 2018, at 1:26 PM, roofto...@mac.com wrote:
> 
> I’ll run a test convert after hours on the production server and see if it 
> completes without a problem.  We do reboot our 4D app once per week. 
> (Hold-over habits from past years of less stable 4D products.)  You mentioned 
> this hang behavior sometimes appears when quitting 4D Server.  Have you seen 
> it and does it recover (or how long does it hang)?

10-15 minutes on a server with 192GB of memory. But only sometimes.

On our production server, when it had 256GB of memory and the cache was full, 
it would freeze/hang for about 25 minutes while memory was being released.


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Server Fail When Converting from v15.2 to v16R5

[rooftop99--- via 4D_Tech]

Thanks Jeffrey.  Very helpful.

Our production server has 168 GB of RAM.  Our app uses ~68 and another ~5 is 
consumed by OS overhead etc.  We generally run with ~95 GB of Ram free, so I 
guess we’ll be okay…  

I’ll run a test convert after hours on the production server and see if it 
completes without a problem.  We do reboot our 4D app once per week. (Hold-over 
habits from past years of less stable 4D products.)  You mentioned this hang 
behavior sometimes appears when quitting 4D Server.  Have you seen it and does 
it recover (or how long does it hang)?

I will file a ticket with 4D.

Thanks again!
Kirk

> On Apr 12, 2018, at 9:49 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Kirk,
> 
> According to 4D, the problem is due to the new cache design in v16. We've 
> also seen this on our servers that have a large amount of memory installed. 
> We're working with 4D on a solution to this. The problem, according to 4D, is 
> that the new cache manager allocates a lot of very small blocks of memory, as 
> opposed to always four very large blocks in v15 and earlier. When it comes 
> time to release some of the memory when cache is full, something goes wrong 
> and Windows takes a very long time to release all of these tiny blocks.
> 
> Three solutions: 
> 
> 1. Wait it out. If you open task manager you can watch the amount of memory 
> used by 4D slowly fall.  It will eventually come back to life and continue.
> 
> 2. Add enough memory so that a cache purge is never necessary.
> 
> 3. Allocate a fixed size cache that will handle the entire re-indexing 
> operation even though it will result in page file swapping. If you're on an 
> SSD, the swapping isn't so bad and will allow 4D to complete its indexing.  
> Once this is done, set your cache back to a normal value for your application.
> 
> Note that the same problem will happen in normal use if you fill the cache 
> and 4D needs to purge some objects. This also happens sometimes when you try 
> to quit 4D Server.  4D has recommended that we set the percent of cache purge 
> to a small value in the database parameters, but I haven't tried this yet.  
> We bit the bullet and installed enough memory in our server so that a cache 
> purge will never happen.
> 
> I know 4D is working with Microsoft on this. You might open a tech support 
> case so your voice can be added to ours.
> 
> --
> Jeffrey Kain
> jeffrey.k...@gmail.com
> 
> 
> 
> 
>> On Apr 12, 2018, at 12:30 PM, rooftop99--- via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> The pattern is as follows:
>> -Open v15 database with v16R5 and authorize the conversion.
>> -Various Building Index and progress bar dialogs appear
>> -Task Manager shows very little CPU activity, but the Memory used graph 
>> slowly increases until it pegs at 99% of physical Memory installed on  the 
>> machine.
>> -Eventually the 4D dialogs stop updating and the machine bogs down to near 
>> non-responsive. (I have left is in this state for hours to see if it would 
>> recover, with no luck.)
>> -I have to kill the 4D app and reboot the server.
>> -Once rebooted I can open the app again with v16R5 and it appears to start 
>> where is left off and build the rest of the indexes, etc
>> -Eventually the 4D update process completes and the app appears fine...
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Server Fail When Converting from v15.2 to v16R5

[Jeffrey Kain via 4D_Tech]

Another solution might be to convert to v15R4 first, which will do the required 
reindexing but still use the old cache manager.  Then convert to v16 so it 
won't have to index.


> On Apr 12, 2018, at 12:49 PM, Jeffrey Kain  wrote:
> 
> Kirk,
> 
> According to 4D, the problem is due to the new cache design in v16. We've 
> also seen this on our servers that have a large amount of memory installed. 
> We're working with 4D on a solution to this. The problem, according to 4D, is 
> that the new cache manager allocates a lot of very small blocks of memory, as 
> opposed to always four very large blocks in v15 and earlier. When it comes 
> time to release some of the memory when cache is full, something goes wrong 
> and Windows takes a very long time to release all of these tiny blocks.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Server Fail When Converting from v15.2 to v16R5

[Jeffrey Kain via 4D_Tech]

Kirk,

According to 4D, the problem is due to the new cache design in v16. We've also 
seen this on our servers that have a large amount of memory installed. We're 
working with 4D on a solution to this. The problem, according to 4D, is that 
the new cache manager allocates a lot of very small blocks of memory, as 
opposed to always four very large blocks in v15 and earlier. When it comes time 
to release some of the memory when cache is full, something goes wrong and 
Windows takes a very long time to release all of these tiny blocks.

Three solutions: 

1. Wait it out. If you open task manager you can watch the amount of memory 
used by 4D slowly fall.  It will eventually come back to life and continue.

2. Add enough memory so that a cache purge is never necessary.

3. Allocate a fixed size cache that will handle the entire re-indexing 
operation even though it will result in page file swapping. If you're on an 
SSD, the swapping isn't so bad and will allow 4D to complete its indexing.  
Once this is done, set your cache back to a normal value for your application.

Note that the same problem will happen in normal use if you fill the cache and 
4D needs to purge some objects. This also happens sometimes when you try to 
quit 4D Server.  4D has recommended that we set the percent of cache purge to a 
small value in the database parameters, but I haven't tried this yet.  We bit 
the bullet and installed enough memory in our server so that a cache purge will 
never happen.

I know 4D is working with Microsoft on this. You might open a tech support case 
so your voice can be added to ours.

--
Jeffrey Kain
jeffrey.k...@gmail.com




> On Apr 12, 2018, at 12:30 PM, rooftop99--- via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> The pattern is as follows:
> -Open v15 database with v16R5 and authorize the conversion.
> -Various Building Index and progress bar dialogs appear
> -Task Manager shows very little CPU activity, but the Memory used graph 
> slowly increases until it pegs at 99% of physical Memory installed on  the 
> machine.
> -Eventually the 4D dialogs stop updating and the machine bogs down to near 
> non-responsive. (I have left is in this state for hours to see if it would 
> recover, with no luck.)
> -I have to kill the 4D app and reboot the server.
> -Once rebooted I can open the app again with v16R5 and it appears to start 
> where is left off and build the rest of the indexes, etc
> -Eventually the 4D update process completes and the app appears fine...

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D Server Fail When Converting from v15.2 to v16R5

[rooftop99--- via 4D_Tech]

Hi All,

(OS-Windows Server 2012, 24 GB Ram, or 64GB Ram on second test machine)

We are moving a large (90GB) database from v15.2 to v16R5.  When converting the 
application the server eventually grinds to a halt, becomes non responsive, and 
requires a reboot.  I attempted this on two different machines with the same 
result...

The pattern is as follows:
-Open v15 database with v16R5 and authorize the conversion.
-Various Building Index and progress bar dialogs appear
-Task Manager shows very little CPU activity, but the Memory used graph slowly 
increases until it pegs at 99% of physical Memory installed on  the machine.
-Eventually the 4D dialogs stop updating and the machine bogs down to near 
non-responsive.  (I have left is in this state for hours to see if it would 
recover, with no luck.)
-I have to kill the 4D app and reboot the server.
-Once rebooted I can open the app again with v16R5 and it appears to start 
where is left off and build the rest of the indexes, etc
-Eventually the 4D update process completes and the app appears fine...

Thoughts?  It appears to be a "memory leak” such as the failure on 4D’s part to 
release memory once it completes conversion of a given index. I would like to 
resolve this crash before committing a converted database to our production 
environment.

Thanks for your help!
Kirk 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: v13+ LEP - What is sent to OS

[Epperlein, Lutz (agendo) via 4D_Tech]

AFAIK it is installed per default since Win XP, I'm sure that is installed in 
Win 7 and Win 10 and of course in the matching server versions.

Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip 
> Scheide via
> 4D_Tech
> Sent: Thursday, April 12, 2018 5:07 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: Re: v13+ LEP - What is sent to OS
>
> I will investigate further, but as I understand:
> Robocopy is an EXTERNAL dos command, and as such is not (or may not) be
> installed on some/all Windows systems.
>
> xCopy is part of command.com, and as such exists on all windows systems
> (at least all that would be in use today).
> Chip
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v13 - Custom Constants & 4D Pop

[Chip Scheide via 4D_Tech]

Thanks!
I did find the file,
however, the Finder was not finding the file, I do not know why...

On Thu, 12 Apr 2018 10:01:13 +0200, Koen Van Hooreweghe wrote:
> Hi Chip,
> 
> The User Constants.xlf file is located inside your database package 
> in the Resources folder.
> You can indeed move this file to other databases, just like any other 
> ‘Resources' file. Translation xlf files inside language (.lproj) 
> directories or images.
> 
> HTH
> Koen
> 
>> Op 11 apr. 2018, om 19:19 heeft Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> het volgende geschreven:
>> 
>> 1 - where does 4D pop put the cliff file for custom constants? (Mac)
>> 2 - can I move this file around (i.e. to other database/systems)?
> 
> 
> 
> 
> Compass bvba
> Koen Van Hooreweghe
> Kloosterstraat 65
> 9910 Knesselare
> Belgium
> tel +32 495 511.653
> 
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v13+ LEP - What is sent to OS

[Chip Scheide via 4D_Tech]

I will investigate further, but as I understand:
Robocopy is an EXTERNAL dos command, and as such is not (or may not) be 
installed on some/all Windows systems.

xCopy is part of command.com, and as such exists on all windows systems 
(at least all that would be in use today).
Chip

On Wed, 11 Apr 2018 15:50:39 -0600, Kenneth Geiger via 4D_Tech wrote:
> Have you tried ROBOCOPY instead of XCOPY?
> 
>> On Apr 11, 2018, at 1:38 PM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I think the problem is in escaping the file path.
>> I'm trying to get xCopy to work.
>> 
>> I have tried a variety of variations, none of which want to work.
>> That is why I would like to see what it is that LEP is handing off to 
>> the OS
>> 
>> 
>> On Wed, 11 Apr 2018 19:31:34 +, Timothy Penner wrote:
>>> Hi Chip,
>>> 
>>> I agree with Tim Nevels' approach. It’s very solid.
>>> 
>>> Another thing to add, is that sometimes you may need to call the 
>>> actual cmd.exe and feed your command into that, as described in this 
>>> tech tip:
>>> http://kb.4d.com/assetid=76658
>>> 
>>> On windows that would be like this:
>>> 
>>> $theRestOftheCommand:="cp thisFile here"
>>> $command_t:="cmd.exe /C "+$theRestOftheCommand
>>> LAUNCH EXTERNAL PROCESS($command_t)
>>> 
>>> Regarding this:
 I have done the set text to pasteboard thing, and I have pasted into 
 a .bet file -- it works.
>>> 
>>> Pasting it into a batch (I assume you meant .bat file) is not the 
>>> same as running it in the Command Interpreter; for example, a batch 
>>> file lets you execute multiple lines as a batch, while the Command 
>>> Interpreter (and 4D's LEP) only lets you execute one line at a time.
>>> 
>>> Also, if the .bat file works, then you could always try executing the 
>>> .bat file from 4D using LEP.
>>> 
>>> -Tim
>>> 
>>> 
>>> 
>>> Timothy Penner
>>> Senior Technical Services Engineer
>>> 
>>> 4D Inc
>>> 95 S. Market Street, Suite #240
>>> San Jose,CA 95113
>>> United States
>>> 
>>> Telephone: +1-408-557-4600
>>> Fax:   +1-408-271-5080
>>> Email: tpen...@4d.com 
>>> Web:   www.4D.com 
>>> 
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html 
>> Archive:  http://lists.4d.com/archives.html 
>> 
>> Options: https://lists.4d.com/mailman/options/4d_tech 
>> 
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
>> 
>> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v13 - Custom Constants & 4D Pop [solved!]

[Chip Scheide via 4D_Tech]

Thanks,
I figured out the HTML encoding based on something I entered through 
the 4DPop constants editor.

For Cr, Lf, CrLf, and Tab there appears to be no way to add these 
values through 4DPop constants editor, which is why I was looking for a 
work around, and why I posted this info.

On Wed, 11 Apr 2018 20:45:51 +, Keisuke Miyako via 4D_Tech wrote:
> FYI
> 
> these are standard XML notations
> 
> alternatively you can code hexadecimal i.e.
> 
>  and 
> 
> https://en.m.wikipedia.org/wiki/XML
> 
> technically you can widen the range of valid unicode characters by 
> specifying version=1.1 in declaration.
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Summit 2018 Comments

[Keisuke Miyako via 4D_Tech]

overloading requires the concept of inheritance based on class.
although it was confirmed during the Summit that the feature is under 
development,
I would urge you to spend a moment to check out immediately
collection methods that accept a "callback" project method.

http://doc.4d.com/4Dv17/4D/17/collectionsort.301-3730920.en.html
http://doc.4d.com/4Dv17/4D/17/collectionsome.301-3730945.en.html
http://doc.4d.com/4Dv17/4D/17/collectionorderByMethod.301-3730937.en.html
http://doc.4d.com/4Dv17/4D/17/collectionmap.301-3730943.en.html
http://doc.4d.com/4Dv17/4D/17/collectionevery.301-3730944.en.html
http://doc.4d.com/4Dv17/4D/17/collectionfilter.301-3730926.en.html
http://doc.4d.com/4Dv17/4D/17/collectionfind.301-3730925.en.html
http://doc.4d.com/4Dv17/4D/17/collectionfindIndex.301-3730946.en.html

2018/04/10 15:57、Tom Swenson via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
What would be cool would be to create some form of overloaded operators.



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Appending XML Elements

[Keisuke Miyako via 4D_Tech]

 it depends on what you mean by efficient; fewer 4D code does not necessarily 
mean better performance, it all depends on the internal implementation (xerces).

if you don't know already there is this

> $dom:=DOM Create XML Ref("root")
> $e:=DOM Create XML element($dom;"root/element[10]")  //10 childs
>
> ARRAY TEXT($elements;0)
> $e:=DOM Find XML element($dom;"root/element";$elements)  //10 children

the advantage here is that you make fewer calls to "DOM Create".

you still need to loop over your array in 4D code to set values,
but a loop (For, While, Repeat) in compiled mode is as fast as any "batch" 
command in 4D,
and I don't see its as inefficient at all, you already have the DOM references.

something else, XML does not have the concept of arrays.
you could have many sibling elements that share the same name,
but that would only be a pretence of an array, open to interpretation.

it is expected that there are no standards to convert an arrays or JSON to XML.

> 2018/04/11 23:45、Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> のメール：
> Is there a more efficient way that a large number of sub - elements can be
> added to the root element? At the moment we are using a For Loop.
> (I am looking for something like SELECTION TO JSON or JSON Stringify array
> for XML..)



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Summit 2018 Comments - Import XML Structure

[JPR via 4D_Tech]

[JPR]

Hi All,

In fact, it seems that it has been a little misunderstanding in this case of 
XML Structure. What LR was talking about is the NEW way which has been 
demonstrated by Laurent Esnault during the Summit.

With the new way of handling the 4DB (usually named 'the structure'), it will 
be possible to save everything into text files. Forms will be JSON files, 
Methods will be Text files, and Structure will be XML Files. And you will be 
able to export and reimport any part. And this is what Laurent explained.

I perfectly understand that you are dreaming so hard of it, that you want to 
believe that it is already available! But in fact you will have to wait a 
little bit more, until it will be fully tested and introduced into a R-release.

Sorry about breaking your dreams, but this is the way it works.

And, BTW, I have also to confess that Santa Claus doesn't exist...

My very best,

JPR



> On 11 Apr 2018, at 07:57, 4d_tech-requ...@lists.4d.com wrote:
> 
> I suggest you mention JPR in this message so that JPR will see it and
> perhaps pass your comments along :)
> 
> Pat
> 
> On 10 April 2018 at 22:33, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> On Apr 10, 2018, at 12:40 PM, Randy Engle wrote:
>> 
>>> I tried this from several different angles (16r6)
>>> Import XML Structure works like importing records.
>>> It doesn't "update" or "merge", just imports new structure elements
>> (Tables)
>>> 
>>> Perhaps Laurent was confused at that moment?
>> 
>> You are right Randy.  I did some quick tests and IMPORT STRUCTURE command
>> will not update existing tables. The documentation says "If an imported
>> table has the same name as a local one, an error is generated and the
>> import operation is aborted.” and this is the case.
>> 
>> So Laurent must have been confused and maybe thought, why create fields
>> with SQL when you could create tables and fields with the IMPORT STRUCTURE
>> command. You can do that, but what we want to do is update existing tables
>> and fields and that is currently not possible with this command.
>> 
>> So we are stuck again with the inability to set the “map NULL values to
>> blank” field property when creating fields with SQL.
>> 
>> Tim
>> 
>> Tim Nevels
>> timnev...@mac.com 
>> Innovative Solutions
>> 785-749-3444

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v13 - Custom Constants & 4D Pop

[Koen Van Hooreweghe via 4D_Tech]

Hi Chip,

The User Constants.xlf file is located inside your database package in the 
Resources folder.
You can indeed move this file to other databases, just like any other 
‘Resources' file. Translation xlf files inside language (.lproj) directories or 
images.

HTH
Koen

> Op 11 apr. 2018, om 19:19 heeft Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> 1 - where does 4D pop put the cliff file for custom constants? (Mac)
> 2 - can I move this file around (i.e. to other database/systems)?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: v13+ LEP - What is sent to OS

[Epperlein, Lutz (agendo) via 4D_Tech]

I second this recommendation. Robocopy is far better and more flexible than 
xcopy.
But the problem with escaping of paths remains the same.

Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kenneth 
> Geiger
> via 4D_Tech
> Sent: Wednesday, April 11, 2018 11:51 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Kenneth Geiger 
> Subject: Re: v13+ LEP - What is sent to OS
>
> Have you tried ROBOCOPY instead of XCOPY?
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**