[TIME-74] [pivot report exception] No user found

Hello,

some days before we have deleted an user that was part of our project team.
Now we want to generate a pivot report from the last month and get the following system error.
It seems that the plugin cannot handle deleted users properly.

System Error - User not found

System Error A system error has occurred. If this problem persists - please notify your JIRA administrator of this problem. Otherwise, please create a support issue on our support system at http://support.atlassian.com with the following information: 1. a description of your problem 2. cut & paste the error and system information found below Cause: com.opensymphony.user.EntityNotFoundException: No user awwad0i found Stack Trace: [hide] com.opensymphony.user.EntityNotFoundException: No user awwad0i found at com.opensymphony.user.UserManager.getEntity(UserManager.java:259) at com.opensymphony.user.UserManager.getUser(UserManager.java:181) at com.fdu.jira.plugin.report.pivot.Pivot.getTimeSpents(Pivot.java:160) at com.fdu.jira.plugin.report.pivot.Pivot.generateReport(Pivot.java:201) at com.fdu.jira.plugin.report.pivot.Pivot.generateReportHtml(Pivot.java:229) at com.atlassian.jira.web.action.browser.ConfigureReport.doExecute(ConfigureReport.java:112) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:59) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:141) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:181) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

And another exception is created if we make a select from filter

System Error - User not found

