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 > [email protected] <[email protected]')" target="1">[email protected] > > www.manhattan.edu(http://www.manhattan.edu/) > > > > On Wed, Mar 26, 2014 at 11:33 AM, Cindy Duggan <[email protected](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 > > [email protected](javascript:main.compose() > > > > www.manhattan.edu(http://www.manhattan.edu/) > > > > > > > > > > On Tue, Mar 25, 2014 at 4:45 PM, Cindy Duggan <[email protected](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 > > > [email protected](javascript:main.compose() > > > > > > www.manhattan.edu(http://www.manhattan.edu/) > > > > > > > > > > > > > > > On Mon, Mar 24, 2014 at 7:43 PM, James Wennmacher <[email protected](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 > > > > > [email protected](javascript:main.compose() > > > > > > > > > > www.manhattan.edu(http://www.manhattan.edu/) > > > > > > > > > > > > > > > > > > > > On Mon, Mar 24, 2014 at 6:58 PM, Drew Wills <[email protected](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 [email protected](javascript:main.compose() as: [email protected](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 [email protected](javascript:main.compose() as: [email protected](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 [email protected](javascript:main.compose() as: [email protected](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 [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
smime.p7s
Description: S/MIME Cryptographic Signature
