3804307 - BW Data Product Generator and Query Template Generator setup - Guided Answer

The purpose of the below Guided Answer is to provide help and information to analyse problems happening during the setup process of BW Data Product Generator and Query Template Generator in a SAP BW or SAP BW/4HANA system.

The decision tree addresses amongst others the following problems that can appear at various stages of the setup process, that is described in the Configuration Guide:

• *** WARNING => Connect to dspxyz.eu10.hcs.cloud.sap:443 failed: NIECONN_REFUSED
• 403 Access Denied
• 500 Internal Server Error - WebDynpro Exception: URL for redirect does not exist in HTTP allow list
• Authorization Request Error
• Authorization Request Error – OpenID provider cannot process the request due to configuration issues (redirect_uri does not match the configuration)
• Create Failed
• Create failed: plugin not active
• Error in BW: key spark not found in object
• HDLFS Configuration not successful
• HTTPIO_ERROR_CUSTOM_MYSAPSSO
• NIECONN_REFUSED or ICMECONNREFUSED
• Runtime error UNCAUGHT_EXCEPTION with exception CX_WD_GENERAL
• SSL handshake with … failed: SSSLERR_PEER_CERT_UNTRUSTED
• SSSLERR_ALERT_BAD_CERTIFICATE
• SSSLRC_CONN_CLOSED
• putBwPce failed error without additional details
• putBwPce failed: An error occurred: Tenant is missing licenses for Spark blocks or feature flag is not enabled.
• putBwPce failed: Capabilities mismatch for space type BWPCE: expected bwpce,hdlfStorage, got hdlfStorage
• putBwPce failed: Missing systemId
• putBwPce failed: The system with the id SID_0012345678 is not allowed
• putBwPce failed: You've reached the maximum number of 5 spaces with SAP HANA data lake files storage that can be created in a tenant.

• SAP Netweaver 7.50
• SAP BW/4HANA

KBA , BDC-BW , SAP BW (PCE) , BDC-BW-QRY , Query Template Generator , BDC-BW-ODC , BW integration in One Data Catalogue , Problem