Inconsistent DB in SAP B1 Integration framework

[former_member604797]

There are only two Company Database (SBODemoAu and SBODemoIN) in MS SQL server and SLD but I get the error as shown below (screen print) when I connect to the Integration Framework. I tried to click Sync button but it did not solve the issue. How should should I solve this? Did anyone has faced such issue?

[kvbalakumar · Accepted solution]

Hi,

1. Please check if the Event Sender could connect to B1i successfully.

All Programs -> Integration Solution for SAP Business One ->SAP Business One EventSender -> Setup -> Go to Step 3/5 -> Test Connection

2. Use the below query to check if the created company DB exists in the SLSP table in SBO-COMMON (Records inserted by Business One)

select * from SLSP

3. Check if the system id records exist in SLSPP table (Records inserted by B1i)

select * from SLSPP

4. If the company db records does not exist in SLSPP, please delete the Company DB records in SLSP and go to Business One refresh the DB which will trigger records recreated in SLSP and SEVT (the table to trigger eventsender pick up records and send to B1i). Later you should be able to see the system id created in SLD and SLSPP table.

Regards,

Bala