Table many too field

SUGGESTED

Hello

The number of fields in my table has increased and I cant add another column in table.it cannot be validated ! what should i do؟

Parents
  • 0
    SUGGESTED

    I interpret your question to also mean columns in the table schema have been added and now you are unable to add further columns? Any change to schema is a customization. How many columns(fields) are on the table now?  SQL Server supports up to 1,024 columns. Sage X3 does maintain a data dictionary to describe the schema definition. Therefore, I recommend you review the ATABZON definition and see if there is a limit set there (possibly: Number of records field). I cannot advise as to the impact if you change this value; you will need to perform the required testing on a sandbox or having a backup, and review the results.
    Is there a specific error on the validation log?

    In the current version, it appears the limit is set to 1000; which is just shy of the SQL server limitation:

Reply
  • 0
    SUGGESTED

    I interpret your question to also mean columns in the table schema have been added and now you are unable to add further columns? Any change to schema is a customization. How many columns(fields) are on the table now?  SQL Server supports up to 1,024 columns. Sage X3 does maintain a data dictionary to describe the schema definition. Therefore, I recommend you review the ATABZON definition and see if there is a limit set there (possibly: Number of records field). I cannot advise as to the impact if you change this value; you will need to perform the required testing on a sandbox or having a backup, and review the results.
    Is there a specific error on the validation log?

    In the current version, it appears the limit is set to 1000; which is just shy of the SQL server limitation:

Children
No Data