[SAP EAI] Error "Can't allocate space for object 'js_history' ..."

개발환경

• SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
• SAP NetWeaver (NW) - All versions

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver

 

Error Message

00:0003:00000:00019:2021/01/22 07:58:28.61 kernel Job Scheduler (js__exec_handler): Exception 3602 raised.
00:0003:00000:00019:2021/01/22 07:58:28.61 kernel Job Scheduler got exception for execution token 1.
00:0003:00000:00019:2021/01/22 07:58:28.63 server Error: 1105, Severity: 17, State: 2
00:0003:00000:00019:2021/01/22 07:58:28.63 server Can't allocate space for object 'js_history' in database 'sybmgmtdb' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

 

해결방안

1) Database Resizing

 - 현재 시스템에 맞는 적절한 사이즈로 Database의 사이즈 조정

2) Split data and logs

 - 'sybmgmtdb'에 full 현상이 발생하는 이유가 시스템에서 사용하는 data와 log가 한 database에서 사용되어지기 때문에 full 현상이 발생할 수 있다.

 - 때문에 시스템에서 data를 사용하는 'sybmgmtdb_data'와 'sybmgmtdb_log' 로 database를 분할하여 사용

 

참고 Notes

- Note 1931223 - Error SQL1105 "Can't allocate space for object..." - SAP ASE for Business Suite and SAP BW
- Note 2361809 - js_history and js_output table in sybmgmtdb growth issue - SAP ASE
- Note 1665820 - SYB:Job Scheduler logs for ATM are not truncated
- Note 1799477 - SYB:’sybmgmtdb’ database running out of space