• Recent
    • Tags
    • Popular
    • Register
    • Login
    1. Home
    2. turboblade
    3. Posts

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website
    T
    • Profile
    • Following 0
    • Followers 0
    • Topics 2
    • Posts 15
    • Best 0
    • Controversial 0
    • Groups 0

    Posts made by turboblade

    • RE: Power Curve

      thanks

      posted in User help
      T
      turboblade
    • Power Curve

      I am currently using Mango as a SCADA interface with a number of Wind Turbines. I would like to be able to produce a Power Curve for each Wind Turbine. This is basically a graph showing discrete "Wind Speeds" along the x-axis, with corresponding average "Power Output" along the y-axis.

      "Wind Speed" and "Power Output" are two values that are polled from each Wind Turbine every 10 seconds and logged in the database.

      As I see it this is a four step process:

      1. Search the database for each occurrence of each discrete "Wind Speed" and record the corresponding date/time stamp
      2. Use these date/time stamps to lookup all of the "Power Outputs" that occurred against each "Wind Speed"
      3. Take an average of the "Power Outputs" against each "Wind Speed"
      4. Plot the "Power Output" averages against each of the discrete "Wind Speeds" on a graph

      eg as shown below

      image

      This can be done manually using csv exports and lookup tables in excel. But does anyone have any ideas how this process could be automated by Mango.

      Thanks

      posted in User help
      T
      turboblade
    • RE: Power Curve

      I am currently using Mango as a SCADA interface with a number of Wind Turbines. I would like to be able to produce a Power Curve for each Wind Turbine. This is basically a graph showing discrete "Wind Speeds" along the x-axis, with corresponding average "Power Output" along the y-axis.

      "Wind Speed" and "Power Output" are two values that are polled from each Wind Turbine every 10 seconds and logged in the database.

      As I see it this is a four step process:

      1. Search the database for each occurrence of each discrete "Wind Speed" and record the corresponding date/time stamp
      2. Use these date/time stamps to lookup all of the "Power Outputs" that occurred against each "Wind Speed"
      3. Take an average of the "Power Outputs" against each "Wind Speed"
      4. Plot the "Power Output" averages against each of the discrete "Wind Speeds" on a graph

      eg as shown below

      image

      This can be done manually using csv exports and lookup tables in excel. But does anyone have any ideas how this process could be automated by Mango.

      Thanks

      posted in User help
      T
      turboblade
    • RE: MSSQL 2008

      ok I will use it for now. Can you please explain how to copy my existing DGLux dashboard to a new Mango installation

      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      Ok here I am now using a clean database and I am presented with the following error when I open the data sources page:

      Server error: PreparedStatementCallback; bad SQL grammar [SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,ds.name,ds.xid,ds.dataSourceType FROM dataPoints AS dp join dataSources ds on ds.id = dp.dataSourceId ORDER BY dp.deviceName, dp.name OFFSET ? ROWS FETCH NEXT ? ROWS ONLY]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'OFFSET'.
Server error: PreparedStatementCallback; bad SQL grammar [SELECT id,xid,name,dataSourceType,data FROM dataSources ORDER BY name OFFSET ? ROWS FETCH NEXT ? ROWS ONLY]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'OFFSET'.

      Also, when I open the beta alarms page I am presented with the following error:

      Server error: PreparedStatementCallback; bad SQL grammar [SELECT evt.id,evt.typeName,evt.subtypeName,evt.typeRef1,evt.typeRef2,evt.activeTs,evt.rtnApplicable,evt.rtnTs,evt.rtnCause,evt.alarmLevel,evt.message,evt.ackTs,evt.ackUserId,evt.alternateAckSource,u.username,(select count(1) from userComments where commentType=1 and typeKey=evt.id) as cnt ,ue.silenced FROM events AS evt left join users u on evt.ackUserId=u.id left join userEvents ue on evt.id=ue.eventId WHERE evt.rtnTs IS NULL AND evt.rtnApplicable IN (?) AND evt.ackTs IS NULL AND evt.alarmLevel >= 1 ORDER BY evt.activeTs DESC OFFSET ? ROWS FETCH NEXT ? ROWS ONLY]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'OFFSET'.
      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      ok another query. How can i copy my DGLux installation across from my other Mango GUID. I tried copying the entire DGLux folder to the ...\web\modules folder but now I have no DGLux at all in Mango.

      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      OK i have been able to start a new install of mango successfully with an MSSQL database. The only problem now is the GUID doesnt match my license. How can I fix this? Hopefully i wont have to purchase a new license.

      Also, would the MSSQL convert work for the already established Mango installation if I disabled the Watch List module or did this only work because it is a fresh install?

      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      Thank you for getting back to me. What exactly is the watch list module used for?

      Will I be able to transfer my dglux design across to the new database

      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      Any further developments on this. I find it hard to believe
      that MS sql has not been successfully used by anyone yet.

      I am currently running Mango from a virtual XP PC. Do you think this could cause issues?

      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      There are a few third party options for converting MYSQL to MSSQL. But I assume this wont help since even a clean database isn't working properly.

      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      @JoelHaggar said:

      Ok, thanks. I'll look into this and get back to you.

      Joel.

      Thanks very much for your help

      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      Sorry, my mistake. This is it running with a clean database.

      INFO  2013-11-20 21:56:47,912 (com.serotonin.util.properties.ReloadingProperties.checkForReload:142) - (env) Found updated file(s) at [C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\classes\env.properties, C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\overrides\properties\env.properties]. Reloading properties 
