A small number of VO/SAAS firms are getting an error when they select to update their database after the 2018.2.0 update release. If you speak to a firm that encounters the error below, please visit the Practice CF.

Once you have CF authorization, follow these directions:

Add the firm ID and the name of the database to TFS 1549678. Make a backup of the database utilizing the VO Minibar and copy it to \\pssg.local\UserServices\TFS\CSPracticeSupport\1549678.

Once the database is copied, please send an email to kristie.logan@thomsonreuters.com and Support-Accounting.Practice.Senior.Specialists@thomsonreuters.com

Include a Practice login for development to use to open the database in the email. 

Reach out to the Practice CF is you have any questions.

Error:

System.ApplicationException: Database schema update failed at line 218 of ServicePacks.V3014_0.121.sql:

(Arithmetic overflow error converting varchar to data type numeric.

The statement has been terminated.)

update

dbo.Custom_Value

set

custom_field_type_KEY = VV.custom_field_type_KEY

, custom_field_slot = VV.custom_field_slot

, custom_value_as_checkbox = VV.custom_value_as_checkbox

, custom_value_as_number = VV.custom_value_as_number

, custom_value_as_date = VV.custom_value_as_date

, custom_value__staff_KEY = VV.custom_value__staff_KEY

, custom_value__custom_grouping_KEY = VV.custom_value__custom_grouping_KEY

from

dbo.Custom_Value

join

dbo.vv_Custom_Value_View as VV

on

VV.custom_value_KEY = dbo.Custom_Value.custom_value_KEY

---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting varchar to data type numeric.

The statement has been terminated.

TFS 1549678