Data is missing error

[vandersonpessoa]

I'm submitting a

[x] bug report

...about

[x] Content Types or data management
[x] DNN parts

Current Behavior / Expected Behavior

The 2sxc modules once in a while throw the following error:

Error: System.Exception: Data is missing. This is common when a site is copied but the content / apps have not been imported yet - check http://2sxc.org/help?tag=export-import

Clearing the site cache, recycling the app pool and restarting the site do not typically resolve this issue, but usually it is resolved by the next day.

Instructions to Reproduce the Problem

Your environment

• 2sxc version(s): 16.7.0
• Browser: all
• DNN: 9.11.00
• Hosting platform: IIS
• Language: any/all

[iJungleboy]

This is hard to guess. I suggest you upgrade to the latest LTS for now (17.09).

I'll close this now, if after the upgrade you still experience something similar, we'll reopen the issue.

[vandersonpessoa]

Upgrading to 17.09 didn't fix the issue

[vandersonpessoa]

@iJungleboy Could you please reopen the issue?

[vandersonpessoa]

We migrated our database to Azure, and it seems this issue is occurring more frequently since then. Could the migration be causing this? What other details can we provide you to help investigate this error?

[iJungleboy]

Something is obviously wrong when loading the data, but I can't actually debug it without seeing it.

Basically I suggest you check the insights next time this happens. There is a lot of information about loading the data being logged, so if it fails to load there is probably a message that a folder wasn't accessible or something.

[vandersonpessoa]

I've checked the module logs and found the error, but not exactly the cause.

Is there any other log that could have relevant information about this? Please see attached the complete log file for reference (it's an html page)
LogsError.txt

[iJungleboy]

@vandersonpessoa The problem is not in the page which loads, but earlier.

Something must break loading the initial data. There are other sections in the log showing global data being loaded etc. Please go through that to find out more.

You can see on a working system that there is one section in the logs which is huge. That's the one loading all the default schemas etc. and almost certainly the part which seems to fail randomly on your system.

[iJungleboy]

Check out these sections

There should be a very big log here, which is probably much smaller because something couldn't be accessed:

[vandersonpessoa]

The boot-log section doesn't exist here:

I've looked into the global-start-up, but the file isn't much smaller than the one you mentioned:

Also, at first sight I couldn't see much difference comparing it to a log from a site that is working properly. Please see attached and let me know your thoughts.

global-start-up.txt

[6TELOIV]

We've noticed this issue occur sometimes if you make a change to web.config. Once IIS "reloads", 2sxc data gets out of sync. Restarting the server has always fixed the issue for us.

Based on the nature of the issue, it seems to be a race condition, making it hard to reproduce.

[vandersonpessoa]

@6TELOIV Thank you for your input, but a web.config update doesn't seem to be the thing that is causing the issue in our environment. It occurs even without recent changes in web.config. Also, restarting the server or IIS doesn't fix the site here.

[6TELOIV]

At the bottom of your log, I see that it says "Found 0 Licenses"; did you have your installation verified on patrons.2sxc? I think this log indicates that somehow the connection isn't present. Other than that, I didn't find anything significantly different between your log and mine for an operational 2sxc installation.

Also not sure how a license presence would cause this error, especially at the random rate you describe. Just throwing out ideas!

[vandersonpessoa]

No, it is not registered on patrons

[vandersonpessoa]

We've noticed that this issue is only occurring with the Content App. Could the number of items be causing this?

[iJungleboy]

@vandersonpessoa this is special.

Can you confirm that when this happens, it only happens on this app, and the others work? This could give us a clue as to where to look, but I must be very sure that this is the case?

[vandersonpessoa]

Yes, the other apps keep working

[iJungleboy]

This is helpful, but still strange.

Internally large data amounts are loaded batchwise, to prevent SQL problems - usually batches of 5000 items. But what would be strange is that it sometimes works, and sometimes fails.

If your description is correct, then the logs showing loading of that specific app should give more info (in your case Zone 2 App 2). I believe it logs the clustering and loading, and so it should also show SQL problems or something.

[iJungleboy]

Note that we just released 18.01 last week, and it should show more debugging when loading the chunks.

Any chance you could test that?

[vandersonpessoa]

Sure, we've just installed the 18.01 version in one of our environments. Please see attached the boot-log and global-start-up log files.

global-start-up.txt
boot-log.txt

[marcelom2s]

is there any type of paid support that you guys can help us to understand what is going on and fix it? We are willing to do it if that's an option to resolve this issue. Thanks!

[iJungleboy]

Sure. I think we'll need about 2h to evaluate this, and depending on the root cause it's anywhere from 0 - 4h or so to resolve. Head over to https://2sxc.org/en/contact to submit your request and to https://2sxc.org/en/contact/paypal to pay for 2h, then we'll setup a telco.

[marcelom2s]

OK, thanks! We will check how to consistently reproduce the issue and we will be getting back to you.

[BondForWebSolutions]

Had this too. Also on Azure.
The result was we had to restore a backup.

Upgrades also did not work:
https://stackoverflow.com/questions/78401994/error-with-2sxc-apps-on-site-since-this-morning

And I see one other with the same kinds of issues:
https://stackoverflow.com/questions/77153567/all-2sxc-data-missing

Perhaps Azure related?!?