Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Qlik SAP BW Connector Error - "Handling of duplicate Keys not possible."

Dear Experts,

I need your help in understanding and solving the issue which I have recently faced. Below is the Problem Statement.

Background:

I am using QlikView version 11.20 SR 10

SAP Connector version 5.80 SR4

SAP BW version 7.40

SAP Database Hanna

Problem :

I am connecting to SAP BW and Qlik using SAP connector. While extracting data I am getting error as below.

"Key: [0PROFIT_CTR].[ has been assigned KeyPos: -1 in c.m_HierarchyKeys. Thus, the Key already exists in c.m_HierarchyKeys. Handling of duplicate Keys not possible."

I dont know what this error is all about. Also have no idea about whether this is a Qlik SAP connector issue or SAP side issue.

I have attached the log file for your Reference.

Request you all to help me.

Thanking you,

Kaushik Solanki

5 Replies
jakob_rasmussen
New Contributor III

Re: Qlik SAP BW Connector Error - "Handling of duplicate Keys not possible."

Hi Kaushik,

We're facing a similar error here. Have you been able to find a solution since you posted this?

Best regards,

Jakob

Employee
Employee

Re: Qlik SAP BW Connector Error - "Handling of duplicate Keys not possible."

Hi, I believe that you have a hierarchy leaf or node that is duplicated in the selected hierarchy for 0PROFIT_CTR (TEST_GLOBAL MIS HIERARCHY_BO). This leads to an error in the extraction in the OLAP connector. If possible: remove the duplicate from the hierarchy (should it be there?). Otherwise: Register a case with Qlik Support.

/ Mats

Re: Qlik SAP BW Connector Error - "Handling of duplicate Keys not possible."

Hi Jakob,

I had filed a case with Qlik Support and they confirm that its a Bug.

Hope to see the bug fixed in next service release of SAP connector.

Regards,

Kaushik Solanki

tobivogt
New Contributor III

Re: Qlik SAP BW Connector Error - "Handling of duplicate Keys not possible."

Hi Kaushik,

if this is confirmed as a bug, try to use only the Profit Center values as a plain field without hierarchy and export hierarchy via Extractor Connector.

Maybe this might be a workaround until it's fixed.

Regards,

Tobias

======

Re: Qlik SAP BW Connector Error - "Handling of duplicate Keys not possible."

Thanks Tobias,

I will try and let you know.

Regards,

Kaushik Solanki