Outscaling keeps trying to send failed events
Outscaling keeps trying to send failed events
Problem
Within 1.3 build 3, the retry mechanism of Outscaling for sending failed events has been changed slightly. However, these changes has introduced a bug, which has to do with comparing a NULL value against a numeric value on the RetryCount field of the osEventQueueStatus table.
The result is that when sending an event fails for whatever reason, this event is not marked as being failed and the error that occurred won't be written to the EventQueue Errors (osEventQueueStatus table as well). Because of this, the Outscaling background component will endlessly keep trying to send this event (until it succeeds) every background loop.
But some events will never succeed (e.g. due to database constraint violations), so these events are the problem. Outscaling will keep trying to send these events, and for the sake of performance and resource usage this should be prevented.
Resolution
Outscaling will be fixed within the next build/release (isnull check added to the retrycount comparing), however in the meantime it is strongly adviced to add a database DEFAULT CONSTRAINT (with value 0) to the RetryCount column of the osEventQueueStatus table. You can use the SQL script shown below.
SQL | Copy Code |
---|---|
IF NOT EXISTS ( SELECT 1 FROM sys.default_constraints dc INNER JOIN sys.columns c ON dc.parent_object_id = c.object_id AND dc.parent_column_id = c.column_id WHERE parent_object_id = object_id('osEventQueueStatus') AND c.name = 'retrycount' ) ALTER TABLE osEventQueueStatus ADD CONSTRAINT DF_osEQStatus_RetryCount DEFAULT ((0)) FOR retrycount; |
This will, in the meantime, effectively fix the bug mentioned above and will have no impact once you install the next build/release containing the bug-fix in code.
- Getting Started
- Hardware and software requirements for Smartsite iXperion
- Platform support
- Site Installation
- Smartsite 7 Manager
- iXperion Publication Server
- iXperion tools
- Database Server
- Security
- IIS Configuration
- Asp.Net Configuration
- Outscaling
- WCF
- Smartsite Configuration files
-
Knowledge Base | Installation and Configuration
- Request for the permission of type 'System.Web.AspNetHostingPermission failed.
- ConfigEditor won't start with this message: Method not found: System.Windows.Forms.ToolStripItem.set_ImageIndex(Int32)
- SecurityException while installing the performance counters.
- Preview error after installing / upgrading to release 1.1
- Purge Items isn't synchronized between cms instances
- How to duplicate the render template mappings from one channel to another
- Automation Error - More Data Available on startup
- Forum Smartlet fails when using Active Directory security on the front-end
- Site fails to start after updating to 1.3 with MissingMethodException
- The PUB engine won't start due to the following error: Could not load type 'System.DateTimeOffset' Exception
- Reduce server traffic by setting the Cache-Control response header in IIS7
- Error Reference
- EmptySix site
- Smartsite iXperion Release 1.3 Installation manual
- Smartsite iXperion Requirements - v3.6
- Implementatiehandleiding Active Directory Koppeling of LDAP Smartsite iXperion v1.1.3
- Installatiehandleiding iXperion 1.3 en hoger Win 2008 32bit-v1.4
- Installatiehandleiding iXperion 1.3 en hoger Win 2008 64bit-v1.4
- Installatiehandleiding iXperion Word Import - Word 2010 setup voor x64- v1.0
- Installatiehandleiding Oracle client iXperion 1.3 Windows 2008 R2 64bit- v1.0.1
- Installatiehandleiding Smartsite iXperion SMI 2.0 - v1.0.3