Data is Null. This method or property cannot be called on Null values.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlNullValueException: Data is Null. This method or property cannot be called on Null values.]
System.Data.SqlClient.SqlBuffer.get_Int32() +5056576
System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i) +38
umbraco.DataLayer.RecordsReaderAdapter`1.GetInt(String fieldName) +36
umbraco.cms.businesslogic.web.Document.PopulateDocumentFromReader(IRecordsReader dr) +545
umbraco.cms.businesslogic.web.Document.GetChildrenForTree(Int32 NodeId) +506
umbraco.cms.presentation.Trees.BaseContentTree.Render(XmlTree& Tree) +80
umbraco.loadContent.Render(XmlTree& tree) +50
umbraco.presentation.webservices.TreeDataService.LoadTree(TreeRequestParams treeParams) +157
umbraco.presentation.webservices.TreeDataService.GetXmlTree() +198
umbraco.presentation.webservices.TreeDataService.ProcessRequest(HttpContext context) +85
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +100
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1022
Could you share a bit more information about the solution? When did the error start happening? Has there been done any custom integration using the API's etc.?
The solution is an intranet with a news administration module that uses the umbraco api.
I made some changes to this module, and testing these changes made the module crash during the saving opereation of a newly created news topic.
The problem was easyly solvedm and the newmodule works fine now, but the above mentioned crash left my umbraco content tree out off sync in some way.
Saving news with the newsmodule does not affect the umbraco.config file, so i figure the problem must be found somwhere in one of the umbraco tables, but i just cannot figure out where.
Content tree nodes do not load
I have a problem that makes /umbraco/webservices/TreeDataService.ashx crash when loading the content tree in the umbraco UI!
umbraco v 4.5.2 (Assembly version: 1.0.3891.20719)
Any suggestion to where and in which tables i should look for the cause of this error would be highly appreciated
I tracked the error through the log table to:
http://intradevbo/umbraco/webservices/TreeDataService.ashx?rnd=b72caa0abc0143e19f631a18edb557a8&id=1106&treeType=content&contextMenu=true&isDialog=false&rnd2=67.1
Which returns the following error
Server Error in '/' Application.
Data is Null. This method or property cannot be called on Null values.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1022
Hi Bo and welcome to our :)
Could you share a bit more information about the solution? When did the error start happening? Has there been done any custom integration using the API's etc.?
/Jan
Hi Jan!
The solution is an intranet with a news administration module that uses the umbraco api.
I made some changes to this module, and testing these changes made the module crash during the saving opereation of a newly created news topic.
The problem was easyly solvedm and the newmodule works fine now, but the above mentioned crash left my umbraco content tree out off sync in some way.
Saving news with the newsmodule does not affect the umbraco.config file, so i figure the problem must be found somwhere in one of the umbraco tables, but i just cannot figure out where.
/Bo
is working on a reply...