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.....
This is my code.....
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
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
-- 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
Edited by: ani nazir on Oct 21, 2008 3:59 PM
Edited by: ani nazir on Oct 21, 2008 4:41 PM