Teradata Database Message 3556 - 3556 - Analytics Database - Teradata Vantage
Teradata® VantageCloud Lake - Analytics Database Messages
- Edition
- Lake
- Product
- Analytics Database
- Teradata Vantage
- Published
- October 2022
- Language
- English (United States)
- Last Update
- 2024-02-26
- dita:mapPath
- tzr1629746512312.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- vza1585613049811
- lifecycle
- latest
- Product Category
- Teradata® Vantage™
- Message
- Too many columns defined for this table.
- Explanation
- As a table is modified and fields are dropped and added, each new added field is given a higher column id than any prior column id for the table. The range from highest to lowest column id in a table is restricted, for internal reasons, to SYSMAXFIELDS, which is 2560.
- Generated By
- GEN modules.
- For Whom
- End User.
- Notes
- None
- Remedy
- If the error occurred during ALTER TABLE, then if a new column is absolutely necessary in the table, the table must be rebuilt. Create a new table with the existing data. If the error did not occur during ALTER TABLE, then the cause must be that some spool file has been defined with too many columns. Examine the query and modify to use fewer columns.