SAP Knowledge Base Article - Preview

3520068 - Table Partition Error: 'SAP DBTech JDBC: [545]: invalid partition spec: Range [XXX, XXX) is invalid'

Symptom

As for the table "table-name", there's a primary key which combines two columns 'X' and 'Y'.

While executing the table partition sql statement:
ALTER TABLE "table-name" PARTITION BY RANGE ("X") 

Some error showing like below:
Could not execute 'ALTER TABLE "table-name" PARTITION BY RANGE ("X") ((PARTITION '20000000' <= ...'
SAP DBTech JDBC: [545]: invalid partition spec: Range [80000000000, 100000000000) is invalid


Read more...

Environment

SAP HANA Platform

Product

SAP HANA, platform edition all versions

Keywords

Table Partition, Partitioning, Primary Key, invalid partition spec: , KBA , HAN-DB-ENG , SAP HANA DB Engines , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.