28/02/2021 21:41:03  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  invalid input syntax for type date: ""
LINE 32:           AND m.fectranage>=''  AND m.fectranage<='28/02/202...
                                     ^
Whole query:  
						    SELECT  s.codmon,
							        s.codemisor,
									(CASE WHEN MAX(ref_kiu)!='' THEN s.codemisor||' - '||MAX(ref_kiu)||' - '||MAX(denemisor)
										  ELSE s.codemisor||' - '||MAX(denemisor)
									END) AS infoemisor,
									
											(
		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.codemisor=s.codemisor	
												   AND ma.codmon=s.codmon	
												   AND ma.fectranage<'01/04/2020'					  
												GROUP BY ma.codmon,ma.codemisor
												ORDER BY ma.codmon,ma.codemisor
											 ) AS saldo_anterior,
									  
									     
									sum(s.creditos) as creditos,
									sum(s.debitos) as debitos,
									sum(s.saldo) as saldo        
							FROM
							(
								SELECT codmon,
								       codemisor,
									   0 AS debitos,
									   0 AS creditos,
									   sum(montransage) as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								  AND m.fectranage>=''  AND m.fectranage<='28/02/2021' 
								GROUP BY codmon,codemisor 
								UNION
								SELECT codmon, 
								       codemisor,
									   sum(montransage) AS debitos,
									   0 AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('DEB','REVCRE','REVAND')
								    AND m.fectranage>=''  AND m.fectranage<='28/02/2021' 
								GROUP BY codmon,codemisor  
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS debitos,
									   sum(montransage) AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('CRE','REVDEB','REVANC')
								  AND m.fectranage>=''  AND m.fectranage<='28/02/2021' 
								GROUP BY codmon,codemisor  
							) AS s
							INNER JOIN aero_emisores e ON e.codemisor=s.codemisor
							GROUP BY s.codmon,s.codemisor
							ORDER BY s.codmon,s.codemisor						 
					  

28/02/2021 21:41:04  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  invalid input syntax for type date: ""
LINE 32:           AND m.fectranage>=''  AND m.fectranage<='28/02/202...
                                     ^
Whole query:  
						    SELECT  s.codmon,
							        s.codemisor,
									(CASE WHEN MAX(ref_kiu)!='' THEN s.codemisor||' - '||MAX(ref_kiu)||' - '||MAX(denemisor)
										  ELSE s.codemisor||' - '||MAX(denemisor)
									END) AS infoemisor,
									
											(
		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.codemisor=s.codemisor	
												   AND ma.codmon=s.codmon	
												   AND ma.fectranage<'01/04/2020'					  
												GROUP BY ma.codmon,ma.codemisor
												ORDER BY ma.codmon,ma.codemisor
											 ) AS saldo_anterior,
									  
									     
									sum(s.creditos) as creditos,
									sum(s.debitos) as debitos,
									sum(s.saldo) as saldo        
							FROM
							(
								SELECT codmon,
								       codemisor,
									   0 AS debitos,
									   0 AS creditos,
									   sum(montransage) as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								  AND m.fectranage>=''  AND m.fectranage<='28/02/2021' 
								GROUP BY codmon,codemisor 
								UNION
								SELECT codmon, 
								       codemisor,
									   sum(montransage) AS debitos,
									   0 AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('DEB','REVCRE','REVAND')
								    AND m.fectranage>=''  AND m.fectranage<='28/02/2021' 
								GROUP BY codmon,codemisor  
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS debitos,
									   sum(montransage) AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('CRE','REVDEB','REVANC')
								  AND m.fectranage>=''  AND m.fectranage<='28/02/2021' 
								GROUP BY codmon,codemisor  
							) AS s
							INNER JOIN aero_emisores e ON e.codemisor=s.codemisor
							GROUP BY s.codmon,s.codemisor
							ORDER BY s.codmon,s.codemisor						 
					  

28/02/2021 21:42:09  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  invalid input syntax for type date: "--"
LINE 32:           AND m.fectranage>='--'  AND m.fectranage<='2021-02...
                                     ^
Whole query:  
						    SELECT  s.codmon,
							        s.codemisor,
									(CASE WHEN MAX(ref_kiu)!='' THEN s.codemisor||' - '||MAX(ref_kiu)||' - '||MAX(denemisor)
										  ELSE s.codemisor||' - '||MAX(denemisor)
									END) AS infoemisor,
									
											(
		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.codemisor=s.codemisor	
												   AND ma.codmon=s.codmon	
												   AND ma.fectranage<'2020-04-01'					  
												GROUP BY ma.codmon,ma.codemisor
												ORDER BY ma.codmon,ma.codemisor
											 ) AS saldo_anterior,
									  
									     
									sum(s.creditos) as creditos,
									sum(s.debitos) as debitos,
									sum(s.saldo) as saldo        
							FROM
							(
								SELECT codmon,
								       codemisor,
									   0 AS debitos,
									   0 AS creditos,
									   sum(montransage) as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								  AND m.fectranage>='--'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 
								UNION
								SELECT codmon, 
								       codemisor,
									   sum(montransage) AS debitos,
									   0 AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('DEB','REVCRE','REVAND')
								    AND m.fectranage>='--'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor  
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS debitos,
									   sum(montransage) AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('CRE','REVDEB','REVANC')
								  AND m.fectranage>='--'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor  
							) AS s
							INNER JOIN aero_emisores e ON e.codemisor=s.codemisor
							GROUP BY s.codmon,s.codemisor
							ORDER BY s.codmon,s.codemisor						 
					  

