Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > Content Synchronation scheduled task? View modes: 
User avatar
Member
Member
masonc-fayobserver - 2/3/2011 7:55:11 AM
   
Content Synchronation scheduled task?
Has anyone experienced issues with a scheduled task specifically content synchronization task losing the "Next Run" time? I am having issues where the next run time is randomly blank. To resolve I edit the task time ahead several minutes.

User avatar
Kentico Consulting
Kentico Consulting
kentico_borisp - 2/14/2011 5:47:59 AM
   
RE:Content Synchronation scheduled task?
Hello,

Could you please apply the latest hotfix? There has been a minor issue regarding staging and maybe it is related to your problem.
Could you please also check the Event log for any related error messages?

Best regards,
Boris Pocatko

User avatar
Member
Member
masonc-fayobserver - 2/14/2011 6:56:52 AM
   
RE:Content Synchronation scheduled task?
We are using version 5.5.3926 at the moment. I can't update to latest hotfix due to a partnership with another software company because they are not ready for latest version. I am having this error:

Event ID: 289670
Event type: Error
Event time: 2/14/2011 6:09:49 AM
Source: Staging
Event code: LOGDOCUMENT
IP address:

Description: Message: [DataConnection.ExecuteQuery]: Query: INSERT INTO Staging_Synchronization ([SynchronizationTaskID], [SynchronizationServerID], [SynchronizationLastRun], [SynchronizationErrorMessage] ) VALUES ( @SynchronizationTaskID, @SynchronizationServerID, @SynchronizationLastRun, @SynchronizationErrorMessage); SELECT SCOPE_IDENTITY() AS [SynchronizationID]: caused exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Staging_Synchronization_SynchronizationTaskID_Staging_Task". The conflict occurred in database "GNWeb-5", table "dbo.Staging_Task", column 'TaskID'.
The statement has been terminated.
Stack Trace:
at CMS.DataProviderSQL.DataConnection.ExecuteScalar(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
at CMS.DataEngine.GeneralConnection.ExecuteScalar(QueryParameters query)
at CMS.DataEngine.GeneralConnection.ExecuteScalar(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN, String columns)
at CMS.DataEngine.GeneralConnection.ExecuteScalar(String queryName, Object[,] parameters)
at CMS.DataEngine.SimpleDataClass.Insert(Boolean getId)
at CMS.DataEngine.SimpleDataClass.Insert()
at CMS.DataEngine.AbstractInfo.Insert()
at CMS.Staging.SynchronizedInfo.Insert()
at CMS.Staging.SynchronizationInfoProvider.SetSynchronizationInfo(SynchronizationInfo synchronization)
at CMS.Staging.SynchronizationInfoProvider.CreateSynchronizationInfo(TaskInfo task, Int32 siteId, Int32 serverId)
at CMS.Staging.SynchronizationInfoProvider.CreateSynchronizationInfo(TaskInfo task, String where)
at CMS.Staging.SynchronizationInfoProvider.CreateSynchronizationInfo(TaskInfo task, Int32 siteId, Int32 serverId)
at CMS.WorkflowEngine.DocumentHelper.LogSynchronization(TreeNode node, TaskTypeEnum taskType, TreeProvider tree, Int32 serverId, Boolean runAsync)

Machine name:
Event URL:
URL referrer:
User agent:

User avatar
Kentico Support
Kentico Support
kentico_zdenekc - 3/15/2011 11:09:21 PM
   
RE:Content Synchronation scheduled task?
Hello,

As stated earlier through email communication, we weren't able to reproduce the issue yet.
We also haven't received any response within the support ticket regarding backups needed for further inspection.
Were you able to resolve the issue or identify the exact circumstances when it happens?

Please let us know if you have any news.
Thank you.

Regards,
Zdenek