B1 TestEnvironment

[Former Member]

Hi All,

I downloaded B1 Test Environment and installed in the system. Now the proplem is it is unstalled VS IDE and unable to open SQL Management Stuido, gives me JIT script error while opening the SQL MS, then uninstalled B1TE , now works fine my SQL MS.

Can someone help me to work B1 TE, what are the steps should I take to work B1TE.

Thanks

kv

[Gianluigi · Accepted solution]

Very strange. Did you install B1TE from the setup ? usual next / next / next / accept / etc sequence ?

[Former Member · Accepted solution]

Yes, I was downloaded setup file from SDN.SAP.com, and installed successfully, after restart my system sql server not working, even VS studio not working, its deleted VS IDE.

Any one installed B1TE?

Thanks

kv

[Former Member · Accepted solution]

I tried second time and got the same problem again..

thanks

[YatseaLi · Accepted solution]

B1TE works fine in my machine. I am using B12007, MS SQL 2005 and VS 2005. You need to download the right version of B1TE match the verstion B1 and VS.net.

Could you please let us what versions of B1, SQL and VS are you working with?

I guess the reason is the wrong version B1TE, then it update .NET framework, which is used in VS and MSSQL...

Kind Regards

-Yatsea

[Former Member · Accepted solution]

Hi Yatsea Li

Thanks for the response,

I am using SAP B1 2007 and MS SQL 2005, Could you please let me know what B1TE should i download if possible.

thanks

kv

[YatseaLi · Accepted solution]

Hello,

Did you download this?if not, please try this. Thanks.

[SAP Business One Test Environment Tools Setup for SAP Business One SDK 2007 v2.2|https://www.sdn.sap.com/irj/sdn/businessone?rid=/webcontent/uuid/90f6df24-216a-2a10-cd97-948b4f70d544]

Kind Regards

-Yatsea

[Former Member · Accepted solution]

Hi Yatsea...

I am working in SAP B1 2005B,MS SQL 2005 and VS 2005.When I run my B1DBProfiler test Tool,I am getting this below error....

"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."

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, 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

*

o 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'

*

o ADD YOUR CODE HERE

*

o Select the return values

select @error, @error_message

end

Please give me a helpful Reply....

Regards,

Anitha.

[YatseaLi · Accepted solution]

Hello ani

You haven't finished the configuration. please insert the following code into the section.

*

o ADD YOUR CODE HERE

*

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

Please refer to <<C:\Program Files\SAP\SAP Business One Test Environment\B1TE.doc>> more info.

Kind Regards

-Yatsea

[Former Member · Accepted solution]

Hi Yatsea....

Thanks for ur Reply...

Ya... i did this already...Even though i am getting this Error.

What to do?

Regards,

Anitha.

[YatseaLi · Accepted solution]

Hello ani,

But I can't find them in your given code about SBO_SP_PostTransactionNotice or SBO_SP_TransactionNotification.

And here is my SBO_SP_PostTransactionNotice

ALTER proc [dbo].[SBO_SP_PostTransactionNotice]

@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

--DB profiler
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

--DI Event Service
DECLARE @db_name nvarchar(120) -- database name
Select @db_name = db_name()

EXEC @hresult = sp_OACreate 'B1DIEventsSender.Profiler', @object OUT
EXEC @hresult = sp_OAMethod @object, logDb,  NULL, 
	@db_name,
	@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

RETURN
END
--------------------------------------------------------------------------------------------------------------------------------

-- Select the return values
select @error, @error_message

end

Kind Regards

-Yatsea

Edited by: Yatsea Li on Oct 22, 2008 3:01 PM

[Former Member · Accepted solution]

Hi Yatsea....

when i apply ur code to my SBO_Sp_TransactionNotification And excute in SQL. I am getting error in END statement.

Regards,

Ani.

[YatseaLi · Accepted solution]

Hello Ani,

You should copy it to SBO_SP_PostTransactionNotice, not SBO_SP_TransactionNotification

Any qeustion, just let me know. Thanks.

Kind Regards

-Yatsea

[Former Member · Accepted solution]

Hi...

there is no any SBO_SP_PostTransactionNotification, it is mention as SBO_SP_TransactionNotification only. Plz give ur mail id, to send one printed doc.

Regards,

Ani.

[YatseaLi · Accepted solution]

Hello ani,

actually then you can do some small change, just change into SBO_SP_TransactionNotification in the begining of SP

Try this:

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
 
--DB profiler
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
 
--DI Event Service
DECLARE @db_name nvarchar(120) -- database name
Select @db_name = db_name()
 
EXEC @hresult = sp_OACreate 'B1DIEventsSender.Profiler', @object OUT
EXEC @hresult = sp_OAMethod @object, logDb,  NULL, 
	@db_name,
	@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
 
RETURN
END
--------------------------------------------------------------------------------------------------------------------------------
 
-- Select the return values
select @error, @error_message
 
end