SAP Knowledge Base Article - Preview

2419270 - Duplicate SIDs in table /BI0/SIOBJNM

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

Keywords

/IWFND/MED 024, RS_EXCEPTION000, RS_EXCEPTION301, BRAIN282,  DBMAN 203 , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-WHM-MTD , Metadata (repository) , How To

About this page

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

Search for additional results

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