SQL Server Performance

Processing Error

Discussion in 'SQL Server 2005 Analysis Services' started by emamuthu, Dec 12, 2006.

  1. emamuthu New Member

    Hi,
    While processing the cube in the server i got a error msg. I didn't get the msg when i processed the cube on my local server.


    rrors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_v_dim_CoverageGeography, Column: PolicyId, Value: 4239; Table: dbo_v_dim_CoverageGeography, Column: CoverageId, Value: 4315; Table: dbo_v_dim_CoverageGeography, Column: State, Value: CT; Table: dbo_v_dim_CoverageGeography, Column: Country, Value: US. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: v Dim Geography of Dimension: Geography from Database: Adhoc Analysis, Cube: EMRS, Measure Group: Coverage Geography, Partition: v Dim Coverage Geography, Record: 2501.

    Wht could it be & how can i resolve it.

    Thanks
    emamuthu
  2. smy New Member

    Here's the steps which might help you:
    1) look at the processing options
    2) at the 'Dimension key errors' tab, select the option 'Use custom error configuration' and change the settings to 'Convert to unknown'
  3. emamuthu New Member

    thanks for u'r reply..but i still have the error on the particular dim table.
    Do you think if i refersh the table the error might go.

  4. smy New Member

    quote:Originally posted by emamuthu


    rrors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_v_dim_CoverageGeography, Column: PolicyId, Value: 4239; Table: dbo_v_dim_CoverageGeography, Column: CoverageId, Value: 4315; Table: dbo_v_dim_CoverageGeography, Column: State, Value: CT; Table: dbo_v_dim_CoverageGeography, Column: Country, Value: US. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: v Dim Geography of Dimension: Geography from Database: Adhoc Analysis, Cube: EMRS, Measure Group: Coverage Geography, Partition: v Dim Coverage Geography, Record: 2501.

    you mean you still have the above error?
  5. ranjitjain New Member

    Hi,
    It seems, the values which are there in your OLTP table are not in the dimension yet.
    So firstly you full process all the dimensions and then process your measure groups.

Share This Page