SAP Knowledge Base Article - Preview

2616168 - CREATE STOGROUP SAPTMPGRP failed with SQL0104N

Symptom

  • Temporary Tablespace is growing to full. Temporary tablespaces are based on SMS infrastructure, they cannot be extended using a new stripe set. 
    Therefore, once one of the original storage paths is exhausted, no more space will be available to the temporary tablespace for future temporary objects.
    To fix this, creating SAP temporary group SAPTMPGRP which failed with the below error.
    ========================================
    CREATE STOGROUP SAPTMPGRP ON
    DB21034E  The command was processed as an SQL statement because it was not a
    valid Command Line Processor command.  During SQL processing it returned:
    SQL0104N  An unexpected token "END-OF-STATEMENT" was found following "TOGROUP
    SAPTMPGRP ON".  Expected tokens may include:  "<storage_path_or_drive_list>".
    SQLSTATE=42601

  •  Installation of gateway system failed with the above error.


Read more...

Environment

  • SAP on IBM Db2 for Linux, UNIX, and Windows
  • Database is using automatic storage
  • SAP NETWEAVER 7.4 / 740
  • SAP ERP 6.0

Product

SAP NetWeaver 7.4

Keywords

createStoGroupSAPTMPGRP, storage paths, tablespace, saptmp,  storage group , KBA , sapinst , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.