Hello guys! I really need help, my server was working 100%, but, i have a problem with Window 7 and i have to reinstall it.. And now i setup my server everything works fine but when i create a character and i try to start my character i can, i press start and i got some error in Global Manager, ShardManager and GameServer... Here is a picture of the problem
And those are the error (more detailed)
Global Manager:
Code:
execute query error : exec _AddCurrentUserCount 64, 0, '2012-9-23 0:34:49'
Query Error!!! Query Result : -1, Query : exec _AddCurrentUserCount 64, 0, '2012-9-23 0:34:49'
SQL Error State:42000, Native Error Code: 1FB2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Error al convertir el tipo de datos varchar a datetime.
exec _AddCurrentUserCount 64, 0, '2012-9-23 0:34:49'
ShardManager:
Code:
Query Error!!! Query Result : -1, Query : INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT', 359, 'Start', '2012-09-23 00:34:48')
SQL Error State:22007, Native Error Code: F2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.
INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT', 359, 'Start', '2012-09-23 00:34:48')
SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Se terminó la instrucción.
INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT', 359, 'Start', '2012-09-23 00:34:48')
AQ_ScheduleInsertLog Query Failed!! Query : INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT', 359, 'Start', '2012-09-23 00:34:48')
Query Error!!! Query Result : -1, Query : INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG', 245, 'Start', '2012-09-23 00:34:48')
SQL Error State:22007, Native Error Code: F2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.
INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG', 245, 'Start', '2012-09-23 00:34:48')
SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Se terminó la instrucción.
INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG', 245, 'Start', '2012-09-23 00:34:48')
AQ_ScheduleInsertLog Query Failed!! Query : INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG', 245, 'Start', '2012-09-23 00:34:48')
OnSR_PREPARE_USER_ACK() - An error returned from GAMESERVER [fdsafasd >> error_code: 23]
msg is not completely used : IP:XXX.XXX.X.XXX Ack:0x0002 (0x0000) (MsgType:11), 14 - 1
GameServer:
Code:
Query Error!!! Query Result : -1, Query : {?=CALL _DelExpiredRentItemInStorage (0, 11580,'2012-9-23 0:37:49')}
SQL Error State:42000, Native Error Code: 1FB2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Error al convertir el tipo de datos varchar a smalldatetime.
{?=CALL _DelExpiredRentItemInStorage (0, 11580,'2012-9-23 0:37:49')}
CALL _DelExpiredRentItemInStorage failed!! StorageType[0],StorageID[11580]
LOADTARGET_CHARDATA_N_INVENTORY(PC Inventory) Failed (693)
Character Data Loading Failed[JID: 1417, CharID: 11580]
CharDataLoadingCompleted:: CharData loading failed![JID: 1417, CharID: 11580]
So.. If someone can help me i will mean lot to me, because i try everything but i'm still getting this fu$#@!% error and i need help..
NOTE: I know i alredy post this error.. But this time is more detailed and i note that in the other post isn't the same picture, becuase i take that picture from another post.
Fixed, this was my solution
Install SQL Server 2008 ENGLISH VERSION!!
Setup ODBC in ENGLISH
and finally Lenguage and Region in English (This can be done by Control Panel)
Character Data Loading Failed 07/10/2015 - SRO Private Server - 8 Replies Hey guys, i need a litle help with this problem, everything works good but when i press start i got an error in sr_shardmanager and sr_gameserver + DC
Here's a picture
http://i.epvpimg.com/bOrYc.png
It's the same error with all characters.. I try do to again the ODBC.. But it doens't work.. I even reinstall the SQL but i still get the same error..
Hope you can help me.
Vsro Chardata Loading Failed.. Help Me! 02/19/2013 - SRO Private Server - 1 Replies http://img513.imageshack.us/img513/5981/adszmr.png
I tried another character, but it did not :confused:
Vsro Files Character Data Loading Failed 03/26/2012 - SRO Private Server - 8 Replies Hello,
I installed windows new on my pc, before all working great.I can creat a new character but when i press start on my character i get a disconnect and in gameserver a message popup. What can i do?
http://img6.imagebanana.com/img/d0o7co0g/thumb/Un benannt.png
i hope anyone can help me, thank you