SAP Knowledge Base Article - Preview

2968736 - HANA SQL Error 463 - number of tables exceeds its maximum

Symptom

Complex queries like "HANA_Configuration_Minichecks" or "HANA_SQL_StatementHash_DataCollector.txt" (from SAP Note 1969700 SQL Statement Collection for SAP HANA) cannot execute successfully with the following error messages:

  • 463: number of tables exceeds its maximum: 4095
  • 463: number of tables exceeds its maximum: table count in statement exceeds its maximum:4095

PAH_HANA_MiniChecks_error.jpg

Could not split statements; SQL console content is too large
Could not execute 'WITH /* [NAME] - HANA_Configuration_Minichecks_<revision> [DESCRIPTION] - General SAP HANA checks ...'
SAP DBTech JDBC: [463]: number of tables exceeds its maximum: table count in statement exceeds its maximum:4095

Note: This error could occur for any complex query which is accessing many tables.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition all versions

Keywords

Minichecks, HANA_Configuration_Minichecks, 463, number of tables exceeds its maximum, 4095, table_size_check, max_table_count_in_statement , KBA , HAN-DB , SAP HANA Database , How To

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.