---
title: "Message: The 'Sort_Order' property on 'tblLIBStorageLocation' could not be set to a 'System.Int32' value. You must set this property to a non-null value of type 'System.Int16'."
canonical: "https://servicedesk.maxgeo.com/space/DS/1720483848/Message%3A+The+'Sort_Order'+property+on+'tblLIBStorageLocation'+could+not+be+set+to+a+'System.Int32'+value.+You+must+set+this+property+to+a+non-null+value+of+type+'System.Int16'."
format: markdown
---
|  |  |  |  |
| --- | --- | --- | --- |
| Application: | DataShed | Related Build Number: | 3.1.0 |
| Status: | [Known Issue - Reported to DEveopment] | Resolved Build Number | 3.1.0 |

---

**Issue:**

Error when select the “+ New Dispatch” in the same dispatch extension

```sql
Message: The 'Sort_Order' property on 'tblLIBStorageLocation' could not be set to a 'System.Int32' value. You must set this property to a non-null value of type 'System.Int16'.
```

![image-20250604-013218.png](media://75e681e1-30e8-459b-91c8-fbe177757dac)


**Cause:**

The Sort order has to be set to NULL

```sql
select * from tblLIBStorageLocation
where Sort_Order is not NULL
```

![image-20250604-013143.png](media://a818bffe-64c6-4a64-8efe-312966086def)


**Resolution: ** 

Set all sort order to be NULL

```sql
update tblLIBStorageLocation set Sort_Order = NULL
```


> ⚠️ DB Modification
> ⚠️ 
> ⚠️ Before any change is made to a user database (or system), maxgeo recommends competent staff should follow all standard database change management practices and never make untested changes to a production database.  
> ⚠️ Change, test and document all modifications on a test copy of your database to ensure results are as expected before implementing them on your live database. Always ensure a full backup is available in case rollback is required and follow all company change management procedures and practices.