Key has already been loaded - removing duplicates from a dimension

Key has already been loaded - removing duplicates from a dimension

From:

Sudharshan Chary [mailto:schary@datavisiontech.com]
Sent: Tuesday, October 23, 2018 10:06 AM
Subject: DV Internal: (FIXED) POS2 Discount Issue on MOBI

 

Hello all,

 

Just recapping how I fixed the issue with Yovany’s help.  Basically, when I opened the POS2Discounts dimension in Dim Manager, it gave me an error saying “key has already been loaded” or something. Essentially this means, there are duplicates at some level.

 

So we ran the query:

select allelements from  dimPOS2Discount  GROUP BY ALLELEMENTS HAVING COUNT(*) > 1

 

This gave me 12 records, which we are all rollups (IsLeaf = 0), which was basically 6 records duplicated twice. I verified by just searching for those entries:

 

SELECT * FROM dimPOS2Discount WHERE ALLELEMENTS IN

('Complimentary',

'Discount 40%',

'JP Morgan Corp Disc 10%',

'Member Retail 10%',

'Summer Treats',

'Training ')

 

Sure enough, each one showed up twice. I deleted ONE of each duplicate

Select from dimPOS2Discount where POS2Discountkey in

(997,1038,2005,1500,2914,1443)

 

Reloaded from database and processed the dimension.


    • Related Articles

    • Steps to Fix Rigid Relationships Error

      First search and open Visual Studio        ·         Go to “File” in the top left corner, then go to “Open”, and click on “Analysis Service Database” ·         Select the Datavision Database and click “OK” ·         It will take a couple of minutes ...

    • DVAlert Error - Number of records don't match between tmp and inc...

      So, DVAlert is failing, the message is something like this: "IdBatch: 658 The numbers of records between tmpfactPMSBOB and incfactPMSBOB not match for cube PMS BOB" The problem is most likely that one of more of the dimensions has duplicate All ...

    • DV Training Webinars

        http://www.datavisiontech.com/webinar.htm We find it useful if you open a session of Excel on one screen and the webinar on a secondary screen.  This allows the user to follow along with the exercises on the screen with your data in the Excel ...

    • Code Only and Description Attribute update for Loews

      This is how you can update the Code Only and Description Attribute for Loews - Open the Dim Manager on Loews SQL Open the PMS Rate Code dimension Click on the Attribute button at the top of the screen At the bottom of the Attribute screen, there is ...

    • MOHG/MOBI Cloud Patch Process

      MOBI Cloud Patch process     11 AM – 11:15 AM – Stop DVAlert services (There are three, DVAlert, DVAlert Market, DVAlert MOMLN) Login Open each manager, click the stop button, wait for clear Open services, stop each dvalert and set to Manual restart ...