ERROR GAME SERVER ProcessMessage MSID 3122!

[Changoleon1]

Hi guys i clean my DB with this querys
USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]

USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]

USE [SRO_VT_SHARD]
GO
truncate table _CharSkill
truncate table _CharSkillMastery
truncate table _GuildMember
truncate table _BlockedWhisperers
truncate table _Inventory
truncate table _InventoryForAvatar
truncate table _InventoryForLinkedStorage
truncate table _TrainingCampMember
truncate table _TrainingCampSubMentorHonorPoint
truncate table _TrainingCampHonorRank
truncate table _TrainingCampBuffStatus
delete from _TrainingCamp
truncate table _StaticAvatar
truncate table _User
truncate table _Friend
truncate table _Memo
truncate table _TimedJob
truncate table _CharTrijobSafeTrade
delete from _CharTrijob
truncate table _InvCOS
delete from _CharCOS where ID > 0
delete from _Char where charid > 0
truncate table _Chest
truncate table _ChestInfo
truncate table _ItemPool
delete from _Items where ID64 > 0
delete from _AccountJID
truncate table _GuildChest
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
truncate table _GuildWar
delete from _Guild where ID > 0
delete from _AlliedClans where ID > 0
truncate table _CharNameList
truncate table _CharQuest
truncate table _ClientConfig
truncate table _DeletedChar
truncate table _SiegeFortressStruct
truncate table _SiegeFortressStoneState
truncate table _SiegeFortressRequest
truncate table _SiegeFortressObject
truncate table _SiegeFortressItemForge
truncate table _SiegeFortressBattleRecord
delete from _SiegeFortress
truncate table _OpenMarket

and when
i start agian my server get error in Gamerserver
This Error
An Exception occurred in CGame::ProcessMessage() MsgID : 3122
i get it when i log in, when i teleport or i used return to some places.
who can help me!!

[MentaL]

[Blacksheep25]

i get it when i log in, when i teleport or i used return to some places.

Check your "_RefRegionBindAssocServer" in the Shard database, make sure you have enabled the regions you want.

Also the error message your getting I think is related to the Green Book. Try looking up how to disable it or use server files that already have it disabled.

Also it makes it easier if you post what server files you are using, what cap and other details you are trying to use as well when making threads.

[Changoleon1]

MY SERVER FILES DONT HAVE GREEN BOOK i disable it, the error start when i Clean my DB

[Blacksheep25]

Well this clean DB query looks fine to me, shouldn't of messed anything up apart from messing up the Fortress War because its cleaning the required tables out.

Use this clean DB script, its the one i used to use :)

Spoiler:

USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [__SiegeFortressStatus__]
TRUNCATE TABLE [__TrijobRanking__]
TRUNCATE TABLE [__TrijobRankingStatus__]
TRUNCATE TABLE [_BlockedUser]
TRUNCATE TABLE [_CasGMChatLog]
--TRUNCATE TABLE [_Notice]
TRUNCATE TABLE [_Punishment]
TRUNCATE TABLE [_ServiceManagerLog]
TRUNCATE TABLE [_ShardCurrentUser]
TRUNCATE TABLE [_SMCLog]
TRUNCATE TABLE [QuaySoEpoint]
TRUNCATE TABLE [SK_CharRenameLog]
TRUNCATE TABLE [SK_DownLevelLog]
TRUNCATE TABLE [SK_ITEM_GuardLog]
TRUNCATE TABLE [SK_ItemSaleLog]
TRUNCATE TABLE [SK_PackageItemSaleLog]
TRUNCATE TABLE [SK_PK_UpdateLog]
TRUNCATE TABLE [SK_ResetSkillLog]
TRUNCATE TABLE [SK_Silk]
TRUNCATE TABLE [SK_SilkBuyList]
TRUNCATE TABLE [SK_SilkChange_BY_Web]
TRUNCATE TABLE [SK_SubtractSilk_VAS]
TRUNCATE TABLE [SR_CharAppoint]
TRUNCATE TABLE [SR_CharNames]
TRUNCATE TABLE [SR_ShardCharNames]
TRUNCATE TABLE [TB_Net2e]
TRUNCATE TABLE [TB_Net2e_Bak]
TRUNCATE TABLE [tb_partnerInfo]
TRUNCATE TABLE [tb_paygate_trans]
TRUNCATE TABLE [_PrivilegedIP]
TRUNCATE TABLE [TB_User]
UPDATE [TB_User] SET AccPlayTime = 0, LatestUpdateTime_ToPlayTime = 0
TRUNCATE TABLE [TB_User_Bak]
TRUNCATE TABLE [Evangelion_uniques]
UPDATE [_ShardService] SET ShardID = '64'
GO
USE [SRO_VT_SHARD]
GO
TRUNCATE TABLE [_Chest]
TRUNCATE TABLE [_ChestInfo]
TRUNCATE TABLE [_User]
TRUNCATE TABLE [_OpenMarket]
DELETE FROM [_AccountJID]
-- start fortress (fix invalid Register Siege Struct gen position is designated! [structure_pos_ja_defensive_17]: [65535, 0.000000, 0.000000, 0.000000])
TRUNCATE TABLE [_SiegeFortressStruct]
TRUNCATE TABLE [_SiegeFortressObject]
TRUNCATE TABLE [_SiegeFortressItemForge]
TRUNCATE TABLE [_SiegeFortressBattleRecord]
TRUNCATE TABLE [_SiegeFortressRequest]
TRUNCATE TABLE [_SiegeFortressStoneState]
DELETE FROM [_SiegeFortress]
EXEC [_InsertSiegeFortress]
DELETE FROM [_SiegeFortressStruct] WHERE RefObjID IN (SELECT ID FROM [_RefObjCommon] WITH (NOLOCK) WHERE TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 5 AND TypeID4 = 6)
DELETE FROM [_SiegeFortressStruct] WHERE RefEventStructID = 107
UPDATE [_SiegeFortressStruct] SET OwnerGuildID = 0
UPDATE [_SiegeFortress] SET GuildID = 0, TaxRatio = 0, Tax = 0, NPCHired = 0, TempGuildID = 0, Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL, IntroductionModificationPermission = 1
-- end fortress
UPDATE [_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0'
DELETE FROM [_GuildMember] WHERE GuildID > 0
DELETE FROM [_Guild] WHERE ID > 0
DBCC CHECKIDENT ([_Guild], RESEED, 0) WITH NO_INFOMSGS;
DELETE FROM [_AlliedClans] WHERE ID > 0
DBCC CHECKIDENT ([_AlliedClans], RESEED, 0) WITH NO_INFOMSGS;
TRUNCATE TABLE [_GuildWar]
TRUNCATE TABLE [_GuildChest]
TRUNCATE TABLE [_InventoryForAvatar]
TRUNCATE TABLE [_BlockedWhisperers]
TRUNCATE TABLE [_TrainingCampMember]
TRUNCATE TABLE [_TrainingCampSubMentorHonorPoint]
TRUNCATE TABLE [_CharTrijobSafeTrade]
DELETE FROM [_CharTrijob] WHERE CharID > 0
TRUNCATE TABLE [_OldTrijob]
TRUNCATE TABLE [_TimedJob]
TRUNCATE TABLE [_StaticAvatar]
TRUNCATE TABLE [_Inventory]
TRUNCATE TABLE [_Memo]
TRUNCATE TABLE [_FlagWorld_EventParticipants]
TRUNCATE TABLE [_FleaMarketNetwork]
TRUNCATE TABLE [_ResultOfPackageItemToMappingWithServerSide]
TRUNCATE TABLE [_Friend]
TRUNCATE TABLE [_CharSkill]
TRUNCATE TABLE [_CharSkillMastery]
TRUNCATE TABLE [_RefObjCharExtraSkill]
TRUNCATE TABLE [_InvCOS]
DELETE FROM [_CharCOS] WHERE ID > 0
DBCC CHECKIDENT ([_CharCOS], RESEED, 0) WITH NO_INFOMSGS;
DELETE FROM [_Char] WHERE CharID > 0
DBCC CHECKIDENT ([_Char], RESEED, 0) WITH NO_INFOMSGS;
TRUNCATE TABLE [_CharCollectionBook]
TRUNCATE TABLE [_CharInstanceWorldData]
TRUNCATE TABLE [_CharNameList]
TRUNCATE TABLE [_CharNickNameList]
TRUNCATE TABLE [_CharQuest]
TRUNCATE TABLE [_ClientConfig]
TRUNCATE TABLE [_DeletedChar]
TRUNCATE TABLE [_GPHistory]
TRUNCATE TABLE [_InventoryForLinkedStorage]
DELETE FROM [_ItemPool] WHERE ItemID > 0
DELETE FROM [_Items] WHERE ID64 > 0
DBCC CHECKIDENT ([_Items], RESEED, 0) WITH NO_INFOMSGS
TRUNCATE TABLE [_BindingOptionWithItem]
TRUNCATE TABLE [_Skill_BaoHiem_TNET]
TRUNCATE TABLE [_TimedJobForPet]
TRUNCATE TABLE [_TrainingCampBuffStatus]
TRUNCATE TABLE [_TrainingCampHonorRank]
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (1)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (2)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (3)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (4)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (5)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (6)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (7)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (8)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (9)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (10)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (11)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (12)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (13)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (14)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (15)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (16)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (17)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (18)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (19)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (20)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (21)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (22)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (23)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (24)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (25)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (26)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (27)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (28)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (29)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (30)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (31)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (32)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (33)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (34)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (35)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (36)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (37)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (38)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (39)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (40)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (41)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (42)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (43)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (44)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (45)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (46)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (47)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (48)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (49)
INSERT INTO [_TrainingCampHonorRank](Ranking) VALUES (50)
EXEC [_TRAINING_CAMP_UPDATEHONORRANK]
DELETE FROM [_TrainingCamp]
DBCC CHECKIDENT ([_TrainingCamp], RESEED, 0) WITH NO_INFOMSGS
TRUNCATE TABLE [Tab_RefRanking_HunterContribution]
TRUNCATE TABLE [Tab_RefRanking_RobberContribution]
TRUNCATE TABLE [Tab_RefRanking_TraderContribution]
GO
USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [_LogCashItem]
TRUNCATE TABLE [_LogEventChar]
TRUNCATE TABLE [_LogEventItem]
TRUNCATE TABLE [_LogEventSiegeFortress]
TRUNCATE TABLE [_LogSchedule]
TRUNCATE TABLE [_LogServerEvent]

After using these queries, make sure you copy the default fortress war structures in. otherwise your fortress war won't work.

[Changoleon1]

i get this when i used your query clean DB

[Blacksheep25]

Looks like your using different files, you might need to change the table name or some column names for the ones that have errors. The rest look like they cleaned the DB fine.

[Changoleon1]

i found the error, the error is when i ejecute the query for Desbug the underbars from f1-f4, but is not the query
is this quest
1 15 3 QEVENT_GUIDE 1

when is enable i get DC and DC only with new chars with old chars all works fine the underbar is not bug anymore
but with new chars ( when i create other one) i get DC and DC and DC every frist thing i make, frist spawn, frist walk, frist attack etc

[blapanda]

First to your QEVENT_GUIDE thing. That quest is buggy for vSRO users. Everyone disables that quest. Just get rid of it and also remove the respective ID from the _CharQuest table.

The other disconnection stuff, are those happening suddenly? Like, sometimes after 5 minutes, or right few seconds after spawning into the gameworld? If so, do the first thing: Remove all Silk from every registered account (SRO_VT_ACC -> _Silk). If this helps, try to setup your billingserver properly.

If this is not helping at all, there might be an issue with the modules you are using, where communication in different ways are failing, and attempting interacting legally with each other, which is in this case won't work.

[skerdikas]

Check your "_RefRegionBindAssocServer" in the Shard database, make sure you have enabled the regions you want.

Also the error message your getting I think is related to the Green Book. Try looking up how to disable it or use server files that already have it disabled.

Also it makes it easier if you post what server files you are using, what cap and other details you are trying to use as well when making threads.

Yea its a greenbook its just a message ignore it


Sent from my iPhone using Tapatalk

[Changoleon1]

fix you can closed thx!