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.

Install Error, current version 4_5_3057_40 (Closed) (Mono Support )

Viewed 87247 time(s), 23 post(s) 10/23/2011 2:31:47 AMby Kiamori
khorvat

khorvat

10/26/2011 10:38:31 AM
Hi,

you can find the CreateDatabase.sql and import scripts attached to this post. You need to extract them to the fresh MonoX unzipped package and locations are:

1. /MonoX/Installer/SQL/CreateDatabase.sql
2. /MonoX/Installer/SQL/Import/*.sql

After you do that you can setup the IIS and start the installation process. Let us know if this has fixed the issue you are having ?

Note: We suspect the this is an issue related to SQL script was to big so we have splitted into smaller batches. 

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

Kiamori

10/23/2011 2:31:48 AM
I see another thread with the same error, however I have tried the suggested solution(s) and I am still getting the same error in trying to install the monoX platform on IIS 7.5

current version 4_5_3057_40

Here is the errors with timestamps:
2011-10-22 21:21:30Z: Importing "LocalizationSource" ...
2011-10-22 21:26:32Z: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Inserting values into [dbo].[LocalizationSource]

Any ideas?

This content has not been rated yet. 
61 Reputation 10 Total posts
denis

denis

10/23/2011 3:54:14 PM
I assume that you were refering to this thread. Are you also trying to install MonoX in a shared hosting environment? Could you send us the web.config file?
This content has not been rated yet. 
7207 Reputation 956 Total posts
Kiamori

Kiamori

10/23/2011 9:59:59 PM
Well that is the one I thought I made a link to in my post, however it does not seem to work today...

Why does it matter if this is a shared SQL or not? It should work reguardless of the fact. I checked the server status and their are no problems what so ever as far as load, network or server resources.
I first tried to install using the installer, without making any changes directly to the web.config file as noted in the install instructions when that did not work I did not make any changes other than the constring, which is as follows:

<add name="LocalSqlServer" connectionString="Data Source=ServerIP;uid=UserID;pwd=Password;database=DatabaseName;Connect Timeout=600;" providerName="System.Data.SqlClient"/>
<add name="ADConnectionString" connectionString="LDAP://server.domain" />

I also tried as stated in the post you referanced.

<add name="LocalSqlServer" connectionString="Server=ServerIP;Database=DatabaseName;uid=UserID;Pwd=Password;Connect Timeout=600;" providerName="System.Data.SqlClient" />
< add name="ADConnectionString" connectionString="Server=ServerIP;Database=DatabaseName;uid=UserID;Pwd=Password;Connect Timeout=600;" />

Permissions were set with IIS APPPool/identity

I also tried the install directly fromt the sql query tool using CreateDatabase.sql, however that also created errors.
This content has not been rated yet. 
61 Reputation 10 Total posts
denis

denis

10/23/2011 10:18:00 PM
Some shared hosting providers have various performance and connection problems. The installation should work regardless of the environment. The SQL script that inserts the data into the LocalizationSource is quite heavy, but should be executed without problems.
Is there a chance for us to have a remote access to your server (via TeamViewer or a similar tool)?
This content has not been rated yet. 
7207 Reputation 956 Total posts
Kiamori

Kiamori

10/23/2011 10:49:22 PM
This is a production environment so that would not be possible, anything else we can do to troubleshoot? I can setup a dev server for the project but that seems a bit excessive for something that should be so simple.
This content has not been rated yet. 
61 Reputation 10 Total posts
denis

denis

10/24/2011 8:12:22 AM
I am still confident that this is a problem with the SQL Server configuration in your production environment. There is no other reason why this should not work for you, as there are thousands other users that are able to install it successfully.
What error do you get when trying to run the SQL script directly? Note that you still may have to change the connection timeout (more details here).
This content has not been rated yet. 
7207 Reputation 956 Total posts
Kiamori

Kiamori

10/24/2011 3:57:07 PM
This is a fairly nice setup and we run several other cms's without a problem including some finicky enterprise class cms solutions such as telligent community. Actually I've been the one to install most of the other cms's and I have yet to have a problem installing one other than monox.

The sql server is running 24 core(2-25% peak CPU utilization), 128GB ram and 14TB Raid-10(1/3 utilized, with a max response time of 14ms on the process during install).
This content has not been rated yet. 
61 Reputation 10 Total posts
denis

denis

10/24/2011 5:43:07 PM
This is far beyond the minimal requirements, and the problem is somewhere else, not in your hardware. Could you let us know happens when you run the script directly?
This content has not been rated yet. 
7207 Reputation 956 Total posts
Kiamori

Kiamori

10/24/2011 6:42:11 PM
After running the createdatabase.sql and going to the url, the platform still takes me to the installer even if I try to remove the /installer directory so I ran the installer again with the option to upgrade after which the error is as follows:

Server Error in '/' Application.

The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_Page_aspnet_Applications". The conflict occurred in database "monox",
table "dbo.aspnet_Applications", column 'ApplicationId'.
The statement has
been terminated. 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.SqlClient.SqlException: The INSERT statement conflicted with the
FOREIGN KEY constraint "FK_Page_aspnet_Applications". The conflict occurred in
database "monox", table "dbo.aspnet_Applications", column
'ApplicationId'.
The statement has been terminated.

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:

[SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Page_aspnet_Applications". The conflict occurred in database "monox", table "dbo.aspnet_Applications", column 'ApplicationId'.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +109
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +126
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +238
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2313
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +164
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1034
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +242
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +295
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +117
SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute() +343

[ORMQueryExecutionException: An exception was caught during the execution of an action query: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Page_aspnet_Applications". The conflict occurred in database "monox", table "dbo.aspnet_Applications", column 'ApplicationId'.
The statement has been terminated.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.]
SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute() +631
SD.LLBLGen.Pro.ORMSupportClasses.BatchActionQuery.Execute() +112
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteActionQuery(IActionQuery queryToExecute) +97
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.PersistQueue(List`1 queueToPersist, Boolean insertActions, Int32& totalAmountSaved) +1241
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave, IPredicateExpression updateRestriction, Boolean recurse) +1030
SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave) +38
MonoSoftware.LLBLGen.Repository.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave) +51
MonoSoftware.MonoX.Repositories.PageRepository.CreatePage(String url, String template) +396
MonoSoftware.MonoX.Repositories.PageRepository.CreatePage(String url) +28
MonoSoftware.MonoX.Utilities.PageUtility.GetPageProperties(String appRelativeCurrentExecutionFilePath) +197
MonoSoftware.MonoX.BasePage.GetPageProperties() +28
MonoSoftware.MonoX.BasePage.get_PageProperties() +28
MonoSoftware.MonoX.BasePage.OnPreInit(EventArgs e) +53
System.Web.UI.Page.PerformPreInit() +21
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +993



Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET
Version:4.0.30319.237
This content has not been rated yet. 
61 Reputation 10 Total posts
khorvat

khorvat

10/24/2011 8:40:22 PM
Hi,

can you please try to run the create script on an empty database so we can see what exact error do you get ?

Thanks
This content has not been rated yet. 
15993 Reputation 2214 Total posts
1 2 3