Problem with usp_Read_SkillMaxID_R DB table load error

[SacruM00]

Hello
I have a problem that I honestly can not figure out how to handle it, the Sserie Pserver EP5 is presenting the following error.

2017-11-19 12:06:06 PS_GAME__system log start (Game01)

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/sorp1

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/croco1

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/croco2

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/Troll1

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/Spink1

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/GoldenPig

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/Sorp3

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/SorpNamed1

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/SorpNamed2

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/Sorp2

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/CrocoNamed1

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/CrocoNamed2

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/CrocoNamed3

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/OrcNamed1

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/OrcNamed2

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/OrcNamed3

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/TrollNamed1

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/Deinos

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/Parridalis

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/Alcarian

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/ZinAlcaria

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/Belizabeth

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/Kirhiross

2017-11-19 12:06:06 Loaded Behavior In Factory : data/ai/CrypticOne

2017-11-19 12:06:19 err=-1, [Microsoft][ODBC SQL Server Driver]Tempo limite da consulta excedido, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2017-11-19 12:06:19 CGameData::LoadConstSkill: err=-1, query=EXEC usp_Read_SkillMaxID_R

2017-11-19 12:06:19 DB table load error

2017-11-19 12:06:19 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2017-11-19 12:06:19 Call save all waiting...

2017-11-19 12:06:19 Call save all failed dbagent disconnected(user count = 0)...

2017-11-19 12:06:19 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0

2017-11-19 12:06:19 Save MobID=1979293

2017-11-19 12:06:19 PS_GAME__system log end (Game01)

2017-11-19 12:06:19 3 1 SService::ServiceCtrlDispatcher(): service shutdown



Before they tell me that the error is in sight ... I know I do not want them to solve it for me, asking for help to know where to go to solve it, I do not want everything for free, I just need to know where I should go to solve, because I already tried the I could not if they could indicate, thank you!

[Eric-Dutra16]

Show how your procedure is. Maybe the problem is in the "WAITFOR DELAY" command, since it showed the timeout error exceeded, try to decrease the delay or remove this command.

[SacruM00]

The only things I do and click on "control service > Start All Server Services"

everyone logs in but the GameGroups01 > Game

They end up being off after a while, I found other errors in the log plus those I solved but that ended up losing me!

[SacruM00]

problem solved


The problem was caused by an issue made not PS_game in the connection rate part, it was just the rate that was for 100 put to 99, ready.