System Error A system error has occurred. Please try submitting this problem via the Support Request Page Otherwise, please create a support issue on our support system at http://support.atlassian.com with the following information: 1. a description of your problem 2. cut & paste the error and system information found below 3. attach the application server log file ( /opt/jira/home/logs/atlassian-jira.log ) Cause: java.lang.ClassCastException Stack Trace: [hide] java.lang.ClassCastException Referer URL: http://jira.xxx.de/jira/secure/ConfigureReport!default.jspa?selectedProjectId=10020&reportKey=com.fdu.jira.plugin.timesheet:projectpivot Build Information: Uptime : N/A Edition : enterprise Version : 4.0 Build Number : 466 Build Date : Mon Sep 28 00:00:00 CEST 2009 Atlassian Partner : null Installation Type : Standalone Server ID : xxxx-xxxx-xxxx-xxxx Server Information: Application Server: Apache Tomcat/5.5.28 Servlet Version: 2.4 File Paths: Location of entityengine.xml: file:/opt/jira/server/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: /opt/jira/home/logs/atlassian-jira.log Memory Information: Total Memory: 494 MB Free Memory: 31 MB Used Memory: 463 MB Total PermGen Memory: 256 MB Free PermGen Memory: 112 MB Used PermGen Memory: 174 MB System Information: System Date : Dienstag, 09 Feb 2010 System Time : 10:24:54 +0100 Current Working Directory : /opt/jira/home/logs Java Version : 1.6.0_16 Java Vendor : Sun Microsystems Inc. JVM Version : 1.0 JVM Vendor : Sun Microsystems Inc. JVM Implementation Version : 14.2-b01 Java Runtime : Java(TM) SE Runtime Environment Java VM : Java HotSpot(TM) 64-Bit Server VM User Name : jira User Timezone : Europe/Berlin User Locale : Deutsch (Deutschland) System Encoding : ISO-8859-15 Operating System : Linux 2.6.22-14-server OS Architecture : amd64 Application Server Container : Database type : mysql Database JNDI address : java:comp/env/jdbc/JiraDS Database URL : Hidden Database version : 5.0.45-Debian_1ubuntu3.3-log Database driver : MySQL-AB JDBC Driver mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) External user management : OFF Crowd integration : OFF JVM Input Arguments : -Xms128m -Xmx512m -XX:MaxPermSize=256m -Djava.awt.headless=true -Datlassian.standalone=JIRA -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/opt/jira/server/conf/logging.properties -Djava.endorsed.dirs=/opt/jira/server/common/endorsed -Dcatalina.base=/opt/jira/server -Dcatalina.home=/opt/jira/server -Djava.io.tmpdir=/opt/jira/server/temp -Duser.timezone=Europe/Berlin -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/opt/jira/server/conf/logging.properties abort Language Info: Installed languages: Chinesisch (China) Chinesisch (Taiwan) Deutsch (Deutschland) Deutsch (Schweiz) Dänisch (Dänemark) Englisch (UK) Englisch (Vereinigte Staaten von Amerika) Französisch (Frankreich) Italienisch (Italien) Japanisch (Japan) Katalanisch (Spanien) Niederländisch (Belgien) Norwegisch (Norwegen) Polnisch (Polen) Portugiesisch (Brasilien) Russisch (Russland) Slowakisch (Slowakei) Spanisch (Spanien) Tschechisch (Tschechische Republik) Türkisch (Türkei) Ungarisch (Ungarn) Default language: Englisch (UK) Request Information: - Request URL: http://xxx/jira/500page.jsp - Scheme: http - Server: jira.xxx.de - Port: 80 - URI: /jira/500page.jsp - Context Path: /jira - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: projectid=&filterid=10134&startDate=9%2FDec%2F09&endDate=18%2FDec%2F09&selectedProjectId=10020&reportKey=com.fdu.jira.plugin.timesheet%3Aprojectpivot&Next=Next Request Attributes - javax.servlet.forward.request_uri : /jira/secure/ConfigureReport.jspa - javax.servlet.forward.context_path : /jira - javax.servlet.forward.servlet_path : /secure/ConfigureReport.jspa - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.forward.query_string : projectid=&filterid=10134&startDate=9%2FDec%2F09&endDate=18%2FDec%2F09&selectedProjectId=10020&reportKey=com.fdu.jira.plugin.timesheet%3Aprojectpivot&Next=Next - os_securityfilter_already_filtered : true - jira.request.time.micros : 0 - atlassian.core.seraph.original.url : /secure/ConfigureReport.jspa?projectid=&filterid=10134&startDate=9%2FDec%2F09&endDate=18%2FDec%2F09&selectedProjectId=10020&reportKey=com.fdu.jira.plugin.timesheet%3Aprojectpivot&Next=Next - javax.servlet.error.servlet_name : action - com.atlassian.gzipfilter.GzipFilter_already_filtered : true - loginfilter.already.filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@6b16730a - com.atlassian.jira.web.filters.accesslog.AccessLogFilter_already_filtered : true - javax.servlet.error.message : - webwork.result : Value stack =========== =========== - jira.request.username : huber0m - com.atlassian.jira.web.filters.RequestCleanupFilter_already_filtered : true - javax.servlet.error.request_uri : /jira/secure/ConfigureReport.jspa - jira.request.id : 37494x480458x1 - jira.webwork.cleanup : false - javax.servlet.error.status_code : 500 - ASESSIONID : 11lz468 - jira.request.start.millis : 1265707494553 - com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true - com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered : true - jira.request.assession.id : 11lz468 - __sitemesh__filterapplied : true - javax.servlet.error.exception : javax.servlet.ServletException Request Logging 0 log statements generated by this request: Listeners - GreenHopper Listener (com.pyxis.greenhopper.jira.customfields.GreenHopperCTFIndexer) - Issue Cache Listener (com.atlassian.jira.event.listeners.cache.IssueCacheListener) - Issue Index Listener (com.atlassian.jira.event.listeners.search.IssueIndexListener) - Mail Listener (com.atlassian.jira.event.listeners.mail.MailListener) Services - Backup Service (com.atlassian.jira.service.services.export.ExportService) - Delay: 720 minutes - USEZIP: Zip - USE_DEFAULT_DIRECTORY: true - Create/Comment Service MEDTEM (com.atlassian.jira.service.services.file.FileService) - Delay: 1 minutes - handler.params: project=MEDTEM, issuetype=1, createusers=true, bulk=forward - directory: /home/jira/Maildir/MEDTEM/new - handler: Create Or Comment Handler - Create/Comment Service SMTPISSUE (com.atlassian.jira.service.services.file.FileService) - Delay: 1 minutes - handler.params: project=EXAMPLE, issuetype=1, createusers=true, bulk=forward - directory: /home/jira/Maildir/EXAMPLE/new - handler: Create Or Comment Handler - Mail Queue Service (com.atlassian.jira.service.services.mail.MailQueueService) - Delay: 1 minutes - Service Provider Token Remover (com.atlassian.sal.jira.scheduling.JiraPluginSchedulerService) - Delay: 480 minutes - pluginJobName: Service Provider Token Remover - Subversion Revision Indexing Service (com.atlassian.jira.plugin.ext.subversion.revisions.RevisionIndexService) - Delay: 2 minutes - VCS Update Service (com.atlassian.jira.service.services.vcs.VcsService) - Delay: 5 minutes Plugins - Admin Menu Sections 1.0 - Plugin by Atlassian - Enabled - Apache HttpClient OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Apache HttpCore OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Atlassian Gadgets OAuth Service Provider Plugin 1.0.3 - Plugin by Atlassian - Enabled - Atlassian OAuth Admin Plugin 1.0.7 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer Plugin 1.0.7 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer SPI 1.0.7 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider Plugin 1.0.7 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider SPI 1.0.7 - Plugin by Atlassian - Enabled - Atlassian REST - Module Types 1.0.5 - Plugin by Atlassian - Enabled - Atlassian Template Renderer API 1.0.2 - Plugin by Atlassian - Enabled - Atlassian Template Renderer Velocity 1.6 Plugin 1.0.2 - Plugin by Atlassian - Enabled - Atlassian UI Plugin 1.2.2 - Plugin by Atlassian - Enabled - BND Library 0.0.255 - Plugin by aQute SARL http://www.aQute.biz - Enabled - Content Link Resolvers Plugin 1.0 - Plugin by Atlassian - Enabled - Custom Field Types & Searchers 1.0 - Plugin by Atlassian - Enabled - Embedded Gadgets Plugin 1.0.3 - Plugin by Atlassian - Enabled - FishEye Plugin 3.0.9 - Plugin by Atlassian Software Systems - Enabled - Gadget Dashboard Plugin 1.0.3 - Plugin by Atlassian - Enabled - Gadget Directory Plugin 1.0.3 - Plugin by Atlassian - Enabled - Gadget Renderer Plugin 1.0.3 - Plugin by Atlassian - Enabled - Gadget Spec Publisher Plugin 1.0.3 - Plugin by Atlassian - Enabled - GreenHopper 4.2-jira40 - Plugin by Atlassian - Enabled - ICU4J 3.8.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Issue Operations Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Tab Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Views Plugin 1.0 - Plugin by Atlassian - Enabled - JDOM DOM Processor 1.0.0 - Plugin by SpringSource - Enabled - JIRA Activity Stream Plugin 3.0.12 - Plugin by Atlassian - Enabled - JIRA Bamboo Plugin 4.0 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - JIRA Calendar Plugin 1.10 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Charting Plugin 1.5 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Commit Acceptance Plugin 1.4 - Plugin by Atlassian Pty Ltd - Enabled - configure.url: /secure/CommitAcceptanceConfigure.jspa - JIRA Footer 1.0 - Plugin by Atlassian - Enabled - JIRA Gadgets Plugin 4.0 - Plugin by Atlassian - Enabled - JIRA Labels Plugin 2.3 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Linker Plugin 1.2.1 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Misc Workflow Extensions 1.4 - Plugin by Innovalog - Enabled - JIRA OAuth Consumer SPI Plugin 4.0 - Plugin by Atlassian - Enabled - JIRA OAuth Service Provider SPI Plugin 4.0 - Plugin by Atlassian - Enabled - JIRA REST Plugin 4.0 - Plugin by Atlassian - Enabled - JIRA Subversion plugin 0.10.5.2 - Plugin by Atlassian Pty Ltd - Enabled - JIRA TimeSheet Report and Portlet 1.8 - Plugin by Andriy Zhdanov - Enabled - JQL Functions 1.0 - Plugin by Atlassian - Enabled - JSON Library 20070829.0.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Jira SU 1.2 - Plugin by Andy Brook - Enabled - Jira Workflow Report Plugin 1.5.2 - Plugin by OnResolve Ltd - Enabled - Joda-Time 1.6 - Plugin by null - Enabled - MKK JIRA Enhancer Plugin 1.4.0 - Plugin by Tuncay Senturk - Merkezi Kayit Kurulusu - Enabled - Neko HTML 1.9.12.1 - Plugin by Atlassian Pty Ltd - Enabled - Portlets Plugin 1.0 - Plugin by Atlassian - Enabled - Preset Filters Sections 1.0 - Plugin by Atlassian - Enabled - Project Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Project Role Actors Plugin 1.0 - Plugin by Atlassian - Enabled - ROME, RSS and atOM utilitiEs for Java 1.0 - Plugin by Sun Microsystems - Enabled - ROME: RSS/Atom syndication and publishing tools 0.9.0 - Plugin by SpringSource - Enabled - RPC JIRA Plugin 4.0 - Plugin by Atlassian - Enabled - Renderer Component Factories Plugin 1.0 - Plugin by Atlassian - Enabled - Renderer Plugin 1.0 - Plugin by Atlassian - Enabled - Reports Plugin 1.0 - Plugin by Atlassian - Enabled - Shared Application Access Layer API 2.0.14 - Plugin by Atlassian - Enabled - Shared Application Access Layer JIRA Plugin 2.0.14 - Plugin by Atlassian Software Systems - Enabled - Top Navigation Bar 1.0 - Plugin by Atlassian - Enabled - User Format 1.0 - Plugin by Atlassian - Enabled - User Navigation Bar Sections 1.0 - Plugin by Atlassian - Enabled - User Profile Links 1.0 - Plugin by Atlassian - Enabled - View Project Operations Sections 1.0 - Plugin by Atlassian - Enabled - Web Resources Plugin 1.0 - Plugin by Atlassian - Enabled - Webwork Plugin 1.0 - Plugin by Atlassian - Enabled - Wiki Renderer Macros Plugin 1.0 - Plugin by Atlassian - Enabled - Workflow Plugin 1.0 - Plugin by Atlassian - Enabled

Thanks in advance!

By huber0m/Marc Huber on Tue, 9 Feb 2010 01:29:59 -0800

Comments (1)