Skip to Content
0

SAP HANA 2.0 SPS 03: After Update Error. variable cannot be set via SET command: XS_APPLICATIONUSER

Apr 13 at 12:37 PM

110

avatar image

Hi,

after our update from SPS 02 to SPS 03 we are not able to run our web modul anymore

In different apps we have this issue:

ERR Error: the predefined session variable cannot be set via SET command: XS_APPLICATIONUSER

Thanks for helping us!

10 |10000 characters needed characters left characters exceeded

Now I saw we have also the issue to run our db explorer and I found this in the notes.

  • Tenant database containers limitation:
    • When working with the SAP Web IDE for SAP HANA in a multi-database container configuration, the database explorer may not be able to connect to tenant database HDI containers. This limitation prevents the database explorer from working with these containers and it affects the data preview window for calculation views in the development perspective. When you use this type of configuration, the connection fails with an error “Setting XS_APPLICATIONUSER failed due to invalid or expired token.” The cause of this error is that a trust relationship has not been established between your XSUAA token and the SAP HANA database. You can remedy this error by following these instructions.

2510793 - SAP HANA Runtime Tools 2.0 SP 03 Release Notes

Does this issue belong together?

0

You can remedy this error by following these instructions.

The link doesn't work for us!

https://jam4.sapjam.com/wiki/show/sV7E5RZBrfWTKvK7avA0zC

not-found.png

@SAP Please would someone exchange this link. To solve our issue, we need these instructions urgently! Please!

not-found.png (23.8 kB)
1
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ayman Salem 5 days ago
1

Hallo Dirk,

I have the same problem with HANA Express SPS03 after update from SPS02.

to solve it, follow the instruction from Markus Strehle Blog:

(Re-)Establish Trust with XSUAA and HANA DB | SAP Blogs

https://blogs.sap.com/2017/01/22/re-establish-trust-with-xsuaa-and-hana-db/

hier my xsuaa_settings.cfg file for HXE SPS03:

HANA_SID=HXE
HANA_INSTANCE=90
# use this MDC_DATABASE to set database name in case you use HANA with MDC
MDC_DATABASE=HXE
#HANA_XSPATH=/usr/sap/hana/shared/XSA/xs
HANA_SYSTEM_USER=system
#HANA_SYSTEM_PASSWORD=
XSA_USER=xsa_admin
XSA_UAA_ENDPOINT="https://`hostname -f`:39032/uaa-security"
# documentation about jdbc url, see http://help.sap.com/saphelp_hanaplatform/helpdata/en/ff/15928cf5594d78b841fbbe649f04b4/frameset.htm
# this is the jdbc url for a single instance database
#JDBC_HANA_ENDPOINT="jdbc:sap://`hostname -f`:30015"
# this is the jdbc url for a multiple instance database with connect to system DB
#JDBC_HANA_ENDPOINT="jdbc:sap://`hostname -f`:30013"
# this is the jdbc url for a multiple instance database with connect to tenant DB XSA
JDBC_HANA_ENDPOINT="jdbc:sap://`hostname -f`:39013/?databaseName=HXE"

Ayman

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Ayman,

thanks for your response.

Yes, I found this same solution already on saturday and reminded me, that we had the same issue one year ago.

Found this note 2470084 and came to the same link as you mentioned. Will check for it today.

"2470084 - XSUAA metadata for XS_APPLICATIONUSER trust creation"

BR,

Dirk

0