Issue: Selecting and deleting a number of notifications causes exception

Copyright Witness Network Support <[email protected]> Wed, 22 Oct 2008 21:42:25 +0100
Newsgroups gmane.comp.java.scarab.devel
Organization Copyright Witness
Message-ID <[email protected]>
   Issue ID  	*TPSW53 (Defect)*
	Created by 	Barry Pearce <mailto:[email protected]> -
20-Oct-2008 22:55:30 GMT 	Last modified by 	Barry Pearce
<mailto:[email protected]> - 22-Oct-2008 20:41:25 GMT


        Basic Info

Component/Product 	Scarab
Component/Product Version 	Subversion trunk 10627
Summary 	Selecting and deleting a number of notifications causes exception


        Situation

Description 	

Examining the notifications page showed a number of notifications. All were expanded and all check boxes ticked. After pressing delete selected an exception occurred.
      

Status 	New
On Hold 	No
Severity 	6 - Normal
Occurance Likelihood 	5 - Occasionally
Priority 	Medium
Further Info Required? 	No
Platform 	PC
Processor 	AMD Athlon XP2600+
OperatingSystem 	Ubuntu Server
Operating System Version 	Hardy Heron 8.04.1
Runtime Environment 	

JBoss AS 4.2.3GA, MySQL 5.0.51a

Java Version 	J2SE 6.0


        Actions


      Comments(2)


        Enter new comment


        Comments


        Barry Pearce <mailto:[email protected]> -
        20-Oct-2008 22:56:34 GMT

Notifications  	Customize View ...

   1. UCFG19 <http://projectweb.devgd.copyrightwitness.net/scarab/issues/id/UCFG19/tab/1> Users barrypearce and daymonlester not created during Lancre install. (CW Software Projects> Ubuntu Configurator)
         1. Mon Oct 20 22:42:12 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	AssignedTo: barrypearce () 	
                  Reason for change 	
         2. Mon Oct 20 22:46:35 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: New (Unconfirmed) 	
                  Reason for change 	
         3. Mon Oct 20 22:48:38 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: Assigned (New) 	
                  	scheduled 	Target Release [Ubuntu Cfg]: 1.0 () 	
                  	scheduled 	Resolution Strategy: Create new host scripts for Lancre and Uberwald. () 	
                  	scheduled 	Assessment: The host scripts for lancre and uberwald do not exist - it is these scripts which create the users. () 	
                  Reason for change 	

      UCFG29 <http://projectweb.devgd.copyrightwitness.net/scarab/issues/id/UCFG29/tab/1> digital certificates for mail-* not installed as part of thunderbird user_config (CW Software Projects> Ubuntu Configurator)
         1. Mon Oct 20 22:44:40 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: New (Unconfirmed) 	
                  Reason for change 	
         2. Mon Oct 20 22:45:19 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Description: The digital certificates to access the mail server need to be provided as part of the install, and installed to the user's .ssl directory. The pkcs12 version of the file is required for Thunderbird. (The digital certficates to access the mail server need to be provided as part of the install, and installed to the user's .ssl directory. The pkcs12 version of the file is required for Thunderbird.) 	
                  	scheduled 	Status: Assigned (New) 	
                  	scheduled 	Target Release [Ubuntu Cfg]: 1.0 () 	
                  Reason for change 	

      UCFG23 <http://projectweb.devgd.copyrightwitness.net/scarab/issues/id/UCFG23/tab/1> Gateway set for uberwald and Lancre (CW Software Projects> Ubuntu Configurator)
         1. Mon Oct 20 22:45:45 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: New (Unconfirmed) 	
                  Reason for change 	
         2. Mon Oct 20 22:46:19 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: Assigned (New) 	
                  	scheduled 	Target Release [Ubuntu Cfg]: 1.0 () 	
                  	scheduled 	Assessment: The gateway is set on the interface configuration under /etc/network. () 	
                  Reason for change 	

      UCFG7 <http://projectweb.devgd.copyrightwitness.net/scarab/issues/id/UCFG7/tab/1> Setup xorg.conf for Rincewind and Lancre for 1280x1024 75Hz (CW Software Projects> Ubuntu Configurator)
         1. Mon Oct 20 22:48:55 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: New (Unconfirmed) 	
                  Reason for change 	
         2. Mon Oct 20 22:49:52 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: Assigned (New) 	
                  	scheduled 	Target Release [Ubuntu Cfg]: 1.0 () 	
                  	scheduled 	Assessment: This is configured in /etc/X11/xorg.conf. This file is modified during the install as part of the install of the nvidiagraphics script. () 	
                  Reason for change 	

      UCFG14 <http://projectweb.devgd.copyrightwitness.net/scarab/issues/id/UCFG14/tab/1> Examine the Cyrus IMAP virtual domain support (CW Software Projects> Ubuntu Configurator)
         1. Mon Oct 20 22:50:08 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: New (Unconfirmed) 	
                  Reason for change 	
         2. Mon Oct 20 22:50:18 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: Assigned (New) 	
                  Reason for change 	

      UCFG13 <http://projectweb.devgd.copyrightwitness.net/scarab/issues/id/UCFG13/tab/1> Cyrus IMAP config script doesnt work (CW Software Projects> Ubuntu Configurator)
         1. Mon Oct 20 22:50:33 UTC 2008 Barry Pearce
               1.
                  Delete 	Status 	Description 	Comment
                  	scheduled 	Status: Assigned (New) 	
                  Reason for change 	


        Barry Pearce <mailto:[email protected]> -
        20-Oct-2008 22:55:49 GMT

