3514470 - SCM jobs is taking long time and reporting error 1105 on saptempdb - SAP ASE for Business Warehouse

• SCM job involving BW infocubes is running slow and canceled.
• Checking from SM37 you'll see the details of related developer trace file, which is reporting messages 1105 on database saptempdb, similar to this:

                  C  (1105) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for objec
                  C  t 'temp worktable' in database 'saptempdb' because 'system' segment is full/has
                  C  no free extents. If you ran out of space in syslogs, dump the transaction log. O
                  C  therwise, use ALTER DATABASE to increase the size of the segment.
                  C
                  C  ERROR: -1 in function StartSelect (execute) [line 35006]
                  C  (3621) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Command has been aborted.
                  C
                  C  sql statement is ==>  select ..................................

• The mentioned "select" statement is a query with very high number of joins and tables/joins used (ie more than 40).

• SAP Adaptive Server Enterprise (ASE) 16.0
• SAP Supply Chain Management (SCM) 7.0
• SAP Business Warehouse (BW) - All versions

BW, SCM, APO, 1105, saptempdb, infocube, optimizer , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem