How To Fix GC158 - Investment table and database inconsistent : &

GC158 - Overview

• Message type: E = Error

• Message class: GC - Error Messages for Consolidation/Extended General Ledger

• Message number: 158

• Message text: Investment table and database inconsistent : &

What causes this issue?

The book value entered in Changes in Investments does not correspond to
the value contained in the Totals table.

System Response

Capital Consolidation cancelled

How to fix this error?

Check the book values entered in the Investments table. The key of the
Investment table is shown in the error message.

Error message extract from SAP system. Copyright SAP SE.

GC158 - Details

• The SAP error message GC158 indicates that there is an inconsistency between the investment table and the database. This typically occurs in the context of Asset Accounting (FI-AA) or Investment Management (IM) modules, where the system expects certain data to be consistent across different tables and records.
  
  Cause:
  
  Data Corruption: This can happen due to data corruption during transactions, updates, or system migrations.
  Incomplete Transactions: If a transaction was not completed properly, it may leave the investment table in an inconsistent state.
  Custom Developments: Custom programs or enhancements that manipulate investment data may inadvertently cause inconsistencies.
  Database Issues: Problems with the underlying database, such as locks or failed updates, can lead to inconsistencies.
  
  
  Solution:
  
  Consistency Check: Use transaction codes like S_ALR_87012086 or S_ALR_87012087 to run consistency checks on the investment tables. This can help identify the specific inconsistencies.
  Reconciliation: Perform a reconciliation of the investment data. This may involve comparing the investment table with the corresponding database entries