Gunz ping 999 when adding torn pages in shop.xml

**trivian** · 02-07-13

Hi all,

I got problems with my Gunz private server.
When I add torn pages in shop.xml and play with a friend, we got ping 999 problem.
But when i remove the pages from shop.xml, everything is normal.

**MentaL**

Gunz ping 999 when adding torn pages in shop.xml

**yerij007** · 02-07-13

I so. Rare mmhm dont use torn pages is the solution if you put avaliables all the quest items.

**trivian** · 02-07-13

I think most of the people who has ping 999 problem, got torn pages added.

And thx for a solution.

**yerij007** · 03-07-13

You can give me a Thanks if you click the Like Button.
Ps: on my post of course.

**trivian** · 03-07-13

I've tried your solution yerij007, but I got ping 999 problem if i use other quest items like the skull, dolls, etc.
I noticed that I had shop.xml in my system.mrs and deleted it from system.mrs, but also that doesn't solve the problem.

Is there any other solution Possible?
Thnx in advance.

**Patrick2607** · 03-07-13

lol.

Ok, open your ports and use your IP in the runnable/matchagent.

**Chrisss** · 03-07-13

This problem is not caused by editing the shop.xml, thats stupid. Post your logs.

**trivian** · 03-07-13

Originally Posted by Patrick2607

lol.

Ok, open your ports and use your IP in the runnable/matchagent.

When i add the quest items, than i get ping 999 problems.
But when i remove them, than everything is normal.
That's why I know the ports of my router are correct.

**trivian** · 03-07-13

Originally Posted by Sensor

This problem is not caused by editing the shop.xml, thats stupid. Post your logs.

Here are my logs.

MatchAgent:

Code:

[07/03/13 15:29:59] Command registeration completed

================================== Agent configure info ==================================
[07/03/13 15:29:59] Release Date : Jan 16 2012
===========================================================================================

[07/03/13 15:29:59] Match Agent Created (Port:5100)
[07/03/13 15:29:59] MMatchAgent::ConnectToMatchServer BEGIN 
[07/03/13 15:29:59] Request Connect to matchserver ip(WAN IP), port(6000).
[07/03/13 15:29:59] MMatchAgent::ConnectToMatchServer END 
RealCPNet> SessionCreated=2, SessionDestroyed=0

locator:

Code:

MLocator create.

===========================Loator self dump(2013-7-3 14:11)=========================
 - Server dead count list- 
LiveServerCount(1) : DeadServerCount(0)

Country code3 cache hit miss count : 0
Invalid IP count : 0
Block Count : 0
Country code check count : 0
Block country code hit count : 0
========================================================================================

MatchServer:

Code:

Load XML from memory : strings.xml(0x0052) - SUCCESS
Load XML from memory : cserror.xml(0x0052) - SUCCESS
[07/03/13 15:32:11] DBMS connected

[07/03/13 15:32:11] Command registeration completed

Start GambleItem Init.
GIID : 1000001
  GRIID : M(502003), F(502003), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(500003), F(500003), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(502001), F(502001), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(506002), F(506002), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(509003), F(509003), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(505002), F(505002), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(520032), F(520532), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(520030), F(520530), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(521014), F(521514), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(521024), F(521524), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(522009), F(522509), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(522013), F(522513), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(523027), F(523527), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(523012), F(523512), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(524016), F(524516), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(524025), F(524525), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(528002), F(528002), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(520033), F(520533), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(502004), F(502004), RentHourPeriod(360), ItemCnt(0).
  GRIID : M(527001), F(527001), RentHourPeriod(360), ItemCnt(0).
GIID : 1000002
  GRIID : M(502002), F(502002), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(500004), F(500004), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(500001), F(500001), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(506004), F(506004), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(507003), F(507003), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(504501), F(504501), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(520014), F(520514), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(520029), F(520529), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(521017), F(521517), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(521027), F(521527), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(522020), F(522520), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(522004), F(522504), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(523024), F(523524), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(523005), F(523505), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(524027), F(524527), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(524012), F(524512), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(527002), F(527002), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(520034), F(520534), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(502005), F(502005), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(528001), F(528001), RentHourPeriod(168), ItemCnt(0).
GIID : 1000003
  GRIID : M(4), F(4), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(6), F(6), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(14), F(14), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(16), F(16), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(31), F(31), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(4023), F(4023), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(4514), F(4514), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(5016), F(5016), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(6009), F(6009), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(7004), F(7004), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(8001), F(8001), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(9001), F(9001), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(21009), F(21509), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(22006), F(22506), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(23008), F(23511), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(24007), F(24507), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(30403), F(30403), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(25005), F(25005), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(30002), F(30002), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(400007), F(400007), RentHourPeriod(168), ItemCnt(0).
