PS_DBAGENT__system log ERROR !

KILLSTEAL · May 31, 2010

2010-05-29 20:22:44 PS_DBAGENT__system log start (DBAgent01)

2010-05-29 20:22:45 connect game, Name=

2010-05-29 20:22:45 connect game, Name=

2010-05-29 20:22:47 connect game, Name=

2010-05-31 12:19:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]In 'sysdatabases' wurde kein Eintrag für die 'Billcrux30'-Datenbank gefunden. Es wurde kein Eintrag mit diesem Namen gefunden. Stellen Sie sicher, dass der Name richtig eingegeben wurde., SQL STATE: 08004, NATIVE ERROR: 911 (0x38F)

2010-05-31 12:19:11 SaveGiftPointItem 811 .TestUser. qerr=**** {? = call [usp_Save_User_NCash](389,390,'B1_Cface0001')}

-----------------------------------------------------------------
In English:

2010-05-29 20:22:44 PS_DBAGENT__system start log (DBAgent01)

2010-05-29 20:22:45 game connect, name =

2010-05-29 20:22:45 game connect, name =

2010-05-29 20:22:47 game connect, name =

2010-05-31 12:19:11 err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] In 'sysdatabases' no entry was for the' Billcrux30' database found. There was no entry with that name found. Make sure that the name is spelled correctly., SQL STATE: 08 004, NATIVE ERROR: 911 (0x38F)

2010-05-31 12:19:11 SaveGiftPointItem 811th Test User. Qerr = **** (? = Call [usp_Save_User_NCash] (389.390, 'B1_Cface0001'))

:thumbup:

Twilight · May 31, 2010

tomorrow fix...
Zzzzzz...

Twilight · Jun 1, 2010

Carefully
These procedures test.
If the test succeeds then move to section [Fix]
The result of the procedures, see PS_GameData -> PointErrorLog table.

KILLSTEAL · Jun 1, 2010

Twilight said:
Carefully
These procedures test.
If the test succeeds then move to section [Fix]
The result of the procedures, see PS_GameData -> PointErrorLog table.

Ok i will Test

thx a lot

P.S i think it works fine here the ErrorLog table.

304 NULL B1_Bcall0005 100 28.05.2010 10:25:13
344 NULL B1_Sroul0005 100 29.05.2010 02:04:27
378 NULL B1_Bcall0005 100 29.05.2010 02:04:35
378 NULL B1_Bcall0005 100 29.05.2010 02:05:58
389 NULL B1_Cface0001 100 31.05.2010 12:19:11
358 NULL B1_Misun0001 100 01.06.2010 15:29:38
378 NULL B1_Bcall0005 100 29.05.2010 02:03:02
378 NULL B1_Bcall0005 100 29.05.2010 02:03:43
378 NULL B1_Bcall0005 100 29.05.2010 02:04:06
358 NULL B1_Misun0001 100 01.06.2010 15:30:24
NULL NULL NULL NULL NULL

i test it out foe few days. The we{you can set it too [Fix]

---------- Post added at 06:09 PM ---------- Previous post was at 05:49 PM ----------

hmm damnit

Now i found this Error

2010-06-01 20:05:47 err=-1, [Microsoft][ODBC SQL Server Driver]Timeout abgelaufen, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2010-06-01 20:05:47 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'B1_Nosko0001')}

in English:

2010-06-01 20:05:47 err =- 1, [Microsoft] [ODBC SQL Server Driver] Timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2010-06-01 20:05:47 SaveGiftPointItem 9 [GM] KAMPFSAU Qerr = **** (? = Call [usp_Save_User_NCash] (1,3, 'B1_Nosko0001'))

in PS_DBAGENT_system.log

Twilight · Jun 1, 2010

Next proc error? =}
Wait 15 minutes.
I'll write another check and fix ..

KILLSTEAL · Jun 1, 2010

Twilight said:
Next proc error? =}
Wait 15 minutes.
I'll write another check and fix ..

Ok

and that was the new error after the fix to test sendGift

