SAP Knowledge Base Article - Preview

2419270 - Duplicate SIDs in table /BI0/SIOBJNM and/or /BI0/SINFOPROV

Symptom

  • There are different infoObjects share the same SID value in system table /BI0/SIOBJNM, for example:
    IOBJNM SID 
    1KYFNM 108
    2C-EBELN 108
  • BW system may hit different errors such as:
    • When add ODATA service in transaction, get Error:
      Metadata not loaded - See /IWBEP/ERROR_LOG in backend 'LOCAL' - Query xxxx is invalid or contains errors....
      Message no. /IWFND/MED024
    • run a query, get error:
      An exception with the type CX_SY_ITAB_DUPLICATE_KEY occurred, but was neither handled locally, nor declared in a RAISING clause
      Error A row was to be added that would have lead to a duplicate of the ID key. RS_EXCEPTION 000
      Information CL_RSD_IOBJ_PROP_CACHE >> Row: Inc: 162 Prog: PREFILL_CACHE RS_EXCEPTION 301
      Cancel Error when generating dataProvider BRAIN 282
    • System gets a short dump of: (for example, when activate a real time cube)
      Category ABAP Programming Error
      Runtime Errors ITAB_DUPLICATE_KEY
      Except. CX_SY_ITAB_DUPLICATE_KEY
      ABAP Program CL_RSD_IOBJ_PROP_CACHE========CP
      Application Component BW-WHM-MTD

    • Run LISTCUBE, although the infoprovider is active you get error of:
      InfoProvider xxx is not active; check the entries
      Message No. DBMAN203
    • DTP load failed for error:

      Data package processing terminated
      An exception with the type CX_SY_ITAB_DUPLICATE_KEY occurred, but was neither handled locally, nor declared in a RAISING clause
      Error while extracting from source xxx (type InfoCube)
      Data package processing terminated

  • In transaction SNRO, the number range object BIM9999991 for characteristic 0IOBJNM has a big current value. The from number might be set with a big value, too. There is a key figure with a SID of more than 7 digits and aggregation is set to MIN or MAX in RSD1. When run a query using this key figure, the query generation fails with syntax error in RSR_BAD_CODING:
    The name "<G_S_DATA_MM_Z____xxxxxxxx_MAX>" is longer than the allowed 30 characters.
    or
    The name "<G_S_DATA_MM_Z____xxxxxxxx_MIN>" is longer than the allowed 30 characters.


Read more...

Environment

  • BW
  • Release independent

Product

SAP NetWeaver all versions ; SAP S/4HANA all versions

Keywords

/IWFND/MED 024, RS_EXCEPTION000, RS_EXCEPTION301, BRAIN282,  DBMAN 203, The name XXX is longer than the allowed 30 characters,  , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-WHM-MTD , Metadata (repository) , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.