Re: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Ken Eyring via 4D_Tech]

Thank you everyone who responded.  We tried to disable DEP and that did 
not solve the issue.


The first time the issue arose, it looked like it was running as a 
service - (the status said it was running), but no one could log into 
the built server.  Clients would receive a -10002 error.


Because the application was needed for production and they were already 
down for a day+, they reverted back to Win 7.


I'm looking into upgrading their application to the latest version of 4D.

This list has been a wonderful resource during my many years of using 
4D.  I don't come here often, but when I do... I always find excellent 
advice.  As always, my sincere thanks to all who share their knowledge.


Best regards,
Ken




On 01/19/21 7:35 PM, Kevin Abraham wrote:

We run v13.5 on Win 10 on just not on the Server End. If you are running a 4D 
Server on Win 10 as opposed to Win Server, I would check that there was Windows 
where you had to open up ports in the Win Fire Wall and also allow for Code 
Execution from a separate file.

Thanks,
Kevin Abraham
Digital Retirement Solutions
kabra...@drs401k.com



On Jan 19, 2021, at 8:39 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

It crossed my mind that v13 may not run on Win 10 Pro.

The upgrade from Windows 7 was done without my knowledge - or I would have 
asked this list for previous experiences.

Thanks,
Ken




**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro.

[David Samson via 4D_Tech]

As an interim solution you might be able to run a virtual PC with Win 7.


-- 
D Samson
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Kevin Abraham via 4D_Tech]

We run v13.5 on Win 10 on just not on the Server End. If you are running a 4D 
Server on Win 10 as opposed to Win Server, I would check that there was Windows 
where you had to open up ports in the Win Fire Wall and also allow for Code 
Execution from a separate file.

Thanks,
Kevin Abraham
Digital Retirement Solutions
kabra...@drs401k.com


> On Jan 19, 2021, at 8:39 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> It crossed my mind that v13 may not run on Win 10 Pro.
> 
> The upgrade from Windows 7 was done without my knowledge - or I would have 
> asked this list for previous experiences.
> 
> Thanks,
> Ken
> 
> 
> 
> 
> 
> On 01/19/21 10:36 AM, Kenneth Geiger wrote:
>> I believe that 4D v13 and Win10 are not really compatible. I also believe 
>> that 4D v15 is the oldest version supported on Win10.
>>> On Jan 19, 2021, at 8:21 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
>>> wrote:
>>> 
>>> I am trying to help a business that has a Built 4D Server (v13.6) that was 
>>> developed by another developer.
>>> 
>>> It was running fine on Friday - while running on Win 7.
>>> 
>>> Their IT upgraded the server OS to Win 10 Pro, Windows Experience Pack 
>>> 120.2212.551.0.
>>> 
>>> When I attempt to launch the built server after the Windows upgrade, I get 
>>> a prompt “No data file was found”.  I choose the "Open" option and navigate 
>>> to the data file, but after selecting the data file I get a runtime error 
>>> message “Cannot open structure of database”
>>> 
>>> When I try to launch the built application again and choose to "Create" a 
>>> data file (to see if that would allow the built server to run) - I get the 
>>> same error message that the structure cannot be opened.
>>> 
>>> I’m not a Windows expert - and any help that can be provided is very much 
>>> appreciated!
>>> **
>>> 4D Internet Users Group (4D iNUG)
>>> New Forum: https://discuss.4D.com
>>> 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)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Doug Cottrill via 4D_Tech]

Windows 10 has tightened security.  Someone else suggested checking to make 
sure structure and data file are not set to read only.  I would also recommend 
trying to run as Admin.  (Right click on 4D server app, select “run as Admin” 
and select structure).  Good luck.

