Descripción:
Al dar clic en el botón Finalizar se muestra el siguiente error
"Error: no se pudo registrar carga"
Y en consola se muestra este msj:
{"status":false,"header":"HTTP\/1.1 500 Internal Server Error\r\nContent-Type: application\/json; charset=UTF-8\r\nDate: Fri, 25 Oct 2024 21:24:41 GMT\r\nTransfer-Encoding: chunked\r\n\r\n","data":"{\"Fault\":{\"faultcode\":\"axis2ns720: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.cambiar_recipiente(\\rcast('2067' as int8)\\r,cast('922' as int4)\\r,cast('2000' as int4)\\r,cast('9000' as int4)\\r,cast('jperezempresaprueba' as varchar)\\r,cast('false' as varchar)\\r,cast('200' as float8)) resultado was aborted: ERROR: >>TOOLSERROR:CANT_MAYOR_EXISTENCIA:200:125<<\\n Where: PL\/pgSQL function prd.cambiar_recipiente(bigint,integer,integer,integer,character varying,character varying,double precision) line 112 at RAISE Call getNextException to see other errors in the batch.\\nDS Code: DATABASE_ERROR\\nSource Data Service:-\\nName: PRDDataService\\nLocation: \/PRDDataService.dbs\\nDescription: N\/A\\nDefault Namespace: http:\/\/ws.wso2.org\/dataservice\\nCurrent Request Name: _post_lote_recipiente_cambiar_batch_req\\nCurrent Params: {batch_id_origen=2067, reci_id=922, usuario_app=jperezempresaprueba, cantidad=200, etap_id_deposito=2000, forzar_agregar=false, empre_id=9000}\\nNested Exception:-\\njava.sql.BatchUpdateException: Batch entry 0 select prd.cambiar_recipiente(\\rcast('2067' as int8)\\r,cast('922' as int4)\\r,cast('2000' as int4)\\r,cast('9000' as int4)\\r,cast('jperezempresaprueba' as varchar)\\r,cast('false' as varchar)\\r,cast('200' as float8)) resultado was aborted: ERROR: >>TOOLSERROR:CANT_MAYOR_EXISTENCIA:200:125<<\\n Where: PL\/pgSQL function prd.cambiar_recipiente(bigint,integer,integer,integer,character varying,character varying,double precision) line 112 at RAISE Call getNextException to see other errors in the batch.\\n\\n\",\"detail\":\"\"}}","code":500}
Ambiente Test - v2.4.1
Descripción: Al dar clic en el botón Finalizar se muestra el siguiente error "Error: no se pudo registrar carga"
Y en consola se muestra este msj:
{"status":false,"header":"HTTP\/1.1 500 Internal Server Error\r\nContent-Type: application\/json; charset=UTF-8\r\nDate: Fri, 25 Oct 2024 21:24:41 GMT\r\nTransfer-Encoding: chunked\r\n\r\n","data":"{\"Fault\":{\"faultcode\":\"axis2ns720: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.cambiar_recipiente(\\rcast('2067' as int8)\\r,cast('922' as int4)\\r,cast('2000' as int4)\\r,cast('9000' as int4)\\r,cast('jperezempresaprueba' as varchar)\\r,cast('false' as varchar)\\r,cast('200' as float8)) resultado was aborted: ERROR: >>TOOLSERROR:CANT_MAYOR_EXISTENCIA:200:125<<\\n Where: PL\/pgSQL function prd.cambiar_recipiente(bigint,integer,integer,integer,character varying,character varying,double precision) line 112 at RAISE Call getNextException to see other errors in the batch.\\nDS Code: DATABASE_ERROR\\nSource Data Service:-\\nName: PRDDataService\\nLocation: \/PRDDataService.dbs\\nDescription: N\/A\\nDefault Namespace: http:\/\/ws.wso2.org\/dataservice\\nCurrent Request Name: _post_lote_recipiente_cambiar_batch_req\\nCurrent Params: {batch_id_origen=2067, reci_id=922, usuario_app=jperezempresaprueba, cantidad=200, etap_id_deposito=2000, forzar_agregar=false, empre_id=9000}\\nNested Exception:-\\njava.sql.BatchUpdateException: Batch entry 0 select prd.cambiar_recipiente(\\rcast('2067' as int8)\\r,cast('922' as int4)\\r,cast('2000' as int4)\\r,cast('9000' as int4)\\r,cast('jperezempresaprueba' as varchar)\\r,cast('false' as varchar)\\r,cast('200' as float8)) resultado was aborted: ERROR: >>TOOLSERROR:CANT_MAYOR_EXISTENCIA:200:125<<\\n Where: PL\/pgSQL function prd.cambiar_recipiente(bigint,integer,integer,integer,character varying,character varying,double precision) line 112 at RAISE Call getNextException to see other errors in the batch.\\n\\n\",\"detail\":\"\"}}","code":500}
Pasos a reproducir: