4D Write Pro Table Printing
Hello everyone, I’m using 4D v17.3 with 4D Write Pro. When I create a Write Pro Table and populate it and go to print it, it does not handle page breaks. If the whole table doesn’t fit on the remainder of the page, a page break is automatically done. On the new page, the contents of the table are printed but it only prints as much as it can fit - even printing over the footer. Has anyone cracked the nut on printing out 4D Write Pro tables so that page breaks are done automatically within a table? Much Thanks! David Conley By The Book, Inc. Office: 815-234-7530 http://www.bythebook.com This email was sent to 4d_tech@lists.4D.com (mailto:4d_tech@lists.4D.com) unsubscribe from this list (http://emailclicks.bythebook.com/track/unsub.php?u=30055319=163ac5564c314a08861d97aed10b3849.NlszJIRS%2FTUDQjLGi3RBQPkkK%2Bw%3D=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4D.com) ** 4D Internet Users Group (4D iNUG) 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: Server Process "Frozen"-ish
Tim, FWIW, I’ve implemented a method which issues a resume process command for each of my stored procedures. I invoke it via a new process command using the On Backup Shutdown command. My backups run once per day so it gives me a clean way of resuming those procedures each day after the backup completes. If they aren’t stuck then no big deal. If they are then they get resumed. Once completed the process dies. It was the best solution I could come up with for a work around until the problem is fixed. Thanks! David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > On Oct 25, 2017, at 4:13 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > I’m a big user of Stored Procedure and I don’t need the headache of them > acting up when everything is completely stable now. And it’s a bug I can’t > even implement a work around for, other than to manually monitor all server > every single day and executing RESUME PROCESS commands manually when I detect > an issue. I’ve got work to do. I’m not going to become a server babysitter. > This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com) unsubscribe from this list (http://emailclicks.bythebook.com/track/unsub.php?u=30055319=4e524469ed2e48cc8bc6c3810ba1273b.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4d.com) ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Server Process "Frozen"-ish
Interesting. I did some more digging and here is what I’ve found. I have 13 Macs that run up to 10 databases on each machine of differing 4D versions (usually 4Dv13.4, 4Dv15R5 and 4Dv16.0) - all are 32 bit. I focused on 2. Machine 1 - uptime 158 days I have 10 databases running on this machine. 3 are running using 4D v13.4, 2 are running v15R5 and the other 5 are running v16.0. The ones running v13.4 are not having this issue. All of the other ones are. Machine 2 - uptime 86 days I have 9 databases running on this machine. 3 are running 4Dv13.4 and 6 are running 4Dv16.0. None of the 4Dv13.4 databases have the problem. None of the 4Dv16.0 databases on this machine have experienced this problem. Jeff: I can confirm that the 4D Server UI monitor for graphs does stop updating when this occurs. On Machine 1, the only one that is working now is the one I manually resumed the processes for. On machine 2, all of the graphs are working just fine. The code dealing with these server processes has been running just fine for many, many years. Thanks! David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > On Oct 25, 2017, at 9:37 AM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Keith, > > Yes, that’s why I was curious about the machine up time. It would be curious > if it was close to 24.86 days, for example. > This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com) unsubscribe from this list (http://emailclicks.bythebook.com/track/unsub.php?u=30055319=9677e92f5f6e4a8c99f800ea10e5b871.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4d.com) ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Server Process "Frozen"-ish
I can confirm that this is caused by the delay process. In fact, all of my server processes that use delay process stopped on the same day. They had different levels of delay times set. As per your suggestion, I went into Runtime Explorer on the Server and typed resume process (pid) and they worked again. I will check tomorrow to see if the processes run more than one day after manually using resume. I am running 16.0 Build 16.209177. Server is running on Mac. I will create a test database and see if I can re-create and will open a support case for this issue. Thanks! David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > On Oct 18, 2017, at 7:33 PM, Timothy Penner via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi Cannon, > > If I am reading this correctly, you have a process that was delayed using > DELAY PROCESS and it should have already woken up after 1 second but it was > still delayed several hours later - is that right? > > Not sure if this will help you at all, but if you can locate the process > number for the process (let's assume it is process #10) and then issue RESUME > PROCESS(10) does it actually wake up or does it stay delayed? > > You can obtain the process number from the Admin Window or the Runtime > Explorer. > > You can issue commands from the Runtime Explorer by adding a new expression > and typing the command into the expression. For example, typing RESUME > PROCESS(10) into the Runtime Explorer will resume the process with id 10. > > To be clear - I don’t think this will help find the root cause of the > problem, but I do think it could help in understanding what state the process > is actually in. > > If this issue is simply DELAY PROCESS not waking up, I wonder if someone > could build a quick and simple database that demonstrates and tests that? > Maybe having a process that delays itself and updates a variable with the > current time, and another process checking the variable to confirm a certain > amount of time has elapsed. Then if the elapse time between updates falls > outside of the expected range then the bug has been hit? Has anyone tried > that to confirm this? > This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com) unsubscribe from this list (http://emailclicks.bythebook.com/track/unsub.php?u=30055319=8c2a09f8dc174d07aebcb70e893613ce.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4d.com) ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Anyone using 4D Write Pro with a semblance of success?
From everything that I’ve read, High Sierra is the last version of OS X that will support 32 bit apps. This makes the 4D Write/4D View issue imminent for me. Thanks! David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > > Anybody heard comments from Apple or Microsoft as to when they will kill > support for 32bit applications? > This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com) unsubscribe from this list (http://emailclicks.bythebook.com/track/unsub.php?u=30055319=55128fca61194ea7990a570d8e4be7c5.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4d.com) ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Hosting Service for Small System
Hi Doug, We’ve used Mac Mini Colo & Mac Stadium for years. Actually I liked the provisioning of Mac Stadium better than Mac Mini Colo so I was happy when they were absorbed. We’ve been very happy with the service and support. The biggest thing I’d warn you is to use the Legacy Network Layer when going over the WAN (if possible). We’ve also kept the machines at Yosemite as I’ve seen performance issues on the boxes when going beyond that OS version (I haven’t tried High Sierra yet). The performance issues had to do with an OS X process taking up high CPU usage. I could kill it but it would come back. The other nice thing about Mac Stadium is that you can have them install windows on the mac if you’d prefer to run the server on windows (you need to give them a windows license). Their price point is much cheaper than other hosting environments. My two cents worth… David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > On Oct 13, 2017, at 10:25 AM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I'm working with a company that has a seven user server running on a Mac > mini. They've decided to go "office-less" and are looking to have their > system hosted. > > This is a new area to me so I'm looking for recommendations for hosting > services. We would like to use the current Mac mini and, for a variety of > reasons, the hosting service should be located in the continental US. > > Checking in on the Mac mini colo reveals that they've been absorbed by > macstadium.com. Any comments on that service in particular? This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com) unsubscribe from this list (http://emailclicks.bythebook.com/track/unsub.php?u=30055319=76edb9f29fdc48898e14e6e2dcb26f07.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4d.com) ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Server Process "Frozen"-ish
Cannon, I would say about that yes. We have several server processes and only one gets called to our attention for not working. No one complains about the others and I haven’t looked into it to see if they have stopped too and no one noticed or if they are still happily working. I’ve been meaning to spend some time looking at it and haven’t had a chance yet. Thanks! David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > On Sep 8, 2017, at 4:23 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi David, > > How about timing? Just once every two-three months per server like us? > This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com) unsubscribe from this list (http://emailclicks.bythebook.com/track/unsub.php?u=30055319=292f69a675514e51a1e96bb53aaa57e5.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4d.com) ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Server Process "Frozen"-ish
We started seeing the same problem when we upgraded to v15R5 too. A process that ran for years on older versions just like Cannon described just stopped doing it’s thing. A reboot resolves it. We are seeing it on 32 bit server Mac & Windows. Thanks! David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > On Sep 8, 2017, at 4:13 PM, Stephen J. Orth via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Cannon, > > I can provide only antidotal information, but we too are seeing something > like this. We happen to be using V15 R5, which is basically V16, however > since upgrading to it we have seen A LOT of server related issues that we > have never encountered before. The code ran just fine in V13... > This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com) unsubscribe from this list (http://emailclicks.bythebook.com/track/unsub.php?u=30055319=d66a086fa68144c883a62ea6bdf1ebbb.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.4d.com) ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **