HANA XSA Service CROSS_SCHEMA_SYS not found while doing Cross Container access

[former_member530295]

Hello Experts,

After trying hard for one complete week, I am asking this question. I have HANA Xpress edition installed locally. I have created user provided service for SYS using command line tool

xs cups CROSS_SCHEMA_SYS -p "{\"host\":\"hxehost\",\"port\":\"39013\",\"user\":\"SYSTEM\",\"password\":\"Magic123\",\"driver\":\"com.sap.db.jdbc.Driver\",\"tags\":[\"hana\"] , \"schema\" : \"SYS\" }"

After that I have added the Resources and Modules as below in my DBA module to access SYS schema

When i create synonym and build the ..hdbsynonym, i am getting error as "service CROSS_SCHEMA_SYS" not found.

Please guide.

Thanks and Regards,

Anubhav.

[thomas_jung · Accepted solution]

What space did you create the service in? What space is your project targeting? From your first screenshot you seem to be creating the UPS in the SAP space (I see many other standard service instances in there). But the SAP space isn't generally where you do project development.

[former_member530295 · Accepted solution]

Thomas, you made my day!

[jhodel18]

I can’t see the type of service you used, did you use this type?

type: org.cloudfoundry.existing-service

Errors like that has something to tell about the mta configurations you have.

[former_member530295]

Dear Cailan,

Yes, the type was used, may be missed to capture in last screenshot