> On Jan 19, 2021, at 10:39 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> It crossed my mind that v13 may not run on Win 10 Pro.
> 
> The upgrade from Windows 7 was done without my knowledge - or I would have 
> asked this list for previous experiences.
> 
> Thanks,
> Ken
> 
> 
> 
> 
> 
> On 01/19/21 10:36 AM, Kenneth Geiger wrote:
>> I believe that 4D v13 and Win10 are not really compatible. I also believe 
>> that 4D v15 is the oldest version supported on Win10.
>>> On Jan 19, 2021, at 8:21 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
>>> wrote:
>>> 
>>> I am trying to help a business that has a Built 4D Server (v13.6) that was 
>>> developed by another developer.
>>> 
>>> It was running fine on Friday - while running on Win 7.
>>> 
>>> Their IT upgraded the server OS to Win 10 Pro, Windows Experience Pack 
>>> 120.2212.551.0.
>>> 
>>> When I attempt to launch the built server after the Windows upgrade, I get 
>>> a prompt “No data file was found”.  I choose the "Open" option and navigate 
>>> to the data file, but after selecting the data file I get a runtime error 
>>> message “Cannot open structure of database”
>>> 
>>> When I try to launch the built application again and choose to "Create" a 
>>> data file (to see if that would allow the built server to run) - I get the 
>>> same error message that the structure cannot be opened.
>>> 
>>> I’m not a Windows expert - and any help that can be provided is very much 
>>> appreciated!
>>> **
>>> 4D Internet Users Group (4D iNUG)
>>> New Forum: https://discuss.4D.com
>>> 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)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Ken Eyring via 4D_Tech]

It crossed my mind that v13 may not run on Win 10 Pro.

The upgrade from Windows 7 was done without my knowledge - or I would 
have asked this list for previous experiences.


Thanks,
Ken





On 01/19/21 10:36 AM, Kenneth Geiger wrote:

I believe that 4D v13 and Win10 are not really compatible. I also believe that 
4D v15 is the oldest version supported on Win10.


On Jan 19, 2021, at 8:21 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

I am trying to help a business that has a Built 4D Server (v13.6) that was 
developed by another developer.

It was running fine on Friday - while running on Win 7.

Their IT upgraded the server OS to Win 10 Pro, Windows Experience Pack 
120.2212.551.0.

When I attempt to launch the built server after the Windows upgrade, I get a prompt “No 
data file was found”.  I choose the "Open" option and navigate to the data 
file, but after selecting the data file I get a runtime error message “Cannot open 
structure of database”

When I try to launch the built application again and choose to "Create" a data 
file (to see if that would allow the built server to run) - I get the same error message 
that the structure cannot be opened.

I’m not a Windows expert - and any help that can be provided is very much 
appreciated!
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Ken Eyring via 4D_Tech]

Thank you for responding.

The structure and data files are NOT set to Read Only.  They are read-write.

Any other suggestions are greatly appreciated.  I'm at a loss...

I'm assuming that v13.6 should run on Win 10 Pro.



On 01/19/21 10:27 AM, Spencer Hinsdale wrote:


Does this maybe mean the Structure is locked?  Restart the computer to release 
any hold Windows has on it.  Get Properties and change Permissions as needed.  
Set the preference inside 4D Server to Allow Read Only Structure...



On 1/19/21, 7:21 AM, "4D_Tech on behalf of Ken Eyring via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

  “Cannot open structure of database”



**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Kenneth Geiger via 4D_Tech]

I believe that 4D v13 and Win10 are not really compatible. I also believe that 
4D v15 is the oldest version supported on Win10.

> On Jan 19, 2021, at 8:21 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am trying to help a business that has a Built 4D Server (v13.6) that was 
> developed by another developer.
> 
> It was running fine on Friday - while running on Win 7.
> 
> Their IT upgraded the server OS to Win 10 Pro, Windows Experience Pack 
> 120.2212.551.0.
> 
> When I attempt to launch the built server after the Windows upgrade, I get a 
> prompt “No data file was found”.  I choose the "Open" option and navigate to 
> the data file, but after selecting the data file I get a runtime error 
> message “Cannot open structure of database”
> 
> When I try to launch the built application again and choose to "Create" a 
> data file (to see if that would allow the built server to run) - I get the 
> same error message that the structure cannot be opened.
> 
> I’m not a Windows expert - and any help that can be provided is very much 
> appreciated!
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Spencer Hinsdale via 4D_Tech]

Does this maybe mean the Structure is locked?  Restart the computer to release 
any hold Windows has on it.  Get Properties and change Permissions as needed.  
Set the preference inside 4D Server to Allow Read Only Structure...



On 1/19/21, 7:21 AM, "4D_Tech on behalf of Ken Eyring via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

 “Cannot open structure of database”


**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: NEED HELP

[Tom Dillon via 4D_Tech]

Running MSC on the dB fixed it. Thanks

On Sun, Feb 23, 2020 at 5:58 PM Chuck Miller <
cjmil...@informed-solutions.com> wrote:

