cancel
Showing results for 
Search instead for 
Did you mean: 

Creating a table using hdbtable

former_member205400
Active Participant
0 Kudos
660

Friends,

We are moving towards creating tables using the hdbtable syntax and I was looking at this link:

http://help.sap.com/saphelp_hanaplatform/helpdata/en/89/cbf999e6004be3a5324b8f9ef0c53f/content.htm?f...

and I can't seem to find the "Team | Activate"

What am I doing wrong here I thought I followed the example.

Mike

View Entire Topic
lucas_oliveira
Advisor
Advisor
0 Kudos

Hi Mike,

You probably want to look into the indexserver trace files and see what are the errors for component tableruntime. You'll probably bump into something like:

[43185]{301910}[41/4717481] 2016-04-20 17:22:57.265751 e tableruntime     TableRuntime.cpp(00344) : activationID 49: Errornous statement: CREATE COLUMN TABLE "DEVSANDBOX"."i829138.sandbox.domainTests::MyTab" ("Col1" VARCHAR(20) NOT NULL, "Col4" DECIMAL(2, 3) NOT NULL)

[43185]{301910}[41/4717481] 2016-04-20 17:22:57.265759 e tableruntime     TableRuntime.cpp(00345) : activationID 49: decimal scale specifier is out of range

So Col4 is trying to use a scale bigger than the precision. That's not going to work since the scale needs to be as big as the precision established. I think we have a typo in the doc page you referred.

BRs,

Lucas de Oliveira