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?