Ótimo scadabr, se tiver tempo tentarei a solução, senão aguardarei a versão 0.9.1. Este erro não é urgente para mim agora, por enquanto estou apenas testando todas as funcionalidades do software antes de colocá-lo em ambientes de produção.
Agora que a versão 0.9.1 foi lançada, retomei os testes.
Eu instalei uma instância do 0.9.1 e importei o banco de dados de uma instalação 0.9. A importação funcionou, e o ScadaBR está aparentemente funcionando de forma adequada.
Mas os testes com relatórios não funcionaram. Anteriormente, o problema era só quando se incluia os eventos no relatório, mas agora não está funcionando de jeito nenhum.
O sistema acusa falha na execução, e ao tentar baixar os dados, e depois clicando em “Show error details”, aparece:
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select id, dataSourceName, pointName, dataType, startValue, textRenderer, colour, consolidatedChart from reportInstancePoints where reportInstanceId=?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘consolidatedChart’ in ‘field list’
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.translate(SQLExceptionSubclassTranslator.java:78)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:237)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:606)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:640)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:677)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:709)
at com.serotonin.db.spring.ExtendedJdbcTemplate.query(ExtendedJdbcTemplate.java:159)
at com.serotonin.db.DaoUtils.query(DaoUtils.java:189)
at com.serotonin.mango.db.dao.ReportDao.reportInstanceData(ReportDao.java:422)
at com.serotonin.mango.web.servlet.ReportExportBase.execute(ReportExportBase.java:63)
at com.serotonin.mango.web.servlet.ReportExportServlet.doGet(ReportExportServlet.java:34)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘consolidatedChart’ in ‘field list’
at sun.reflect.GeneratedConstructorAccessor35.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:99)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:647)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:590)
… 23 more
REQUEST URL
http://192.168.0.110:8080/scadabr_demo/exception/error.jsp
REQUEST PARAMETERS
instanceId=10
REQUEST HEADERS
host=192.168.0.110:8080
user-agent=Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
accept=text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
accept-language=pt-br,pt;q=0.8,en-us;q=0.5,en;q=0.3
accept-encoding=gzip, deflate
accept-charset=ISO-8859-1,utf-8;q=0.7,*;q=0.7
connection=keep-alive
referer=http://192.168.0.110:8080/scadabr_demo/reports.shtm
cookie=JSESSIONID=72AA2DBB6D882E356F392EA1805B7DBE
REQUEST ATTRIBUTES
javax.servlet.forward.request_uri=/scadabr_demo/export/Relat%C3%B3rio1.csv
javax.servlet.forward.context_path=/scadabr_demo
javax.servlet.forward.servlet_path=/export
javax.servlet.forward.path_info=/exception/error.jsp
javax.servlet.forward.query_string=instanceId=10
javax.servlet.error.status_code=500
javax.servlet.error.servlet_name=reportExport
javax.servlet.error.message=
javax.servlet.error.exception=org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select id, dataSourceName, pointName, dataType, startValue, textRenderer, colour, consolidatedChart from reportInstancePoints where reportInstanceId=?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘consolidatedChart’ in ‘field list’
sessionUser=com.serotonin.mango.vo.User@20
javax.servlet.error.request_uri=/scadabr_demo/export/Relat%C3%B3rio1.csv
SESSION ATTRIBUTES
LONG_POLL_DATA_TIMEOUT=1319574261459
sessionUser=com.serotonin.mango.vo.User@20
LONG_POLL_DATA=[com.serotonin.mango.web.dwr.longPoll.LongPollData@349d52ac, com.serotonin.mango.web.dwr.longPoll.LongPollData@449eb530, com.serotonin.mango.web.dwr.longPoll.LongPollData@719bc401, com.serotonin.mango.web.dwr.longPoll.LongPollData@296157ec, com.serotonin.mango.web.dwr.longPoll.LongPollData@1d2fa9ae, com.serotonin.mango.web.dwr.longPoll.LongPollData@5e8bb0f8, com.serotonin.mango.web.dwr.longPoll.LongPollData@46881911, com.serotonin.mango.web.dwr.longPoll.LongPollData@18de9738]
CONTEXT ATTRIBUTES
constants.EventType.EventSources.PUBLISHER=7
constants.DataSourceVO.Types.MODBUS_SERIAL=2
constants.DataSourceVO.Types.HTTP_IMAGE=15
org.directwebremoting.impl.ServerContext=org.directwebremoting.impl.DefaultServerContext@f898582
constants.DataSourceVO.Types.M_BUS=20
constants.DataSourceVO.Types.SQL=6
constants.UserComment.TYPE_EVENT=1
constants.DataSourceVO.Types.ONE_WIRE=8
constants.DataSourceVO.Types.OPC=32
constants.DataSourceVO.Types.DR_STORAGE_HT5B=38
org.apache.catalina.WELCOME_FILES=[Ljava.lang.String;@d9c21c6
constants.DataSourceVO.Types.ASCII_SERIAL=34
constants.DataSourceVO.Types.HTTP_RECEIVER=7
constants.DataSourceVO.Types.VIRTUAL=1
DYNAMIC_IMAGES=[com.serotonin.mango.view.DynamicImage@56d5525, com.serotonin.mango.view.DynamicImage@4cf0f2eb, com.serotonin.mango.view.DynamicImage@5edc49c3, com.serotonin.mango.view.DynamicImage@506ed1dc]
constants.DataSourceVO.Types.INTERNAL=27
constants.DataSourceVO.Types.MODBUS_IP=3
javax.servlet.context.tempdir=/usr/share/tomcat6/work/Catalina/localhost/scadabr_demo
constants.UserComment.TYPE_POINT=2
constants.AuditEventType.TYPE_COMPOUND_EVENT_DETECTOR=4
constants.DataSourceVO.Types.SNMP=5
constants.SystemEventType.TYPE_VERSION_CHECK=5
constants.AuditEventType.TYPE_EVENT_HANDLER=6
org.springframework.web.servlet.FrameworkServlet.CONTEXT.springDispatcher=org.springframework.web.context.support.XmlWebApplicationContext@3b34c0a6: display name [WebApplicationContext for namespace ‘springDispatcher-servlet’]; startup date [Tue Oct 25 17:58:08 BRST 2011]; parent: org.springframework.web.context.support.XmlWebApplicationContext@6d7e4dee
constants.Common.NEW_ID=-1
org.apache.catalina.jsp_classpath=/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/classes/:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/OneWireAPI.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/RXTXcomm.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/SNMP4J.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/activation.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/alpha24j.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/axis.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/bacnet4J.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-beanutils-1.8.3.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-codec-1.3.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-collections-3.2.1.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-dbcp-jdbc4.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-discovery-0.2.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-fileupload.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-httpclient-3.0.1.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-io.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-lang-2.5.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-logging.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/commons-pool.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/crowd-integration-client-2.1.1.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/derby.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/derbytools.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/dnp3.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/dnp34j.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/dwr.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/ezmorph-1.0.6.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/fhz4j-core-0.1.4-SNAPSHOT.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/freemarker.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/iec101.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/j-interop-2.06.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/j-interopdeps-1.4.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/jaxrpc.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/jcifs-1.2.19.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/jcommon-1.0.14.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/jdom-1.0.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/jfreechart-1.0.11.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/joda-time-1.3.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/json-lib-2.3-jdk15.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/jstl-api-1.2.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/jstl-impl-1.2.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/jstl.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/junit-4.8.2.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/log4j-1.2.14.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/mail.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/mbus4j-core-0.1.4-SNAPSHOT.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/mbus4j-master-0.1.4-SNAPSHOT.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/modbus4J.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/mysql-connector-java-3.1.8-bin.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/mysql-connector-java-5.1.7-bin.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/opc-driver.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/openscada-utils.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/openv4j-core-0.1.4-SNAPSHOT.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/org.openscada.opc.dcom-0.5.0.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/org.openscada.opc.lib-0.5.0.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/quartz-1.6.3.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/rts.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/saaj.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/seroUtils.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/slf4j-api-1.5.11.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/slf4j-log4j12-1.5.11.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/spinwave.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/spring-webmvc.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/spring.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/sqljdbc4.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/standard.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/taglibs-log.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/viconics.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/wsdl4j-1.5.1.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/wsdl4j.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/wss4j-1.5.8.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/xfire-aegis-1.2.6.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/xfire-core-1.2.6.jar:/usr/share/tomcat6/webapps/scadabr_demo/WEB-INF/lib/xmlsec-1.4.3.jar:/usr/share/tomcat6/lib/:/usr/share/tomcat6/lib/tomcat-coyote.jar:/usr/share/tomcat6/lib/tomcat-i18n-es.jar:/usr/share/tomcat6/lib/jasper-el.jar:/usr/share/tomcat6/lib/servlet-api.jar:/usr/share/tomcat6/lib/catalina-tribes.jar:/usr/share/tomcat6/lib/jasper.jar:/usr/share/tomcat6/lib/annotations-api.jar:/usr/share/tomcat6/lib/tomcat-i18n-ja.jar:/usr/share/tomcat6/lib/jsp-api.jar:/usr/share/tomcat6/lib/ecj-3.3.1.jar:/usr/share/tomcat6/lib/catalina.jar:/usr/share/tomcat6/lib/tomcat-i18n-fr.jar:/usr/share/tomcat6/lib/tomcat-dbcp.jar:/usr/share/tomcat6/lib/catalina-ha.jar:/usr/share/tomcat6/lib/el-api.jar:/usr/share/tomcat6/lib/catalina-ant.jar:/usr/share/tomcat6/bin/bootstrap.jar:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/ext/sunjce_provider.jar:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/ext/localedata.jar:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/ext/dnsns.jar:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/ext/sunpkcs11.jar
javax.servlet.ServletConfig=org.apache.catalina.core.StandardWrapperFacade@1b93ebc5
constants.EventType.EventSources.SYSTEM=4
org.apache.jasper.runtime.JspApplicationContextImpl=org.apache.jasper.runtime.JspApplicationContextImpl@c5be0a8
org.apache.catalina.resources=org.apache.naming.resources.ProxyDirContext@63fa3bee
DwrContainer=org.directwebremoting.impl.DefaultContainer@4174b989
constants.PublisherVO.Types.PACHUBE=2
constants.DataTypes.NUMERIC=3
javax.servlet.http.HttpServlet=org.directwebremoting.servlet.DwrServlet@5640f2f1
constants.DataSourceVO.Types.EBI25=16
constants.DataTypes.IMAGE=5
constants.AuditEventType.TYPE_DATA_SOURCE=1
AdminServletAxisEngine=org.apache.axis.server.AxisServer@420dd874
constants.DataSourceVO.Types.SPINWAVE=4
constants.AuditEventType.TYPE_DATA_POINT=2
constants.DataSourceVO.Types.IEC101_SERIAL=35
constants.DataSourceVO.Types.DNP3_IP=21
constants.Permissions.DataPointAccessTypes.SET=2
org.directwebremoting.WebContextFactory$WebContextBuilder=org.directwebremoting.impl.DefaultWebContextBuilder@1afdc98d
constants.SystemEventType.TYPE_SET_POINT_HANDLER_FAILURE=7
constants.AuditEventType.TYPE_POINT_LINK=7
org.springframework.web.context.WebApplicationContext.ROOT=org.springframework.web.context.support.XmlWebApplicationContext@6d7e4dee: display name [Root WebApplicationContext]; startup date [Tue Oct 25 17:58:05 BRST 2011]; root of context hierarchy
constants.SystemEventType.TYPE_USER_LOGIN=4
IMAGE_SETS=[com.serotonin.mango.view.ImageSet@bbb55d3, com.serotonin.mango.view.ImageSet@37ff95a9, com.serotonin.mango.view.ImageSet@6cbaa6f7, com.serotonin.mango.view.ImageSet@5227d9e5, com.serotonin.mango.view.ImageSet@36527386, com.serotonin.mango.view.ImageSet@5f1e7e46, com.serotonin.mango.view.ImageSet@4af45673, com.serotonin.mango.view.ImageSet@6f57be76, com.serotonin.mango.view.ImageSet@69996e15, com.serotonin.mango.view.ImageSet@580a5adc, com.serotonin.mango.view.ImageSet@fd34eac, com.serotonin.mango.view.ImageSet@79d20651, com.serotonin.mango.view.ImageSet@4b9cee52, com.serotonin.mango.view.ImageSet@2be27046, com.serotonin.mango.view.ImageSet@1f391a2c, com.serotonin.mango.view.ImageSet@5de54eb7, com.serotonin.mango.view.ImageSet@79930089, com.serotonin.mango.view.ImageSet@220860ba, com.serotonin.mango.view.ImageSet@540664ca, com.serotonin.mango.view.ImageSet@6fc334de, com.serotonin.mango.view.ImageSet@78c41424, com.serotonin.mango.view.ImageSet@1106856d, com.serotonin.mango.view.ImageSet@4321bfd6, com.serotonin.mango.view.ImageSet@5cb99d08, com.serotonin.mango.view.ImageSet@1df4a7c7, com.serotonin.mango.view.ImageSet@2933092e, com.serotonin.mango.view.ImageSet@559fc023, com.serotonin.mango.view.ImageSet@6aff65bf, com.serotonin.mango.view.ImageSet@2571157a, com.serotonin.mango.view.ImageSet@23390fca, com.serotonin.mango.view.ImageSet@773ba8d6, com.serotonin.mango.view.ImageSet@6dc9b6c1, com.serotonin.mango.view.ImageSet@55fd7136, com.serotonin.mango.view.ImageSet@7213bc54, com.serotonin.mango.view.ImageSet@6db1694e, com.serotonin.mango.view.ImageSet@1a78b825, com.serotonin.mango.view.ImageSet@6b8192b6, com.serotonin.mango.view.ImageSet@7c721de, com.serotonin.mango.view.ImageSet@228079cf, com.serotonin.mango.view.ImageSet@20bd16bb, com.serotonin.mango.view.ImageSet@5e1f5fc7, com.serotonin.mango.view.ImageSet@5dc93217, com.serotonin.mango.view.ImageSet@43f7b41b, com.serotonin.mango.view.ImageSet@3b517b79, com.serotonin.mango.view.ImageSet@6281635b, com.serotonin.mango.view.ImageSet@1ca21de3, com.serotonin.mango.view.ImageSet@575830c4, com.serotonin.mango.view.ImageSet@5ee9c0a8, com.serotonin.mango.view.ImageSet@44678646, com.serotonin.mango.view.ImageSet@68a080bf, com.serotonin.mango.view.ImageSet@164b143, com.serotonin.mango.view.ImageSet@79b1a66b, com.serotonin.mango.view.ImageSet@7e24f937, com.serotonin.mango.view.ImageSet@2d65ca94, com.serotonin.mango.view.ImageSet@75d6d1d4, com.serotonin.mango.view.ImageSet@6a69f1bc, com.serotonin.mango.view.ImageSet@517da438, com.serotonin.mango.view.ImageSet@fa88254, com.serotonin.mango.view.ImageSet@460d4, com.serotonin.mango.view.ImageSet@1f70fe4e, com.serotonin.mango.view.ImageSet@3347c302, com.serotonin.mango.view.ImageSet@2c53d29b, com.serotonin.mango.view.ImageSet@3327d4d9]
constants.DataSourceVO.Types.ALPHA_2=39
constants.DataTypes.ALPHANUMERIC=4
constants.PublisherVO.Types.HTTP_SENDER=1
constants.EventType.EventSources.SCHEDULED=6
constants.DataTypes.BINARY=1
HTTP_RECEIVER_MULTICASTER=com.serotonin.mango.rt.dataSource.http.HttpReceiverMulticaster@7c070ccb
constants.SystemEventType.TYPE_MAX_ALARM_LEVEL_CHANGED=3
clientSideMessages={js.help.lastUpdated=com.serotonin.web.i18n.LocalizableMessage@729293fd, js.disabledSe=com.serotonin.web.i18n.LocalizableMessage@97a7b393, js.disabledPointLink=com.serotonin.web.i18n.LocalizableMessage@25407509, js.help.error=com.serotonin.web.i18n.LocalizableMessage@f876c0, common.disabledToggle=com.serotonin.web.i18n.LocalizableMessage@d7f89333, header.mute=com.serotonin.web.i18n.LocalizableMessage@43df3cba, js.email.testSent=com.serotonin.web.i18n.LocalizableMessage@f59d9881, common.administrator=com.serotonin.web.i18n.LocalizableMessage@a467f3ea, js.help.related=com.serotonin.web.i18n.LocalizableMessage@3dce6ae3, common.sendTestEmail=com.serotonin.web.i18n.LocalizableMessage@8fd89c9f, compoundDetectors.compoundEventDetector=com.serotonin.web.i18n.LocalizableMessage@51020f89, js.email.noRecipForEmail=com.serotonin.web.i18n.LocalizableMessage@4b694592, common.enabledToggle=com.serotonin.web.i18n.LocalizableMessage@ea5c2f12, js.email.addAddress=com.serotonin.web.i18n.LocalizableMessage@cbb9a38a, header.unmute=com.serotonin.web.i18n.LocalizableMessage@d635aa93, pointLinks.pointLink=com.serotonin.web.i18n.LocalizableMessage@2c6dd5e5, js.email.addMailingList=com.serotonin.web.i18n.LocalizableMessage@6fa4a69f, scheduledEvents.se=com.serotonin.web.i18n.LocalizableMessage@b5cc6cfa, common.alarmLevel.lifeSafety=com.serotonin.web.i18n.LocalizableMessage@1c71626, common.minimize=com.serotonin.web.i18n.LocalizableMessage@5d740b21, js.email.addUser=com.serotonin.web.i18n.LocalizableMessage@49cc77b5, js.disabledCed=com.serotonin.web.i18n.LocalizableMessage@5d4e0ee1, common.maximize=com.serotonin.web.i18n.LocalizableMessage@c752a74f, js.email.noRecipients=com.serotonin.web.i18n.LocalizableMessage@d78563d2, common.user=com.serotonin.web.i18n.LocalizableMessage@8a9479ce, common.alarmLevel.none=com.serotonin.web.i18n.LocalizableMessage@223c1a70, common.access.set=com.serotonin.web.i18n.LocalizableMessage@a3e5309b, js.help.loading=com.serotonin.web.i18n.LocalizableMessage@10dfaff4, events.silence=com.serotonin.web.i18n.LocalizableMessage@8376c0ac, common.disabled=com.serotonin.web.i18n.LocalizableMessage@be9bfeff, common.access.read=com.serotonin.web.i18n.LocalizableMessage@d8bff83d, common.alarmLevel.critical=com.serotonin.web.i18n.LocalizableMessage@2b076d7, common.alarmLevel.info=com.serotonin.web.i18n.LocalizableMessage@2239cfe6, events.unsilence=com.serotonin.web.i18n.LocalizableMessage@29ad6533, common.alarmLevel.urgent=com.serotonin.web.i18n.LocalizableMessage@8fa9c879}
constants.DataSourceVO.Types.NMEA=13
constants.DataTypes.MULTISTATE=2
constants.Permissions.DataPointAccessTypes.DATA_SOURCE=3
constants.DataSourceVO.Types.VMSTAT=17
constants.Permissions.DataPointAccessTypes.ADMIN=4
EVENT_MANAGER=com.serotonin.mango.rt.EventManager@32d9230a
constants.Permissions.DataPointAccessTypes.NONE=0
constants.SystemEventType.TYPE_POINT_LINK_FAILURE=9
constants.DataSourceVO.Types.PACHUBE=23
constants.DataSourceVO.Types.META=9
constants.SystemEventType.TYPE_PROCESS_FAILURE=10
constants.EventType.EventSources.MAINTENANCE=9
constants.EventType.EventSources.AUDIT=8
FREEMARKER_CONFIG=freemarker.template.Configuration@4d8b7f9a
constants.DataSourceVO.Types.ASCII_FILE=33
org.directwebremoting.ContainerList=[org.directwebremoting.impl.DefaultContainer@4174b989]
constants.DataSourceVO.Types.PERSISTENT=24
constants.SystemEventType.TYPE_SYSTEM_STARTUP=1
constants.SystemEventType.TYPE_SYSTEM_SHUTDOWN=2
constants.AuditEventType.TYPE_SCHEDULED_EVENT=5
AxisEngine=org.apache.axis.server.AxisServer@420dd874
constants.DataSourceVO.Types.POP3=12
constants.DataSourceVO.Types.HTTP_RETRIEVER=11
constants.DataSourceVO.Types.FHZ_4_J=40
org.directwebremoting.Container=org.directwebremoting.impl.DefaultContainer@4174b989
DATABASE_ACCESS=com.serotonin.mango.db.MySQLAccess@1667f3c
constants.PublisherVO.Types.PERSISTENT=3
constants.DataSourceVO.Types.NODAVE_S7=37
constants.DataSourceVO.Types.OPEN_V_4_J=19
constants.DataSourceVO.Types.VICONICS=18
constants.SystemEventType.TYPE_COMPOUND_DETECTOR_FAILURE=6
constants.EventType.EventSources.DATA_SOURCE=3
constants.EventType.EventSources.DATA_POINT=1
constants.Permissions.DataPointAccessTypes.READ=1
BACKGROUND_PROCESSING=com.serotonin.mango.rt.maint.BackgroundProcessing@702b3cdb
org.apache.AnnotationProcessor=org.apache.catalina.util.DefaultAnnotationProcessor@26a88765
RUNTIME_MANAGER=com.serotonin.mango.rt.RuntimeManager@2510bb7
constants.DataSourceVO.Types.DNP3_SERIAL=22
constants.DataSourceVO.Types.GALIL=14
constants.DataSourceVO.Types.IEC101_ETHERNET=36
constants.DataSourceVO.Types.BACNET=10
constants.AuditEventType.TYPE_POINT_EVENT_DETECTOR=3
constants.SystemEventType.TYPE_EMAIL_SEND_FAILURE=8
constants.EventType.EventSources.COMPOUND=5
constants.DataSourceVO.Types.JMX=26
Desenvolvedores, alguém pode dar uma olhada neste problema?
Obrigado,
Rodrigo Martinho.
Os relatórios estão funcionando para uma instalação nova da versão 0.9.1. Funcionou também para um projeto da versão 0.9 importado para a versão 0.9.1 através da função nativa de exportação/importação. O problema ocorre apenas quando importo diretamente a base dados de uma instalação 0.9 através do phpmyadmin. Como houve moificações nas tabelas da versão 0.9 para a 0.9.1, esta deve ser a causa do problema.
Creio que para trabalhar diretamente na versão 0.9.1 os relatórios estão funcionando perfeitamente.