ERROR Dataset cannot be published to sap lumira server

[Former Member]

Hello Experts,

We recently upgraded from patch 17 to 28 of Lumira server. Just after

upgrading We are getting the following error while trying to publish

the   data set "ERROR: Dataset cannot be published to sap lumira server

publishing to SAP HANA layer faild reason no avilable (HDB 11009)".

I have upgraded the Hana Database from 1.80 to 1.97 and i have installed SAP UAL 1.308.00. But still i am facing same issue. I have attached the error screenshot below. Please help me how to resolve the issue.

Thanks,

Ram

[Former Member]

Hello Shankar,

Thanks for the reply, I changed the Lumiratech user password in RepoConnection.xssqlcc sap -> bi -> launchpad -> logic -> v2  edited the RepoConnection.xssqlcc object and i changed the password and activated the objext.But i am facing same issue.

Thanks,

Ram

[Former Member]

Hello,

I found some xsengine trace log files. But i did't understand properly.

The following error showed in Trace alert file.

[7392]{7392}[-1/-1] 2015-09-03 06:08:31.347922 e XSAuthentication Wire.cpp(00108) : SQL error. Code: 10, Message: invalid username or password at ptime/query/catalog/userinfo.cc:958

[7392]{7392}[-1/-1] 2015-09-03 06:08:31.352816 e XSAuthentication Wire.cpp(00108) : SQL error. Code: 10, Message: invalid username or password at ptime/query/catalog/userinfo.cc:958

[7392]{7392}[-1/-1] 2015-09-03 06:08:53.719004 e xsa:sap.bi.launc sap.bi.launchpad.logic.lib:ResponseHandler.xsjslib(00120) : InternalError: dberror(CallableStatement.execute): 500 - predicates are required in a where clause: "_SYS_BIC"."sap.bi.launchpad.db.havana_procedures/HAVANA_GET_USER_PACKAGE": line 16 col 5 (at pos 786): [500] (range 3) predicates are required in a where clause exception: predicates are required in a where clause: M_EFFECTIVE_PRIVILEGES_ needs predicates on columns (connected by AND if more than one): an equal predicate on USER_NAME.

Can you please help me the this issue.

Thanks

Ram

[shankarsgs]

Hi Ram,

SAP Lumira uses the Catalog to store your dataset.

You will have to goto SAP Lumira Configuration in your Fiori Launchpad and configure the BI_TECH_USER USER in RepoConnection.xssqlcc which can be found at “sap -> bi -> launchpad -> logic -> v2” make sure that the password of the LUMIRATECH user which you would have created is not in initial password change.

Activate the object after entering the details and try publishing the dataset.

Regards

Shankar

[TammyPowlas]

Hi Ram- there are at least 4 SAP notes related to this issue; see the most recent one here: http://service.sap.com/sap/support/notes/2099960

I encourage you to go to support.sap.com/notes and search HDB 11009 and see if the notes apply to your situation

Tammy

[Former Member]

Hello Tammy,

Thanks for the reply, I checked following sap notes:2099960,2056841,1995325,2160781.All users roles are assigned properly. But no luck . Still i am facing the issue.

Thanks,

Ram

[Former Member]

Tammy,

I found some xsengine trace log files. But i did't understand properly.

The following error showed in Trace alert file.

[7392]{7392}[-1/-1] 2015-09-03 06:08:31.347922 e XSAuthentication Wire.cpp(00108) : SQL error. Code: 10, Message: invalid username or password at ptime/query/catalog/userinfo.cc:958

[7392]{7392}[-1/-1] 2015-09-03 06:08:31.352816 e XSAuthentication Wire.cpp(00108) : SQL error. Code: 10, Message: invalid username or password at ptime/query/catalog/userinfo.cc:958

[7392]{7392}[-1/-1] 2015-09-03 06:08:53.719004 e xsa:sap.bi.launc sap.bi.launchpad.logic.lib:ResponseHandler.xsjslib(00120) : InternalError: dberror(CallableStatement.execute): 500 - predicates are required in a where clause: "_SYS_BIC"."sap.bi.launchpad.db.havana_procedures/HAVANA_GET_USER_PACKAGE": line 16 col 5 (at pos 786): [500] (range 3) predicates are required in a where clause exception: predicates are required in a where clause: M_EFFECTIVE_PRIVILEGES_ needs predicates on columns (connected by AND if more than one): an equal predicate on USER_NAME.

Can you please help me the this issue.

Thanks

Ram

[TammyPowlas]

I don't have Lumira server but the log clearly shows invalid user name and password