[GUIDE] Troubleshooting Common Server Set Up Problems

[abrasive]

Here is a list of common problems users run into when setting up a private server. These are in order of server set up completeness (from starting services to logging into Shaiya and performing in-game actions).

These are directly from my . I decided to make them their own post as it was a bit much to load the guide up every time I wanted to look at this part. Also this should be easier for new users to find.

All services show a red X
This is most likely to your Shaiya Agent Client service (D:\SHAIYA_SERVER\SERVER\PSM_Client\PSM_Agent.exe) not being installed and/or not running. Get it installed and started, and restart PSMServer_Mgr.exe if needed.

All services show a green x
This means your services are not installed, or are not being recognized as being installed.

Services go to a green arrow, but then back to pause
This usually means the services were unable to connect to the database. Check your logs in D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Log and D:\SHAIYA_SERVER\SERVER\PSM_Client\Log. These logs help tell you of problems with services starting, so keep that in mind for future problems.

Check notice board
Usually caused by connecting to the wrong IP address, or Windows Firewall blocking the client.
Can also be cause by using the wrong game client, thus connecting to the wrong IP address.

Failed to connect to game server, after selecting server and clicking ok
May be caused by Windows Firewall blocking the client trying to connect to the server.
Can also be caused by the incorrect IP address entered in D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\ps_g ame.ini on the line that starts with GamePublicIP=
It could possibly also be from incorrect IP addresses in other .ini files.

Disconnect after selecting game server and clicking ok
Most likely you have incorrect or missing data in your database. There could be many causes of this. I'd suggest using the SQL profiler to trace what happens in this case and look for error messages in the logs. If there is an error message present in the logs try to find which SQL query that you traced with the profiler caused it.

Disconnect after less than 2 minutes of being connected to the server
Usually caused by forgetting to run the /nprotectoff command. Normally this needs to be run every time the server services are restarted, which includes server reboots, etc.

Disconnect when targetting mobs, or doing other specific activities
Most likely you have incorrect or missing data in your database. There could be many causes of this. I'd suggest using the SQL profiler to narrow down the problem.

Disconnect when buying an item from the item mall.
The Distributed Transaction Coordinator service may not be running, it is required to use the statement: BEGIN DISTRIBUTED TRANSACTION

Feel free to add more to this, but DON'T ask questions in this thread.

[Bаne]

# bumped

/starts sticky support.

Nice job of compiling common issues.

[abrasive]

Disconnect after selecting game server and clicking ok

I've ran into this specific cause of the above many times now, and it always happens to me when I set up a fresh server. Never have I seen anyone else mention it before though. I decided to add it here just in case it would be useful to someone.

Inside of PS_GameData.dbo.usp_Read_Char_Product_Item_E there is this query:

SELECT Slot,ItemID,ItemCount FROM PS_USERDB01.PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID

Since PS_USERDB01 does not exist, it causes my client to disconnect after selected the server and clicking ok.

To fix it, I remove PS_USERDB01 from the stored procedure so the query looks like this:

SELECT Slot,ItemID,ItemCount FROM PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID

[iykeusa]

I have made my server and it is running perfectly for me, however i want my friend to connect to it using hamachi so i set it up accordingly (changed the public ips to hamachi ip, made a network that my friend is in blah blah blah), but when my friend tries to play the game it says failed to connect to game server. i can play the game fine :S

[[Admin]Snuggle]

Seriously? -.-
Do people not read?
"Feel free to add more to this, but DON'T ask questions in this thread."
You may have not added a question mark to your post but it's still a form of asking for help.
This is why there isn't many advanced releases now. (such as getting skills past 3)
In the end it just ends up as people asking and begging for more. >.>
Which makes the person who released it pretty mad.
Anyway.
Good release
Hopefully people will stop spamming the private server section and dev section for help because their server doesn't start lol

[Bаne]

Sticked, hopefully this will help new server devs.

[PureJustice]

