x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Subscribers 22 subscribers
  • Views 1586 views
  • Users 0 members are here
Browse Forums
Announcements
649
topics
57
replies
General Discussion
2k
topics
5k
replies
Intelligence Reporting
348
topics
833
replies
KavirM

Sage 200 V10 Offline Branch Accounting Initial Sync Error

SOLVED
Posted By

Hi All,

I've setup the HO and Branch Sync Monitors (Version 10.0.0.062 > 32 bit) and started the initial sync from the HO Sync Monitor. While exporting for the branches I get the following error:

upload exception: Cannot open file "C:\Sage 200 Branch Accounting\PMB_HO_Update_Folder\0001-0000-B0MBSQ.xml". The system cannot find the file specified

The Complete Log is as follows:

2020-02-25 16:08:46.784 [I] Branch Pietermaritzburg: Downloading Hash File...
2020-02-25 16:08:46.791 [I] Nothing to download
2020-02-25 16:08:46.817 [I] Branch Pietermaritzburg: Downloading...
2020-02-25 16:08:46.822 [I] Nothing to download
2020-02-25 16:08:46.839 [I] Branch Pietermaritzburg: Downloading...
2020-02-25 16:08:46.841 [I] Looking for Data Recovery file...
2020-02-25 16:08:46.845 [I] Nothing to download
2020-02-25 16:08:46.863 [I] Branch Pietermaritzburg: Downloading...
2020-02-25 16:08:46.865 [I] Looking for Data Recovery file...
2020-02-25 16:08:46.868 [I] Nothing to download
2020-02-25 16:08:46.887 [I] Looking for any corrective files
2020-02-25 16:08:46.913 [I] Branch Pietermaritzburg: Exporting...
2020-02-25 16:10:53.468 [I] Creating sync hash verification file... 0001-0000-B0MBSQ.xml
2020-02-25 16:10:53.469 [I] Generating files hashes... 0001-0000-B0MBSQ.xml
2020-02-25 16:10:53.572 [I] Hash verification file complete.
2020-02-25 16:10:53.573 [I] Loading sync hash verification file... 0001-0000-B0MBSQ.xml
2020-02-25 16:10:53.575 [I] Searching sync hash verification file for completed file imports
2020-02-25 16:10:53.576 [I] Searching sync hash verification file completed, no entries removed
2020-02-25 16:10:53.578 [I] Export complete
2020-02-25 16:10:53.588 [I] Branch Pietermaritzburg: Uploading...
2020-02-25 16:10:53.597 [I] Purging acknowledged uploads
2020-02-25 16:10:53.611 [I] Upload complete
2020-02-25 16:10:53.636 [I] Branch Pietermaritzburg: Uploading...
2020-02-25 16:10:53.649 [I] Purging acknowledged uploads
2020-02-25 16:10:53.660 [I] No files found to upload
2020-02-25 16:10:53.677 [I] Branch Pietermaritzburg: Uploading...
2020-02-25 16:10:53.685 [I] Purging acknowledged uploads
2020-02-25 16:10:53.693 [I] No files found to upload
2020-02-25 16:10:53.713 [I] Branch Pietermaritzburg: Uploading Hash File...
2020-02-25 16:10:53.725 [I] Removing 0001-0000-B0MBSQ.xml
2020-02-25 16:10:53.733 [I] Uploading file: C:\Sage 200 Branch Accounting\PMB_HO_Update_Folder\0001-0000-B0MBSQ.xml (1 KB)
2020-02-25 16:10:53.742 [I] Will restart partial upload if allowed by FTP server
2020-02-25 16:10:53.747 [E] Upload exception: Cannot open file "C:\Sage 200 Branch Accounting\PMB_HO_Update_Folder\0001-0000-B0MBSQ.xml". The system cannot find the file specified
2020-02-25 16:10:53.807 [E] An error occurred while processing this branch... Attempting to retry in 10 seconds. Retry 1 of 3

My next step was to verify my FileZilla Server settings as well as make sure the Branch Accounting Folders had all permissions. After doing this, I tried a custom export from HO for branch 1 and got the following error: (Note that I have deleted all DAT and PART files from the branch Accounting folders before attempting the custom export)

2020-02-26 11:10:18.096 [I] Custom export starting
2020-02-26 11:10:18.113 [I] Branch Pietermaritzburg: Exporting...
2020-02-26 11:10:20.119 [I] Records exported from 51 tables. Creating export file 0001-0000-000000-B0MBSQ
2020-02-26 11:10:22.570 [I] Creating sync hash verification file... 0001-0000-B0MBSQ.xml
2020-02-26 11:10:22.572 [I] Generating files hashes... 0001-0000-B0MBSQ.xml
2020-02-26 11:10:22.619 [I] Hash verification file complete.
2020-02-26 11:10:22.635 [I] Custom export complete
2020-02-26 11:10:22.641 [I] Branch Pietermaritzburg: Uploading...
2020-02-26 11:10:22.646 [I] Purging acknowledged uploads
2020-02-26 11:10:22.651 [I] Uploading file: C:\Sage 200 Branch Accounting\PMB_HO_Update_Folder\0001-0000-000000-B0MBSQ.dat (3 MB)
2020-02-26 11:10:23.382 [E] File upload failed: 553 - 553 file exists
2020-02-26 11:10:23.394 [I] Branch Pietermaritzburg: Uploading Hash File...
2020-02-26 11:10:23.399 [I] Removing 0001-0000-B0MBSQ.xml
2020-02-26 11:10:23.402 [I] Uploading file: C:\Sage 200 Branch Accounting\PMB_HO_Update_Folder\0001-0000-B0MBSQ.xml (1 KB)
2020-02-26 11:10:23.407 [I] Will restart partial upload if allowed by FTP server
2020-02-26 11:10:23.409 [E] Upload exception: Cannot open file "C:\Sage 200 Branch Accounting\PMB_HO_Update_Folder\0001-0000-B0MBSQ.xml". The system cannot find the file specified

I've monitored the Branch Accounting Folder when running the custom export but it doesn't seem to be even creating the .xml file and I'm not sure what to do from here any assistance will be greatly appreciated.

  • 0

    Hi Kavir

    Please log this query in the usual way with Sage Evolution Support so that a Branch Accounting specialist can attend to it and perhaps arrange a remote session to investigate it for you.

    Sorry, I really don't have quick fix for you at this stage.

    Kind Regards

    Bennie 

  • 0 in reply to Bennie Pienaar

    Thanks for the response Bennie, will do.

  • +1
    verified answer

    Just an Update for those that come here because they're experiencing the same problem.

    I had the pleasure of dealing with Thomas Chauke from support. With his expert knowledge on the product we were able to troubleshoot, identify and fix the following on call and via AnyDesk:

    1)  in the "Folder Options" for the branch accounting folder that you create, the "Hide extensions for known file types" option needs to be unchecked as shown here

    2) When I setup the FTP using FileZilla Server, I set the "Home Directory" for my FTP user to the Same location as my Head Offices sync monitor local root folder. This is incorrect.

    The correct way of setting this up is that the "Home Directory" should be a different folder, in my case, I created a "Sage Branch Accounting" folder on the C: drive and set this folder as the FTP "Home Directory".

    Within this folder, I created a folder call "HO_Update" and pointed my HO sync monitors local root folder to this folder and just like that, problem solved.

  • 0 in reply to KavirM

    Thanks so much for sharing your solution with us all, Kavir!

    It're really appreciated Smiley

*Community Hub is the new name for Sage City