LINK_REGION ERROR

10/23/2017 01:31 Twistin**#1

Hello,
I have issue with my database
but i can't find a solution
i didn't make a backup since a long time ago
and now my database start to give me this errors on gameserver
it was working fine but i don't remember what i have done to
result this issue,
i don't have a backup and i can't fix this error
i am looking for help if anyone can help fixing this error without restore old
database backup, the problem not inside server Data folder
because i've tried alot of files and still the same error
and when i make a rollback ( restore old backup )
the problem not appear

Quote:

2017-10-22 19:25:57 [SR_GameServer] Invalid Region!![ID:41][ObjName128:????]
2017-10-22 19:25:57 [SR_GameServer] At initialize Server, Loading Siege data :: CurrentTax = 0
2017-10-22 19:25:57 [SR_GameServer] At initialize Server, Loading Siege data :: CurrentTax = 17820427041
2017-10-22 19:25:57 [SR_GameServer] At initialize Server, Loading Siege data :: CurrentTax = 0
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,86) -> (202,86)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,86) -> (202,87)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,86) -> (204,87)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,86) -> (204,86)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,86) -> (204,85)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,86) -> (203,85)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,86) -> (202,85)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,87) -> (202,87)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,87) -> (202,88)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,87) -> (203,88)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,87) -> (204,88)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,87) -> (204,87)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,87) -> (204,86)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(203,87) -> (202,86)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(202,91) -> (201,91)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(202,91) -> (201,92)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(202,91) -> (202,92)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(202,91) -> (203,92)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(202,91) -> (203,91)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(202,91) -> (203,90)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(202,91) -> (202,90)]
2017-10-22 19:26:00 [SR_GameServer] LINK_REGION ERROR [(202,91) -> (201,90)]

10/23/2017 14:51 guckguck#2

Hello, something with your mirror dimension map is wrong. However I don't know the exact solution :)
Maybe check if you have all regions enabled, specially ID 41.
[Only registered and activated users can see links. Click Here To Register...] could be useful too...

Code:

22475    203    87    JUPITER    ???? ?? ??    1    3001    -1    0    0    xxx    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL

10/23/2017 15:43 blapanda#3

This seems like a simple region linking issue (LINK_REGION ERROR).
Have you added new regions or tweaked them, and used the exec RefLinkRegions procedure to finish up that work?

Those are few lines of the jupiter continent. Look for the part with the region IDs after the "xxx" declarations:

Code:

wRegionID	X	Z	ContinentName	AreaName	IsBattleField	Climate	MaxCapacity	AssocObjID	AssocServer	AssocFile256	LinkedRegion_1	LinkedRegion_2	LinkedRegion_3	LinkedRegion_4	LinkedRegion_5	LinkedRegion_6	LinkedRegion_7	LinkedRegion_8	LinkedRegion_9	LinkedRegion_10
21707	203	84	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	0	21962	21963	21964	21708	0	0	0	0	0
21708	204	84	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21707	21963	21964	21965	0	0	0	0	0	0
21962	202	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	0	22217	22218	22219	21963	21707	0	0	0	0
21963	203	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21962	22218	22219	22220	21964	21708	21707	0	0	0
21964	204	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21963	22219	22220	22221	21965	0	21708	21707	0	0
21965	205	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21964	22220	22221	22222	21966	0	0	21708	0	0
21966	206	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21965	22221	22222	22223	21967	0	0	0	0	0

Do yours from _RefRegion match those I am showing? If not, execute the stored procedure "_LinkRefRegions"

Assure that JUPITER has been declared inside that procedure, otherwise execute this one first (applying changes) and then execute it via "exec _LinkRefRegions":

Spoiler

Quote:

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_LinkRefRegions] Script Date: 02.05.2016 20:16:40 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_LinkRefRegions]
AS

--- Blow Query is Each Area and FORT matching ---
declare @China int
declare @West_China int
declare @Oasis_Kingdom int
declare @Eu int
declare @Am int
declare @Ca int
declare @JUPITER int

select @China = AssocServer from _RefRegionBindAssocServer where AreaName = 'CHINA'
select @West_China = AssocServer from _RefRegionBindAssocServer where AreaName = 'West_China'
select @Oasis_Kingdom = AssocServer from _RefRegionBindAssocServer where AreaName = 'Oasis_Kingdom'
select @Eu = AssocServer from _RefRegionBindAssocServer where AreaName = 'Eu'
select @Am = AssocServer from _RefRegionBindAssocServer where AreaName = 'Am'
select @Ca = AssocServer from _RefRegionBindAssocServer where AreaName = 'Ca'
select @JUPITER = AssocServer from _RefRegionBindAssocServer where AreaName = 'JUPITER'

update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_JA_AREA'
update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_BJ_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_DW_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_HM_AREA'
update _RefRegionBindAssocServer set AssocServer = @Oasis_Kingdom where AreaName = 'FORT_HT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Eu where AreaName = 'FORT_CT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Am where AreaName = 'FORT_ER_AREA'
update _RefRegionBindAssocServer set AssocServer = @Ca where AreaName = 'FORT_SK_AREA'
update _RefRegionBindAssocServer set AssocServer = @JUPITER where AreaName = 'JUPITER'

