<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.5764" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
color=#0000ff size=2>I have been having a similar problem. I thought it
was just with some kind of duplicate declare... but today, I put
this...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2> if: mid(d_fld["1"],"1","1") eq
"A"</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2>then: blah blah</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2>and it did what it has been doing on this 5.6.6 version of rcabe.
It gives the syntax error , and then when I press ENTER, it gives another syntax
error... but then immediately drops back to the shell. It should not do
that. The rcabe program usually/always puts you back in the prc table on
the line with the error, or close to it. In the past few weeks to amonth
or so I have been seeing this other behavior.... rcabe crashing out. Very
strange.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial size=2>I
thought mid(array[element],x,x) on the left side of an if comparison was
allowed. It never used to be, but it was fixed some time ago ... along
with mid of a lookup in the same place (left side of a comparison on the
if line.). I *know* these were fixed... but today, the mid of an
array(element) failed. I had to put the value in to a variable and then mid the
variable.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2>What is there an "R" in the month or something... no... a "Y"... ahhh,
that's it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009><FONT face=Arial
size=2>John</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=096254721-14052009></SPAN> </DIV><FONT
style="BACKGROUND-COLOR: #ffffff" face=Arial size=2></FONT><FONT
style="BACKGROUND-COLOR: #ffffff" face=Arial size=2></FONT><FONT
style="BACKGROUND-COLOR: #ffffff" face=Arial size=2></FONT><FONT
style="BACKGROUND-COLOR: #ffffff" face=Arial size=2></FONT><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
filepro-list-bounces+john=valar.com@lists.celestial.com
[mailto:filepro-list-bounces+john=valar.com@lists.celestial.com] <B>On Behalf
Of </B>Boaz Bezborodko<BR><B>Sent:</B> Thursday, May 14, 2009 5:12
PM<BR><B>To:</B> rkreiss@gccconsulting.net<BR><B>Cc:</B>
filepro-list@lists.celestial.com<BR><B>Subject:</B> Re: How much do I need to
worry about this?<BR></FONT><BR></DIV>
<DIV></DIV>Richard Kreiss wrote:
<BLOCKQUOTE cite=mid:00a101c9d4d6$4f8b0310$eea10930$@net type="cite"><PRE wrap=""> </PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">-----Original Message-----
From: <A class=moz-txt-link-abbreviated href="mailto:filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com">filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com</A>
</PRE></BLOCKQUOTE><PRE wrap=""><!---->[<A class=moz-txt-link-freetext href="mailto:filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com">mailto:filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com</A>]
On
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">Behalf Of Boaz Bezborodko
Sent: Tuesday, May 12, 2009 3:33 PM
To: Nancy Palmquist
Cc: <A class=moz-txt-link-abbreviated href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</A>
Subject: Re: How much do I need to worry about this?
Nancy Palmquist wrote:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">Boaz Bezborodko wrote:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">John Esak wrote:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap=""> Well, I guess you mean a comment on the if: line of a lookup. I
</PRE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE><PRE wrap=""><!---->don't
</PRE>
<BLOCKQUOTE type="cite">
<BLOCKQUOTE type="cite">
<BLOCKQUOTE type="cite">
<BLOCKQUOTE type="cite"><PRE wrap="">think anything other than the lookup can go on a lookup line. But,
still,
shouldn't cause rcabe to crash. It's sounding like an overall
memory error.
I didn't understand what you were saying about your testing on other
machines. Did it not crash there so you think it is just on your one
development machine? Is it at all repeatable? Have you eliminated
hardware
problems. Re-seated the memory, simple things like that?
</PRE></BLOCKQUOTE><PRE wrap="">The problem happens when I have a syntax error in the table and
occurs no matter which machine I use in the office. I checked the
log on Samba and it seems to be opening and closing the files as
necessary and isn't complaining about anything.
I also tried copying all the files from the file server onto my own
machine and set PFDSK to the local disk and I still got the problem.
This should have eliminated any memory problems (wouldn't duplicate
on other machines) and the server (I'm running the programs off the
local disk).
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">I do know one error that causes very strange behavior with cabe... I
don't
rmember if it does actual crashes. It might... Though... I know it
does all
sorts of weird stuff. This is the error of not having enough memory
allocated to "label" size. There is an environment variable that can
be set
higher. PFLBSIZE. As you get more and more lookup aliases, array
names I
think, and actual labels, maybe some other things, Ken would have to
elaborate, the tables can not be saved properly and lots of strange
runtime
errors occur. I set it in most of my large systems to 5000. I
think it is
defaulted to only 1024. Like I say, it probably doesn't cause cabe to
crash, but then again, that might be one of the symptoms.
John
</PRE></BLOCKQUOTE><PRE wrap="">This couldn't be the problem as I can make it do this even if the
only line in the table is a lookup with a syntax error.
One thing more....I'm seeing the following on the screen right after
the error window pops up:
Exception error -1073741819 in process failed 0(0x00000000)
comspec="(null)"
command="\fpro\fp\rcabe
"
Press Enter:
_______________________________________________
Filepro-list mailing list
<A class=moz-txt-link-abbreviated href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</A>
<A class=moz-txt-link-freetext href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</A>
</PRE></BLOCKQUOTE><PRE wrap="">Are you running a WINDOWS version of filePro? I had the impressing
you were running a Unix/Linux version from the talk of Samba.
I had no end of issues with filePro when the Windows network is not
working correctly.
The errors were like SegViolations on Unix and reported like you see
above. It always seemed to be caused by the system being unable to
write fast enough.
Now mostly I saw this in the runtime side, but maybe your network has
other problems.
To fix my RUNTIME issues, I added SLEEP commands after WRITE or
</PRE></BLOCKQUOTE><PRE wrap="">CLOSE
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">to give the network time to write the data and update the server.
It fixed most of the problems. It has reduced them to the point where
they are very occasional, instead of crashing so much we could not
</PRE></BLOCKQUOTE></BLOCKQUOTE><PRE wrap=""><!---->work.
</PRE>
<BLOCKQUOTE type="cite">
<BLOCKQUOTE type="cite"><PRE wrap="">Check that you have applied all the network patches for the system,
especially related to LOCKING and I/O, for the server and clients.
Hope that will help.
Nancy
</PRE></BLOCKQUOTE><PRE wrap="">Thanks for the in depth responses, Nancy.
I am using FilePro running locally on Windows machines and using a Linux
server running Samba as the fileserver. (When we made this change we
were already running FP Windows off a Netware server, so moving to Samba
when we needed to upgrade seemed the logical decision.)
I have no problems with rclerk or rreport. In fact everyone else is
moving along fine without even knowing about what is happening (except
for my having to explain why I can't get anything else done right now).
The error occurs as soon as I enter 'Y' at Check Syntax. Yes, it saves
the file, but it won't compile it.
To isolate the problem I moved everything over to my own local machine
and change PFDSK to point to the local drive. It still happens which
means that it isn't related to the server. I also get the same problem
on other machines so it can't be a memory issue.
I ran Microsoft's FILEMON to see what the system was doing with the
files and I did find one interesting thing when I looked at the data. I
found that rcabe was looking for 3 files that I can't find on my system.
273 2:53:40 PM rcabe.exe:360 QUERY INFORMATION
E:\fpro\fp\WINSTA.dll NOT FOUND Attributes: Error
274 2:53:40 PM rcabe.exe:360 QUERY INFORMATION
E:\fpro\fp\WTSAPI32.dll NOT FOUND Attributes: Error
275 2:53:40 PM rcabe.exe:360 QUERY INFORMATION
E:\fpro\fp\SETUPAPI.dll NOT FOUND Attributes: Error
I have sent FPsupport this information as well as the complete FILEMON
data from the error.
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
Just crashed rcabe 5.06.07 Windows.
Here is what caused the crash
Cn(len(1),edit(1)=2
Note I left off the closing paran. ). The syntax check found the error and
pointed at the =.
Not sure if this was your problem, but this is my error and it did crash
rcabe.
Richard Kreiss
GCC Consulting
<A class=moz-txt-link-abbreviated href="mailto:rkreiss@gccconsulting.net">rkreiss@gccconsulting.net</A>
</PRE></BLOCKQUOTE>Upgrading to 5.6.07 seems to have resolved the
problem.<BR><BR><BR></BLOCKQUOTE></BODY></HTML>