amperex . | Pego el tocho que em devuelve el log tras intentar ejecutar la impresión de etiquetas:
2011-06-12 21:45:37,505 DEBUG [com.comerzzia.web.core.informes.InformesServlet] Abriendo informe: C:\Program Files (x86)\ComerZZia/servidor/jboss-4.2.3.GA/server/comerzzia/recursos/informes/general/articulos/lstArticulos_Etiquetas.jasper 2011-06-12 21:45:37,505 DEBUG [com.comerzzia.web.core.informes.InformesServlet] Abriendo conexión para ejecutar informe con: java:/jdbc/COMERZZIA_DS 2011-06-12 21:45:37,542 DEBUG [net.sf.jasperreports.engine.fill.JRBaseFiller] Fill 27401742: created for Etiquetas 2011-06-12 21:45:37,543 DEBUG [net.sf.jasperreports.engine.fill.JRBaseFiller] Fill 27401742: filling report 2011-06-12 21:45:37,544 DEBUG [net.sf.jasperreports.engine.fill.JRFillDataset] Fill 27401742: Creating sql query executer 2011-06-12 21:45:37,544 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] SQL query string: SELECT D_ARTICULOS_TBL."CODART" AS D_ARTICULOS_TBL_CODART, D_ARTICULOS_TBL."DESART" AS D_ARTICULOS_TBL_DESART, D_ARTICULOS_CODBAR_TBL."CODIGO_BARRAS" AS D_ARTICULOS_CODBAR_TBL_CODIGO_, D_TARIFAS_DET_TBL."PRECIO_TOTAL" AS D_TARIFAS_DET_TBL_PRECIO_VENTA, ETIQUETAS."DESETIQUETA" AS DESETIQUETA, ETIQUETAS."FACTOR" AS FACTOR, D_ARTICULOS_TBL."CANTIDAD_UM_ETIQUETA" AS CANTIDAD FROM "D_ARTICULOS_CODBAR_TBL" D_ARTICULOS_CODBAR_TBL RIGHT OUTER JOIN "D_ARTICULOS_TBL" D_ARTICULOS_TBL ON D_ARTICULOS_CODBAR_TBL."CODART" = D_ARTICULOS_TBL."CODART" LEFT OUTER JOIN "D_TARIFAS_DET_TBL" D_TARIFAS_DET_TBL ON D_ARTICULOS_TBL."CODART" = D_TARIFAS_DET_TBL."CODART" LEFT OUTER JOIN "D_UNIDAD_MEDIDA_ETIQUETAS_TBL" ETIQUETAS ON D_ARTICULOS_TBL."COD_UM_ETIQUETA" = ETIQUETAS."COD_UM_ETIQUETA" WHERE D_ARTICULOS_TBL.CODART >= ? AND D_ARTICULOS_TBL.CODART <= ? AND D_ARTICULOS_TBL.CODPRO >= ? AND D_ARTICULOS_TBL.CODPRO <= ? AND D_ARTICULOS_TBL.CODFAM >= ? AND D_ARTICULOS_TBL.CODFAM <= ? AND D_ARTICULOS_TBL.ACTIVO = 'S' AND D_ARTICULOS_CODBAR_TBL.DUN14 = 'N' AND LENGTH(D_ARTICULOS_CODBAR_TBL.CODIGO_BARRAS) = 13 AND D_TARIFAS_DET_TBL.CODTAR = 'GENERAL' ORDER BY D_ARTICULOS_TBL.CODART ASC 2011-06-12 21:45:37,544 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #1 (CODART_DESDE of type java.lang.String): 0 2011-06-12 21:45:37,544 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #2 (CODART_HASTA of type java.lang.String): ZZZZZZZZZZZZZ 2011-06-12 21:45:37,544 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #3 (CODPRO_DESDE of type java.lang.String): 0 2011-06-12 21:45:37,544 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #4 (CODPRO_HASTA of type java.lang.String): ZZZZZZZZZZZ 2011-06-12 21:45:37,544 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #5 (CODFAM_DESDE of type java.lang.String): 0 2011-06-12 21:45:37,545 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #6 (CODFAM_HASTA of type java.lang.String): ZZZZZZ 2011-06-12 21:45:37,545 DEBUG [net.sf.jasperreports.engine.fill.JRFillDataset] Fill 27401742: closing query executer 2011-06-12 21:45:37,545 ERROR [com.comerzzia.web.core.informes.InformesServlet] Se ha producido un error al intentar ejecutar informe.Error executing SQL statement for : Etiquetas 2011-06-12 21:45:37,545 ERROR net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Etiquetas 2011-06-12 21:45:37,545 ERROR at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) 2011-06-12 21:45:37,546 ERROR at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:685) 2011-06-12 21:45:37,546 ERROR at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605) 2011-06-12 21:45:37,546 ERROR at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1235) 2011-06-12 21:45:37,546 ERROR at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:865) 2011-06-12 21:45:37,546 ERROR at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:814) 2011-06-12 21:45:37,546 ERROR at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) 2011-06-12 21:45:37,546 ERROR at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421) 2011-06-12 21:45:37,546 ERROR at com.comerzzia.web.core.informes.InformesServlet.service(InformesServlet.java:66) 2011-06-12 21:45:37,546 ERROR at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2011-06-12 21:45:37,546 ERROR at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 2011-06-12 21:45:37,546 ERROR at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2011-06-12 21:45:37,546 ERROR at com.comerzzia.web.core.filtros.SessionFilter.doFilter(SessionFilter.java:44) 2011-06-12 21:45:37,546 ERROR at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2011-06-12 21:45:37,546 ERROR at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2011-06-12 21:45:37,547 ERROR at com.comerzzia.web.core.filtros.EncodingFilter.doFilter(EncodingFilter.java:34) 2011-06-12 21:45:37,547 ERROR at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2011-06-12 21:45:37,547 ERROR at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2011-06-12 21:45:37,547 ERROR at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 2011-06-12 21:45:37,547 ERROR at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2011-06-12 21:45:37,547 ERROR at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2011-06-12 21:45:37,547 ERROR at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) 2011-06-12 21:45:37,547 ERROR at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 2011-06-12 21:45:37,547 ERROR at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) 2011-06-12 21:45:37,547 ERROR at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) 2011-06-12 21:45:37,547 ERROR at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 2011-06-12 21:45:37,547 ERROR at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 2011-06-12 21:45:37,547 ERROR at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) 2011-06-12 21:45:37,548 ERROR at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 2011-06-12 21:45:37,548 ERROR at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) 2011-06-12 21:45:37,548 ERROR at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 2011-06-12 21:45:37,548 ERROR at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) 2011-06-12 21:45:37,548 ERROR at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) 2011-06-12 21:45:37,548 ERROR at java.lang.Thread.run(Thread.java:619) 2011-06-12 21:45:37,548 ERROR Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"CODART" AS D_ARTICULOS_TBL_CODART, D_ARTICULOS_TBL."DESART" AS D_ARTICULOS' at line 2 2011-06-12 21:45:37,548 ERROR at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2011-06-12 21:45:37,548 ERROR at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) 2011-06-12 21:45:37,548 ERROR at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) 2011-06-12 21:45:37,548 ERROR at java.lang.reflect.Constructor.newInstance(Constructor.java:513) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.Util.getInstance(Util.java:381) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) 2011-06-12 21:45:37,549 ERROR at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) 2011-06-12 21:45:37,549 ERROR at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342) 2011-06-12 21:45:37,549 ERROR at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135) 2011-06-12 21:45:37,550 ERROR ... 33 more
Nose por donde coger el error ya que la consulta sql es algo farragosapara mi y tampoco estoy familiarizado con las tablas de comerzzia. Lo único que si que es verdad que he consultado para todos los productos y se da el caso que a mis productos no les tengo aplicados familias, proveedores y demás aunque no estoy seguro que eso tenga que ver. |