> Dis you change OS versions
>
>
>
> Sent from my iPhone
>
> > On Feb 23, 2020, at 7:43 PM, Tom Dillon via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > No, I didn't. So will try that. Thanks
> >
> >> On Sun, Feb 23, 2020 at 3:37 PM Randy Kaempen 
> >> wrote:
> >>
> >> Tom,
> >>
> >>> On Feb 23, 2020, at 5:33 PM, Tom Dillon via 4D_Tech <
> >> 4d_tech@lists.4d.com> wrote:
> >>>
> >>> I am not sure if this is the right forum but I need help on a problem
> >>> that's just cropped up.
> >>>
> >>> I have been successfully  building stand alone apps using V13.3 for
> years
> >>> now and suddenly each time I try to "Build the app" it starts coping
> over
> >>> file but just before it finishes 4d crashes. I have tried everything to
> >> get
> >>> it to work.
> >>>
> >>> Anybody have any ideas as to what causing this?
> >>
> >> To ask the obvious questions:
> >>
> >> Did you run the MSC on the structure to make sure there’s no damage?
> >>
> >> Did you try replacing the 4D Volume Desktop with a fresh copy?
> >>
> >>
> >> Randy Kaempen
> >> Intellex Corporation
> >>
> > **
> > 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
> > **
>
>
**
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: NEED HELP

[Pat Bensky via 4D_Tech]

Are you running low on disk space?

On Sun, 23 Feb 2020 at 23:34, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I am not sure if this is the right forum but I need help on a problem
> that's just cropped up.
>
> I have been successfully  building stand alone apps using V13.3 for years
> now and suddenly each time I try to "Build the app" it starts coping over
> file but just before it finishes 4d crashes. I have tried everything to get
> it to work.
>
> Anybody have any ideas as to what causing this?
>
> Thanks,
>
> Tom Dillon
> **
> 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
> **



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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: NEED HELP

[Chuck Miller via 4D_Tech]

Dis you change OS versions



Sent from my iPhone

> On Feb 23, 2020, at 7:43 PM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> No, I didn't. So will try that. Thanks
> 
>> On Sun, Feb 23, 2020 at 3:37 PM Randy Kaempen 
>> wrote:
>> 
>> Tom,
>> 
>>> On Feb 23, 2020, at 5:33 PM, Tom Dillon via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> I am not sure if this is the right forum but I need help on a problem
>>> that's just cropped up.
>>> 
>>> I have been successfully  building stand alone apps using V13.3 for years
>>> now and suddenly each time I try to "Build the app" it starts coping over
>>> file but just before it finishes 4d crashes. I have tried everything to
>> get
>>> it to work.
>>> 
>>> Anybody have any ideas as to what causing this?
>> 
>> To ask the obvious questions:
>> 
>> Did you run the MSC on the structure to make sure there’s no damage?
>> 
>> Did you try replacing the 4D Volume Desktop with a fresh copy?
>> 
>> 
>> Randy Kaempen
>> Intellex Corporation
>> 
> **
> 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
> **

**
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: NEED HELP

[Randy Kaempen via 4D_Tech]

Tom,

> On Feb 23, 2020, at 5:33 PM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am not sure if this is the right forum but I need help on a problem
> that's just cropped up.
> 
> I have been successfully  building stand alone apps using V13.3 for years
> now and suddenly each time I try to "Build the app" it starts coping over
> file but just before it finishes 4d crashes. I have tried everything to get
> it to work.
> 
> Anybody have any ideas as to what causing this?

To ask the obvious questions:

Did you run the MSC on the structure to make sure there’s no damage?

Did you try replacing the 4D Volume Desktop with a fresh copy?


Randy Kaempen
Intellex Corporation
**
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: NEED HELP

[Keisuke Miyako via 4D_Tech]

it is really important to specify the platform (OS)

but assuming this is Mac, maybe you have some unexpected files inside one of 
your database folders (components, resources, plugins, extras, etc) that can 
not be copied.

On Feb 24, 2020, at 8:33, Tom Dillon via 4D_Tech 
<4d_tech@lists.4d.com> wrote:
Anybody have any ideas as to what causing this?

**
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: Need help identifying a crash source

[Bruno LEGAY via 4D_Tech]

Hi again,

