How To Fix CRM_MKTLIST_ADMIN059 - External list &1 with logical system &2 still exists as a deleted list

SAP Error Message - Details

• Message type: E = Error

• Message class: CRM_MKTLIST_ADMIN - CRM Marketing: Messages External List Management

• Message number: 059

• Message text: External list &1 with logical system &2 still exists as a deleted list

What causes this issue?

You wanted to create an external list with the ID &V1& and logical
system &V2&

System Response

This external list is already deleted.
The combination of ID and logical system for a list can no longer be
used after deletion.

How to fix this error?

Change the external list field (database field LIST_ID) or the logical
system for your external list.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message CRM_MKTLIST_ADMIN059 - External list &1 with logical system &2 still exists as a deleted list ?

  The SAP error message CRM_MKTLIST_ADMIN059 indicates that there is an external list that has been marked as deleted but still exists in the system. This can occur in the context of managing marketing lists in SAP Customer Relationship Management (CRM).
  Cause:
  The error typically arises when:
  
  An external marketing list has been deleted, but the system still retains references to it.
  There may be inconsistencies in the database where the list is not fully removed from the system.
  The logical system specified in the error message is still holding onto the deleted list, which can happen due to replication issues or incomplete deletion processes.
  
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Check the External List:
  
  Use transaction code CRMD_ORDER or CRMD_ORDERADM_H to check if the external list still exists in the system.
  You can also use transaction CRMD_MKTLIST to view marketing lists.
  
  
  
  Delete the External List:
  
  If the list is still present, you may need to delete it properly. Ensure that you have the necessary authorizations to perform this action.
  Use the appropriate transaction to delete the list, ensuring that it is removed from all relevant tables.
  
  
  
  Check Logical System Configuration:
  
  Verify the configuration of the logical system mentioned in the error message. Ensure that it is correctly set up and that there are no inconsistencies.
  You can check the logical system settings in transaction SALE or SPRO.
  
  
  
  Database Cleanup:
  
  If the list is not visible in the application but the error persists, you may need to perform a database cleanup. This could involve running specific reports or programs that clean up orphaned entries.
  Consult with your SAP Basis team or use transaction SE38 to run any relevant cleanup programs.
  
  
  
  Check for Replication Issues:
  
  If your system is integrated with other systems (like SAP ECC or other CRM systems), check for any replication issues that might be causing the list to appear as deleted in one system but still exist in another.
  
  
  
  Consult SAP Notes:
  
  Look for any relevant SAP Notes that might address this specific error. You can search the SAP Support Portal for notes related to CRM_MKTLIST_ADMIN059.
  
  
  
  Contact SAP Support:
  
  If the issue persists after trying the above steps, consider reaching out to SAP Support for further assistance. Provide them with the error message details and any steps you have already taken.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as CRMD_ORDER, CRMD_MKTLIST, and SE38.
  SAP Documentation: Review SAP documentation related to marketing lists and CRM data management for best practices.
  User Authorizations: Ensure that you have the necessary authorizations to view and delete marketing lists in the system.
  
  By following these steps, you should be able to resolve the error and ensure that the external list is properly managed within your SAP CRM system.