Skip to Content
0
Former Member
Oct 21, 2008 at 10:25 AM

Error in B1 DB Profiler

21 Views

Error in B1 DB Profiler:

Even though I configured my SBO_SP_Transaction Notification stored Procedure, I am getting the Error like below.

"An addon test has been run.Several lines should appear in the B1DbProfiler is not correctly configured.If failed please check you have copied the needed code into the SBO_SP_TransactionNotification stored procedure."

Below Note: i found this in discription file....

"Important Note: Please pay attention to the declaration of the object_type variable inside the SBO_SP_TransactionNotification stored procedure. In precedent version it was declared as int, starting from B1 2004 and B1TE 2.0 version we require the declaration of this variable as nvarchar(20). Please change it if you have the old declaration version."

According to the Note: in above i also changed the declaration even though i am getting this error

i am using the sap version->SAP B1 2005B(7.40.252)SP:00 PL:39

If anyone have idea help us.....

Hi...

This is my code.....

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'

-


-- ADD YOUR CODE HERE

-


-- Select the return values

select @error, @error_message

end

Regards,

Anitha

Edited by: ani nazir on Oct 21, 2008 3:59 PM

Edited by: ani nazir on Oct 21, 2008 4:41 PM