Can't use the plan due to the following error message:
Could not allocate space for object dbo.orc_orders. IX_orc_OrdersUpdateTimeStamp in database 'DATABASENAME' because the PRIMARY filegroup is full. Create a disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup or setting autogrowth on for existing files in the filegroup.
The primary filegroup is full and the log files size needs to be set to unlimited. This will prevent the error from generating again. Please action the below on the Orchestrate databases from SQL management studio:
Connect to the SQL Server instance
Expand Databases.
Right-click on the relevant database and click on Properties.
First, we will change the MAXSIZE of data files
click on Files.
In the right pane, click on a balloon in the Autogrowth / Maxsize column in ROWS File Type.
A dialog box named Change Autogrowth opens.
In the dialog box, set Maximum File Size to Unlimited.
Click on OK to save the value and close the dialog box.
Similarly, change the value of the MAXSIZE parameter of the log files.
Once parameter values are updated, click OK to close the database properties.