Re: .tmp files created by 4D Server
in general: there is an internal upper limit to how much "temporary" cache a memory an intensive operation such as sort can use, because awarding unlimited access could cost other operation such as queries or transactions. the limit can be configured with database parameter #61 (Maximum temporary memory size). when a limit is set, temporary swap files are created (extension .tmp) then erased when the operation is over. the temporary folder next to the structure is normally empty, but the fact that the folder exists is an indication that at some point some cache objects were temporarily swapped out. in any case, I don't think the content of the files can tell which 4D process created it. if you must, I suppose you could use standard diagnostic tools such as... http://doc.4d.com/4Dv15/4D/15.5/Get-database-measures.301-3577108.en.html http://doc.4d.com/4Dv16R5/4D/16-R5/Appendix-E-Description-of-log-files.300-3509179.en.html https://taow.4d.com/Process-Supports/PSList.en.html > 2018/02/28 17:48、Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> のメール: > Hi everyone, > We have a 4D Server v15 application running which has recently started > leaving 2 or 3 .tmp files in the Temporary files folder. Is there any way to > read these files and determine which process created them? > Thanks in advance, ** 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: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen
Ditto! R.I.P Ortwin Adriano Cisternino ** 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: Possible to view Users & Groups?
Hi Bob, Have you had a look at http://doc.4d.com/4Dv15/4D/15.5/GET-USER-LIST.301-3576686.en.html and http://doc.4d.com/4Dv15/4D/15.5/GET-GROUP-LIST.301-3576687.en.html? On Wed, Feb 28, 2018 at 6:29 AM, Bob Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Everyone, > > I've been digging on this: is it possible to view/maintain Users & Groups > from the 4D Server console? > > I've not used the 4D Password system until recently, when I started using > CHANGE CURRENT USER so that I could get the user name from a trigger > method. Now I'm interested to inspect what users have been added to the > system, but I don't know how, as they've all been programmatically added. > > Maybe I have to write a bit of code to inspect the list of users? I > thought this might be exposed somewhere... > > > Bob Miller, IT Manager > Chomerics, a division of Parker Hannifin Corporation · phone 781-939-4726 > · mobile 781-316-4864 > > > ll > "PLEASE NOTE: The preceding information may be confidential or privileged. > It only should be used or disseminated for the purpose of conducting > business with Parker. If you are not an intended recipient, please notify > the sender by replying to this message and then delete the information from > your system. Thank you for your cooperation." > ** > 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 > ** -- Kirk Brooks San Francisco, CA === *We go vote - they go home* ** 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 **
Setting "Map NULL values to blank values" with SQL command
I’ve got some SQL code that I am running to create new fields in tables. Basic "ALTER TABLE tablename ADD fieldname VARCHAR” command. It is working just fine. But I would like to also set the "Map NULL values to blank values” checkbox property. Can you do this programmatically? I can’t find anything in the documentation. Tim * Tim Nevels Innovative Solutions 785-749-3444 timnev...@mac.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 15R5 Feedback
Yes we are using tools like loader.io to test the SOAP calls. Will post results soon. On Wed, 28 Feb 2018 at 3:20 pm, Justin Carr via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Sujit > > I never dug that deeply into it. Customers who are handling "significant" > numbers of SOAP requests are crashing intermittently but typically at least > once every few days. "Significant" is probably in the order of 80+ per > minute. It was super easy to create a reproducible test database so I > didn't do more detailed diagnostics. The test case is submitting (on my > system) in the order of 700 requests per minute, and it would typically > crash after 15-20 minutes or so. > > J > > On 28 Feb 2018, at 12:54 pm, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Justin, > > > > Was it the volume of SOAP calls or the frequency that caused the crashes? > > > > We are clocking around 400 per minute at peak times. > > > > > > > > On Wed, Feb 28, 2018 at 9:39 AM, Justin Carr via 4D_Tech < > > 4d_tech@lists.4d.com> wrote: > > > >> That one was raised by me but in our case, it is only happening on > 32-bit > >> Mac server. > >> > >> But it's very easy to test. Just create a server application that has > >> nothing at all except for exposing a single web service. That web > service > >> does nothing other than return a value of 0. Then from another > application > >> fire continual requests at that server. > >> > >> In my case the server would crash anywhere after 10,000 requests. After > >> using a version containing the fix, on macOS 10.12 the server responded > to > >> around 3,000,000 requests before I stopped it. On macOS 10.11 it still > >> crashed but not until sometime after 500,000 requests. > >> > >> J > >> > >> On 28 Feb 2018, at 8:29 am, Keisuke Miyako via 4D_Tech < > >> 4d_tech@lists.4d.com> wrote: > >>> > >>> that would be: ACI0097539 > >>> > >>> > >>> https://bugs.4d.fr/fixedbugslist?branch=16_R6 > >>> https://bugs.4d.fr/fixedbugslist?branch=16 > >>> > 2018/02/28 3:07、Stephen J. Orth via 4D_Tech <4d_tech@lists.4d.com> > >> のメール: > I recall reading (recently) a fix in V16.3 specifically dealing with a > >> server crash problem due to many SOAP calls. > >>> > >>> > >>> > >>> ** > >>> 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 > >> ** > >> > > > > > > > > -- > > > > xxx > > "There must be ingenuity as well as intention, strategy as well as > > strength. " > > ** > > 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 > ** -- xxx "There must be ingenuity as well as intention, strategy as well as strength. " ** 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: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen
This is sad news, and I'm shocked indeed. I have not met Ortwin, but I've read many, many of his posts on the Forums and he is on the "Must Read" list when he posts to the iNug, as others have said as well. Certainly he contributed a great deal to 4D and to this community. He will be missed very much. For me personally he's reached out to help me several times when I posted something or another that had me stumped. He didn't have to do that, he didn't know me, but it says a lot about a person who helps others he hasn't met and when it is highly probable the favor can't be reciprocated (he's a lot smarter than me!). The untimeliness is shocking and I'm sure his family is reeling. I wish them peace and help in their recovery from the shock. Maybe if someone who knows his family can collect these posts and get them to the family it would help some? Peace, Ortwin...we will drink to you, your work, and what you've stood for at the Summit! Bob Miller Chomerics, a division of Parker Hannifin Corporation ll "PLEASE NOTE: The preceding information may be confidential or privileged. It only should be used or disseminated for the purpose of conducting business with Parker. If you are not an intended recipient, please notify the sender by replying to this message and then delete the information from your system. Thank you for your cooperation." ** 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: Possible to view Users & Groups?
Hi Everyone, I've been digging on this: is it possible to view/maintain Users & Groups from the 4D Server console? I've not used the 4D Password system until recently, when I started using CHANGE CURRENT USER so that I could get the user name from a trigger method. Now I'm interested to inspect what users have been added to the system, but I don't know how, as they've all been programmatically added. Maybe I have to write a bit of code to inspect the list of users? I thought this might be exposed somewhere... Bob Miller, IT Manager Chomerics, a division of Parker Hannifin Corporation · phone 781-939-4726 · mobile 781-316-4864 ll "PLEASE NOTE: The preceding information may be confidential or privileged. It only should be used or disseminated for the purpose of conducting business with Parker. If you are not an intended recipient, please notify the sender by replying to this message and then delete the information from your system. Thank you for your cooperation." ** 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: .tmp files created by 4D Server
What are the full names of the files? -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 28, 2018, at 3:48 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > We have a 4D Server v15 application running which has recently started > leaving 2 or 3 .tmp files in the Temporary files folder. Is there any way to > read these files and determine which process created them? ** 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: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen
Very sad to hear. We did buy a few components from him. Always great with UI and a very pragmatic approach. He was very active and always had a very refreshing way to resolve issues. He will be missed greatly God Bless On Tue, 27 Feb 2018 at 9:22 pm, Herr Alexander Heintz via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Fellow 4D developers, > > it is with great sadness, that I have to inform you, that Ortwin Zillgen > has passed away end of last week. > Suddenly, unexpectedly and far to early at the young age of 64. > > Ortwin was known to many of us for his interesting and innovative ideas > for interfaces, anything to do with cartography and mastery of subforms, > his garish striped shirts and baggy yellow jacket, but most of all, as an > all-around great guy to hang out with and talk of 4d, art, and anything > that comes to mind. > I have known him for many years and never saw him without that wide > friendly grin on his face, I will miss it. > > 4d tech support all over the world will painfully feel his absence and an > urgent need to stock up on staff. > > He will be missed dearly and we wish him godspeed whichever tricky subform > he may be heading to. > > All the best to y’all and stay safe > > Alex Heintz > > PS: I will pass on any condolences from the nug to his family > ** > 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 > ** -- xxx "There must be ingenuity as well as intention, strategy as well as strength. " ** 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 15R5 Feedback
From what I gather the general consensus is that R15 Did not have a reported issue with SOAP calls other than ours. And what worked in R2 should work in R5 as well. Randy working with R5 does not have SOAP issues. R16 had a problem with intensive SOAP calls but these were fixed in the current nightly builds. Thanks for the input. On Wed, 28 Feb 2018 at 3:20 pm, Justin Carr via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Sujit > > I never dug that deeply into it. Customers who are handling "significant" > numbers of SOAP requests are crashing intermittently but typically at least > once every few days. "Significant" is probably in the order of 80+ per > minute. It was super easy to create a reproducible test database so I > didn't do more detailed diagnostics. The test case is submitting (on my > system) in the order of 700 requests per minute, and it would typically > crash after 15-20 minutes or so. > > J > > On 28 Feb 2018, at 12:54 pm, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Justin, > > > > Was it the volume of SOAP calls or the frequency that caused the crashes? > > > > We are clocking around 400 per minute at peak times. > > > > > > > > On Wed, Feb 28, 2018 at 9:39 AM, Justin Carr via 4D_Tech < > > 4d_tech@lists.4d.com> wrote: > > > >> That one was raised by me but in our case, it is only happening on > 32-bit > >> Mac server. > >> > >> But it's very easy to test. Just create a server application that has > >> nothing at all except for exposing a single web service. That web > service > >> does nothing other than return a value of 0. Then from another > application > >> fire continual requests at that server. > >> > >> In my case the server would crash anywhere after 10,000 requests. After > >> using a version containing the fix, on macOS 10.12 the server responded > to > >> around 3,000,000 requests before I stopped it. On macOS 10.11 it still > >> crashed but not until sometime after 500,000 requests. > >> > >> J > >> > >> On 28 Feb 2018, at 8:29 am, Keisuke Miyako via 4D_Tech < > >> 4d_tech@lists.4d.com> wrote: > >>> > >>> that would be: ACI0097539 > >>> > >>> > >>> https://bugs.4d.fr/fixedbugslist?branch=16_R6 > >>> https://bugs.4d.fr/fixedbugslist?branch=16 > >>> > 2018/02/28 3:07、Stephen J. Orth via 4D_Tech <4d_tech@lists.4d.com> > >> のメール: > I recall reading (recently) a fix in V16.3 specifically dealing with a > >> server crash problem due to many SOAP calls. > >>> > >>> > >>> > >>> ** > >>> 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 > >> ** > >> > > > > > > > > -- > > > > xxx > > "There must be ingenuity as well as intention, strategy as well as > > strength. " > > ** > > 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 > ** -- xxx "There must be ingenuity as well as intention, strategy as well as strength. " ** 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: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen
Hi Alexander Thank you for passing on this news and I’d like to add my condolences and deeply felt sadness at the departure of such a creative and appreciated contributor to the 4D community. I had occasion to liaise with Ortwin on a couple of projects and his input was always spirited, engaging and of course highly professional. He’s also left a huge legacy of techniques and tools, most of which he made freely available to the community on his website. I’m truly sorry to hear of this and wish his family and close friends every comfort at what appears to be a very unexpected loss. Regards Peter Jakobsson > On 27 Feb 2018, at 12:22, Herr Alexander Heintz via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Fellow 4D developers, > > it is with great sadness, that I have to inform you, that Ortwin Zillgen has > passed away end of last week. > Suddenly, unexpectedly and far to early at the young age of 64. ** 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 **
.tmp files created by 4D Server
Hi everyone, We have a 4D Server v15 application running which has recently started leaving 2 or 3 .tmp files in the Temporary files folder. Is there any way to read these files and determine which process created them? Thanks in advance, Paul ** 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 **