Global Manager Overlap !!!!

[ROBEX]

حد عندة حل !!!!!!!
هيعمل overlap كتيير ورا بعض و بعدين يعمل Dump Files فى ال Server Files و بعدين Craaash كل 5-6 ساعااات !

https://image.ibb.co/mqMYjQ/over.jpg

[Neoon]

إقفل شوية مدن

[ROBEX]

إقفل شوية مدن


اولا شكرا جدا على محاولة المساعدة
ثانيا دة Global Manager مش GameServer يعنى ملوش اى علاقة ب ال Regions و GameServer مفيش فى اى مشاكل.
اخيرا الFiles دى شغالة على Dedicated Server 128 GB RAM :)

يعنى مش حل بس شكرا على المساعدة و الرد :lulu12:

[Neoon]

بص انت ممكن تكون ضفت حاجه غلط لو المشكلة جديدة او اول مر تجيلك يعني ممكن تعمل restore يا اما تمسح الـ Dump files .

[ROBEX]

بص انت ممكن تكون ضفت حاجه غلط لو المشكلة جديدة او اول مر تجيلك يعني ممكن تعمل restore يا اما تمسح الـ Dump files .




الفكرة ان الGlobal Manager ملوش علاقة بال database اصلا يعنى مش بيقراها اصلا فا هى مش databse

[Neoon]

بص مشكلتك انك عدلت على حاجه غلط , اي تعديل عملتو حديثاً رجعو زي ما كان

او انك تقفل مدن يا اما تعمل Restore
وشوف المواضيع ديه نفس مشكلتك ومحلولة.

Here (http://silkroad4arab.com/vb/showthread.php?t=596473)
and
Here (http://silkroad4arab.com/vb/showthread.php?t=479713)

[ROBEX]

بص مشكلتك انك عدلت على حاجه غلط , اي تعديل عملتو حديثاً رجعو زي ما كان

او انك تقفل مدن يا اما تعمل Restore
وشوف المواضيع ديه نفس مشكلتك ومحلولة.

Here (http://silkroad4arab.com/vb/showthread.php?t=596473)
and
Here (http://silkroad4arab.com/vb/showthread.php?t=479713)


كل دول المكلة عندهم فى الGameServer انا GlobalManager و هما السيرفر مش بيشتغل عندهم انا شغال عندى تمام بس الجلوبال بيجيلو Crash من كتر ال Overlap !

[Neoon]

طيب اقفل اي region

او كدة عندك table and stored produce مش موجودين او ناقصين

ضيف دول

Table

USE [SRO_VT_ACCOUNT]
GO
/****** Object: Table [dbo].[SR_CharAppoint] Script Date: 10/29/2011 10:50:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_CharAppoint](
[UserJID] [int] NOT NULL,
[ShardID] [int] NOT NULL,
[CharID] [varchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Stored Produce

set ANSI_NULLS OFF
set QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_ManageShardCharName]
@job tinyint,
@UserJID int,
@ShardID smallint,
@CharName varchar(64),
@OldName varchar(64)
as
-- add new char name
if (@job = 0)
begin
if (not exists(select * from SR_ShardCharNames where UserJID = @UserJID and ShardID = @ShardID and CharName = @CharName))
begin
insert SR_ShardCharNames values(@UserJID, @ShardID, @CharName)
end
end
-- remove char name
else if (@job = 1)
begin
delete SR_ShardCharNames where UserJID = @UserJID and ShardID = @ShardID and CharName = @CharName
delete SR_CharAppoint where UserJID = @UserJID and ShardID = @ShardID and CharID = @CharName
end
-- rename previous one
else if (@job = 2)
begin
update SR_ShardCharNames set CharName = @CharName where UserJID = @UserJID and ShardID = @ShardID and CharName = @OldName
update SR_CharAppoint set CharID = @CharName where UserJID = @UserJID and ShardID = @ShardID and CharID = @OldName
end

[ROBEX]

طيب اقفل اي region

او كدة عندك table and stored produce مش موجودين او ناقصين

ضيف دول

Table

USE [SRO_VT_ACCOUNT]
GO
/****** Object: Table [dbo].[SR_CharAppoint] Script Date: 10/29/2011 10:50:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_CharAppoint](
[UserJID] [int] NOT NULL,
[ShardID] [int] NOT NULL,
[CharID] [varchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Stored Produce

set ANSI_NULLS OFF
set QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_ManageShardCharName]
@job tinyint,
@UserJID int,
@ShardID smallint,
@CharName varchar(64),
@OldName varchar(64)
as
-- add new char name
if (@job = 0)
begin
if (not exists(select * from SR_ShardCharNames where UserJID = @UserJID and ShardID = @ShardID and CharName = @CharName))
begin
insert SR_ShardCharNames values(@UserJID, @ShardID, @CharName)
end
end
-- remove char name
else if (@job = 1)
begin
delete SR_ShardCharNames where UserJID = @UserJID and ShardID = @ShardID and CharName = @CharName
delete SR_CharAppoint where UserJID = @UserJID and ShardID = @ShardID and CharID = @CharName
end
-- rename previous one
else if (@job = 2)
begin
update SR_ShardCharNames set CharName = @CharName where UserJID = @UserJID and ShardID = @ShardID and CharName = @OldName
update SR_CharAppoint set CharID = @CharName where UserJID = @UserJID and ShardID = @ShardID and CharID = @OldName
end

Msg 2714, Level 16, State 6, Line 11
There is already an object named 'SR_CharAppoint' in the database.

و الProc. راجت عليها موجودة