MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

The conversion of a varchar data type to a datetime data - Need Urgent Help  (Mono Support )

Viewed 17679 time(s), 10 post(s) 5/13/2013 9:59:49 AMby developer
developer

developer

5/13/2013 9:59:49 AM
Hello all,

please help me with this strange error, which suddenly occurs today morning on my web page. This error occurs only on main page Default.aspx. Other pages run OK. I cannot discover which datetime is wrong. I don't use AdModule on my page. When I inspect DB tables, I see, that all time values are in columns of DateTime datatype, so I don't understand why this error occurs: 

System.Data.SqlClient.SqlException: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Stack Trace:

[SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
System.Data.SqlClient.SqlDataReader.HasMoreRows() +301
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +422
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteMultiRowRetrievalQuery(IRetrievalQuery queryToExecute, IEntityFactory2 entityFactory, IEntityCollection2 collectionToFill, IFieldPersistenceInfo[] fieldsPersistenceInfo, Boolean allowDuplicates, IEntityFields2 fieldsUsedForQuery) +1605
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollectionInternal(IEntityCollection2 collectionToFill, IRelationPredicateBucket& filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) +1260
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) +221
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, Int32 pageNumber, Int32 pageSize) +75
MonoSoftware.LLBLGen.Repository.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, Int32 pageNumber, Int32 pageSize) +114
MonoSoftware.MonoX.Repositories.AdRepository.GetRandomAds(Guid pageId, String keywordFilter, Int32 pageNumber, Int32 pageSize, Int32& recordCount) +3166
MonoSoftware.MonoX.ModuleGallery.AdModule.OnLoad(EventArgs e) +1168
System.Web.UI.Control.LoadRecursive() +95
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2760

Thanks.
This content has not been rated yet. 
165 Reputation 19 Total posts
developer

developer

5/13/2013 10:04:30 AM
We use MonoX v4.5.3206.40
This content has not been rated yet. 
165 Reputation 19 Total posts
khorvat

khorvat

5/13/2013 10:09:13 AM
Are you absolutely sure that you aren't using AdModule ? It seems to me that you have one instance running on that page ?

Can you please send us your Mark-up and Code-behind ?

Regards
This content has not been rated yet. 
15993 Reputation 2214 Total posts
developer

developer

5/13/2013 10:41:41 AM
In Default.aspx markup I don't see any statically inserted AdModule (see attachment). Can you tell me which DB table stores dynamic module bindings? Now I discover also this function anomalia: When I sign into admin modul and change link to any subpage (/contact.aspx), I cannot load Part Catalog - rotating cursor never ends.

I have no Ads defined on portal. Now I define one Ad called "Test", but this action don't solve my problem. Can you tell me which datetime value in which table may cause problems?
This content has not been rated yet. 
165 Reputation 19 Total posts
khorvat

khorvat

5/13/2013 10:50:36 AM
I'll review the attached file, in the meanwhile can you let me know if you have changed the structure of any table in the database (MonoX tables) ?

Regards
This content has not been rated yet. 
15993 Reputation 2214 Total posts
khorvat

khorvat

5/13/2013 10:54:17 AM
Yes there is no statically added AdModules there, to check if there is a dynamic instance running you should go to page administration, find a default page, right click on the page then click on the "Manage Web Parts" there you should see the list of all WebParts registered for that page in all WebPart Zones. You can then remove or reset the part.

Can you please check if you get any Javascript errors ?
Now I discover also this function anomalia: When I sign into admin modul and change link to any subpage (/contact.aspx), I cannot load Part Catalog - rotating cursor never ends.
Regards
This content has not been rated yet. 
15993 Reputation 2214 Total posts
developer

developer

5/13/2013 10:59:58 AM
No, I didn't change your tables. I just add my 2 tables for my module. This web portal runs OK after migration from developers machine to web server for few days without any error. Can you tell me which DB table stores dynamic module bindings? 
This content has not been rated yet. 
165 Reputation 19 Total posts
developer

developer

5/13/2013 11:03:41 AM
When I click on "Manage Web Parts" in page administration I see this message:

There are no personalizable Web parts on this page.
This content has not been rated yet. 
165 Reputation 19 Total posts
developer

developer

5/13/2013 11:11:28 AM
I've inspected JavaScript via Developer Console in Firefox and see this error:
TypeError: a.cookie is undefined jquery-ui-1.8.15.min.js:393
This content has not been rated yet. 
165 Reputation 19 Total posts
khorvat

khorvat

5/13/2013 12:05:35 PM
You don't need to go to DB to clear this table as administration stated that there is no WebParts on that page.
No, I didn't change your tables. I just add my 2 tables for my module. This web portal runs OK after migration from developers machine to web server for few days without any error. Can you tell me which DB table stores dynamic module bindings?
Is there any other error on the page or do you have a reference to jQuery UI ?
I've inspected JavaScript via Developer Console in Firefox and see this error:
TypeError: a.cookie is undefined jquery-ui-1.8.15.min.js:393
Regarding the error below, please send us the error log from ~/MonoX/ApplicationData/Logs/*.log so we can inspect what is causing your modules not to load.
 I cannot load Part Catalog - rotating cursor never ends.



Regards
This content has not been rated yet. 
15993 Reputation 2214 Total posts