Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
aoi
Contributor

Re: Error using new BEX Connector v6.1.1

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

2 Replies
aoi
Contributor

Re: Error using new BEX Connector v6.1.1

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

Employee
Employee

Re: Error using new BEX Connector v6.1.1

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

Community Browser