• # Demerits suspension job is not catching some patrons

• Article Type: General
• Product: Voyager
• Product Version: 7.0.3

Description:
Bug Report Form for Issue 16384-9345
Module(s): Circjob
Server platform(s) affected: Solaris

Release(s) replicated in: 7.1.0-7.2.0

Expected results:
Circjob 31 should suspend all patrons eligible for suspension.

Actual results:
Circjob 31 does not suspend all eligible patrons when it hits a patron with a large number of entries in the fine_fee table.

Workflow implications:
Circjob 31 does not suspend patrons and they are not blocked as they should be.

Replication steps:
1. Run Circjob 31.
2. You will find that there are some patrons that are not suspended and should have been (they have more than the allowed max demerits for their patron group, they are not already suspended and they do not have any accrued demerits.)
3. Looking at the truss from when circjob 31 is run in these cases, there is a select statement for a large amount of fine_fee_id’s belonging to one patron, followed by an error: “O R A - 0 0 9 0 7 : m i s s i n g r i g h t p a r e n t h e s i s.”
4. Manually suspending the patron and forgiving their demerits allows the job to run to completion, until the next time it hits a similar patron.

Other information:

The end of the truss output when the job does not complete:
\0\00101\0\0\0\0\0\0\0\0\001FEFF S E L E C T f i n e _ f e e _
i d , f i n e _ f e e _ b a l a n c e F R O M f i n e _ f
e e W H E R E f i n e _ f e e _ i d I N ( 1 7 4 2 ,
1 9 2 3 , 1 4 5 7 , 1 9 5 9 , 1 9 5 1 , 1 7 6 7 , 1 9
8 2 , 1 9 7 2 , 1 6 9 9 , 1 4 5 0 , 1 6 9 4 , 1 6 9 7
, 1 7 4 5 , 1 7 5 0 , 1 4 9 6 , 1 7 4 9 , 1 9 9 0 ,
1 4 1 8 , 1 4 7 1 , 1 9 3 1 , 1 7 6 9 , 1 5 8 9 , 1 7
2 6 , 1 4 4 8 , 1 5 0 6 , 1 6 9 6 , 1 7 5 2 , 1 5 6 7
, 1 7 1 0 , 1 5 5 5 , 1FF 5 4 0 , 1 4 8 9 , 1 4 5 6 ,
2 0 0 3 , 1 9 7 4 , 1 7 2 0 , 1 5 0 9 , 1 4 0 8 , 1
5 6 1 , 1 4 6 5 , 1 7 5 5 , 1 4 2 6 , 1 7 6 2 , 1 4 2
8 , 1 3 9 5 , 1 5 6 2 , 1 9 3 2 , 1 9 8 5 , 1 7 9 2 ,
1 9 9 8 , 1 5 1 4 , 1 6 9 5 , 1 7 3 2 , 1 5 9 2 , 1
7 8 7 , 1 7 1 5 , 1 7 7 9 , 1 3 8 6 , 2 0 0 4 , 1 5 1
2 , 1 4 0 1 , 1 5 2 1 , 1 5 7 7 , 1 5 6 9 , 1 5 5 7 ,
1 7 7 5 , 1 9 8 4 , 1 5 5 4 , 1 5 4 5 , 1 5 4 3 , 1
7 6 8 , 1 5 4 1 , 1 7 6 6FF , 1 5 3 4 , 1 5 2 4 , 1 5
0 7 , 1 7 3 3 , 1 4 7 5 , 1 4 6 9 , 1 4 6 0 , 1 4 5 9
, 1 9 1 9 , 1 9 1 8 , 1 4 3 9 , 1 9 1 6 , 1 4 2 9 ,
1 5 5 6 , 1 9 3 5 , 1 9 2 4 , 1 4 5 8 , 1 4 3 0 , 1 4
0 3 , 1 3 9 9 , 1 7 1 1 , 1 4 0 2 , 1 3 9 8 , 1 5 7 0
, 1 5 0 5 , 1 4 4 9 , 1 5 7 2 , 1 5 4 9 , 1 7 2 1 ,
1 9 2 9 , 1 5 5 2 , 1 5 8 1 , 1 4 6 1 , 1 9 3 6 , 1 4
9 4 , 1 5 6 8 , 1 5 2 0 , 1 4 6 8 , 1 4 6 3 , 1 9 6 0
, 1 7 3 6 , 1 4 1 2 , 1FF 7 5 8 , 1 7 2 7 , 1 5 4 6 ,
1 4 7 2 , 1 9 2 0 , 1 7 8 8 , 1 9 9 6 , 1 7 5 4 , 1
9 6 6 , 1 4 3 1 , 2 0 0 7 , 1 5 3 6 , 1 4 7 3 , 1 5 4
4 , 1 9 7 8 , 1 4 2 3 , 1 1 7 2 , 1 4 8 0 , 1 5 1 7 ,
1 4 9 0 , 1 5 6 0 , 1 7 3 1 , 1 4 2 5 , 1 7 8 4 , 1
5 4 8 , 1 7 2 8 , 1 4 8 1 , 1 7 1 6 , 1 7 2 9 , 1 4 3
8 , 1 5 8 6 , 1 4 3 3 , 1 5 6 6 , 1 5 3 5 , 1 7 4 7 ,
1 5 2 8 , 1 6 9 8 , 1 9 3 4 , 1 9 7 5 , 1 7 7 3 , 1
3 8 8 , 1 5 7 8 , 1 4 8 3FF , 1 9 3 7 , 1 7 0 1 , 1 5
2 9 , 1 4 2 4 , 1 7 1 2 , 1 5 5 9 , 1 7 3 5 , 1 9 4 9
, 1 9 5 7 , 1 5 6 4 , 1 7 7 0 , 1 5 5 3 , 1 4 5 4 ,
1 4 2 7 , 1 7 5 3 , 1 5 4 7 , 1 7 2 3 , 1 4 8 6 , 1 5
2 7 , 1 7 0 2 , 1 5 1 5 , 1 9 3 3 , 1 5 2 6 , 1 5 2 2
, 1 4 0 5 , 1 9 2 8 , 1 7 9 3 , 1 9 9 9 , 1 7 6 4 ,
1 9 7 6 , 1 7 4 3 , 1 7 8 3 , 1 4 8 4 , 1 5 6 5 , 1 9
8 9 , 1 4 7 0 , 1 9 5 4 , 1 4 7 7 , 1 4 6 4 , 1 4 1 6
, 1 7 5 9 , 1 9 7 1 , 1FF 9 5 0 , 1 7 3 8 , 1 4 0 6 ,
1 4 1 9 , 1 9 8 7 , 1 9 2 1 , 1 7 1 9 , 1 9 1 3 , 1
9 2 5 , 1 9 4 8 , 1 4 8 5 , 1 4 0 9 , 1 5 0 3 , 1 9 4
2 , 2 0 0 8 , 1 1 6 7 , 1 5 7 6 , 1 4 1 3 , 1 4 5 5 ,
1 7 7 4 , 1 1 7 3 , 1 4 7 9 , 1 7 1 7 , 1 4 7 6 , 1
4 4 1 , 1 5 7 1 , 1 4 4 7 , 1 4 5 3 , 1 5 8 8 , 1 7 9
4 , 2 0 0 1 , 1 5 8 0 , 1 9 3 8 , 1 3 9 2 , 1 3 9 6 ,
1 3 8 7 , 1 9 9 1 , 1 7 6 3 , 1 9 4 5 , 1 4 3 5 , 1
5 2 3 , 1 4 0 4 , 1 5 5 8FF , 1 4 0 0 , 1 5 1 9 , 1 9
6 5 , 1 5 8 4 , 1 5 8 7 , 1 9 5 5 , 1 7 3 9 , 1 4 9 2
, 1 4 9 8 , 1 9 5 3 , 1 4 7 8 , 1 5 7 5 , 1 7 9 6 ,
2 0 0 9 , 1 5 0 2 , 1 5 7 9 , 1 5 7 4 , 1 9 8 8 , 1 7
7 7 , 1 5 1 6 , 1 5 0 8 , 1 4 9 7 , 1 4 9 1 , 1 7 4 0
, 1 9 4 0

Resolution:
Fix area(s): Circjob, Circ

Fix version(s): 7.2.2

• Article last edited: 10/17/2013