Table of Contents

KB Item 63

Product

None

Product Version (if applicable)

None Defined

Issue

Error converting data type nvachar to numeric excuting SQL statement on TWBS_FDX_WXX and TWBS_FDX_WXX_D

Symptom

Error converting data type nvachar to numeric excuting SQL statement on TWBS_FDX_WXX and TWBS_FDX_WXX_D

Cause

Resolution Notes

When running SQL statement on views TWBS_FDX_WXX and TWBS_FDX_WXX_D recieve Error converting data type nvarchar to numeric. Cause: A comma in data field U_Quantity in table @TWBS_UPS_Lines causing error converting Weight field in view TWBS_FDX_XX and TWBS_FDX_XX_D. Solution: Remove comma from U_Quantity in table @TWBS_UPS_LINES

KB Type

Solution

Item Date

10 Oct 2011