SAP Knowledge Base Article - Preview

3423866 - System rename - SWPM, CALL SYSPROC.ADMIN_TASK* fails with SQL0901N and/or SQL0803N  

Symptom

During a system rename with SWPM,
Step: CALL SYSPROC.ADMIN_TASK_REMOVE ('SAPTOOLS.DBH_UOW_COLLECT', NULL) fails with the error SQL0901N  The SQL statement or command failed because of a database system error. (Reason "Key to Data Mismatch Error".)  

Step: CALL SYSPROC.ADMIN_TASK_ADD ('SAPTOOLS.DBH_UOW_COLLECT', NULL, NULL, NULL, '*/1 * * * *', 'SAPTOOLS', 'DBH_UOW_COLLECT', NULL, NULL, NULL) fails with the error
SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "SYSTOOLS.ADMINTASKS" from having duplicate values for the index key.  

 

 


Read more...

Environment

Db2 LUW IBM
BC-INS-SWPM

Product

SAP NetWeaver all versions

Keywords

DB2ATS, DCF , KBA , 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.