Help!

[Denis Strokov]

hi all Im running ep 4.5 db and got problem with WH . put item , relog , rollback

Log's
PS_GAMELOG
2013-08-21 12:42:15 PS_DBAGENT__system log start (DBAgent01)

2013-08-21 12:42:19 connect game, Name=



2013-08-21 12:42:19 connect game, Name=



2013-08-21 12:44:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка при преобразовании типа данных varchar к datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-08-21 12:44:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка при преобразовании типа данных varchar к datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-08-21 12:44:35 ::SaveCharacter 10 <ADM>Anonymous ret=-1, qerr=-1, {?=call Usp_Save_User_StoredItem_Add_E(1,1,390293709513149 6448, 39, 25001,25,1, 0, 0,0,0,0,0,0,'±в???ЖАМЕЫ', 10, '2013-08-21 00:18:28', 'S')}

2013-08-21 12:44:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка при преобразовании типа данных varchar к datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-08-21 12:44:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка при преобразовании типа данных varchar к datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-08-21 12:44:35 ::SaveCharacter 10 <ADM>Anonymous ret=-1, qerr=-1, {?=call Usp_Save_User_StoredItem_Add_E(1,1,390293709513149 6448, 39, 25001,25,1, 0, 0,0,0,0,0,0,'±в???ЖАМЕЫ', 10, '2013-08-21 00:18:28', 'S')}

2013-08-21 12:47:06 1 1 SAgent:isconnect: (4, 64)

2013-08-21 12:47:06 1 1 T=000:04:00:000, RC=15,RCS=0, RB=358,RBS=1, SC=17,SCS=0, SB=2576,SBS=8

2013-08-21 12:47:06 disconnect game, Name=Game01



2013-08-21 12:47:06 1 1 SAgent:isconnect: (4, 64)

2013-08-21 12:47:06 1 1 T=000:04:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=3,SCS=0, SB=2064,SBS=7

2013-08-21 12:47:06 disconnect game, Name=Game01



2013-08-21 12:47:06 save market... wait plz...



2013-08-21 12:47:06 save all... wait plz... enter /uc



2013-08-21 12:47:06 3 1 SERVICE_CONTROL_STOP

2013-08-21 12:47:06 PS_DBAGENT__system log end (DBAgent01)


2013-08-21 12:47:06 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAME
2013-08-21 12:42:16 PS_GAME__system log start (Game01) [KR]

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/sorp1

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/croco1

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/croco2

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Troll1

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Spink1

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/GoldenPig

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Sorp3

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/SorpNamed1

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/SorpNamed2

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Sorp2

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/CrocoNamed1

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/CrocoNamed2

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/CrocoNamed3

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/OrcNamed1

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/OrcNamed2

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/OrcNamed3

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/TrollNamed1

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Deinos

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Parridalis

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Alcarian

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/ZinAlcaria

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Belizabeth

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Kirhiross

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/CrypticOne

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Haruhion

2013-08-21 12:42:16 Loaded Behavior In Factory : data/ai/Freezing

2013-08-21 12:42:19 connect mgr 948

2013-08-21 12:42:19 connect dbagent 952

2013-08-21 12:42:19 connect dbagent2 956

2013-08-21 12:42:19 connect gamelog 972

2013-08-21 12:42:19 Market End -----------------------

2013-08-21 12:42:20 Load Shaiya.SData 1

2013-08-21 12:42:32 <Console input> /nprotectoff

2013-08-21 12:42:32 <Console output> cmd NProtect off ok

2013-08-21 12:43:18 error exp over usern=Dennirock,charn=<ADM>Anonymous, level=2013,exp=7186750,exppn=7186750

2013-08-21 12:44:35 discon client: (104, 64) T=000:01:00:000, RC=10,RCS=0, RB=80,RBS=0, SC=95,SCS=1, SB=1944,SBS=22

2013-08-21 12:47:06 Call save all waiting...

2013-08-21 12:47:06 3 1 SERVICE_CONTROL_STOP

2013-08-21 12:47:06 1 1 SAgent:isconnect: (3, 64)

2013-08-21 12:47:06 1 1 T=000:04:00:000, RC=2,RCS=0, RB=106,RBS=0, SC=9,SCS=0, SB=655,SBS=2

2013-08-21 12:47:06 1 1 SAgent:isconnect: (3, 64)

2013-08-21 12:47:06 1 1 T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=3,SCS=0, SB=126,SBS=0

