SHardManager - ODBC error while creating a new char

02/12/2014 11:25 SunGm#1
Hello !

I ve downloaded the Blue-Sro DB cuz it has a lot of good edits. I can make my char ,play etc... But when i make a new acc and try to make a new char i get an error in-game and at shardmaneger too. I tired it with 3-4 accs , sometimes it works but sometimes not and crash the shared manager.

I ve used db clearing queries , but still not working.

Please help me !

Thanks !
02/13/2014 08:33 Crue*#2
make sure about DB's names
and check Procedures _AddNewChar also
02/14/2014 22:41 SunGm#3
I checked all the configs and everything is fine :/

Here is the log:

4-02-11 21:18:53 [AgentServer] server cord established : 3 (25.186.99.1:14214)
2014-02-11 21:19:10 [SR_ShardManager] SR_ShardManager is initialized successfully
2014-02-11 21:19:46 [SR_GameServer] Invalid Region!![ID:43][ObjName128:KINGDOLLLAR]
2014-02-11 21:19:46 [SR_GameServer] Invalid Region!![ID:44][ObjName128:KINGDOLLAR]
2014-02-11 21:19:46 [SR_GameServer] Invalid Region!![ID:45][ObjName128:KINGDOLLLAR]
2014-02-11 21:19:46 [SR_GameServer] Invalid Region!![ID:46][ObjName128:KINGDOLLLAR]
2014-02-11 21:20:03 [SR_GameServer] SR_GameServer is initialized successfully
2014-02-11 21:21:00 [SR_ShardManager] ScheduleExecutor : Find Failed In Schedule Exe - End(STATE) SCHEDULE_DEF_FLAG_WORLD(DEFINE) 490(SCHIDX)
2014-02-11 21:21:05 [SR_ShardManager] Query Error!!! Query Result : -1, Query : {?=CALL _AddNewChar (8, 14890,'fsdgdfg',67,27471,1205.000000,80.000000,396 .000000,19554,11629,11630,11631,10887,0,39,39,39,6 6,0,0)}
2014-02-11 21:21:05 [SR_ShardManager] SQL Error State:25000, Native Error Code: 10A, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
2014-02-11 21:21:05 [SR_ShardManager] {?=CALL _AddNewChar (8, 14890,'fsdgdfg',67,27471,1205.000000,80.000000,396 .000000,19554,11629,11630,11631,10887,0,39,39,39,6 6,0,0)}
2014-02-11 21:28:03 [AgentServer] 713:SR_GameServer is blind : 0 users are banned
2014-02-11 21:28:03 [FarmManager] server cord closed : 3
2014-02-11 21:28:03 [GlobalManager] agent server is broken !!. all associated user is unregistered : 0
2014-02-11 21:28:03 [SR_ShardManager] server cord closed : 2
2014-02-11 21:28:03 [AgentServer] server cord closed : 2
2014-02-11 21:28:05 [FarmManager] server cord closed : 2
2014-02-11 21:28:05 [SR_ShardManager] server cord closed : 3
2014-02-11 21:28:07 [GlobalManager] server cord closed : 4
2014-02-11 21:28:08 [GlobalManager] server cord closed : 3
2014-02-11 21:28:09 [GlobalManager] server cord closed : 5
2014-02-11 21:28:10 [GlobalManager] server cord closed : 2
2014-02-11 21:28:10 [SR_ShardManager] OnExit() Called


Please help !
02/14/2014 23:49 Justin1337*#4
Quote:
Originally Posted by SunGm View Post
I checked all the configs and everything is fine :/

Here is the log:



Please help !
Added you on Skype i'll help you. =)
02/16/2014 05:34 Anonymous-6723#5
Just restore default _AddNewChar probably it has something wrong around it.
12/16/2016 21:38 Toonami2010#6
Quote:
Originally Posted by Pr0x! View Post
Just restore default _AddNewChar probably it has something wrong around it.
i have the same problem, Failed To execute _AddNewChar

but i don't se any dbo table with this name

_AddNewChar it's from SRO_VT_SHARD? SRO_VT_ACCOUNT OR SHARLOG
12/16/2016 23:08 janicka#7
Its stored procedure.
12/17/2016 00:36 Toonami2010#8
Quote:
Originally Posted by janicka View Post
Its stored procedure.
explain me how to fix please
i'll add your on skype
12/17/2016 18:23 janicka#9
SRO_VT_SHARD go to programmability then go stored procedures and there is it.... Mostly this is messed up when you try add some start items etc......
12/19/2016 02:59 Toonami2010#10
execute query error : exec _AddCurrentUserCount 64, 0,
Query Error!!! Query Result : -1, Query : exec _AddCurrentUserCount 64, 0,
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,

i get this error in Global manager what's ?
12/20/2016 09:01 sro_cyklon#11
[Only registered and activated users can see links. Click Here To Register...]