topic Re: Error when connecting Qlik SAP Connector 8.0.1 in Connectivity & Data Prep

Error when connecting Qlik SAP Connector 8.0.1

KeyReaL — Tue, 31 May 2022 10:49:56 GMT

After installation and settings in accordance with the instructions, when connecting, to the SAP system, errors occur, please help in the solution.

The course of our actions:

Work on the Qlik Sense server

Installing the latest version of Qlik Sap Connector version 8.0.1
Put the ports to the file "Services"

In our case, I prescribed DNS suffixes in a network connection
Installation of the MS C ++ 2010 SP1 libraries package for SQL queries
Activated the SAP connector license

Work on the SAP ERP server (version 753)

Installation of transport files for SAP ERP and BW (attachments - "version SAP", "Transport files")

Creation of a user with the type "Service", purpose of roles in mask: Qtqv* (attachments - "Role for User")
SapRouter - is not used on our server

Connection

Connection setting via SAP Connector
Error after connection(attachments - "Erorr OpenStream failed")

Info: 1. We use the version: Qlik Sense Enterprise on Windows 14.28.10 (August 2021 Patch 4)

2.MS Windows Server 2016

Re: Error when connecting Qlik SAP Connector 8.0.1

Hakan_Ronningberg — Tue, 31 May 2022 06:02:32 GMT

Hi,

Maybe you have not assigned the roles to the Qlik SAP user that you use when creating the connection? Check page 36 (for the SQL connector) in the attached document.

Regards,
Håkan

Re: Error when connecting Qlik SAP Connector 8.0.1

KeyReaL — Tue, 31 May 2022 06:13:26 GMT

Hello,

Thanks for the answer.

At the moment, I have already appointed all the possible roles specified in the instructions (see the attachment "Role for User.jpg")

QTQVCACCESS
QTQVCADMIN
QTQVCBWACCESS
QTQVCEXTRACTOR
QTQVCEXTRADM
QTQVCEXTRSETUP

since separately (as indicated for different users of the role) also does not help.

Regards, Kirill

Re: Error when connecting Qlik SAP Connector 8.0.1

Hakan_Ronningberg — Tue, 31 May 2022 06:32:45 GMT

Hi again,

Strange. The error message indicates that your SAP user does not have enough authorization. When the roles are assigned correctly to the user, this error should not occur.

Regards,
Håkan

Re: Error when connecting Qlik SAP Connector 8.0.1

KeyReaL — Wed, 01 Jun 2022 12:54:32 GMT

Good day.

The problem was solved with the connection solved. Maybe someone will come in handy....

I contacted BASIS specialists, watched the roles of authorization (Qtqvcaccess), found the lack of a line of the “functional module”. They trace the user connection in the SAP system and found errors on some objects and fields, added them to the role in the "functional module" field After updating this role, the repeated entrance was successful, the SAP system tables opened.