Symptom
Error 1142 is reported while starting the ASE server:
Error: 1142, Severity: 22, State: 4 Invalid OAM Page 0. Found pstat=0x0, object=0, database=6, indid=0
An accompanying stacktrace is generated and refers to following functions during 'saptempdb' database recovery:
pg__objdeall_validate_obj()
pg_ptndeal()
closetable()
close_range()
s_estmt_loopend()
s_execute.fdpr.chunk()
sequencer()
execproc()
s_execute()
As a result, database recovery fails since the database is not brought online.
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 SP122 for Business Suite
Cause
Access to saptempdb occurs prior to the database being online.
This issue has been addressed by SAP CR 771382: Its description reads, "error 1142 was raised on a user defined tempdb (saptempdb) during boot time recovery against 15.7 sp122 ASE. Please use system procedure sp_dbrecovery_order to change database recovery order. It will let ASE rebuild user defined tempdb saptempdb first after recovery system databases, then recovery other user databases".
Resolution
Ensure that saptempdb recovers and is brought online, prior to the user database (SID) recovery. This can be done via the sp_dbrecovery_order stored procedure.
sp_dbrecovery_order saptempdb, 1, force, strict
If there is already an recovery order defined for 1, it needed to be removed with the command: sp_dbrecovery_order saptempdb, -1
More details refer Snote: 2072361