TN AppSvr203 Manually marking an object undeployed via the GR DB (MSSQL)

Description

This article from InSource shows how to trick the IDE into thinking an object is undeployed. Occasionally a deploy or undeploy operation may hang and the IDE may "lose its brain" not matching up with what is actually deployed. Please note that it is not officially supported to make modifications to the Galaxy Database SO USE THIS AT YOUR OWN RISK. This has been used on test systems where the IDE has been mismatched with the actual deploy state of an object. The query is basically just marking the table that the object is undeployed.

• Author: Lewis Talley
• Published: 8/5/2016
• Applies to: Application Server and SQL Server

Details

declare @objectID int
select @objectID = gobject_id from gobject where tag_name = '****INSERT YOUR OBJECTNAME HERE*****'
declare @temptable table(
[gobject_id] int
)
insert into @temptable
exec [dbo].[internal_get_all_hosted_gobjects] @objectID
insert into @temptable
select @objectID
update gobject set deployed_package_id = 0, last_deployed_package_id = 0
where gobject_id in (select gobject_id from @temptable)