We are trying to use the "View entries" option from umbraco on the forms we have created. When we click this option, an alert box is shown with the error:
"DataTables warning (table id = 'entriesf1a5cde185e54ba7b0241be2689ec217'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error."
This happens with our current forms and when creating a test form with no data from the list of available templates.
Thanks! You too. FYI. We may have found part of the issue. It is giving us an error about permissions to access random DLL files in the C:\WINDOWS\TEMP directory. I'm looking into that now.
It looks like that was the issue. As far as permissions, should the app pool have to be added to permissions for this folder? Do we know why this would be required? The files being created include filenames such as: isjpayga.dll, isjpayga.pdb.
Aren't pdb files used for debugging?
SOLUTION: Added read/write permissions to C:\WINDOWS\Temp
Tim, we've just run into the same error - permissions again I think, although our scenario is a little different...
We run the app pool under a real local user account, and because of another component in the site, require Load User Profile to be set to true. This means that the temp folder becomes C:\Users\USERNAME\AppData\Local\Temp.
I'm seeing exceptions as follows;
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 08/10/2013 14:45:16
Event time (UTC): 08/10/2013 14:45:16
Event ID: bd15aa8754d14e3e87d90945a909a5b3
Event sequence: 6281
Event occurrence: 23
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/29/ROOT-1-130256569459084000
Trust level: Full
Application Virtual Path: /
Application Path: \\file-1\USERNAME\websites\new.USERNAME.com\
Machine name: WEB14
Process information:
Process ID: 4952
Process name: w3wp.exe
Account name: WEB14\USERNAME
Exception information:
Exception type: FileLoadException
Exception message: Could not load file or assembly 'file:///C:\Users\USERNAME\AppData\Local\Temp\noaxwnc2.dll' or one of its dependencies. Access is denied.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyName assemblyRef, Evidence assemblySecurity)
at System.CodeDom.Compiler.CompilerResults.get_CompiledAssembly()
at System.Xml.Xsl.Xslt.Scripts.CompileAssembly(List`1 scriptsForLang)
at System.Xml.Xsl.Xslt.Scripts.CompileScripts()
at System.Xml.Xsl.Xslt.QilGenerator.Compile(Compiler compiler)
at System.Xml.Xsl.Xslt.QilGenerator.CompileStylesheet(Compiler compiler)
at System.Xml.Xsl.Xslt.Compiler.Compile(Object stylesheet, XmlResolver xmlResolver, QilExpression& qil)
at System.Xml.Xsl.XslCompiledTransform.CompileXsltToQil(Object stylesheet, XsltSettings settings, XmlResolver stylesheetResolver)
at System.Xml.Xsl.XslCompiledTransform.LoadInternal(Object stylesheet, XsltSettings settings, XmlResolver stylesheetResolver)
at System.Xml.Xsl.XslCompiledTransform.Load(XmlReader stylesheet, XsltSettings settings, XmlResolver stylesheetResolver)
at Umbraco.Forms.Data.XsltHelper.TransformXML(XmlNode xml, String XsltFile, Dictionary`2 settings)
at Umbraco.Forms.UI.Webservices.Records.ReturnRecords(Guid id, DateTime date, FormState state, Int32 startIndex, Int32 lenght, Sorting sortOrder)
at Umbraco.Forms.UI.Webservices.Records.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at umbraco.BasePages.BasePage.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Request information:
Request URL: http://new.USERNAME.com/umbraco/plugins/umbracoContour/webservices/records.aspx?guid=0413edc6-4a8b-4b83-9910-b271d5e24e32
Request path: /umbraco/plugins/umbracoContour/webservices/records.aspx
User host address: 10.190.254.5
User:
Is authenticated: False
Authentication Type:
Thread account name: WEB14\webservers
Thread information:
Thread ID: 35
Thread account name: WEB14\webservers
Is impersonating: False
Stack trace: at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyName assemblyRef, Evidence assemblySecurity)
at System.CodeDom.Compiler.CompilerResults.get_CompiledAssembly()
at System.Xml.Xsl.Xslt.Scripts.CompileAssembly(List`1 scriptsForLang)
at System.Xml.Xsl.Xslt.Scripts.CompileScripts()
at System.Xml.Xsl.Xslt.QilGenerator.Compile(Compiler compiler)
at System.Xml.Xsl.Xslt.QilGenerator.CompileStylesheet(Compiler compiler)
at System.Xml.Xsl.Xslt.Compiler.Compile(Object stylesheet, XmlResolver xmlResolver, QilExpression& qil)
at System.Xml.Xsl.XslCompiledTransform.CompileXsltToQil(Object stylesheet, XsltSettings settings, XmlResolver stylesheetResolver)
at System.Xml.Xsl.XslCompiledTransform.LoadInternal(Object stylesheet, XsltSettings settings, XmlResolver stylesheetResolver)
at System.Xml.Xsl.XslCompiledTransform.Load(XmlReader stylesheet, XsltSettings settings, XmlResolver stylesheetResolver)
at Umbraco.Forms.Data.XsltHelper.TransformXML(XmlNode xml, String XsltFile, Dictionary`2 settings)
at Umbraco.Forms.UI.Webservices.Records.ReturnRecords(Guid id, DateTime date, FormState state, Int32 startIndex, Int32 lenght, Sorting sortOrder)
at Umbraco.Forms.UI.Webservices.Records.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at umbraco.BasePages.BasePage.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Custom event details:
However, using SysInterals ProcMon, I can see noaxwnc2.dll (from the example above) getting built, written, but ACCESS_DENIED when trying to be opened, then deleted OK - all as the username shown above.
Any thoughts? What's actually happening at this point - seems to be a bunch of compilation going on?
The permissions are Full Control for the relevant username, and the dll open is using that username, according to ProcMon. It's very odd - the worker process creates the file during the compilation, closes it, then tries to open it (to presumably run it), and hits an Access Denied.
This is obviously a Windows/environment problem, rather than Contour per-se, but frustrating!
My website gets the same error, it pops up in an alert right away when i select Entries.
Message:
DataTables warning (table id = 'entriesae3e6832e10c4cacbe6c6f7858ff9980'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.
I just ugraded my site from Umbraco 4.11 to 6.1.6
and contour from 1.1.10 to 3.0.17
I havent used contour for a while, but now i want to, and it works ok, and i get my email as set up in workflow, but when i click entries i got this:
My website is on unoeuro.com webhost, so i can't check the rights etc.
By the way, thanks to Sebastian for a great Umbraco 6 Level 2 course in copenhagen, that was really nice to get updated.
For the record, I've been able to resolve this, as it was a "simple" permissions problem...
Our environment is possibly a little odd because of the need to run the worker process under a local (profile-loading) user account, combined with some funky permissions required as the webroot is on a network share. As a result, the temp DLLs were being created under one users \AppData\Local\Temp\ folder (WEB14\USERNAME), but the runtime was trying to read and execute them as a different user (WEB14\webservers).
My 'quick-fix' for now has been to grant Full Control permissions on that folder (and path leading to it) to both users - as always, the real error was in the Event Log all along ('access denied'), it's just spotting it that's the problem!
JSON data from server could not be parsed error.
We are trying to use the "View entries" option from umbraco on the forms we have created. When we click this option, an alert box is shown with the error:
"DataTables warning (table id = 'entriesf1a5cde185e54ba7b0241be2689ec217'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error."
This happens with our current forms and when creating a test form with no data from the list of available templates.
Comment author was deleted
Hey Anthony,
Mind telling me the Umbraco + Contour version you are running + also the browser you are using
Thanks :)
Absolutely. We are on Umbraco version 6.0.5, Contour 3.0.11, and this is happening across all browsers. IE 10, Firefox 22, and Chrome 28.0.1500.71.
Any input is appreciated!
-Anthony
Comment author was deleted
Ok haven't seen this error before, any chance I can take a look at the site, you can mail details to tg at umbraco dot com
Regards,
Tim
Hey, Tim. Did you get my message with info on the site? Thanks again for your help and input.
Comment author was deleted
Yeah got the email will take a look on monday have a good weekend :)
Thanks! You too. FYI. We may have found part of the issue. It is giving us an error about permissions to access random DLL files in the C:\WINDOWS\TEMP directory. I'm looking into that now.
It looks like that was the issue. As far as permissions, should the app pool have to be added to permissions for this folder? Do we know why this would be required? The files being created include filenames such as: isjpayga.dll, isjpayga.pdb.
Aren't pdb files used for debugging?
SOLUTION: Added read/write permissions to C:\WINDOWS\Temp
Comment author was deleted
Ah sweet glad it's working now :)
Tim, we've just run into the same error - permissions again I think, although our scenario is a little different...
We run the app pool under a real local user account, and because of another component in the site, require Load User Profile to be set to true. This means that the temp folder becomes C:\Users\USERNAME\AppData\Local\Temp.
I'm seeing exceptions as follows;
However, using SysInterals ProcMon, I can see noaxwnc2.dll (from the example above) getting built, written, but ACCESS_DENIED when trying to be opened, then deleted OK - all as the username shown above.
Any thoughts? What's actually happening at this point - seems to be a bunch of compilation going on?
Phil
Comment author was deleted
Yeah it has something todo with using xslt in Contour, it gens temp assemblies so the permissions for that folder need to be ok
The permissions are Full Control for the relevant username, and the dll open is using that username, according to ProcMon. It's very odd - the worker process creates the file during the compilation, closes it, then tries to open it (to presumably run it), and hits an Access Denied.
This is obviously a Windows/environment problem, rather than Contour per-se, but frustrating!
Phil
Comment author was deleted
Yeah sorry about that :(, will see if I can find some details on it
My website gets the same error, it pops up in an alert right away when i select Entries.
Message:
DataTables warning (table id = 'entriesae3e6832e10c4cacbe6c6f7858ff9980'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.
I just ugraded my site from Umbraco 4.11 to 6.1.6
and contour from 1.1.10 to 3.0.17
I havent used contour for a while, but now i want to, and it works ok, and i get my email as set up in workflow, but when i click entries i got this:
My website is on unoeuro.com webhost, so i can't check the rights etc.
By the way, thanks to Sebastian for a great Umbraco 6 Level 2 course in copenhagen, that was really nice to get updated.
Comment author was deleted
@brian make sure to clear your browser cache after an update might be running a combination of old scripts with new
Also can you try creating a new test form and see if you also get the error when viewing entries on that one
For the record, I've been able to resolve this, as it was a "simple" permissions problem...
Our environment is possibly a little odd because of the need to run the worker process under a local (profile-loading) user account, combined with some funky permissions required as the webroot is on a network share. As a result, the temp DLLs were being created under one users \AppData\Local\Temp\ folder (WEB14\USERNAME), but the runtime was trying to read and execute them as a different user (WEB14\webservers).
My 'quick-fix' for now has been to grant Full Control permissions on that folder (and path leading to it) to both users - as always, the real error was in the Event Log all along ('access denied'), it's just spotting it that's the problem!
Phil
Comment author was deleted
Sweet thanks for posting the fix :)
is working on a reply...