3749297 - sp_shrink simulate reports arithmetic overflow while running shrink device – SAP ASE

• Attempting to reduce a data device file size with sp_shrink using the simulate option results in an error.
• Error message: Arithmetic overflow during implicit conversion of UNSIGNED INT value '2197815296' to an INT field.
• Error code/context: Msg 247, Level 16, State 1; Procedure 'sp_shrinkdevice', Line 359.
• The command used was: sp_shrink 'device', 'dev1','<value>M', 'simulate'

• SAP ERP
• Business Suite on Adaptive Server Enterprise

sp_shrink, device shrink, simulate, arithmetic overflow, error 247, unsigned int to int, conversion error, sp_shrinkdevice, reduce device size, free space exceeded, ase shrink simulate error , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem