Skip to Content

Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: DUMMY

Hello All,

Was trying to integrate an HANA schema and HDI container service(trial version) with a JAVA application on cloud foundry, and encountered an error as below

could any one help me in understanding, what wrong here? am i supposed to assign an authorization? I am just running on cloud foundry trial version.

this is our simple connection test program

and even created an context.xml under META-INF under webapp.

am i missing anything over here? could some one help me in understanding the limitation of technical HANA on a trial version?




s4hana-cld.png (156.4 kB)
s4hana-cld.png (26.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Did you created and object (e.g. table, synonym, ...) in your HDI Container? In an HDI container you do not have a DUMMY object by default or have access to the SYS.DUMMY object.

    If you have created such an object in your HDI Container, did you check that the user has the required privileges to do a query on it?

  • Hi Florian,

    thanks for getting back,

    Tried with SYS.DUMMY, but it throws this below error

    I haven't created any Objects inside HDI container, I barely created an SAP HANA Schema and HDI service on Cloud Floundry Trial, and bind'd for the application, just to ensure/check the connectivity between application and HANA on CF trial,

    so not able to understand on how to make it working with CF trial and how do we debug this.




    1.png (49.8 kB)
  • Follow
  • Get RSS Feed

0 Answers