SS2005 SP1 + Cummlative Hotfixes - Snapshot Replication StartIndex Cannot Be Less Than Zero

Hi, has anyone got the following error message before? It seems like it occurred when the snapshot creation agent reached the UDF fn_getOwner():


StartIndex cannot be less than zero.
Parameter name: startIndex


Error messages:


Message: StartIndex cannot be less than zero.
Parameter name: startIndex
Command Text:
select 'number' = convert(int, 0), 'definition' = definition
from sys.sql_modules
where object_id = object_id(@qualified_object_name)
union all
select 'number' = convert(int, procedure_number), 'definition' = definition
from sys.numbered_procedures
where object_id = object_id(@qualified_object_name)
Parameters: @qualified_object_name = [dbo].[fn_getOwner]

Stack: at Microsoft.SqlServer.Replication.AgentCore.ExecuteWithOptionalResults(CommandSetupDelegate commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, Int32 queryTimeout, CommandBehavior commandBehavior)
at Microsoft.SqlServer.Replication.AgentCore.ExecuteWithOptionalResults(CommandSetupDelegate commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, CommandBehavior commandBehavior)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.TextModeOnObjectScripter.Script()
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GenerateNonTableArticleSchScript(Scripter scripter, BaseArticleWrapper articleWrapper, SqlSmoObject smoObject, Boolean quotedIdentifierOn, Boolean ansiNullsOn, Boolean textMode)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GenerateFunctionArticleScripts(ArticleScriptingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateArticleScripts(ArticleScriptingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GenerateObjectScripts(ArticleScriptingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.DoScripting()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.DoScripting()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: 52006)
Get help: http://help/52006

Source: mscorlib
Target Site: System.Text.StringBuilder Remove(Int32, Int32)
Message: StartIndex cannot be less than zero.
Parameter name: startIndex
Stack: at System.Text.StringBuilder.Remove(Int32 startIndex, Int32 length)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.TextModeOnObjectScripter.ProcessGetObjectScriptResult(SqlDataReader dataReader)
at Microsoft.SqlServer.Replication.AgentCore.ExecuteWithOptionalResults(CommandSetupDelegate commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, Int32 queryTimeout, CommandBehavior commandBehavior) (Source: mscorlib, Error number: 0)
Get help: http://help/0



Here's the function:


set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

/* various comments here. */

ALTER

FUNCTION [dbo].[fn_getOwner] (@moduleID integer, @FY char(4))

RETURNS varchar(5)

AS

BEGIN

declare @tin char(9),

@owner varchar(5),

@ownerCount integer

-- Get owner via ModuleID

select @owner = owner

from tblControlPage

where moduleid = @moduleID and AuditFY = @FY;

-- Get owner via ATIN (This is when the moduleId is not on control page or no owner.

-- Check to see if the ATIN is on control page and use ATIN's Owner)

if @owner is null

begin

-- get module's TIN.

select @tin = tin from tblModule where moduleid = @moduleID

-- count the number of owners by ATIN those owner is not null via entity association.

select @ownerCount = count(*) from

(

select owner from vwControlPage c inner join vwEntityAssociation e

on c.tin = e.atin and e.tin = @tin

and auditfystart <= @FY and @FY < auditfyend

where owner is not null

group by owner

) owners



if @ownerCount = 1

begin

-- good, there's only one owner, get the ATIN owner.

select top 1 @owner = owner from vwControlPage c inner join vwEntityAssociation e

on c.tin = e.atin and e.tin = @tin

and auditfystart <= @FY and @FY < auditfyend

where owner is not null

group by owner

end

-- else there are multiple owners, set owner value to 'Multi'

if @ownerCount > 1

begin

set @owner = 'Multi'

end

end



-- Get owner via TIN if @owner is still null

if @owner is null --or len(@owner) = 0

begin

-- get TIN of module (Commented out the following because it was retrieved on prior "if" condition)

-- select @tin = tin from tblModule where moduleid = @moduleID

-- count number of owners by that TIN those not null.

select @ownerCount = count(*) from

(

select owner from vwControlPage

where tin = @tin and auditFY = @FY and owner is not null

group by owner

) owners

if @ownerCount = 1

begin

-- good, there's only one owner.

select top 1 @owner = owner from vwControlPage

where tin = @tin and auditFY = @FY and owner is not null

group by owner

end

-- else there are multiple owners, set owner value to 'Multi'

if @ownerCount > 1

begin

set @owner = 'Multi'

end

end

return @owner

end