GIID : 1000004
  GRIID : M(7), F(7), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(8), F(8), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(17), F(17), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(18), F(18), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(35), F(35), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(4022), F(4022), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(4516), F(4516), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(5020), F(5020), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(6010), F(6010), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(7009), F(7009), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(8004), F(8004), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(9007), F(9007), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(21010), F(21510), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(22007), F(22507), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(23009), F(23512), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(24008), F(24508), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(30003), F(30003), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(25006), F(25006), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(30103), F(30103), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(30305), F(30305), RentHourPeriod(168), ItemCnt(0).
  GRIID : M(6008), F(6008), RentHourPeriod(168), ItemCnt(0).
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 2.
Shop GItem : 1000003
Shop GItem : 1000004
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Blue Box), IsTimeover(0).
Gamble item. ID(1000002), Name(Pink Box), IsTimeover(0).
Gamble item. ID(1000003), Name(Green Box), IsTimeover(0).
Gamble item. ID(1000004), Name(Gold Box), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 2
Shop gamble item. ID(1000003), Name(Green Box).
Shop gamble item. ID(1000004), Name(Gold Box).
=== Completed Dump GambleItem Info. ===

init GameOn success.
success init security.
FILE PATH : C:\Users\gameserver\Desktop\ps\Gunz1.5\Clean server\Matchserver\MD5HashValue.txt
MD5 Hash Value => a1 a8 f5 e8 15 e9 72 30 80 5f a6 4e f2 96 77 d7 

================================== Server configure info ==================================
[07/03/13 15:32:11] Release Date : Nov 15 2012
[07/03/13 15:32:11] X-Trap Off
[07/03/13 15:32:11] MD5 Check Off
[07/03/13 15:32:11] Loop Log Save Off
[07/03/13 15:32:11] Server Country : KOREA
[07/03/13 15:32:11] Command version : (58)
[07/03/13 15:32:11] Event usable state : (true)
[07/03/13 15:32:11] Load event size : (0)
[07/03/13 15:32:11] FileCRCCheckSum usable state : (false)
[07/03/13 15:32:11] FileCRC size : (0)
[07/03/13 15:32:11] Country Code Filter usalbe state : (false)
[07/03/13 15:32:11] Accept Invalied IP state : (false)
[07/03/13 15:32:11] Keeper IP : (WAN IP)
[07/03/13 15:32:11] Monitor IP : (127.0.0.1)
[07/03/13 15:32:11] Ticket use : 0

===========================================================================================

[07/03/13 15:32:11] Match Server Created (Port:6000)

Dueltournament Service Open(2013-7-3 Hour15, Min32) 
Daily Survival Ranking Request [month7 day3 hour15 min32]
[07/03/13 15:32:19] Start agent Register (CommUID 0:10) IP:WAN IP, TCPPort:5100, UDPPort:7778
 
[07/03/13 15:32:19] Agent Added (UID:010)
[07/03/13 15:32:19] Agent Registered (CommUID 0:10) IP:WAN IP, TCPPort:5100, UDPPort:7778
 

[07/03/13 15:32:37]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertConnLog (3, 82, 101, 230, 214, '')} ), ErrCode( -1 )
ErrMsg - Invalid object name 'LogDB.dbo.ConnLog'.
State:S0002,Native:208,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]


[07/03/13 15:32:53]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spDTInsertDTCharacterInfo(2)} ), ErrCode( -1 )
ErrMsg - Cannot insert the value NULL into column 'TimeStamp', table 'GunzDB.dbo.DTCharacterInfo'; column does not allow nulls. INSERT fails.
The statement has been terminated.
State:23000,Native:515,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:01000,Native:3621,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

MMatchServer::OnAsyncResponse_GetDuelTournamentCharacterInfo - ½ÇÆÐ

[07/03/13 15:33:20]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertGameLog2 (2, 'Mansion', 'Quest')} ), ErrCode( -1 )
ErrMsg - Invalid object name 'LogDB.dbo.GameLog'.
State:S0002,Native:208,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[15:33:20] Async DB Query(OnAsyncInsertGameLog) Failed
[07/03/13 15:35:11] GARBAGE SESSION CLEANING : m_This(02), ClientCount=1, SessionCount=2, AgentCount=1, CommandPool=14, objHistoryCount=3