WARN  2013-11-20 21:56:49,692 (com.serotonin.m2m2.Main.getProperties:607) - Module C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\web\modules\_save: module.properties not found in module directory. Module not loaded. 
INFO  2013-11-20 21:56:49,708 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'dglux', v1.0.3 by Infinite Automation Systems Inc. 
INFO  2013-11-20 21:56:49,708 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'dojo', v1.7.3 by Serotonin Software 
INFO  2013-11-20 21:56:49,708 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'graphicalViews', v1.4.1 by Serotonin Software 
INFO  2013-11-20 21:56:49,911 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'internal', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:56:49,927 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'maintenanceEvents', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:56:49,942 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'modbus', v1.4.2 by Serotonin Software 
INFO  2013-11-20 21:56:49,958 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'pointLinks', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:56:49,974 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'reports', v2.0.0 by Serotonin Software 
INFO  2013-11-20 21:56:49,989 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'scheduledEvents', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:56:50,005 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'scripting', v1.0.0 by Serotonin Software 
INFO  2013-11-20 21:56:50,020 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'sqlds', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:56:50,036 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'sstGraphics', v1.0.1 by Serotonin Software 
INFO  2013-11-20 21:56:50,036 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'virtualDS', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:56:50,036 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'watchlists', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:56:51,270 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager 
ERROR 2013-11-20 21:56:53,723 (com.serotonin.m2m2.Main.main:93) - Error during initialization 
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ alter table watchListUsers add constraint watchListUsersFk2 foreign key (userId) references users(id) on delete cascade; ]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN KEY constraint 'watchListUsersFk2' on table 'watchListUsers' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
	at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:71)
	at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:90)
	at com.serotonin.m2m2.db.DatabaseProxy.runScriptFile(DatabaseProxy.java:212)
	at com.serotonin.m2m2.watchlist.WatchListSchemaDefinition.newInstallationCheck(WatchListSchemaDefinition.java:19)
	at com.serotonin.m2m2.db.DatabaseProxy.newDatabaseCheck(DatabaseProxy.java:175)
	at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:84)
	at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:445)
	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:159)
	at com.serotonin.m2m2.Main.main(Main.java:87)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN KEY constraint 'watchListUsersFk2' on table 'watchListUsers' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649)
	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
	at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
	... 10 more
INFO  2013-11-20 21:56:53,785 (com.serotonin.m2m2.db.BasePooledProxy.terminate:108) - Stopping database
      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      Thank you for the reply.

      INFO  2013-11-20 21:28:46,396 (com.serotonin.util.properties.ReloadingProperties.checkForReload:142) - (env) Found updated file(s) at [C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\classes\env.properties]. Reloading properties 
