Used .netTiers to create a custom app and now we want to implement that with mojoPortal. We converted the CodeSmith generated pages to UserControls and registered those as modules. We then created mojoPortal pages and added the modules to the page. The pages that perform searches and retrieve information for editing work.

The problem is that the Insert and Update functions cause a Sql Timeout error.  The application hangs and an error message like the following is in the mojoPortal system log. We tried using both stored procedures and embedded Sql statements for the .netTiers.

2010-11-23 20:41:52,340 ERROR mojoPortal.Web.Global - 68.190.10.213-en-US - /OrganizationEdit.aspx?OrganizationId=1
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
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 Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command, DbTransaction transaction)
at Catering.DAL.Utility.ExecuteReader(TransactionManager transactionManager, DbCommand dbCommand)
at Catering.DAL.SqlClient.SqlOrganizationProviderBase.GetByOrganizationId(TransactionManager transactionManager, Int32 _organizationId, Int32 start, Int32 pageLength, Int32& count)
at Catering.DAL.Bases.OrganizationProviderBaseCore.GetByOrganizationId(TransactionManager transactionManager, Int32 _organizationId)
at Catering.Web.Data.OrganizationDataSourceView.GetSelectData(Int32& count)
at Catering.Web.Data.BaseDataSourceView`2.GetCachedData(Int32& count)
at Catering.Web.Data.BaseDataSourceView`2.GetEntityList(DataSourceSelectArguments arguments, IDictionary values)
at Catering.Web.Data.BaseDataSourceView`2.ExecuteSelectCore(DataSourceSelectArguments arguments)
at Catering.Web.Data.BaseDataSourceView`2.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
at System.Web.UI.WebControls.FormView.DataBind()
at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
at System.Web.UI.WebControls.FormView.EnsureDataBound()
at System.Web.UI.WebControls.BaseDataBoundControl.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 

Any thoughts to get us going in the right direction?

You are correct. The tools we used want to pull the connection string from the <connectionStrings> section. We added the <connectionStrings> section to the web.config file. It "seems" like it is working because we can pull back information from the application database.  I say "seems" because something is obviously not exactly right because the Insert and Update functions aren't working.

Thanks for the replies.

I was hoping maybe someone had encountered this before. It is not a heavy transaction, just adding/updating 1 record with a minimal number of fields. It seems straightforward enough...

 

 

 

Yes. The table has a primary key and the code is using the same connection string. The app is an existing app that works outside of mojoPortal. We were just converting the application pages to UserControls. We wanted to see if we could combine the features of mojoPortal with the features of some auto-generated code. I think it can be done... just need to get through some of these oddities.

Solved the probkem... Put the code away for awhile, worked on something else, got a good night sleep, re-investigated the web.config file Forgot to to include the EntityTransactionModule configuration in the httpModules section Thanks Joe - onto the next challenge (or stupid mistake)

There might be a bug in the .netTiers framework... but my problem was that I missed copying a configuration setting from the .netTiers generated web.config file to the mojoPortal web.config file. Specifically, it was the EntityTransactionModule configuration in the httpModules section. I have a series of notes on what I did for the integration.. maybe I will turn that into a blog post..

Anyone else interested in something like that?