Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

Data Not Imported and Detailed Log Screen Blank on Data Transfer Workbench

SAP-Business-One-Tips-Data-Not-Imported

This could be your problem when you use Data Transfer Workbench for import some data to SAP Business One. There’s no error, but somehow, you can’t find any imported data on SAP.

First, when you try to click “Import“, there’s an error:

SAP_Business_One_Tips-STEM-Solve Data Transfer Workbench Error Current Recordset Does Not Support Updating on SAP B1

“Current Recordset Does Not Support Updating. This may be a limitation of the provider, or of the selected locktype.” 

And after finish simulation, you can find on Detailed Log screen blank, none of the results appear. And you can’t update the templates you have uploaded.

So, this happen when windows doesn’t authorize or give permissions for DTW to make modification on your hardisk, and it can be solve with following solutions:

 

  1. User must has administrator rights, and Run As Administrator when clicking to Data Transfer Workbench’s icon.orYou can look with right click on DTW’s icon, choose Properties > Shortcut (tab) > Advanced > tick Run As Administrator > Choose OK on Advance Properties screen > click Apply > OK
    SAP_Business_One_Tips-STEM-Solve Data Transfer Workbench Error Current Recordset Does Not Support Updating on SAP B1
  2. Try to install or reinstall Microsoft Access Database Engine, based on your microsoft office version. If you using Office 2016, you can download Ms. Access Database engine here

Well, this is how we managed to solve the error, and now we successfully import with Data Transfer Workbench to SAP Business One.

, , ,