Upgrade Simulation Tool - error SBO_SP_TransactionNotification

[Former Member]

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

[Former Member]

Ok, I've resolved the problem.

In my Store Procedure @object_type is int ... in other store procedure @object_type is nvarchar(20).

TY