WARN  2013-11-20 21:28:48,208 (com.serotonin.m2m2.Main.getProperties:607) - Module C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\web\modules\_save: module.properties not found in module directory. Module not loaded. 
INFO  2013-11-20 21:28:48,255 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'dglux', v1.0.3 by Infinite Automation Systems Inc. 
INFO  2013-11-20 21:28:48,270 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'dojo', v1.7.3 by Serotonin Software 
INFO  2013-11-20 21:28:48,270 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'graphicalViews', v1.4.1 by Serotonin Software 
INFO  2013-11-20 21:28:48,661 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'internal', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:28:48,692 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'maintenanceEvents', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:28:48,708 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'modbus', v1.4.2 by Serotonin Software 
INFO  2013-11-20 21:28:48,754 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'pointLinks', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:28:48,770 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'reports', v2.0.0 by Serotonin Software 
INFO  2013-11-20 21:28:48,817 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'scheduledEvents', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:28:48,833 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'scripting', v1.0.0 by Serotonin Software 
INFO  2013-11-20 21:28:48,864 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'sqlds', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:28:48,879 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'sstGraphics', v1.0.1 by Serotonin Software 
INFO  2013-11-20 21:28:48,895 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'virtualDS', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:28:48,911 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'watchlists', v1.4.0 by Serotonin Software 
INFO  2013-11-20 21:28:50,957 (com.serotonin.m2m2.db.DerbyProxy.initializeImpl:56) - Initializing derby connection manager 
INFO  2013-11-20 21:28:59,643 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:36) - Starting instance with core version 2.0.6, db 7 
INFO  2013-11-20 21:29:36,418 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:280) - Data source 'Manse Road' initialized 
INFO  2013-11-20 21:29:48,275 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:280) - Data source 'Test Road' initialized 
INFO  2013-11-20 21:29:48,462 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:280) - Data source 'Test Road' initialized 
INFO  2013-11-20 21:29:59,898 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting 
INFO  2013-11-20 21:29:59,898 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started 
INFO  2013-11-20 21:30:01,803 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController' 
INFO  2013-11-20 21:30:01,866 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/modules.shtm] onto handler 'modulesController' 
INFO  2013-11-20 21:30:01,866 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/point_hierarchy.shtm] onto handler 'pointHierarchyController' 
INFO  2013-11-20 21:30:01,866 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/emport.shtm] onto handler 'emportController' 
INFO  2013-11-20 21:30:01,928 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController' 
INFO  2013-11-20 21:30:02,085 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController' 
INFO  2013-11-20 21:30:02,085 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_sources.shtm] onto handler 'dataSourceListController' 
INFO  2013-11-20 21:30:02,085 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mailing_lists.shtm] onto handler 'mailingListsController' 
INFO  2013-11-20 21:30:02,085 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/event_handlers.shtm] onto handler 'eventHandlersController' 
INFO  2013-11-20 21:30:02,210 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController' 
INFO  2013-11-20 21:30:02,288 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController' 
INFO  2013-11-20 21:30:02,288 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/system_settings.shtm] onto handler 'systemSettingsController' 
INFO  2013-11-20 21:30:02,335 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController' 
INFO  2013-11-20 21:30:02,335 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/events.shtm] onto handler 'eventsController' 
INFO  2013-11-20 21:30:02,335 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publishers.shtm] onto handler 'publisherListController' 
INFO  2013-11-20 21:30:02,335 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController' 
INFO  2013-11-20 21:30:02,460 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_details.shtm] onto handler 'dataPointDetailsController' 
INFO  2013-11-20 21:30:02,460 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController' 
INFO  2013-11-20 21:30:05,303 (com.serotonin.m2m2.web.dwr.util.BlabberConverterManager.addConverter:61) - Probably not an issue: org.jdom.Document is not available so the jdom converter will not load. This is only an problem if you wanted to use it. 
INFO  2013-11-20 21:30:05,303 (com.serotonin.m2m2.web.dwr.util.BlabberConverterManager.addConverter:61) - Probably not an issue: org.jdom.Element is not available so the jdom converter will not load. This is only an problem if you wanted to use it. 
INFO  2013-11-20 21:30:06,521 (com.serotonin.m2m2.Lifecycle.configureDwr:631) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.modbus.dwr.ModbusEditDwr 
INFO  2013-11-20 21:30:06,724 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/dglux.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,740 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/dglux/login.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,740 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/views.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,740 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/public_view.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,756 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/view_edit.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,756 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/maintenance_events.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,756 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/point_links.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,771 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/reportChart.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,771 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/reports.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,771 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/scheduled_events.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,771 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/watch_list.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,787 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/login.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,802 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/watch_list.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:06,802 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/logout.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController] 
INFO  2013-11-20 21:30:07,052 (com.serotonin.util.properties.ReloadingProperties.checkForReload:142) - (dglux) Found updated file(s) at [C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\web\modules\dglux\classes\dglux.properties]. Reloading properties

      As you can see the startup script runs correctly using Derby without the conversion.

      posted in Mango Automation Installation
      T
      turboblade
    • MSSQL 2008

      Trying to convert my Derby to MSSQL 2008, but I am presented with the following error. Any suggestions?

      INFO  2013-11-19 23:06:22,950 (com.serotonin.util.properties.ReloadingProperties.checkForReload:142) - (env) Found updated file(s) at [C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\classes\env.properties, C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\overrides\properties\env.properties]. Reloading properties 
