2sic
Data is missing error
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
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.
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?
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.
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
@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.
Check out these sections
There should be a very big log here, which is probably much smaller because something couldn't be accessed:
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.
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.
@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.
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!
We've noticed that this issue is only occurring with the Content App. Could the number of items be causing this?
@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?
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.
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?
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
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!
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.
OK, thanks! We will check how to consistently reproduce the issue and we will be getting back to you.
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?!?
So @marcelom2s issue is not related to @BondForWebSolutions which is probably the DNN issue that 9.13.5 and 9.13.6 do something wrong with DLLs, which should be fixed in the next DNN.
Since I haven't heard from @marcelom2s since October, I'll assume this is closed.
Hello,
I do no know if it is best to open a new issue or not, but I am having the same issue as reported above. For some days I have been having this issue and sometimes, after an APP restart it finally starts working again. In the hosting environment (shared) nothing has changed as far as I can see. But it seems the startup performance is verry bad and the site takes a long time to start after a restart.
Can it be something related to SQL server performance? My Apps have a lot of data. After startup, I can see the APPs and all my content types but none of them have any data. The insights look like this:
Is there any thing else I can check to know with more detail what might be the problem?
Edit: I have multiple APPS and only one (with lots of data) fails to load Itens for all content types. All other apps are working fine.
Edit 2: After a long time and about 20 application restarts the app was able to load content type data and now is working as expected.
@miguelvaz78 We've managed to reproduce this issue while trying to import large batches of data a couple of months ago, so yeah, everything points to this issue being related to database performance.
@vandersonpessoa thanks for the fast feedback. Is there any way of configuring the system so it does not depend on full data load for large content types when starting up? What would be the workaround or your best practices for this scenarios?
@miguelvaz78 Not that I'm aware of. @iJungleboy Can you reopen the issue and help with this?
@miguelvaz78 please open a new issue, with info as to the version you're using etc. since your problem may be different from the similar problem a year ago.