Descripción:
Al completar los campos obligatorios y agregar el reporte, luego dar clic en el botón "Guardar" el sistema no permite guardar dicho registro
Se agregan recopilaciones que se recupera al Inspeccionar:
"{\"Fault\":{\"faultcode\":\"axis2ns141285: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 'LOTE-ENV-1512' \\r,cast('8636' as integer)\\r,cast('1000' as integer)\\r,cast('2012' as bigint)\\r,cast('12' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('873' as integer)\\r,cast('2000' as integer)\\r,'jperezempresaprueba'\\r,cast('9000' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('1304' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('15-12-2023', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:cannot delete from table \\\"recursos_lotes\\\" because it does not have a replica identity and publishes deletes:13<<\\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=873, empr_id=9000, batch_id=0, planificado=false, usuario_app=jperezempresaprueba, arti_id=8636, tipo_recurso=HUMANO, etap_id=2000, batch_id_padre=2012, num_orden_prod=, fec_iniciado=15-12-2023, cantidad_padre=0, lote_id=LOTE-ENV-1512, noco_list=, cantidad=12, forzar_agregar=false, recu_id=1304}\\nNested Exception:-\\njava.sql.BatchUpdateException: Batch entry 0 select prd.crear_lote_noco(\\r 'LOTE-ENV-1512' \\r,cast('8636' as integer)\\r,cast('1000' as integer)\\r,cast('2012' as bigint)\\r,cast('12' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('873' as integer)\\r,cast('2000' as integer)\\r,'jperezempresaprueba'\\r,cast('9000' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('1304' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('15-12-2023', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:cannot delete from table \\\"recursos_lotes\\\" because it does not have a replica identity and publishes deletes:13<<\\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\":\"\"}}"
"HTTP/1.1 500 Internal Server Error\r\nContent-Type: application/json; charset=UTF-8\r\nDate: Fri, 15 Dec 2023 20:56:49 GMT\r\nTransfer-Encoding: chunked\r\n\r\n"
{"status":false,"header":"HTTP\/1.1 500 Internal Server Error\r\nContent-Type: application\/json; charset=UTF-8\r\nDate: Fri, 15 Dec 2023 20:56:49 GMT\r\nTransfer-Encoding: chunked\r\n\r\n","data":"{\"Fault\":{\"faultcode\":\"axis2ns141285: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 'LOTE-ENV-1512' \\r,cast('8636' as integer)\\r,cast('1000' as integer)\\r,cast('2012' as bigint)\\r,cast('12' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('873' as integer)\\r,cast('2000' as integer)\\r,'jperezempresaprueba'\\r,cast('9000' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('1304' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('15-12-2023', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:cannot delete from table \\\"recursos_lotes\\\" because it does not have a replica identity and publishes deletes:13<<\\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=873, empr_id=9000, batch_id=0, planificado=false, usuario_app=jperezempresaprueba, arti_id=8636, tipo_recurso=HUMANO, etap_id=2000, batch_id_padre=2012, num_orden_prod=, fec_iniciado=15-12-2023, cantidad_padre=0, lote_id=LOTE-ENV-1512, noco_list=, cantidad=12, forzar_agregar=false, recu_id=1304}\\nNested Exception:-\\njava.sql.BatchUpdateException: Batch entry 0 select prd.crear_lote_noco(\\r 'LOTE-ENV-1512' \\r,cast('8636' as integer)\\r,cast('1000' as integer)\\r,cast('2012' as bigint)\\r,cast('12' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('873' as integer)\\r,cast('2000' as integer)\\r,'jperezempresaprueba'\\r,cast('9000' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('1304' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('15-12-2023', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:cannot delete from table \\\"recursos_lotes\\\" because it does not have a replica identity and publishes deletes:13<<\\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\":\"\"}}","code":500,"error":"TOOLSERROR:cannot delete from table \"recursos_lotes\" because it does not have a replica identity and publishes deletes:13","reci_id":null,"msj":null}
Ambiente Test - v2.2.17
Descripción: Al completar los campos obligatorios y agregar el reporte, luego dar clic en el botón "Guardar" el sistema no permite guardar dicho registro
https://github.com/Trazalog/traz-prod-trazasoft/assets/88331456/4cd9b62a-881e-49de-b2a0-9c158f499d20
Se agregan recopilaciones que se recupera al Inspeccionar:
"{\"Fault\":{\"faultcode\":\"axis2ns141285: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 'LOTE-ENV-1512' \\r,cast('8636' as integer)\\r,cast('1000' as integer)\\r,cast('2012' as bigint)\\r,cast('12' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('873' as integer)\\r,cast('2000' as integer)\\r,'jperezempresaprueba'\\r,cast('9000' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('1304' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('15-12-2023', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:cannot delete from table \\\"recursos_lotes\\\" because it does not have a replica identity and publishes deletes:13<<\\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=873, empr_id=9000, batch_id=0, planificado=false, usuario_app=jperezempresaprueba, arti_id=8636, tipo_recurso=HUMANO, etap_id=2000, batch_id_padre=2012, num_orden_prod=, fec_iniciado=15-12-2023, cantidad_padre=0, lote_id=LOTE-ENV-1512, noco_list=, cantidad=12, forzar_agregar=false, recu_id=1304}\\nNested Exception:-\\njava.sql.BatchUpdateException: Batch entry 0 select prd.crear_lote_noco(\\r 'LOTE-ENV-1512' \\r,cast('8636' as integer)\\r,cast('1000' as integer)\\r,cast('2012' as bigint)\\r,cast('12' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('873' as integer)\\r,cast('2000' as integer)\\r,'jperezempresaprueba'\\r,cast('9000' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('1304' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('15-12-2023', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:cannot delete from table \\\"recursos_lotes\\\" because it does not have a replica identity and publishes deletes:13<<\\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\":\"\"}}"
"HTTP/1.1 500 Internal Server Error\r\nContent-Type: application/json; charset=UTF-8\r\nDate: Fri, 15 Dec 2023 20:56:49 GMT\r\nTransfer-Encoding: chunked\r\n\r\n"
{"status":false,"header":"HTTP\/1.1 500 Internal Server Error\r\nContent-Type: application\/json; charset=UTF-8\r\nDate: Fri, 15 Dec 2023 20:56:49 GMT\r\nTransfer-Encoding: chunked\r\n\r\n","data":"{\"Fault\":{\"faultcode\":\"axis2ns141285: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 'LOTE-ENV-1512' \\r,cast('8636' as integer)\\r,cast('1000' as integer)\\r,cast('2012' as bigint)\\r,cast('12' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('873' as integer)\\r,cast('2000' as integer)\\r,'jperezempresaprueba'\\r,cast('9000' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('1304' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('15-12-2023', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:cannot delete from table \\\"recursos_lotes\\\" because it does not have a replica identity and publishes deletes:13<<\\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=873, empr_id=9000, batch_id=0, planificado=false, usuario_app=jperezempresaprueba, arti_id=8636, tipo_recurso=HUMANO, etap_id=2000, batch_id_padre=2012, num_orden_prod=, fec_iniciado=15-12-2023, cantidad_padre=0, lote_id=LOTE-ENV-1512, noco_list=, cantidad=12, forzar_agregar=false, recu_id=1304}\\nNested Exception:-\\njava.sql.BatchUpdateException: Batch entry 0 select prd.crear_lote_noco(\\r 'LOTE-ENV-1512' \\r,cast('8636' as integer)\\r,cast('1000' as integer)\\r,cast('2012' as bigint)\\r,cast('12' as float8)\\r,cast('0' as float8)\\r,''\\r,cast('873' as integer)\\r,cast('2000' as integer)\\r,'jperezempresaprueba'\\r,cast('9000' as integer)\\r,'false'\\r,to_date('01-01-3000','DD-MM-YYYY')\\r,cast ('1304' as int4)\\r,'HUMANO'\\r,'false'\\r,cast('0' as bigint)\\r,''\\r,to_date('15-12-2023', 'DD-MM-YYYY'))\\rresultado was aborted: ERROR: >>TOOLSERROR:cannot delete from table \\\"recursos_lotes\\\" because it does not have a replica identity and publishes deletes:13<<\\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\":\"\"}}","code":500,"error":"TOOLSERROR:cannot delete from table \"recursos_lotes\" because it does not have a replica identity and publishes deletes:13","reci_id":null,"msj":null}