Troubleshooting -- Global Manager --

[SupremeSRO]

-- Global Manager --

Error - exec _ManageShardCharName

fatal Query Error!!! Query Result : -1, Query : exec _ManageShardCharName
fatal SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SR_CharAppoint'.
fatal exec _ManageShardCharName

Solution

USE [SRO_VT_ACCOUNT]
GO
SET ANSI_NULLS OFF
GO
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
end
-- rename previous one
else if (@job = 2)
begin
update SR_ShardCharNames set CharName = @CharName where UserJID = @UserJID and ShardID = @ShardID and CharName = @OldName
end

Credits to " AsGaN "

[MentaL]