ue_01_z0102 process stops after 2000 records; account is locked; CTXSYS

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Problem Symptoms:
Our version 18 ue_01_z0102 process is stopping after processing 2000 records:

cd $data_scratch
grep -c HANDLING *run_e_01_z0102*

run_e_01_z0102.12005:2000
run_e_01_z0102.14552:2000
run_e_01_z0102.15486:2000

There's no indication in the log of any error, but util c/1 and "ps -ef / grep z0102" show that the ue_01_z0102 process no longer exists.

The other two ue_01 processes seem to be working fine.

Cause:
CTXSYS account locked.

Resolution:
This happens because the CTXSYS account is locked: in each of the run_e_01_z0102 logs we see this after 1000 times HANDLING:

Oracle error: handle_connection
ORA-28000: the account is locked

Then, for some reason, it gets stuck the second time (another 1000 times).

This was an upgrade problem, and did not occur again once it was fixed (unlocked).

The fix is the following:

s+ aleph_admin
alter user CTXSYS identified by CTXSYS account unlock;
exit;