16/07/2020 01:23:28  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  la sintaxis de entrada no es válida para integer: «»
LINE 36:                        AND dc.nrodoccont = ''
                                                    ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-00000000005') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   0 AS cargo, 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON spg.codemp = '0001'  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON ep1.codemp='0001' 
											      AND ep1.codestpro1=dp.codestpro1 
											      AND ep1.estcla=dp.estcla
							LEFT JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = ''
							LEFT JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							UNION
							SELECT ac.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-00000000005') AS comprobante,
								   MAX(spga.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																           AND spga.estcla = dp.estcla																   
																           AND spga.codestpro1 = dp.codestpro1
																           AND spga.codestpro2 = dp.codestpro2
																           AND spga.codestpro3 = dp.codestpro3
																           AND spga.codestpro4 = dp.codestpro4
																           AND spga.codestpro5 = dp.codestpro5
												LEFT JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = ''
												LEFT JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
												  AND dp.moncarpar<>0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo,						   
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
											 WHEN sigafecpar='DI' THEN -dp.moncarpar
											 ELSE dp.moncarpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
							INNER JOIN spg_cuentas spga ON spga.codemp = '0001'
							                           AND spga.spg_cuenta = ac.spg_cuenta   
													   AND spga.estcla = dp.estcla																   
													   AND spga.codestpro1 = dp.codestpro1
													   AND spga.codestpro2 = dp.codestpro2
													   AND spga.codestpro3 = dp.codestpro3
													   AND spga.codestpro4 = dp.codestpro4
													   AND spga.codestpro5 = dp.codestpro5
							INNER JOIN spg_ep1 ep1 ON ep1.codemp='0001' 
											      AND ep1.codestpro1=dp.codestpro1 
											      AND ep1.estcla=dp.estcla
							LEFT JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = ''
							LEFT JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.moncarpar<>0
							GROUP BY ac.spg_cuenta,
								     dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							ORDER BY 1,2,3,4,5,6,7
				  

16/07/2020 01:25:16  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  el operador no existe: integer = character varying
LINE 36:                       AND dc.nrodoccont = dp.codcont
                                                 ^
HINT:  Ningún operador coincide con el nombre y el tipo de los argumentos. Puede ser necesario agregar conversiones explícitas de tipos.
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-00000000005') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   0 AS cargo, 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON spg.codemp = '0001'  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON ep1.codemp='0001' 
											      AND ep1.codestpro1=dp.codestpro1 
											      AND ep1.estcla=dp.estcla
							LEFT JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												          AND dc.nrodoccont = dp.codcont
							LEFT JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							UNION
							SELECT ac.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-00000000005') AS comprobante,
								   MAX(spga.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																           AND spga.estcla = dp.estcla																   
																           AND spga.codestpro1 = dp.codestpro1
																           AND spga.codestpro2 = dp.codestpro2
																           AND spga.codestpro3 = dp.codestpro3
																           AND spga.codestpro4 = dp.codestpro4
																           AND spga.codestpro5 = dp.codestpro5
												LEFT JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	          AND dc.nrodoccont = dp.codcont
												LEFT JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
												  AND dp.moncarpar<>0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo,						   
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
											 WHEN sigafecpar='DI' THEN -dp.moncarpar
											 ELSE dp.moncarpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
							INNER JOIN spg_cuentas spga ON spga.codemp = '0001'
							                           AND spga.spg_cuenta = ac.spg_cuenta   
													   AND spga.estcla = dp.estcla																   
													   AND spga.codestpro1 = dp.codestpro1
													   AND spga.codestpro2 = dp.codestpro2
													   AND spga.codestpro3 = dp.codestpro3
													   AND spga.codestpro4 = dp.codestpro4
													   AND spga.codestpro5 = dp.codestpro5
							INNER JOIN spg_ep1 ep1 ON ep1.codemp='0001' 
											      AND ep1.codestpro1=dp.codestpro1 
											      AND ep1.estcla=dp.estcla
							LEFT JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												          AND dc.nrodoccont = dp.codcont
							LEFT JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.moncarpar<>0
							GROUP BY ac.spg_cuenta,
								     dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							ORDER BY 1,2,3,4,5,6,7
				  

16/07/2020 19:38:56  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_sco_c_contratosobras <br><b>METODO:</b> TotalesPartidasDoc <br><b>ERROR->:</b><br>Invalid query: ERROR:  la sintaxis de entrada no es válida para integer: «»
LINE 36:        AND dp.nrodoccont =''
                                   ^
Whole query:   
						SELECT sum(subtotpar) as subtotpar,
							   sum(moncarpar) as moncarpar,
							   sum(montotpar) as montotpar
						FROM(
							SELECT  3 AS ordenvisualiza,
								'EJECUCION_PARTIDA' AS tiporenglon,
								tipafecpar,
								dc.tipdoccont,
								dentipdoccont,
								dp.nrodoccont,	
								CASE WHEN dp.nrodoccont=0 THEN 'AU' ELSE sigafecpar END AS sigafecpar,								
								CASE WHEN sigafecpar='AU' THEN dp.preunipar 
									 WHEN sigafecpar='DI' THEN -dp.preunipar
									 ELSE dp.preunipar END AS preunipar,	
								CASE WHEN sigafecpar='AU' THEN dp.canpartida 
									 WHEN sigafecpar='DI' THEN -dp.canpartida
									 ELSE dp.canpartida END AS canpartida,
								CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
									 WHEN sigafecpar='DI' THEN -dp.subtotpar
									 ELSE dp.subtotpar END AS subtotpar,
								CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
									 WHEN sigafecpar='DI' THEN -dp.moncarpar
									 ELSE dp.moncarpar END AS moncarpar,
								CASE WHEN sigafecpar='AU' THEN dp.montotpar 
									 WHEN sigafecpar='DI' THEN -dp.montotpar
									 ELSE dp.montotpar END AS montotpar
							FROM sco_dt_partidas_contrato dp					 
							LEFT JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
											   AND dc.nrodoccont = dp.nrodoccont
							LEFT JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							WHERE dp.codcont ='5'
							AND dp.nrodoccont =''
							ORDER BY 1,6
						) pdoc
					;