cancel
Showing results for 
Search instead for 
Did you mean: 

B1if > Items mass imports > SQL full

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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.

Trinidad
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

Former Member
0 Kudos

Hi Trinidad,

i'm sending you a mail with the requested infos.

thaks again.

Former Member
0 Kudos

no ideas?

we also noted tables looking on another database.

Trinidad
Product and Topic Expert
0 Kudos

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.