• Change content status via database
    DescriptionWhen you need to change the content status via the database, you need to change more then just the content_status column in the content table. This process may need to be run in cases where a content item is displaying an error in the workarea, or the status is not in a recognized sta...

  • Clarification on encrypting an Ektron database
    Description What methods of encrypting the Ektron database have been tested and are supported? Resolution Encrypting the Ektron databases further has not been tested within the Ektron CMS. Many forms of encryption are likely to cause issues within the CMS, but is is suspected that...

  • Clearing Your AssetServerTable
    DescriptionOccasionally when troubleshooting issues, such as eSync and Go-Live functionality, the support tech may ask you to clear out your "AssetServerTable" and stop and start the Ektron Windows Service.  ResolutionWhen requested to clear the "AssetServerTable", pleas...

  • Clearing Your perform_action table
    DescriptionWhen troubleshooting Go-Live or archive issues, a support tech may ask you to clear your perform_action table.The perform_action table acts as a "bucket," where current actions in the CMS are temporarily stored. For example, if you publish content, the content temporarily re...

  • ContentManager.GetList returns incorrect results when run recursively.
    DescriptionIncorrect results may return when using the API below with the recursive property set.  In this case, results from other folders may appear in the results. ContentManager cm = new ContentManager(Ektron.Cms.Framework.ApiAccessMode.Admin); ContentCriteria criteria = new ContentCri...

  • Creating a database backup
    DescriptionAt some point you may run into an issue which requires you to backup your database and upload it to Ektron support. To that end, here are some simple steps to create a backup. Resolution1) In SQL Server Management Studio(SSMS), connect to the database server.2) Right click on the...

  • Database Permissions
    DescriptionWhich database permissions are necessary to set up a restored database to work with a minSite? ResolutionThe user account in the connectionstring must have the following database permissions: 

  • Error Message: System.Data.SqlClient.SqlException Invalid column name
    DescriptionOne may experience issues receiving errors similar to the one below in the Event Viewer or while navigating around the CMS. These errors can also occur when using the Ektron APIs. Message: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Name'Typically the cause o...

  • Error regarding LicenseManager
    DescriptionWhen installing a min site with a min database for the first time you may run into the following error message when logging into the workarea or in the event viewer: Error Message:Receive following in the event log Timestamp: 3/10/2014 5:05:13 PM Message: Exception thrown from: / O...

  • Error when using the Ektron database connection string in an MVC environment
    DescriptionSome users may notice when upgrading an MVC site based of the Synergy 2011 MVC Sample (created on Ektron 8.6) to Ektron 9.1 that they are receiving errors similar to the following when using the select Ektron APIs:[CommunicationException: An error occurred while receiving the HTTP res...

  • Find the folder path from a content id in the database
    DescriptionWhen querying the Ektron database for troubleshooting, sometimes it is necessary to find the location of the content item in the workarea or in the case of assets and library items, the actual file on the file system. ResolutionWhen querying the database, the following script can...

  • Format of the Ektron Connection String
    DescriptionSome users have different values on their connection string the the Ektron CMS. The format of this string does matter for certain areas of the product to function correctly. Please make sure your connection string matches below. ResolutionThe connection string is located in the s...

  • How to migrate database to a new SQL Server
    DescriptionHow to migrate a database to a new SQL server.Resolution Backup the source database. Copy, then restore the source backup onto the destination SQL Server. Ensure the SQL account for the connection has the necessary role memberships (minimally: db_datareader, db_datawriter, db_ddladmin...

  • How to: Perform a manual database upgrade
    DescriptionFrom time to time, Ektron Support may request a manual upgrade of a database. The manual upgrade process is good for upgrading a database to a base release without rerunning the site setup utility. It can also sometimes circumvent errors within the site setup utility, or identify what...

  • Invalid object name 'ContentCollectionView' on database upgrade
    DescriptionWhen running an upgrade to a 9.1 series from an earlier version of Ektron a Invalid object name 'ContentCollectionView' error message is thrown. CauseThis error message is caused by the site missing data entry that is present within later versions of the product. ResolutionT...

  • Issues upgrading an Ektron Database that contains custom database triggers
    DescriptionYou may experience issues upgrading your Ektron database if it contains custom database triggers.To clarify, a database trigger is a database object that is attached to table similar to a stored procedure. These triggers are only fired when an INSERT, UPDATE or DELETE statement occurs...

  • List of Content Types and Content SubTypes
    DescriptionWhen developing, it is useful to know what content types and sub types you are working with. Below is a list of these types as defined in the EkEnumeration class. ResolutionContent Types  NameValue All Types -1 Undefined 0 Content 1 Forms 2 Archived Content 3 Archi...

  • Taxonomies, Foreign Key Constraint Errors, and Multilingual Environments
    DescriptionIn a multilingual environment, you are getting the following error when trying to add sub taxonomies to particular taxonomies:Error occured while executing cms_createtaxonomy: The INSERT statement conflicted with the FOREIGN KEY constraint "taxonomy_children_tbl_fk1".  The c...

  • The type initializer for 'Ektron.Cms.LanguageHelper' threw an exception Error and What It Means
    DescriptionWhen trying to publish content, an error may be thrown: The type initializer for 'Ektron.Cms.LanguageHelper' threw an exception CauseTypically this error stems from code that is making calls to the database and then not closing the connection. Making direct calls to the databa...

  • Transaction log for database 'name' is full
    DescriptionUpon 8.5 upgrade, error The transaction log for database 'name' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databasesResolutionTo fix this problem, change the Database Recovery Model from "Full" to "Simple"....

  • Troubleshooting SQL Deadlocks
    DescriptionA SQL Deadlock occurs when two or more tasks permanently block each other. Each task locks a resource which the other tasks are trying to lock. The following resource types can be deadlocked:Locks - Waiting to acquire locks on resources such as objects, pages, metadata, and applicatio...

  • Violation of PRIMARY KEY constraint 'PK_notification_publish_preference_tbl
    DescriptionWhen you upgrade to Ektron 9.00 SP2, the database portion of the upgrade displayed the following error:ERROR! Failed to execute script!  Error[cms_SetupDefaultNotificationPreferencesForActivity}: Violation of PRIMARY KEY constraint 'PK_notification_publish_preference_tbl'. Cannot in...

  • Violation of Primary Key Constraint Error
    DescriptionWhen adding content, a user, a menu, taxonomy, or any other item in the workarea or via the API an error stating, "Violation of PRIMARY KEY constraint "column_name". Cannont insert duplicate key in object 'object_name'" occurs. Before running any scripts listed bel...

  • WebEventCriteria GetList returns Invalid Column Name Error
    DescriptionUsing the following sample will throw the error: Server Error in '<site>' Application. Invalid column name 'Description'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the er...