While executing the SUM activity, the execution is stop at DBCHK_PRE stage with the error message “A User/Schema mismatch was found in your SAP database”.
Solution
As stated from the above screenshot, please follow SAP Note 1086375 to resolve the issue.
First of all, check whether the user is still the owner of other schema in the database. Use below SQL command to check this:
use SID
select * from sys. schemas where principal_id = user_id('schema')
If the system returns more than one line as the result, create a customer message under the component BC-DB-MSS and request a manual correction for the inconsistency. If the above command returns only one line, you can use the script attached from the note to perform the repair.
In our case, the output return with one line and below steps to be follow.
- Perform the full database backup.
- Bring down the SAP system.
- Load the attached script from the SAP Note and edit the below line to your own database sid.
set @SchemaToFix = ‘your_sid’ - Run the script.
- The execution will take some time and ensure the space of the transaction log is sufficient (up to 1GB). Once the repair is completed, use the SQL command below to check if the repair was successful. select * from sys.schemas where name = ‘schema’
