Error Publishing to Server 1.17

[Former Member]

Hello,

Facing this error when publishing to Server 1.17:

Error: Dataset cannot be published to SAP Lumira™ Server; publishing to SAP HANA layer failed. Reason: '<Not available>'. (HDB 11009)

[24906]{-1}[-1/-1] 2014-06-16 20:03:34.014520 e xsa:sap.bi.launc sap.bi.launchpad.logic.lib:ResponseHandler.xsjslib(00119) : InternalError: dberror(CallableStatement.execute): 8 - invalid argument:  [8] "_SYS_BIC"."sap.bi.launchpad.db.havana_procedures/HAVANA_GET_USER_PACKAGE": line 16 col 5 (at pos 786): [8] (range 3): invalid argument: SELECT without WHERE clause USER_NAME = ... not supported at ptime/session/eapi/jdbc/ExternalStatement.cc:908

File: /sap/bi/launchpad/logic/v2/UserServiceResource.xsjs

Line: 184

    @/sap/bi/launchpad/logic/v2/UserServiceResource.xsjs:184

    @/sap/bi/launchpad/logic/lib/ResourceRouter.xsjslib:87

    @/sap/bi/launchpad/logic/v2/UserServiceResource.xsjs:161

Any ideas would be much appreciated.

[former_member184471 · Accepted solution]

Hi,

did you configure publishing on the SAP Lumira server after install?

1.17 has an easier way for configuration, please see my blog with instruction.

Hope that help,

  Christina

[Former Member · Accepted solution]

Thanks Christina. The Fiori App to configure Lumira is not showing in the Launchpad. Did we miss something during installation?

[former_member184471 · Accepted solution]

Did you make sure that the user that accesses http://<HOSTNAME>:80<INSTANCE>/sap/bi/launchpad/fiori needs has the BI_CONFIGURATOR HANA roles assign? This is needed to see the "SAP Lumira Administration" catalog in fiori. Said user has to add the configuration tile from the catalog onto the homepage, which is described in the blog.

Hope that helps,

Christina