MuEmu S4 F-TEAM: Dataserver [ODBC SQL Server Drive

[AkrooS]

Erro acontece no Dataserver [ODBC SQL Server Driver]Invalid cursor state (...)

Depois de algumas horas ou as vezes minutos, o erro acontece sem mais nem menos no dataserver. Não consigo achar uma pista do que isso pode ser em nenhum outro log... por favor alguem poderia me ajudar a achar este erro? Será na ODBC? Ou na conexão com ODBC caindo?

Já tentei:
- Alterar o Dataserver.
- Reinstalar o SQL em outra versão.
- Reinstalar ODBC (Inclusive manualmente).
- Liberar portas adicionais.

Imagem do erro:

Log do Erro:

21:10:26 SELECT Name FROM QuestKillCount WHERE Name='ReVoLTaa'
21:10:26 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:10:26 INSERT INTO QuestKillCount (Name,QuestIndex,MonsterClass1,KillCount1,MonsterC lass2,KillCount2,MonsterClass3,KillCount3,MonsterC lass4,KillCount4,MonsterClass5,KillCount5) VALUES ('ReVoLTaa',-1,-1,0,-1,0,-1,0,-1,0,-1,0)
21:10:26 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:10:26 SELECT Name FROM MasterSkillTree WHERE Name='ReVoLTaa'
21:10:26 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:10:26 INSERT INTO MasterSkillTree (Name,MasterLevel,MasterPoint,MasterExperience) VALUES ('ReVoLTaa',1,1,65653259)
21:10:26 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:10:30 EXEC WZ_GetItemSerial
21:10:30 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:10:43 EXEC WZ_GetItemSerial
21:10:43 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:10:48 EXEC WZ_GetItemSerial
21:10:48 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:10:54 EXEC WZ_GetItemSerial
21:10:54 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:03 UPDATE Character SET cLevel=400,Class=1,LevelUpPoint=3215,Experience=-472819216,Strength=18,Dexterity=50018,Vitality=100 15,Energy=60030,Leadership=0,Inventory=?,MagicList =?,Money=1975197900,Life=20459.000000,MaxLife=2045 9.000000,Mana=120858.000000,MaxMana=120858.000000, BP=35021.000000,MaxBP=35021.000000,Shield=161029.0 00000,MaxShield=161029.000000,MapNumber=0,MapPosX= 141,MapPosY=127,MapDir=0,PkCount=0,PkLevel=3,PkTim e=0,Quest=?,EffectList=?,FruitAddPoint=0,FruitSubP oint=0 WHERE AccountID='hueider' AND Name='AnGeL'
21:11:03 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:03 SELECT Name FROM QuestKillCount WHERE Name='AnGeL'
21:11:03 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:03 INSERT INTO QuestKillCount (Name,QuestIndex,MonsterClass1,KillCount1,MonsterC lass2,KillCount2,MonsterClass3,KillCount3,MonsterC lass4,KillCount4,MonsterClass5,KillCount5) VALUES ('AnGeL',5,409,0,410,0,411,0,-1,0,-1,0)
21:11:03 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:03 SELECT Name FROM MasterSkillTree WHERE Name='AnGeL'
21:11:03 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:03 INSERT INTO MasterSkillTree (Name,MasterLevel,MasterPoint,MasterExperience) VALUES ('AnGeL',0,0,0)
21:11:03 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:03 SELECT GUID FROM T_FriendMain WHERE Name='AnGeL'
21:11:03 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:04 SELECT * FROM Character WHERE AccountID='hueider' AND Name='AnGeL'
21:11:04 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:08 UPDATE Character SET cLevel=400,Class=33,LevelUpPoint=2235,Experience=-472819216,Strength=10022,Dexterity=50025,Vitality= 10020,Energy=50015,Leadership=0,Inventory=?,MagicL ist=?,Money=1970461920,Life=18354.000000,MaxLife=2 0479.000000,Mana=75528.000000,MaxMana=75628.000000 ,BP=25950.000000,MaxBP=26020.000000,Shield=157323. 000000,MaxShield=157323.000000,MapNumber=42,MapPos X=97,MapPosY=188,MapDir=2,PkCount=0,PkLevel=3,PkTi me=0,Quest=?,EffectList=?,FruitAddPoint=0,FruitSub Point=0 WHERE AccountID='schub' AND Name='XAROPINHA'
21:11:08 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:08 SELECT Name FROM QuestKillCount WHERE Name='XAROPINHA'
21:11:08 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:08 INSERT INTO QuestKillCount (Name,QuestIndex,MonsterClass1,KillCount1,MonsterC lass2,KillCount2,MonsterClass3,KillCount3,MonsterC lass4,KillCount4,MonsterClass5,KillCount5) VALUES ('XAROPINHA',6,412,0,-1,0,-1,0,-1,0,-1,0)
21:11:08 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:08 SELECT Name FROM MasterSkillTree WHERE Name='XAROPINHA'
21:11:08 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:08 INSERT INTO MasterSkillTree (Name,MasterLevel,MasterPoint,MasterExperience) VALUES ('XAROPINHA',0,0,0)
21:11:08 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:38 SELECT Id FROM AccountCharacter WHERE Id='hueider'
21:11:38 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:38 INSERT INTO AccountCharacter (Id) VALUES ('hueider')
21:11:38 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:11:38 SELECT * FROM AccountCharacter WHERE Id='hueider'
21:11:38 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:12:01 UPDATE Character SET cLevel=262,Class=17,LevelUpPoint=30353,Experience= 185760300,Strength=65000,Dexterity=20020,Vitality= 5025,Energy=1010,Leadership=0,Inventory=?,MagicLis t=?,Money=934868579,Life=15632.000000,MaxLife=1563 2.000000,Mana=1150.000000,MaxMana=1150.000000,BP=1 6271.000000,MaxBP=16271.000000,Shield=118709.00000 0,MaxShield=118709.000000,MapNumber=3,MapPosX=177, MapPosY=100,MapDir=6,PkCount=0,PkLevel=3,PkTime=0, Quest=?,EffectList=?,FruitAddPoint=0,FruitSubPoint =0 WHERE AccountID='iori' AND Name='sabotage'
21:12:01 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:12:01 SELECT Name FROM QuestKillCount WHERE Name='sabotage'
21:12:01 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:12:01 INSERT INTO QuestKillCount (Name,QuestIndex,MonsterClass1,KillCount1,MonsterC lass2,KillCount2,MonsterClass3,KillCount3,MonsterC lass4,KillCount4,MonsterClass5,KillCount5) VALUES ('sabotage',-1,-1,0,-1,0,-1,0,-1,0,-1,0)
21:12:01 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:12:01 SELECT Name FROM MasterSkillTree WHERE Name='sabotage'
21:12:01 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:12:01 INSERT INTO MasterSkillTree (Name,MasterLevel,MasterPoint,MasterExperience) VALUES ('sabotage',0,0,0)
21:12:01 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:12:01 SELECT GUID FROM T_FriendMain WHERE Name='sabotage'
21:12:01 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:12:26 SELECT * FROM AccountCharacter WHERE Id='hueider'
21:12:26 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:12:59 EXEC WZ_GetItemSerial
21:12:59 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:13:44 SELECT Id FROM AccountCharacter WHERE Id='hueider'
21:13:44 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:13:44 INSERT INTO AccountCharacter (Id) VALUES ('hueider')
21:13:44 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:13:44 SELECT * FROM AccountCharacter WHERE Id='hueider'
21:13:44 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:15:07 DELETE MuCastle_NPC WHERE MAP_SVR_GROUP = 0
21:15:07 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:15:19 SELECT Id FROM AccountCharacter WHERE Id='HUEIDER'
21:15:19 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:15:19 INSERT INTO AccountCharacter (Id) VALUES ('HUEIDER')
21:15:19 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:15:19 SELECT * FROM AccountCharacter WHERE Id='HUEIDER'
21:15:19 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:15:57 EXEC WZ_GetItemSerial
21:15:57 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:17:05 SELECT Id FROM AccountCharacter WHERE Id='hueider'
21:17:05 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:17:05 INSERT INTO AccountCharacter (Id) VALUES ('hueider')
21:17:05 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
21:17:05 SELECT * FROM AccountCharacter WHERE Id='hueider'
21:17:05 [QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid cursor state

Eu uso:
MuEmu S4 F-Team.
Windows Server 2012 R2.
SQL 2008 R2 (O mesmo erro acontece no SQL 2014).

[blado]

Estou com o mesmo erro se alguem poder ajudar a gente ae ^^

[blado]

eu rodei isso e deu certo agora, nao ta mais sumindo os char quando eu dou pk e vou trocar de char

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Z_PK_HERO] ON [dbo].[Character]
AFTER UPDATE
AS

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @rank int
DECLARE @valor int
DECLARE @char varchar(10)

SELECT @valor = PkCount FROM DELETED
SELECT @rank = PkCount, @char = Name FROM INSERTED

IF (@rank > 0) and (@rank > @valor)
UPDATE [dbo].[Character]
SET Z_RankPK = Z_RankPK + (@rank-@valor)
WHERE Name = @char
ELSE
IF (@rank < 0) and (@rank < @valor)
UPDATE [dbo].[Character]
SET Z_RankHR = Z_RankHR + (@valor-@rank)
WHERE Name = @char

SET NOCOUNT OFF
SET XACT_ABORT OFF