Unable to import settings, multilingual site "DocumentCultureVariationDto was not found for node"

Questions
,
1

Hello, it’s me again. Back for more annoying errors and issues.

So I have this Umb13 site, with multiple languages configured, swedish, dutch, danish, norweigan, english and french.

When im doing a usync settings import, im getting this error:

A popup window titled "hassimplehero.config" displays an error message stating that a "DocumentCultureVariationDto" was not found for node 11279 and language 2, with a copy button and a close button. (Captioned by AI)
A popup window titled "hassimplehero.config" displays an error message stating that a "DocumentCultureVariationDto" was not found for node 11279 and language 2, with a copy button and a close button. (Captioned by AI)727×312 15.8 KB

Going to that node in the content tree, for language 2 (which is dutch)

image
image1245×883 93.7 KB

it’s pointing to an unpublished and empty node in the content tree, if I just delete the node and o another settings import, im just getting another node id and so on and so on.

What’s causing this? and how can this be avoided?

Summoning Kevin Juomp into the chat!

2

Did you find a solution ?

3

This is just a wild guess, but are the languages the same between what uSync has and the language in the environment? For instance, is one nl-NL and the other just nl for instance?

4

Hej Luuk

I’m may case it’s because a datatype went not culture to cultured. (From what I can see)

I have changed the language id og does to the matching lang Id..

Have worked before… But not in this case.

5

Creating the node in the db, that’s “missing”
With the missing lang id

INSERT INTO umbracoDocumentCultureVariation (
nodeId,
languageId,
edited,
available,
published,
name
)
VALUES (
22734, – nodeId
2, – languageId
0, – edited (ikke redigeret endnu)
1, – available
0, – published
N’slettes’ – name
);

Also setting the lang id on the datatypes that has changed to culture

UPDATE [umbracoPropertyData] set languageId = 2where propertyTypeId IN (121, 126) AND languageId IS NULL

UPDATE [dbo].[cmsPropertyType] SET variations = 1 WHERE id IN (121, 126)

Fixed it for me

1 Like
6

If someone can give me a reproduceable way to get here, we can look at what we can do in uSync.

uSync doesn’t touch this table directly (uSync does NO database updates, its all via the Umbraco layer)

I have tried various combinations of changing cultured to and from not cultured on properties and doctypes, and deleting/recreating languages, and i can’t get this to happen.

The error is coming from deep inside umbraco when it ‘Renormalizes` the document edited flags, (which is triggered when the doctype changes from cultures to not cultured, but how it gets into the state is the hard part)

It looks like something doesn’t match inside the table at this point you get this then the error is thrown.

I just can’t get the site into this state though any combination of import/sync :frowning:

if you can work out how it gets like this then happy to try and get something in there to resolve it.