SAP Business One Notes Symptom You have installed the SAP Business One integration component according to the guide. However after the installation you cannot use the Cockpit/Dashboard and you require troubleshooting help. Cause Consulting Solution Applicable for 8.81,8.82,9.0 and OnDemand implementations 1. Errors when launching Integration 2. Errors on test connection(Integration Explorer -> SLD) 3. Errors when logging into business One 4. Errors when launching dashboard within Business One Client 1.Errors when launching Integration 1.1 Error HTTP 401: Unauthorized l Root cause 1: localhost was not added to Trusted Sites. l Solution 1: Add http://127.0.0.1 to Trusted Sites (Tools->Internet Options->Security tab->Trusted Sites) l Root cause 2: Admin account for the Integration framework is deactivated l Solution 2: Please refer note:1556041 1.2 Error HTTP 403 Forbidden - XCL198 HTTP access currently not allowed from remote clients, as B1iP runs in local-mode or safe-mode(When accessing B1i from remote machine) l Root cause 1: You use localhost in the B1i Server address. l Solution 1: Ensure instead of localhost you use the IP address or the server name to connect. Open the Integration Framework -> Maintenance -> Cfg Runtime and change the corresponding setting. 1.3 Error HTTP 404 not found/File not found l Root cause 1: Https Port 8443 is being used by another program. l Solution 2: Open https://localhost:8443 via the browser and ensure it is the home page of Apache Tomcat. If not, the 8443 port is occupied by another program. Disable the other program that is using port 8443 or assign another port to the other program. l Root cause 2: SQL Server Service or Tomcat Services have not been started. l Solution 2: Ensure SQL Server//Tomcat Services are started: a. Click Start -> Control Panel -> Administrative Tools -> Services b. Locate the service name "SQL Server (MSSQLSERVER)" and "SAP Business One Integration" and ensure they are started l Root cause 3: There is an SQL server instance name. l Solution 3: If you are using an SQL named instance make sure each instance uses a different TCP/IP port and, during the installation of the integration component, enter the server name as rather than \instance name. Note: 8.81 PL08 and higher will provide regular support for named instances – See SAP Note 1621563 Top 2.Errors on test connection(Intergration Explorer -> SLD) Please refer to SAP Note 2029714. Top 3.Errors when logging into Business One. 3.1 SAP Business One Integration Service authentication failed. Log off from the application; then log on and try again. If the problem persists, contact your system administrator. l Root cause 1: The company is not listed in the SLD(Integration Explorer -> SLD) l Solution 1: Follow the solution provided in Note 2032666 l Root cause 2: [hostname] is used in some configuration settings, and [ip-address] is used in others. l Solution 2: Ensure you use exclusively either the [hostname] or the [ip-address] in all the following configuration settings: a. Integration Framework > SLD > B1i Server > [company database] > B1DI > b1Server b. Integration Framework > SLD > B1i Server > [company database] > JDBC > url c. Integration Framework > SLD > B1i Server > HAnyforXcelsius > associatedSrvIP d. EventSender Setup > Step 1 > DB Server Name e. License Manager > Configure Security > DB Server l Root cause 3:Test connection is not successful 1619422 - B1ic_Troubleshooting Guide for B1ic Dashboard/Cockpit Version 38 Validity: 27.06.2014 - active Language English l Solution 3: Make sure test connection id successful for the following settings. a. Integration Framework > SLD > B1i Server > [company database] > B1DI b. Integration Framework > SLD > B1i Server > [company database] > JDBC l Root cause 4: There are duplicate entries for the Company Database in Integration Framework > SLD. l Solution 4: Remove the duplicate entries. Ensure the details for the remaining Company Database are correct. And restart the SAP Business One Integration Service if required. l Root cause 5: The username or password contains a special character that is not supported by the B1i server. (e.g. “, &, ‘, ) l Solution 5: Update the username or password so that it does not contain any of those special characters. 3.2 Cannot connect to SAP Business One Integration Service. In the Microsoft "Services" window, ensure that this service has been started. l Root cause 1: Firewall is blocking connection from a client workstation to server l Solution 1: Ensure firewall is not blocking ports 8080 and 8443 in the server l Root cause 2: sap.Xcelsius package is not active in Business One Integration Component. l Solution 2: Go to Integration solution for SAP Business One -> Scenarios -> Control -> tick the check box for 'sap.Xcelsius' -> Activate -> OK 3.3 Cannot connect to B1i server. For more information, see below. The operation has timed out l Root cause 1: Firewall is blocking connection from a client workstation to server l Solution 1: Ensure firewall is not blocking ports 8080 and 8443 in the server 3.4 Cannot connect to B1i server. The remote server returned an error :(500) Internal server error. l Root cause 1: Firewall is blocking connection from a client workstation to server l Solution 1: Ensure firewall is not blocking ports 8080 and 8443 in the server l Root cause 2:sap.Xcelsius package is not active in Business One Integration Component. l Solution 2: Go to Integration solution for SAP Business One -> Scenarios -> Control -> tick the check box for 'sap.Xcelsius' -> Activate -> OK l Root cause 3:Test connection is not successful l Solution 3:Fill the correct DIProxy server name/ip and port (SLD->Company->diProxyhost and SLD->Company->diProxyport).Make sure DI Proxy is started and DIProxy port is available(To check port availability. Open Command Prompt -> Enter "netstat -a -n -o |findstr "2099"") 3.5 User logon SAP Business One client and want to enable dashboard. When selecting 'Enable Dashboard Widget', error 'Ensure that SAP Business One Integration Service and SAP Business One Event Sender have been started; then wait 1 minutes and try again' occurs l Root cause 1: Duplicate entries in SBO-COMMON.SLSP. l Solution 1: Please run below query to check whether there any duplicate entries for the same company Db. use [SBO-COMMON] select CompIdent,count(CompIdent) from slsp group by CompIdent having count(CompIdent) > 1 If there is duplicated company record, please delete the extra record by comparing with the records in SLSPP table. Top 4.Errors when launching dashboard within Business One Client. Before correcting dashboard issue, please correct all issues related to login. 4.1 Cannot connect to SAP Business One Integration Service. In the Microsoft "Services" window, ensure that this service has been started. Log off from the application; then log on and try again l Root cause 1: Dashboard scenario is not configured correctly. l Solution 1: Ensure you use exclusively either the [hostname] or the [ip-address] in all the following configuration settings: a. Integration Framework > SLD > B1i Server > [company database] > B1DI > b1Server b. Integration Framework > SLD > B1i Server > [company database] > JDBC > url c. Integration Framework > SLD > B1i Server > HAnyforXcelsius > associatedSrvIP d. EventSender Setup > Step 1 > DB Server Name e. License Manager > Configure Security > DB Server 4.2 The request dashboard does not exist. Dashboard: /com.sap.b1.dashboards/00100001xxx.sap_dashboard_xxx.dabxxx/default.html .If this dashboard is newly imported, ensure that the SAP Business One EventSender Server has been Started; then wait for several minutes and try again. l Root cause 1: After installation of B1iC, the deployment was unsuccessful due to some incorrect configurations l Solution 1: Ensure Event Sender, B1i SLD entries and the Xcelsius scenario are configured correctly a. Deactivate the Dashboard in your Business One client - Disable the Dashboard Widget in Administration->System Initialization->General Settings->Cockpit b. Monitor SBO-COMMON database SEVT table and remove the table records if they're not used for integration purpose. c. Run EventSender Setup (in first step try to avoid using localhost or IP addresses), in third step press Test Connection, in fourth step make sure that your database is checked, press also Receiver button and then Test Connection. Finish EventSender setup. d. Ensure connections to the B1i SLD for your Company database (B1DI and JDBC) are successful. If not, please refer to note chapter 2. e. In the Integration Framework UI, go to Scenarios in upper menu, then select Setup in left menu, select sap.Xcelsius package, make sure company DB is listed in sender list. If not, please refer to solution 3. f. In the Integration Framework UI, go to Scenarios in upper menu, then select Control in left menu, then de-activate and re-activate the Xcelsius scenario. g. Restart the Integration Framework services (DI Proxy, EventSender and Integration) h. Activate the Dashboard in your Business One database - Enable the Dashboard Widget in Administration->System Initialization->General Settings->Cockpit i. The Integration framework will deploy the dashboards again. This may take a few minutes, depending on the performance of your system. After a few minutes, login to the company again and check the Dashboards. l Root cause 2: After installation of B1ic, the company is not listed in the SLD(Integration Explorer -> SLD) l Solution 2: Follow the solution provided in Note 2032666 l Root cause 3:The sender list is not configured for the company database. l Solution 3:Follow below steps a. Login integration explorer->Scenarios->Setup->Select sap.Xcelsius -> Deactivate the scenario b. Click on the sender button->Chose "main sender list" in combo c. In the Sender list window, check the company database where database needs to be deployed. d. Press save and activate the scenario. l Root cause 4:Dashboard deployment failed due to Deactivated IPO steps. l Solution 4:Follow below steps a. Login integration explorer->Monitoring->queue monitor for the checking the message being processed. b. For activating IPO steps ,Control Center-> Monitor -> IPO-Step Status -> Select the CheckBox "Deactivated Steps only"->Press Submit. c. If there are any deactivated steps then reactivate it by pressing the (Re)activate button. l Root cause 5:Incorrect DIproxy settings. l Solution 5:On Step 3/5 of the Event Sender set up ensure Proxy Host or the Proxy Port are configured and test connection successful. 4.3 Internal Reason: Did not supply the DB-driver (Param1)! l Root cause 1: The instance that is called by B1 dashboard (/vP.001sap0004.in_HCSX/com.sap.b1i.vplatform.runtime/INB_HT_CALL_SYNC_XPT/INB_HT_CALL_SYNC_XPT.ipo/proc) was incorrectly generated in its deployment document:/com.sap.b1i.system.xc/xml.deployments/vP.INB_HT_CALL_SYNC_XPT.xml l Solution 1: Go to Integration solution for SAP Business One -> Scenarios -> Control -> tick the check box for 'sap.Xcelsius' -> Deactivate then Activate 4.4 Security alert: The identity of this web site or the integrity of this connection cannot be verified l Root cause 1: Internet Explorer security settings l Solution 1a: Reduce the Internet Explorer security settings (Tools->Internet Options->Security tab). Please add the site to the trusted sites as well in IE. l Solution 1b: Follow the steps in Note 1810486 to install the certificate. 4.5 Error #2032 Connection type: XML Data l Root cause 1: Incorrect setting in Server Manager l Solution 1: Start "Server Manager"-> Under the "security information section, click on the Configure IE ESC" link and Turn off for Administrators. l Root cause 2: Improper IE setting l Solution 2: In toolbar of the Microsoft Windows Internet Explorer,choose Tools -> Internet Options. In the Settings section of the Advanced tab, navigate to the Security list, and deselect the checkbox Do not save encrypted pages to disk. 4.6 The server xxxx at B1iP_ipo_/vP.001sap0004.in_HCSX/com.sap.b1i.vplatform.runtime/INB_HT_CALL_SYNC_XPT.ipo/proc requires a username and password”. l Root cause 1: Explicit authentication required. l Solution 1a: If this occurs in SAP Business One you should restart the SAP Business One client l Solution 1b: Check the Configuration Runtime settings (Integration Explorer -> Maintenance -> Cfg runtime). Set the correct B1i Server name and restart the SAP Business One Integration service. 4.7 Dashboard not loaded and displays no errors. l Root cause 1: Missing ActiveX component. l Solution 1: Install Adobe flash player on the workstation. l Root cause 2: In Windows Server 2008 or 2012 Windows Desktop Experience needs to be activated. l Solution 2: Activate Windows Desktop Experience: 1. Click Start, point to Administrative Tools, and then click Server Manager; 2. In the Server Manager, click Features, and then in the Server Manager details pane, under Features Summary, click Add features; 3. In the Features list, select Desktop Experience, and then click Install. 4.8 Dashboard 'Top 5 Customers' does not load data in Business One 9.0 l Root cause 1:The dashboard authorization is not assigned to any group l Solution 1: Go to Business One Client -> Tools -> Query -> Query Manager -> Manage Categories -> Choose [SAP_DASHBOARD_001_DAB003_QUERY] -> Click 'Select All' button to choose all groups -> Click [Update] -> OK 4.9 Dashboard 'Sales Analysis' does not load data in Business One 8.82 and 9.0 l Root cause 1: 'Sales Analysis' relevant store procedures are missing from company database. The issue only occurs to Microsoft SQL Server 2005 or 2012. l Solution 1: Go SQL studio, backup the company DB. Extract the attached 'missing_sp.zip', paste and execute the query against the company DB. 4.10 Did not supply an appropriate user-ID integer (Param6). l Root cause 1: The url property (SLD->company entry->JDBC section) for the company entry is not pointing to the correct Database. l Solution 1: Change the url to point to the correct company database. It should look like: jdbc:sqlserver://[Server]:1433;integratedSecurity=false;databaseName=[company database name];selectMethod=cursor Top Header Data References This document refers to: SAP Business One Notes This document is referenced by: SAP Business One Notes (2) Validity Embedded Objects Released On 27.06.2014 09:39:41 Release Status Released for Customer Component SBO-INT-DAB Dashboards SBO-INT-B1IF SAP Business One integration framework SBO-INT-CKP Cockpit Priority Recommendations/additional info Category Consulting 2032666 SAP Business One company database entries missing from integration framework SLD 1810486 Dashboard Certificate Sercurity Alert appears on every logon to Business One 1621563 B1if_ SQL named instances in the "Integration Component" 1556041 Admin account for the Integration framework is deactivated 1844555 ICO_Troubleshooting Guide for Intercompany Integration Solution 1765361 Electronic Document CFDi is not generated or error received from PAC Software Component Version SAP BUSINESS ONE 8.81 8.82 9.0 File Name File Size (KB) Mime Type missing_sp.zip 13 application/x-zip-compressed dashboard.zip 1910 application/x-zip-compressed Other Components