How To Fix WEBI_CHECKS102 - Consistency of Service Definitions (Where-Used List)

SAP Error Message - Details

• Message type: E = Error

• Message class: WEBI_CHECKS - WEBI Checks

• Message number: 102

• Message text: Consistency of Service Definitions (Where-Used List)

What causes this issue?

The purpose of this check is to report inconsistencies in Where-Used
List of Service Definitions (table VEPCROSSREF).
Table VEPCROSSREF contains redundant data only. It can be calculated
from other data.

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_CHECKS102 - Consistency of Service Definitions (Where-Used List) ?

  Certainly! Here's a detailed explanation for the SAP error message WEBI_CHECKS102: Consistency of Service Definitions (Where-Used List):
  
  Error Message
  WEBI_CHECKS102: Consistency of Service Definitions (Where-Used List)
  
  Cause
  This error typically occurs in SAP BusinessObjects Web Intelligence (WebI) when there is an inconsistency or corruption in the service definitions related to the "Where-Used List." The "Where-Used List" is a feature that tracks dependencies and usage of objects (like universes, reports, queries, etc.) within the BI platform.
  The root causes can include:
  
  Corrupted or inconsistent metadata in the repository or CMS database.
  Incomplete or failed upgrade/migration of the BI platform or WebI components.
  Issues with the WebI service definitions or configuration files.
  Cache or temporary data corruption in the BI platform.
  Mismatch between service definitions and actual deployed services.
  
  
  Solution
  To resolve the WEBI_CHECKS102 error, you can try the following steps:
  
  
  Restart BI Services:
  
  Restart the Central Management Server (CMS) and all related BI services to clear any temporary inconsistencies.
  
  
  
  Clear Cache and Temporary Files:
  
  Clear the Web Intelligence cache and temporary files on the server.
  Also, clear the browser cache if accessing WebI via web.
  
  
  
  Check and Repair Repository:
  
  Use the CMS database repair tools or run consistency checks on the CMS database.
  If you have a backup, consider restoring the CMS database to a consistent state.
  
  
  
  Re-import or Re-deploy Service Definitions:
  
  Re-import the WebI service definitions or re-deploy the WebI application to ensure service definitions are consistent.
  This might involve re-installing or patching the WebI components.
  
  
  
  Apply Latest Patches/Support Packs:
  
  Check SAP Notes and apply the latest patches or support packs for your SAP BusinessObjects version.
  Sometimes, this error is fixed in later patches.
  
  
  
  Check Logs for More Details:
  
  Review the WebI server logs and CMS logs for more detailed error messages.
  Logs can provide clues about which service definitions are inconsistent.
  
  
  
  Contact SAP Support:
  
  If the problem persists, open a ticket with SAP Support providing logs and system details.
  SAP may provide a specific fix or patch.
  
  
  
  
  Related Information
  
  Where-Used List: This feature helps administrators and developers understand dependencies between BI objects. Consistency in service definitions is critical for this feature to work correctly.
  SAP Notes: Search SAP Support Portal for notes related to WEBI_CHECKS102 or service definition consistency.
  BI Platform Upgrade: Ensure that all components are upgraded together to avoid mismatches.
  Backup: Always maintain backups of CMS database and configuration before performing repairs or upgrades.
  
  
  Summary
  
  
  
  Aspect
  Details
  
  
  
  
  Cause
  Inconsistent or corrupted WebI service definitions related to the Where-Used List.
  
  
  Solution
  Restart services, clear cache, repair CMS database, re-import service definitions, apply patches.
  
  
  Related Info
  Check logs, SAP Notes, ensure consistent upgrades, maintain backups.
  
  
  
  
  If you provide your SAP BusinessObjects version and environment details, I can help you find more specific SAP Notes or patches related to this error.