cancel
Showing results for 
Search instead for 
Did you mean: 

HANA schema is not created in catalog folder in HANA systems tab

former_member508729
Active Participant
0 Kudos
146

HI

I created a new schema in HANA studio and activated the file

this should ideally created schema in catalog folder in HANA system tab but this didnt happen but schema is created in to my package instead.

could you please tell me why this has happened and I reckon the HANA studio I am using is on SP4.

thanks

Ashutosh

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182302
Active Contributor
0 Kudos

Can you share the screenshots please?

Also the SQL statement you used to create the schema.

Regards,

Krishna Tangudu

former_member508729
Active Participant
0 Kudos
thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

Are you sure you are running SP4?  The Studio certainly isn't SP4.  I can tell from the screen shot it is SP7. If in fact your server is SP4, then that is too old to perform such operations.  Most XS based development techniques didn't come until SP5.  Please confirm which release you are actually on. 

The other thing to consider is that you created the schema correctly but don't have authorization to see it yet. The schema is created and owned by _SYS_REPO.  Your user won't have access to it until you create an hdbrole and grant that role to your account.

former_member508729
Active Participant
0 Kudos

Dear Thomas

thanks for your reply

here are details from my HANA studio

Version: 1.0.7000

Build id:  386119

thanks

Ashutosh

former_member182302
Active Contributor
0 Kudos

Hi Thomas,

When i created the schema, without the .hdbrole, i was able to see the schema which i created for SYSTEM user.

But for the other user id it requires .hdbrole as you must be mentioning.

Want to know how SYSTEM user is able to see the newly created schema which is owned by _SYS_REPO?

Regards,

Krishna Tangudu

former_member182302
Active Contributor
0 Kudos

Hi Ashutosh,

Thomas was asking the version of your DB.

Fire this query and see the results:

select * from "M_DATABASE"

Regards,

Krishna Tangudu

former_member508729
Active Participant
0 Kudos

HI Krishna

firing this query is giving same results which I mentioned in my earlier reply

query result says

DATABASE_NAME  ;HOST;    START_TIME;                        VERSION

HAN;                       dmzim002;Dec 5, 2013 9:03:16.612 AM;1.00.70.00.386119

Thanks

Ashutosh

former_member182302
Active Contributor
0 Kudos

So u are on revision 70 means much above than SP4 .. and it got installed on Dec 5

Regards,

Krishna Tangudu