How To Fix WEBI_CHECKS101 - Consistency of Service Definitions (Administrative Data)

SAP Error Message - Details

• Message type: E = Error

• Message class: WEBI_CHECKS - WEBI Checks

• Message number: 101

• Message text: Consistency of Service Definitions (Administrative Data)

What causes this issue?

The purpose of this check is to report inconsistencies in Administrative
Data of Service Definitions (table WSHEADER).
Table WSHEADER contains redundant data only. The content of table
WSHEADER can be calculated from data stored in other tables.
The content from WSHEADER was transported using table WSHEADER_DARK and
copied to WSHEADER with help of an after import method. Especially in
case of problems during import WSHEADER might not have been updated.

System Response

Inconsistent entries are reported.

How to fix this error?

Use Report <DS:REPN.WEBI_REPAIR>WEBI_REPAIR</> to repair the service
definition (<DS:RE.WEBI_REPAIR>report documentation</> ).

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 WEBI_CHECKS101 - Consistency of Service Definitions (Administrative Data) ?

  Certainly! Here's a detailed explanation regarding the SAP error message WEBI_CHECKS101: Consistency of Service Definitions (Administrative Data):
  
  Error Message
  WEBI_CHECKS101: Consistency of Service Definitions (Administrative Data)
  
  Cause
  This error typically occurs in SAP BusinessObjects Web Intelligence (WebI) environments and relates to inconsistencies or corruption in the service definitions or administrative data within the CMS (Central Management Server) repository.
  More specifically:
  
  The error indicates that the service definitions stored in the CMS database are inconsistent or corrupted.
  This can happen due to:
  
  Incomplete or failed upgrades/patches of the BusinessObjects platform.
  Manual changes or corruption in the CMS database.
  Mismatched versions of services or components.
  Issues during migration or restoration of the CMS repository.
  Problems with the CMS database connectivity or integrity.
  
  
  
  
  Impact
  
  Web Intelligence reports or services may fail to run or behave unpredictably.
  Administrative operations related to service definitions may not complete.
  The CMS may not be able to properly manage or instantiate certain services.
  
  
  Solution / Resolution
  
  
  Check System and Patch Levels:
  
  Verify that all BusinessObjects components (CMS, WebI, etc.) are on compatible patch and support pack levels.
  Ensure that no partial or failed upgrade has left the system in an inconsistent state.
  
  
  
  Restart CMS and Related Services:
  
  Sometimes, restarting the CMS and dependent services can clear transient inconsistencies.
  
  
  
  Run CMS Database Consistency Checks:
  
  Use the cmsdbcheck tool (if available) to check and repair the CMS database.
  This tool can identify and fix inconsistencies in the CMS repository.
  
  
  
  Restore from Backup:
  
  If the CMS database is corrupted beyond repair, restoring from a known good backup may be necessary.
  
  
  
  Reinstall or Repair Installation:
  
  In some cases, repairing the BusinessObjects installation or reinstalling components may be required.
  
  
  
  Check Logs for More Details:
  
  Review the CMS and WebI server logs for more detailed error messages.
  Look for stack traces or related errors that can pinpoint the root cause.
  
  
  
  SAP Notes and Support:
  
  Search SAP Support Portal for notes related to WEBI_CHECKS101.
  For example, SAP Note 000XXXXX (replace with actual note number if available) may provide patches or detailed instructions.
  If unresolved, open a support ticket with SAP, providing logs and system details.
  
  
  
  
  Related Information
  
  CMS Database: The Central Management Server database stores all configuration and administrative data for BusinessObjects. Its integrity is critical.
  Service Definitions: These define how various services (like WebI processing, scheduling, etc.) operate within the platform.
  Upgrade/Migration: Always follow SAP recommended procedures for upgrades and migrations to avoid repository inconsistencies.
  Backup: Regular backups of the CMS database are essential to recover from corruption.
  Tools: cmsdbcheck and cmsdbrepair are command-line tools provided by SAP for database consistency checks.
  
  
  Summary
  
  
  
  Aspect
  Details
  
  
  
  
  Error
  WEBI_CHECKS101: Consistency of Service Definitions (Administrative Data)
  
  
  Cause
  Inconsistencies or corruption in CMS service definitions due to upgrade, migration, or DB issues
  
  
  Solution
  Verify patch levels, restart services, run CMS DB consistency checks, restore backup, consult SAP Notes
  
  
  Related Info
  CMS database integrity, service definitions, upgrade best practices, SAP support tools
  
  
  
  
  If you provide more context (e.g., when the error occurs, system version), I can help tailor the troubleshooting steps further.