error with xp_startsmtp - 02-25-2009 , 08:47 PM
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
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
Re: error with xp_startsmtp - 02-26-2009 , 08:57 AM
Ricci wrote in news:49a602be.50f8.1681692777 (AT) sybase (DOT) com:
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"
Re: error with xp_startsmtp - 02-26-2009 , 09:56 AM
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.