Weblog:	SAP Business One Test Environment v2.3
Subject:	B1 DB Profiler is not working with Vista?
Date:	2009-10-22 00:41:39
From:	Harianto Ng  Business Card
Hi, I am trying to use B1 DB Profiler for certification. I have also copied the SBO_SP_PostTransactionNotice.txt to the SBO_SP_PostTransactionNotice Store Procedure. I start the DB Profiler and click on the T button to test. A message telling me that test run has been performed, but I can't see any lines in the Profiler. What could be wrong? Anything else that I need to setup? I am running SAP B1 2007B PL10, SQL Server 2005, and B1TE version 2.3 Any ideas? Regards, Harianto

Previous Message Next Message  Showing messages 1 through 3 of 3. Titles Only Main Topics Oldest First B1 DB Profiler is not working with Vista? 2009-10-26 08:12:53 Maria Trinidad MARTINEZ GEA  Business Card [Reply] Hi, Can you please try to add/update a BP in B1 application for example? (having the code in the SBO_SP_TransactionNotification you should be able to see from B1 app if there is an error message). If the error message is related to "SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures'" please check section "Enable Ole Automation Procedures using sp_configure" in page http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx# Hope it helps Trinidad. B1 DB Profiler is not working with Vista? 2009-10-26 08:12:18 Maria Trinidad MARTINEZ GEA  Business Card [Reply] Hi, Can you please try to add/update a BP in B1 application for example? (having the code in the SBO_SP_TransactionNotification you should be able to see from B1 app if there is an error message). If the error message is related to "SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures'" please check section "Enable Ole Automation Procedures using sp_configure" in page http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx# Hope it helps Trinidad. B1 DB Profiler is not working with Vista? 2009-10-26 08:09:02 Maria Trinidad MARTINEZ GEA  Business Card [Reply] Hi Harianto, Can you just try to copy the code into SBO_SP_TransactionNotification instead? This way you will be able to see if there is an error message when calling the stored procedure. To test afterwards please use B1 to add/update an object (BP for example) and you will see if there is an error message. In case the error message is related to "SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures'" then please check section "Enable Ole Automation Procedures using sp_configure" at page: http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx# Hope it helps Trinidad. Showing messages 1 through 3 of 3.

SAP, mySAP, mySAP.com, xApps, xApp, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product, service names, trademarks and registered trademarks mentioned are the trademarks of their respective owners.