Restore Data Error

  • 145Views
  • Last Post 2 days ago
0
votes
Joan Bautista posted this 13 April 2021

Hi,

Currently Skyvia is connected to Salesforce Marketing Cloud. Backup is running okay. However, when I'm trying to restore records from a backup an error occured: 

Here is the backup records:

And this is the Data Extension's fields:

It seems that the restore does not map correctly the columns to the data extension? If this is the case, how can I correct the mapping. Hope you can help. 

Thanks,

 

Joan

Order By: Standard | Newest | Votes
0
votes
Dmitriy Muzurov posted this 13 April 2021

Hi Joan,

Thank you for the screenshots.

Please let us know if your data extension has any subscriber relationship.

We are looking forward to hearing from you.

0
votes
Joan Bautista posted this 5 weeks ago

Hi Dmitriy,

I changed my data extension to sendable and updated the test records that exists in All Subscribers, however, the same error still occurred when I try to restore it using Insert operator. Update and Delete works perfectly though.

Regards,

Joan

0
votes
Dmitriy Muzurov posted this 5 weeks ago

Hi Joan,

Thank you for reply.

Please let us know if your data extension has subscriber relationship:

Or it's not related to Subscribers. We will test it from our side.

0
votes
Joan Bautista posted this 4 weeks ago

Hi Dmitriy,

Yes, DE has subscriber relationship 

Error is the same when my DE is with or without subscriber relationship..

Regards,

Joan

0
votes
Joan Bautista posted this 4 weeks ago

Hi Dmitriy,

Any update on this?

Thanks,

Joan

0
votes
Nataliia Nikulina posted this 4 weeks ago

Hello Joan,

Thank you for contacting the Skyvia team.

The issue seems to be related to the fact that the metadata cache of your connection is outdated.

 Please follow the steps below to overcome the issue:

 - Clear metadata cache of your Salesforce Marketing Cloud connection and save connection;

- Create a new backup and launch it;

- Try to restore backed-up data.

Additionally please find a couple of guides to learn more:

https://docs.skyvia.com/connections/metadata-cache.html

https://docs.skyvia.com/connectors/cloud-sources/exacttarget_connections.html

Please update us about the results.  

Kind regards, Nataliia

0
votes
Joan Bautista posted this 3 weeks ago

Hi Nataliia,

I cleared the cache and created a new connecttion and backup objects but still I encountered the same error.

Best Regards,

Joan

0
votes
Nataliia Nikulina posted this 3 weeks ago

Hello Joan,

 

Thank you for the email.

 

We were able to reproduce the issue on our side and will let you know

as soon as it is fixed.

 

Kind regards,

Nataliia

0
votes
Nataliia Nikulina posted this 3 weeks ago

Hello,  

 

Additionally please note that we have fixed the underlying issue and will update you when the fix is available. In the meantime, as a workaround you can follow the steps below:

 

go to UI of your Salesforce Marketing cloud account
Clear the Primary Key check box for the Subscriber Key row
–°lear Metadata cache of the connection  

 

The above steps should fix the issue.   Kind regards, Nataliia

0
votes
Joan Bautista posted this 2 weeks ago

Hi Nataliia,

I uncheck the Primary Key in our Data Extension in Marketing Cloud and this error occured when I tried to restore the data.

Best Regards,

Joan

0
votes
Joan Bautista posted this 2 weeks ago

Hi Nataliia,

Any update on this?

Thanks,

Joan

0
votes
Nataliia Nikulina posted this 2 weeks ago

Hello Joan,  

 

Thank you for contacting Skyvia Support team.  

We would suggest that you wait until the app is updated and changes are available to you.   

We will let you know once this is done.  

 

Kind regards, Nataliia

0
votes
Joan Bautista posted this 2 weeks ago

Hi Nataliia,

Thanks for this information. May we know when the target date for this update? 

Many Thanks,

Joan

0
votes
Nataliia Nikulina posted this 2 days ago

Hello Joan,  

Thank you for the email.  

We expect the changes to be available in a week.  

Kind regards,

Nataliia

Close