Curious Error

[TeddyBear94]

Hey Guys i have noticed a curious error in my loggs and tbh i have no clue how they appeared nor how i should fix them.
I already executed the usp_save_char_info_e new but yet it doesnt made any difference.
I would be rly glad if anyone got a clue or a hint for that prob

 Spoiler

//PS_DBAGENT__charsave log start (DBAgent01)

--<begin>2013-04-23 11:14:15,smoky,1,Tedde,153

{?=call usp_Save_Char_Info_E(153,70, 0,5, 10,19,9,7,8,12, 6064,474,1406, 43,250, 21000,200000, 1141.413208,16.317999,1597.816772, 0,200,0,0,0, 1000000,0,0,0)}

EXEC usp_Save_User_StoredMoney_E 1,1,302

{?=call Usp_Save_Char_Item_Mod_E(153,3831810757377458176, 1,20, 800, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(153,3831810757377523712, 1,21, 800, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(153,3831810757377589248, 1,22, 600, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(153,3831810757377654784, 1,23, 600, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(153,3831810757377720320, 2,23, 400, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(153,3831812629983199232, 3,23, 800, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(153,3831812629983264768, 4,23, 800, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(153,3831812629983330304, 5,23, 600, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_ApplySkill_Del_E(153,0,0,1)}

EXEC usp_Save_Char_QuickSlot_Del_E 153

--<end>2013-04-23 11:14:15,smoky,1,Tedde,153

 Spoiler

2013-04-23 11:14:15 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., SQL STATE: 21000, NATIVE ERROR: 512 (0x200)

2013-04-23 11:14:15 ::SaveCharacter 153 Tedde ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(153,70,0,5,10,19,9,7,8,12,606 4,474,1406,43,250,21000,200000,'1141.413208','16.3 17999','1597.816772', 0,200,0,0,0, 1000000,0,0,0, 0,0)}

2013-04-23 11:14:15 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., SQL STATE: 21000, NATIVE ERROR: 512 (0x200)

2013-04-23 11:14:15 ::SaveCharacter 153 Tedde ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(153,70,0,5,10,19,9,7,8,12,606 4,474,1406,43,250,21000,200000,'1141.413208','16.3 17999','1597.816772', 0,200,0,0,0, 1000000,0,0,0, 0,0)}

2013-04-23 11:18:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., SQL STATE: 21000, NATIVE ERROR: 512 (0x200)

2013-04-23 11:18:52 ::SaveCharacter 153 Tedde ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(153,70,0,5,10,19,9,7,8,12,606 4,474,1406,43,46,21000,200000,'1142.076660','16.57 8924','1596.968750', 0,200,0,0,0, 1000000,0,0,0, 0,0)}

2013-04-23 11:18:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., SQL STATE: 21000, NATIVE ERROR: 512 (0x200)

2013-04-23 11:18:52 ::SaveCharacter 153 Tedde ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(153,70,0,5,10,19,9,7,8,12,606 4,474,1406,43,46,21000,200000,'1142.076660','16.57 8924','1596.968750', 0,200,0,0,0, 1000000,0,0,0, 0,0)}

2013-04-23 12:44:13 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., SQL STATE: 21000, NATIVE ERROR: 512 (0x200)

2013-04-23 12:44:13 ::SaveCharacter 146 TeddyBear ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(146,70,0,5,14,12,9,8,7,15,651 4,909,1806,43,96,21000,136120,'1115.584351','14.66 3244','1583.717163', 0,200,0,0,0, 200000,0,0,0, 0,0)}

2013-04-23 12:44:13 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., SQL STATE: 21000, NATIVE ERROR: 512 (0x200)

 Spoiler

2013-04-23 10:59:52 PS_GAME__system log start (Game01) [KR]

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/sorp1

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/croco1

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/croco2

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/Troll1

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/Spink1

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/GoldenPig

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/Sorp3

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/SorpNamed1

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/SorpNamed2

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/Sorp2

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/CrocoNamed1

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/CrocoNamed2

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/CrocoNamed3

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/OrcNamed1

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/OrcNamed2

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/OrcNamed3

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/TrollNamed1

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/Deinos

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/Parridalis

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/Alcarian

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/ZinAlcaria

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/Belizabeth

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/Kirhiross

2013-04-23 10:59:52 Loaded Behavior In Factory : data/ai/CrypticOne

2013-04-23 10:59:53 Loaded Behavior In Factory : data/ai/Haruhion

2013-04-23 10:59:53 Loaded Behavior In Factory : data/ai/Freezing

2013-04-23 10:59:53 RandomOption Error : ItemID=6179, byServer=3, Wis=0

2013-04-23 10:59:53 RandomOption Error : ItemID=10132, byServer=3, Wis=0

2013-04-23 10:59:53 RandomOption Error : ItemID=40172, byServer=6, Wis=0

2013-04-23 11:00:34 <Console input> /nprotectoff

2013-04-23 11:00:34 <Console output> cmd NProtect off ok

2013-04-23 11:00:58 connect mgr 864

2013-04-23 11:00:58 connect dbagent 868

2013-04-23 11:00:58 connect dbagent2 872

2013-04-23 11:00:58 connect gamelog 888

2013-04-23 11:00:59 Market End -----------------------

2013-04-23 11:00:59 cannot open .\Data\Lua\145.lua: No such file or directory

2013-04-23 11:14:15 discon client: (104, 1236) T=000:00:00:000, RC=2,RCS=0, RB=32,RBS=1, SC=23,SCS=1, SB=1859,SBS=84

2013-04-23 12:01:09 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 12:44:13 discon client: (104, 1236) T=000:00:00:000, RC=2,RCS=0, RB=32,RBS=1, SC=23,SCS=1, SB=1252,SBS=59

2013-04-23 13:01:10 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 14:01:10 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 15:01:11 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 16:01:11 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 17:01:11 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 18:01:11 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 19:01:12 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 19:13:06 discon client: (104, 1236) T=000:00:00:000, RC=2,RCS=0, RB=32,RBS=0, SC=23,SCS=0, SB=1252,SBS=30

2013-04-23 19:28:08 discon client: (104, 1236) T=000:01:00:000, RC=10,RCS=0, RB=106,RBS=1, SC=101,SCS=1, SB=2814,SBS=38

2013-04-23 19:43:09 discon client: (104, 1236) T=000:02:00:000, RC=6,RCS=0, RB=48,RBS=0, SC=89,SCS=0, SB=2617,SBS=16

2013-04-23 20:01:12 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 20:51:58 discon client: (104, 1236) T=000:00:00:000, RC=2,RCS=0, RB=32,RBS=2, SC=23,SCS=1, SB=1859,SBS=154

2013-04-23 21:01:12 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2013-04-23 21:26:32 3 1 SERVICE_CONTROL_STOP

2013-04-23 21:26:32 Call save all waiting...

2013-04-23 21:26:32 1 1 SAgent:isconnect: (3, 1236)

2013-04-23 21:26:32 1 1 T=010:25:00:000, RC=99,RCS=0, RB=1852,RBS=0, SC=193,SCS=0, SB=4521,SBS=0

2013-04-23 21:26:32 1 1 SAgent:isconnect: (3, 1236)

2013-04-23 21:26:32 1 1 T=010:25:00:000, RC=92,RCS=0, RB=2420,RBS=0, SC=119,SCS=0, SB=509,SBS=0

2013-04-23 21:26:32 1 1 SAgent:isconnect: (3, 1236)

2013-04-23 21:26:32 1 1 T=010:25:00:000, RC=302,RCS=0, RB=30439,RBS=0, SC=254,SCS=0, SB=2689,SBS=0

2013-04-23 21:26:32 1 1 SAgent:isconnect: (3, 1236)

2013-04-23 21:26:32 1 1 T=010:25:00:000, RC=83,RCS=0, RB=332,RBS=0, SC=135,SCS=0, SB=892,SBS=0

2013-04-23 21:26:32 discon mgr ((3,1236, 1852,4521)

2013-04-23 21:26:32 mgr Connection Lost INFO : T=010:25:00:000, RC=99,RCS=0, RB=1852,RBS=0, SC=193,SCS=0, SB=4521,SBS=0

2013-04-23 21:26:32 mgr server disconnection

2013-04-23 21:26:32 1 1 SAgent:isconnect: (3, 1236)

2013-04-23 21:26:32 1 1 T=010:25:00:000, RC=85,RCS=0, RB=340,RBS=0, SC=171,SCS=0, SB=5756,SBS=0

2013-04-23 21:26:32 discon gamelog ((3,1236, 340,5756)

2013-04-23 21:26:32 gamelog Connection Lost INFO : T=010:25:00:000, RC=85,RCS=0, RB=340,RBS=0, SC=171,SCS=0, SB=5756,SBS=0

2013-04-23 21:26:32 game log server disconnection

2013-04-23 21:26:32 discon dbagent2 ((3,1236, 2420,509)

2013-04-23 21:26:32 dbagent2 Connection Lost INFO : T=010:25:00:000, RC=92,RCS=0, RB=2420,RBS=0, SC=119,SCS=0, SB=509,SBS=0

2013-04-23 21:26:32 db agent2 server disconnected...

2013-04-23 21:26:32 discon dbagent ((3,1236, 30439,2689)

2013-04-23 21:26:32 discon userlog ((3,1236, 332,892)

2013-04-23 21:26:32 dbagent Connection Lost INFO : T=010:25:00:000, RC=302,RCS=0, RB=30439,RBS=0, SC=254,SCS=0, SB=2689,SBS=0

2013-04-23 21:26:32 userlog Connection Lost INFO : T=010:25:00:000, RC=83,RCS=0, RB=332,RBS=0, SC=135,SCS=0, SB=892,SBS=0

2013-04-23 21:26:32 db agent server disconnected...

2013-04-23 21:26:32 userlog log server disconnection

2013-04-23 21:26:32 call disconnectAll...

2013-04-23 21:26:32 server shutdown Connection INFO : T=010:26:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=15,CReq=15,CCnt=15,DCCnt=15, CTimeT=000:37:00:000,CTimeAvg=000:02:00:000, RBT=3954,RBS=0,RBSC=1,SBT=54234,SBS=1,SBSC=24

2013-04-23 21:26:32 Save Shaiya.SData 2

2013-04-23 21:26:32 PS_GAME__system log end (Game01)

2013-04-23 21:26:32 3 1 SService::ServiceCtrlDispatcher(): service shutdown

 Spoiler

2013-04-23 10:59:52 PS_LOGIN__system log start (Login01)

2013-04-23 11:00:24 <Console input> /vchkoff

2013-04-23 11:00:24 <Console output> cmd version chk off ok

2013-04-23 12:00:03 cmd_auto server info log

user = 0 (0/500)

2013-04-23 12:00:03 T=001:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=5,CReq=5,CCnt=5,DCCnt=5, CTimeT=000:05:00:000,CTimeAvg=000:01:00:000, RBT=821,RBS=0,RBSC=2,SBT=1151,SBS=0,SBSC=3

2013-04-23 12:00:03 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 13:00:05 cmd_auto server info log

user = 0 (0/500)

2013-04-23 13:00:05 T=002:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=7,CReq=7,CCnt=7,DCCnt=7, CTimeT=000:06:00:000,CTimeAvg=000:00:00:000, RBT=1209,RBS=0,RBSC=3,SBT=1705,SBS=0,SBSC=4

2013-04-23 13:00:05 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 14:00:05 cmd_auto server info log

user = 0 (0/500)

2013-04-23 14:00:05 T=003:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=7,CReq=7,CCnt=7,DCCnt=7, CTimeT=000:06:00:000,CTimeAvg=000:00:00:000, RBT=1209,RBS=0,RBSC=3,SBT=1705,SBS=0,SBSC=4

2013-04-23 14:00:05 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 15:00:06 cmd_auto server info log

user = 0 (0/500)

2013-04-23 15:00:06 T=004:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=7,CReq=7,CCnt=7,DCCnt=7, CTimeT=000:06:00:000,CTimeAvg=000:00:00:000, RBT=1209,RBS=0,RBSC=3,SBT=1705,SBS=0,SBSC=4

2013-04-23 15:00:06 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 16:00:06 cmd_auto server info log

user = 0 (0/500)

2013-04-23 16:00:06 T=005:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=7,CReq=7,CCnt=7,DCCnt=7, CTimeT=000:06:00:000,CTimeAvg=000:00:00:000, RBT=1209,RBS=0,RBSC=3,SBT=1705,SBS=0,SBSC=4

2013-04-23 16:00:06 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 17:00:06 cmd_auto server info log

user = 0 (0/500)

2013-04-23 17:00:06 T=006:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=7,CReq=7,CCnt=7,DCCnt=7, CTimeT=000:06:00:000,CTimeAvg=000:00:00:000, RBT=1209,RBS=0,RBSC=3,SBT=1705,SBS=0,SBSC=4

2013-04-23 17:00:06 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 18:00:06 cmd_auto server info log

user = 0 (0/500)

2013-04-23 18:00:06 T=007:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=7,CReq=7,CCnt=7,DCCnt=7, CTimeT=000:06:00:000,CTimeAvg=000:00:00:000, RBT=1209,RBS=0,RBSC=3,SBT=1705,SBS=0,SBSC=4

2013-04-23 18:00:06 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 19:00:07 cmd_auto server info log

user = 0 (0/500)

2013-04-23 19:00:07 T=008:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=7,CReq=7,CCnt=7,DCCnt=7, CTimeT=000:06:00:000,CTimeAvg=000:00:00:000, RBT=1209,RBS=0,RBSC=3,SBT=1705,SBS=0,SBSC=4

2013-04-23 19:00:07 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 20:00:07 cmd_auto server info log

user = 0 (0/500)

2013-04-23 20:00:07 T=009:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=15,CReq=15,CCnt=15,DCCnt=15, CTimeT=000:09:00:000,CTimeAvg=000:00:00:000, RBT=2761,RBS=0,RBSC=4,SBT=3921,SBS=0,SBSC=6

2013-04-23 20:00:07 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 21:00:07 cmd_auto server info log

user = 0 (0/500)

2013-04-23 21:00:07 T=010:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=18,CReq=18,CCnt=18,DCCnt=18, CTimeT=000:10:00:000,CTimeAvg=000:00:00:000, RBT=3343,RBS=0,RBSC=5,SBT=4752,SBS=0,SBSC=7

2013-04-23 21:00:07 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2013-04-23 21:26:32 3 1 SERVICE_CONTROL_STOP

2013-04-23 21:26:32 1 1 SAgent:isconnect: (3, 1236)

2013-04-23 21:26:32 1 1 T=010:26:00:000, RC=147,RCS=0, RB=972,RBS=0, SC=3909,SCS=0, SB=32274,SBS=0

2013-04-23 21:26:32 1 1 SAgent:isconnect: (3, 1236)

2013-04-23 21:26:32 1 1 T=010:26:00:000, RC=83,RCS=0, RB=332,RBS=0, SC=119,SCS=0, SB=509,SBS=0

2013-04-23 21:26:32 mgr server disconnection

2013-04-23 21:26:32 log system server disconnection

2013-04-23 21:26:32 PS_LOGIN__system log end (Login01)

2013-04-23 21:26:32 3 1 SService::ServiceCtrlDispatcher(): service shutdown

[castor4878]

- in

call usp_Save_Char_Info_E(153,70,0,5,10,19,9,7,8,12,606 4,474,1406,43,250,21000,200000,'1141.413208','16.3 17999','1597.816772', 0,200,0,0,0, 1000000,0,0,0, 0,0)

the Hp parameter is "606 4" instead of 6064; is it a typo due to log process or copy/paste in this post?

- usp_Save_Char_Info_E, the "classical" one does not perform any subquery, it only contains a where clause with the @CharID argument.
did u change that SP ? can u post the one u are using?

[TeddyBear94]

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_Char_Info_E] Script Date: 04/24/2013 19:50:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Save_Char_Info_E]

@CharID int,
@Level int,
@StatPoint smallint,
@SkillPoint smallint,
@Str smallint,
@Dex smallint,
@Rec smallint,
@Int smallint,
@Wis smallint,
@Luc smallint,
@Hp smallint,
@Mp smallint,
@Sp smallint,
@Map smallint,
@Dir smallint,
@Exp int,
@Money int,
@Posx real,
@Posy real,
@Posz real,
@Hg int,
@Vg int,
@Cg int,
@Og int,
@Ig int,
@K1 int = null,
@K2 int = null,
@K3 int = null,
@K4 int = null,
@KillLevel tinyint,
@DeadLevel tinyint

AS

SET NOCOUNT ON

DECLARE @ServerID int
SET @ServerID = 1

UPDATE Chars
SET [Level] = @Level, StatPoint = @StatPoint, SkillPoint = @SkillPoint,
[Str] = @Str, dex = @Dex, Rec = @Rec, [int] = @Int, Wis = @Wis, Luc = @Luc,
HP = @Hp, Mp = @Mp, Sp = @Sp,
Map = @Map, dir = @Dir, [exp] = @Exp, [money] = @Money,
PosX = @Posx, PosY = @PosY, PosZ = @PosZ, hg = @Hg, vg = @Vg, cg = @Cg, og = @Og, ig = @Ig,
KillLevel=@KillLevel, DeadLevel=@DeadLevel,LeaveDate=GETDATE()
WHERE CharID = @CharID

IF( (@K1 IS NOT NULL) AND (@K2 IS NOT NULL) AND (@K3 IS NOT NULL) AND (@K4 IS NOT NULL))
BEGIN
UPDATE Chars SET K1=@K1, K2=@K2, K3=@K3, K4=@K4 WHERE CharID=@CharID
END

--EXEC PS_USERDB01.PS_UserData_IDC_T3.dbo.usp_Update_Char sPVPData_E @ServerID = @ServerID, @CharID = @CharID, @K1 = @K1, @K2 = @K2, @K3 = @K3, @K4 = @K4

IF(@@ERROR = 0 AND @@ROWCOUNT = 1)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

SET NOCOUNT OFF

thats the one i use and no i never changed that one ö.ö
the problem appeared out of nowhere D:

[x-DoeSn'TxMaTTeR-x]

Source:

Charlie___XXX25 Points:
0
set @assignedID = (select ID from RecordTable where DateSubmitted = @dateSubmitted)



my guess is that you get that error because you insert more than one record with the same datesubmitted value.

Reply Quote
Tuesday, June 26, 2007 3:02 PM

SomeDeveloperPerson130 Points


0
Charlie___XXX wrote:
set @assignedID = (select ID from RecordTable where DateSubmitted = @dateSubmitted)

my guess is that you get that error because you insert more than one record with the same datesubmitted value.




That's not possible. The error occurs even when the RecordTable is empty.
Reply Quote
Tuesday, June 26, 2007 3:10 PM

SomeDeveloperPerson130 Points


1
SomeDeveloperPerson wrote:
Charlie___XXX wrote:
set @assignedID = (select ID from RecordTable where DateSubmitted = @dateSubmitted)

my guess is that you get that error because you insert more than one record with the same datesubmitted value.




That's not possible. The error occurs even when the RecordTable is empty.


Charlie... you're actually correct. I modified the line to:
Code Snippet
set @assignedID = (select MAX(ID) from RecordTable where DateSubmitted = @dateSubmitted)



And it works with no problems now. Apparently the code is executing faster than expected so that several records are being written in under a millisecond.

[castor4878]

your example is perfect DSTM

set @assignedID = (select ID from RecordTable where DateSubmitted = @dateSubmitted)

is indeed inherently invalid.

but the original usp_Save_Char_Info_E and the version posted by Teddy doesn't contain such statement.

I also assume that the call to the unknown "sp_Update_Char sPVPData_E" proc is actually in a comment (the log does not indicate that error occured in that SP neither).

The error has so far no explanation with the given information.

Teddy, the calls logged in the out file can be executed (as any valid sql stmt), so try to execute one of the

call usp_Save_Char_Info_E(153,70,0,5,10,19,9,7,8,12,606 4,474,1406,43,250,21000,200000,'1141.413208','16.3 17999','1597.816772', 0,200,0,0,0, 1000000,0,0,0, 0,0)

in a query window. add all useful output in the SP, eg:

PRINT 'step N' + @CharID

-------------------------------------------------------------------------

after 5th reading ... there is non consistant definition.

the PS_BDAGENT logs:

usp_Save_Char_Info_E(153,70, 0,5, 10,19,9,7,8,12, 6064,474,1406, 43,250, 21000,200000, 1141.413208,16.317999,1597.816772, 0,200,0,0,0, 1000000,0,0,0)

so it manages posX, posY, posZ as reals and it doesn't transmit the @KillLevel and @DeadLevel parameters ... this is (except enormous mistake) not possible, these last 2 params are mandatory.

meantime, the SP you provided does define:

[...] Proc [usp_Save_Char_Info_E]

@CharID int, @Level int, @StatPoint smallint, @SkillPoint smallint,
@Str smallint, @Dex smallint, @Rec smallint, @Int smallint, @Wis smallint, @Luc smallint,
@Hp smallint, @Mp smallint, @Sp smallint,
@Map smallint, @Dir smallint, @Exp int, @Money int,
@Posx real, @Posy real, @Posz real,
@Hg int, @Vg int, @Cg int, @Og int, @Ig int,
@K1 int = null, @K2 int = null, @K3 int = null, @K4 int = null,
@KillLevel tinyint, @DeadLevel tinyint

where posX|Y|Z are indeed real, so the call would be correct, expect the 2 missing last params.

OOH, the second log gives:

2013-04-23 11:14:15 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., SQL STATE: 21000, NATIVE ERROR: 512 (0x200)

2013-04-23 11:14:15 ::SaveCharacter 153 Tedde ret=1, qerr=-1, {
?=call usp_Save_Char_Info_E(153,70,0,5,10,19,9,7,8,12,606 4,474,1406,43,250,21000,200000,'1141.413208','16.3 17999','1597.816772', 0,200,0,0,0, 1000000,0,0,0, 0,0)}

where one reads:

usp_Save_Char_Info_E(153,70,0,5,10,19,9,7,8,12, 6064, 474,1406, 43,250,21000,200000,
'1141.413208','16.3 17999','1597.816772',
0,200,0,0,0,
1000000,0,0,0,
0,0)

the 3 coords are transmitted as string (they are single-quoted) (and the Kill / Dead levels are provided)

this point shall be fixed. your SP excepts real or string but not both, and function overloading is AFAIK not supported by SQL (we can not have both with 2 prototypes).

my own SP is:

 Spoiler

USE [PS_GameData]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER Proc [dbo].[usp_Save_Char_Info_E]

@CharID int,
@Level int,
@StatPoint smallint,
@SkillPoint smallint,
@Str smallint,
@Dex smallint,
@Rec smallint,
@Int smallint,
@Wis smallint,
@Luc smallint,
@Hp smallint,
@Mp smallint,
@Sp smallint,
@Map smallint,
@Dir smallint,
@Exp int,
@Money int,
@posSX varchar(32),
@posSY varchar(32),
@posSZ varchar(32),
@Hg int,
@Vg int,
@Cg int,
@Og int,
@Ig int,
@K1 int = null,
@K2 int = null,
@K3 int = null,
@K4 int = null,
@KillLevel tinyint,
@DeadLevel tinyint

AS

SET NOCOUNT ON

DECLARE
@posX real,
@posY real,
@posZ real

IF (ISNumeric(@posSX)=1 and ISNumeric(@posSY)=1 and ISNumeric(@posSZ)=1)
BEGIN
SET @posX = CAST(@posSX as real)
SET @posY = CAST(@posSY as real)
SET @posZ = CAST(@posSZ as real)
END
ELSE
BEGIN
-- gets here if there is an error in the positions, likely a bot or exploit.
SET @Map = 42
SET @posX = 66.5
SET @posY = 2.0
SET @posZ = 52.6
END

UPDATE Chars SET
[Level]=@Level, StatPoint=@StatPoint, SkillPoint=@SkillPoint,
[Str]=@Str, Dex=@Dex, Rec=@Rec, [Int]=@Int, Wis=@Wis, Luc=@Luc,
HP=@Hp, Mp=@Mp, Sp=@Sp, Map=@Map, Dir=@Dir, [Exp]=@Exp, [Money]=@Money,
PosX=@posX, PosY=@posY, PosZ=@posZ, Hg=@Hg, Vg=@Vg, Cg=@Cg, Og=@Og, Ig=@Ig,
KillLevel=@KillLevel, DeadLevel=@DeadLevel, LeaveDate=GETDATE()
WHERE CharID=@CharID

IF ((@K1 IS NOT NULL) AND (@K2 IS NOT NULL) AND (@K3 IS NOT NULL) AND (@K4 IS NOT NULL))
BEGIN
UPDATE Chars SET K1=@K1, K2=@K2, K3=@K3, K4=@K4 WHERE CharID=@CharID
END

IF(@@ERROR = 0 AND @@ROWCOUNT = 1)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

SET NOCOUNT OFF

where coords are given as string and the final client (the PS_Login.exe and PS_Game.exe) shall comply with this declaration and thus provide a pointer to string, not a real8.

may be the ODBC middleware manages the coercion of data.
but may be this real / string mistake is the cause of your error, the SP failed to be called due to invalid parameter and reported errors are wrong (exact cause is lost bacuse no actual call is made).

you should check this assumption with the SP above.

[TeddyBear94]

error got fixed
i noticed that i deleated all my chars and accounts and made new accounts which was the problem as the old items from that accounts caused these problems. i moved the new accounts to UserUID 50+ and now it works all fine.
thats for the input the thread can be closed

[JohnHeatz]

#Closed as requested