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.
Error Adding SQL Data Source
-
Greetings all-
I downloaded the latest 2.0.0 core today and upgraded my Mango Automation version to the latest. I also re-downloaded the sqlds data source version 2.0 - 1.4.0 so I could have the latest version of the data source module. However, when I try to add a new data source of type SQL, the software generates an error:
System exception!
The server has experienced an exception processing your last request. The exception has been logged, and system administrators will be notified of this problem. You may continue to use the site. We apologize for the inconvenience.
The details are here:
org.apache.jasper.JasperException: PWC6033: Unable to compile class for JSP
PWC6199: Generated servlet error:
Main.Constants cannot be resolvedat org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:123) at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:296) at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:376) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:437) at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:608) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:360) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:517) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:284) at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:115) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:238) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1047) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:817) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1352) at com.serotonin.m2m2.web.filter.WebContextFilter.doFilter(WebContextFilter.java:43) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) at com.serotonin.m2m2.web.filter.LoggedInFilter.doFilter(LoggedInFilter.java:100) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) at com.serotonin.web.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:37) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:476) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:517) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110) at org.eclipse.jetty.server.Server.handle(Server.java:346) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1048) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529) at java.lang.Thread.run(Thread.java:722)REQUEST URL
http://10.90.16.76:8080/exception/error.jspREQUEST PARAMETERS
typeId=SQLREQUEST HEADERS
Host=10.90.16.76:8080
Connection=keep-alive
User-Agent=Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.64 Safari/537.4
Accept=text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Referer=http://10.90.16.76:8080/data_sources.shtm
Accept-Encoding=gzip,deflate,sdch
Accept-Language=en-US,en;q=0.8
Accept-Charset=ISO-8859-1,utf-8;q=0.7,*;q=0.3
Cookie=JSESSIONID=14toku825r4k01c49sa5wuocj0REQUEST ATTRIBUTES
instanceDescription=SmartPlant
javax.servlet.forward.request_uri=/data_source_edit.shtm
dataSource=com.serotonin.m2m2.sql.SqlDataSourceVO@4c642d
org.springframework.web.servlet.DispatcherServlet.THEME_SOURCE=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Mon Sep 24 12:21:48 EDT 2012]; parent: Root WebApplicationContext
org.springframework.web.servlet.DispatcherServlet.THEME_RESOLVER=org.springframework.web.servlet.theme.FixedThemeResolver@144f8c6
javax.servlet.forward.context_path=
javax.servlet.error.servlet_name=springDispatcher
NEW_ID=-1
lang=en
javax.servlet.forward.servlet_path=/data_source_edit.shtm
javax.servlet.error.message=PWC6033: Unable to compile class for JSPPWC6199: Generated servlet error:
Main.Constants cannot be resolvedjavax.servlet.jsp.jstl.fmt.locale.request=en_US
sessionUser=User [id=1, username=admin, password=0DPiKuNIrrVmD8IUCuw1hQxNqZc=, email=admin@yourMangoDomain.com, phone=, admin=true, disabled=false, dataSourcePermissions=[], dataPointPermissions=[], homeUrl=null, lastLogin=1348502756332, receiveAlarmEmails=0, receiveOwnAuditEvents=false, timezone=null]
javax.servlet.error.request_uri=/data_source_edit.shtm
javax.servlet.jsp.jstl.fmt.localizationContext.request=org.springframework.web.servlet.support.JstlUtils$SpringLocalizationContext@12891dd
modulePath=/modules/sqlds
javax.servlet.forward.query_string=typeId=SQL
analogPoints=[DataPointVO [id=3, xid=DP_938362, name=Data Point 1 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@807f3b, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1b29aee, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=7, xid=DP_819154, name=Data Point 2 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@d9af50, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@184eb2c, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=9, xid=DP_768385, name=Data Point 3 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@16ba3d1, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1d008b6, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=10, xid=DP_090656, name=Data Point 4 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@ec15de, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@18fcc5a, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=11, xid=DP_417940, name=Data Point 5 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@1b12d9d, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@129bf16, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=12, xid=DP_710683, name=Data Point 6 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@1c0420d, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1306d9c, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=13, xid=DP_998858, name=Data Point 7 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@6c3705, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@904219, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=14, xid=DP_213333, name=Data Point 8 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@e37fcd, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1dba49b, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=15, xid=DP_602725, name=Data Point 9 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@113c960, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@9cf9d, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=18, xid=DP_211778, name=VISU, dataSourceId=2, deviceName=VISU, enabled=false, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@1d81c7, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.internal.InternalPointLocatorVO@3cb8f1, dataSourceTypeName=INTERNAL, dataSourceName=VISU, dataSourceXid=DS_412070, lastValue=null, settable=false]]
org.springframework.web.servlet.DispatcherServlet.CONTEXT=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Mon Sep 24 12:21:48 EDT 2012]; parent: Root WebApplicationContext
javax.servlet.error.status_code=500
javax.servlet.error.exception_type=class org.apache.jasper.JasperException
availableLanguages=[com.serotonin.db.pair.StringStringPair@92089a, com.serotonin.db.pair.StringStringPair@172b6c0, com.serotonin.db.pair.StringStringPair@3c3276, com.serotonin.db.pair.StringStringPair@151a8b, com.serotonin.db.pair.StringStringPair@1819bb7, com.serotonin.db.pair.StringStringPair@16417e]
org.springframework.web.servlet.HandlerMapping.pathWithinHandlerMapping=/data_source_edit.shtm
org.eclipse.jetty.server.error_page=/exception/error.jsp
commPortError=no rxtxSerial in java.library.path
org.springframework.web.servlet.HandlerMapping.bestMatchingPattern=/data_source_edit.shtm
javax.servlet.error.exception=org.apache.jasper.JasperException: PWC6033: Unable to compile class for JSPPWC6199: Generated servlet error:
Main.Constants cannot be resolveduserPoints=[DataPointVO [id=4, xid=DP_706123, name=Data Point 1 AN, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@125d603, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1058cae, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=1, xid=DP_189946, name=Data Point 1 B, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@15715e2, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@5db987, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=2, xid=DP_803267, name=Data Point 1 MS, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@13f7d71, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1448c82, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=3, xid=DP_938362, name=Data Point 1 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@807f3b, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1b29aee, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=16, xid=DP_146498, name=Data Point 10 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@164cd4e, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@e2e186, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=8, xid=DP_885410, name=Data Point 2 AN, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@144626a, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@995a52, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=5, xid=DP_947597, name=Data Point 2 B, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@1f8d357, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@fb127c, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=6, xid=DP_291245, name=Data Point 2 MS, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@17acc05, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1f837d1, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=7, xid=DP_819154, name=Data Point 2 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@d9af50, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@184eb2c, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=17, xid=DP_755133, name=Data Point 3 MS, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@118baf3, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@99c1ba, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=9, xid=DP_768385, name=Data Point 3 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@16ba3d1, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1d008b6, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=10, xid=DP_090656, name=Data Point 4 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@ec15de, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@18fcc5a, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=11, xid=DP_417940, name=Data Point 5 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@1b12d9d, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@129bf16, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=12, xid=DP_710683, name=Data Point 6 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@1c0420d, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1306d9c, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=13, xid=DP_998858, name=Data Point 7 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@6c3705, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@904219, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=14, xid=DP_213333, name=Data Point 8 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@e37fcd, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@1dba49b, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=15, xid=DP_602725, name=Data Point 9 N, dataSourceId=1, deviceName=Virtual Demo, enabled=true, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@113c960, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.virtual.vo.VirtualPointLocatorVO@9cf9d, dataSourceTypeName=VIRTUAL, dataSourceName=Virtual Demo, dataSourceXid=DS_009500, lastValue=null, settable=false], DataPointVO [id=18, xid=DP_211778, name=VISU, dataSourceId=2, deviceName=VISU, enabled=false, pointFolderId=0, loggingType=1, intervalLoggingPeriodType=2, intervalLoggingPeriod=15, intervalLoggingType=1, tolerance=0.0, purgeOverride=true, purgeType=7, purgePeriod=1, textRenderer=com.serotonin.m2m2.view.text.PlainRenderer@1d81c7, chartRenderer=null, eventDetectors=null, comments=null, defaultCacheSize=1, discardExtremeValues=false, discardLowLimit=-1.7976931348623157E308, discardHighLimit=1.7976931348623157E308, engineeringUnits=95, chartColour=null, plotType=1, pointLocator=com.serotonin.m2m2.internal.InternalPointLocatorVO@3cb8f1, dataSourceTypeName=INTERNAL, dataSourceName=VISU, dataSourceXid=DS_412070, lastValue=null, settable=false]]
org.springframework.web.servlet.DispatcherServlet.LOCALE_RESOLVER=org.springframework.web.servlet.i18n.SessionLocaleResolver@7da901SESSION ATTRIBUTES
LONG_POLL_DATA_TIMEOUT=1348503765228
LONG_POLL_DATA=[com.serotonin.m2m2.web.dwr.longPoll.LongPollData@1e29a8c, com.serotonin.m2m2.web.dwr.longPoll.LongPollData@108a67]
sessionUser=User [id=1, username=admin, password=0DPiKuNIrrVmD8IUCuw1hQxNqZc=, email=admin@yourMangoDomain.com, phone=, admin=true, disabled=false, dataSourcePermissions=[], dataPointPermissions=[], homeUrl=null, lastLogin=1348502756332, receiveAlarmEmails=0, receiveOwnAuditEvents=false, timezone=null]CONTEXT ATTRIBUTES
org.springframework.web.servlet.FrameworkServlet.CONTEXT.springDispatcher=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Mon Sep 24 12:21:48 EDT 2012]; parent: Root WebApplicationContext
com.sun.jsp.tagFileJarUrlsCache={}
constants.AuditEventType.TYPE_DATA_POINT=DATA_POINT
constants.Permissions.DataPointAccessTypes.DATA_SOURCE=3
constants.SystemEventType.TYPE_EMAIL_SEND_FAILURE=EMAIL_SEND_FAILURE
DwrContainer=org.directwebremoting.impl.DefaultContainer@1eea070
constants.SystemEventType.TYPE_USER_LOGIN=USER_LOGIN
constants.SystemEventType.TYPE_PROCESS_FAILURE=PROCESS_FAILURE
constants.EventType.EventTypeNames.PUBLISHER=PUBLISHER
constants.DataTypes.IMAGE=5
constants.Permissions.DataPointAccessTypes.READ=1
org.springframework.web.context.support.ServletContextScope=org.springframework.web.context.support.ServletContextScope@167213b
constants.EventType.EventTypeNames.DATA_POINT=DATA_POINT
constants.SystemEventType.TYPE_SYSTEM_STARTUP=SYSTEM_STARTUP
constants.Permissions.DataPointAccessTypes.NONE=0
constants.Common.NEW_ID=-1
DataSourceListDwr=com.serotonin.m2m2.web.dwr.DataSourceListDwr@1b6e7c8
javax.servlet.ServletConfig=org.eclipse.jetty.servlet.ServletHolder$Config@12b13f1
constants.Permissions.DataPointAccessTypes.ADMIN=4
constants.UserComment.TYPE_EVENT=1
org.directwebremoting.WebContextFactory$WebContextBuilder=org.directwebremoting.impl.DefaultWebContextBuilder@12a3c05
constants.AuditEventType.TYPE_POINT_EVENT_DETECTOR=POINT_EVENT_DETECTOR
constants.EventType.EventTypeNames.AUDIT=AUDIT
constants.EventType.EventTypeNames.SYSTEM=SYSTEM
constants.DataTypes.MULTISTATE=2
org.directwebremoting.impl.ServerContext=org.directwebremoting.impl.DefaultServerContext@1ca7e4c
javax.servlet.http.HttpServlet=org.directwebremoting.servlet.DwrServlet@129c503
MiscDwr=com.serotonin.m2m2.web.dwr.MiscDwr@1455f1f
com.sun.jsp.taglibraryCache=EXCEPTION in String.valueOf: null
javax.servlet.context.tempdir=/tmp/jetty-0.0.0.0-8080-web-_-any-
DataPointDetailsDwr=com.serotonin.m2m2.web.dwr.DataPointDetailsDwr@b2601
constants.DataTypes.ALPHANUMERIC=4
constants.SystemEventType.TYPE_MAX_ALARM_LEVEL_CHANGED=MAX_ALARM_LEVEL_CHANGED
org.apache.catalina.jsp_classpath=/home/smartplant/M2M2/web/modules/virtualDS/classes:/home/smartplant/M2M2/web/modules/virtualDS/lib/m2m2-virtualDS-1.4.0.jar:/home/smartplant/M2M2/web/modules/lang_fi/classes:/home/smartplant/M2M2/web/modules/lang_fi/lib/m2m2-lang_fi-0.9.2.jar:/home/smartplant/M2M2/web/modules/vmstat/classes:/home/smartplant/M2M2/web/modules/vmstat/lib/m2m2-vmstat-1.4.0.jar:/home/smartplant/M2M2/web/modules/internal/classes:/home/smartplant/M2M2/web/modules/internal/lib/m2m2-internal-1.4.0.jar:/home/smartplant/M2M2/web/modules/graphicalViews/classes:/home/smartplant/M2M2/web/modules/graphicalViews/lib/m2m2-graphicalViews-1.4.0.jar:/home/smartplant/M2M2/web/modules/log4JReset/classes:/home/smartplant/M2M2/web/modules/log4JReset/lib/m2m2-log4JReset-1.0.1.jar:/home/smartplant/M2M2/web/modules/sstGraphics/classes:/home/smartplant/M2M2/web/modules/sstGraphics/lib/m2m2-sstGraphics-1.0.1.jar:/home/smartplant/M2M2/web/modules/jspViews/classes:/home/smartplant/M2M2/web/modules/jspViews/lib/m2m2-jspViews-1.1.0.jar:/home/smartplant/M2M2/web/modules/reports/classes:/home/smartplant/M2M2/web/modules/reports/lib/m2m2-reports-2.0.0.jar:/home/smartplant/M2M2/web/modules/dglux/classes:/home/smartplant/M2M2/web/modules/dglux/lib/m2m2-dglux-1.0.0.jar:/home/smartplant/M2M2/web/modules/lang_nl/classes:/home/smartplant/M2M2/web/modules/lang_nl/lib/m2m2-lang_nl-0.5.1.jar:/home/smartplant/M2M2/web/modules/lang_zh/classes:/home/smartplant/M2M2/web/modules/lang_zh/lib/m2m2-lang_zh-0.5.1.jar:/home/smartplant/M2M2/web/modules/lang_en/classes:/home/smartplant/M2M2/web/modules/lang_en/lib/m2m2-lang_en-1.0.1.jar:/home/smartplant/M2M2/web/modules/pointLinks/classes:/home/smartplant/M2M2/web/modules/pointLinks/lib/m2m2-pointLinks-1.4.0.jar:/home/smartplant/M2M2/web/modules/sstTheme/classes:/home/smartplant/M2M2/web/modules/sstTheme/lib/m2m2-sstTheme-1.0.1.jar:/home/smartplant/M2M2/web/modules/lang_pt/classes:/home/smartplant/M2M2/web/modules/lang_pt/lib/m2m2-lang_pt-0.5.1.jar:/home/smartplant/M2M2/web/modules/watchlists/classes:/home/smartplant/M2M2/web/modules/watchlists/lib/m2m2-watchlists-1.4.0.jar:/home/smartplant/M2M2/web/modules/lang_de/classes:/home/smartplant/M2M2/web/modules/lang_de/lib/m2m2-lang_de-0.5.1.jar:/home/smartplant/M2M2/web/modules/scheduledEvents/classes:/home/smartplant/M2M2/web/modules/scheduledEvents/lib/m2m2-scheduledEvents-1.4.0.jar:/home/smartplant/M2M2/web/modules/dataImport/classes:/home/smartplant/M2M2/web/modules/dataImport/lib/opencsv-2.2.jar:/home/smartplant/M2M2/web/modules/dataImport/lib/m2m2-dataImport-1.2.1.jar:/home/smartplant/M2M2/web/modules/sqlds/classes:/home/smartplant/M2M2/web/modules/sqlds/lib/m2m2-sqlds-1.4.0.jar
org.directwebremoting.ContainerList=[org.directwebremoting.impl.DefaultContainer@1eea070]
constants.SystemEventType.TYPE_SET_POINT_HANDLER_FAILURE=SET_POINT_HANDLER_FAILURE
constants.DataTypes.BINARY=1
org.directwebremoting.Container=org.directwebremoting.impl.DefaultContainer@1eea070
org.springframework.web.context.WebApplicationContext.ROOT=Root WebApplicationContext: startup date [Mon Sep 24 12:21:45 EDT 2012]; root of context hierarchy
constants.EventType.EventTypeNames.DATA_SOURCE=DATA_SOURCE
constants.SystemEventType.TYPE_LICENSE_CHECK=LICENSE_CHECK
jspx.1st.request=true
constants.AuditEventType.TYPE_EVENT_HANDLER=EVENT_HANDLER
constants.Permissions.DataPointAccessTypes.SET=2
clientSideMessages={js.help.lastUpdated=com.serotonin.m2m2.i18n.TranslatableMessage@729293fd, js.help.error=com.serotonin.m2m2.i18n.TranslatableMessage@f876c0, common.disabledToggle=com.serotonin.m2m2.i18n.TranslatableMessage@d7f89333, header.mute=com.serotonin.m2m2.i18n.TranslatableMessage@43df3cba, js.email.testSent=com.serotonin.m2m2.i18n.TranslatableMessage@f59d9881, common.administrator=com.serotonin.m2m2.i18n.TranslatableMessage@a467f3ea, js.help.related=com.serotonin.m2m2.i18n.TranslatableMessage@3dce6ae3, common.sendTestEmail=com.serotonin.m2m2.i18n.TranslatableMessage@8fd89c9f, js.email.noRecipForEmail=com.serotonin.m2m2.i18n.TranslatableMessage@4b694592, common.enabledToggle=com.serotonin.m2m2.i18n.TranslatableMessage@ea5c2f12, js.email.addAddress=com.serotonin.m2m2.i18n.TranslatableMessage@cbb9a38a, header.unmute=com.serotonin.m2m2.i18n.TranslatableMessage@d635aa93, js.email.addMailingList=com.serotonin.m2m2.i18n.TranslatableMessage@6fa4a69f, common.alarmLevel.lifeSafety=com.serotonin.m2m2.i18n.TranslatableMessage@1c71626, common.loading=com.serotonin.m2m2.i18n.TranslatableMessage@cf5f0419, common.minimize=com.serotonin.m2m2.i18n.TranslatableMessage@5d740b21, js.email.addUser=com.serotonin.m2m2.i18n.TranslatableMessage@49cc77b5, common.maximize=com.serotonin.m2m2.i18n.TranslatableMessage@c752a74f, js.email.noRecipients=com.serotonin.m2m2.i18n.TranslatableMessage@d78563d2, common.user=com.serotonin.m2m2.i18n.TranslatableMessage@8a9479ce, common.alarmLevel.none=com.serotonin.m2m2.i18n.TranslatableMessage@223c1a70, common.access.set=com.serotonin.m2m2.i18n.TranslatableMessage@a3e5309b, events.silence=com.serotonin.m2m2.i18n.TranslatableMessage@8376c0ac, common.disabled=com.serotonin.m2m2.i18n.TranslatableMessage@be9bfeff, common.access.read=com.serotonin.m2m2.i18n.TranslatableMessage@d8bff83d, common.alarmLevel.critical=com.serotonin.m2m2.i18n.TranslatableMessage@2b076d7, common.alarmLevel.info=com.serotonin.m2m2.i18n.TranslatableMessage@2239cfe6, events.unsilence=com.serotonin.m2m2.i18n.TranslatableMessage@29ad6533, common.alarmLevel.urgent=com.serotonin.m2m2.i18n.TranslatableMessage@8fa9c879}
constants.SystemEventType.TYPE_SYSTEM_SHUTDOWN=SYSTEM_SHUTDOWN
constants.UserComment.TYPE_POINT=2
constants.DataTypes.NUMERIC=3
constants.AuditEventType.TYPE_DATA_SOURCE=DATA_SOURCECan this be reproduced? Is it a configuration issue or a bug? Thanks,
Jordan
-
I was able to duplicate this so must be a bug we'll look into.
Thanks,
Joel.
-
I don't see a problem with the code. Could be a problem with the specific module from the download site. I've uploaded a rebuilt module. It has the same version, but you may have better results. Please download and give it another try.
-
Still has the same result for me.
-
Thank you both for the quick responses. I re-downloaded the SQL module, stuck it in the modules folder, and restarted the instance from the modules screen. When it came back up it unfortunately still generates the same error. Thanks again,
Jordan
-
Works for me. Can you try re-downloading the core too? There was a change on Friday that might make a difference.
-
Hi Matthew,
I downloaded a fresh core this morning from the bundled core with included modules link. However, this problem appears to precede the very latest core as it first appeared in the prior minor version as well. It also appears to have broken editing the existing data sources as well. Joel was able to reproduce it too. Can you check his setup and see if you can reproduce it? Thanks,
Jordan
-
Ok, i've uploaded version 2.0.1, which i've successfully tested against the SQL data source at least. Please have a try and let me know if it works better.
-
Will do in the morning and will report back ASAP. Thank you very much again!
Jordan
-
2.0.1 works!
-
Looks great! Thanks for the R & D Matthew and thanks for the validation testing Joel. I normally dislike smilies, but :mrgreen:. Thanks again,
Jordan
