Hi Cindy. I think you are on the right track. You can have your DBA check what specific constraint '*UPRTINSTALL.SYS_C0042907*' is (table and columns) and that can confirm if it is this issue. If it is, you can query the tables to figure out what fname/name combination is causing the duplicate name and adjust the name to be unique (probably the same portlet that had it's fname changed if that's what happened). Alternately you might be able to drop the unique constraint, though I suggest not going this route.
James Wennmacher - Unicon 480.558.2420 On 03/26/2014 08:35 AM, Cindy Duggan wrote: > All started happening in mid Feb. > > > *Cindy Duggan, Ph.D., P.E.* > /Assistant Director of Web and Collaboration > / > > Riverdale, New York 10471 > Phone: 718.862.7413 > Fax: 718.862.8024 > [email protected] <mailto:[email protected]> > > www.manhattan.edu <http://www.manhattan.edu/> > > > > On Wed, Mar 26, 2014 at 11:33 AM, Cindy Duggan > <[email protected] <mailto:[email protected]>> wrote: > > Oracle Database folks found the following: > > Tablespaces all OK. > > > Apache / Tomcat logs show the following - see the end for that > related to events aggregation : > > > WARN [TP-Processor337-guest] rendering.PortletExecutionManager.[] > 2014-03-25 00:01:03,138 - Portlet worker started but never > retrieved for: PortletWindow [portletWindowId=55_u21l1n5_12, > delegationParentId=null, portletMode=view, windowState=normal, > expirationCache=null, renderParameters={}, > publicRenderParameters={}, portletEntity=PortletEntity > [portletEntityId=55_u21l1n5_12, layoutNodeId=u21l1n5, userId=12, > portletDefinition=PortletDefinition [portletDefinitionId=55, > fname=emergency-alert, portletDescriptorKey=PortletDescriptorKey > [frameworkPortlet=false, webAppName=/jasig-widget-portlets, > portletName=emergency-alerts], portletType=PortletTypeImpl > [internalId=1, name=Portlet, descr=Adapter for JSR-168 and JSR-286 > Portlets, cpdUri=/org/jasig/portal/portlets/GenericPortlet.cpd.xml]]]] > WARN [TP-Processor283-guest] rendering.PortletExecutionManager.[] > 2014-03-25 00:01:06,193 - Portlet worker started but never > retrieved for: PortletWindow [portletWindowId=55_u21l1n5_12, > delegationParentId=null, portletMode=view, windowState=normal, > expirationCache=null, renderParameters={}, > publicRenderParameters={}, portletEntity=PortletEntity > [portletEntityId=55_u21l1n5_12, layoutNodeId=u21l1n5, userId=12, > portletDefinition=PortletDefinition [portletDefinitionId=55, > fname=emergency-alert, portletDescriptorKey=PortletDescriptorKey > [frameworkPortlet=false, webAppName=/jasig-widget-portlets, > portletName=emergency-alerts], portletType=PortletTypeImpl > [internalId=1, name=Portlet, descr=Adapter for JSR-168 and JSR-286 > Portlets, cpdUri=/org/jasig/portal/portlets/GenericPortlet.cpd.xml]]]] > WARN [TP-Processor213-guest] rendering.PortletExecutionManager.[] > 2014-03-25 00:01:26,425 - Portlet worker started but never > retrieved for: PortletWindow [portletWindowId=55_u21l1n5_12, > delegationParentId=null, portletMode=view, windowState=normal, > expirationCache=null, renderParameters={}, > publicRenderParameters={}, portletEntity=PortletEntity > [portletEntityId=55_u21l1n5_12, layoutNodeId=u21l1n5, userId=12, > portletDefinition=PortletDefinition [portletDefinitionId=55, > fname=emergency-alert, portletDescriptorKey=PortletDescriptorKey > [frameworkPortlet=false, webAppName=/jasig-widget-portlets, > portletName=emergency-alerts], portletType=PortletTypeImpl > [internalId=1, name=Portlet, descr=Adapter for JSR-168 and JSR-286 > Portlets, cpdUri=/org/jasig/portal/portlets/GenericPortlet.cpd.xml]]]] > > > *WARN [uP-TaskExec-77-aggregateRawEvents] > spi.SqlExceptionHelper.[] 2014-03-25 00:01:33,821 - SQL Error: 1, > SQLState: 23000 > ERROR [uP-TaskExec-77-aggregateRawEvents] > spi.SqlExceptionHelper.[] 2014-03-25 00:01:33,823 - ORA-00001: > unique constraint (UPRTINSTALL.SYS_C0042907) violated > WARN [uP-TaskExec-77-aggregateRawEvents] spi.SqlExceptionHelper.[] > 2014-03-25 00:01:33,823 - SQL Error: 1, SQLState: 23000 > ERROR [uP-TaskExec-77-aggregateRawEvents] > spi.SqlExceptionHelper.[] 2014-03-25 00:01:33,823 - ORA-00001: > unique constraint (UPRTINSTALL.SYS_C0042907) violated > ERROR [uP-TaskExec-77-aggregateRawEvents] > internal.BatchingBatch.[] 2014-03-25 00:01:33,823 - HHH000315: > Exception executing batch [ORA-00001: unique constraint > (UPRTINSTALL.SYS_C0042907) violated* > ] > > > > > Wondering if related to: > > https://issues.jasig.org/browse/UP-3899 > > > > > *Cindy Duggan, Ph.D., P.E.* > /Assistant Director of Web and Collaboration > / > > Riverdale, New York 10471 > Phone: 718.862.7413 > Fax: 718.862.8024 > [email protected] <mailto:[email protected]> > > www.manhattan.edu <http://www.manhattan.edu/> > > > > On Tue, Mar 25, 2014 at 4:45 PM, Cindy Duggan > <[email protected] <mailto:[email protected]>> > wrote: > > Thanks James. > > I will have our systems folks check out the events aggregator > and tables. > > *Cindy Duggan, Ph.D., P.E.* > /Assistant Director of Web and Collaboration > / > > Riverdale, New York 10471 > Phone: 718.862.7413 > Fax: 718.862.8024 > [email protected] <mailto:[email protected]> > > www.manhattan.edu <http://www.manhattan.edu/> > > > > On Mon, Mar 24, 2014 at 7:43 PM, James Wennmacher > <[email protected] <mailto:[email protected]>> wrote: > > Is the events aggregator working? I think you can look at > portal/portal-events.log to see if the thread is properly > aggregating events or if it is somehow hung. You may also > have a large UP_RAW_EVENTS table if it is not working. > > If it is working, you should see log messages like below, > though with values > 0 (this is from my local system). > > INFO [uP-TaskExec-1-aggregateRawEvents] > o.j.p.e.a.PortalEventProcessingManagerImpl 2014-03-24 > 10:31:15,595 - Aggregated 0 events created at null > events/second between 1145 and 0.0000 in {}ms - {} e/s a > {}x speedup. > INFO [uP-TaskExec-1-aggregateRawEvents] > o.j.p.e.a.PortalEventProcessingManagerImpl 2014-03-24 > 10:32:15,159 - Aggregated 0 events created at null > events/second between 49 and 0.0000 in {}ms - {} e/s a {}x > speedup. > INFO [uP-TaskExec-1-purgeRawEvents] > o.j.p.e.a.PortalEventProcessingManagerImpl 2014-03-24 > 10:32:16,349 - Purged 0 events created at null > events/second between 45 and 0.0000 in {}ms - {} e/s a {}x > speedup > > James Wennmacher - Unicon > 480.558.2420 > > On 03/24/2014 04:00 PM, Cindy Duggan wrote: >> Drew, >> >> It displays all zeroes. >> >> >> >> *Cindy Duggan, Ph.D., P.E.* >> /Assistant Director of Web and Collaboration >> / >> >> Riverdale, New York 10471 >> Phone: 718.862.7413 >> Fax: 718.862.8024 >> [email protected] >> <mailto:[email protected]> >> >> www.manhattan.edu <http://www.manhattan.edu/> >> >> >> >> On Mon, Mar 24, 2014 at 6:58 PM, Drew Wills >> <[email protected] <mailto:[email protected]>> wrote: >> >> On 03/24/2014 03:43 PM, Cindy Duggan wrote: >> >> The suddenly - a few months ago - the Portlet was >> no longer displaying >> anything. >> >> >> Cindy, >> >> Do you mean it displays nothing at all? Or zeroes? >> >> drew >> >> -- >> You are currently subscribed to >> [email protected] >> <mailto:[email protected]> as: >> [email protected] >> <mailto:[email protected]> >> To unsubscribe, change settings or access archives, >> see http://www.ja-sig.org/wiki/display/JSG/uportal-dev >> >> >> -- >> >> You are currently subscribed [email protected] >> <mailto:[email protected]> as:[email protected] >> <mailto:[email protected]> >> To unsubscribe, change settings or access archives, see >> http://www.ja-sig.org/wiki/display/JSG/uportal-dev > > -- > > You are currently subscribed [email protected] > <mailto:[email protected]> as:[email protected] > <mailto:[email protected]> > > > > > To unsubscribe, change settings or access archives, > seehttp://www.ja-sig.org/wiki/display/JSG/uportal-dev > > > > > -- > > You are currently subscribed to [email protected] as: > [email protected] > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-dev -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
