Hi all

we have a replication between two ASA 9 database. But, the
last couple of weeks we are having the following issue:

02/26 09:26:36. SQL statement failed: (-121) Permission
denied: you do not have permission to execute the procedure
"xp_startsmtp"
02/26 09:26:36. Receiving messages failed

We are not using xp_startsmtp, so I am not sure we have this
error. The replication is now failing because this error.

I appreciate anyu help

Thanks

Ricci

Ricci wrote in news:49a602be.50f8.1681692777 (AT) sybase (DOT) com:

Can you please run dbremote with the -v switch and post the
output here when you see the error please?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

It sounds like you may have had someone attempt
to use SMTP email in combination with passthrough
mode. You can check for this yourself by translating
the 'source' transaction logs using the offsets identified
from the message being applied. For example, if your
error shows up with this applying message line

02/26 09:26:36. Applying message from "Jake" (0-0000012345-0000015697-0)

you could then go to Jake's transaction logs
and translate one of those with

dbtran -sr -ir 0000012345,0000015697 xxx.log

to see what was recorded.

<Ricci> wrote