SQL Anywhere database replication - SQLRemote - Server rejected target file name error.

Author

SQLRemote - Server rejected target file name error.

James Clanton

2005-08-05, 3:23 am

I'm relatively new to using SQLRemote and am trying to figure out this
problem.

We are getting errors using SQLRemote to synchronize a database to a remote
location. These databases are synchronized every 3 hours. We are getting
errors on the synchronization as shown below. These series of errors occurs
multiple times in a single session.

The replication process was taking about 20 seconds to complete. Now, it's
taking 15 minutes or more. The volume of data changed on a data basis
hasn't really changed. It appears to me that the problem is from the old
log file created with the -x parameter, thought that's just a guess.

Any help would be appreciated.

James Clanton
PropertyBoss Solutions
-------------------------------------------------
.. SQL Remote Message Agent Version 8.0.3.5191

I. 08/04 22:15:26. Applying message from "website_remote_user"
(0-0002640954-0002640954-0)
I. 08/04 22:15:26. Scanning logs starting at offset 0023232546
I. 08/04 22:15:26. Processing transaction logs from directory
" C:\PROGRA~1\PROPER~1
\PropertyBoss_Produc
tion\"
I. 08/04 22:15:34. Transaction log
" C:\PROGRA~1\PROPER~1
\PropertyBoss_Produc
tion\050802AH.LOG" starts at offset
0023200713
I. 08/04 22:15:34. Processing transactions from transaction log
" C:\PROGRA~1\PROPER~1
\PropertyBoss_Produc
tion\050802AH.LOG"
I. 08/04 22:15:35. Sending message to "website_remote_user"
(9-0023232546-0023232546-0)
I. 08/04 22:18:06. Server rejected target file name.
I. 08/04 22:18:07. Rename failed!
I. 08/04 22:18:07. Server denied permission to DELE file.
I. 08/04 22:18:07. Sending message to "website_remote_user"
(9-0023232546-0023232546-1)
I. 08/04 22:18:08. Sending message to "website_remote_user"
(9-0023232546-0023232546-2)
I. 08/04 22:18:09. Sending message to "website_remote_user"
(9-0023232546-0023232546-3)
I. 08/04 22:18:10. Sending message to "website_remote_user"
(9-0023232546-0023232546-4)
I. 08/04 22:18:10. Sending message to "website_remote_user"
(9-0023232546-0023232546-5)
I. 08/04 22:18:13. Sending message to "website_remote_user"
(9-0023232546-0023309624-6)
I. 08/04 22:18:16. Sending message to "website_remote_user"
(9-0023309624-0023338515-0)

Reg Domaratzki $iAnywhere Solutions$

2005-08-05, 9:24 am

This looks to be a problem on the FTP server. Can you run the following
command and then post the dbremote output again? It will provide much more
information on what is going on with the file transfer on the FTP site.

SET REMOTE ftp OPTION "public".Debug='Yes';

Note : The userid and password you use for the FTP server will be in plain
text in the output file. You might want to X-out the values before posting
to a public forum.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"James Clanton" < jclanton@propertybos
s.com> wrote in message
news:42f2d107$1@foru
ms-1-dub...
> I'm relatively new to using SQLRemote and am trying to figure out this
> problem.
>
> We are getting errors using SQLRemote to synchronize a database to a
remote
> location. These databases are synchronized every 3 hours. We are getting
> errors on the synchronization as shown below. These series of errors
occurs
> multiple times in a single session.
>
> The replication process was taking about 20 seconds to complete. Now,
it's
> taking 15 minutes or more. The volume of data changed on a data basis
> hasn't really changed. It appears to me that the problem is from the old
> log file created with the -x parameter, thought that's just a guess.
>
> Any help would be appreciated.
>
> James Clanton
> PropertyBoss Solutions
> -------------------------------------------------
> . SQL Remote Message Agent Version 8.0.3.5191
>
> I. 08/04 22:15:26. Applying message from "website_remote_user"
> (0-0002640954-0002640954-0)
> I. 08/04 22:15:26. Scanning logs starting at offset 0023232546
> I. 08/04 22:15:26. Processing transaction logs from directory
> " C:\PROGRA~1\PROPER~1
\PropertyBoss_Produc
tion\"
> I. 08/04 22:15:34. Transaction log
> " C:\PROGRA~1\PROPER~1
\PropertyBoss_Produc
tion\050802AH.LOG" starts at
offset
> 0023200713
> I. 08/04 22:15:34. Processing transactions from transaction log
> " C:\PROGRA~1\PROPER~1
\PropertyBoss_Produc
tion\050802AH.LOG"
> I. 08/04 22:15:35. Sending message to "website_remote_user"
> (9-0023232546-0023232546-0)
> I. 08/04 22:18:06. Server rejected target file name.
> I. 08/04 22:18:07. Rename failed!
> I. 08/04 22:18:07. Server denied permission to DELE file.
> I. 08/04 22:18:07. Sending message to "website_remote_user"
> (9-0023232546-0023232546-1)
> I. 08/04 22:18:08. Sending message to "website_remote_user"
> (9-0023232546-0023232546-2)
> I. 08/04 22:18:09. Sending message to "website_remote_user"
> (9-0023232546-0023232546-3)
> I. 08/04 22:18:10. Sending message to "website_remote_user"
> (9-0023232546-0023232546-4)
> I. 08/04 22:18:10. Sending message to "website_remote_user"
> (9-0023232546-0023232546-5)
> I. 08/04 22:18:13. Sending message to "website_remote_user"
> (9-0023232546-0023309624-6)
> I. 08/04 22:18:16. Sending message to "website_remote_user"
> (9-0023309624-0023338515-0)
>
>

Sponsored Links