SAP Knowledge Base Article - Preview

2314335 - Error 1163 occurs if tempdb is bigger than 63GB - SAP ASE

Symptom

  • A 1163 error occured "The space allocated to rhe sysgams table in database 'tempdb' (dbid =2) must be at least 16 pages."
  • create a tempdb bigger than 63GB and separate data and log segments by sp_logdevice


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver

Product

SAP Adaptive Server Enterprise 15.7

Keywords

error 1163, tempdb, sp_log_device, tempdb_log1, pggam_srchonegampage, pg_allocate_syslogs, crdb_logtrunc, CR710603, CR#710603, 710603 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.