The error was in the very first proc
change sql to this:
--**************************
-- PROJECT DASHBOARD
--**************************
IF EXISTS(SELECT name FROM sysobjects WHERE name='geminigetprojectsummarycomponents')
DROP PROCEDURE geminigetprojectsummarycomponents
GO
CREATE PROCEDURE geminigetprojectsummarycomponents
@projectid NUMERIC(10,0),
@userid INT,
@viewown BIT
AS
BEGIN
SELECT a.componentid,a.componentname,a.parentcomponentid,ISNULL(b.issuecount, 0) AS issuecount, a.componentdesc FROM geminicomponents a
LEFT OUTER JOIN
(SELECT componentid, COUNT(*) AS issuecount FROM geminiissuecomponents ic WHERE ic.issueid IN
(
SELECT issueid FROM geminiissues WHERE projectid=@projectid
AND issuestatusid NOT IN (SELECT statusid FROM geminiissuestatusfinal)
AND (@viewown = 0 OR (@viewown = 1 AND (geminiissues.reportedby = @userid or @userid in (select ir.userid from geminiissueresources ir where ir.issueid = geminiissues.issueid) ) ) )
AND ((geminiissues.visibilitymembertype=2 and @userid in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = geminiissues.visibility)) or (geminiissues.visibilitymembertype=3 and @userid in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = geminiissues.visibility)))
)
GROUP BY componentid
) b
ON a.componentid=b.componentid
WHERE a.projectid=@projectid
ORDER BY a.componentorder, a.componentname
END
GO
a.componentdesc was missing
