Troubleshooting Replication Incomplete and MYOB Connection Errors

Initial Diagnostics

Before changing system settings, identify the specific cause of the failure:

• Check the Status Reporter: Press Shift + F5 within Datapel WMS. This window captures specific error logs and provides clues about which part of the sync failed.

• Identify "Stuck" Connections: If MYOB crashed recently, a "lock file" might be preventing WMS from reconnecting. Ensure all MYOB processes are closed in the Task Manager before restarting the sync.

Connection & Configuration Fixes

Verify Connection Details

Go to Tools > Connect > Configuration and ensure:

1. The path to the MYOB company file is correct and accessible.

2. All users are accessing the MYOB data file using the same path (e.g., all using a UNC path like \\Server\Data\ or all using the same mapped drive letter like Z:\). Mixing paths causes ODBC conflicts.

Check the Preference File (prefs.xml)

Navigate to C:\Program Files (x86)\Datapel Systems\Warehouse Management System\.

• If "Multi MYOB" is enabled in prefs.xml, ensure users are logging in via Myobp.exe.

• Verify that the company name does not contain an ampersand (&) symbol, as this can break the XML parsing.

ODBC Driver Check

• Check ODBC_MYOB.ini in C:\Program Files (x86)\Datapel Systems\Common.

• If the driver is corrupt, a reinstallation of the MYOB ODBC driver is required.

• Registry Path: Ensure the following registry key points to the correct MYOB installation: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\App Paths\Myobp.exe

Environment & Security Settings

Antivirus Exclusions

Antivirus software often blocks the background communication between the WMS and MYOB. Exclude the following processes from scanning:

• WMS.exe

• DTconnection.exe

• DTMYOBCONNECT.dll

• MYOBP.exe

Data Execution Prevention (DEP)

DEP can stop the replication service. To add an exception:

1. Right-click This PC/My Computer > Properties > Advanced System Settings.

2. Under Performance, click Settings > Data Execution Prevention tab.

3. Select "Turn on DEP for all programs and services except those I select" and add the processes listed in the Antivirus section above.

File & Permission Requirements

• Folder Access: The user must have "Full Control" permissions for:

  • The MYOB installation path.

  • The MYOB data file location.

  • C:\Windows or the user’s local Windows folder (C:\Users\[Username]\WINDOWS) to allow MYOB to create required .ini files.

• Mapped Drives: Avoid using mapped home drives for system files. Use a physical drive or a script-mapped drive to ensure the odbc.ini is created correctly for TCP/IP use.

Advanced Troubleshooting

If the error persists:

1. Verify & Optimize: Perform a "Verify" and "Optimize" on the company file within MYOB (ensure you have a backup first).

2. TCP/IP Protocol: Ensure users are logging into MYOB using the TCP/IP protocol, not just a local file opening.

3. Test Connection: Use the Datapel Connection Test utility to isolate whether the issue is with the WMS or the underlying ODBC link.

Related Information

Should you find further errors please notify support so they may be included in this article.

Can use below method to check the effective permissions to folders

https://technet.microsoft.com/en-us/library/cc771586(v=ws.11).aspx