It was discussed here :
http://forums.4d.fr/Post/FR/19031749/2/19066921#19066921

And there is a fix in 4D v15.4 HF1

ACI0096430  A query on three fields including a composite index 
could lead to a crash.

And Miyako gave further details :
the revised summary of ACI0096430 reads "A query on three field 
including a composite index could lead to a crash"
the description also talks about "composite index + a non-indexed 
field", in other words, 2-field composite index plus a non-index field seems to 
have triggered a crash. 

Not sure if it fits your situation.

I haven't tried 4D v15.4 HF1.

HTH
Bruno
**
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: Need help identifying a crash source

[Bruno LEGAY via 4D_Tech]

Hi,

Maybe we should report it to 4D (I did not report it must admit)...
Would you mind doing it ?

Thanks
Bruno
**
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: Need help identifying a crash source

[Keisuke Miyako via 4D_Tech]

for reference:

the issue is in question is ACI0096430

http://bugs.4d.fr/fixedbugslist?Version=15.4_HF1

tip:

some query examples for the URL

http://bugs.4d.fr/fixedbugslist?Version=15.4

http://bugs.4d.fr/fixedbugslist?Version=16_R3

http://bugs.4d.fr/fixedbugslist?Branch=16

> 2017/07/23 8:30、Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> のメール：
> Sounds like you’re using 15.4 - original release.
> There was an issue with composite indexes that was quickly fixed in the hot 
> fixes.




**
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: Need help identifying a crash source

[Kirk Brooks via 4D_Tech]

Sannyasin,
I took Bruno's suggestion and deleted the composite index for these two
fields. After that I was still getting a crash but it had moved further
down the execution chain. So I just deleted all the composite indexes.

That seemed to fix the problem.

On Sat, Jul 22, 2017 at 2:20 PM, Sannyasin Siddhanathaswami via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Code looks fine to me. Is it possible $1 or $2 is accidentally the wrong
> type (aka, not text). I’ve had fun crashes by accidentally passing an array
> that should have been just text…
>

-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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: Need help identifying a crash source

[Kirk Brooks via 4D_Tech]

Bruno,
That seems to be the issue. I say 'seems' because I could run the same
method with the same parameters in a different context and not have a
problem. And like I said this method is called very frequently. None the
less when I took out the composite index the problem shifted further down
the execution chain - to another similar situation with different methods
but a composite index in the mix anyway.

I knew there was a problem with the composites with 4D server but this is
the first time I've had a problem otherwise.

Thanks again for the lead.

On Sat, Jul 22, 2017 at 1:23 AM, Bruno LEGAY via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Kirk,
>
> We recently encountered a crash on a QUERY after adding a composite
> index...
> We removed composite index, no more crash...
> Do you have composite indexes ?
>
-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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: Need help identifying a crash source

[Kirk Brooks via 4D_Tech]

Oh yeah, the composite index thing. I'd forgotten that one and this is
15.4. Good suggestion, I'll have to look at that.

On Sat, Jul 22, 2017 at 1:23 AM, Bruno LEGAY via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Kirk,
>
> We recently encountered a crash on a QUERY after adding a composite
> index...
> We removed composite index, no more crash...
> Do you have composite indexes ?
>
> HTH
> Bruno
>
>
>
> **
> 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
> **
>



-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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: Need help identifying a crash source

[Ronald Rosell via 4D_Tech]

Kirk, something seems odd about this code.  Toward the end you have:


If ($key#"")

QUERY([KVP];[KVP]key=$key;*)

QUERY([KVP]; & ;[KVP]dir=$dir;*)

QUERY([KVP])

End if

That last Query([Table]) would bring up the query editor.  I’ve never tried 
doing that at the end of a string of Query parameters.  Either I have specified 
query parameters (the last one NOT ending in ;*) or I bring up the query table 
by referencing just the table and no parameters.

Perhaps this is what you need?

If ($key#"")

QUERY([KVP];[KVP]key=$key;*)

QUERY([KVP]; & ;[KVP]dir=$dir)

ELSE 

QUERY([KVP])

End if
__

Ron Rosell
President
StreamLMS

> On Jul 21, 2017, at 9:58 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I need some ideas on a problem.
> 
> I'm getting a crash when a method runs. The method itself isn't the issue,
> I think, because it gets called literally hundreds of times in a given
> session. Here it is:
> 
> C_TEXT($1;$2;$dir;$key)
> 
> $key:=$1
> 
> $dir:=""
> 
> If (Count parameters=2)
> 
> $dir:=$2
> 
> End if
> 
> ASSERT($key#"";"No key for a KVP find.")
> 
> If ($key#"")
> 
> QUERY([KVP];[KVP]key=$key;*)
> 
> QUERY([KVP]; & ;[KVP]dir=$dir;*)
> 
> QUERY([KVP])
> 
> End if
> 
> 
> The crash is happening as soon as the query runs when it's called in the
> context of a process that I spin up for a specific task. Now as I say this
> method is called frequently. I tried running it with the same parameters it
> gets in the crash scenario with no problem. This surprised me. So just for
> fun I ran the datafile through MSC and it comes back some errors in an
> index not related to this table at all. I repair it all anyway and still
> get the crash.
> 
> I try some different source records for the process even though the lookup
> that's being performed is the same for all of them. I still get the crash.
> 
> So, I'm looking for other avenues to explain what might be going on here.
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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
> **

**
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: Need help with LEP printing

[Peter Lerch]

KirkBrooks wrote
> And I also need the solution for doing the same thing on windows.

Hi Kirk,

This solution here prints all document types on Windows (assuming the
file-type is linked to any application that can print it).

Pass the following string to LEP: 
powershell "Start-Process 'full path to file' -Verb print -WindowStyle
hidden -PassThru | %{Start-Sleep 10;$_} | Stop-Process" 

It will print a file with the application that is set in the print
associations of its file type (e.g. .XLS -> Excel). So it doesn't rely on
Acrobat Reader to print PDFs.

Fore some PowerShell in 4D background, see http://kb.4d.com/assetid=76530


Regards,

Peter




--
View this message in context: 
http://4d.1045681.n5.nabble.com/Need-help-with-LEP-printing-tp5748583p5748624.html
Sent from the 4D Tech mailing list archive at Nabble.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: Need help with LEP printing

[Kirk Brooks]

Hey Tim,

On Thu, Nov 10, 2016 at 4:22 PM, Tim Nevels  wrote:

> Nice that Miyako made a plugin especially for you and your situation to
> print a PDF. I’m sure you will get it working.
>
​You flatter me. ​(I think.) But the timestamp on gitHub suggests the last
update on it was over 2 months ago. I think Miyako is very good but not
necessarily prescient.

There is another option. Use Adobe Acrobat Reader on Windows. It has always
> had a “hidden” feature where you can control it from the command line and
> have it open and print a PDF. I’ve been using it for years on Windows.
>
​Ah ha! That's the kind of hack I was looking for. Of course it assumes the
user has Acrobat on board but that's easy to deal with.

Thank you.
​

-- 
Kirk Brooks
San Francisco, CA
===
**
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: Need help with LEP printing

[Timothy Penner]

Hi Kirk,

If you are in Mac Terminal, and issue the same command, does it work from 
there?  

Make sure you are testing the same shell as you specified in the command, like 
this:

1) Open Mac Terminal.app
2) Navigate to the directory containing the pdf
3) Change the shell to /bin/sh by issuing the command: /bin/sh
4) Now in the /bin/sh shell, issue the command you sent to the shell: lpr 
Test.pdf

If it doesn’t work there, then it won't work from 4D either. Make it work from 
the terminal first, then adapt for 4D's LEP.

Sorry if this isn't much help, I just wanted to help rule out the obvious first.

-Tim
**
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: Need help setting up oAuth with cURL

[Spencer Hinsdale]

Thanks!  I will have a look.  I now remember needing to add cert separately for 
curl.exe, prior to OAuth plugin (non-blocking!).  Thanks again.

> On Oct 28, 2016, at 12:03 AM, Keisuke Miyako  wrote:
> 
> please study the method "HTTPS_DEBUG" provided with the plugin's sample 
> database.
> 
> C_BLOB($in;$out)
> C_LONGINT($err)
> ARRAY LONGINT($tNomOption;0)
> ARRAY TEXT($tValOption;0)
> APPEND TO ARRAY($tNomOption;CURLOPT_SSL_VERIFYHOST)
> APPEND TO ARRAY($tValOption;"1")
> 
> APPEND TO ARRAY($tNomOption;CURLOPT_SSL_VERIFYPEER)
> APPEND TO ARRAY($tValOption;"1")
> APPEND TO ARRAY($tNomOption;CURLOPT_CAINFO)
> APPEND TO ARRAY($tValOption;Convert path system to POSIX(Get 4D 
> folder(Current resources folder)+"cacert.pem"))
> 
> APPEND TO ARRAY($tNomOption;CURLOPT_DEBUGFUNCTION)
> APPEND TO ARRAY($tValOption;"CB_DEBUG")
> 
> $err:=cURL ("https://www.bigcommerce.com";$tNomOption;$tValOption;$in;$out)
> 

**
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: Need help setting up oAuth with cURL

[Keisuke Miyako]

please study the method "HTTPS_DEBUG" provided with the plugin's sample 
database.

C_BLOB($in;$out)
C_LONGINT($err)
ARRAY LONGINT($tNomOption;0)
ARRAY TEXT($tValOption;0)
APPEND TO ARRAY($tNomOption;CURLOPT_SSL_VERIFYHOST)
APPEND TO ARRAY($tValOption;"1")

APPEND TO ARRAY($tNomOption;CURLOPT_SSL_VERIFYPEER)
APPEND TO ARRAY($tValOption;"1")
APPEND TO ARRAY($tNomOption;CURLOPT_CAINFO)
APPEND TO ARRAY($tValOption;Convert path system to POSIX(Get 4D folder(Current 
resources folder)+"cacert.pem"))

APPEND TO ARRAY($tNomOption;CURLOPT_DEBUGFUNCTION)
APPEND TO ARRAY($tValOption;"CB_DEBUG")

$err:=cURL ("https://www.bigcommerce.com";$tNomOption;$tValOption;$in;$out)



宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

**
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: Need help setting up oAuth with cURL

[Spencer Hinsdale]

Hi Miyako,

I recently tried replacing OAuth.bundle (10/10/14)  with cURL.bundle (9/30/16) 
and ran into a problem with Error 60:
Peer certificate cannot be authenticated with known CA certificates.

I found that I could work around the problem by setting
CURLOPT_SSL_VERIFYPEER
to zero, which didn't seem like a great idea so I reverted :)

I tested against bigcommerce.com and shopify.com, getting the same error, using 
15.2 on El Capitan with Firewall off.  I did not have common-crypto installed.

I would be happy to post code, re-test, etc..

Thanks!

Spencer

> On Oct 26, 2016, at 8:35 AM, Keisuke Miyako  wrote:
> 
> the command names are exactly the same, nothing has changed other than the 
> name of the 2 plugins (the plugin has been split).
> code written for the old plugin will work "as is" with the "curl" and 
> "common-crypto" plugins.

**
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: Need help setting up oAuth with cURL

[Keisuke Miyako]

ah, you got me there, it's called "Get unixtime" in common-crypto.

unix time is the time passed since 1 January 1970
https://en.wikipedia.org/wiki/Unix_time

> 2016/10/27 1:08、Kirk Brooks  のメール：
> I notice there's one method that's been deleted: SYSTEM Get unixtime
> Easy enough, but does it need to be UTC or local time?



宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

**
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: Need help setting up oAuth with cURL

[Kirk Brooks]

Miyako,
Thanks for the reply. I found the presentation you did at the '12 Summit
where you used cURL & oAuth2 to connect to google. I'm working through that
since it details the steps.

I removed the deprecated oAUTH plugin and installed the new cURL and common
crypto.

I notice there's one method that's been deleted: SYSTEM Get unixtime

Easy enough, but does it need to be UTC or local time?

Thanks again.


On Wed, Oct 26, 2016 at 8:35 AM, Keisuke Miyako 
wrote:

> the command names are exactly the same, nothing has changed other than the
> name of the 2 plugins (the plugin has been split).
> code written for the old plugin will work "as is" with the "curl" and
> "common-crypto" plugins.
>

-- 
Kirk Brooks
San Francisco, CA
===
**
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: Need help setting up oAuth with cURL

[Keisuke Miyako]

the command names are exactly the same, nothing has changed other than the name 
of the 2 plugins (the plugin has been split).
code written for the old plugin will work "as is" with the "curl" and 
"common-crypto" plugins.

> 2016/10/26 22:31、Kirk Brooks  のメール：
> oAuth plugin is deprecated in favor of cUrl - but I don't see how
> to set the headers properly.



宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

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