Skip to Content

Issue with Lumira Designer 2.1 lumx documents based on UNX sources (BIP4.1SP10)

I have recently upgraded our test environment from BIP 4.1SP07 / Lumira Server 1.31.8 to BIP4.1SP10 / Lumira Server 2.1. This system is clustered with one node having the main BIP and CMS servers and the other just LumiraServer, and relevant APS & AJS servers.

Lumira Discovery documents are fine but I'm having problems with Lumira Designer documents published or run on the BI Platform (data source is UNX). They test fine when run locally via Designer but when published to BIP or executed on the BI Platform from Designer the reports fail in one of two ways. Either:-

1) The report is completely blank and an error in the Lumira Server trace log about a ConnectionAccess issue and MALFORMED_DATA_SOURCE_ALIAS e.g.:

|0F2AD83DE6AC4C3F9F34EC635691E23D7|2018 02 26 12:39:12.895|+0000| |Error| | | |LS_LUMIRASERVER.LumiraServer| 4664| 236|Transport:Shared-57/56| |183|0|1|0|BIlaunchpad.WebApp|BIPSERVER:15408:81.1327:1|BIlaunchpad.WebApp|LUMIRASERVER:15408:81.1327:1|.post|LUMIRASERVER:4664:236.301:1|Cl4GN.pC5EXCtw4Ii3Ztdks52d|||||||||com.sap.ip.bi.zen.boe.service.core.landscape.ConnectionAccess|BI-RA-AD|???MALFORMED_DATA_SOURCE_ALIAS???

OR

2) The report displays a grey Graph placeholder with "Add measures or dimensions" across it. In the bottom right an error is displayed after clicking a "I" button:-

Cannot load InfoProvider "DSL/Abq1y3LZgClBlODrBggnlfE" (data provider "DS_1": Exception occurred during creation)Cannot load InfoProvider "DSL/Abq1y3LZgClBlODrBggnlfE" (data provider "DS_1": Exception occurred during creation)

On searching I have found this rather vague comment on SAP Lumira Server 2.1 Restrictions https://launchpad.support.sap.com/#/notes/2561566 :

"4) After acquiring data from an SAP Universe in the Designer application, if you publish the document to SAP Lumira Server and then try to execute the application in BIP mode, you get an error."

But no detail related to this to confirm it relates to either or both the issues I am seeing.

**************** Additional Info ***************************

Some possibly relevant additional information. The environment previously had the Design Studio 1.6 server add-on installed with BI4.1SP07. I uninstalled this prior to installing BI4.1SP10 + Lumira Server 2.1. This was to make the upgrade test more similar to our other systems which just have BI4.1SP07 and Lumira Server 1.3.8 but no Design Studio.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 01 at 10:45 AM

    OK SOLVED!

    We have a clustered environment with main BIP & CMS on one server and Lumira on another. In terms of servers for Lumira 1.31.8 we just needed LumiraServer, APS and AJS on the Lumira Node - and in that configuration Adaptive Connectivity Services were not included in the APS. From what I have read with Lumira 2.1 and Lumira Server supporting Designer documents we needed to add Adaptive Connectivity Services to the APS on the Lumira Node in the cluster. (REF: SAP Lumira Admin Guide 5.3.3:- “Adaptive Connectivity Service is running on the Adaptive Processing Server on which the SAP Lumira Server Add-On is installed.”)

    So simply adding Adaptive Connectivity Services to my APS wouldn't work initially. It was giving an“The edge between objects ------ and ------ does not exist” error - which lead me down the repair install route. However this is because certain install elements are not on this node. So I modified the install and added Connectivity Services and all under Data Access. This adds ConnectionServer, ConnectionServer32 and Adaptive Connectivity Services to the existing APS on the Lumira node. A quick test of one of the failing Designer documents and success!

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 26 at 03:18 PM

    Have you converted your older documents to 2.x ? please check out the lumira upgrade pattern book for conversion procedures and useful kbas which comment on the same -

    https://www.sap.com/documents/2017/12/00b76107-e57c-0010-82c7-eda71af511fa.html

    Add comment
    10|10000 characters needed characters exceeded

    • Dan Densley Shiva Vishnubatla

      OK SOLVED!

      We have a clustered environment with main BIP & CMS on one server and Lumira on another. In terms of servers for Lumira 1.31.8 we just needed LumiraServer, APS and AJS on the Lumira Node - and in that configuration Adaptive Connectivity Services were not included in the APS. From what I have read with Lumira 2.1 and Lumira Server supporting Designer documents we needed to add Adaptive Connectivity Services to the APS on the Lumira Node in the cluster. (REF: SAP Lumira Admin Guide 5.3.3:- “Adaptive Connectivity Service is running on the Adaptive Processing Server on which the SAP Lumira Server Add-On is installed.”)

      So simply adding Adaptive Connectivity Services to my APS wouldn't work initially. It was giving an“The edge between objects ------ and ------ does not exist” error - which lead me down the repair install route. However this is because certain install elements are not on this node. So I modified the install and added Connectivity Services and all under Data Access. This adds ConnectionServer, ConnectionServer32 and Adaptive Connectivity Services to the existing APS on the Lumira node. A quick test of one of the failing Designer documents and success!

  • Feb 27 at 09:58 AM

    Additional relevant info added to main post.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 26 at 03:07 PM

    Is this happening with admin user as well? Can you give rights on the all the servers, everyone group, view access?

    Add comment
    10|10000 characters needed characters exceeded

    • Gave everyone group view objects rights at top level CMC Servers - no change. Tests are running as the same user who created the report and ran it "locally" in Designer - so they have rights to the Universe/connection.