SAP Knowledge Base Article - Preview

2326023 - SQL0601

Symptom

Case 1) During a table conversion, the ALTER TABLE statement fails with SQL0601 while creating the Primary key.

    In the activation log, you find the following error

    | sql: |
    | | ALTER TABLE R3<SID>DATA/'<table_name>' |
    | | ADD CONSTRAINT '<table name>+0' primary key |
    | | ('MANDT', |
    | | 'DOCID', |
    | | 'ITEMID') |
    | | SQL0601 - "<table_name>+0" in R3<SID>DATA type *N already exists
    | | ts. (582346/<SID>ADM/WPXX) |
    | | DDL Time(___2): ........70 milliseconds |
    | | The SQL statement was not executed |
    | | Statements for Table <table_name> could not be executed |
    | | Request for <table_name> could not be executed |

    Where <SID> is the System ID of the SAP system and <table_name> is the SQL table name

================================================================================

Case 2) During an update with SUM, you may encounter the problem in the DBCLONE phase. The logs show a number of tables are affected.

ALTER TABLE R3<SID>DATA/"/OSP/T_RAUI_CTGT?" ADD CONSTRAINT "/OSP/T_RAUI_CTGT+0" primary key ("MANDT", "LANG", "CAT_ID") 
1EETGCLN
SQL0601 - "/OSP/T_RAUI_CTGT+0" in R3<SID>DATA type *N already exists. (543551/<SID>ADM/WP14)
1EETGCLN /OSP/T_RAUI_CTGT
1EETGCLN
Error when cloning table structure

  Where <SID> is the System ID of the SAP system and <table_name> is the SQL table name

                                        
================================================================================

Case 3) During an update with SUM, in rare conditions an SQL0601 can be observed for SAP tables or views

SQL-error "-601-SQL0601 - "/UIF/LREPVC" in R3<SID>DATA type *FILE already exists.

In some cases, querying the catalog view SYSTABLES or SYSVIEWS does not find the system name of the object.

================================================================================

Case 4)
During an SP update with SPAM, the creation of database views ends with SQL0601 (File already exists) and SQL0204 (File not found)

================================================================================


Read more...

Keywords

AS/400, OS/400, system i, i5/OS, IBM i, Import_Proper, RC 08, return code 8 , KBA , BC-DB-DB4 , DB2 for AS/400 , BC-OP-AS4 , IBM AS/400 , 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.