WARN  2013-11-19 23:06:24,887 (com.serotonin.m2m2.Main.getProperties:607) - Module C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\web\modules\_save: module.properties not found in module directory. Module not loaded. 
INFO  2013-11-19 23:06:24,887 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'dglux', v1.0.3 by Infinite Automation Systems Inc. 
INFO  2013-11-19 23:06:24,903 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'dojo', v1.7.3 by Serotonin Software 
INFO  2013-11-19 23:06:24,903 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'graphicalViews', v1.4.1 by Serotonin Software 
INFO  2013-11-19 23:06:25,106 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'internal', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,121 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'maintenanceEvents', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,137 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'modbus', v1.4.2 by Serotonin Software 
INFO  2013-11-19 23:06:25,168 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'pointLinks', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,168 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'reports', v2.0.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,184 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'scheduledEvents', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,200 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'scripting', v1.0.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,215 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'sqlds', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,231 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'sstGraphics', v1.0.1 by Serotonin Software 
INFO  2013-11-19 23:06:25,231 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'virtualDS', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,246 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'watchlists', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:26,496 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager 
WARN  2013-11-19 23:06:28,183 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2 
INFO  2013-11-19 23:06:28,183 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\logs\com.serotonin.m2m2.db.upgrade.Upgrade1.log 
ERROR 2013-11-19 23:06:28,980 (com.serotonin.m2m2.Main.main:93) - Error during initialization 
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata image; ]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'column'.
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
	at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:144)
	at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:445)
	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:159)
	at com.serotonin.m2m2.Main.main(Main.java:87)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata image; ]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'column'.
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
	at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:71)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
	at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
	... 5 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'column'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649)
	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
	at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
	... 12 more
INFO  2013-11-19 23:06:29,026 (com.serotonin.m2m2.db.BasePooledProxy.terminate:108) - Stopping database
      posted in Mango Automation Installation
      T
      turboblade
    • RE: MSSQL 2008

      Trying to convert my Derby to MSSQL 2008, but I am presented with the following error. Any suggestions?

      INFO  2013-11-19 23:06:22,950 (com.serotonin.util.properties.ReloadingProperties.checkForReload:142) - (env) Found updated file(s) at [C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\classes\env.properties, C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\overrides\properties\env.properties]. Reloading properties 
WARN  2013-11-19 23:06:24,887 (com.serotonin.m2m2.Main.getProperties:607) - Module C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\web\modules\_save: module.properties not found in module directory. Module not loaded. 
INFO  2013-11-19 23:06:24,887 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'dglux', v1.0.3 by Infinite Automation Systems Inc. 
INFO  2013-11-19 23:06:24,903 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'dojo', v1.7.3 by Serotonin Software 
INFO  2013-11-19 23:06:24,903 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'graphicalViews', v1.4.1 by Serotonin Software 
INFO  2013-11-19 23:06:25,106 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'internal', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,121 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'maintenanceEvents', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,137 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'modbus', v1.4.2 by Serotonin Software 
INFO  2013-11-19 23:06:25,168 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'pointLinks', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,168 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'reports', v2.0.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,184 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'scheduledEvents', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,200 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'scripting', v1.0.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,215 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'sqlds', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,231 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'sstGraphics', v1.0.1 by Serotonin Software 
INFO  2013-11-19 23:06:25,231 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'virtualDS', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:25,246 (com.serotonin.m2m2.Main.loadModules:371) - Loading module 'watchlists', v1.4.0 by Serotonin Software 
INFO  2013-11-19 23:06:26,496 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager 
WARN  2013-11-19 23:06:28,183 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2 
INFO  2013-11-19 23:06:28,183 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to C:\Documents and Settings\Administrator.WINDXPGST1\Desktop\Mango\logs\com.serotonin.m2m2.db.upgrade.Upgrade1.log 
ERROR 2013-11-19 23:06:28,980 (com.serotonin.m2m2.Main.main:93) - Error during initialization 
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata image; ]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'column'.
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
	at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:144)
	at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:445)
	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:159)
	at com.serotonin.m2m2.Main.main(Main.java:87)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata image; ]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'column'.
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
	at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:71)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
	at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
	at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
	... 5 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'column'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649)
	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
	at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
	... 12 more
INFO  2013-11-19 23:06:29,026 (com.serotonin.m2m2.db.BasePooledProxy.terminate:108) - Stopping database
      posted in Mango Automation Installation
      T
      turboblade