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؟
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؟
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:
*Community Hub is the new name for Sage City