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.

Some pages give an error even after applying SQL 2012 scripts.  (Mono Support )

Viewed 22486 time(s), 2 post(s) 4/27/2014 8:09:54 AMby Terfex

Related topics

Terfex

Terfex

4/27/2014 8:09:54 AM
I after applying the SQL scripts for SQL 2012, after getting these errors in this post, I'm still seeing some errors which appear to be SQL related as well.
Here's a few instances when the errors occur:

 - Accessing the Social Dashboard: /MonoX/Pages/SocialNetworking/Dashboard.aspx
Security error.
at MonoSoftware.MonoX.BasePage.OnInit(EventArgs e) at MonoSoftware.MonoX.Pages.SocialNetworking.Dashboard.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 - Accessing the site wall on the mobile site: /MonoX/Mobile/Wall.aspx
Object reference not set to an instance of an object.
at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.Comments.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at MonoSoftware.MonoX.Utilities.MonoXUtility.RenderMonoXTemplate(Control templateContainer, StringBuilder sb, Hashtable tagObjectMappingCollection, VelocityContext velocityContext, VelocityEngine velocityEngine) at MonoSoftware.MonoX.BasePart.RenderTemplatedPart(Control templateContainer, String templateName, StringBuilder sb, Hashtable tagObjectMappingCollection, VelocityContext velocityContext, VelocityEngine velocityEngine) at MonoSoftware.MonoX.BasePart.RenderTemplatedPart(Control templateContainer, String templateName, String template, Hashtable tagObjectMappingCollection, VelocityContext velocityContext, VelocityEngine velocityEngine) at MonoSoftware.MonoX.BasePart.RenderTemplatedPart(Control templateContainer, String templateName, String template, Hashtable tagObjectMappingCollection, VelocityContext velocityContext) at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.WallNotes.lvItems_OnItemDataBound(Object sender, ListViewItemEventArgs e) at System.Web.UI.WebControls.ListView.OnItemDataBound(ListViewItemEventArgs e) at System.Web.UI.WebControls.ListView.CreateItemsWithoutGroups(ListViewPagedDataSource dataSource, Boolean dataBinding, InsertItemPosition insertPosition, ArrayList keyArray) at System.Web.UI.WebControls.ListView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at System.Web.UI.WebControls.ListView.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at System.Web.UI.WebControls.ListView.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.DataBind() at MonoSoftware.MonoX.Utilities.PagerUtility.BindPager(Pager pager, PagerAction bindDelegate, Control pagedControl, Object dataSource, Int32 pagerVirtualCount, Control warningControl) at MonoSoftware.MonoX.Utilities.PagerUtility.BindPager(Pager pager, PagerAction bindDelegate, Control pagedControl, Object dataSource, Int32 pagerVirtualCount) at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.WallNotes.BindData() at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.WallNotes.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 - Accessing Messages: /MonoX/Pages/SocialNetworking/InMail.aspx
Security error.
at MonoSoftware.MonoX.BasePage.OnInit(EventArgs e) at MonoSoftware.MonoX.Pages.SocialNetworking.InMail.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 - Viewing your friends list: profile-friends/(user's name)/
An exception was caught during the execution of a retrieval query: Could not find stored procedure 'dbo.FriendSuggestion'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.
at SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchDataReader(IRetrievalQuery queryToExecute, CommandBehavior readerBehavior) at MonoSoftware.MonoX.Repositories.UserRepository.GetUserConnectionTypedViewEntries(Guid userId, String searchTerm, Boolean isRandom, Int32 numberOfLevels, Int32 pageNumber, Int32 pageSize, Int32& recordCount) at MonoSoftware.MonoX.ModuleGallery.SocialNetworking.FriendSuggestionsList.BindData() at MonoSoftware.MonoX.Pages.Profile.MyFriends.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Could not find stored procedure 'dbo.FriendSuggestion'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior)
 - Submitting a wall post both on my own and another user's
This event has been logged and will be addressed by the maintenance department. We appreciate your patience.To continue working with the application please click here
 - Submitting a comment.
This event has been logged and will be addressed by the maintenance department. We appreciate your patience.To continue working with the application please click here
 - Sending a message from the contact form results in no message sent.

It seems some script needs to be run for the social networking side but I can't seem to find where the script is.
This content has not been rated yet. 
71 Reputation 7 Total posts
khorvat

khorvat

4/28/2014 8:43:32 AM
Hi,

  can you please let us know if you have upgraded only runtime assemblies (bin folder) or did you upgrade your markup too ?

- All security errors aren't related to upgrade or SQL scripts but to currently authenticated user so please check if you have permissions in MonoX administration -> Page Management.
- "It seems some script needs to be run for the social networking side but I can't seem to find where the script is." MonoX comes with the upgrade scripts that can be used to upgrade your database to the latest version. You can find the scripts in the /MonoX/Installer/Sql/UpgradeScripts (exceptions like this one "Could not find stored procedure 'dbo.FriendSuggestion'." will be resolved by upgrading)
- for the rest of the issues can you please provide us with the MonoX log files "/MonoX/ApplicationData/Logs"

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