Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Upgrade Simulation Tool - error SBO_SP_TransactionNotification

Hi All,

I've SBO2005 SP1 PL46, after installation of "Upgrade Simulation Tool" for upgrade to 2007A, when I choose the specific company on which to run the SAP Business One Simulation Tool, I got this error:

'Change the SBO_SP_TransactionNotification stored procedure parameters according to the installation guide'

This is my SBO_SP_TransactionNotification :

USE [*******]

GO

/****** Object: StoredProcedure [dbo].[SBO_SP_TransactionNotification] Script Date: 09/26/2008 09:28:11 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER proc [dbo].[SBO_SP_TransactionNotification]

@object_type int, -- 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

Not what you were looking for? View more on this topic or Ask a question