Hot Topic (More than 10 Replies) Sesame crash (Read 1566 times)
Derek-PSTC
Member
Members
*
Offline


No personal text

Posts: 12
Joined: May 3rd, 2006
Sesame crash
Jul 19th, 2006 at 1:25pm
Print Post Print Post  
Maybe I'm missing something simple, but I am haveing some trouble with one record crashing Sesame whenever it comes up, either in searching that record, or coming across it using F10.

There was somehow a duplicate record in the database, but it has been removed, could this be causing the problem?

Thanks

Derek
  
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: Sesame crash
Reply #1 - Jul 19th, 2006 at 1:28pm
Print Post Print Post  
Derek,

Send it in to support@lantica.com and I'll have a look at it.

-Ray
  

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


No personal text

Posts: 12
Joined: May 3rd, 2006
Re: Sesame crash
Reply #2 - Jul 19th, 2006 at 1:33pm
Print Post Print Post  
Thanks Ray
  
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: Sesame crash
Reply #3 - Jul 19th, 2006 at 2:20pm
Print Post Print Post  
Derek,

Did you recently do an import of Data?
or
Change a field type from Date to Number?

-Ray
  

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


No personal text

Posts: 12
Joined: May 3rd, 2006
Re: Sesame crash
Reply #4 - Jul 19th, 2006 at 2:25pm
Print Post Print Post  
Morning Ray;


No I havn't changed a thing in that database, and I don't believe anyone at the client would have been playing with it either.


Thanks

Derek
  
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: Sesame crash
Reply #5 - Jul 19th, 2006 at 2:37pm
Print Post Print Post  
Derek,

In your e-mail you will have the file back. There was a bad date value in that one record.

-Ray
  

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


No personal text

Posts: 12
Joined: May 3rd, 2006
Re: Sesame crash
Reply #6 - Jul 19th, 2006 at 2:52pm
Print Post Print Post  
Thank you


Derek
  
Back to top
 
IP Logged
 
Derek-PSTC
Member
Members
*
Offline


No personal text

Posts: 12
Joined: May 3rd, 2006
Re: Sesame crash
Reply #7 - Jul 19th, 2006 at 3:05pm
Print Post Print Post  
Ray,


Still crashing on unit # 219520 same as before.   Sad


Thank you

Derek
  
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: Sesame crash
Reply #8 - Jul 19th, 2006 at 3:47pm
Print Post Print Post  
Derek,

Double check that you are opening the files that I sent back to you. I just triple checked it here and I can see the 219520 record. Try saving them under a different name just to be sure you are opening the right one.

If you are running Client/Server shut down the server then save the files down.

-Ray
  

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


No personal text

Posts: 12
Joined: May 3rd, 2006
Re: Sesame crash
Reply #9 - Jul 19th, 2006 at 4:10pm
Print Post Print Post  
Yes thanks Ray that did it

Made sure eveyone was out of the server before, but didn't shut it down

Thank you again
  
Back to top
 
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Sesame crash
Reply #10 - Jul 22nd, 2006 at 7:03pm
Print Post Print Post  
I'm just curious, but what is a "bad date value"?
  

**
Captain Infinity
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Sesame crash
Reply #11 - Jul 22nd, 2006 at 7:20pm
Print Post Print Post  
Infinity wrote on Jul 22nd, 2006 at 7:03pm:
I'm just curious, but what is a "bad date value"?


It is a string of character that appear in a date field that cannot be resolved as a date by any of the twenty or so date formats that Sesame accepts. In this user's particular case it was a string that was formatted as a human readable date (i.e.: "MM/DD/YYYY") that made its way onto the engine without being converted to the internal date format ("YYYY/MM/DD"). Sesame does not ordinarily allow this condition.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged