Skip to Content

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

B1 TestEnvironment

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

Former Member
replied

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

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