Home Dashboard Directory Help
Search

sql server job Expired subscription clean up Error 557 fails job after many successful runs by Porter Horne


Status: 

Closed
 as External Help for as External


1
0
Sign in
to vote
Type: Bug
ID: 772393
Opened: 11/27/2012 10:36:17 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

I have a SQL Server 2005 SP3 job “Expired subscription clean up” that recently started receiving Error 557, which fails the job. The timing appears to be when I created a pull subscription to a SQL Server 2008 R2 SP2 publication. I have googled the error with no success.

What do I need to do to stop the errors?

(the server runs Windows Server 2003 SP2 with no virtualization)
Details
Sign in to post a comment.
Posted by Microsoft on 11/30/2012 at 8:54 AM
Hi Porter Horne,

given my previous message, I'm archiving this work item for now.

Best regards
Jean-Yves Devant 
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
Program Manager SQL Server Replication, Change Data Capture, Change Tracking
Posted by Microsoft on 11/30/2012 at 8:50 AM
Hi Porter Horne,
    
thanks for taking the time to share your feedback, this is really important to us. I checked, we do not have any known issue at this point that would raise the error 557 (Only functions and some extended stored procedures can be executed from within a function.). The way you can troubleshoot this further for starting is by running the proc manually (eg outside of the context of the job) and take a profiler trace to identify the statement which leads to this error.

Then I recommend you work with our support engineers to move forward on this issue. Indeed MS Connect is not meant to be used as a support offering. It is meant to collect feedback on defects and feedback on existing features or wish of feature. If our support staff determine there is a defect behind the behavior you are describing they have means to engage with on how we could move forward on this defect if there is one.
You may already have a local support representative. If not you'll find more information on http://www.microsoft.com/microsoftservices/en/us/support.aspx.
Best regards
Jean-Yves Devant 
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server

Program Manager SQL Server Replication, Change Data Capture, Change Tracking
Posted by Microsoft on 11/30/2012 at 8:43 AM
            Hi Porter Horne,
                    
            thanks for taking the time to share your feedback, this is really important to us.
            We will investigate the issue and get back to you.
            
            Best regards
            Jean-Yves Devant 
            Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
            Program Manager SQL Server Replication, Change Data Capture, Change Tracking
Sign in to post a workaround.