Rollback after using Rune

09/22/2012 02:41 [ADM]KEFARET#1
Hello,

I have a problem as I mentioned it in my topic.

Everything is working great till I use any rune appearing on the screen when used.Such as 30 day continuous Rune,Prevent of Item Drop Rune , Eternal Endurance Rune,Red Phoenix Charm and Warehouse Recall Rune.

When I use any of these runes ,everything seems to be normal till I go back to character screen.If I try to go back to character screen ,I disconnect from the server and see the notification saying "connection with servre has been disconnected ERROR 0"

When I relog in the game I found the rune unused in my bag and datas are rolled back to the time before I use the rune.

I will be appreaciated if anybody can tell me how to fix it.

Regards.
09/22/2012 06:19 JohnHeatz#2
Have you checked on your logs for what is shown at the time the "roll-back" happens? If not, that would be the best way to go to start
09/22/2012 10:04 [S]DipNot#3
Siz İlk önce Item.sdata 'yı Düzenleyin ve Server Dosyalarınızı Tekrar Yaratın. Sorununuz Girelecektir.
09/23/2012 20:47 IsTaNBLuE*#4
[SORRY FOR TURKISH LANGUAGE]

Merhaba Kefaret;

Bir aralar aynı problem bendede vardı sebebi ise MSSQL Serverden kaynaklanması kurulumda bazı dosyaları eksik yüklediği için bendede çıkıyordu aynı problem veya Dipnot arkadaşımızın dediği gibi item.sdatayı tekrardan yapın eğer yine aynı problem çıkıyor ise muhtemelen MSSQL Serverden kaynaklıdır.
09/24/2012 05:05 [ADM]KEFARET#5
Thanks for your advices but none of them worked for me.These are logs.If you figure out the problem ,I am all ear.

PS_DBAGENT__system.log__20120924_054430.log

Code:
2012-09-24 05:44:30 PS_DBAGENT__system log start (DBAgent01)

2012-09-24 05:44:31 connect game, Name=



2012-09-24 05:44:31 connect game, Name=



2012-09-24 05:48:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-09-24 05:48:42 ::SaveCharacter 32076 defs ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(32076,286,3,2591972)}

2012-09-24 05:48:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-09-24 05:48:42 ::SaveCharacter 32076 defs ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(32076,286,3,2591972)}

2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)

2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)

2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=15,RCS=0, RB=322,RBS=1, SC=18,SCS=0, SB=2902,SBS=9

2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=2,RCS=0, RB=41,RBS=0, SC=4,SCS=0, SB=2068,SBS=6

2012-09-24 05:49:53 disconnect game, Name=Game01



2012-09-24 05:49:53 disconnect game, Name=Game01



2012-09-24 05:49:53 save market... wait plz...



2012-09-24 05:49:53 save all... wait plz... enter /uc



2012-09-24 05:49:53 3 1 SERVICE_CONTROL_STOP

2012-09-24 05:49:53 PS_DBAGENT__system log end (DBAgent01)


2012-09-24 05:49:53 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GAME__system.log__20120924_054430.log

Code:
2012-09-24 05:44:30 PS_GAME__system log start (Game01) [KR]

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/sorp1

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/croco1

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/croco2

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Troll1

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Spink1

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/GoldenPig

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Sorp3

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Sorp2

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Deinos

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Parridalis

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Alcarian

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Belizabeth

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Kirhiross

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/CrypticOne

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Haruhion

2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Freezing

2012-09-24 05:44:31 connect mgr 796

2012-09-24 05:44:31 connect dbagent 804

2012-09-24 05:44:31 connect dbagent2 816

2012-09-24 05:44:31 connect gamelog 848

2012-09-24 05:44:32 Market End -----------------------

2012-09-24 05:44:32 Load Shaiya.SData 5

2012-09-24 05:46:57 error exp over usern=KEFARET,charn=defs, level=70,exp=-1294967296,exppn=71851

2012-09-24 05:48:43 discon client: (104,    64) T=000:01:00:000, RC=10,RCS=0, RB=94,RBS=0, SC=74,SCS=0, SB=1754,SBS=14

2012-09-24 05:49:53 3 1 SERVICE_CONTROL_STOP

2012-09-24 05:49:53 Call save all waiting...

2012-09-24 05:49:53 1 1 SAgent::Disconnect: (3, 64)

2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=3,RCS=0, RB=110,RBS=0, SC=10,SCS=0, SB=659,SBS=2

