Thanks James and Tim! I will pass along that info to the DBA team.
*Cindy Duggan, Ph.D., P.E.* *Assistant Director of Web and Collaboration* Riverdale, New York 10471 Phone: 718.862.7413 Fax: 718.862.8024 cindy.dug...@manhattan.edu www.manhattan.edu On Wed, Mar 26, 2014 at 2:29 PM, Tim Levett <lev...@wisc.edu> wrote: > Hi Cindy, > > This happened at UW-Madison a while back. The issue we had was when we > changed the fname of a portlet, then tried to create a new portlet with the > same fname as the previous. The error was during aggregation on the > constraint on UP_AGGR_PORTLET_MAPPING.portlet_fname. That might not be > the exact case you have, but I thought I would share what happened to us. > > We created a quick Groovy script to check the UP_RAW_EVENTS table. If it > gets too far behind our build bot Jenkins lets us know about it. > > - Tim > > > On 03-26-14, James Wennmacher wrote: > >> >> >> >> 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 >> > uportal-dev@lists.ja-sig.org <cindy.dug...@manhattan.edu')" target="1"> >> cindy.dug...@manhattan.edu >> > >> > www.manhattan.edu(http://www.manhattan.edu/) >> >> > >> > >> > >> > On Wed, Mar 26, 2014 at 11:33 AM, Cindy Duggan < >> cindy.dug...@manhattan.edu(javascript:main.compose()> 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 >> > > cindy.dug...@manhattan.edu(javascript:main.compose() >> > > >> > > www.manhattan.edu(http://www.manhattan.edu/) >> >> > > >> > > >> > > >> > > >> > > On Tue, Mar 25, 2014 at 4:45 PM, Cindy Duggan < >> cindy.dug...@manhattan.edu(javascript:main.compose()> 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 >> > > > cindy.dug...@manhattan.edu(javascript:main.compose() >> > > > >> > > > www.manhattan.edu(http://www.manhattan.edu/) >> >> > > > >> > > > >> > > > >> > > > >> > > > On Mon, Mar 24, 2014 at 7:43 PM, James Wennmacher < >> jwennmac...@unicon.net(javascript:main.compose()> 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 >> > > > > > cindy.dug...@manhattan.edu(javascript:main.compose() >> > > > > > >> > > > > > www.manhattan.edu(http://www.manhattan.edu/) >> >> > > > > > >> > > > > > >> > > > > > >> > > > > > On Mon, Mar 24, 2014 at 6:58 PM, Drew Wills <awi...@unicon.net >> (javascript:main.compose()> 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 >> > > > > > > uportal-dev@lists.ja-sig.org(javascript:main.compose() >> as: cindy.dug...@manhattan.edu(javascript:main.compose() >> >> > > > > > > To unsubscribe, change settings or access archives, see >> http://www.ja-sig.org/wiki/display/JSG/uportal-dev >> > > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > -- You are currently subscribed to uportal-dev@lists.ja-sig.org >> (javascript:main.compose() as: >> jwennmac...@unicon.net(javascript:main.compose() >> To unsubscribe, change settings or access archives, see >> http://www.ja-sig.org/wiki/display/JSG/uportal-dev >> > > > > > >> > > > > > >> > > > > >> > > > > >> > > > > -- You are currently subscribed to >> > > > > uportal-dev@lists.ja-sig.org(javascript:main.compose() >> as: cindy.dug...@manhattan.edu(javascript:main.compose() To unsubscribe, >> change settings or access archives, see http://www.ja-sig.org/wiki/ >> display/JSG/uportal-dev >> > > > > >> > > > > >> > > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > >> > > >> > > >> > > >> > > >> > > >> > >> > >> > >> > >> > -- You are currently subscribed to http://www.ja-sig.org/wiki/ >> display/JSG/uportal-dev >> > >> >> >> -- >> You are currently subscribed to uportal-dev@lists.ja-sig.org as: >> lev...@wisc.edu >> >> To unsubscribe, change settings or access archives, see >> http://www.ja-sig.org/wiki/display/JSG/uportal-dev >> > > -- You are currently subscribed to uportal-dev@lists.ja-sig.org as: arch...@mail-archive.com To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev