I just noticed today that a very long program (to me anyway ~900 lines) seems to be crashing on run. I didn't realize this until I couldn't get a thread on the server because all my crashes were hogging them. When I logged into the agent console I saw the dead bodies of all my little agents laying around with x's in their eyes and the word 'crashed' on their little tombstones.

The funny thing is, I've been getting output which leads me to believe things are running successfully. The HTML page includes the following messages in the comments at the bottom.

<!--
0 NUMBER OF RECORDS IN TABLE=      100  LINES=    100
0 NUMBER OF RECORDS IN TABLE=      100  LINES=    100
0 NUMBER OF RECORDS SELECTED=      100  LINES=    100
0 NUMBER OF RECORDS SELECTED=      100  LINES=    100
0 LINES OF MATCH OUTPUT     =      200
0 NUMBER OF RECORDS IN TABLE=      200  LINES=    200
' SENT
SENT
SENT
SENT
' SENT
SENT
SENT
SENT
' SENT
SENT
SENT
SENT
0 NUMBER OF RECORDS IN TABLE=      200  LINES=    200
SENT
SENT
0 NUMBER OF RECORDS IN TABLE=      200  LINES=    200
0 NUMBER OF RECORDS IN TABLE=       65  LINES=     65
0 NUMBER OF RECORDS IN TABLE=       20  LINES=     20
0 NUMBER OF RECORDS IN TABLE=        0  LINES=      0
0 NUMBER OF RECORDS IN TABLE=      100  LINES=    100
0 NUMBER OF RECORDS IN TABLE=      100  LINES=    100
0 NUMBER OF RECORDS IN TABLE=      138  LINES=    138
0 NUMBER OF RECORDS IN TABLE=      138  LINES=    138
0 NUMBER OF RECORDS IN TABLE=      138  LINES=    138
0 NUMBER OF RECORDS IN TABLE=      138  LINES=    138
0 NUMBER OF RECORDS IN TABLE=       94  LINES=     94
0 NUMBER OF RECORDS IN TABLE=       43  LINES=     43
0 NUMBER OF RECORDS IN TABLE=        1  LINES=      1
0 NUMBER OF RECORDS IN TABLE=      138  LINES=     94
-->

Lots of holds and joins, in case you're wondering. Not sure what those 'sent's are, they've been there since almost the beginning, but I don't think they have anything to do with this. I've tried 'EXIT'ing on major breaks in the program but so far haven't seen any resolution. Any clues for me as to what this could mean or what type of an issue this suggests?

- ABT

This message has been edited. Last edited by: ABT,

Are you able to set ECHO to ON or ALL, to see what the code is doing ?

I would search for SENT in the code and see if there are one or more extra or missing single quotes.

quote:

Originally posted by Dan Satchell:
I would search for SENT in the code and see if there are one or more extra or missing single quotes.

The 'SENT' messages seem to be coming after three multi field joins. As I said previously, this was coming out even before I noticed the crashed agent problem. It doesn't seem to be affecting anything and is at most a curiousity. Just wanted to close the loop on it though.

JOIN
 LEFT_OUTER BT_SRG_FEED_1.PAYOR_CODE_1 AND BT_SRG_FEED_1.COMPANY_CODE
 IN BT_SRG_FEED_1 TO UNIQUE T2INSPLAN.T2INSPLAN.INSURANCE_PLAN_CODE
 AND T2INSPLAN.T2INSPLAN.INS_PLAN_TABLE_ID IN T2INSPLAN TAG J11 AS J11
 END


JOIN
 LEFT_OUTER BT_SRG_FEED_1.PAYOR_CODE_2 AND BT_SRG_FEED_1.COMPANY_CODE
 IN BT_SRG_FEED_1 TO UNIQUE T2INSPLAN.T2INSPLAN.INSURANCE_PLAN_CODE
 AND T2INSPLAN.T2INSPLAN.INS_PLAN_TABLE_ID IN T2INSPLAN TAG J12 AS J12
 END


JOIN
 LEFT_OUTER BT_SRG_FEED_1.PAYOR_CODE_3 AND BT_SRG_FEED_1.COMPANY_CODE
 IN BT_SRG_FEED_1 TO UNIQUE T2INSPLAN.T2INSPLAN.INSURANCE_PLAN_CODE
 AND T2INSPLAN.T2INSPLAN.INS_PLAN_TABLE_ID IN T2INSPLAN TAG J13 AS J13
 END

After the code above and TABLE PRINT ... HOLD on the results, here are the outputs:

 0 NUMBER OF RECORDS IN TABLE=      100  LINES=    100
 0 NUMBER OF RECORDS IN TABLE=      100  LINES=    100
 0 NUMBER OF RECORDS SELECTED=      100  LINES=    100
 0 NUMBER OF RECORDS SELECTED=      100  LINES=    100
 0 LINES OF MATCH OUTPUT     =      200
 0 NUMBER OF RECORDS IN TABLE=      200  LINES=    200
 ' SENT
 SENT
 SENT
 SENT
 ' SENT
 SENT
 SENT
 SENT
 ' SENT
 SENT
 SENT
 SENT
 0 NUMBER OF RECORDS IN TABLE=      200  LINES=    200

- ABT

Those "SENT" lines may not be "at most a curiousity" - I've never seen one before. And you say "this was coming out even before I noticed the crashed agent problem" - this doesn't rule out them causing the crash. What does the last step of code do?

quote:

Are you able to set ECHO to ON or ALL, to see what the code is doing ?

I did, but it doesn't really reveal anything of interest. Just a code dump with the variables filled in and nothing really looks out of place.

- ABT

>20 By statements (in several blocks). Evidently, that's a no-no....

-ABT

Posting the code may help, as one of us may see something that you haven't.