Symptom
- Error 1163 is raised when executing the CREATE DATABASE FOR LOAD command to create a database > 63GB:
Error: 1163, Severity: 21, State: 1
The space allocated to the sysgams table in database 'db1' (dbid = 7) must be at least 16 pages. Use 'DBCC GAM(7,-1,-1, 'fix')' to increase the allocation.
- A stack trace for Error 1163 contains the following functions:
pggam__srchonegampage
pggam_getfree_lowhigh
pg_allocate_syslogs
log__newpage
plc__flush
xls_preflush
write_prepare_rec
Note: A complete stack trace is available under Attachments.
-
Error 1163 may be followed by Error 6103 and result in a phantom process:
Error: 6103, Severity: 17, State: 1
Unable to do cleanup for the killed process; received Msg 3300.
WARNING: spid 67 with suid 2210 and curdbid 7 has an active transaction in dbid 1 with xactid (70955, 23).
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
Sybase, CR797041, CR#797041, 797041, 63GB , 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.