Table many too field

Question

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؟

Phil Kennedy · Answer

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:

Sage X3

Table many too field

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING