log_LS_DB ERROR exec dbo.ProcGetServerList

I have problem log_LS_DB ERROR exec dbo.ProcGetServerList

Spoiler:

2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(4) 94ms
2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(0) 94ms
2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(6) 94ms
2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(7) 94ms
2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(13) 94ms
2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(5) 94ms
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 29 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcFindServer'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.ProcFindServer (20201) })
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 24 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.USP_USER_LOBBY'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.USP_USER_LOBBY (0, 20201, 0, 0, 1, 2) })
2012-03-11 06:55:18 102 PC_44 0 MATCHING SYSTEM : fail { call dbo.USP_USER_LOBBY (0, 20201, 0, 0, 1, 2) }
2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(1) 94ms
2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(2) 94ms
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 33 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetServerList'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.ProcGetServerList })
2012-03-11 06:55:18 101 PC_44 10 { call dbo.ProcGetServerList }
2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(14) 109ms
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.ProcGetServerCmd (20201) })
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'DBO.USP_MATCHING_INTR'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(EXEC DBO.USP_MATCHING_INTR)
2012-03-11 06:55:18 107 PC_44 1 [DB PROFILE CONNECT] ThreadNo(3) 109ms
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 25 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 21 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 30 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.USP_TREASURE_STAT'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(Exec dbo.USP_TREASURE_STAT 1)
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 17 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 16 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 50 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcUpdateServerState'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.ProcUpdateServerState (20201,0,0,100,'2010022400','',0,0,100,1,1,0,4,10,1,0,55, 0, 0) })
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 20 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 18 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetPreviouosServerCmd'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec dbo.ProcGetPreviouosServerCmd 20201, 15 )
2012-03-11 06:55:18 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.ProcGetServerList'.)
2012-03-11 06:55:18 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.ProcGetServerList })
2012-03-11 06:55:18 101 PC_44 10 { call dbo.ProcGetServerList }
2012-03-11 06:55:19 101 PC_44 2 [E_NETUNIT] SOCKET CONNECT : IP(øØ}
), Port(0)
2012-03-11 06:55:19 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'DBO.USP_PARTS_LIMIT_CONFIG'.)
2012-03-11 06:55:19 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery(exec DBO.USP_PARTS_LIMIT_CONFIG)
2012-03-11 06:55:19 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.USP_GHOST_VER'.)
2012-03-11 06:55:19 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.USP_GHOST_VER (2736, 220, 172, 65) })
2012-03-11 06:55:19 102 PC_44 2 QUERY FAIL({ call dbo.USP_GHOST_VER (2736, 220, 172, 65) })
2012-03-11 06:55:19 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.USP_MANAGER_SERVER_AUTH_STATE'.)
2012-03-11 06:55:19 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.USP_MANAGER_SERVER_AUTH_STATE (20201,1,1,48,49) })
2012-03-11 06:55:19 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.USP_MANAGER_SERVER_AUTH_STATE'.)
2012-03-11 06:55:19 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.USP_MANAGER_SERVER_AUTH_STATE (20201,1,1,32,33) })
2012-03-11 06:55:19 107 PC_44 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.USP_MANAGER_SERVER_AUTH_STATE'.)
2012-03-11 06:55:19 107 PC_44 1 [F_QUERY] LastSuccQuery(), CurrQuery({ call dbo.USP_MANAGER_SERVER_AUTH_STATE (20201,1,1,0,1) })

I've installed the correct dns but with results like this

http://i43.tinypic.com/2s629tk.jpg

please help my problem

From the looks of it you're missing quite a few stored procedures. Are they present in your databases?

If they are not: Are the CREATE procedures available in your database dump?

If there are problems regarding the log database in your stored procedures, you have two options:
- Modify the problematic procedures and disable the INSERTs into the non-existing log database.
- Create a log database with the necessary tables (table layout can be derived from the INSERT statements).

Other than that, double check that you set the language of your DSNs to English.

I do not understand please help me

Quote:

---

Originally Posted by Tsukasa

From the looks of it you're missing quite a few stored procedures. Are they present in your databases?

If they are not: Are the CREATE procedures available in your database dump?

If there are problems regarding the log database in your stored procedures, you have two options:
- Modify the problematic procedures and disable the INSERTs into the non-existing log database.
- Create a log database with the necessary tables (table layout can be derived from the INSERT statements).

Other than that, double check that you set the language of your DSNs to English.

---

Help ME