Dbmon error after start up

08/22/2013 19:35 Godricc#1
Well after running the siege commands I get an awesome new error.
If anyone knows whats up give me a hint. Never seen this before.

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
08/22/2013 19:53 DKUNitex#2
I would delete all of the Siege information, so your server starts, then try again.

Run these queries:

NOTE -- these will delete your Siege data.

delete from character.dbo.siege_info
delete from character.dbo.siege_result_log


-----

The long way to fix this is to check the queries you ran, the siege SPs, and the actual Siege data in the siege_info table.

To me it looks like there's something wrong with the SP (first screenshot), so check that as well.

Does the server crash when you start Siege in game? Or when the server finishes loading? If it crashes when you start Siege in game, it's most likely a SP issue. If it crashes as soon as the server finishes loading, then it's usually a data issue (because the data for Siege is accessed as soon as the server finishes loading).

Good luck.
08/22/2013 20:16 Godricc#3
I did what you said, new lines went in fine.

Server is now booted and fine.

I just got this in the dbmon...
[7256] OnDefenderSetting::onParsing TotalSize
08/22/2013 20:35 DKUNitex#4
Glad to hear. Enjoy :).
08/22/2013 20:39 Godricc#5
What does that message mean from the dbmon though? I heard it means I have something wrong still. :)
08/23/2013 01:42 conquer93#6
That error is something in about siege some days ago I had same problem the server worked fine and siege and i restarted it to edit some file and after that I had Same error after it loads the brick 105 after fully restored db and siege scripts removed it worked again
08/23/2013 10:43 DKUNitex#7
It just means some of the defender data is wrong. Just ignore it, it'll be fixed the next time the server does Siege successfully and re-updates the data.
08/23/2013 14:14 conquer93#8
ther was no way to ignore it cus the dekaronserver.exe crashes after that. lol
08/23/2013 18:29 Godricc#9
So It took a min but I found another error not longer after the whole process. Maybe this is what my issue is?

[1392] Microsoft OLE DB Provider for SQL Server: Could not find stored procedure 'SP_SIEGE_GUILD_INFO_U'.

I just looked and I in fact do not have this SP. I have a dummy server set up on my pc and the database on my pc has the SP, but the main does not.
08/23/2013 18:32 DKUNitex#10
Quote:
Originally Posted by Godricc View Post
So It took a min but I found another error not longer after the whole process. Maybe this is what my issue is?

[1392] Microsoft OLE DB Provider for SQL Server: Could not find stored procedure 'SP_SIEGE_GUILD_INFO_U'.

I just looked and I in fact do not have this SP. I have a dummy server set up on my pc and the database on my pc has the SP, but the main does not.
Then yeah, it's missing. I believe that one is made when the Siege queries is ran, I don't remember. You can always add it yourself.



Quote:
Originally Posted by conquer93 View Post
ther was no way to ignore it cus the dekaronserver.exe crashes after that. lol
Quote:
Originally Posted by Godricc View Post
Server is now booted and fine.