begin TRANSACTION
begin
declare @LinkNum int
declare @this_region int
declare @region_x int
declare @region_z int
declare @wRegionID smallint
declare @wTempRID smallint
declare @col_link varchar(256)
declare @query varchar(256)
declare @db_id_to_link smallint

-- clear all existing region link
set @LinkNum = 1
while (@LinkNum <= 10)
begin
set @query = 'update _RefRegion set LinkedRegion_' + cast(@LinkNum as varchar(10)) + ' = 0'
execute (@query)

set @LinkNum = @LinkNum + 1
end
-- loop all region
declare region_cursor CURSOR FOR
select wRegionID
from _RefRegion
OPEN region_cursor
FETCH NEXT FROM region_cursor INTO @wRegionID
WHILE @@FETCH_STATUS = 0
begin
if (@@error = 0 and @wRegionID <> 0)
begin
-- 던전은 스킵!
if (@wRegionID > 0)
begin
set @LinkNum = 8
while (@LinkNum >= 0)
begin
set @region_z = (@wRegionID & 0xff00) / 256
set @region_x = (@wRegionID & 0x0ff)
set @wTempRID = 0;

if (@LinkNum = 0)
begin
set @region_x = @region_x - 1
set @col_link = 'LinkedRegion_1'
end
else if (@LinkNum = 1)
begin
set @region_x = @region_x - 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_2'
end
else if (@LinkNum = 2)
begin
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_3'
end
else if (@LinkNum = 3)
begin
set @region_x = @region_x + 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_4'
end
else if (@LinkNum = 4)
begin
set @region_x = @region_x + 1
set @col_link = 'LinkedRegion_5'
end
else if (@LinkNum = 5)
begin
set @region_x = @region_x + 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_6'
end
else if (@LinkNum = 6)
begin
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_7'
end
else if (@LinkNum = 7)
begin
set @region_x = @region_x - 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_8'
end

set @wTempRID = (@region_z & 0x00ff) * 256
set @wTempRID = @wTempRID + (@region_x & 0x00ff)

select @db_id_to_link = wRegionID
from _RefRegion
where wRegionID = @wTempRID

if (@@ROWCOUNT <> 0)
begin
set @query = 'update _RefRegion set ' + @col_link + ' = ' + cast(@db_id_to_link as varchar(10)) + ' where wRegionID = ' + cast(@wRegionID as varchar(10))
end
else -- 존재하지 않는 region link 는 0으로 채운다
begin
set @query = 'update _RefRegion set ' + @col_link + ' = 0 where wRegionID = ' + cast(@wRegionID as varchar(10))
end

execute(@query)
set @LinkNum = @LinkNum - 1
end
end
end
FETCH NEXT FROM region_cursor INTO @wRegionID
end

CLOSE region_cursor
DEALLOCATE region_cursor
COMMIT TRANSACTION
end

10/24/2017 00:48 Twistin**#4

Quote:
Originally Posted by blapanda
This seems like a simple region linking issue (LINK_REGION ERROR).
Have you added new regions or tweaked them, and used the exec RefLinkRegions procedure to finish up that work?

Those are few lines of the jupiter continent. Look for the part with the region IDs after the "xxx" declarations:
Code:
wRegionID	X	Z	ContinentName	AreaName	IsBattleField	Climate	MaxCapacity	AssocObjID	AssocServer	AssocFile256	LinkedRegion_1	LinkedRegion_2	LinkedRegion_3	LinkedRegion_4	LinkedRegion_5	LinkedRegion_6	LinkedRegion_7	LinkedRegion_8	LinkedRegion_9	LinkedRegion_10
21707	203	84	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	0	21962	21963	21964	21708	0	0	0	0	0
21708	204	84	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21707	21963	21964	21965	0	0	0	0	0	0
21962	202	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	0	22217	22218	22219	21963	21707	0	0	0	0
21963	203	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21962	22218	22219	22220	21964	21708	21707	0	0	0
21964	204	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21963	22219	22220	22221	21965	0	21708	21707	0	0
21965	205	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21964	22220	22221	22222	21966	0	0	21708	0	0
21966	206	85	JUPITER	Mirror Dimension - Field	1	3001	-1	0	0	xxx	21965	22221	22222	22223	21967	0	0	0	0	0
Do yours from _RefRegion match those I am showing? If not, execute the stored procedure "_LinkRefRegions"

Assure that JUPITER has been declared inside that procedure, otherwise execute this one first (applying changes) and then execute it via "exec _LinkRefRegions":

Quote:
Originally Posted by guckguck
Hello, something with your mirror dimension map is wrong. However I don't know the exact solution :)
Maybe check if you have all regions enabled, specially ID 41.
[Only registered and activated users can see links. Click Here To Register...] could be useful too...
Code:
22475    203    87    JUPITER    ???? ?? ??    1    3001    -1    0    0    xxx    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL

Still the same nothing wrong with jupiter

after removing jupiter i got this error

Spoiler

alot of dump files generated automatically after running gameserver