contact admistrator: failed to retreive data for content
Some content are undable to load on backend.
When i tried to load create/update some content, It shows the error "failed to retreive data for content id 1234".
Log files shows some data conversion error.
#
2014-02-25 14:22:57,204 [6] ERROR umbraco.presentation.publishingService - [Thread 11] Error executing scheduled publishing
System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at Umbraco.Core.Persistence.Database.<Query>d__1c1.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at Umbraco.Core.Persistence.Repositories.ContentRepository.<PerformGetByQuery>d__1f.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext()
at System.Linq.Buffer1..ctor(IEnumerable1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at umbraco.presentation.publishingService.CheckPublishing(Object sender)
Glad to hear you got it sorted. So if I understand correctly you had some double definitions of properties, which already inherited from a parent document type?
Just trying to figure out wether this was related to a possible bug or not.
contact admistrator: failed to retreive data for content
Some content are undable to load on backend. When i tried to load create/update some content, It shows the error "failed to retreive data for content id 1234".
Log files shows some data conversion error.
#
2014-02-25 14:22:57,204 [6] ERROR umbraco.presentation.publishingService - [Thread 11] Error executing scheduled publishing System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at Umbraco.Core.Persistence.Database.<Query>d__1c1.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Umbraco.Core.Persistence.Repositories.ContentRepository.<PerformGetByQuery>d__1f.MoveNext() at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext() at System.Linq.Buffer1..ctor(IEnumerable1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at umbraco.presentation.publishingService.CheckPublishing(Object sender)Did you find a solution for this problem?
Hi Jivan and Amalie
What version of Umbraco 7 are you using when you see this?
/Jan
7.0.4
Ok, and is it content created by the administrator user type or some other user type?
/Jan
Is the adminstrator who created the content in my case
Hi Amalie
Hmm ok - What server and database are you using? And how did you install Umbraco?
I'm thinking this may be an issue with permissions. But I'm not sure.
/Jan
The database is on azure, the website i running local.
Its only pages of a specific doc type
Is there anything special going on on that page? Some custom integration or som weird charachters?
/Jan
No, i just two properties.
And I have deleted them again to see if they coursed the problem
I've solved it.
I had created a new tab in the parent doc type, and when i deleted it everything worked again.
I had other doctypes that had the parent doctype that worked
Hi Amalie
Glad to hear you got it sorted. So if I understand correctly you had some double definitions of properties, which already inherited from a parent document type?
Just trying to figure out wether this was related to a possible bug or not.
/Jan
I created a tab, and then renamed it on the parent.
When i deleted the tab, it appeared in the child doctype twice, one had the original name and the other had the renamed name.
And im sure that i did'nt create them in the child doctype
is working on a reply...