cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Cannot Connect Analysis for Office 2.4SP4 to SAP HANA SP12 directly

former_member512307
Discoverer

‎08-23-2017 3:53 PM - edited ‎02-04-2024 12:59 AM

0 Kudos

Dear expert,

I applied the following tutorial

https://archive.sap.com/documents/docs/DOC-64277 to setup a connection between analysis for office and HANA

I can logon, but blank screen appears forever

2017-08-23-10-48-31.png

Is some of us already face this issue?

If you need more information, please let me know.

Many thanks in advance for your help.

Kind regards

Show replies
Show replies
TammyPowlas
Active Contributor
‎08-27-2017 8:23 PM
0 Kudos

Fred - sorry for the delay in replying - could it be a firewall issue? Can other applications connect to SAP HANA?

former_member512307
Discoverer
‎09-07-2017 3:57 PM
0 Kudos

Hi Tammy,

Thanks for your advices. Unfortunately, it is not firewall issue.

We did further checks, there is no firewall filtering on the port 8008 (80<instance_number>) in our landscape.

To be 100% sure, we installed AO 2.4SP4 on a remotedesktop on the same network as the HANA server. I face the same issue. A blank screen after the logon.

Excel, Lumira and analysis for OLAP can connect to HANA and get data.

Many thanks in advance for your help.

Kind regards

former_member512307
Discoverer
‎09-07-2017 4:05 PM
0 Kudos

Dear expert,

I went a bit further on this issue

Step 0: Install AO 2.4 SP4 on a remotedesktop without any firewall through HANA

Same Issue, authentication OK, blank screen

Step 1: Applied the following note:

  • SAP Note 2097965 - Additional setting for using the HANA Service Information Access
  • SAP 2207175 - 403 forbidden issue occur while logging on AOclient 2.0 with local SAP HANA connection
  • SAP Note 2315536 - HANA InA role

Step 2: Try with the MY_USER and the SYSTEM user

Step 3: Check the INA service

The answer from HANA looks OK 

<html><head></head><body><pre style="word-wrap: break-word; white-space: pre-wrap;">{"ServerInfo":{"BuildTime":"2016-06-21 01:54:21","Client":
  • http://<server>:8008/sap/bc/ina/service/v2/GetResponse?Request={%22Metadata%22:{%22Expand%22:[%22Cubes%22]}}

The answer from HANA looks OK too 

<html><head></head><body><pre style="word-wrap: break-word; white-space: pre-wrap;">{"Cubes":[{"Annotations":"","CatalogPackage":"sap.hana.security.base.persistence","CatalogSchema":"_SYS_BIC","CatalogType":"CALC","CatalogView":"AuditPoliciesExpanded","CreatedBy":"","CreatedOn":"2016-11

Result => Not Found

Step 4: Trace the network between AO 2.4SP4 and HANA Answer from HANA => Not Found

Wireshark trace:

GET /sap/bc/ina/service/v2/ HTTP/1.1
Accept: */*
X-SAP-BICS-INA-PURPOSE: BROWSER_BASED_LOGON
Accept-Language: en-US
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E; InfoPath.3)
Host: <server>:8008
Connection: Keep-Alive
Authorization: Basic RkxABQkFDSDpAYUxqfUB2Si86VDk=
 
HTTP/1.1 404 Not Found
set-cookie: xsId8F45306ECACB5632E6FAE6372621EDFEB=7362445D98622344898F097D2674402C; path=/; HttpOnly
set-cookie: sapxslb=AC944AF4CC4A6E740A12375E9480E8178; path=/; HttpOnly
content-type: text/html
content-length:      2825

Do you have any idea to fix this connection issue?

Many thanks in advance

Kind regards

Answer

Accepted Solutions (0)

Answers (0)

Ask a Question