Sitecore not registering goal
I am running Sitecore 6.5 rev. 120706 with DMS 2.0.1 rev. 120706. Sitecore is not registering goals reached for visitors. The log is showing
ERROR Exception during registration: System.Data.StrongTypingException: The value for column 'LastAccessedDateTime' in table 'AutomationStates' is DBNull.
Checking the LastAccessedDateTime column in SQL Server rows aren't being populated:
Is there any known workarounds or a way to populate this data via code?
Looking into our installation [AutomationStates].[LastAccessedDateTime] is marked as allowing Nulls. You could try to download a clean Analytics database, generate creation scripts for both and run a diff tool to see where your database is corrupted.
The update script for DMS201 does not contain any references to LastAccessedDateTime, so it must come from a prior update.
- Sitecore FXM issue - parent selector is missing in Add to Placeholder dialog
- Customising the Quick Info Section in the Content Editor of Sitecore
- Map Droplist item to complextype using Glass.Mapper
- The "TransformXml" task was not found (error MSB4036) on TeamCity build
- Could not find configuration node: settings/setting[@name='mediaFolder']/@value
- How to retrieve an Image in Bitmap format from the Media Library
- Sitecore GraphQL get siblings
- Querying a large number of items via Sitecore API
- Editing Sitecore zip package
- API documentation for Sitecore 6
- Sitecore LinkManager.GetItemUrl() resolving to alias
- Coveo.UI.Components.Models.IBaseComponentProperties.Id is not supported by SitecoreIdMapper
- Filter in Sitecore Children in Sitecore
- Sitecore: The layout for the requested document was not found
- Sitecore 10 K8S Deployment - Invalid redirect_uri and Keyset Missing Errors
- Clear Sitecore cache for an item from cache programmatically
- Sitecore create drop-down button in RTE populated from master database
- Why changing template in Sitecore using powershell script creates a version in English language even if there no version exists?
- I want to convert sitecore search facet filter from multiple to single
- Sitecore Solr remove versions from index
- Sitecore - render code to add value to database if item is NULL
- Sitecore 7, Link manager, alwaysIncludeServerUrl not working
- Is there a way to stop OnItemSaving events?
- Sitecore Indexing based off of base template
- Using New Relic with Sitecore
- Search empty fields
- How do I turn off XHTML validation in Sitecore?
- Image from sitecore showing up incorrectly on webpage - changing url hash fixes it?
- Sitecore is skipping items during publishing. How to troubleshoot and find out why?
- Language.TryParse Method use in sitecore point of view?