Error GlobalDBAgent

[somerdinha]

My server was running normally, but now is showing the following error when I try to log into the server, it does not connect, this presents the following error, could someone help me with this.

[Wed Jul 14 2010 17:09:37.429945 3086366416]: open log file '/var/log/cabal/GlobalDBAgent.log'
[Wed Jul 14 2010 17:09:37.430118 3086366416]: LOG LEVEL: 3
[Wed Jul 14 2010 17:09:37.430150 3086366416]: MemPoolUnitSizeClass(0): 14336Bytes
[Wed Jul 14 2010 17:09:37.430936 3086366416]: Start GlobalDBAgent Server
[Wed Jul 14 2010 17:09:37.431554 3086366416]: UseEcryptText (Off)
[Wed Jul 14 2010 17:09:37.435144 3086363536]: CProcessLayer(0)::svc Start [3086363536]
[Wed Jul 14 2010 17:09:37.435263 3075873680]: CProcessLayer(0)::svc Start [3075873680]
[Wed Jul 14 2010 17:09:37.435332 3065383824]: CProcessLayer(0)::svc Start [3065383824]
[Wed Jul 14 2010 17:09:37.435396 3054893968]: CProcessLayer(0)::svc Start [3054893968]
[Wed Jul 14 2010 17:09:37.435475 3044404112]: CProcessLayer(0)::svc Start [3044404112]
[Wed Jul 14 2010 17:09:37.435538 3033914256]: CProcessLayer(0)::svc Start [3033914256]
[Wed Jul 14 2010 17:09:37.435606 3023424400]: CProcessLayer(0)::svc Start [3023424400]
[Wed Jul 14 2010 17:09:37.435677 3012934544]: CProcessLayer(0)::svc Start [3012934544]
[Wed Jul 14 2010 17:09:37.436291 3086366416]: try listening 38180 port
[Wed Jul 14 2010 17:09:37.436523 3002444688]: CProcessLayer(0)::svc Start [3002444688]
[Wed Jul 14 2010 17:09:37.436577 2991954832]: CProcessLayer(0)::svc Start [2991954832]
[Wed Jul 14 2010 17:09:37.898779 3086366416]: accept success 8(127.0.0.1:55312)
[Wed Jul 14 2010 17:09:37.899809 3086366416]: 1.open user 8 [81FA5F8] (127.0.0.1)
[Wed Jul 14 2010 17:09:40.673589 3086366416]: accept success 10(127.0.0.1:55320)
[Wed Jul 14 2010 17:09:40.673821 3086366416]: 2.open user 10 [8208D18] (127.0.0.1)
[Wed Jul 14 2010 17:10:24.457460 3065383824]: Database Connect success!
[Wed Jul 14 2010 17:10:24.487955 3065383824]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Wed Jul 14 2010 17:10:24.487997 3065383824]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
[Wed Jul 14 2010 17:10:24.488008 3065383824]: [##ERROR##] DB ERROR(CODE) : 242
[Wed Jul 14 2010 17:10:24.488018 3065383824]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 14 2010 17:10:24.488027 3065383824]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Wed Jul 14 2010 17:10:24.488036 3065383824]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}
[Wed Jul 14 2010 17:10:24.495309 3065383824]: Database Connect success!
[Wed Jul 14 2010 17:10:24.495338 3065383824]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Wed Jul 14 2010 17:10:24.495361 3065383824]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)

[MentaL]

[SheenBR]

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.


READ the error log.

[Alphakilo23]

Would you mind to post the result of this tsql-query?

SELECT [LoginTime], [LogoutTime], [CreateDate]
  FROM [account].[dbo].[cabal_auth_table]
  WHERE [UserNum] = 0

How did you end up with a account with UserNum 0 anyway?
Should start with 1.

[somerdinha]

Dear friend, do not understand what he asked you not speak English very well, could drill for what I do to fix this problem.

Thank you very much

[SheenBR]

O.O I cant understand u very well.

GO to SQL and execute that query so we can identity the date of you sql and help u to solve ur problem.

[Alphakilo23]

1. Open the SQL Managememt studio.
2. Log into your server.
3. Hit new Query (or file, new, query).
4. Copy and paste the sql query that i posted.
5. Click on the "execute" button.
6. ???
7. Post the result!

[magraopb]

i have this error too, my results are blank because my UserNum is "1" and query find "0"

[Alphakilo23]

i have this error too, my results are blank because my UserNum is "1" and query find "0"

Then edit the query accordingly:

SELECT [LoginTime], [LogoutTime], [CreateDate]
FROM [account].[dbo].[cabal_auth_table]
WHERE [UserNum] = 1

[magraopb]

result: