Message type: E = Error
Message class: MH - Maintain Material Master Data (Retail)
Message number: 173
Message text: Database error during mass delete from table MPOI
A database error occurred during the mass deletion of data from table
MPOI.
The system issues an error message and will not allow you to continue with this transaction until the error is resolved.
If the error is due to the rollback segment being too small, you can
extend it and rerun program MMXPRA14 after upgrading.
If it is not possible to extend the rollback segment, you can modify
the program to reduce the number of data records processed for each
commit block.
You do this by changing program MMXPRA14 as follows:
CONSTANTS
MAX_ANZ_SAETZE TYPE I VALUE 2500. "Max. SStze pro Commit-Block <<Delete
MAX_ANZ_SAETZE TYPE I VALUE 1000. "Max. SStze pro Commit-Block <<Insert
Error message extract from SAP system. Copyright SAP SE.
MH173
- Database error during mass delete from table MPOI ?The SAP error message MH173, which indicates a "Database error during mass delete from table MPOI," typically arises during operations that involve mass deletion of entries from the MPOI table (which is related to material master data in SAP). This error can be caused by several factors, including database constraints, locks, or issues with the data itself. Causes: Database Constraints: There may be foreign key constraints or other database integrity constraints that prevent the deletion of certain records. Locks: The records you are trying to delete may be locked by another transaction or user, preventing the mass delete operation from completing. Data Integrity Issues: There may be inconsistencies or corruption in the data that are causing the delete operation to fail. Insufficient Authorizations: The user executing the delete operation may not have the necessary authorizations to perform mass deletions on the MPOI table. Database Performance Issues: If the database is under heavy load or if there
Get instant SAP help. Sign up for our Free Essentials Plan.
MH172
Database error during mass insert in table MABW
What causes this issue? A database error occurred during the mass insertion of data in table MPOI.System Response The system issues an error message...
MH171
Program &; client &
What causes this issue? A database error occurred for client &V2& while XPRA program &V1& was converting the change pointers from tab...
MH174
The material type & is not allowed for value-only materials
What causes this issue? You have specified a material category that is allowed only for <DS:GLOS.value-only_material>value-only materials</&...
MH175
The listing end is not allowed to be in the past
What causes this issue? You wanted to carry out the listing operation. However, you have specified a date in the past as the end of listing. If you c...
Click on this link to search all SAP messages.