15/06/2021 10:35:09  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_sno_c_nomina Personal MÉTODO->ConsultaDtPersonalFonatransbanca ERROR->Invalid query: ERROR:  operator does not exist: character = record
LINE 25:       AND s.codconc = ('0000006020','0000006021','0000006022...
                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
Whole query: 
		
					    SELECT p.nacper,p.cedper,hp.fecdesper,hp.fechasper,s.codconc,COALESCE(abs(round(s.valsal::numeric,2)),0) AS valsal,s.tipsal
						FROM sno_hsalida s
						INNER JOIN sno_hconcepto c ON s.codemp = c.codemp 
									  AND s.codnom = c.codnom 
									  AND s.anocur = c.anocur 
									  AND s.codperi = c.codperi
									  AND s.codconc = c.codconc
						INNER JOIN sno_hperiodo hp ON s.codemp = hp.codemp
									   AND s.codnom = hp.codnom
									   AND s.anocur = hp.anocur
									   AND s.codperi = hp.codperi
						INNER JOIN sno_hnomina n ON n.codemp = s.codemp 
									AND n.codnom = s.codnom 
									AND n.anocurnom = s.anocur 
									AND n.peractnom = s.codperi 
						INNER JOIN sno_hpersonalnomina pn ON pn.codemp=s.codemp		
										AND pn.codnom=s.codnom						 
										AND pn.codper=s.codper
										AND pn.anocur=s.anocur 
										AND pn.codperi=s.codperi 
						INNER JOIN sno_personal p ON p.codemp=pn.codemp AND p.codper=pn.codper 
						WHERE s.codemp='0001'
						AND s.codconc = ('0000006020','0000006021','0000006022','0000006023','0000008100')
						AND s.valsal<>0
						AND s.codnom='1000'
						AND s.anocur='2021'
						AND s.codperi='007'
						AND s.codper='0003142361'
						ORDER BY p.nacper,p.cedper,hp.fecdesper,hp.fechasper,s.codconc

		        

15/06/2021 20:55:06  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> insertar_clienteInvalid query: ERROR:  setval: value 0 is out of bounds for sequence "cxc_clientes_id_cliente_seq" (1..9223372036854775807)
Whole query:  SELECT setval('cxc_clientes_id_cliente_seq', max(id_cliente)) FROM cxc_clientes; INSERT INTO cxc_clientes(
											    codemp,
												codcliente,
												tipperrif,
												numpririf,
												numterrif,
												nitcli,
												id_tipo_cliente,
												nombre_cliente,
												cliente_abvr,
												id_zona,
												id_vend,
												id_clasif_cliente,
												dircliente,
												direntrega,
												codpai,
												codest,
												codmun,
												codpar,
												codciu,
												codpostal,
												faxcliente,
												telcliente,
												emailcliente,
												webcliente,
												observcliente,
												sc_cuenta,
												estclient,
												limitecred,
												diascred,
												descglob,												
												cedularesp,
												nombreresp,
												cargoresp,
												emailresp,
												cupocestas,
												retmensual,
												fondogar,
												alquilervehiculo,
												retfinmes,
												descarta,
												descartb,
												descartc,
												descartd,
												tipfongar,												
												porcahoaso,
												facnctercero,
												fecregcliente,
												retivaauto,
												retislrauto,
												retauto1,
												retauto2,
												retauto3,
												sucadscli,												
												id_ruta,
												tarcostcli,
												fecreg,
												usureg,
												horareg
										) 
										 VALUES ('0001','295','J','30416760','1','','14','MAYOR DE CONFITERIA Y VIVERES LA PLAZA DE ANTIMANO C.A.','','2','1','01','CALLE LATERAL OESTE FTE. A LA PLAZA DE ANTIMANO, CARACAS','','---','---','---','---','---','','','02124728435 04129331129','','','','102020100','A','0.00','0.00','0.00','','SR JUAN','','','0.00','0.00','0.00','0.00','0.00','0','0','0','0','0','0.00','0','2021-06-15','0.00','0.00','0.00','0.00','0.00','','0','','2021-06-15','ADMINISTRADOR','20:55'); ; SELECT lastval() AS valor_id; 

15/06/2021 20:55:56  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> Error en valida datos comprobante