Item Server Log of Death?

[A v a r a]

I am wondering what does this log indicates?

sql [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'hb_tan_gp_userinfo_se'.

..and how to avoid this..

Ciao!

 

[Radiantecf]

Create a ODBC to billcrux_phil Data Base and configure config.txt with this ODBC.

The problem is the hb_tan_gp_userinfo_se store procedure, if you still have the same problem you can execute the next code in your billcrux_phil Data Base.

/****** Object:  StoredProcedure [dbo].[hb_tan_gp_userinfo_se]    Script Date: 09/21/2014 18:05:14 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[hb_tan_gp_userinfo_se]
    [USER=1335]user[/USER]Id    AS    nvarchar(64)
AS
DECLARE [USER=315880]cas[/USER]hBalance    AS    INT
SELECT [USER=315880]cas[/USER]hBalance = cashBalance FROM tblUserInfo WHERE userId = [USER=1335]user[/USER]Id AND apply = 1
IF(@@ROWCOUNT = 0)
    SET [USER=315880]cas[/USER]hBalance = -1
SELECT [USER=315880]cas[/USER]hBalance AS cashBalance
GO

 

[A v a r a]

Create a ODBC to billcrux_phil Data Base and configure config.txt with this ODBC.

The problem is the hb_tan_gp_userinfo_se store procedure, if you still have the same problem you can execute the next code in your billcrux_phil Data Base.

/****** Object:  StoredProcedure [dbo].[hb_tan_gp_userinfo_se]    Script Date: 09/21/2014 18:05:14 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[hb_tan_gp_userinfo_se]
    @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Id    AS    nvarchar(64)
AS
DECLARE @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance    AS    INT
SELECT @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance = cashBalance FROM tblUserInfo WHERE userId = @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Id AND apply = 1
IF(@@ROWCOUNT = 0)
    SET @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance = -1
SELECT @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance AS cashBalance
GO

Thanks. Will look forward for the logs after restarting my itemsvr.exe.

 

[A v a r a]

@Radiantecf

How about for "hb_tan_gp_applyinfo_userinfo_in" do you have a script for this? Please help.

 

[iElyrb]

I suggest you look for a fixed database and restore it on another instance then just copy the whole stored procedures on your live server.

You are missing stored procedures on billcrux_phil.