Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first. View modes: 
User avatar
Member
Member
joeh42 - 8/30/2011 8:51:53 AM
   
How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
When I try to move an item using content staging, I get the error below. How can I resolve this error?
Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.

Create Workflow scope '/Home/Welcome' CREATEOBJ

ClassName ID CodeName SiteName ParentID Info
cms_site 3 MySite

Workflow scope

Field name Value
ScopeID
6
ScopeStartingPath
/Home/Welcome
ScopeWorkflowID
42
ScopeSiteID
3
ScopeGUID
5680bc42-e615-40f3-a903-51a5740d2b2d
ScopeLastModified
8/18/2011 1:52:48 PM

User avatar
Kentico Developer
Kentico Developer
kentico_ivanat - 8/31/2011 5:53:20 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi,

exceptions of this kind may happen when the target parent object doesn't exist, e.g. in import process, when the parent object in target site is missing or has different ID.

Could you please check if the parent of synchronized node already exists on the target server?

Best regards,
Ivana Tomanickova

User avatar
Member
Member
joeh42 - 8/31/2011 8:06:00 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi Ivana,

How do I identify the parent of the synchronized node, in this case the parent of the workflow?

The workflow already exists on the target server, and so do the nodes Home and Welcome.

Thanks,
Joe

User avatar
Kentico Developer
Kentico Developer
kentico_ivanat - 9/1/2011 12:30:47 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi,

could you please check if you are using the same workflow on the source and target server?

Have you synchronized all of previous tasks that could be related with the problematic one?

Could you please share the list of all tasks in the queue?

Thank you for information.

Best regards,
Ivana Tomanickova

User avatar
Member
Member
joeh42 - 9/1/2011 8:33:17 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
I've cleaned up the content staging queue, so the only object in it right now is this failed one. If I had deleted the create task by accident, how would I fix it?

The workflow exists in both our dev and staging environments, so I know that I promoted it through content staging

User avatar
Kentico Developer
Kentico Developer
kentico_ivanat - 9/2/2011 6:42:07 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi,

could you please try to delete workflow scope /Home/Welcome and then create it again?

When you created the workflow on the live site. Have you selected the same culture in the Cultures tab?

Would it be possible to grant us with an access to your dev/live site so we could check your settings. If so please send an email to support@kentico.com.

Thank you.

Best regards,
Ivana Tomanickova

User avatar
Member
Member
joeh42 - 9/2/2011 12:06:17 PM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Deleting the item and recreating it worked.

Is there anything else I should do in troubleshooting next time?

I was very confused by the reference to dependent objects. Are they documented in the database somewhere?

User avatar
Kentico Developer
Kentico Developer
kentico_ivanat - 9/5/2011 5:19:11 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi,

it is important to synchronize all tasks that could be related to the issue. For example a parent document if you are synchronizing its child, publish parent document if you would like to synchronize its child, etc.

Unfortunately, the documentation about this topic is missing. I have created a requirement and a Troubleshooting section should be added into documentation of 7.0 version. Thank you for suggestion.

Best regards,
Ivana Tomanickova

User avatar
Member
Member
ML - 2/6/2013 7:27:22 PM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi,

I have a similar problem in synchronizing content from one Kentico website to another on the same server. The website is the sample out-of-the-box Corporate website. I can sync content changes successfully from Dev to Staging, but when I try to sync from Staging to Dev, I got "Synchronization server error: Exception occurred: Object reference not set to an instance of an object."
I am using Kentico 7.0 hotfix 18.

Could Kentico experts please advise how I can trace to the root of this issue.

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 2/7/2013 1:05:53 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi,

Could you please check your settings according to the following chapter in the Developers Guide: Bi-directional staging.

Did you also renamed the Microsoft.Web.Services3.dll.rename file in both instances?

Best regards,
Martin Danko

User avatar
Member
Member
ML - 2/18/2013 1:42:14 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi kentico_martind2,

Yes, I have followed the instructions from the Developers Guide.
Forget about bi-directional staging for now, I am now trying to do one direction content staging using v7 hot fix 19 and I am getting the error:
"Synchronization server error: Exception occurred: Object reference not set to an instance of an object."

Please advise.

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 2/26/2013 1:17:12 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi,

There was a bug with a content staging. could you please try to install the latest hotfix? It should fix your issue.

Best regards,
Martin Danko

User avatar
Member
Member
seanbun - 3/14/2013 10:36:38 PM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hey Martin,

I have recently worked on a project and upgrade it from 5.5 to 6 with latest hotfix v.58. When I tried to content staging content, I have "Synchronization failed, see synchronization log for details.: Object reference not set to an instance of an object." error.

I used KIM for the upgrade process. It was smooth and no error found and there is no problem to content staging global objects but not documents. Do you have any idea?

Cheers,
Matt

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 3/19/2013 5:58:16 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi Matt,

Could you please tell me which version of .NET are you running with this instance? Also please check the Event log for more details.

Best regards,
Martin Danko

User avatar
Member
Member
seanbun - 4/8/2013 10:41:46 PM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
I work on .Net 4.0. There is no clue on the Event log.

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 4/9/2013 9:09:58 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hello,

Check also the synchronization log which can be found in CMS Desk --> Tools --> Staging for the given task that has a Failed Result. You can find there more details related to every task. Synchronizing the content - All tasks tab, have you also installed any hotfixes?

Best regards,
Martin Danko

User avatar
Member
Member
swetag-clavax - 4/17/2013 9:24:56 AM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi All,

I am trying to synchronize the ecommerce_customer object, before doing this I have successfully synchronize the CMS_USER data.
I have the unique username on behalf of which, first I am creating a row in CMS_USER table and then trying to sync the COM_CUSTOMER table and trying to fetch the User Id against that username and setting the User Id to the COM_CUSTOMER -> CustomerUserID field but when clicking to Sync button the task fails and giving me the below error.
[BaseIntegrationConnector.ProcessExternalTasks]: Error processing task. Original message: [SyncHelper.UpdateObject]: Cannot translate columns 'CustomerUserID', import the dependent objects first.

I would appreciate any help.

Thanks,
Sweta

User avatar
Member
Member
kentico_sandroj - 4/27/2013 7:24:39 PM
   
RE:How to resolve Synchronization server error: Exception occurred: [SyncServer.UpdateObject]: Cannot translate columns 'ScopeWorkflowID', import the dependent objects first.
Hi Sweta,

This object is using/bound to some other objects - if you try to sync it to an instance without these objects you will get an error since those objects are not there. I would recommend using the Site Manager -> Sites -> Export objects link to export all things from given objects category.

Documentation on exporting and importing objects.

Please let us know if you have additional questions.

Thanks,
Sandro