Rollback Transac in B1if-Database

[Former Member]

Hello,

Nearly every half hour, in SQL-Mgmt Studio we can see this "task" ?

Can anyone tell me something about "Rollback Transac" in  B1if-Database ?

Our Problem is, that during the time this Task is online, nothing happens in our B1i. The System doesn't transfer any Order

Thanks for your help.

Markus

[Former Member]

Hi,

Did you check all active process on log in to your integration?

Remain only task active which are needed.

[Former Member]

Hi,

oh - I don't know what you mean. Can you explain me more, what I have to check ?

[Former Member]

Hi,

You need to log in to your integration administration and check for all active jobs. and select only job required. https://yourstaticipaddress:8843

User id: B1iadmin

Password: yourpassword

[Former Member]

good morning,

I have entered via Port you written down:

Can you tell me where I have to navigate in the Menue to find all active Jobs ?

[Former Member]

Follow below steps:

1 To switch off the transaction log, do the following:

  A Integration Framework -> Maintenance -> Cfg Dev Environment -> deselect ‘Activate Scenarios with Detailed Logging’ -> Save

  B Integration Framework -> Scenarios -> Control -> Untick the check box for active scenarios -> Tick the check box for the deactivated scenarios

2 Change transaction log level to SEVERE.

  A Open Xcellerator.cfg (..\SAP\SAP Business One Integration\B1iServer\Tomcat\webapps\B1iXcellerator)

  B Modify the below parameters and save Xcellerator.cfg

.level= SEVERE

com.sap.b1i.bizprocessor.level = SEVERE

com.sap.b1i.coordservice.level = SEVERE

com.sap.b1i.utilities.level = SEVERE

com.sap.b1i.dblayer.level = SEVERE

com.sap.b1i.xcellerator.level = SEVERE

  C Restart SAP Business One Integration Service

3 Switch off the B1 Event Monitor log

Integration Framework -> Maintenance->B1 Event Monitor-> Untick the check box for Log -> Save

4 Set the Recovery Mode to "Simple" in SQL Server settings

[Former Member]

Hello again Chintan,

thanks for your tips.

after Checking Control - Scenarios I found it like this:

We only use B1i for Documents (Sales-Order, DeliveryNote, Invoice) and OITM

Can you tell me, which of the SAP-Scenarios I can deactivate ?

[Former Member]

Hello again,

i made all changes but the SQL-Task is still there.

The Time, ROLLBACK TRANSAC is working, there is no action in our B1i.

What can I do next ?