[mapguide-users] MapGuide Service muste be restarted once in a while
Hello, I have a problem with my MapGuide Server 2.5. The thing is, I have to restart the Service once in a while because I cant see the map, layouts or anything else. Im working with Windows Server 2012 R2 64bit, an APS.NET web Application and IIS 8.5. Im allready tried the automatic recovery features of Windows Services and also written an program that should run and restart the service when an error occurs but it seems thats nothing of these happens because my program should have written an log file. There is also not a single entry in Windows event viewer about MapGuide Server 2.5. Do somebody have an idea? -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] MapGuide Service muste be restarted once in a while
Will this be caused by the Serverconfig.ini setting? https://trac.osgeo.org/mapguide/wiki/ServerconfigWebConfigIni SessionTimeout 0 < Value <= 86400 Time duration in seconds for when an idle session is expired SessionTimerInterval0 < Value <= 2147483647 ime interval in seconds for when the server checks -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] MapGuide Service muste be restarted once in a while
Is something wrong with my values? SessionTimerInterval = 4000 SessionTimeout = 12000 Here is an error log, at the end I restarted the service manuelly. The error is somewhere between 08:37 and 9:33. <2018-02-06T08:37:12> 6160Anonymous Error: An exception occurred in FDO component. Error occurred in Feature Source (Library://Neunkirchen-Seelscheid/Data/NeunkirchenSeelscheid_SQL.FeatureSource): RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'tbl_Grab_ID' wurde in der Grabnummer-Tabelle mehrmals angegeben. (Cause: , Root Cause: RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'tbl_Grab_ID' wurde in der Grabnummer-Tabelle mehrmals angegeben. ) StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\mg-2.5-x86\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpExecuteSqlNonQuery.Execute() line 150 file c:\mg-2.5-x86\mgdev\server\src\services\feature\OpExecuteSqlNonQuery.cpp - MgServerSqlCommand.ExecuteQuery() line 131 file c:\mg-2.5-x86\mgdev\server\src\services\feature\ServerSqlCommand.cpp <2018-02-06T08:37:29> 9944Anonymous Error: An exception occurred in FDO component. Error occurred in Feature Source (Library://Neunkirchen-Seelscheid/Data/NeunkirchenSeelscheid_SQL.FeatureSource): RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler bei ALTER TABLE DROP COLUMN, da die 'tbl_GrafikText_ID'-Spalte in der Grabbeschriftung-Tabelle nicht vorhanden ist. (Cause: , Root Cause: RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler bei ALTER TABLE DROP COLUMN, da die 'tbl_GrafikText_ID'-Spalte in der Grabbeschriftung-Tabelle nicht vorhanden ist. ) StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\mg-2.5-x86\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpExecuteSqlNonQuery.Execute() line 150 file c:\mg-2.5-x86\mgdev\server\src\services\feature\OpExecuteSqlNonQuery.cpp - MgServerSqlCommand.ExecuteQuery() line 131 file c:\mg-2.5-x86\mgdev\server\src\services\feature\ServerSqlCommand.cpp <2018-02-06T08:37:29> 1344Anonymous Error: An exception occurred in FDO component. Error occurred in Feature Source (Library://Neunkirchen-Seelscheid/Data/NeunkirchenSeelscheid_SQL.FeatureSource): RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'LokTbl_Beschriftungsart_ID' wurde in der Grabbeschriftung-Tabelle mehrmals angegeben. (Cause: , Root Cause: RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'LokTbl_Beschriftungsart_ID' wurde in der Grabbeschriftung-Tabelle mehrmals angegeben. ) StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\mg-2.5-x86\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpExecuteSqlNonQuery.Execute() line 150 file c:\mg-2.5-x86\mgdev\server\src\services\feature\OpExecuteSqlNonQuery.cpp - MgServerSqlCommand.ExecuteQuery() line 131 file c:\mg-2.5-x86\mgdev\server\src\services\feature\ServerSqlCommand.cpp <2018-02-06T08:37:29> 4240Anonymous Error: An exception occurred in FDO component. Error occurred in Feature Source (Library://Neunkirchen-Seelscheid/Data/NeunkirchenSeelscheid_SQL.FeatureSource): RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'tbl_Grab_ID' wurde in der Grabbeschriftung-Tabelle mehrmals angegeben. (Cause: , Root Cause: RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'tbl_Grab_ID' wurde in der Grabbeschriftung-Tabelle mehrmals angegeben. ) StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\mg-2.5-x86\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpExecuteSqlNonQuery.Execute() line 150 file c:\mg-2.5-x86\mgdev\server\src\services\feature\OpExecuteSqlNonQuery.cpp - MgServerSqlCommand.ExecuteQuery() line 131 file c:\mg-2.5-x86\mgdev\server\src\services\feature\ServerSqlCommand.cpp <2018-02-06T08:41:38> 6160Anonymous Error: Resource was not found: Session:ef84409c-0b0f-11e8-8000-208d0a1054f9_en_MTI3LjAuMC4x0AFC0AFB0AFA//FriedaMarker.FeatureSource StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\mg-2.5-x86\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpUpdateFeatures.Execute() line 136 file c:\mg-2.5-x86\mgdev\server\src\services\feature\OpUpdateFeatures.cpp - MgServerUpdateFeatures.UpdateFeatures() line 138 file c:\mg-2.5-x86\mgdev\server\src\services\feature\ServerUpdateFeatures.cpp - MgFdoConnectionManager.Open() line 333 file c:\mg-2.5-x86\mgdev\ser
Re: [mapguide-users] MapGuide Service muste be restarted once in a while
Is the server out of system resources at the time you need to restart? Does Mapguide memory usage continually increase? Is your SQL experiencing long query times? Martin Morrison Infrastructure Application Engineer/Systems Analyst Engineering Design Systems, Inc. 540.345.1410 martin.morri...@edsi.com www.edsi.com -Original Message- From: mapguide-users [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of frieda Sent: Thursday, February 8, 2018 3:23 AM To: mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] MapGuide Service muste be restarted once in a while Is something wrong with my values? SessionTimerInterval = 4000 SessionTimeout = 12000 Here is an error log, at the end I restarted the service manuelly. The error is somewhere between 08:37 and 9:33. <2018-02-06T08:37:12> 6160Anonymous Error: An exception occurred in FDO component. Error occurred in Feature Source (Library://Neunkirchen-Seelscheid/Data/NeunkirchenSeelscheid_SQL.FeatureSource): RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'tbl_Grab_ID' wurde in der Grabnummer-Tabelle mehrmals angegeben. (Cause: , Root Cause: RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'tbl_Grab_ID' wurde in der Grabnummer-Tabelle mehrmals angegeben. ) StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\mg-2.5-x86\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpExecuteSqlNonQuery.Execute() line 150 file c:\mg-2.5-x86\mgdev\server\src\services\feature\OpExecuteSqlNonQuery.cpp - MgServerSqlCommand.ExecuteQuery() line 131 file c:\mg-2.5-x86\mgdev\server\src\services\feature\ServerSqlCommand.cpp <2018-02-06T08:37:29> 9944Anonymous Error: An exception occurred in FDO component. Error occurred in Feature Source (Library://Neunkirchen-Seelscheid/Data/NeunkirchenSeelscheid_SQL.FeatureSource): RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler bei ALTER TABLE DROP COLUMN, da die 'tbl_GrafikText_ID'-Spalte in der Grabbeschriftung-Tabelle nicht vorhanden ist. (Cause: , Root Cause: RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler bei ALTER TABLE DROP COLUMN, da die 'tbl_GrafikText_ID'-Spalte in der Grabbeschriftung-Tabelle nicht vorhanden ist. ) StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\mg-2.5-x86\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpExecuteSqlNonQuery.Execute() line 150 file c:\mg-2.5-x86\mgdev\server\src\services\feature\OpExecuteSqlNonQuery.cpp - MgServerSqlCommand.ExecuteQuery() line 131 file c:\mg-2.5-x86\mgdev\server\src\services\feature\ServerSqlCommand.cpp <2018-02-06T08:37:29> 1344Anonymous Error: An exception occurred in FDO component. Error occurred in Feature Source (Library://Neunkirchen-Seelscheid/Data/NeunkirchenSeelscheid_SQL.FeatureSource): RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'LokTbl_Beschriftungsart_ID' wurde in der Grabbeschriftung-Tabelle mehrmals angegeben. (Cause: , Root Cause: RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'LokTbl_Beschriftungsart_ID' wurde in der Grabbeschriftung-Tabelle mehrmals angegeben. ) StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\mg-2.5-x86\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpExecuteSqlNonQuery.Execute() line 150 file c:\mg-2.5-x86\mgdev\server\src\services\feature\OpExecuteSqlNonQuery.cpp - MgServerSqlCommand.ExecuteQuery() line 131 file c:\mg-2.5-x86\mgdev\server\src\services\feature\ServerSqlCommand.cpp <2018-02-06T08:37:29> 4240Anonymous Error: An exception occurred in FDO component. Error occurred in Feature Source (Library://Neunkirchen-Seelscheid/Data/NeunkirchenSeelscheid_SQL.FeatureSource): RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'tbl_Grab_ID' wurde in der Grabbeschriftung-Tabelle mehrmals angegeben. (Cause: , Root Cause: RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Spaltennamen müssen in jeder Tabelle eindeutig sein. Der Spaltenname 'tbl_Grab_ID' wurde in der Grabbeschriftung-Tabelle mehrmals angegeben. ) StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\mg-2.5-x86\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpExecuteSqlNonQuery.Execute() line 150 file c:\mg-2.5-x86\mgdev\server\src\services\feature\OpExecuteSqlNonQuery.cpp - MgServerSqlCommand.ExecuteQuery() lin
Re: [mapguide-users] MapGuide Service muste be restarted once in a while
My SQL-Queries are not that extraordinarily long. The Server has enough resources so that should not be a problem either (no entries in server manager about that). -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] MapGuide Service muste be restarted once in a while
Ok today I had to restart the map guide server again. Nothing is running at full capacity, in error log file I can only see "Session has expired", "Cannot create repository" or "Authentication failed" but these kind of errors happening on a daily basis. Its seems that this happens at rush hour. Maybe I shoul increase some values in my serverconfig.ini, any tips which one? -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] MapGuide Service muste be restarted once in a while
This article Jackie wrote might help you: http://themapguyde.blogspot.ca/2012/06/thoughts-on-mapguide-scalability.html -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] MapGuide Service muste be restarted once in a while
Thank you very much, I found the reason. My SessionRepositoriesLimit was to low (200). I just have increased the value to 400 -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users