Twilight · Jun 1, 2010

try new test

KILLSTEAL · Jun 1, 2010

Twilight said:
try new test

hmm now this Error

2010-06-01 22:21:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Objektname 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-01 22:21:02 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'B1_Nosko0001')}

in English:

2010-06-01 22:21:02 err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-01 22:21:02 SaveGiftPointItem 9 [GM] KAMPFSAU Qerr = **** (? = Call [usp_Save_User_NCash] (1,3, 'B1_Nosko0001'))

Twilight · Jun 1, 2010

in Billcrux30 -> procRequestOrderProductByGame
find string

Code:

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PointLog WHERE (UserUID = @receiveClientUserNumber)

change

Code:

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.dbo.PointLog WHERE (UserUID = @receiveClientUserNumber)

or

Code:

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.PointLog WHERE (UserUID = @receiveClientUserNumber)

and try again..

KILLSTEAL · Jun 2, 2010

Twilight said:

in Billcrux30 -> procRequestOrderProductByGame
find string

Code:

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PointLog WHERE (UserUID = @receiveClientUserNumber)

change

Code:

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.dbo.PointLog WHERE (UserUID = @receiveClientUserNumber)

or

Code:

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.PointLog WHERE (UserUID = @receiveClientUserNumber)

and try again..

Both dont work same Error again:

2010-06-02 09:49:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Objektname 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:49:38 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'B1_regem0001')}

2010-06-02 09:49:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Objektname 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:49:58 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'B1_inche0005')}

2010-06-02 09:50:56 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Objektname 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:50:56 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'PK_remed0002')}

In English:

2010-06-02 09:49:38 err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:49:38 SaveGiftPointItem 9 [DA]-KAMPFSAU Qerr 100 = (? = Call [usp_Save_User_NCash] (1,3, 'B1_regem0001'))

2010-06-02 09:49:58 err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:49:58 SaveGiftPointItem 9 [GM] KAMPFSAU Qerr = **** (? = Call [usp_Save_User_NCash] (1,3, 'B1_inche0005'))

