Normal Topic Subform Search Crashes Server (Read 1004 times)
North_Guy
Member
*
Offline


No personal text, yet.

Posts: 25
Location: Alberta, Canada
Joined: Sep 7th, 2005
Subform Search Crashes Server
Jan 5th, 2006 at 9:09pm
Print Post Print Post  
Hi there, I have encountered what may be a bug. I have a form open in search/update mode that has a subform, when I type in a 'customer number' in the customer number field of the main form and an '..a..' in the description field of the subform(table view) and press F10, the client hangs with a red 'working' in the mode indicator and it crashes the server its on on our LAN thats running on a linux box. Once it actually crashed the box all together.
One interesting thing is that on the subform there is a 'spacer' field that is always blank and when I type an '=' in that field along with a customer number on the main form it doesn't cause any problems at all and retrieves all the records instantly.
Anyone else encounter something like this?
Thanks
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Subform Search Crashes Server
Reply #1 - Jan 5th, 2006 at 9:19pm
Print Post Print Post  
What Flavor/Version of Linux are you running?
What version of Sesame? (NCLib/OCLib and version number)

If it is possible, please send your DB and DAT files to Support@Lantica.com along with any login information or special instructions that are needed to replicate this problem.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
North_Guy
Member
*
Offline


No personal text, yet.

Posts: 25
Location: Alberta, Canada
Joined: Sep 7th, 2005
Re: Subform Search Crashes Server
Reply #2 - Jan 5th, 2006 at 10:06pm
Print Post Print Post  
Thanks for the prompt reply. The linux box is running Mandrake 10.1 with NCLib and the version of sesame is 1.1.3.

I will email the files to the support email asap. The forms that I have encountered this problem with are the invoice form and the customer form, let me know if you need further details for testing.

Thanks again.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Subform Search Crashes Server
Reply #3 - Jan 6th, 2006 at 3:49pm
Print Post Print Post  
Hello,

I cannot get the Invoice form to misbehave, the search is run and records are returned, but I can get customer form to not complete a search and to hang. Development is looking into the cause of it now.

Is there a particular reason you are using relationally linked subforms instead of naturally linked subforms?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
North_Guy
Member
*
Offline


No personal text, yet.

Posts: 25
Location: Alberta, Canada
Joined: Sep 7th, 2005
Re: Subform Search Crashes Server
Reply #4 - Jan 6th, 2006 at 6:07pm
Print Post Print Post  
Thats interesting about the invoice form not hanging. I just did a search on customer number 140103 and ..a.. in the Description field of the subform and it seemed to hang on my copy. Wierd.
The reason why we used relational linking is because we had to import invoice history into the existing app.
Thanks
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Subform Search Crashes Server
Reply #5 - Jan 6th, 2006 at 7:09pm
Print Post Print Post  
Hello,

Does the app still need to be relational or can it be made natural?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
North_Guy
Member
*
Offline


No personal text, yet.

Posts: 25
Location: Alberta, Canada
Joined: Sep 7th, 2005
Re: Subform Search Crashes Server
Reply #6 - Jan 6th, 2006 at 8:32pm
Print Post Print Post  
Yes, I guess this app can be converted to natural now that we have all the data imported but we have other similiar appilcations having similar problems that have to stay relational unfortuneatly.
  
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Subform Search Crashes Server
Reply #7 - Jan 6th, 2006 at 9:40pm
Print Post Print Post  
North_Guy,

You should notice a HUGE speed improvement if you switch to Natural links - especially when searching within a subform.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Subform Search Crashes Server
Reply #8 - Jan 6th, 2006 at 10:17pm
Print Post Print Post  
North Guy,

We found the problem in the Customers form. It wasn't actually crashing so much as it was running through all of the available memory. I've revised the relational subform search routine so that it will give back more memory as it runs, which should prevent the problem you are seeing in this form, and (in larger relational applications) improve the speed.

The fix will be in the next release.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
North_Guy
Member
*
Offline


No personal text, yet.

Posts: 25
Location: Alberta, Canada
Joined: Sep 7th, 2005
Re: Subform Search Crashes Server
Reply #9 - Jan 6th, 2006 at 10:27pm
Print Post Print Post  
Excellent! Thats great, thanks very much. In the meantime with this app we are going to try to convert to natural linking but we have others we can't convert so this is great news.
Thanks guys.
  
Back to top
 
IP Logged