Skip to Content

Connection Parameters: 

Although it may sound unnecessary, the first check is ensure you have the correct parameters set in your connection method.

  • Server: Test using IP address as well as Server name. Also include the Instance name if used. When installing the SAP Business One server on Version 8.8, you can no longer enter (local) or a period (.) for the server name. The name must be a server name or IP address.

  • DBType: dst_MSSQL /dst_MSSQL2005 depending if customer is using MSSQL 2000 or MSSQL 2005. Up until Version 2007, the default value for the DBServerType property of the Company object was dst_MSSQL (SQL Server 2000), so you could connect to the DI API without specifying a server type if you were using SQL Server 2000. In Version 8.8, you must specify a server type.

  • LicenseServer: ensure it is started and the correct name with port is used e.g. localhost:30000 or TestPC:30000

  • DBUserName and DBPassword are set and are correct.  

 DI Connection

image

 DTW Connection:

image

SM_OBS_DLL folder is not updated:

This is the most common solution to errors that occur when connecting to the DI/DTW. When connecting to the DI API the following occurs:

  • The SAPbobsCOM connects to the server and requests the OBServer.dll (stored in the SBO-Common database)
  • The OBServer.dll is loaded from the server into process memory and stored in the temp folder on the local system
  • Via the OBServer.dll it accesses the company database

This means the OBServer.dll is downloaded only during the first connection and uses this each time it wants to connect there after. When you upgrade your DI and there has been a database upgrade then the new version of the OBServer.dll will be downloaded automatically to the SM_OBS_DLL folder in the temp folder. If there has only been a client upgrade then the SBO-Common version is unchanged so the OBServer.dll will not be replaced since it doesn’t detect the change.

Therefore after each upgrade we recommend that you do the following:

  1. Go to Start -> Run and type %temp%
  2. Locate the folder SM_OBS_DLL
  3. Delete or rename this folder

Version mismatch: 

Ensure the SBO-Common version, the SAP Business One company database version and the DI version are ok.

  • Common version- stored in the SINF table of the SBO-COMMON database

image

 

  • Database version – stored in the CINF table in the company database

image

 

  • DI Version – OBServer.dll -> Properties -> Special Build Description

image

 

While these are common checks you can do, the root cause could be due to a number of other reasons. For more detailed root cause analysis for DI Connection errors I would highly recommend that you visit the SDK Landing Page on the Portal https://sapneth1.wdf.sap.corp/~sapidb/011000358700000070422009E.

You can find really useful RCA(Root Cause Analysis) for many other topics like:

 AR/AP

Documents don’t appear in Dunning Wizard

 Performance

UDF System Freeze

 

Slow Login to SAP Business One

 

Slow Performance in SAP Business One when using Windows Vista

 

Slow Performance in SAP Business One when using Choose From List functionality

 

Application Shutdown on Initial Logging in

 

SQL native client driver not installed for SAP Business One client

 

SAP Business One shuts down when printing a document containing serial numbers

 System

Upgrade Issues

 

Licence & SAP Service Marketplace issues

 

Alerts Management

 

SAP Business One Server Tool: SBO Mailer

 

SAP Business One Backup Issues 

 

SAP Business One and Citrix

 

SAP Business One Add-on Copy Express issues

 

SAP Business One Add-on Outlook Integration issues

 

SAP Business One Add-on XL Reporter issues 

 DTW

Issues during login to DTW

 

Issues when importing or updating data via the DTW 

 Finance

Profit Centers & Distribution Rules 

 

Budget Issues 

 

Rounding Issues 

 

Cannot reconcile Business Partner Transactions 

 

Tax Report Deviates 

 

Payment Wizard Issues 

 

Sales Report Issues 

 

Profit and Loss Statement doesn’t match with Balance Sheet

 

Unbalanced Trial Balance 

 

Bank Statement Processing 

Financial Add-ons

Fixed Assets Issues

 

Payment Engine Issues  

Cross Topics

ALD Issues 

 

PLD Issues  

 

Check Print Issues  

 Logistics

Serial/Batch Issues

 

Incorrect Committed/Ordered Quantity 

         

To find these go to http://service.sap.com/ -> SAP Channel Partner Portal -> Login -> Solutions -> SAP Business One -> Support -> Support Self Help and Library. It can also be accessed via the following link:

http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000707558&_SCENARIO=01100035870000000183&_ADDINC=&_OBJECT=011000358700000622642008e

Our next blog will cover the topic of macros and how to use these to import/update data for obejcts exposed by the DI but not via the DTW. So catch you then 🙂

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply