Hi,
I got error while installing Tagger Module. Below shows the error part, all else went fine.
Info Executing 01.03.00.SqlDataProvider
StartJob Start Sql execution: 01.03.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near '1'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[ifty_SetTags]') AND type in (N'P', N'PC')) BEGIN EXEC sp_executesql @statement = N'ALTER Procedure dbo.[ifty_SetTags] ( @Tags nvarchar(2000) ,@TagDelim char(1) ,@PortalId int ,@TabModuleId int ,@Header nvarchar(300) ,@Line1 nvarchar(300) ,@Line2 nvarchar(300) ,@replacePrevious bit ,@UrlKeyValuePairs nvarchar(550) ,@KeyValueDelim char(1) ,@PairsDelim char(1) ,@overwriteHeader bit ,@overwriteLines bit ) AS BEGIN /* ============================================= Author: WOMBAT\Bruce Create date: 01/06/2007 Description: Creates a set of tags for a Tab/Module instance of a Tag module ============================================= Return Values -2 - No record(s) returned. Procedure Executed Ok. -1 - No records modified. Commit Occured 0 - Successful Execution. 1 - SQL Error. Rollback Occurred. 2 - No records modified. Rollback Occurred. 3 - Error in sub procedure - entire top procedure rolled back. 4 - Specific to procedure Modified by: Date: Reason for Modification: brc 1/3/08 Tempdb collation default =============================================*/ SET NOCOUNT ON DECLARE @ErrStr varchar(100) /* Return error string */ DECLARE @Error int /* Return error value */ DECLARE @Rowcount int /* Return related row count */ DECLARE @TranCount int /* Keeps a record of the transaction count */ DECLARE @CurTime dateTime SELECT @CurTime = GetDate() DECLARE @InstanceId int Create Table #UsedTagIds (UsedTagId int,Tag nvarchar(50), SeqNum int, IsNew bit) SELECT @TranCount = @@TRANCOUNT IF @TranCount = 0 BEGIN TRANSACTION T1 /* find if this instance of a tab module has been saved in the tags links before */ SELECT @InstanceID = ml.InstanceId FROM ifty_TagInstanceLink ml INNER JOIN ifty_fnInstanceIdsFromKeyValues (@UrlKeyValuePairs ,@KeyValueDelim ,@PairsDelim,0) ON InstanceId = FoundInstanceID AND PortalID = @PortalID AND TabModuleID = @TabModuleId SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=1, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END if (@RowCount = 0) /* there was no instance of this key/value set being saved for this tab/module combo before */ BEGIN /* not found to update, so create a new one */ INSERT INTO ifty_TagInstanceLink (PortalId, TabModuleId, Header, Line1, Line2) VALUES (@PortalId,@TabModuleId, @Header, @Line1, @Line2) SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=2, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END SET @InstanceId = @@Identity --get new instance id for this key/value tab/module set END ELSE BEGIN IF (@overwriteHeader = 1 or @overwritelines = 1) BEGIN select Header = case when Header <> @Header and @overwriteHeader =1 then @Header else Header end ,Line1 = case when Line1 <> @Line1 and @overwriteLines =1 then @line1 else Line1 end ,Line2 = case when Line2 <> @Line2 and @overwriteLines =1 then @line2 else Line2 end ,@overwriteLines, @overwriteHeader from ifty_TagInstanceLink WHERE InstanceId = @InstanceId AND PortalId = @PortalId AND TabModuleId = @TabModuleId /* update the tab module link so that the header lines are up to date - but only if requested to */ UPDATE ifty_TagInstanceLink SET Header = case when Header <> @Header and @overwriteHeader =1 then @Header else Header end ,Line1 = case when Line1 <> @Line1 and @overwriteLines =1 then @line1 else Line1 end ,Line2 = case when Line2 <> @Line2 and @overwriteLines =1 then @line2 else Line2 end WHERE InstanceId = @InstanceId AND PortalId = @PortalId AND TabModuleId = @TabModuleId SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=3, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END END END /* get the list of tags and their id''s */ INSERT INTO #UsedTagIDs (UsedTagId, Tag, IsNew, SeqNum) SELECT COALESCE(min(TagId), 0), Tag, IsNew, min(SeqNum) FROM ifty_fnParseTags (@tags,@tagDelim,@portalId) pt LEFT JOIN ifty_Tag t on t.TagText = pt.Tag and t.PortalId = @portalId GROUP BY Tag, IsNew SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=4, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* ok insert the new ones one by one so we can get the identitys */ INSERT INTO ifty_Tag (PortalId, TagText, FirstTagDate, LastTagDate, NumberTags) SELECT @portalId, Tag , @CurTime, @CurTime, 1 FROM #UsedTagIDs WHERE IsNew = 1 ORDER BY SeqNum DESC SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=5, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* now we have to go back and update those new id''s */ UPDATE #UsedTagIds SET UsedTagId = TagId FROM ifty_Tag t WHERE TagId >= (@@Identity - (select count(*) from #UsedTagIds)) AND Tag collate database_Default = t.TagText collate database_Default SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=6, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* update the tag count and last usage, as long as this isn''t a new tag and it''s not already associated with this instance */ UPDATE ifty_Tag Set NumberTags = NumberTags 1 ,LastTagDate = @CurTime FROM #UsedTagIds ut WHERE UsedTagID = TagId AND IsNew = 0 AND NOT EXISTS (SELECT TagId FROM ifty_TagInstance ti WHERE ti.TagId = ut.UsedTagId AND InstanceID = @InstanceID AND PortalID = @PortalId) SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=7, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END SELECT UsedTagId, Tag, @InstanceId, @PortalId FROM #UsedTagIds ut WHERE NOT EXISTS (SELECT TagId FROM ifty_TagInstance ti WHERE ti.TagId = ut.UsedTagId AND InstanceID = @InstanceID AND PortalID = @PortalId) /* Ok now we are going to associate those tags with the module / tab id combo except where an association already exists */ INSERT INTO ifty_TagInstance (TagId, InstanceId, PortalId) SELECT UsedTagId, @InstanceId, @PortalId FROM #UsedTagIds ut WHERE NOT EXISTS (SELECT TagId FROM ifty_TagInstance ti WHERE ti.TagId = ut.UsedTagId AND InstanceID = @InstanceID AND PortalID = @PortalId) SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=8, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* if we are replacing all the old ones, get rid of any ones that weren''t in the supplied set */ if (@replacePrevious = 1) BEGIN /* delete the tag/tab links */ DELETE FROM ifty_TagInstance WHERE TagId not in (SELECT UsedTagId from #UsedTagIds) AND InstanceID = @InstanceID AND PortalId = @PortalId SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=9, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* update those not in the tag list to be one less than currently */ UPDATE ifty_Tag SET NumberTags = NumberTags - 1 WHERE TagId not in (SELECT UsedTagId from #UsedTagIds) AND NumberTags > 1 SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=10, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* delete any no-longer used tags*/ DELETE FROM ifty_Tag WHERE TagId not in (SELECT UsedTagId from #UsedTagIds) AND NumberTags = 0 AND not exists (SELECT TagId from ifty_TagInstance ttm where ttm.TagId = ifty_Tag.TagId) SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=11, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END END /* ok the tags have been updated and linked to the tab/module */ /* delete the old query string key/value pairs for the link */ DELETE FROM ifty_TagInstanceLinkKey WHERE InstanceId = @InstanceId SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=12, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* insert the query string values into the LinkKey table */ DECLARE @seqNum int INSERT INTO ifty_TagInstanceLinkKey (InstanceId, PortalId, SeqNum, UrlKey, UrlValue) SELECT @InstanceId,@PortalId, PairNumber, KeyChar, ValueChar FROM dbo.ifty_fnParseKeyValues(@urlKeyValuePairs, @KeyValueDelim, @PairsDelim) SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=13, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* finished procedure, commit and return */ IF @TranCount = 0 COMMIT TRANSACTION T1 IF @RowCount = 0 RETURN -1 /*** Procedure did nothing. Records committed */ ELSE RETURN 0 /*** Procedure executed ok. Records committed */ END ' END
EndJob End Sql execution: 01.03.00.SqlDataProvider file
Info Executing 01.04.00.SqlDataProvider
StartJob Start Sql execution: 01.04.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[ifty_ResetTagCounts]') AND type in (N'P', N'PC')) BEGIN EXEC sp_executesql @statement = N' CREATE Procedure dbo.[ifty_ResetTagCounts] AS BEGIN /* ============================================= Author: WOMBAT\Bruce Create date: 01/06/2007 Description: Recalculates the number of tag instances per tag. ============================================= Return Values -2 - No record(s) returned. Procedure Executed Ok. -1 - No records modified. Commit Occured 0 - Successful Execution. 1 - SQL Error. Rollback Occurred. 2 - No records modified. Rollback Occurred. 3 - Error in sub procedure - entire top procedure rolled back. 4 - Specific to procedure Modified by: Date: Reason for Modification: =============================================*/ SET NOCOUNT ON DECLARE @ErrStr varchar(100) /* Return error string */ DECLARE @Error int /* Return error value */ DECLARE @Rowcount int /* Return related row count */ DECLARE @TranCount int /* Keeps a record of the transaction count */ DECLARE @CurTime dateTime SELECT @CurTime = GetDate() DECLARE @InstanceId int Create Table #UsedTagIds (UsedTagId int, tag nvarchar(50), SeqNum int) SELECT @TranCount = @@TRANCOUNT IF @TranCount = 0 BEGIN TRANSACTION T1 declare @tagId int, @instanceCount int declare Tag_Count_Curs cursor for select TagId, count(Distinct instanceId) from ifty_TagInstance group by TagId SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=1, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END open Tag_Count_Curs fetch from Tag_Count_Curs into @TagId, @instanceCount while @@fetch_Status = 0 begin update ifty_Tag set NumberTags = @instanceCount where TagId = @TagId and @instanceCount <> NumberTags SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=2, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END fetch from Tag_Count_Curs into @TagId, @instanceCount end close tag_Count_Curs deallocate tag_Count_Curs SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=3, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* finished procedure, commit and return */ IF @TranCount = 0 COMMIT TRANSACTION T1 IF @RowCount = 0 RETURN -1 /*** Procedure did nothing. Records committed */ ELSE RETURN 0 /*** Procedure executed ok. Records committed */ END ' END System.Data.SqlClient.SqlException: Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. Incorrect syntax near 'OBJECT_NAME'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[ifty_ClearTagsForTabModule]') AND type in (N'P', N'PC')) BEGIN EXEC sp_executesql @statement = N' create Procedure dbo.[ifty_ClearTagsForTabModule] ( @PortalId int ,@TabModuleId int ) AS BEGIN /* ============================================= Author: WOMBAT\Bruce Create date: 23/05/08 Description: Deletes all tags and tag instances for the specified tab module ============================================= Return Values -2 - No record(s) returned. Procedure Executed Ok. -1 - No records modified. Commit Occured 0 - Successful Execution. 1 - SQL Error. Rollback Occurred. 2 - No records modified. Rollback Occurred. 3 - Error in sub procedure - entire top procedure rolled back. 4 - Specific to procedure Modified by: Date: Reason for Modification: =============================================*/ SET NOCOUNT ON DECLARE @ErrStr varchar(100) /* Return error string */ DECLARE @Error int /* Return error value */ DECLARE @Rowcount int /* Return related row count */ DECLARE @TranCount int /* Keeps a record of the transaction count */ DECLARE @CurTime dateTime SELECT @CurTime = GetDate() DECLARE @tag nvarchar(50), @tagId int, @isNew bit, @InstanceId int Create Table #UsedTagIds (UsedTagId int) SELECT @TranCount = @@TRANCOUNT IF @TranCount = 0 BEGIN TRANSACTION T1 /* first reset the tag counts back for any deleted modules */ exec [ifty_ResetTagCounts] declare TabModule_Instance_Curs cursor for select InstanceId from ifty_TagInstanceLink where tabModuleId = @tabModuleId and portalId = @portalId open TabModule_Instance_Curs fetch from TabModule_Instance_Curs into @instanceID while @@Fetch_STatus = 0 BEGIN Truncate Table #usedTagIds /* collect all the tags that are used for this module/tab keyvalue instance */ INSERT INTO #UsedTagIds (UsedTagId) SELECT DISTINCT m.TagId FROM ifty_TagInstanceLink ml inner join ifty_TagInstance m on m.InstanceId = ml.InstanceId WHERE ml.InstanceID = @InstanceId AND ml.POrtalId = @portalId and ml.TabModuleID = @TabMOduleID SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=1, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* update the tag count and last usage */ UPDATE ifty_Tag Set NumberTags = NumberTags - 1 FROM #UsedTagIds WHERE UsedTagID = TagId SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=2, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* delete the tag/tab links */ DELETE FROM ifty_TagInstance WHERE InstanceID = @InstanceID And PortalId = @portalId SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=3, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* update those in the tag list to be one less than currently */ UPDATE ifty_Tag SET NumberTags = NumberTags - 1 WHERE TagId in (SELECT UsedTagId from #UsedTagIds) AND NumberTags > 0 SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=4, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* if we are down to zero uses of that tag, can it */ DELETE FROM ifty_Tag WHERE TagId in (SELECT UsedTagId from #UsedTagIds) AND NOT EXISTS (Select TagId from ifty_TagInstance ti where ifty_Tag.TagId = ti.TagId) SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=5, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* delete the old query string key/value pairs for the link */ DELETE FROM ifty_TagInstanceLinkKey WHERE InstanceId = @InstanceId AND PortalID = @portalId SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=6, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END /* delete the link values */ DELETE FROM ifty_TagInstanceLink WHERE InstanceId = @InstanceId AND PortalID = @PortalID AND TabModuleID = @TabMOduleID SELECT @Error = @@ERROR, @RowCount = @@RowCount IF @Error <> 0 BEGIN IF @TranCount = 0 ROLLBACK TRANSACTION T1 SELECT @ErrStr=''Error in '' OBJECT_NAME(@@PROCID) ''. Stmt No.=7, Db=''_name()'',Err=''??(varchar(10),@Error) RAISERROR(@ErrStr,16,1) RETURN 1 /* statement failed */ END fetch from TabModule_Instance_Curs into @instanceID END close TabModule_Instance_Curs deallocate TabModule_Instance_Curs /* recalc tag counts in case it got out again */ exec [ifty_ResetTagCounts] /* finished procedure, commit and return */ IF @TranCount = 0 COMMIT TRANSACTION T1 IF @RowCount = 0 RETURN -1 /*** Procedure did nothing. Records committed */ ELSE RETURN 0 /*** Procedure executed ok. Records committed */ END ' END
EndJob End Sql execution: 01.04.00.SqlDataProvider file
EndJob Finished Sql execution
Please help me out..
Regards
Sudheep