log_LS_DB ERROR exec dbo.ProcGetServerList

[jiung]

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



please help my problem

[MentaL]

[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.

[bribrite]

I do not understand please help me

[bribrite]

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