p_publish_06 does not create a tar file - error in system date
- Article Type: General
- Product: Aleph
- Product Version: 22
Problem Symptoms:
Service p_publish_06 runs correctly but it doesn't create a new file tar.
Example of error:
If the system date is not correct (e.g. 2030 instead 2015) and if publish_06 is executed with this date,
the date in the file tab_publish_timestamp and in z00p_timestamp will not be correct.
cat /exlibris/aleph/a20_1/aleph/tab/tab_publish_timestamp
PRIMO-SCD 203002051449090
select max(Z00P_TIMESTAMP) from z00P where Z00P_SET like 'PRIMO-SCD%';
MAX(Z00P_TIMEST
---------------
203002051449089
Cause:
error in system date
Resolution:
To correct this error, correct the date in the file tab_publish_timestamp and in the oracle table z00p (z00p_timestamp).
cat /exlibris/aleph/a20_1/aleph/tab/tab_publish_timestamp
PRIMO-SCD 201502051449090
update z00p set z00p_timestamp = ' 201502051449089' where Z00P_SET like 'PRIMO-SCD%' and z00p_timestamp = '203002051449089';
Additional Information
Context:
The last date used by p_publish_06 to add a new record or an update of BIB record in the table z00p,
is in the file /exlibris/aleph/ann_n/aleph/tab/tab_publish_timestamp.
The last date written in field z00p_timestamp is the same set (PRIMO-FULL).
cat /exlibris/aleph/a20_1/aleph/tab/tab_publish_timestamp
PRIMO-FULL 201502110148595
PRIMO-SCD 201502110201005
select max(Z00P_TIMESTAMP) from z00P where Z00P_SET like 'PRIMO-FULL%';
MAX(Z00P_TIMEST
---------------
201502110148594
select max(Z00P_TIMESTAMP) from z00P where Z00P_SET like 'PRIMO-SCD%';
MAX(Z00P_TIMEST
---------------
201502110201004
z00p_set z00p_timestamp tab_publish_stamp
-----------------------------------------------------------------------------------
PRIMO-FULL 201502110148594 201502110148595
PRIMO-SCD 201502110201004 201502110201005
Category: Publishing - ALEPH
Subject: Publishing Services - ALEPH
- Article last edited: 2/12/2015