Acq client crashes in displaying particular order (or associated invoice)
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
Acquisitions client crashes trying to display Invoice -- or order 123456-2 which is connected to this invoice.
Cause:
Acq is reading the order record's z601 (budget transaction) records to display amounts committed/spent.
A particular z601 causes the crash. {When the z601_rec_key_3 (the order number) was temporarily changed, the order and invoice displayed without problem.}
Resolution:
Run the following SQL to display the z601 records connected to the order:
SQL> select Z601_REC_KEY, Z601_REC_KEY_2, Z601_ACTIVE_SUM from z601 where z601_rec_key_3 = '00012345600002' order by Z601_ACTIVE_SUM;
{where 00012345600002 is the order key (ADM# + sequence)}.
Examine the results to see if any seem odd/defective.
Additional Information
In this case the active-sum and local-sum were zero:
SQL> select * from z601 where z601_rec_key = '3201-S-2013 201206249854629';
3201-S-2013 201206249854629
00000 00550163200002 Y-TOYO
20120624 ENC
D USD 20120624 000000000000 00000000000000 00000000000000
00000000000000 00000000000000
(It is normal for there to be many z601's with zero amounts; it's unclear why this particular one caused the crash.)
Category: Acquisitions (500)
- Article last edited: 10/8/2013