2010-06-02 09:50:56 err =- 1 [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:50:56 SaveGiftPointItem 9 [GM] KAMPFSAU Qerr = **** (? = Call [usp_Save_User_NCash] (1,3, 'PK_remed0002'))

Twilight · Jun 2, 2010

Ok.
use sql query for test:

use PS_GameData;
exec usp_Save_User_NCash 1,3,'B1_regem0001';

Error?

KILLSTEAL · Jun 2, 2010

Twilight said:
Ok.
use sql query for test:

use PS_GameData;
exec usp_Save_User_NCash 1,3,'B1_regem0001';

Error?

Msg 208, Level 16, State 1, Procedure procRequestOrderProductByGame, Line 35
Ungültiger Objektname 'PointLog'.

In English:

Msg 208, Level 16, State 1, Procedure procRequestOrderProductByGame, Line 35
Invalid object name 'PointLog'.

Twilight · Jun 2, 2010

Insert here your the text of its procedures procRequestOrderProductByGame
possible error

KILLSTEAL · Jun 2, 2010

Twilight said:
Insert here your the text of its procedures procRequestOrderProductByGame
possible error

PHP:

set ANSI_NULLS OFF
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[procRequestOrderProductByGame] 
@buyClientUserNumber               BIGINT,
@receiveClientUserNumber           BIGINT,
@itemCode                          VARCHAR(50),
@resultCode                        SMALLINT           	OUTPUT,
@cashBalanceAfterOrder             INT                      	OUTPUT,
@orderNumber			      INT			OUTPUT
AS

DECLARE @CheckUserBy BIGINT
DECLARE @CheckUserReceive BIGINT

--print @receiveClientUserNumber

SELECT @CheckUserBy = UserUID FROM Chars WHERE  UserUID = @buyClientUserNumber AND Del = 0
SELECT @CheckUserReceive = UserUID FROM Chars WHERE  UserUID = @receiveClientUserNumber AND Del = 0
--/Check EMPTY ITEMS/
IF(@itemCode  = '0' OR @itemCode IS NULL)
BEGIN
	SET @resultCode = 1 --if item empty code return error 1
	RETURN @resultCode
END

--/Check USERS/
IF( @CheckUserBy = 0 OR @CheckUserReceive IS NULL ) OR ( @CheckUserReceive = 0 OR @CheckUserBy  IS NULL )
BEGIN
	
	SET @resultCode = 2 --if users not present return error 2
	RETURN @resultCode
END

ELSE
BEGIN
SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.PointLog WHERE (UserUID = @receiveClientUserNumber)

IF ( @cashBalanceAfterOrder = 0 OR @cashBalanceAfterOrder IS NULL ) OR (@cashBalanceAfterOrder < 0)
    BEGIN
	SET @resultCode = 6 --if remain money 0   Hack?
	RETURN @resultCode
END


-- ALL ERRORS CHECK----------
IF @@ERROR <> 0 
    BEGIN
	SET @resultCode = 5 --if sql query return error...return error
	RETURN @resultCode
END
ELSE
    BEGIN
	SET @resultCode = 0
	RETURN @resultCode  -- return ok
RETURN @cashBalanceAfterOrder
RETURN @orderNumber
 
   END

END

Msg 201, Level 16, State 4, Procedure procRequestOrderProductByGame, Line 0
Die Prozedur oder Funktion 'procRequestOrderProductByGame' erwartet den '@buyClientUserNumber'-Parameter, der nicht bereitgestellt wurde.

(1 row(s) affected)

(1 row(s) affected)

In English:

Msg 201, Level 16, State 4, Procedure procRequestOrderProductByGame, Line 0
The procedure or function 'procRequestOrderProductByGame expects' the' @ buyClientUserNumber' parameter that was not provided.

(1 row (s) affected)

(1 row (s) affected)

Twilight · Jun 2, 2010

exec.. sql query

Code:

SELECT * FROM  PS_GameData.dbo.PointLog

Error?

KILLSTEAL · Jun 2, 2010

Twilight said:
exec.. sql query

SELECT * FROM PS_Gata.dbo.PointLog

Error?

exec.. sql query

SELECT * FROM PS_GameData.dbo.PointLog

Msg 2812, Level 16, State 62, Line 1
Die gespeicherte Prozedur 'sql' wurde nicht gefunden.

(1462 row(s) affected)

Twilight · Jun 2, 2010

KILLSTEAL said:
SELECT * FROM PS_GameData.dbo.PointLog

strange.. it works
SELECT * FROM PS_GameData.dbo.PointLog

temporary fix.. exec and test.. see log

Code:

use Billcrux30;
GO
drop procedure [dbo].[procRequestOrderProductByGame]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO


CREATE PROCEDURE [dbo].[procRequestOrderProductByGame] 
@buyClientUserNumber               BIGINT,
@receiveClientUserNumber           BIGINT,
@itemCode                          VARCHAR(50),
@resultCode                        SMALLINT               OUTPUT,
@cashBalanceAfterOrder             INT                          OUTPUT,
@orderNumber                  INT            OUTPUT
AS

    SET @resultCode = 0
    RETURN @resultCode
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

KILLSTEAL · Jun 2, 2010

Twilight said:
strange.. it works
SELECT * FROM PS_GameData.dbo.PointLog

...

THX A LOT IT´s WORKS NOW FINE :w00t:

Cyber_Garret · Jul 7, 2010

Ty for fix work fine

wshraa520 · Aug 24, 2014

hihihi

Welcome!

PS_DBAGENT__system log ERROR !

Junior Spellweaver

DEV

DEV

Attachments

Junior Spellweaver

DEV

Junior Spellweaver

DEV

Attachments

Junior Spellweaver

DEV

Junior Spellweaver

DEV

Junior Spellweaver

DEV

Junior Spellweaver

DEV

Junior Spellweaver

DEV

Junior Spellweaver

Newbie Spellweaver

Initiate Mage

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor