2229208 – DTW_Enable Faster Import

Symptom

When you work on the SAP HANA database, to improve the performance of DTW, you can choose to enable faster import for some objects.

Solution

As of SAP Business One 9.1 PL11, in DTW, you can use the Enable Faster Import function for the SAP HANA DB companies.

Scenario:

  1. Log on to DTW, select a SAP HANA database server, and then select the checkbox “Enable Faster Import” below the Companies on Current Server area.

    This checkbox is unchecked by default. If you select the checkbox, DTW will install SAP DI API as COM+ applications.
    Note: Make sure that you have the proper permission to enable COM+ application.

  2. Specify the Number of Threads field. The default number of threads is 4, but you can manually input a number between 1 and 21 depending on your hardware configuration. (Rule of thumb: the stronger the hardware configuration you have, the more threads you can define.)
    DTW will start the same number of threads, and each thread is connected to a COM+ application process, thus DTW can use multiple DI API processes to import data.
    We recommend that you use multiple threads if you import over 1000 master data records and 1000 transactional data records. (Tested by 8 multiple threads on a machine with a 4 core, 8 thread CPU.)
  3. You can fast import the following business objects:
    • Business Partner
    • Item Master Data
    • Sales Quotation
    • Sales Order
    • Delivery
    • A/R Invoice
    • Purchase Quotation (for update only, while not for add)
    • Purchase Order
    • Goods Receipt PO
    • A/P Invoice
  4. When you use faster import, in Step 6: Define Error Handling, the first option Cancel Import and Perform Rollback When One or More Errors Occur is not available, neither is the Run Simulation button.
    As for the third option Ignore Up to _ Errors and Process Valid Records, note that the number of errors might be greater than the defined value. For example if it’s set to 10, one thread has an error and reached the maximum number of errors 10. Meanwhile other threads have already started to import data before this occurred and would continue to run, and also possibly receive errors in the end. Therefore, the number of errors could be anything from 10 to 10+N-1, N is the number of threads input when you log on.
  5. When you finish faster import and check the result, the order of data imported could differ from that in the data file because of the multiple threads.

Note:

  • If faster import is enabled, you cannot start multiple instances of DTW.
  • Before you try to uninstall SAP Business One DI API, make sure that the faster import is disabled first.
Picture of Trần Văn Sơn

Trần Văn Sơn

Với 18+ năm kinh nghiệm và 50+ dự án thành công, tôi chuyên giải quyết bài toán quản trị từ gốc rễ quy trình và con người. Phương châm của tôi là hướng doanh nghiệp vận hành theo chuẩn SAP B1 toàn cầu, đảm bảo hệ thống vận hành đơn giản, hiệu quả ở hiện tại và dễ dàng nâng cấp, mở rộng trong tương lai.
Thảo luận và chia sẻ kinh nghiệm
Bạn có gặp tình huống tương tự khi sử dụng hệ thống SAP Business One?

Bài có liên quan theo chủ đề đang xem

Scroll to Top