Release Assembly - TC Cockpit JIRA Report Update

Project Overview

Currently we have a Jira issue report in Cockpit and we need to add the project level bugs.

Requirements

Current we have a Jira issue report which can be view here: http://www.topcoder.com/direct/dashboardJiraIssuesReport

However this report doesn't contain project level bugs, so we need to add them to the report. The tasks of this contest consists of 2 parts.

1. Update Loader

Jira data is stored in MySQL, you can find table details here: https://coder.topcoder.com/internal/database/scripts/trunk/mysql/bugs_oltp

Currrently we have a loader to load from MySql to our data warehouse db (where the Jira report is pulling from), and this loader needs to be udpated to load project level bugs too. You can find the source code of the loader here:

https://coder.topcoder.com/internal/web_module/trunk/src/main/com/topcoder/utilities/dwload/JiraDataLoadUtility.java

Custom field id for project id is 10190 and you should use NUMBERVALUE column type.

2. Update Jira report

You'll also need to update the data warehouse db to add a new column for project id. You also need to update the queries and frontend pages so the Jira report can correctly show the project level bugs.

SVN

Please email support@topcoder.com to request access to direct trunk, please include the contest title/link and your user name in the email.

Direct Trunk: https://coder.topcoder.com/tcs/clients/cronos/applications/direct/trunk/
DB Trunk: https://coder.topcoder.com/internal/database/scripts/trunk

Revision

Please make sure you work with the latest revision on SVN.

VM

VM specific information is found here: http://www.topcoder.com/wiki/display/docs/VM+Image+2.5.

Upon registration as a submitter or reviewer you will need to request a VM based on the new TopCoder Cockpit/Direct image. To request your image, please use the forum.

Before requesting your VM, you need to ensure that you have an SSH key created and in your member profile. Instructions to do so are here: http://www.topcoder.com/wiki/display/projects/Generate+SSH+Key, and instructions to connect afterwards are here: http://www.topcoder.com/wiki/display/projects/Connect+Using+SSH+Key.

There is a TC Site Resource page that contains documentation / instructions for the VM instance you will be issued upon request. It is located here: http://www.topcoder.com/wiki/display/projects/Cockpit%2CDirect+VM

Technology Overview

• Java 1.5
• JSP
• Struts 2
• Redhat Linux
• JBoss 4.0.2
• Informix 10.0

Final Submission Guidelines

Submission Deliverables

• Source code which are necessary to meet all the requirements stated above, including java class, jsp files, sql files etc.
• The competitor should provide a deployment document. This document should include a step-by-step guide on the deployment.
• The test data (as sql script) needed to test the fixes.

Final Submission

For each member, the final submission should be uploaded to the Online Review Tool.