BizTalk - Use of the same SQL stored procedure in multiple Biztalk applications

Asked By Abhishek Iyer
10-Sep-10 02:29 AM

Hi friends,

I have a scenario in which I have a certain number of reports to be generated through SAP and the data for which is to be passed through SQL. In the SQL database, i have a single table that will give the details of the reports to be passed to SAP. The BAPIs, on the other hand,have limited scope in that each BAPI will generate only 2 reports or some such thing.

So, my query is : Can the same Stored Procedure passing the same data to both the BAPIs(4 same fields passed to different BAPIs) be used in two simultaneously running BizTalk applications? i tried this and the problem that i'm facing is that the second one is not getting connected to SAP.

Kindly suggest an answer at the earliest.

  Mohan Raj Aryal replied to Abhishek Iyer
23-Sep-10 03:44 PM
You should be able to use same stored procedure for multiple applications without any problem. Since your goal is to  is just to read some master data (static data).

One thing I want to make on your notice is BizTalk SQL adapter has it's own isolation level (Serializable), which loves to cause deadlocks most of the time. So you can change the isolation level while pooling data from database.  You can read this article to know SQL Adapter Isolation Level. Most relaxed isolation level is READ COMMITTED.

In case of incorrect use, biztalk might decide to throttle the system resources. 

Also, I would suggest to think about keeping those parameter values in some xml configuration files if possible. 
Create New Account
help
Biztalk Stored Procedure problems with NULL value Hi All, In my Biztalk(2004) Orchestration, I use a stored procedure to update some tables in a database hosted by SQL Server 2003. The input of
Calling Stored procedure without parameters in BizTalk using SQL Adapter Hi I know how to use a SQL adapter calling a stored procedure with parameters from Orchestration, but how to call stored procedure without parameters when I generate metadata for the stored procedure I m just gettin the request root node so my question is do I
Error message from SQL adapter Windows Server I have a two-way send-receive SQL BizTalk port (BizTalk 2006). This port executes a stored procedure (SQL Server 2005). This stored procedure returns the content of a column of type 'text'. Sending a request to the sql port triggers the following error from BizTalk: A message sent to adapter "SQL" on send port "RequestToSQLPort" with URI "SQL: / / localhost / MyDB suspended. Error details: HRESULT = "0x 7a" Description = "No error description provided" After having edited the stored procedure so that the text column is converted to a local varchar(8000) variable and
Calling parameterized SQL Stored Procedure through Orchestration Windows Server I want to call stored procedure with simple SELECT query [in loop] from orchestration which takes an input parameter [say customerCode am not aware of the way wherein I can pass the variable parameter to my stored procedure. I call the stored procedure in loop [say 5 times] and each time I call the SP I need to
xml DATA FROM ORCHESTRATION to stored procedure xml parameter Windows Server i want to pass xml DATA FROM ORCHESTRATION to stored procedure xml parameter. I want to copy xml tree from source message to Stored procedure xml parameter. My problem is that mass copy cannot be assigned to a attribute field While generated scheama wizard makes parameters of stored procedure as an attribute. So how can i copy the xml into a generated schema xml