Re: Query & Order by on non indexed fields

[Keisuke Miyako via 4D_Tech]

you can also find out whether a query (not sort) used an index with DESCRIBE 
QUERY EXECUTION

http://doc.4d.com/4Dv15/4D/15.4/DESCRIBE-QUERY-EXECUTION.301-3273970.en.html



**
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

[Arnaud de Montard via 4D_Tech]

> Le 14 sept. 2017 à 03:58, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Houston, er, Clichy -- we have a problem here.

Call Le Pecq, they left Clichy from a while  ;-)

-- 
Arnaud de Montard 



**
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: SFTP - Native to 4D?

[Koen Van Hooreweghe via 4D_Tech]

Hi Janet,

As others has mentioned, there is no native sftp client (yet?) in 4D. On Mac 
I’m using the OS built in sftp command which is called using LAUNCH EXTERNAL 
PROCESS.
For my purpose, I create a ‘batch’ file which contains the necessary sftp 
commands and then run it with sftp.

Eg. a possible content of the batch file could be:
cd /mydir
ls -1

Set the directory to mydir and get the directory listing. Keep in mind this is 
Unix, you must separate the lines with line feeds.

Then the command is like:
sftp -b ‘pathToBatchFileInPosixFormat’ -i ‘pathToIdentityFileInPosix’ 
-oPort= username@serveraddress

pathToIdentityFileInPosix is the path to the rsa file containing your key. This 
file is normally stored in your home folder in a .ssh directory: 
/Users/yourname/.ssh
You can use eg System folder(Desktop) to get the path to your home folder. Just 
toss out the last part of the path.

The fun with this is you can setup and test first in terminal and when all is 
working as expected, move to 4D.

HTH
Koen

> Op 13 sep. 2017, om 17:27 heeft Janet Jonas via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Does 4D have any native capability to do SFTP file transfers and/or generate 
> a SSH-2 RSA public and private key pair?
> 
> Any pointers would be welcome.




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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Query & Order by on non indexed fields

[Andrew Hobson via 4D_Tech]

Hello,
 
I know there was a way to find all QUERY and ORDER BY that are performed on
non indexed fields.
 
But I don't remember how to do it.
 
Is this possible with 4D v13 or must I use an external tool ?
 
Thanks to refresh my memory.
 
Andrew
 
**
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: Query & Order by on non indexed fields

[Keisuke Miyako via 4D_Tech]

whether an index is used or not depends on the context.

of course, 4D can't use an index that does not exist,
but otherwise, just because an index is defined it doesn't mean that it will be 
used.

the exact same query/sort condition may not alway use indexes,
it depends on the current selection to all records ratio,
whether an index update in progress, etc.

that is why one can only say for sure by running the application for some time 
with realistic data and usage.

see GET DATABASE MEASURES (14R3)
http://kb.4d.com/assetid=77205

2017/09/14 16:53、Andrew Hobson via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
Is this possible with 4D v13 or must I use an external tool ?



**
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: Query & Order by on non indexed fields

[Chip Scheide via 4D_Tech]

That functionality was available in through Data Check and/or Sanity 
Check (neither of which have been updated to work with any version of 
4D newer then v2204(?))


On Thu, 14 Sep 2017 09:53:13 +0200, Andrew Hobson via 4D_Tech wrote:
> Hello,
>  
> I know there was a way to find all QUERY and ORDER BY that are performed on
> non indexed fields.
>  
> But I don't remember how to do it.
>  
> Is this possible with 4D v13 or must I use an external tool ?
>  
> Thanks to refresh my memory.
>  
> Andrew
>  
> **
> 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
> **
---
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Server Process "Frozen"-ish

[Cannon Smith via 4D_Tech]

Hmm, v16.2 eh? There goes our hope that it was fixed in that version.

Is anyone having this happen regularly enough that they can turn on some 
logging to see, for example, what the last command that ran was?

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Sep 13, 2017, at 7:58 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I've never seen this happen in 4D before.
> 
> 4D v16.2, Windows Server 2012, 64-bit
> 

**
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

[John DeSoi via 4D_Tech]

> On Sep 14, 2017, at 7:05 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> This is a big problem that must get addressed and fixed or it will do harm to 
> v16’s reputation. I was planning on upgrading one of my clients to v16 in a 
> few months. That is not going to happen now. I can’t afford to have my Stored 
> Procedure randomly stop running. So v16 upgrades for me are never going to 
> happen until I hear this bug has been fixed. This could spread to others and 
> give v16 a very bad name. Nobody wants that. Especially 4D Inc.

Agree. I'm also waiting to be convinced that 4D Client performance with the new 
network layer on on par with version 15. It seems the majority of comments have 
been negative. It would be great to hear some success stories for 64bit 4D 
Client, especially Mac.

John DeSoi, Ph.D.

**
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: SFTP - Native to 4D?

[4dialog via 4D_Tech]

Have used CrushFtp/ CrushSync for many years for backup and sending xml data
to external partners.

It works very well, stable on Mac, flexible, easy to setup.