2012-09-24 05:49:53 discon mgr ((3,64, 110,659)

2012-09-24 05:49:53 mgr Connection Lost INFO : T=000:05:00:000, RC=3,RCS=0, RB=110,RBS=0, SC=10,SCS=0, SB=659,SBS=2

2012-09-24 05:49:53 mgr server disconnection

2012-09-24 05:49:53 1 1 SAgent::Disconnect: (3, 64)

2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=4,RCS=0, RB=2068,RBS=6, SC=2,SCS=0, SB=41,SBS=0

2012-09-24 05:49:53 discon dbagent2 ((3,64, 2068,41)

2012-09-24 05:49:53 dbagent2 Connection Lost INFO : T=000:05:00:000, RC=4,RCS=0, RB=2068,RBS=6, SC=2,SCS=0, SB=41,SBS=0

2012-09-24 05:49:53 db agent2 server disconnected...

2012-09-24 05:49:53 1 1 SAgent::Disconnect: (3, 64)

2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=1,RCS=0, RB=4,RBS=0, SC=7,SCS=0, SB=572,SBS=1

2012-09-24 05:49:53 discon gamelog ((3,64, 4,572)

2012-09-24 05:49:53 gamelog Connection Lost INFO : T=000:05:00:000, RC=1,RCS=0, RB=4,RBS=0, SC=7,SCS=0, SB=572,SBS=1

2012-09-24 05:49:53 game log server disconnection

2012-09-24 05:49:53 1 1 SAgent::Disconnect: (3, 64)

2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=1,RCS=0, RB=4,RBS=0, SC=4,SCS=0, SB=130,SBS=0

2012-09-24 05:49:53 discon userlog ((3,64, 4,130)

2012-09-24 05:49:53 userlog Connection Lost INFO : T=000:05:00:000, RC=1,RCS=0, RB=4,RBS=0, SC=4,SCS=0, SB=130,SBS=0

2012-09-24 05:49:53 userlog log server disconnection

2012-09-24 05:49:53 server shutdown Connection INFO : T=000:05:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=1,CReq=1,CCnt=1,DCCnt=1, CTimeT=000:01:00:000,CTimeAvg=000:01:00:000, RBT=94,RBS=0,RBSC=0,SBT=1754,SBS=5,SBSC=14

2012-09-24 05:49:53 Save Shaiya.SData 5

2012-09-24 05:49:53 PS_GAME__system log end (Game01)

2012-09-24 05:49:53 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAMELOG__system.log__20120924_054430.log

Code:
2012-09-24 05:44:30 PS_GAMELOG__system log start (GameLog01)

2012-09-24 05:44:31 connect game

2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)

2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=7,RCS=0, RB=572,RBS=1, SC=1,SCS=0, SB=4,SBS=0

2012-09-24 05:49:53 disconnect game

2012-09-24 05:49:53 3 1 SERVICE_CONTROL_STOP

2012-09-24 05:49:53 PS_GAMELOG__system log end (GameLog01)

2012-09-24 05:49:53 3 1 SService::ServiceCtrlDispatcher(): service shutdown
09/24/2012 17:08 JuuF#6
Quote:
Originally Posted by [ADM]KEFARET View Post
Thanks for your advices but none of them worked for me.These are logs.If you figure out the problem ,I am all ear.

PS_DBAGENT__system.log__20120924_054430.log

Code:
2012-09-24 05:44:30 PS_DBAGENT__system log start (DBAgent01)

2012-09-24 05:44:31 connect game, Name=



2012-09-24 05:44:31 connect game, Name=



2012-09-24 05:48:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-09-24 05:48:42 ::SaveCharacter 32076 defs ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(32076,286,3,2591972)}

2012-09-24 05:48:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-09-24 05:48:42 ::SaveCharacter 32076 defs ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(32076,286,3,2591972)}

2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)

2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)

2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=15,RCS=0, RB=322,RBS=1, SC=18,SCS=0, SB=2902,SBS=9

2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=2,RCS=0, RB=41,RBS=0, SC=4,SCS=0, SB=2068,SBS=6

2012-09-24 05:49:53 disconnect game, Name=Game01



2012-09-24 05:49:53 disconnect game, Name=Game01



2012-09-24 05:49:53 save market... wait plz...



2012-09-24 05:49:53 save all... wait plz... enter /uc



2012-09-24 05:49:53 3 1 SERVICE_CONTROL_STOP

2012-09-24 05:49:53 PS_DBAGENT__system log end (DBAgent01)


2012-09-24 05:49:53 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Maybe Here? :)Check your Usp_Save_Char_ApplySkill_Add_E2 and try to execute it, then check errors and fix them.
09/24/2012 19:15 [ADM]KEFARET#7
usp_Save_Char_ApplySkill_Add_E2

Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2]    Script Date: 09/24/2012 19:45:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]

@CharID int,
@SkillID smallint,
@SkillLevel tinyint,
@LeftResetTime int

AS

SET NOCOUNT ON

INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftResetTime) VALUES(@CharID,@Skillid,@SkillLevel,@LeftResetTime)

IF(@@ERROR = 0)
BEGIN
	RETURN 1
END
ELSE
BEGIN
	RETURN -1
END

SET NOCOUNT OFF

When executed :

Code:
Msg 137, Level 15, State 2, Procedure usp_Save_Char_ApplySkill_Add_E2, Line 17
Must declare the scalar variable "@Skillid".
09/24/2012 19:19 JohnHeatz#8
It is telling you that you don't have declared @Skillid correctly
09/24/2012 19:41 JuuF#9
Write DECLARE @Skillid smallint after SET NOCOUNT ON and i think your problem will be fixed o,o
09/24/2012 22:45 [ADM]KEFARET#10
After I wrote DECLARE @Skillid smallint after SET NOCOUNT ON the quiry was executed successfully.

And when I tried to use any of the runes ,this time I got that error :



Code:
2012-09-24 21:27:45 PS_DBAGENT__system log start (DBAgent01)

2012-09-24 21:27:47 connect game, Name=



2012-09-24 21:27:47 connect game, Name=



2012-09-24 21:48:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SkillID', table 'PS_GameData.dbo.CharApplySkills'; column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)

2012-09-24 21:48:02 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}

2012-09-24 21:48:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SkillID', table 'PS_GameData.dbo.CharApplySkills'; column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)

2012-09-24 21:48:02 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}

2012-09-24 21:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)

2012-09-24 21:53:29 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}

2012-09-24 21:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)

2012-09-24 21:53:29 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}

2012-09-24 21:57:45 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-09-24 21:57:45 VerifyReConnect : The Connection has been lost, SQLHDBC=712d18

2012-09-24 21:57:46 SDatabasePool::Reconnect:: success...

2012-09-24 21:59:39 1 1 SAgent::Disconnect: (4, 64)

2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=35,RCS=0, RB=742,RBS=0, SC=39,SCS=0, SB=2987,SBS=1

2012-09-24 21:59:39 disconnect game, Name=Game01



2012-09-24 21:59:39 1 1 SAgent::Disconnect: (4, 64)

2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=7,RCS=0, RB=61,RBS=0, SC=9,SCS=0, SB=2088,SBS=1

2012-09-24 21:59:39 disconnect game, Name=Game01



2012-09-24 21:59:39 save market... wait plz...



2012-09-24 21:59:39 save all... wait plz... enter /uc



2012-09-24 21:59:39 3 1 SERVICE_CONTROL_STOP

2012-09-24 21:59:39 PS_DBAGENT__system log end (DBAgent01)


2012-09-24 21:59:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Code:
2012-09-24 21:27:45 PS_GAME__system log start (Game01) [KR]

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/sorp1

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/croco1

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/croco2

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Troll1

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Spink1

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/GoldenPig

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Sorp3

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Sorp2

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Deinos

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Parridalis

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Alcarian

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Belizabeth

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Kirhiross

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/CrypticOne

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Haruhion

2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Freezing

2012-09-24 21:27:47 connect mgr 792

2012-09-24 21:27:47 connect dbagent 800

2012-09-24 21:27:47 connect dbagent2 812

2012-09-24 21:27:47 connect gamelog 844

2012-09-24 21:27:47 Market End -----------------------

2012-09-24 21:27:48 Load Shaiya.SData 0

2012-09-24 21:48:02 discon client: (104,    64) T=000:03:00:000, RC=14,RCS=0, RB=109,RBS=0, SC=101,SCS=0, SB=1945,SBS=8

2012-09-24 21:53:29 discon client: (104,    64) T=000:01:00:000, RC=10,RCS=0, RB=76,RBS=1, SC=81,SCS=1, SB=1622,SBS=21

2012-09-24 21:59:39 3 1 SERVICE_CONTROL_STOP

2012-09-24 21:59:39 Call save all waiting...

2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)

2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)

2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=39,RCS=0, RB=2987,RBS=1, SC=35,SCS=0, SB=742,SBS=0

2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=9,RCS=0, RB=231,RBS=0, SC=21,SCS=0, SB=1257,SBS=0

2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)

2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=9,RCS=0, RB=2088,RBS=1, SC=7,SCS=0, SB=61,SBS=0

2012-09-24 21:59:39 discon dbagent ((3,64, 2987,742)

2012-09-24 21:59:39 discon dbagent2 ((3,64, 2088,61)

2012-09-24 21:59:39 discon mgr ((3,64, 231,1257)

2012-09-24 21:59:39 dbagent2 Connection Lost INFO : T=000:31:00:000, RC=9,RCS=0, RB=2088,RBS=1, SC=7,SCS=0, SB=61,SBS=0

2012-09-24 21:59:39 mgr Connection Lost INFO : T=000:31:00:000, RC=9,RCS=0, RB=231,RBS=0, SC=21,SCS=0, SB=1257,SBS=0

2012-09-24 21:59:39 db agent2 server disconnected...

2012-09-24 21:59:39 mgr server disconnection

2012-09-24 21:59:39 dbagent Connection Lost INFO : T=000:31:00:000, RC=39,RCS=0, RB=2987,RBS=1, SC=35,SCS=0, SB=742,SBS=0

2012-09-24 21:59:39 db agent server disconnected...

2012-09-24 21:59:39 call disconnectAll...

2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)

2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=21,SCS=0, SB=1699,SBS=0

2012-09-24 21:59:39 discon gamelog ((3,64, 24,1699)

2012-09-24 21:59:39 gamelog Connection Lost INFO : T=000:31:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=21,SCS=0, SB=1699,SBS=0

2012-09-24 21:59:39 game log server disconnection

2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)

2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=10,SCS=0, SB=171,SBS=0

2012-09-24 21:59:39 discon userlog ((3,64, 24,171)

2012-09-24 21:59:39 userlog Connection Lost INFO : T=000:31:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=10,SCS=0, SB=171,SBS=0

2012-09-24 21:59:39 userlog log server disconnection

2012-09-24 21:59:39 server shutdown Connection INFO : T=000:31:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=2,CReq=2,CCnt=2,DCCnt=2, CTimeT=000:05:00:000,CTimeAvg=000:02:00:000, RBT=185,RBS=0,RBSC=0,SBT=3567,SBS=1,SBSC=11

2012-09-24 21:59:39 Save Shaiya.SData 1

2012-09-24 21:59:39 PS_GAME__system log end (Game01)

2012-09-24 21:59:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown
And I right clicked on CharApplySkills , clicked on Design and set Identity Specification as Yes from CharID Column Properties

Then Tried again ,this time I got this error:

Code:
2012-09-24 21:59:55 PS_DBAGENT__system log start (DBAgent01)

2012-09-24 21:59:56 connect game, Name=



2012-09-24 21:59:56 connect game, Name=



2012-09-24 22:21:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)

2012-09-24 22:21:47 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}

2012-09-24 22:21:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)

2012-09-24 22:21:47 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}
09/25/2012 00:26 JohnHeatz#11
If you see here it is telling you:

Code:
2012-09-24 21:48:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SkillID', 
table 'PS_GameData.dbo.CharApplySkills'; 
column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
Basically you need to check what is going on there because your database is adding a NULL under SkillID, when SkillID can't be set at NULL
09/25/2012 00:36 [ADM]KEFARET#12
Quote:
Originally Posted by JohnHeatz View Post
If you see here it is telling you:

Code:
2012-09-24 21:48:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SkillID', 
table 'PS_GameData.dbo.CharApplySkills'; 
column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
Basically you need to check what is going on there because your database is adding a NULL under SkillID, when SkillID can't be set at NULL
As I explained in my previous post that I fixed that error by setting auto increment but could not fix when IDENTITY_INSERT is set to OFF error. So I want to learn how to let IDENTITY_INSERT to set to ON from OFF setting.

I could not find a way to turn IDENTITY INSERT setting ON and this error accured just after I set auto increment.Before this setting I got "Can not insert NULL into x column." so I set all columns as Allow NULL.

