Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
6 Replies
jakob_rasmussen
Contributor III
Contributor III

Hi Kaushik,

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

Best regards,

Jakob

mats_olin
Employee
Employee

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
tobivogt
Partner - Contributor III
Partner - Contributor III

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

======

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

Thanks Tobias,

I will try and let you know.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

Hi, did you find a solution? 

Same issue with Qlikview Desktop 12.5 and SAP Conccector 7.0.3.

 

Please help.