-
Hilsen
--
Helge Antonsen
4Dialog as
Tel: +47 64 000 164
Mob: +47 90 15 56 19
Web: www.4dialog.no 
--
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Server Process "Frozen"-ish

[Jeffrey Kain via 4D_Tech]

I opened a case on the taow today - just FYI.


> On Sep 14, 2017, at 8:05 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Then I’d call and speak to Add and get him involved in this. He knows you. 
> And you can tell him that others — like Jeff Kain — are experiencing the same 
> problem. 

**
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: SFTP - Native to 4D?

[Janet Jonas via 4D_Tech]

Koen - 

That was super helpful. Thanks to some Google-fu I was able to find out some 
instructions on making SFTP batch files and how to run them from terminal 
commands, your examples of the commands I would want specifically will make it 
all so much easier.

Thank you,

JJ

> On Sep 14, 2017, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote:
> 
> 
> Message: 5
> Date: Thu, 14 Sep 2017 11:36:56 +0200
> From: Koen Van Hooreweghe  >
> To: 4D iNug Technical <4d_tech@lists.4d.com >
> Subject: Re: SFTP - Native to 4D?
> Message-ID: <73045613-3643-403c-9ac3-37c845c0c...@telenet.be 
> >
> Content-Type: text/plain; charset=utf-8
> 
> Hi Janet,
> 
> As others has mentioned, there is no native sftp client (yet?) in 4D. On Mac 
> I’m using the OS built in sftp command which is called using LAUNCH EXTERNAL 
> PROCESS.
> For my purpose, I create a ‘batch’ file which contains the necessary sftp 
> commands and then run it with sftp.
> 
> Eg. a possible content of the batch file could be:
> cd /mydir
> ls -1
> 
> Set the directory to mydir and get the directory listing. Keep in mind this 
> is Unix, you must separate the lines with line feeds.
> 
> Then the command is like:
> sftp -b ‘pathToBatchFileInPosixFormat’ -i ‘pathToIdentityFileInPosix’ 
> -oPort= username@serveraddress
> 
> pathToIdentityFileInPosix is the path to the rsa file containing your key. 
> This file is normally stored in your home folder in a .ssh directory: 
> /Users/yourname/.ssh
> You can use eg System folder(Desktop) to get the path to your home folder. 
> Just toss out the last part of the path.
> 
> The fun with this is you can setup and test first in terminal and when all is 
> working as expected, move to 4D.
> 
> HTH
> Koen
> 
>> Op 13 sep. 2017, om 17:27 heeft Janet Jonas via 4D_Tech 
>> <4d_tech@lists.4d.com > het volgende geschreven:
>> 
>> Does 4D have any native capability to do SFTP file transfers and/or generate 
>> a SSH-2 RSA public and private key pair?
>> 
>> Any pointers would be welcome.
> 
> 

**
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

[Tim Nevels via 4D_Tech]

On Sep 14, 2017, at 2:00 PM, Cannon Smith wrote:

> Hmm, v16.2 eh? There goes our hope that it was fixed in that version.
> 
> Is anyone having this happen regularly enough that they can turn on some 
> logging to see, for example, what the last command that ran was?

Hi Cannon,

I’d called 4D tech support and open a case on this problem. Ask them to do a 
search in the bug database for similar issues. I did this 6-8 months ago with 
an index corruption issue I was having in v14 and they found another reported 
bug that had the same pattern as mine. And it was fixed in v15. 

Then I’d call and speak to Add and get him involved in this. He knows you. And 
you can tell him that others — like Jeff Kain — are experiencing the same 
problem. 

Once you get past basic 4D tech support and get your case “escalated” many more 
options become available to you. You can get the “debug” version of 4D Server 
and run that. It can help track down bugs like this that are impossible to 
track down with standard 4D Server version even with logging turned on. 
Finally, you can get the attention of 4D engineering and they can add some 
special code to the daily build or debug version to help figure out what is 
going wrong. 

It could be a current v16 daily build version has already fixed the problem. 
You don’t normally run daily build version in production environments, but you 
can if it fixes a critical problem that you need immediately fixed. 

This is a big problem that must get addressed and fixed or it will do harm to 
v16’s reputation. I was planning on upgrading one of my clients to v16 in a few 
months. That is not going to happen now. I can’t afford to have my Stored 
Procedure randomly stop running. So v16 upgrades for me are never going to 
happen until I hear this bug has been fixed. This could spread to others and 
give v16 a very bad name. Nobody wants that. Especially 4D Inc.

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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Server Process "Frozen"-ish

[Bernd Fröhlich via 4D_Tech]

Cannon Smith:

> Thanks for the idea. I did try that before to see if I could jumpstart the 
> process, but unfortunately it doesn’t work. 4D thinks the process is already 
> there. And it it there. It just doesn’t seem to be executing.

Yep, same here.
I do have a method that would start the process again. Problem is: when it 
hangs it can´t be quit, even from the Server-admin-window.

Greetings from Germany,
Bernd Fröhlich
**
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
**