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 Sybase ASE Database Platform , Problem

About this page

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

Search for additional results

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