How To Fix MCEX167 - Update mode changed directly from delta -> Note long text

MCEX167 - Overview

• Message type: E = Error

• Message class: MCEX - Extraction Interface LIS/BW

• Message number: 167

• Message text: Update mode changed directly from delta -> Note long text

What causes this issue?

You changed the update mode to "Delta Direct". Note that a
significantly high amount of entries is created in the BW delta queue
(see the <DS:TRAN.RSA7>BW Delta Queue Maintenance</>).

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

How to fix this error?

It might be necessary to load data more frequently than once a day into
the BW system (but not more often than once an hour).
Also note the following special features when setting up the
DataSources for the BW system:
AFter the set-up run in the OLTP system, at least one successful
initialization request for each DataSource needs to happen before you
can make document changes. Otherwise, delta information is
irretrievably lost.
<ZH>Important</>:
Before transporting the customizing requests for changing the update
mode in other systems, you <ZH>must</> check to see that no more
entries exist in the queue MCEX&V1&. It is possible to check the target
system in the logistics queue overview (transaction LBWQ).

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message MCEX167 - Update mode changed directly from delta -> Note long text ?

  The SAP error message MCEX167 indicates that there has been a change in the update mode of a data source from "delta" to "full" or "initial" without following the proper procedures. This typically occurs in the context of SAP BW (Business Warehouse) when dealing with data extraction from SAP ERP or other sources.
  
  Cause:
  The error arises when:
  
  A delta data source is being used, but the system detects that the update mode has been changed directly to a non-delta mode (like full or initial).
  This can happen if the data source is not properly configured or if there are inconsistencies in the data extraction settings.
  It may also occur if there are changes made to the data source in the source system that are not reflected in the BW system.
  
  
  Solution:
  To resolve the MCEX167 error, you can follow these steps:
  
  
  Check Data Source Settings:
  
  Go to the Data Source in the SAP BW system and verify its