Process Sequence Numbers
The table, PS_PRCSSEQUENCE stores the last sequence numbers for the process scheduler and report manager.
In PeopleTools 8.48.15 there are 5 process sequence keys (PRCSSEQKEY) which you can view yourself by looking at the translates on this field:
- 0 = Process Instance
- 1 = Report Instance
- 2 = Transfer Instance
- 3 = Report ID
- 4 = Folder ID
Its probably a good health check to ensure that the numbers in PS_PRCSSEQUENCE match those in the relevant tables:
xxxxxxxxxx1
select max(PRCSINSTANCE) as PRCSSEQKEY0 from PSPRCSRQST;2
select max(CONTENTID) PRCSSEQKEY1 from PS_CDM_AUTH;3
select max(TRANSFERINSTANCE) PRCSSEQKEY2 from PS_CDM_LIST;4
select max(PSRF_REPORT_ID) PRCSSEQKEY3 from PSRF_RINFO_TBL;5
select max(PSRF_FOLDER_ID) PRCSSEQKEY4 from PSRF_FINFO_TBL;Especially if you happen to be clearing out data from these tables manually. If you do clear out processes/reports you'll want to update the PS_PRCSSEQUENCE accordingly.
No Comments