JOSE LUIS GARCIA | [quote=Abel Morillo (Desarrollador Comerzzia)]Hola, Jose Luis.
La impresión de etiquetas de artículos con código de barras se hace desde el gestor de procesos. Es una funcionalidad que todas las tiendas que tienen intalado Comerzzia utilizan sin problema, por lo que a ti seguro que también te podrá funcionar.
Por lo que dices, cuando intentas ejecutar el informe para imprimir dichas etiquetas te aparece este error: "Se ha producido un error al ejecutar el informe solicitado"
Si es así, es porque, como dice el mensaje, ha habido algún problema ejecutando el informe. Para ver más detalles tendrías que copiarnos el log del servidor jboss. Este log lo puedes encontrar en la carpeta /Jboss/server/comerzzia/log/server.log que debe estar ubicada dentro de la carpeta de instalación de comerzzia.
De cualquier forma, te adelanto que si la mayoría de informes te está funcionando y el error sólo lo tienes en este, el problema más común con las etiquetas se debe a que se han escrito códigos de barra erróneos (se le han incluido letras, guiones, espacios, o un tamaño inadecuado). Para saber exactamente el problema, puedes copiarnos aquí el log y lo revisamos.
Un saludo.
------------------------
Hola. A ver si esto sirve:
2012-09-18 00:08:42,937 DEBUG [com.comerzzia.web.core.informes.InformesServlet] Abriendo conexión para ejecutar informe con: java:/jdbc/COMERZZIA_DS 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.fill.JRBaseFiller] Fill 11507148: created for Etiquetas 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.fill.JRBaseFiller] Fill 11507148: filling report 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.fill.JRFillDataset] Fill 11507148: Creating sql query executer 2012-09-18 00:08:42,937 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 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #1 (CODART_DESDE of type java.lang.String): 3000001 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #2 (CODART_HASTA of type java.lang.String): 3000007 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #3 (CODPRO_DESDE of type java.lang.String): 400001 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #4 (CODPRO_HASTA of type java.lang.String): 400002 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #5 (CODFAM_DESDE of type java.lang.String): 001 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.query.JRJdbcQueryExecuter] Parameter #6 (CODFAM_HASTA of type java.lang.String): 003 2012-09-18 00:08:42,937 DEBUG [net.sf.jasperreports.engine.fill.JRFillDataset] Fill 11507148: closing query executer 2012-09-18 00:08:42,937 ERROR [com.comerzzia.web.core.informes.InformesServlet] Se ha producido un error al intentar ejecutar informe.Error executing SQL statement for : Etiquetas 2012-09-18 00:08:42,937 ERROR net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Etiquetas 2012-09-18 00:08:42,937 ERROR at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) 2012-09-18 00:08:42,937 ERROR at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:685) 2012-09-18 00:08:42,937 ERROR at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605) 2012-09-18 00:08:42,937 ERROR at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1235) 2012-09-18 00:08:42,937 ERROR at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:865) 2012-09-18 00:08:42,937 ERROR at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:814) 2012-09-18 00:08:42,937 ERROR at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) 2012-09-18 00:08:42,937 ERROR at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421) 2012-09-18 00:08:42,937 ERROR at com.comerzzia.web.core.informes.InformesServlet.service(InformesServlet.java:85) 2012-09-18 00:08:42,937 ERROR at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2012-09-18 00:08:42,937 ERROR at com.comerzzia.web.core.filtros.SessionFilter.doFilter(SessionFilter.java:63) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2012-09-18 00:08:42,937 ERROR at com.comerzzia.web.core.filtros.EncodingFilter.doFilter(EncodingFilter.java:53) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2012-09-18 00:08:42,937 ERROR at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 2012-09-18 00:08:42,937 ERROR at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) 2012-09-18 00:08:42,937 ERROR at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 2012-09-18 00:08:42,937 ERROR at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 2012-09-18 00:08:42,937 ERROR at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) 2012-09-18 00:08:42,937 ERROR at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 2012-09-18 00:08:42,937 ERROR at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) 2012-09-18 00:08:42,937 ERROR at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) 2012-09-18 00:08:42,937 ERROR at java.lang.Thread.run(Thread.java:619) 2012-09-18 00:08:42,953 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 2012-09-18 00:08:42,953 ERROR at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2012-09-18 00:08:42,953 ERROR at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) 2012-09-18 00:08:42,953 ERROR at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) 2012-09-18 00:08:42,953 ERROR at java.lang.reflect.Constructor.newInstance(Constructor.java:513) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.Util.getInstance(Util.java:381) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) 2012-09-18 00:08:42,953 ERROR at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) 2012-09-18 00:08:42,953 ERROR at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342) 2012-09-18 00:08:42,953 ERROR at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135) 2012-09-18 00:08:42,953 ERROR ... 33 more
Un saludo JL |