Thanks to everyone who commented and reached out privately.
Based on all comments here, my best bet is to plan to visit the site and set up
the old Server and client which would have full licenses. We opted out of the
partner program when we retired the systems a few years back so any prior
par
It sounds like I may need to arrange to visit their site. My main question was
about running 4D v15.4 in demo mode on an older OS. They/I were a partner for
over 20 years, but stopped once the 4D systems were retired. I recall some 4D
versions offered demo mode but at some point that may have ch
esday, August 25, 2021 at 2:49 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Bradley Perkins
Subject: [EXTERNAL] Re: Run v15.4 in demo mode
Brad,
On Aug 25, 2021, at 3:44 PM, Perkins, Bradley D via 4D_Tech
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> wrote:
I'
Hi,
I've had a request to retrieve some data from a v15.4 database that was last
used in early 2019. The customer still has the server with DB installed and a
compatible client machine, but the machines are in storage and off-network.
Given the current situation getting them online and remotely
I've been asked to dust off a project that last ran client server on v15.4 and
capture the web pages (using Active4D) for a couple of 'applications' that ran
under this server and save them as static pages so that the owner can archive
them.
I have structure and data files but no longer have ne
Thanks Chuck. I'm not concerned about the Active4D part at this time. It seemed
like in the past there was an issue where you wouldn't be allowed to open the
structure after moving between machines or server -> client. I'll be at their
site tomorrow and will try your suggestion.
Brad
On 3/13/
A Windows v15.4 server database is being taken offline. The customer has
requested that some content be archived and output as static web pages. Much of
this database drove a number of Active4D-based web applications. To do this I
will need to move the structure and data to my Macbook Pro. I hav
Aparajita,
I'd estimate another year.
Thanks,
Brad Perkins
From: Aparajita Fishman
To: 4d_tech@lists.4d.com
Subject: Active4D/ObjectTools with 4D 32-bit
Message-ID:
Content-Type: text/plain; charset=us-ascii
Hi,
Just wondering how many Active4D or Obj
Tom,
Actually in this case the problem is that the text field for that row is larger
than the 32,767 character limit. All of the text after that blows up the import
until we start on the next valid row.
I think the original replace string was working as intended
There are only 11 cases where we
My initial tests using this technique look pretty good. I exported 100 rows and
all but one imported into Excel OK. Most of the text fields don't contain any
"s, but one that does caused the import to fail. How are you doubling the "s
when using Replace String?
I tried Replace string([table]tex
Tom,
That sounds extremely useful. In addition to "" any "s in the text do I also
need to \, any commas?
I doubt the data source will be too large, but if it is can break the export
into a couple of files. We'll only need to do this once.
Thanks,
Brad Perkins
From: "Benedict, Tom"
Date: Mon
Keith,
I asked because I haven't seen that feature. I mostly work with non-4D systems
these days and some have that capability. Also, I'd like to not have to install
code, a component etc as I'm trying to do the export from their production
compiled database.
It is looking like I can probably
Hi Tom,
I've been working this with the QR Editor with some success. Another challenge
I've found is that the 4D text fields have carriage returns, carriage
return/new line pairs, and even some tabs. Therefore I'll need to nest the
calls to Replace string in the proper order to place markers
Hi Keith,
Is there an explicit CSV option in Export Data or Quick Reports that will
properly 'quote' and escape any commas (or tabs, unfortunately there are a few)
in the exported text fields? If 4D can produce a file that I don't have to
inspect and manipulate prior to importing into Excel th
(11) with "///" or somesuch.
Then put the CR back after import.
Randy Engle
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Perkins, Bradley
D via 4D_Tech
Sent: Friday, August 3, 2018 10:22 AM
To: 4d_tech@lists.4d.com
Cc:
I've been asked to provide an export from a legacy 4D system delivered as an
.xlsx file.
The challenge I'm facing is that this table contains a number of text fields
and the customer requires the imported column cells to retain the returns or
line feeds in the original text fields. If I do a st
I think this problem is finally solved. As I'd always suspected, it was likely
related to power management features.
As previously noted, running the command ...
$ pmset -g
... suggested that all settings were as they should be. Mainly power nap was
turned off globally.
About a week ago someo
Still having problems. Based on various email notifications, I can see
that the scripts that under past OS versions would reliably restart 4D are
trying to do so, but w/o success. I don't know why they fail, but can see
they are repeatedly trying. That continues until I remotely access the
Mac. At
Thanks Chuck,
I've reset the backup by deleting preferences. I also modified my scripts to
use kill -9 instead of killall. Hopefully this will improve the situation. I
should know overnight.
-- Brad Perkins
On 11/14/17, 1:00 PM, "4D_Tech on behalf of 4d_tech-requ...@lists.4d.com"
<4d_tech-bou
John,
Possibly, but under normal circumstances there might be one request. This is a
small database and backup runs quick. There is a remote monitoring system that
sends a web request every 3 minutes. The page simply responds with the current
time although it might get that time from the server
Changing the thread title of "4D Remote hanging at 3am after upgrading to Hi
Sierra. Need logging advice."
4D 15.4
Mac OS High Sierra Client
Windows 2008r2 Server
As noted in previous posts I now suspect that a 5am (formerly 3am) scheduled 4D
Backup is causing 4D to 'hang'.
I checked my phone a
The good news is that the problem hasn't occurred the last 2 nights.
I haven't had time to check if the backups didn't run though. It is
possible that the database didn't change over the weekend and backups
were skipped. Friday was a federal holiday. Now that people are back at
work I'll be surpr
Tim,
The 4D Remote which is hanging is a Mac which was recently upgraded to
High Sierra, but the backup is running on a Windows 2008r2 Server.
The hang times are consistent with when the backup is running. First it
was 3am. I changed the backup to run at 5am and not the hang happens at
5am. This o
Some more information on my problem.
As I mentioned before I couldn't find anything in the various system logs
on the local machine that would correlate a 3am event. I'd also moved the
one 3am local job to 2am and that didn't move the problem time. Earlier
this week I remembered that 4D Backup run
h@lists.4d.com>
>Subject: Re: 4D Remote hanging at 3am after upgrading to Hi Sierra.
> Need logging advice.
>Message-ID: <0f3680b7-1b6c-4e79-b052-da4139867...@quevivadev.com>
>Content-Type: text/plain; charset=utf-8
>
>On Nov 4, 2017, at 3:32 PM, Perkins, Bradley
This problem went away for a few days, but restarted a couple of nights ago. It
still happens at 3am. I have not been able to observe what happens at that time
and suspect that if I try I won't see the problem. I suspect that Apple's
evolving power management features are part of the problem and
I think I found the problem. When I upgraded the server OS on Tuesday I had a
second GUI login session open for the admin user as I needed to sudo to fix
some permissions, etc (aka fast user switching). When I checked on the
application early Saturday AM I realized I had left that user logged in
I have grep'd everything in /var/log --- the files the the console displays --
and haven't found anything that is running at 3am. That is assuming of course
that any system level activity would be logged. The closest entry is at 3:01
and that is when my monitoring script emails me the first of m
Chip,
/var/log/daily.out exists
Since the OS is newly updated no weekly or monthlies have run yet.
I can see that the daily OS X cleanup scripts are running at ~22:15 local time.
That rules these out.
Thanks,
Brad Perkins
On 10/27/17, 12:25 PM, "Chip Scheide" <4d_o...@pghrepository.org> wrot
Chip,
Except for the OS Upgrade nothing changed. This problem didn't exist under
Sierra.
The machine has AV installed (IT policy mandates that too) but it has never
been a problem in the past.
I'm the only end user of the machine. As noted I do have a 3am job, but that
has run fine in the past
We had to update a machine to Mac OS X Hi Sierra this week (cybersecurity
mandate) on Tuesday of this week.
This machine runs as a web 'client' on 4D 15.4.
I have long standing controls in place to monitor the 4D application and keep
it running.
Since the OS update, 4D is hanging at 3am every mor
James (and others who answered),
Thanks. I updated their dev server yesterday day.
PHP and Apache are latest and will hopefully be 'compliant' for awhile.
Apple is always very slow to update these. My limited 4D testing running
15.4 were also OK.
I had to restore previous Apache configurations t
If anyone has installed the just released version of Mac OS High Sierra can you
confirm which versions of Apache and PHP are installed?
$ http -v
$ php -v
I have a customer that runs a 4D web system on Sierra and their IT/Cyber people
have complained the installed versions Apache 2.4.25 and PHP
A customer needs to replace aging Windows server hardware. I haven't spec'd any
Windows server hardware in a long time and am looking for recommendations.
The primary use is to host 4D Server. This isn't a large database, but does
need to run near 24/7/365.
The are currently running 4D v15.*
The
Chip,
I had already done that, but this helps as it made me review my settings:
Here are the settings for both machines:
Turn display off after : 30 minutes
[ ] Prevent computer from sleeping automatically when display is off.
[ ] Put hard disks to sleep when possible
[x] Wake for Ethernet netwo
I spoke too soon. Client disconnects started once I left work on Friday. I
apparently have app nap turned off for 4D (checkbox in 4D.app get info).
It also is off for most other apps based on viewing the Energy tab of all
processes in Activity monitor. The one exception is Finder, for which
there d
Bob,
Thank you. I was aware of this but was confusing 'App Nap' with the 'Power
Nap' settings in the Energy Saver control panel. I changed these a few
hours ago and no disconnects so far.
Brad Perkins
From: Robert McKeever
>
>Disable App Nap.
>
>>On Apr 13, 2
I'm trying to deploy a couple of system upgrades. We moved two 'web client'
machines from v14 on Mac OS X El Capitan to v15.4 on Sierra this week. Previous
versions of both systems have been deployed for years and gone through many
upgrades.
I am observing that 4D is losing its connection to th
I originally asked this question back in December.
From what I've followed, with newer versions of Sierra, stability of v15
improved greatly. We're still working on our v15 upgrade though and I'm
being forced to do Sierra upgrades next week and am wondering if anyone is
running v14 under newer ver
39 matches
Mail list logo
