search

Trazalog / traz-prod-trazasoft

1 stars 0 forks source link

Producción-->Producción de lotes | Operarios: que se visualice el movimiento del reporte de producción #442

Closed floto-trazalog closed 3 weeks ago

floto-trazalog commented 4 months ago

Ambiente Producción - v2.2.20

Descripción: Este error o similar, se presentó en el issue #440 el cual fue solucionado en las pruebas del Ambiente de Test. Actualmente, sucede en Producción, tener en cuenta que el día miércoles 10/04 se ha realizado un despliegue.

Contexto: se realiza la prueba de integración Tools con Tango, para ello se genera un reporte de producción en un lote registrado previamente, (hace varios meses). En consecuencia, el sistema refleja el movimiento en la pantalla de Alacenes>>Stock pero no lo registra en la tabla y Pablo describe que figura un error al crear lote. Se adjunta el video con audio y luego, los errores del log

https://github.com/Trazalog/traz-prod-trazasoft/assets/88331456/969802a5-2edc-4665-9b67-57c1e059da11

Errores del Log

#TRAZA | #TRAZ-PROD-TRAZASOFT | Etapas | finalizarEtapa(datos)-> {"_post_lote_noconsumibles_list_batch_req":{"_post_lote_noconsumibles_list":[{"lote_id":"LOTE24011502","arti_id":"5518","prov_id":"1000","batch_id_padre":"1996","cantidad":"1","cantidad_padre":"0","num_orden_prod":"","reci_id":"485","etap_id":"2000","usuario_app":"admin@kolormax.com","empr_id":"8","forzar_agregar":"false","fec_vencimiento":"01-01-3000","fec_iniciado":"11-04-2024","recu_id":"2532","tipo_recurso":"HUMANO","batch_id":"0","planificado":"false","noco_list":""}]}}
DEBUG - 2024-04-11 17:55:52 --> #TRAZA | #REST | #CURL | #URL >> http://localhost:8283/services/PRDLoteDataService/_post_lote_noconsumibles_list_batch_req
DEBUG - 2024-04-11 17:55:52 --> #TRAZA | #REST | #CURL | #PAYLOAD >> {"_post_lote_noconsumibles_list_batch_req":{"_post_lote_noconsumibles_list":[{"lote_id":"LOTE24011502","arti_id":"5518","prov_id":"1000","batch_id_padre":"1996","cantidad":"1","cantidad_padre":"0","num_orden_prod":"","reci_id":"485","etap_id":"2000","usuario_app":"admin@kolormax.com","empr_id":"8","forzar_agregar":"false","fec_vencimiento":"01-01-3000","fec_iniciado":"11-04-2024","recu_id":"2532","tipo_recurso":"HUMANO","batch_id":"0","planificado":"false","noco_list":""}]}}
#HEADER SALIDA >> POST /services/PRDLoteDataService/_post_lote_noconsumibles_list_batch_req HTTP/1.1^M
Host: localhost:8283^M
Accept: */*^M
Content-Type: application/json^M
Content-Length: 479^M
^M

ERROR - 2024-04-11 17:55:52 --> #TRAZA | #REST | #CURL | #HEADER SALIDA BODY >> "{\"_post_lote_noconsumibles_list_batch_req\":{\"_post_lote_noconsumibles_list\":[{\"lote_id\":\"LOTE24011502\",\"arti_id\":\"5518\",\"prov_id\":\"1000\",\"batch_id_padre\":\"1996\",\"cantidad\":\"1\",\"cantidad_padre\":\"0\",\"num_orden_prod\":\"\",\"reci_id\":\"485\",\"etap_id\":\"2000\",\"usuario_app\":\"admin@kolormax.com\",\"empr_id\":\"8\",\"forzar_agregar\":\"false\",\"fec_vencimiento\":\"01-01-3000\",\"fec_iniciado\":\"11-04-2024\",\"recu_id\":\"2532\",\"tipo_recurso\":\"HUMANO\",\"batch_id\":\"0\",\"planificado\":\"false\",\"noco_list\":\"\"}]}}"
ERROR - 2024-04-11 17:55:52 --> #TRAZA | #REST | #CURL | #HEADER RESPUESTA >> HTTP/1.1 500 Internal Server Error^M
Content-Type: application/json; charset=UTF-8^M
Date: Thu, 11 Apr 2024 20:55:51 GMT^M
Transfer-Encoding: chunked^M
ERROR - 2024-04-11 17:55:52 --> #TRAZA | #REST | #CURL | #BODY >> "{\"Fault\":{\"faultcode\":\"axis2ns31428604:DATABASE_ERROR\",\"faultstring\":\"DS Fault Message: Error in DS non result invoke.\\nDS Code: DATABASE_ERROR\\nNested Exception:-\\njavax.xml.stream.XMLStreamException: DS Fault Message: Error in 'SQLQuery.processPreNormalQuery': Batch entry 0 select prd.crear_lote_noco(\\r 'LOTE24011502' \\r,cast('5518' as integer)\\r,cast('1000' as integer)\\r,cast('1996' as bigint)\\r,cast('1' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('485' as integer)\\r,cast('2000' as integer)\\r,'admin@kolormax.com'\\r,cast('8' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('2532' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('11-04-2024', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:RECI_NO_VACIO_IGUAL_ART_LOTE-reci_id=485-arti_id=5518-lote_id=LOTE24011502:3<<\\n  Where: PL\/pgSQL function prd.crear_lote_noco(character varying,integer,integer,bigint,double precision,double precision,character varying,integer,integer,character varying,integer,character varying,date,integer,character varying,character varying,bigint,character varying,date) line 530 at RAISE  Call getNextException to see other errors in the batch.\\nDS Code: DATABASE_ERROR\\nSource Data Service:-\\nName: PRDLoteDataService\\nLocation: \/PRDLoteDataService.dbs\\nDescription: N\/A\\nDefault Namespace: http:\/\/ws.wso2.org\/dataservice\\nCurrent Request Name: _post_lote_noconsumibles_list_batch_req\\nCurrent Params: {fec_vencimiento=01-01-3000, prov_id=1000, reci_id=485, empr_id=8, batch_id=0, planificado=false, usuario_app=admin@kolormax.com, arti_id=5518, tipo_recurso=HUMANO, etap_id=2000, batch_id_padre=1996, num_orden_prod=, fec_iniciado=11-04-2024, cantidad_padre=0, lote_id=LOTE24011502, noco_list=, cantidad=1, forzar_agregar=false, recu_id=2532}\\nNested Exception:-\\njava.sql.BatchUpdateException: Batch entry 0 select prd.crear_lote_noco(\\r 'LOTE24011502' \\r,cast('5518' as integer)\\r,cast('1000' as integer)\\r,cast('1996' as bigint)\\r,cast('1' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('485' as integer)\\r,cast('2000' as integer)\\r,'admin@kolormax.com'\\r,cast('8' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('2532' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('11-04-2024', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:RECI_NO_VACIO_IGUAL_ART_LOTE-reci_id=485-arti_id=5518-lote_id=LOTE24011502:3<<\\n  Where: PL\/pgSQL function prd.crear_lote_noco(character varying,integer,integer,bigint,double precision,double precision,character varying,integer,integer,character varying,integer,character varying,date,integer,character varying,character varying,bigint,character varying,date) line 530 at RAISE  Call getNextException to see other errors in the batch.\\n\\n\",\"detail\":\"\"}}"
DEBUG - 2024-04-11 17:55:52 --> #WSO2 #RESPONSE: TOOLSERROR:RECI_NO_VACIO_IGUAL_ART_LOTE-reci_id=485-arti_id=5518-lote_id=LOTE24011502:3

Pasos a reproducir:

  1. En Producción
  2. Clic en Producción de lotes | Operario
  3. Seleccionar el lote: "LOTE24011502"
  4. Completar el formulario
  5. Clic en el botón "Agregar"
  6. Clic en el botón "Guardar"
jfernandez-trazalog commented 4 months ago

Pablo Marrelli.

floto-trazalog commented 3 weeks ago

Solucionado en v2.3.9.2