28/02/2021 22:28:40  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  syntax error at or near "("
LINE 16:            (
                    ^
Whole query:  
						    SELECT  s.codmon,
							        s.codemisor,
									(CASE WHEN MAX(ref_kiu)!='' THEN s.codemisor||' - '||MAX(ref_kiu)||' - '||MAX(denemisor)
										  ELSE s.codemisor||' - '||MAX(denemisor)
									END) AS infoemisor,
									sum(s.saldo_anterior) as saldo_anterior,
									sum(s.creditos) as creditos,
									sum(s.debitos) as debitos,
									sum(s.saldo) as saldo        
							FROM
							(
								SELECT codmon,
								       codemisor,
									    0 AS saldo_anterior 
											(
		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.codemisor=m.codemisor	
												   AND ma.codmon=m.codmon	
												   AND ma.fectranage<'2020-04-01'					  
												GROUP BY ma.codmon,ma.codemisor
												ORDER BY ma.codmon,ma.codemisor
											 ) AS saldo_anterior,
									  
									     
									   0 AS debitos,
									   0 AS creditos,
									   sum(montransage) as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								  AND m.fectranage>='2020-04-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   sum(montransage) AS debitos,
									   0 AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('DEB','REVCRE','REVAND')
								    AND m.fectranage>='2020-04-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor  
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   0 AS debitos,
									   sum(montransage) AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('CRE','REVDEB','REVANC')
								  AND m.fectranage>='2020-04-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 								
							) AS s
							LEFT JOIN aero_emisores e ON e.codemisor=s.codemisor
							GROUP BY s.codmon,s.codemisor
							ORDER BY s.codmon,s.codemisor		
							
					  

28/02/2021 22:29:23  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  each UNION query must have the same number of columns
LINE 36:         SELECT codmon, 
                        ^
Whole query:  
						    SELECT  s.codmon,
							        s.codemisor,
									(CASE WHEN MAX(ref_kiu)!='' THEN s.codemisor||' - '||MAX(ref_kiu)||' - '||MAX(denemisor)
										  ELSE s.codemisor||' - '||MAX(denemisor)
									END) AS infoemisor,
									sum(s.saldo_anterior) as saldo_anterior,
									sum(s.creditos) as creditos,
									sum(s.debitos) as debitos,
									sum(s.saldo) as saldo        
							FROM
							(
								SELECT codmon,
								       codemisor,
									    0 AS saldo_anterior, 
											(
		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.codemisor=m.codemisor	
												   AND ma.codmon=m.codmon	
												   AND ma.fectranage<'2020-04-01'					  
												GROUP BY ma.codmon,ma.codemisor
												ORDER BY ma.codmon,ma.codemisor
											 ) AS saldo_anterior,
									  
									     
									   0 AS debitos,
									   0 AS creditos,
									   sum(montransage) as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								  AND m.fectranage>='2020-04-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   sum(montransage) AS debitos,
									   0 AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('DEB','REVCRE','REVAND')
								    AND m.fectranage>='2020-04-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor  
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   0 AS debitos,
									   sum(montransage) AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('CRE','REVDEB','REVANC')
								  AND m.fectranage>='2020-04-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 								
							) AS s
							LEFT JOIN aero_emisores e ON e.codemisor=s.codemisor
							GROUP BY s.codmon,s.codemisor
							ORDER BY s.codmon,s.codemisor		
							
					  

28/02/2021 23:51:39  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  column reference "codemisor" is ambiguous
LINE 61:        WHERE codemisor IN (SELECT DISTINCT codemisor FROM ae...
                      ^
Whole query:  
						    SELECT  s.codmon,
							        s.codemisor,
									(CASE WHEN MAX(ref_kiu)!='' THEN s.codemisor||' - '||MAX(ref_kiu)||' - '||MAX(denemisor)
										  ELSE s.codemisor||' - '||MAX(denemisor)
									END) AS infoemisor,
									sum(s.saldo_anterior) as saldo_anterior,
									sum(s.creditos) as creditos,
									sum(s.debitos) as debitos,
									(sum(s.saldo)+sum(s.saldo_anterior)) as saldo        
							FROM aero_emisores e
							LEFT JOIN 
							(
								SELECT codmon,
								       codemisor,
									   
											(
		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.codemisor=m.codemisor	
												   AND ma.codmon=m.codmon	
												   AND ma.fectranage<'2020-09-01'					  
												GROUP BY ma.codmon,ma.codemisor
												ORDER BY ma.codmon,ma.codemisor
											 ) AS saldo_anterior,
									  
									     
									   0 AS debitos,
									   0 AS creditos,
									   sum(montransage) as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								  AND m.fectranage>='2020-09-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   sum(montransage) AS debitos,
									   0 AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('DEB','REVCRE','REVAND')
								    AND m.fectranage>='2020-09-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor  
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   0 AS debitos,
									   sum(montransage) AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('CRE','REVDEB','REVANC')
								  AND m.fectranage>='2020-09-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 								
							) AS s ON e.codemisor=s.codemisor
							WHERE codemisor IN (SELECT DISTINCT codemisor FROM aero_ctlage_dt_transacciones)
							GROUP BY s.codmon,s.codemisor
							ORDER BY s.codmon,s.codemisor		
							
					  

28/02/2021 23:54:25  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  column e.codmon does not exist
LINE 2:           SELECT  e.codmon,
                          ^
HINT:  Perhaps you meant to reference the column "s.codmon".
Whole query:  
						    SELECT  e.codmon,
							        e.codemisor,
									(CASE WHEN MAX(e.ref_kiu)!='' THEN e.codemisor||' - '||MAX(e.ref_kiu)||' - '||MAX(e.denemisor)
										  ELSE e.codemisor||' - '||MAX(denemisor)
									END) AS infoemisor,
									COALESCE(sum(s.saldo_anterior),0) as saldo_anterior,
									COALESCE(sum(s.creditos),0) as creditos,
									COALESCE(sum(s.debitos),0) as debitos,
									COALESCE((sum(s.saldo)+sum(s.saldo_anterior)),0) as saldo        
							FROM aero_emisores e
							LEFT JOIN 
							(
								SELECT codmon,
								       codemisor,
									   
											(
		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.codemisor=m.codemisor	
												   AND ma.codmon=m.codmon	
												   AND ma.fectranage<'2020-09-01'					  
												GROUP BY ma.codmon,ma.codemisor
												ORDER BY ma.codmon,ma.codemisor
											 ) AS saldo_anterior,
									  
									     
									   0 AS debitos,
									   0 AS creditos,
									   sum(montransage) as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								  AND m.fectranage>='2020-09-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   sum(montransage) AS debitos,
									   0 AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('DEB','REVCRE','REVAND')
								    AND m.fectranage>='2020-09-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor  
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   0 AS debitos,
									   sum(montransage) AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('CRE','REVDEB','REVANC')
								  AND m.fectranage>='2020-09-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 								
							) AS s ON e.codemisor=s.codemisor
							WHERE s.codemisor IN (SELECT DISTINCT codemisor FROM aero_ctlage_dt_transacciones)
							GROUP BY s.codmon,s.codemisor
							ORDER BY s.codmon,s.codemisor		
							
					  

28/02/2021 23:54:26  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  column e.codmon does not exist
LINE 2:           SELECT  e.codmon,
                          ^
HINT:  Perhaps you meant to reference the column "s.codmon".
Whole query:  
						    SELECT  e.codmon,
							        e.codemisor,
									(CASE WHEN MAX(e.ref_kiu)!='' THEN e.codemisor||' - '||MAX(e.ref_kiu)||' - '||MAX(e.denemisor)
										  ELSE e.codemisor||' - '||MAX(denemisor)
									END) AS infoemisor,
									COALESCE(sum(s.saldo_anterior),0) as saldo_anterior,
									COALESCE(sum(s.creditos),0) as creditos,
									COALESCE(sum(s.debitos),0) as debitos,
									COALESCE((sum(s.saldo)+sum(s.saldo_anterior)),0) as saldo        
							FROM aero_emisores e
							LEFT JOIN 
							(
								SELECT codmon,
								       codemisor,
									   
											(
		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.codemisor=m.codemisor	
												   AND ma.codmon=m.codmon	
												   AND ma.fectranage<'2020-09-01'					  
												GROUP BY ma.codmon,ma.codemisor
												ORDER BY ma.codmon,ma.codemisor
											 ) AS saldo_anterior,
									  
									     
									   0 AS debitos,
									   0 AS creditos,
									   sum(montransage) as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								  AND m.fectranage>='2020-09-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   sum(montransage) AS debitos,
									   0 AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('DEB','REVCRE','REVAND')
								    AND m.fectranage>='2020-09-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor  
								UNION
								SELECT codmon, 
								       codemisor,
									   0 AS saldo_anterior,
									   0 AS debitos,
									   sum(montransage) AS creditos,
									   0 as saldo 
								  FROM aero_ctlage_dt_transacciones m							
								 WHERE m.codemp='0001'
								   AND m.codtipdocage IN ('CRE','REVDEB','REVANC')
								  AND m.fectranage>='2020-09-01'  AND m.fectranage<='2021-02-28' 
								GROUP BY codmon,codemisor 								
							) AS s ON e.codemisor=s.codemisor
							WHERE s.codemisor IN (SELECT DISTINCT codemisor FROM aero_ctlage_dt_transacciones)
							GROUP BY s.codmon,s.codemisor
							ORDER BY s.codmon,s.codemisor