Error message when deleting Service Requests - Error converting data type varchar to numeric

Version 1

    Details

    When trying to delete a record, the following error is generated:

    System.Data.SqlClient.SqlException
    Unhandled system exception: Error converting data type varchar to numeric.

     


    Resolution

    This error is usually caused by an invalid relationship. For example, a custom relationship that was set up with the link/key fields as ServiceReqNumber (numeric) and Task's RecID (text). This will cause the data type conversion error above. Also please note that a Service Request's number will never match up with a Tasks' RecID, so the relationship is not valid or functional. It is recommended to change the link/key fields to be recIDs on both ends, or to other matching unique values appropriate to the relationship.