Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009
Accepted Solution

Only one remote user's files being sent to FTP server

Hi,

 

We're on 7.5.4 LAN.  We have about 35 remote users currently.  Everything seemed to be humming along just fine until I noticed that about 5 days ago,  the TEF's, although are being created just fine, are not moving from Logs  --> OUTFILES folder on Sync server to the FTP OUTFILES directory...... except for one user. His files are still moving as they should.  What could have gotten out of whack here?

Thanks

Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009

Re: Only one remote user's files being sent to FTP server

Can I just move the existing files to the FTP server's OUTFILES until I figure out the cause?

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Only one remote user's files being sent to FTP server

Tempting... BUT you need to be sure  there's no issues w/the Archives folder and the "meta-data" that tracks the tefs.....

 

A - Are these ALL on one synch transfer profile?

B - Did you enable the new "debugging feature for FTP synch?

 

from my KB:

By default, since version 5.x Sync has always been hard coded to use an Active FTP connection. Recent issues with FTP running outside the network in a cloud have required us to support Passive connections as well.
Therefore, there is a registry flag for enabling this:
32-bit
HKEY_LOCAL_MACHINE\SOFTWARE\SalesLogix\Synchronization

64-bit
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SalesLogix\Synchronization

Create a new string value named: ActiveFTP
Its value can be any of the following: Empty String, 'T','Y','TRUE','YES' to enable Active Ftp connections.
To disable once added, either delete the entry from the registry or change value to something other then the above values. I.E. 'F'.

-----More info
updated version of the registry setting(s) for FTP Active/Passive sync. This is in the 7.5.3 Administrator Help file. For possible future reference, I used 'passive' as my search critieria.

Configuring FTP Sync to Run in Active or Passive Mode
You can configure FTP synchronization to use Passive or Active FTP connections. By default, IIS uses Passive mode.

To configure

Run Regedit.

Navigate to the following location:

32-bit - HKEY_LOCAL_MACHINE\SOFTWARE\SalesLogix\Synchronization

64-bit - HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SalesLogix\Synchronization

Right-click, point to New, and then click String Value.

Modify the new value to be True or False, 1 or 0, or Yes or No, Y or N.

If the value is True, 1, Yes, or Y then Active FTP is enabled.

If the value if False, 0, No, or N then Passive FTP is enabled.

--
DebugFTP
Same rules as ActiveFTP

NOTE:
These settings applies to the following and do NOT have to match. You choose Active/Passive based on the (local) system's requirements/needs:
A - ALL synch servers
B - All Remote User Systems
C - All Remote Office Servers

 

 

NOTE: If there is NO ActiveFTP entry in the registry.. it is forced to PASSIVE.... I suggest you put it in and "enable" Active..

 

 

 

 

 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009

Re: Only one remote user's files being sent to FTP server

Thanks for the reply RJ.

 

What was actually happening was that the service would run, and try to move the files to the FTP server where the users could download them, but when it tried, it would find that some of the files that it was moving already existed on the FTP server.  Because of the skill and care put into the development of the sync service, instead of generating errors, shutting down, or doing anything really, the service just kind of said, “Oh…Okay then. Guess I’ll just ignore doing this bit” and would move on and finish its other tasks and report “success!!”.

 

The root problem seems to have been in the generation of the sync files rather than just the moving of the files.  Although it failed to handle duplicate files eloquently, the problem was that the sync service actually created the same files with the same file names for several users during two consecutive sync cycles. The two matching files were exactly the same size, but had two different time stamps, 30 minutes apart.  This shouldn’t happen.

 

The user whose files were still moving happened to be the first user that was processed in the sync process and there were no duplicate files created for him, so the process would always send his files to the FTP server correctly. The second user processed had duplicate files, so his files were not sent, and the sync process exited at that point. 

 

Working with Sage Support, I manually moved the first users' TEFs to the FTP server, and the process was run again, but again it failed because the next user in the list also had duplicate files. We then moved all the users’ files to the FTP server manually, overwriting any duplicates.  At that point, everything started working as it should.

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Only one remote user's files being sent to FTP server

You are welcome...

 

This sure sounds like a major (ftp) synch bug. I hope there's a hot fix in the works for it.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009

Re: Only one remote user's files being sent to FTP server

I hope so too!  Maybe it is a nuance of MS Server 2008 R2 that wasn't caught in the certification testing... We've seen some interesting things with R2.

Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009

Re: Only one remote user's files being sent to FTP server

DEFECT: Synchronization Server stops transferring files and fails to return an error when a file to be copied already exists in the FTP Outfiles folder
  
This is currently an open Defect that is under review.

Defect ID: 11082430

SalesLogix Version: 7.5.4   |   Build Number: 4078

Issue Applies To: LAN

Issue:
DEFECT: Synchronization Server stops transferring files and fails to return an error when a file to be copied already exists in the FTP Outfiles folder

Steps to Duplicate:
Create a SalesLogix environment with functioning FTP synchronization.
In the SalesLogix Client, make a change that generates a TEF for at least one remote user.
While cycling the Synchronization Server, interrupt the process so the file copied to the FTP Outfiles folder is renamed to the standard FILENAME.SITE format (example: ZIP-BTDK-A100014.CYE1), but before the file is deleted from the host Outfiles folder.
Note: In testing this was done by editing the permissions on the host Outfiles folder to specifically deny delete permissions for the domain user running the Synchronization Service. The issue is also produced by allowing synchronization to complete normally, then copying (not moving) one of the files from the FTP Outfiles back to the host Outfiles.
Repeat step 2.
Cycle the Synchronization Server again.

Note that a new file named FILENAME.tmp (example: ZIP-BTDK-A100014.tmp) was created in the FTP Outfiles directory and the FILENAME.SITE file still exists in the host Outfiles directory, with the TEF representing the change in step 4 failing to transfer because the process could not complete for the original TEF. Also note that no errors appear in the Synchronization Server log or the syncerrors.txt.

Expected Behavior:
At minimum SalesLogix returns an error message indicating it was unable to complete the transfer of files to the FTP site. A more elegant solution is to recognize that a file by that name already exists on the FTP site and then continue transferring the other files in the host Outfiles folder.

Cause:
When the Synchronization Server transfers the files to the FTP Outfiles it initially creates a file with the same name as the TEF being copied, but with an extension of .tmp. It then renames the file to the same filename, but with a file extension of the user's site code. However, if for some reason a file already with that name exists on the FTP Outfiles directory, the rename fails; since the Synchronization Server does not delete the file from the host Outfiles until it receives notification that the rename was successful, the file remains stuck in the host Outfiles until the rename can complete - and since files are transferred in sequence, no newer files are transferred until that time either.

This problem should normally be self-correcting over a short period of time, since once the remote user to whom the duplicated file belongs synchronizes the file will be removed from the FTP Outifles, allowing the .tmp file to be renamed and synchronization to continue.


Solution or Workaround:
Deleting the duplicated file from the host Outfiles, or deleting the renamed file (FILENAME.SITE) from the FTP site will allow the synchronization process to rename the .tmp file and the synchronization will continue normally.

Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009

Re: Only one remote user's files being sent to FTP server

Sage released a fix for this bug.  We're testing it  now. I was getting tired of manually montioring the sync folders every day. This was happening to us 5 or 6 times a month....

 

File: SLX754_U12.zip

 

 

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Only one remote user's files being sent to FTP server

Definitely a PAIN!

Glad to see you are testing a fix....

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html