Getting No service implementation available with Lumira 2.0 SP2 Patch 1on BOBJ 4.1 SP10 Patch 1

[NTruhan]

Hello,

I did an upgrade of a 2 server install consisting of BOBJ 4.1 SP8 Patch 4, Analysis for Office 1.4.17, Design Studio 1.6.3 and Lumira 1.31.3 to BOBJ 4.1 SP10 Patch 1, Analysis for Office 1.4.17, Design Studio 1.6.5, Lumira 1.31.3, then upgrading DS and Lumira components to Lumira 2.0 SP2 Patch 1 directly.

We are using OLAP queries through BW and when trying to run either old Design Studio 1.6 reports in Lumira 2.0 or even creating new Lumira 2.0 Designer reports we receive the following errors:

Could not instantiate the data source. See default trace for log ID "c09305f8-3a73-48d9-b05a-519e079b09d1". Details: Cannot load query "cuid:Fg673lIA8ggAbTUAAECp6kQAAFBWrx65/ZMCS709Q

Cannot load query "cuid:Fg673lIA8ggAbTUAAECp6kQAAFBWrx65/ZMCS709Q_ADHOC_BOB_7_001" (data provider "DS_4": No service implementation available)

I see some similar questions on here, like:

https://answers.sap.com/questions/300685/lumira-20-report-does-not-show-on-bi-platform-no-s.html but this is on BOBJ 4.2 not 4.1.

And we can't upgrade to BOBJ 4.2 on these servers since analysis for office 1.4 is not supported, yes they need that version as they still have Office 2007 deployed company-wide which Analysis 2.x does not support.

The BOBJ 4.1 server is on RedHat 5.1. Lumira 2.0 is on Windows 2012. Design Studio used to be on the RedHat server, but is now under Lumira 2.0 in Windows (pre-installed Design Studio there before upgrading Lumira 1.31 there).

Someone had mentioned to me that I may want to uninstall Lumira 1.31 first before doing the 2.0 install, but if I do that then existing Lumira 1.31 documents don't be available in Promotion Management.

Has anyone run into this on the earlier versions of BOBJ, BW and the new Lumira?

Thanks,

Nathan

[NTruhan]

I saw this as a supported install type here:

https://blogs.sap.com/2017/05/19/updating-sap-businessobjects-bi-platform-to-lumira-2.x/

However, in the grand scheme of things and digging further into the error logs, I found that it is actually working. It was a set of SAP Service entries in the windows services file that were missing. the error in the GUI was similar enough to the old error to send me down one path, but the error in the error logs showed a lot more detail of what was going on once I increased logging a bit to see it all. The Design Studio add-on was on server 1 and moved in the process over to server 2 as part of Lumira 2.0 so server 2 was missing those service entries.

The overall system is a patchwork of installs to begin with, which is why the 4.2 install is on a brand-new system but can't migrate over until they upgrade their Office infrastructure, Analysis for Office is a large piece of what they use.

To give you an idea of why I am starting new in 4.2, this is what The current install history looks like. Actually pretty impressive it runs as it does.

SAP BusinessObjects Design Studio 1.6 for BI Platform 4.1 (16.5.4.1284)
SAP BusinessObjects BI platform 4.0 SP2 Patch 14 (14.0.2.657)
SAP BusinessObjects BI platform 4.0 SP4 update (14.0.4.738)
SAP BusinessObjects BI platform 4.1 SP10 update (14.1.10.2483)
SAP BusinessObjects BI platform 4.1 SP10 Patch 1 update (14.1.10.2527)
SAP BusinessObjects BI platform 4.1 SP4 update (14.1.4.1327)
SAP BusinessObjects BI platform 4.1 SP4 Patch 2 update (14.1.4.1412)
SAP BusinessObjects BI platform 4.1 SP4 Patch 6 update (14.1.4.1543)
SAP BusinessObjects BI platform 4.1 SP6 update (14.1.6.1702)
SAP BusinessObjects BI platform 4.1 SP6 Patch 5 update (14.1.6.1882)
SAP BusinessObjects BI platform 4.1 SP8 update (14.1.8.2060)
SAP BusinessObjects BI platform 4.1 SP8 Patch 4 update (14.1.8.2215)
SAP BusinessObjects BI platform 4.0 SP2 (14.0.2.364) - en
SAP BusinessObjects Explorer 4.0 (14.0.2.364) - en
SAP BusinessObjects Explorer 4.0 SP2 Patch 14 (14.0.2.657)
SAP BusinessObjects Explorer 4.0 SP4 update (14.0.4.738)
SAP BusinessObjects Explorer 4.1 SP10 update (14.1.10.2483)
SAP BusinessObjects Explorer 4.1 SP10 Patch 1 update (14.1.10.2527)
SAP BusinessObjects Explorer 4.1 SP4 update (14.1.4.1327)
SAP BusinessObjects Explorer 4.1 SP4 Patch 2 update (14.1.4.1412)
SAP BusinessObjects Explorer 4.1 SP4 Patch 6 update (14.1.4.1543)
SAP BusinessObjects Explorer 4.1 SP6 update (14.1.6.1702)
SAP BusinessObjects Explorer 4.1 SP6 Patch 5 update (14.1.6.1882)
SAP BusinessObjects Explorer 4.1 SP8 update (14.1.8.2060)
SAP BusinessObjects Explorer 4.1 SP8 Patch 4 update (14.1.8.2215)
SAP Lumira, server for BI Platform 1.30 (1.30.0.61) - en
SAP Lumira, server for BI Platform 1.31 update (1.31.0.76)
SAP Lumira, server for BI Platform 1.31 update (1.31.3.84)
SAP BusinessObjects Lumira Server for BI Platform 2.0 SP2 Update (2.0.0201.89)

Thanks for answering hopefully this will help someone else when they get this error to look a their services file.

[denis_konovalov]

In-install of Lumira add-on is a very very bad idea and can leave your system in bad shape. I believe it is not supported.
You should log a support incident with SAP for this issue and see what investigation will show.