Code:
USE [PS_GameData]
GO
/****** Object:  Table [dbo].[CharApplySkills]    Script Date: 09/25/2012 04:36:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CharApplySkills](
	[RowID] [int] NULL,
	[CharID] [int] NULL,
	[SkillID] [smallint] NULL,
	[SkillLevel] [tinyint] NULL,
	[LeftResetTime] [int] NULL
) ON [PRIMARY]
I did not get error.It did not roll back.But when I use a rune or a noss ,it disappears after relog.When I checked CharApplySkills Table I found SkillID column as NULL

While I received
Code:
2012-09-25 03:39:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)
error ,CharApplySkills table was set like below.

Code:
USE [PS_GameData]
GO
/****** Object:  Table [dbo].[CharApplySkills]    Script Date: 09/25/2012 03:17:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CharApplySkills](
	[RowID] [int] NOT NULL,
	[CharID] [int] IDENTITY(1,1) NOT NULL,
	[SkillID] [smallint] NOT NULL,
	[SkillLevel] [tinyint] NOT NULL,
	[LeftResetTime] [int] NOT NULL,
 CONSTRAINT [PK_CharApplySkills_1] PRIMARY KEY CLUSTERED 
(
	[CharID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

I changed all OFF settings to ON like this :
Code:
[CharID] ASC
)WITH (PAD_INDEX  = ON, STATISTICS_NORECOMPUTE  = ON, IGNORE_DUP_KEY = ON, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
Still it did not work.

If I allow to insert NULL value to the columns ,I do not get error but at that time runes and nosses are not permanent.They remain till relog then disapppear.

I am stuck :(
09/26/2012 05:36 ShaiyaOmega#13
From what i can see you are trying to enter information into the DB that the game doesn't understand.

If SkillID is set to NULL then it doesn't know what skill to re-apply when you relog onto the character. Basically you are trying to tell it to add SkillID NULL so that means NO SkillID.

If it is from a Rune or Noss then they have a Specific SkillID that must be listed in the CharApplySkills DB in order for it to Re-Apply them upon logging in.

Is this from Custom Buffs or Noss items? If so then re-check your information you added into the sdata and DB for them because all ApplySkills have a unique SkillID that is listed in the Skills DB like 30 Day Conti is SkillID 286 and The Knockout Noss is SkillID 215...
09/26/2012 10:21 RebeccaBlack#14
Quote:
Originally Posted by [ADM]KEFARET View Post
usp_Save_Char_ApplySkill_Add_E2

Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2]    Script Date: 09/24/2012 19:45:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]

@CharID int,
[COLOR="red"]@SkillID smallint[/COLOR],
@SkillLevel tinyint,
@LeftResetTime int

AS

SET NOCOUNT ON

INSERT INTO CharApplySkills(CharID,[COLOR="red"]Skillid[/COLOR],SkillLevel,LeftResetTime) VALUES(@CharID,[COLOR="red"]@Skillid[/COLOR],@SkillLevel,@LeftResetTime)

IF(@@ERROR = 0)
BEGIN
	RETURN 1
END
ELSE
BEGIN
	RETURN -1
END

SET NOCOUNT OFF

When executed :

Code:
Msg 137, Level 15, State 2, Procedure usp_Save_Char_ApplySkill_Add_E2, Line 17
Must declare the scalar variable "[COLOR="Red"]@Skillid[/COLOR]".
Go to your database that contains "CharApplySkills", verify the column is "Skillid" and not "SkillID".
In your SP, you have "@Skillid", but it's not declared anywhere. However you also have "@SkillID" declared as a parameter. Seems like a typo to me, change "@Skillid" to "@SkillID" to match the parameter variable.
09/26/2012 23:21 [ADM]KEFARET#15
I am formating test VDS and will try what you both told after the server is ready.
RebeccaBlack has caught a very good point.I think that will solve my problem.Hope so.

Thanks to all for your time and assistance.


EDIT: Great! It worked. I changed all @Skillid as @SkillID and cleared DECLARE @SkillID smallint lines both from usp_Save_Char_ApplySkill_Add_E and usp_Save_Char_ApplySkill_Add_E2. Then Executed the procedure.



It cost my half and a month to figure out and fix that problem.In the meanwhile I learnt much by searching a solution.I am much more familiar to the scripts and logs now.

"Every cloud has a silver lining" It is a very right proverb.

I do thank all of you very very very much and many times. Especially RebeccaBlack.