Custom BIRT Reports in SSC 4.4 Upgrade
For those of you with custom reports in SSC.
My SSC 4.1 custom reports failed in SSC 4.4. The reason is simple, the new case sensitive collation. Two examples:
SELECT COUNT(div.issueinstanceid) must become SELECT COUNT(div.issueInstanceId)
LEFT OUTER JOIN defaultissueview div ON div.projectversion_id=app.id must become LEFT OUTER JOIN defaultissueview div ON div.projectVersion_id=app.id
A quick check of your Data Sets will save you a little grief.