ارجو المساعدة بسرعة

[Gadodoola]

Create TrainingCamp Failed!!! [UNKNOWN REASON:-1001] مشكلة في create accademy

[افندينا ™Hamboka™]

واضح اكتر

[Dev.Myth]

خد باك اب من الداتا بيز علشان لو قابلتك مشكله وجرب الكيورهات ديه

USE SRO_VT_SHARD
TRUNCATE TABLE _TrainingCampHonorRank
GO
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)

USE SRO_VT_SHARD
exec _TRAINING_CAMP_UPDATEHONORRANK

[Dev.Ri3o]

هتخش على SRO_VT_SHARD/Programmability/Stored Procedures
فى Precedure اسمو _TRAINING_CAMP_CREATE هتشيل كل اللى فى وتحط ده مكانه

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_TRAINING_CAMP_CREATE]    Script Date: 11/10/2016 10:11:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_TRAINING_CAMP_CREATE]
	@CreaterID	INT
AS
	SET NOCOUNT ON

	IF EXISTS (SELECT CharID FROM _TrainingCampMember WHERE CharID = @CreaterID)
	BEGIN
		RETURN -1001
	END

	DECLARE @CampID		INT
	DECLARE @FoundationDate	SMALLDATETIME
	SET @FoundationDate = GETDATE()

BEGIN TRANSACTION

	DECLARE @HonorPoint INT
	SET @HonorPoint = 0
	SELECT @HonorPoint = HonorPoint FROM _TrainingCampSubMentorHonorPoint WHERE CharID = @CreaterID	
	
	IF @HonorPoint <> 0
	BEGIN
		DELETE FROM _TrainingCampSubMentorHonorPoint WHERE  CharID = @CreaterID	
		IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
		BEGIN
			ROLLBACK TRANSACTION
			RETURN -6
		END
	END

	INSERT INTO _TrainingCamp (CreationDate, Rank, GraduateCount, EvaluationPoint,  LatestEvaluationDate, CommentTitle, Comment )
	VALUES ( @FoundationDate, 5, 0, 0,  @FoundationDate, '', '')

	SET @CampID = @@IDENTITY

	IF (@@ERROR <> 0 OR @@ROWCOUNT = 0 OR @CampID = 0)
	BEGIN
		ROLLBACK TRANSACTION
		RETURN -7
	END

	DECLARE @Ret INT
	EXEC @Ret = _TrainingCamp_FnAddMember  @CampID, @CreaterID, @HonorPoint 
	IF (@@ERROR <> 0 OR @Ret <= 0)
	BEGIN
		ROLLBACK TRANSACTION
		RETURN @Ret
	END

COMMIT TRANSACTION

	SET NOCOUNT OFF

	RETURN @CampID

هتعدل على SRO_VT_SHARD اللى فى الاول لأسم ال Databae بتاعتك

[Gadodoola]

تمام بس في مشكلة تانية ال join مش شغال ممكن حد يجبلي _TrainingCamp_FnAddMember & _TRAINING_CAMP_ADDMEMBER

[Dev.Ri3o]

##