SAP Knowledge Base Article - Preview

2352118 - DB6CONV: Errors SQL0204N and SQL0552N during conversion/reorganisation of data objects.

Symptom

  • SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name. 
  • SQL0552N "SAP<SID>" does not have the privilege to perform operation "CREATE TABLE". 
  • SQL0552N "SAP<SID>" does not have the privilege to perform operation "RENAME INDEX". 

    1.  DB6conv.log
          ONLINE CONVERSION: Start of Step 4 (SWAP)
          CALL SYSPROC.ADMIN_MOVE_TABLE( 'SAP<SID>', '<TABNAME>', '', '', 'SWAP' )ADMIN_MOVE_TABLE - SWAP step aborted.
          SQL0552N "SAP<SID>" does not have the privilege to perform operation "RENAME INDEX". SQLSTATE=42502
          Content (key,value) of SYSTOOLS.ADMIN_MOVE_TABLE

    2.  ST22_dump.log
          Database Interface Information:
          SQL0552N "SAP<SID>" does not have the privilege to perform operation "CREATE TABLE".
          CALL SYSPROC.ADMIN_MOVE_TABLE( 'SAP<SID>', '<source_tabname>', '<target_tabname>', '', 'INIT' ) SYSTEM( <SID> , SAP<SID> ) -- HASH_VALUE( XXXXXXXX )
          ABAP location info 'DB6CONVP', XXX

 


Read more...

Environment

  • DB2 LUW
  • SAP NetWeaver all versions

Keywords

SQL0552N, SQL0204N, DB6CONV, ADMIN_MOVE_TABLE, Aborted, Cancelled, authorizations, incorrect, OS, Reorganization, AMT , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , BC-DB-DB6-SYS , Database Interface/DBMS , 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.