Arithmetic overflow

USE [PS_GameLog]
GO
/****** Object: StoredProcedure [dbo].[usp_Insert_Action_Log_E] Script Date: 02/26/2017 15:55:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER Proc [dbo].[usp_Insert_Action_Log_E]

@UserID varchar(18),
@[Only registered and activated users can see links. Click Here To Register...]ID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTime datetime,
@ActionType tinyint,
@[Only registered and activated users can see links. Click Here To Register...] bigint = null,
@[Only registered and activated users can see links. Click Here To Register...] int = null,
@[Only registered and activated users can see links. Click Here To Register...]3 int = null,
@[Only registered and activated users can see links. Click Here To Register...]4 bigint = null,
@[Only registered and activated users can see links. Click Here To Register...]5 int = null,
@[Only registered and activated users can see links. Click Here To Register...]6 int = null,
@[Only registered and activated users can see links. Click Here To Register...]7 int = null,
@[Only registered and activated users can see links. Click Here To Register...]8 int = null,
@[Only registered and activated users can see links. Click Here To Register...]9 int = null,
@[Only registered and activated users can see links. Click Here To Register...]0 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '',
@[Only registered and activated users can see links. Click Here To Register...] varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1

AS

SET @[Only registered and activated users can see links. Click Here To Register...] = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)


IF(LEN(@mm) = 1)
BEGIN
SET @mm = '0' + @mm
END

IF(LEN(@dd) = 1)
BEGIN
SET @dd = '0' + @dd
END


SET @Sql = N'
INSERT INTO PS_GameLog.dbo.ActionLog (UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID, PosX, PosY, PosZ, ActionTime, ActionType,
Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES(@UserID, @[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]3, @[Only registered and activated users can see links. Click Here To Register...]4, @[Only registered and activated users can see links. Click Here To Register...]5, @[Only registered and activated users can see links. Click Here To Register...]6, @[Only registered and activated users can see links. Click Here To Register...]7, @[Only registered and activated users can see links. Click Here To Register...]8, @[Only registered and activated users can see links. Click Here To Register...]9, @[Only registered and activated users can see links. Click Here To Register...]0, @Text1, @Text2, @Text3, @Text4)'



EXEC sp_executesql @Sql,
N'@UserID varchar(18), @[Only registered and activated users can see links. Click Here To Register...]ID int, @CharID int, @CharName varchar(50),
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint,
@[Only registered and activated users can see links. Click Here To Register...] bigint, @[Only registered and activated users can see links. Click Here To Register...] int, @[Only registered and activated users can see links. Click Here To Register...]3 int, @[Only registered and activated users can see links. Click Here To Register...]4 bigint, @[Only registered and activated users can see links. Click Here To Register...]5 int, @[Only registered and activated users can see links. Click Here To Register...]6 int, @[Only registered and activated users can see links. Click Here To Register...]7 int, @[Only registered and activated users can see links. Click Here To Register...]8 int,
@[Only registered and activated users can see links. Click Here To Register...]9 int, @[Only registered and activated users can see links. Click Here To Register...]0 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]3, @[Only registered and activated users can see links. Click Here To Register...]4, @[Only registered and activated users can see links. Click Here To Register...]5, @[Only registered and activated users can see links. Click Here To Register...]6, @[Only registered and activated users can see links. Click Here To Register...]7, @[Only registered and activated users can see links. Click Here To Register...]8, @[Only registered and activated users can see links. Click Here To Register...]9, @[Only registered and activated users can see links. Click Here To Register...]0, @Text1, @Text2, @Text3, @Text4