Skip to Content
0
Former Member
Jul 31, 2007 at 04:50 PM

B1 DB Profiler Test

60 Views

Hi, i have a problem in the B1 DBProfiler.

When i test the DBProfiler, it pop up an error message: error while trying to add a Business Partner.

then nothing shows in the B1 DBProfiler, so it tells me if nothing is showing check ur SBO_SP_TransactionNotification Stored Procedure.

My SBO_SP_TransactionNotification is this:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER proc [dbo].[SBO_SP_TransactionNotification]

@object_type nvarchar(20), -- SBO Object Type

@transaction_type nchar(1), -- [A]dd, <u>pdate, [D]elete, [C]ancel, C[L]ose

@num_of_cols_in_key int,

@list_of_key_cols_tab_del nvarchar(255),

@list_of_cols_val_tab_del nvarchar(255)

AS

begin

-- Return values

declare @error int -- Result (0 for no error)

declare @error_message nvarchar (200) -- Error string to be displayed

select @error = 0

select @error_message = N'Ok'

DECLARE @object int --declare the object variable

DECLARE @hresult int --declare the hresult variable

EXEC @hresult = sp_OACreate 'B1DbProfilerCOM.Profiler', @object OUT

EXEC @hresult = sp_OAMethod @object, logDb, NULL,

@object_type,

@transaction_type,

@num_of_cols_in_key,

@list_of_key_cols_tab_del,

@list_of_cols_val_tab_del

IF @hresult <> 0

BEGIN

EXEC sp_OAGetErrorInfo @object

RETURN

END

-- Select the return values

select @error, @error_message

end

why is this happening?