Skip to Content
avatar image
Former Member

SAP DTW Unusual Error

Hello SAP expert users,

We are having hard time in troubleshooting the Data Transfer Workbench (DTW) on SAP Business One Application.

SAP Version: SAP 9.0 PL09 HotFix

SQL Version: MS SQL 2008 R2

SAP applications installed on the SAPServer:

  • SAP Client both 32 & 64 bit
  • SAP DI API 32 & 64 bit
  • SAP DTW 32 & 64 bit

We are importing the fixed asset template through DTW in the SAPServer itself wherein the SAP B1 client is installed, but after selecting the templates, the message "Unhanded exception appears". To make the explanation simple, we can successfully login on DTW on the server itself, but we are encountering error and we can't proceed with the importing of templates.

We also tried to install and configure the DTW on SAP workstations, however different errors occur.

For reference, please see attached screenshots

Unable to access SBO-Common database error appears when we input the SERVER NAME on DTW.

we also tried the IP Address of the server, but this error message occurs.

Steps taken but did not help solve the issue:

1. We can login successfully on SQL Server Management Studio (ALL services are running, restarting of all services are taken of course)

2. Windows firewall is off on the server (including the firewall of the anti virus is off)

3. For the SAP workstations, uninstalling and re installing the SAP client (32 & 64 bit) and DWT are tried as well.

(Note: Given that all workstations are on the same network, domain, sub net and gateway)

(Note2: Another add on is installed for SAP Business One, which is iVend Retail, a POS system which is integrated into SAP business One. That is why we can't try uninstalling and re installing the SAP client, di api and dtw on the server. It may damage the processing or system.

Please help us ASAP regarding this concern, we can't also import even a basic template through DTW in SAP Business One. It suddenly crushes on the server and on the workstations, it can't connect.

Thank you and Best Regards,

Nelisa Bajan

SAP Consultant

IP_DTWError.png (30.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 08, 2015 at 03:46 AM

    Hi,

    Check:


    • Ensure you have the correct DB Type selected under
      the Login options.

    • Verify that all connection information is correct
      (for example, the correct user name and password or the user has enough right to
      connect to the database server in case Windows Authentication is used).

    • Check whether the database is running properly, make
      sure that the COMMON and company databases are not suspended or
      stopped.

    • Ensure there is no DI API version mismatch.
    Add comment
    10|10000 characters needed characters exceeded