Creating new HANA table script and delivering via Transport

[Former Member]

Hi Everyone,

What am I missing?  I've created the table creation hdbtable script, included it in a delivery unit and transported it to my QA system.  The script came across but was not executed (it says that it is activated).   What am I missing here?  I thought this was the way to create and alter tables and push the changes to different environments.  Is there a different method that I haven't read about? 

Thanks!

Jeff.

[chandan_praharaj · Accepted solution]

Yes this is the Developement artifact method of doing this. Can you please share the code you used for table creation in hdbtable, Can you also check when table is activated it belongs to _SYS_REPO, do you have proper privilege to see the table?

may be you need to execute the GRANT_ACTIVATED_PRIV..

check with your SYSTEM user too, if he can help.

[Former Member · Accepted solution]

Thanks Chandan.   I found the table, the name of it was prefixed with the Package name as well.  It looks like this:  Package_name.Package_name_2::table_name.

The code I used was from the template provided out of the box and I kept it simple for my first test.  Looks like this.

table.schemaName = "Staging";

table.tableType = COLUMNSTORE;

table.columns =

[

{name = "MY_COL1";  sqlType = VARCHAR; length = 200;}

];

I'll now try to find a way to not have it include the package in the table name.  Any ideas?

Thanks,

Jeff.

[thomas_jung · Accepted solution]

>I'll now try to find a way to not have it include the package in the table name.  Any ideas?

Not possible with hdbtable in the repository.  The package perfix is always added to repository-based development objects.