Messages posted by: colin froggatt

Hi, I had a bizare problem recently and thought I would share it with everyone.

I was in the middle of a planning game and tried to create a new context (stories sorted by Assignee). When I hit save, the spinner appeared and stayed there. I reloaded the page and then pretty much everything I did generated exceptions all over the GH pages. Needless to say I couldn't use GH for the rest of the planning game.

After some investigation we found that it was only my account that was affected and after looking in the catalina.out log, found the offending exception (full exception at end).
Code:

 [id,11105] (SQL Exception while executing the following:UPDATE propertytext SET propertyvalue=? WHERE ID=? (Data truncation: Data too long for column 'propertyvalue' at row 1))

The 'propertytext' table has the 'propertyvalue' column of type TEXT (MySQL 5). The text that it failed to store was 134744 chars.

Given that it couldn't store the value, but after quite a lot of other investigation, we tried deleting some context's and that seems to have fixed it. The remaining question though, is if there's a limit on the number of Contexts that you can create? I had about 10 defined, which I didn't think was really very many.

As a slight aside, we had also tried to delete my Jira user as we thought there might be corrupt state after failing to create so many contexts. We delete the user using the Jira admin options, then recreated the user with the same name, etc. However, when we logged in to GH with the new user, all the old contexts were still there! So when we deleted the Jira user, GH didn't delete its associated state.

We are using GH 3.6 on Jira 3.12.2 professional on a Linux server.

Code:

 [id,11105] (SQL Exception while executing the following:UPDATE propertytext SET propertyvalue=? WHERE ID=? (Data truncation: Data too long for column 'propertyvalue' at row 1))
 	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:185)
 	at com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:570)
 	at com.opensymphony.module.propertyset.AbstractPropertySet.setText(AbstractPropertySet.java:380)
 	at com.atlassian.jira.propertyset.JiraCachingPropertySet.setText(JiraCachingPropertySet.java:337)
 	at com.pyxis.greenhopper.jira.configurations.UserBoardsPreferences.save(UserBoardsPreferences.java:660)
 	at com.pyxis.greenhopper.jira.actions.BoardAction.getSelectedBoardId(BoardAction.java:1059)
 	at com.pyxis.greenhopper.jira.actions.BoardAction.getSelectedBoard(BoardAction.java:336)
 	at com.pyxis.greenhopper.jira.actions.TaskBoardAction.doSuccess(TaskBoardAction.java:78)
 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 	at java.lang.reflect.Method.invoke(Method.java:585)
 	at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61)
 	at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52)
 	at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417)
 	at webwork.action.ActionSupport.execute(ActionSupport.java:146)
 	at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54)
 	at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
 	at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:211)
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 	at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73)
 	...
 	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 	at java.lang.Thread.run(Thread.java:595)

Hi Christian, I asked a similar question a few months ago so checkout the thread here: http://www.greenpeppersoftware.com/site/posts/list/546.page

cheers, Colin

Hi, I've just done more poking around and clearly I didn't read the doc's fully

Most of my questions are answered here:

http://www.greenpeppersoftware.com/confluence/display/GH/PLANNING+BOARD#PLANNINGBOARD-portlet

The selection of the context is on the backlog and covered here:
http://www.greenpeppersoftware.com/site/posts/list/498.page

I would still like to know if I could just link to the chart image (rather than the whole portlet) - a bit like the image shown in the print chart dialog but without the printer dialog pop up.

cheers, Colin

Hi, we recently upgraded to GH v3.6. I remember from previous versions that you could tweek the values displayed in the chart, or switch them off. Has this been removed in v3.6?

It is still referenced in the doics here :
http://www.greenpeppersoftware.com/confluence/display/GH/CHART+BOARD#CHARTBOARD-header

cheers, Colin

Hi JC, we are looking to do a similar thing to Espee - publish the release burndown on a company website.

Ideally, I would like to just get the chart (this is for managment and they're not interested in the stats at this point). I also need to be able to set the 'version', the chart type, e.g. Burndown Chart (for a given statistic) and also a specific 'Context' (as we are using a separate version field to track release versions). I can do this interactively from the portlet, but I need to be able to set these as defaults to ensure the correct information is displayed as soon as anyone views the project page.

I know we don't want much

, but any help here would be much appreciated.

cheers, Colin

Hi JC, I don't think I'm hitting that problem because as a test I created a new issue with all the defaults (empty summary) and it still failed. I also tried changing all fields (small summary < 10 chars) and still it gives the same message.

I checked the Jira and Tomcat log files and they didn't show anything that seemed relevant. Does GH have its own log file anywhere ?

This is not a blocker as I can use the normal issue creation but I thought I should point it out.

cheers, Colin

Yep, spot on. I set the context to show 'done' issues and the Done count was back to normal.

It might be nice if the version summary stats ignored the hiding of 'Done' issues in the context so that you always see a sensible view on todo/inprogress and done.

thanks for the very fast reply.

cheers, Colin

wow, you guys are on the ball

Thanks for that clarification.

cheers, Colin

From Planning board, in List view:
- double click on issue to open card view
- go to edit the Summary and click into Summary text box so it has focus
- double click on word to highlight it (normal operation in browser)
= the card closes back to the List view.

Another minor annoyance, but anything that helps edit issues faster is just helpful.

We are running GH 3.0.1 on Jira Prof 3.10 on Linux. Main browser is Firefox 2.x

cheers, Colin

PS - last on for now - honest ;-)

When on the Planning board in list view (sorted by rank), find an issue that has child issues. Select the parent and it's child issues. Now, click and drag a child issue to drag the group of selected issues up the ranking order. When you drop them, nothing happens.

If you select the same issue group but click and drag the parent issue, when you drop the group, they are all moved to the appropriate place.

We are running GH 3.0.1 on Jira Prof 3.10 on Linux. Main browser is Firefox 2.x

A minor anoyance, but would be nice if it worked consistently

Cheers, Colin.

PS - sorry for raising so many new messages at once but I thought it better to put each in its own topic so its easier for others to search on later.

Trying to use the new Card creation button from the Planning board results in me getting a "Failed to Create issue" message after hitting the create link. No issue is created. Issue creation works fine from the "Create New Issue" Jira menu item and creating sub-issues works from cards.

We are running GH 3.0.1 on Jira Prof 3.10 on Linux. Main browser is Firefox 2.x

Has anyone else seen this ?

cheers, colin

We seem to have lost the done issues on the version summary on the Planning Board. The done count is always 0. The Done issues are displayed on the task board and the done count is shown correctly in the GH portlet (on dashboard) but the Done count is displayed as 0 on the version summary.

After you move an issue from InProgress to done (on the task board) the version summary decrements the inprogress issue count, but the done count remains 0 - very odd.

We are running GH 3.0.1 on Jira Prof 3.10 on Linux. Main browser is Firefox 2.x

It was working correctly until we upgraded to 3.0.1 but I can't see it as a raised issue. Do you think this could be something to do with our config?

We use the default Done defintions and the Default Jira workflow.

cheers Colin

The boards don't seem to remember the layout settings.

- view the task board in list mode
- swap to the planning board, you see things in list view.
- swap to summary view and see cards in summary view.
- click back to the task board - the issue are displayed in summary layout rather than the original list mode.

I'm sure it used to remember the layout some versions ago.

We are running GH 3.0.1 on Jira Prof 3.10 on Linux. Main browser is Firefox 2.x