Making Database Schema Changes for Large Business Object Tables
2 min
in the production instance of the tenant, database schema changes (such as creating new fields or changing the data type) to business objects that have a large number of records can cause the application to slow down and potentially not respond to regular users to protect the application from this, you cannot make database schema changes in the production instance of the tenant to business object tables that contain a large number of records if you try to make the change directly in the production instance, the application displays an error message stating that "the table name table contains a large number of records schema changes cannot be done now " the schema changes are not made instead, makes the changes in the staging instance of the tenant and follow the lifecycle process, via the operations console add the fields in the staging instance of the tenant first (with a smaller number of records in the table), and then use the operations console to transfer the corresponding fields into the production instance of the tenant see the operations console guide for ivantineurons for itsm https //help ivanti com/ht/help/en us/ism/2023/opsconsoleole/content/ops console ug/opsconsole htm for information about using the operations console changing the timeout value for ddl queries when you make database schema changes in the configuration console, you have 30 minutes before the application times out you can change the timeout value if this parameter is missing or set to less than two minutes, the application reverts the value back to 30 minutes to change the timeout value, do the following open the \appserver\web config file with a text editor, such as notepad navigate to the following code \<appsettings> \<! ddl query execution timeout in seconds > \<add key="ddlquerytimeout" value="1800" /> \</appsettings> change the value of the ddlquerytimeout parameter this parameter is specified in seconds for example, value="1800" reflects the 30 minute timeout value save the file perform a microsoft iis reset