on 01-13-2012 1:02 PM
Hi,
I've made a scenario to upload many items into SAPBO. It work perfect!
A litle problem: when it's running any other call to SQL is "waiting..." until the B1if's job end (sooooome hours).
There is a parameter to limit B1if's call to the sql sever (2008 r2) ?
SAPBO version: 8.81 pl 10
B1if is on dedicated server, not the same of SAPBO, but same network.
Thank you for any help!
Hello Monzani, this one is off-topic but I need to do the same as you did, would you give me some guidelines to upload multiple items to SAP through B1if?
Thank you in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eros,
B1if is running all B1 atoms of a Scenario Step inside the same transaction. What means if you have a big loop inside your Scenario Step doing several B1 calls then B1 and the corresponding SQL tables in the SQL server will be blocked in the meanwhile.
If you don't need to have all operations inside the same B1 transaction then you should change your scenario package structure. You have different choices:
1. To read only one entry from your input table everytime. Maybe not to good for performances.
2. To break down your Scenario Step into 2 parts:
1 part reading from SQL and putting all needed B1 actions one by one inside an InternalQueue
There is an atom type called "Put to Internal Queue" that allows you to send a message to an Internal Queue.
1 part taking one by one the messages from the Internal Queue and sending the information to B1.
You can define a Scenario Step with Inbound Channel Type = Internal Queue.
Let me know if you need some clarifications.
Regards,
Trinidad.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Trinidad,
i'm sending you a mail with the requested infos.
thaks again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
no ideas?
we also noted tables looking on another database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eros,
In order to investigate a bit more your problem I need some more details.
Could you please explain a bit your scenario? What are the inbound/outbound channels? What kind of processing are you doing?
Do you have a loop inside your processing flow in order to go over all the documents inside the same processing flow or each document/masterdata is processed as a different message?
Thanks,
Trinidad.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.