SAP Knowledge Base Article - Preview

2450303 - Infocube compression job cancelled after system exception ERROR_MESSAGE - SAP BW on ASE

Symptom

  • The last version of the SYB SAP BW Correction Collection is implemented on your system.
  • Compression job is terminating returning "Report RSCOMP1 ended with errors RSM1 798 E" on SM37 log:

02.04.2017 21:39:05 Collapse terminated: Data target <infocube>, from to 67615 RSM 747 S
02.04.2017 21:39:06 Report RSCOMP1 ended with errors RSM1 798 E
02.04.2017 21:39:06 Job cancelled after system exception ERROR_MESSAGE 00 564 A

  • Checking the related work process file , error SQL1105 is returned:

C Sun Apr 02 21:37:14 2017
C ERROR: -1 in function ExeNormalModify (execute) [line 25682]
C (1105) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for objec
C t 'syslogs' in database '<SID>' because 'logsegment' segment is full/has no free e
C xtents. If you ran out of space in syslogs, dump the transaction log. Otherwise,
C use ALTER DATABASE to increase the size of the segment.
C
C ERROR: -1 in function ExeNormalModify (execute) [line 25682]
C (7412) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Space available in the log seg
C ment has fallen critically low in database '<SID>'. All future modifications to t
C his database will be aborted until the log is successfully dumped and space beco
C mes available.
C
C sql statement is ==> insert into "<E table>" ( ..... ) from "<E Tabe>" where ....
....... " plan ' (use optgoal sap_olap) (use fac
C t_table F) (use ins_by_bulk on) '

C /* R3:CL_SQL_STATEMENT==============CP:1103 T

C :<E table> M:500 */
C
C transaction aborted by server
M *** WARNING => big time diff 2746384513 [1879782507 331199724] for stamp STAT_INSERT, correct ???
C dbdssyb: DBSL99 SQL7412
C [ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'syslogs' in database '<SID>'
C [ASE Error SQL7412][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Space available in the log segment has fallen critically low
C


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions 

Product

SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

SQL1105, 1105, compression, partitioning, RSCOMP1 , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

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.