| Title: | *OLD* ALL-IN-1 (tm) Support Conference |
| Notice: | Closed - See Note 4331.l to move to IOSG::ALL-IN-1 |
| Moderator: | IOSG::PYE |
| Created: | Thu Jan 30 1992 |
| Last Modified: | Tue Jan 23 1996 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 4343 |
| Total number of notes: | 18308 |
Hi, I know that this is the ALL-IN-1 notes conference but this seems to be more of a programming problem rather than a EARS problem. This note is also posted in the EARS notes conference but did not receive any reply for a while. HELP !! I have a problem developing some enhancements for a customer on a EARS V2.1 system (on ALL-IN-1 V2.4). I seem to have a problem accessing a data set from the final distribution action. If I access the same data set interactively, I get the correct information, but if it is run by the EARS Postmaster, it will fail. The command is "get #class_bal = pr_trg_class.class_bal[#key]". I have tried substituting this with a "for" statement with exactly the same results - ok interactively (from EARS Postmaster a/c) but fails in the final distribution. Using the "for" statement, from the trace, the correct record was retrieved but the values from the non-key field was not found. The entry form PR_TRG_CLASS has key1 and key2 and the primary key is the addition of key1 and key2. This is defined in the PR_TRG_CLASS.FDL. A partial trace file is attached. Any suggestions will be much appreciated ! I'm at wit's end here and I need to get this live soon. Regards Seow-Hurn 79 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0118 79 ! [SCP/TRACE] ! Deduct enrollment from that class balance << ears$site_lib_share:ears_trg_distribute 0119 79 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0120 79 ! [SCP/TRACE] get #class_bal = pr_trg_class.class_bal[#key] << ears$site_lib_share:ears_trg_distribute 0121 79 ! GET Symbol: #key 79 ! Value: EUC2150193 79 ! OAFLC: Compiling form PR_TRG_CLASS 80 ! OAFLC: Compiled form PR_TRG_CLASS 81 ! GET Symbol: #class_bal = pr_trg_class.class_bal[#key] 81 ! Value: 81 ! [SCP/TRACE] compute #class_bal = #class_bal - #count << ears$site_lib_share:ears_trg_distribute 0122 81 ! GET Symbol: #CLASS_BAL 81 ! Value: 81 ! GET Symbol: #COUNT 81 ! Value: 2 81 ! [SCP/TRACE] write change pr_trg_class %key=#key , class_bal=#class_bal << ears$site_lib_share:ears_trg_distribute 0123 82 ! GET Symbol: #key 82 ! Value: EUC2150193 82 ! GET Symbol: #class_bal 82 ! Value: -2 82 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0124 82 ! [SCP/TRACE] ! Check to see if course nomination is to be deducted from this year's << ears$site_lib_share:ears_trg_distribute 0125 82 ! [SCP/TRACE] ! budget << ears$site_lib_share:ears_trg_distribute 0126 82 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0127 82 ! [SCP/TRACE] ! Get current fiscal year << ears$site_lib_share:ears_trg_distribute 0128 82 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0129 82 ! [SCP/TRACE] get #start_year=oa$date:2:6 << ears$site_lib_share:ears_trg_distribute 0130 82 ! GET Symbol: #start_year=oa$date:2:6 82 ! Value: 93 82 ! [SCP/TRACE] .if oa$date:2 le 3 then compute #start_year=#start_year - 1 << ears$site_lib_share:ears_trg_distribute 0131 82 ! GET Symbol: OA$DATE:2 82 ! Value: 12 82 ! GET Symbol: 3 82 ! Value: 3 82 ! [SCP/TRACE] compute #end_year=#start_year + 1 << ears$site_lib_share:ears_trg_distribute 0132 82 ! GET Symbol: #START_YEAR 83 ! Value: 93 83 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0133 83 ! [SCP/TRACE] get #start_date = #start_year "0401" << ears$site_lib_share:ears_trg_distribute 0134 83 ! GET Symbol: #start_date = #start_year "0401" 83 ! Value: 930401 83 ! [SCP/TRACE] get #end_date = #end_year "0331" << ears$site_lib_share:ears_trg_distribute 0135 83 ! GET Symbol: #end_date = #end_year "0331" 83 ! Value: 940331 83 ! [SCP/TRACE] get #cd = #class_date:2:6 #class_date:2:2 #class_date:2 << ears$site_lib_share:ears_trg_distribute 0136 83 ! GET Symbol: #cd = #class_date:2:6 #class_date:2:2 #class_date:2 83 ! Value: 931213 83 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0137 83 ! [SCP/TRACE] .if #cd gt #end_date then .goto NOUPDATE << ears$site_lib_share:ears_trg_distribute 0138 83 ! GET Symbol: #CD 83 ! Value: 931213 83 ! GET Symbol: #END_DATE 83 ! Value: 940331 83 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0139 83 ! [SCP/TRACE] .if #cd lt #start_date then .goto NOUPDATE << ears$site_lib_share:ears_trg_distribute 0140 83 ! GET Symbol: #CD 83 ! Value: 931213 83 ! GET Symbol: #START_DATE 83 ! Value: 930401 83 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0141 83 ! [SCP/TRACE] ! First get course fee << ears$site_lib_share:ears_trg_distribute 0142 84 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0143 84 ! [SCP/TRACE] !for pr_trg_class with .cour_c eqs #cour_c and .class_n eqs #class_n do - << ears$site_lib_share:ears_trg_distribute 0144 84 ! [SCP/TRACE] ! get #cour_fee_a = .class_fee_a << ears$site_lib_share:ears_trg_distribute 0145 84 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0146 84 ! [SCP/TRACE] get #cour_fee_a = pr_trg_class.class_fee_a[#key] << ears$site_lib_share:ears_trg_distribute 0147 84 ! GET Symbol: #key 84 ! Value: EUC2150193 84 ! GET Symbol: #cour_fee_a = pr_trg_class.class_fee_a[#key] 84 ! Value: 84 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0148 84 ! [SCP/TRACE] ! Compute total course fee << ears$site_lib_share:ears_trg_distribute 0149 84 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0150 84 ! [SCP/TRACE] decimal 2 << ears$site_lib_share:ears_trg_distribute 0151 84 ! [SCP/TRACE] compute #cf=#cour_fee_a /100 << ears$site_lib_share:ears_trg_distribute 0152 85 ! GET Symbol: #COUR_FEE_A 85 ! Value: 87 ! [SCP/TRACE] compute #total_cost=#cf * #count << ears$site_lib_share:ears_trg_distribute 0153 87 ! GET Symbol: #CF 87 ! Value: 0.00 87 ! GET Symbol: #COUNT 87 ! Value: 2 87 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0154 87 ! [SCP/TRACE] ! Get Budget for the department << ears$site_lib_share:ears_trg_distribute 0155 87 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0156 87 ! [SCP/TRACE] get #trg_bdgt_fy = pr_trg_bdgt:trg_site_c.trg_bdgt_bal[#site_c] << ears$site_lib_share:ears_trg_distribute 0157 87 ! GET Symbol: #site_c 87 ! Value: HRD 87 ! OAFLC: Compiling form PR_TRG_BDGT 87 ! OAFLC: Compiled form PR_TRG_BDGT 88 ! GET Symbol: #trg_bdgt_fy = pr_trg_bdgt:trg_site_c.trg_bdgt_bal[#site_c] 88 ! Value: 13500.00 88 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0158 88 ! [SCP/TRACE] ! Deduct from Budget << ears$site_lib_share:ears_trg_distribute 0159 88 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0160 88 ! [SCP/TRACE] compute #trg_bdgt_fy = #trg_bdgt_fy - #total_cost << ears$site_lib_share:ears_trg_distribute 0161 88 ! GET Symbol: #TRG_BDGT_FY 88 ! Value: 13500.00 88 ! GET Symbol: #TOTAL_COST 88 ! Value: 0.00 88 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0162 88 ! [SCP/TRACE] !Update Budget for the department << ears$site_lib_share:ears_trg_distribute 0163 89 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0164 89 ! [SCP/TRACE] write change pr_trg_bdgt trg_site_c=#site_c,trg_bdgt_bal=#trg_bdgt_fy << ears$site_lib_share:ears_trg_distribute 0165 89 ! GET Symbol: #site_c 89 ! Value: HRD 89 ! GET Symbol: #trg_bdgt_fy 89 ! Value: 13500.00 89 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0166 89 ! [SCP/TRACE] .label NOUPDATE << ears$site_lib_share:ears_trg_distribute 0167 89 ! [SCP/TRACE] << ears$site_lib_share:ears_trg_distribute 0168 89 ! [SCP/TRACE] OA$TRA_SET OFF,ALL << ears$site_lib_share:ears_trg_distribute 0169
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 3697.1 | Final distribution action is a batch job.. | ZPOVC::SEOWHURN | Thu Dec 23 1993 02:20 | 8 | |
Addendum to .0
I should also make special mention that the final distribution action
of EARS is run by the EARS Postmaster account in a BATCH queue, which
seems to be somehow different than when I run the same script
interactively from the same EARS Postmaster account.
Seow-Hurn
| |||||
| 3697.2 | Need to find out what is different in batch process! | BRUMMY::MARTIN::BELL | Martin Bell, NETCC, Birmingham UK | Thu Dec 23 1993 08:35 | 8 |
Seow-Hurn, just a possibility, but how does the named-data in form PR_TRG_CLASS describe the actual data file location? If a logical name is used, then maybe it translates to a different (or non-existent) file when run in batch as opposed to interactively. mb | |||||
| 3697.3 | Unfortunately, no logicals... | ZPOVC::SEOWHURN | Fri Dec 24 1993 01:25 | 21 | |
Martin,
I did check, but unfortunately, the named data is pointing to a
specific file name.
I'd been trying desparately to see what is different but to no avail.
Besides, during one of the testing (numerous), I created another review
item type and rename all the scripts, forms and data to another name
(so as not to interfere with the live system). The strange thing is
that it failed the first time, but AFTER NO CHANGES at all, worked fine
for the duration of the test (about 10 runs). I could find no
explanation for this as well !!
As I cannot find any duplicate form, script, logical redefinitions, I'm
really at wit's end !!
Seow-Hurn
HELP !!!
| |||||
| 3697.4 | Another wild guess ... | BRUMMY::MARTIN::BELL | Martin Bell, NETCC, Birmingham UK | Fri Dec 24 1993 08:43 | 6 |
Is this in a cluster or on a single node? Maybe the batch job executes on a different node to interactive and has different logicals or maybe even different ALL-IN-1 TXLs and FLBs installed. Is it possible to do a reboot to ensure that there are no old bits of code hanging around? mb | |||||
| 3697.5 | Cluster but runs on one node only. | ZPOVC::SEOWHURN | Wed Dec 29 1993 01:19 | 12 | |
RE: -.1
it is a cluster but ALL-IN-1 executes only on one node. The EARS
Postmaster is running on the correct batch queue.
Any more guess ?? Could it be a process quota problem ? I've checked
and although it is not generous, it is sufficient for standard
ALL-IN-1. Besides the JTQUOTA for the installation of EARS, there was
no additional parameters specified as required for the management of
EARS.
Seow-Hurn
| |||||