SAP Knowledge Base Article - Public

2610320 - "Service ? unknown" when trying to connect to BW system via OLAP connection with server type set to "Group"

Symptom

When trying to connect from Analysis Office to a BW system via OLAP connection defined in CMC with server type "Group", the error below occurs:

-----------------------
ERROR service "?" unknown
-----------------------

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Create an OLAP connection in CMC to a BW system with server type set to "Group" to use message server;
  2. Try to connect to the OLAP connection via Analysis for Office;
  3. Confirm the error "service '?' unknown".

Resolution

It is necessary to make sure that the client PCs can communicate with the BW system.

Make sure that the service name configured in the OLAP connection is also configured in the services file at <systemdrive>:\WINDOWS\system32\drivers\etc\services in the client PC.

Note: If SAP Business Objects or BW either of them is on Linux system make sure that host file entries and service name is configured in /etc/services file.

See Also

Chapter "Creating and managing BW system connections in SAP BusinessObjects Business Intelligence" in the Administrator Guide.

Keywords

group, service, unknown, ?, error, connection, NiSrvLGetServNo, service name cached as unknown , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem

Product

SAP Analysis for Microsoft Office all versions