2013-08-21 12:47:06 discon mgr ((3,64, 106,655)

2013-08-21 12:47:06 mgr Connection Lost INFO : T=000:04:00:000, RC=2,RCS=0, RB=106,RBS=0, SC=9,SCS=0, SB=655,SBS=2

2013-08-21 12:47:06 mgr server disconnection

2013-08-21 12:47:06 1 1 SAgent:isconnect: (3, 64)

2013-08-21 12:47:06 discon userlog ((3,64, 0,126)

2013-08-21 12:47:06 userlog Connection Lost INFO : T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=3,SCS=0, SB=126,SBS=0

2013-08-21 12:47:06 1 1 T=000:04:00:000, RC=17,RCS=0, RB=2576,RBS=8, SC=15,SCS=0, SB=358,SBS=1

2013-08-21 12:47:06 userlog log server disconnection

2013-08-21 12:47:06 discon dbagent ((3,64, 2576,358)

2013-08-21 12:47:06 dbagent Connection Lost INFO : T=000:04:00:000, RC=17,RCS=0, RB=2576,RBS=8, SC=15,SCS=0, SB=358,SBS=1

2013-08-21 12:47:06 db agent server disconnected...

2013-08-21 12:47:06 call disconnectAll...

2013-08-21 12:47:06 1 1 SAgent:isconnect: (3, 64)

2013-08-21 12:47:06 1 1 T=000:04:00:000, RC=3,RCS=0, RB=2064,RBS=7, SC=1,SCS=0, SB=37,SBS=0

2013-08-21 12:47:06 discon dbagent2 ((3,64, 2064,37)

2013-08-21 12:47:06 dbagent2 Connection Lost INFO : T=000:04:00:000, RC=3,RCS=0, RB=2064,RBS=7, SC=1,SCS=0, SB=37,SBS=0

2013-08-21 12:47:06 db agent2 server disconnected...

2013-08-21 12:47:06 1 1 SAgent:isconnect: (3, 64)

2013-08-21 12:47:06 1 1 T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=9,SCS=0, SB=1030,SBS=3

2013-08-21 12:47:06 discon gamelog ((3,64, 0,1030)

2013-08-21 12:47:06 gamelog Connection Lost INFO : T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=9,SCS=0, SB=1030,SBS=3

2013-08-21 12:47:06 game log server disconnection

2013-08-21 12:47:06 server shutdown Connection INFO : T=000:04:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=1,CReq=1,CCnt=1,DCCnt=1, CTimeT=000:01:00:000,CTimeAvg=000:01:00:000, RBT=80,RBS=0,RBSC=0,SBT=1948,SBS=6,SBSC=22

2013-08-21 12:47:06 Save Shaiya.SData 1

2013-08-21 12:47:06 PS_GAME__system log end (Game01)

2013-08-21 12:47:06 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_DBAGENT
2013-08-21 12:42:15 PS_DBAGENT__system log start (DBAgent01)

2013-08-21 12:42:19 connect game, Name=



2013-08-21 12:42:19 connect game, Name=



2013-08-21 12:44:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка при преобразовании типа данных varchar к datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-08-21 12:44:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка при преобразовании типа данных varchar к datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-08-21 12:44:35 ::SaveCharacter 10 <ADM>Anonymous ret=-1, qerr=-1, {?=call Usp_Save_User_StoredItem_Add_E(1,1,390293709513149 6448, 39, 25001,25,1, 0, 0,0,0,0,0,0,'±в???ЖАМЕЫ', 10, '2013-08-21 00:18:28', 'S')}

2013-08-21 12:44:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка при преобразовании типа данных varchar к datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-08-21 12:44:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка при преобразовании типа данных varchar к datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-08-21 12:44:35 ::SaveCharacter 10 <ADM>Anonymous ret=-1, qerr=-1, {?=call Usp_Save_User_StoredItem_Add_E(1,1,390293709513149 6448, 39, 25001,25,1, 0, 0,0,0,0,0,0,'±в???ЖАМЕЫ', 10, '2013-08-21 00:18:28', 'S')}

2013-08-21 12:47:06 1 1 SAgent:isconnect: (4, 64)

2013-08-21 12:47:06 1 1 T=000:04:00:000, RC=15,RCS=0, RB=358,RBS=1, SC=17,SCS=0, SB=2576,SBS=8

2013-08-21 12:47:06 disconnect game, Name=Game01



2013-08-21 12:47:06 1 1 SAgent:isconnect: (4, 64)

2013-08-21 12:47:06 1 1 T=000:04:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=3,SCS=0, SB=2064,SBS=7

2013-08-21 12:47:06 disconnect game, Name=Game01



2013-08-21 12:47:06 save market... wait plz...



2013-08-21 12:47:06 save all... wait plz... enter /uc



2013-08-21 12:47:06 3 1 SERVICE_CONTROL_STOP

2013-08-21 12:47:06 PS_DBAGENT__system log end (DBAgent01)


2013-08-21 12:47:06 3 1 SService::ServiceCtrlDispatcher(): service shutdown

[nick4ever]

Is there any trigger in UserStoreditems ?

[Denis Strokov]

no

[.Mamamia.]

Hello,

I advise you to check the language of your SQL server.

* Open SQL server management and log in.
* At your left, you can see on Object Explorer your server. Just right click on it and go to Properties.
* Then go to Advanced and set Default Language to English and click on Ok.
* Restart your server and try once more.

It worked for me, I hope it can help you.

[Denis Strokov]

fixed