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: 
JonnyPoole
Employee
Employee

Error using new BEX Connector v6.1.1

Hi,

We are able to successfully test a connection to the SAP server using the new BEX Connector with the minor update  6.1.1

But when we hit the 'select' button we get the following error:  " row with the same key already exists "

We looked at the logs and found this information from the time we tested.

Any ideas ?

-------------------------------------------------

15:21:12,584 [1] - Setup Connection

15:21:12,584 [1] - Connection string: ASHOST=[*REMOVED*] CLIENT=[400] SYSNR=[00] TIMEOUT=[3600] SNC_MODE=[false] SNC_QOP=[9]

15:21:12,589 [1] - Connected

15:21:12,611 [1] - SAP Transport information: version: B7DK900073; date: 2015-11-09; time: 14:47:21; SAP basis: 700;

15:21:14,980 [1] - Setup Connection

15:21:14,980 [1] - Connection string: ASHOST=[*REMOVED*] CLIENT=[400] SYSNR=[00] TIMEOUT=[3600] SNC_MODE=[false] SNC_QOP=[9]

15:21:14,982 [1] - Connected

15:21:14,985 [1] - SAP Transport information: version: B7DK900073; date: 2015-11-09; time: 14:47:21; SAP basis: 700;

15:21:16,847 [1] - GetInfoProviders

15:21:16,847 [1] - Setup Connection

15:21:28,363 [1] - Error in GetTables: A row with the same key already exists.

15:21:28,363 [1] - Error: RfcAbapRuntimeException

15:21:28,363 [1] - Teardown Connection

15:21:28,373 [1] - Error in select editing.

SAP.Middleware.Connector.RfcAbapRuntimeException: A row with the same key already exists.

   at SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()

   at SAP.Middleware.Connector.RfcConnection.ReadBytes(Byte* buffer, Int32 count)

   at SAP.Middleware.Connector.RfcConnection.ReadRfcIDBegin(Int32& length)

   at SAP.Middleware.Connector.RfcConnection.ReadUpTo(RFCGET readState, RfcFunction function, RFCID toRid)

   at SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function)

   at SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream)

   at SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, IRfcIOStream stream, RFCID rid)

   at SAP.Middleware.Connector.RfcFunction.Invoke(RfcDestination destination)

   at Qlik.Connectors.SAP.SapBexConnection.GetTables(String functionName, List`1 tableStrings, NameValueCollection paramCollection)

1 Solution

Accepted Solutions
mats_olin
Employee
Employee

Try running ANALYZE_RSZ_TABLES in SE38 to look for duplicates in table RSZELTDIR / Mats

View solution in original post

2 Replies
mats_olin
Employee
Employee

Try running ANALYZE_RSZ_TABLES in SE38 to look for duplicates in table RSZELTDIR / Mats

JonnyPoole
Employee
Employee
Author

Thanks mats ... there were indeed multiple components with the same name. Addressing that will be the next step before retesting the connector