If the stack trace below has at the top a mention 
of "ResourceNotFoundException", that means that a template could not be 
found (404) and is probably the result of a broken link.

If the stack trace has something else, please enter a copy of the stack 
trace and an explanation of what you did to cause it to the 
Issue Tracking System for analysis. 
If you are a developer and think you know what the problem is, 
feel free to send in a patch to fix the problem.  

  org.apache.turbine.TurbineException: org.apache.torque.TorqueException: Failed to select one and only one row.
	at org.apache.turbine.pipeline.DefaultActionValve.invoke(DefaultActionValve.java:104)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.apache.turbine.pipeline.DefaultACLCreationValve.invoke(DefaultACLCreationValve.java:127)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.tigris.scarab.pipeline.SetLocaleValve.invoke(SetLocaleValve.java:112)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.tigris.scarab.pipeline.FreshenUserValve.invoke(FreshenUserValve.java:189)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.apache.turbine.pipeline.DefaultSessionValidationValve.invoke(DefaultSessionValidationValve.java:131)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.apache.turbine.pipeline.DefaultLoginValve.invoke(DefaultLoginValve.java:109)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.tigris.scarab.pipeline.AnonymousLoginValve.invoke(AnonymousLoginValve.java:62)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.tigris.scarab.pipeline.NTLMLoginValve.invoke(NTLMLoginValve.java:78)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.apache.turbine.pipeline.DefaultSessionTimeoutValve.invoke(DefaultSessionTimeoutValve.java:121)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.tigris.scarab.pipeline.DetermineTargetValve.invoke(DetermineTargetValve.java:138)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.apache.turbine.pipeline.DetermineActionValve.invoke(DetermineActionValve.java:107)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.tigris.scarab.pipeline.SetInfoMessageValve.invoke(SetInfoMessageValve.java:85)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.tigris.scarab.pipeline.ResetCacheValve.invoke(ResetCacheValve.java:77)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.tigris.scarab.pipeline.DetermineCharsetValve.invoke(DetermineCharsetValve.java:103)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.tigris.scarab.pipeline.TimingInfoValve.invoke(TimingInfoValve.java:131)
	at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
	at org.apache.turbine.pipeline.TurbinePipeline.invoke(TurbinePipeline.java:213)
	at org.apache.turbine.Turbine.doGet(Turbine.java:298)
	at org.apache.turbine.Turbine.doPost(Turbine.java:343)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:437)
	at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:366)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
	at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.torque.TorqueException: Failed to select one and only one row.
	at org.tigris.scarab.om.BaseNotificationStatusPeer.retrieveByPK(BaseNotificationStatusPeer.java:878)
	at org.tigris.scarab.om.BaseNotificationStatusPeer.retrieveByPK(BaseNotificationStatusPeer.java:839)
	at org.tigris.scarab.actions.ChangeNotificationStatus.deleteMarkedEntries(ChangeNotificationStatus.java:139)
	at org.tigris.scarab.actions.ChangeNotificationStatus.doDeletenotifications(ChangeNotificationStatus.java:108)
	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:597)
	at org.apache.turbine.modules.actions.TemplateAction.executeEvents(TemplateAction.java:160)
	at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:144)
	at org.apache.turbine.modules.ActionEvent.execute(ActionEvent.java:179)
	at org.apache.turbine.pipeline.DefaultActionValve.executeAction(DefaultActionValve.java:139)
	at org.apache.turbine.pipeline.DefaultActionValve.invoke(DefaultActionValve.java:99)
	... 53 more

-- 
Sincerely Yours

Copyright Witness Net Support
[email protected]

www.copyrightwitness.com
Registration centre for copyright works.

This e-mail and any attachments are confidential and intended for the addressee only.
The information in this mail does not amount to legal advice or opinion. Any views or legal references are those of the author and are based on personal opinion or understanding only.