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!

[MentaL]

[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]
    @userId    AS    nvarchar(64)
AS
DECLARE @cashBalance    AS    INT
SELECT @cashBalance = cashBalance FROM tblUserInfo WHERE userId = @userId AND apply = 1
IF(@@ROWCOUNT = 0)
    SET @cashBalance = -1
SELECT @cashBalance 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]
    @userId    AS    nvarchar(64)
AS
DECLARE @cashBalance    AS    INT
SELECT @cashBalance = cashBalance FROM tblUserInfo WHERE userId = @userId AND apply = 1
IF(@@ROWCOUNT = 0)
    SET @cashBalance = -1
SELECT @cashBalance 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.