Problem with usp_Read_SkillMaxID_R DB table load error

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

:confused:

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!

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.

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!

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.