[07/03/13 15:38:11] GARBAGE SESSION CLEANING : m_This(02), ClientCount=1, SessionCount=2, AgentCount=1, CommandPool=14, objHistoryCount=3


[07/03/13 15:39:01]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertTPLogNetmarble (2, 368)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spInsertTPLogNetmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[15:39:01] Async DB Query(OnAsyncCharFinalize) Failed
[07/03/13 15:41:11] GARBAGE SESSION CLEANING : m_This(02), ClientCount=0, SessionCount=1, AgentCount=1, CommandPool=14, objHistoryCount=3

[07/03/13 15:44:11] GARBAGE SESSION CLEANING : m_This(02), ClientCount=0, SessionCount=1, AgentCount=1, CommandPool=14, objHistoryCount=1

[07/03/13 15:47:11] GARBAGE SESSION CLEANING : m_This(02), ClientCount=0, SessionCount=1, AgentCount=1, CommandPool=14, objHistoryCount=1


[07/03/13 15:48:30]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertConnLog (3, 82, 101, 230, 214, '')} ), ErrCode( -1 )
ErrMsg - Invalid object name 'LogDB.dbo.ConnLog'.
State:S0002,Native:208,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]


[07/03/13 15:49:00]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spDTInsertDTCharacterInfo(2)} ), ErrCode( -1 )
ErrMsg - Cannot insert the value NULL into column 'TimeStamp', table 'GunzDB.dbo.DTCharacterInfo'; column does not allow nulls. INSERT fails.
The statement has been terminated.
State:23000,Native:515,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:01000,Native:3621,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

MMatchServer::OnAsyncResponse_GetDuelTournamentCharacterInfo - ½ÇÆÐ

[07/03/13 15:49:42]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertTPLogNetmarble (2, 41)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spInsertTPLogNetmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[15:49:42] Async DB Query(OnAsyncCharFinalize) Failed
[07/03/13 15:50:11] GARBAGE SESSION CLEANING : m_This(02), ClientCount=0, SessionCount=1, AgentCount=1, CommandPool=14, objHistoryCount=6

[07/03/13 15:50:49] Agent Removed (UID:010)
RealCPNet> SessionCreated=8, SessionDestroyed=6 
RealCPNet> Begin Destroy 
RealCPNet> Destroy Process 1/4 
RealCPNet> Destroy Process 2/4 
RealCPNet> Destroy Process 3/4 
RealCPNet> Destroy Process 4/4 
RealCPNet> Destroy End 
[07/03/13 15:50:49] Match Server Destoryed

**yerij007** · 03-07-13

Originally Posted by trivian

I've tried your solution yerij007, but I got ping 999 problem if i use other quest items like the skull, dolls, etc.
I noticed that I had shop.xml in my system.mrs and deleted it from system.mrs, but also that doesn't solve the problem.

Is there any other solution Possible?
Thnx in advance.

Mmhm.
Still the problem?
Right. You can pm to this fix fvck*n problem together.

**Chrisss** · 03-07-13

[07/03/13 15:50:49] Agent Removed (UID:010)

Your Agent is removing itself. Build the MatchAgent from your source and try that. If you dont have MatchAgent, ofcourse you will get 999 ping.

**Solaire** · 03-07-13

Originally Posted by Sensor

[07/03/13 15:50:49] Agent Removed (UID:010)

Your Agent is removing itself. Build the MatchAgent from your source and try that. If you dont have MatchAgent, ofcourse you will get 999 ping.

Agent was removed because he shut it down.

**Forean** · 03-07-13

Also, Why do you not have LOGDB?

**trivian** · 03-07-13

Originally Posted by Forean

Also, Why do you not have LOGDB?

Thnx for pointing that one out.
I didn't realize that I didn't add the LogDB.

I've added the LogDB and solved:

Code:

ErrMsg - Cannot insert the value NULL into column 'TimeStamp', table 'GunzDB.dbo.DTCharacterInfo'; column does not allow nulls. INSERT fails.

To solve the above error, go to dbo.DTTimeStamp.
In the table add:
ID: 1
TimeStamp: 2411
Closed: 0
TotalUser:10

At least it worked for me.
But now I get this error:

Code:

[07/03/13 22:17:33]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertTPLogNetmarble (2, 305)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spInsertTPLogNetmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

What does this error mean?

Gunz ping 999 when adding torn pages in shop.xml

Thread Tools

Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Re: Gunz ping 999 when adding torn pages in shop.xml

Advertisement