Well my problem is when i launch the geme.exe it opens a window simular to the 1 when installing the server but it closes and then nothing happens. I believe that i must be missing some programs or files...
Any way to fix this?

[JohnHeatz]

If you show your logs it might be possible to think/see what is it that is causing that problem

[Oreotix]

Help me everyone!!!!!! .... i entre in server patch config and get start all , but session don't open.... userlog,login01 etc are open for a few seconds ...... help me!!!

[ShaiyaOmega]

Originally Posted by Oreotix

Help me everyone!!!!!! .... i entre in server patch config and get start all , but session don't open.... userlog,login01 etc are open for a few seconds ...... help me!!!

If you check your logs i almost guarantee that you are having trouble connecting to the database. Use The Search Function. this has been discussed many times before.

[Jamez1997]

2011-09-13 19:07:04 PS_SESSION__system log start (Session)

2011-09-13 19:07:05 userlog connect failed

2011-09-13 19:07:05 initserver() failed

2011-09-13 19:07:05 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-09-13 19:07:05 PS_SESSION__system log end (Session)

2011-09-13 19:07:05 3 1 SService::ServiceCtrlDispatcher(): service shutdown


2011-09-13 20:05:30 PS_SESSION__system log start (Session)

2011-09-13 20:05:31 userlog connect failed

2011-09-13 20:05:31 initserver() failed

2011-09-13 20:05:31 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-09-13 20:05:31 PS_SESSION__system log end (Session)

2011-09-13 20:05:31 3 1 SService::ServiceCtrlDispatcher(): service shutdown


2011-09-13 20:06:05 PS_SESSION__system log start (Session)

2011-09-13 20:06:06 userlog connect failed

2011-09-13 20:06:06 initserver() failed

2011-09-13 20:06:06 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-09-13 20:06:06 PS_SESSION__system log end (Session)

2011-09-13 20:06:06 3 1 SService::ServiceCtrlDispatcher(): service shutdown


2011-09-13 20:06:23 PS_SESSION__system log start (Session)

2011-09-13 20:06:24 userlog connect failed

2011-09-13 20:06:24 initserver() failed

2011-09-13 20:06:24 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-09-13 20:06:24 PS_SESSION__system log end (Session)

2011-09-13 20:06:24 3 1 SService::ServiceCtrlDispatcher(): service shutdown


2011-09-13 20:07:54 PS_SESSION__system log start (Session)

2011-09-13 20:07:54 userlog connect failed

2011-09-13 20:07:54 initserver() failed

2011-09-13 20:07:54 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-09-13 20:07:54 PS_SESSION__system log end (Session)

2011-09-13 20:07:54 3 1 SService::ServiceCtrlDispatcher(): service shutdown


2011-09-13 20:08:12 PS_SESSION__system log start (Session)

2011-09-13 20:08:13 userlog connect failed

2011-09-13 20:08:13 initserver() failed

2011-09-13 20:08:13 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-09-13 20:08:13 PS_SESSION__system log end (Session)

2011-09-13 20:08:13 3 1 SService::ServiceCtrlDispatcher(): service shutdown

2011-09-13 20:08:15 PS_SESSION__system log start (Session)

2011-09-13 20:08:16 userlog connect failed

2011-09-13 20:08:16 initserver() failed

2011-09-13 20:08:16 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-09-13 20:08:16 PS_SESSION__system log end (Session)

2011-09-13 20:08:16 3 1 SService::ServiceCtrlDispatcher(): service shutdown

[viper4513]

Posting your logs in more than 1 topic wont help you get an answer.. Just read them and you will see your error right away. Check your other topic.

[Xx.LaMin.xX]

You dont need to post same log all the time 1 is enough.! The error is connection to DB

userlog connect failed

That is the problem so check if there is any misstake with db password or account or missing DBs.

[viper4513]

Bumping back to the top. Alot of people asking questions about stuff answered here again.. I think it got lost from sticky

[JohnHeatz]

Still this is one of the links into the only sticky thread on this section now, so no need to bump any thread from this section