Error when connecting Qlik SAP Connector 8.0.1

[KeyReaL]

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:

1. 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
  

2. 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
  

3. 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

[Hakan_Ronningberg]

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

[KeyReaL]

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

[Hakan_Ronningberg]

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

[KeyReaL]

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.