Posting application exits
Don Coleman
dcoleman at dgcreact.com
Thu Oct 16 08:42:18 PDT 2008
FPv5.0.13, Windows 2000 SP4 client, Windows 2003 Server
I have a posting application which posts data received by a separate socket
to socket application. The posting application starts at 1:35AM via Windows
Scheduled Tasks. Overnight this posting application frequently exits with
no error message (filepro) or any other message and has to be manually
restarted (when someone notices). The frequency of this app. exiting can
range from every 10 minutes (in the early AM hours) to an hour or more
overnight, although I have seen it exit after posting just a few records as
well (not the norm). The later into the AM we get the longer it seems to
run, and by the time it is 8:00AM or so it will generally run w/o exiting
for the remainder of the day until I have it automatically exit @ 11:50PM
for system maintenance.
Can anyone provide a suggestion as to what to look/test for. I just checked
the Dr. Watson log. Last entry was 10/10/08 (several). The times noted did
not span a time when my app. exited. In fact, one of the times noted in the
Dr. Watson log (exception error) was a time when my app. had exited prior to
this log entry and my app. had not yet been restarted. Nothing there as far
as I see.
The index used in this *clerk process is defined as follows:
Index D built on
Field 108 Transmitted (1,YESNO)
Field 112 Date (10,MDYY/)
Field 113 Time (8,TIME)
Better way to build this index perhaps?
The variable used in this lookup to identify & post any unposted records is
AA(1,*). Let me know of any need to see additional parts of the table. I
am only including to lookup portion at present. Any thoughts appreciated.
File Name: KALOS Page 1
Processing: Hold
14 ------- - - - - - - - - - - - - - - - -
If:
Then: AA(1,*)="";AB(1,.0)="2"
15 ------- - - - - - - - - - - - - - - - -
If: @TM ge "23:50:00"
Then: exit
16 ------- - - - - - - - - - - - - - - - -
check If:
Then: lookup kalos k=AA i=D -nx
17 ------- - - - - - - - - - - - - - - - -
If: not kalos
Then: goto nextrx
18 ------- - - - - - - - - - - - - - - - -
If: not kalos
Then: flushkey;goto check
19 ------- - - - - - - - - - - - - - - - -
If: kalos(108) eq "Y"
Then: flushkey;goto check
20 ------- - - - - - - - - - - - - - - - -
If:
Then: rn(8,.0)=kalos(@RN)
21 ------- - - - - - - - - - - - - - - - -
If:
Then: lookup - r=rn -np
22 ------- - - - - - - - - - - - - - - - -
If: not kalos
Then: beep;msgbox
"\r UNABLE TO POST KALOS DATA TO filePro WORKFLOW
APPLICATION";exit
23 ------- - - - - - - - - - - - - - - - -
If: 3 eq "P"
Then: gosub rphck;
RC(8,.0,g)=(RC+"1");LOGTEXT
"Rx#="{1<"Status="{3<"Counter="{RC<"Time="{@TM<"Date="{@TD;goto nextrx
24 ------- - - - - - - - - - - - - - - - -
If: 3 eq "N" or
3 eq "R"
Then: RC=(RC+"1");
LOGTEXT
"Rx#="{1<"Status="{3<"Counter="{RC<"Time="{@TM<"Date="{@TD;goto newrx
25 ------- - - - - - - - - - - - - - - - -
If: 3 eq "V"
Then: gosub voidrx
;gosub detail;RC=(RC+"1");LOGTEXT
"Rx#="{1<"Status="{3<"Counter="{RC<"Time="{@TM<"Date="{@TD;goto check
Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302
More information about the Filepro-list
mailing list