25/02/2016 08:35:33  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  no existe la restricción «fk_sep_dt_c_sep_conce_sep_conc» en la relación «sep_dt_concepto»
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 08:37:24  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  no existe la restricción «fk_sep_dt_c_sep_conce_sep_conc» en la relación «sep_dt_concepto»
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 08:44:15  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la columna «numrecdoc» en la relación «sob_valuacion»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 08:58:02  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la columna «numrecdoc» en la relación «sob_valuacion»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 08:58:44  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la relación «cxp_dc_spi»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 09:00:02  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la columna «numdoccom» en la relación «cxp_dc_spg»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 09:01:59  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la columna «numdoccom» en la relación «cxp_dc_spg»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 09:02:36  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la columna «numdoccom» en la relación «cxp_dc_spg»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 10:15:10  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  no existe la restricción «fk_sep_conc_sep_conce_sep_conc» en la relación «sep_conceptocargos»
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 10:16:43  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  no existe la restricción «fk_sep_dtc__sep_dtcon_sep_dt_c» en la relación «sep_dtc_cargos»
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 10:26:36  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  no existe la restricción «fk_sep_dt_c_sep_conce_sep_conc» en la relación «sep_dt_concepto»
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 10:28:29  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  no existe la restricción «fk_sep_dt_c_sep_conce_sep_conc» en la relación «sep_dt_concepto»
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 10:29:49  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  update o delete en «sep_conceptos» viola la llave foránea «fk_sep_conceptocargos__sep_conceptos» en la tabla «sep_conceptocargos»
DETAIL:  La llave (codconsep)=(006) todavía es referida desde la tabla «sep_conceptocargos».
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 10:30:32  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  update o delete en «sep_conceptos» viola la llave foránea «fk_sep_conceptocargos__sep_conceptos» en la tabla «sep_conceptocargos»
DETAIL:  La llave (codconsep)=(006) todavía es referida desde la tabla «sep_conceptocargos».
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 10:30:58  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->SNO MÉTODO->uf_crear_sessionnomina ERROR->Invalid query: ERROR:  no existe la columna sno_nomina.nomespfid
LINE 2: ...etnom,   sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina...
                                                             ^
Whole query: SELECT sno_nomina.codnom, sno_nomina.desnom, sno_nomina.peractnom, sno_nomina.diabonvacnom, sno_nomina.diareivacnom, 		sno_nomina.adenom, sno_periodo.fecdesper, sno_periodo.fechasper, sno_periodo.cerper, sno_periodo.conper,		sno_periodo.totper, sno_nomina.anocurnom, sno_nomina.tippernom, sno_nomina.perresnom, sno_nomina.racnom, 		sno_nomina.subnom, sno_nomina.espnom, sno_nomina.consulnom, sno_nomina.descomnom, sno_nomina.codpronom, 		sno_nomina.codbennom, sno_nomina.conaponom, sno_nomina.cueconnom, sno_nomina.notdebnom,        sno_nomina.numvounom, sno_nomina.recdocnom, sno_nomina.recdocapo, sno_nomina.tipdocnom, sno_nomina.tipdocapo, 		sno_nomina.tipnom, sno_nomina.fecininom, sno_nomina.numpernom, sno_nomina.conpernom, sno_nomina.conpronom, 		sno_nomina.titrepnom, sno_nomina.divcon, sno_nomina.subnom, sno_nomina.informa,sno_nomina.*,        sno_nomina.recdocpagperche, sno_nomina.tipdocpagperche, sno_nomina.estctaalt, sno_nomina.racobrnom, 
				        sno_nomina.ctnom,sno_nomina.ctmetnom, 		sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina.nomespfid   FROM sno_nomina, sno_periodo  WHERE sno_nomina.codemp='0001'    AND sno_nomina.codnom='0200'    AND sno_nomina.codemp=sno_periodo.codemp    AND sno_nomina.codnom=sno_periodo.codnom    AND sno_nomina.peractnom=sno_periodo.codperi 

25/02/2016 10:31:13  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->SNO MÉTODO->uf_crear_sessionnomina ERROR->Invalid query: ERROR:  no existe la columna sno_nomina.nomespfid
LINE 2: ...etnom,   sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina...
                                                             ^
Whole query: SELECT sno_nomina.codnom, sno_nomina.desnom, sno_nomina.peractnom, sno_nomina.diabonvacnom, sno_nomina.diareivacnom, 		sno_nomina.adenom, sno_periodo.fecdesper, sno_periodo.fechasper, sno_periodo.cerper, sno_periodo.conper,		sno_periodo.totper, sno_nomina.anocurnom, sno_nomina.tippernom, sno_nomina.perresnom, sno_nomina.racnom, 		sno_nomina.subnom, sno_nomina.espnom, sno_nomina.consulnom, sno_nomina.descomnom, sno_nomina.codpronom, 		sno_nomina.codbennom, sno_nomina.conaponom, sno_nomina.cueconnom, sno_nomina.notdebnom,        sno_nomina.numvounom, sno_nomina.recdocnom, sno_nomina.recdocapo, sno_nomina.tipdocnom, sno_nomina.tipdocapo, 		sno_nomina.tipnom, sno_nomina.fecininom, sno_nomina.numpernom, sno_nomina.conpernom, sno_nomina.conpronom, 		sno_nomina.titrepnom, sno_nomina.divcon, sno_nomina.subnom, sno_nomina.informa,sno_nomina.*,        sno_nomina.recdocpagperche, sno_nomina.tipdocpagperche, sno_nomina.estctaalt, sno_nomina.racobrnom, 
				        sno_nomina.ctnom,sno_nomina.ctmetnom, 		sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina.nomespfid   FROM sno_nomina, sno_periodo  WHERE sno_nomina.codemp='0001'    AND sno_nomina.codnom='0200'    AND sno_nomina.codemp=sno_periodo.codemp    AND sno_nomina.codnom=sno_periodo.codnom    AND sno_nomina.peractnom=sno_periodo.codperi 

25/02/2016 10:31:43  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->SNO MÉTODO->uf_crear_sessionnomina ERROR->Invalid query: ERROR:  no existe la columna sno_nomina.nomespfid
LINE 2: ...etnom,   sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina...
                                                             ^
Whole query: SELECT sno_nomina.codnom, sno_nomina.desnom, sno_nomina.peractnom, sno_nomina.diabonvacnom, sno_nomina.diareivacnom, 		sno_nomina.adenom, sno_periodo.fecdesper, sno_periodo.fechasper, sno_periodo.cerper, sno_periodo.conper,		sno_periodo.totper, sno_nomina.anocurnom, sno_nomina.tippernom, sno_nomina.perresnom, sno_nomina.racnom, 		sno_nomina.subnom, sno_nomina.espnom, sno_nomina.consulnom, sno_nomina.descomnom, sno_nomina.codpronom, 		sno_nomina.codbennom, sno_nomina.conaponom, sno_nomina.cueconnom, sno_nomina.notdebnom,        sno_nomina.numvounom, sno_nomina.recdocnom, sno_nomina.recdocapo, sno_nomina.tipdocnom, sno_nomina.tipdocapo, 		sno_nomina.tipnom, sno_nomina.fecininom, sno_nomina.numpernom, sno_nomina.conpernom, sno_nomina.conpronom, 		sno_nomina.titrepnom, sno_nomina.divcon, sno_nomina.subnom, sno_nomina.informa,sno_nomina.*,        sno_nomina.recdocpagperche, sno_nomina.tipdocpagperche, sno_nomina.estctaalt, sno_nomina.racobrnom, 
				        sno_nomina.ctnom,sno_nomina.ctmetnom, 		sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina.nomespfid   FROM sno_nomina, sno_periodo  WHERE sno_nomina.codemp='0001'    AND sno_nomina.codnom='0200'    AND sno_nomina.codemp=sno_periodo.codemp    AND sno_nomina.codnom=sno_periodo.codnom    AND sno_nomina.peractnom=sno_periodo.codperi 

25/02/2016 10:32:00  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->SNO MÉTODO->uf_crear_sessionnomina ERROR->Invalid query: ERROR:  no existe la columna sno_nomina.nomespfid
LINE 2: ...etnom,   sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina...
                                                             ^
Whole query: SELECT sno_nomina.codnom, sno_nomina.desnom, sno_nomina.peractnom, sno_nomina.diabonvacnom, sno_nomina.diareivacnom, 		sno_nomina.adenom, sno_periodo.fecdesper, sno_periodo.fechasper, sno_periodo.cerper, sno_periodo.conper,		sno_periodo.totper, sno_nomina.anocurnom, sno_nomina.tippernom, sno_nomina.perresnom, sno_nomina.racnom, 		sno_nomina.subnom, sno_nomina.espnom, sno_nomina.consulnom, sno_nomina.descomnom, sno_nomina.codpronom, 		sno_nomina.codbennom, sno_nomina.conaponom, sno_nomina.cueconnom, sno_nomina.notdebnom,        sno_nomina.numvounom, sno_nomina.recdocnom, sno_nomina.recdocapo, sno_nomina.tipdocnom, sno_nomina.tipdocapo, 		sno_nomina.tipnom, sno_nomina.fecininom, sno_nomina.numpernom, sno_nomina.conpernom, sno_nomina.conpronom, 		sno_nomina.titrepnom, sno_nomina.divcon, sno_nomina.subnom, sno_nomina.informa,sno_nomina.*,        sno_nomina.recdocpagperche, sno_nomina.tipdocpagperche, sno_nomina.estctaalt, sno_nomina.racobrnom, 
				        sno_nomina.ctnom,sno_nomina.ctmetnom, 		sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina.nomespfid   FROM sno_nomina, sno_periodo  WHERE sno_nomina.codemp='0001'    AND sno_nomina.codnom='0200'    AND sno_nomina.codemp=sno_periodo.codemp    AND sno_nomina.codnom=sno_periodo.codnom    AND sno_nomina.peractnom=sno_periodo.codperi 

25/02/2016 10:34:14  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->SNO MÉTODO->uf_crear_sessionnomina ERROR->Invalid query: ERROR:  no existe la columna sno_nomina.nomespfid
LINE 2: ...etnom,   sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina...
                                                             ^
Whole query: SELECT sno_nomina.codnom, sno_nomina.desnom, sno_nomina.peractnom, sno_nomina.diabonvacnom, sno_nomina.diareivacnom, 		sno_nomina.adenom, sno_periodo.fecdesper, sno_periodo.fechasper, sno_periodo.cerper, sno_periodo.conper,		sno_periodo.totper, sno_nomina.anocurnom, sno_nomina.tippernom, sno_nomina.perresnom, sno_nomina.racnom, 		sno_nomina.subnom, sno_nomina.espnom, sno_nomina.consulnom, sno_nomina.descomnom, sno_nomina.codpronom, 		sno_nomina.codbennom, sno_nomina.conaponom, sno_nomina.cueconnom, sno_nomina.notdebnom,        sno_nomina.numvounom, sno_nomina.recdocnom, sno_nomina.recdocapo, sno_nomina.tipdocnom, sno_nomina.tipdocapo, 		sno_nomina.tipnom, sno_nomina.fecininom, sno_nomina.numpernom, sno_nomina.conpernom, sno_nomina.conpronom, 		sno_nomina.titrepnom, sno_nomina.divcon, sno_nomina.subnom, sno_nomina.informa,sno_nomina.*,        sno_nomina.recdocpagperche, sno_nomina.tipdocpagperche, sno_nomina.estctaalt, sno_nomina.racobrnom, 
				        sno_nomina.ctnom,sno_nomina.ctmetnom, 		sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina.nomespfid   FROM sno_nomina, sno_periodo  WHERE sno_nomina.codemp='0001'    AND sno_nomina.codnom='0200'    AND sno_nomina.codemp=sno_periodo.codemp    AND sno_nomina.codnom=sno_periodo.codnom    AND sno_nomina.peractnom=sno_periodo.codperi 

25/02/2016 10:34:51  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->SNO MÉTODO->uf_crear_sessionnomina ERROR->Invalid query: ERROR:  no existe la columna sno_nomina.nomespfid
LINE 2: ...etnom,   sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina...
                                                             ^
Whole query: SELECT sno_nomina.codnom, sno_nomina.desnom, sno_nomina.peractnom, sno_nomina.diabonvacnom, sno_nomina.diareivacnom, 		sno_nomina.adenom, sno_periodo.fecdesper, sno_periodo.fechasper, sno_periodo.cerper, sno_periodo.conper,		sno_periodo.totper, sno_nomina.anocurnom, sno_nomina.tippernom, sno_nomina.perresnom, sno_nomina.racnom, 		sno_nomina.subnom, sno_nomina.espnom, sno_nomina.consulnom, sno_nomina.descomnom, sno_nomina.codpronom, 		sno_nomina.codbennom, sno_nomina.conaponom, sno_nomina.cueconnom, sno_nomina.notdebnom,        sno_nomina.numvounom, sno_nomina.recdocnom, sno_nomina.recdocapo, sno_nomina.tipdocnom, sno_nomina.tipdocapo, 		sno_nomina.tipnom, sno_nomina.fecininom, sno_nomina.numpernom, sno_nomina.conpernom, sno_nomina.conpronom, 		sno_nomina.titrepnom, sno_nomina.divcon, sno_nomina.subnom, sno_nomina.informa,sno_nomina.*,        sno_nomina.recdocpagperche, sno_nomina.tipdocpagperche, sno_nomina.estctaalt, sno_nomina.racobrnom, 
				        sno_nomina.ctnom,sno_nomina.ctmetnom, 		sno_nomina.nomliq, sno_nomina.hojtienom, sno_nomina.nomespfid   FROM sno_nomina, sno_periodo  WHERE sno_nomina.codemp='0001'    AND sno_nomina.codnom='0200'    AND sno_nomina.codemp=sno_periodo.codemp    AND sno_nomina.codnom=sno_periodo.codnom    AND sno_nomina.peractnom=sno_periodo.codperi 

25/02/2016 10:37:53  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->Calcular Nómina MÉTODO->uf_evaluar_conceptopersonal ERROR->Invalid query: ERROR:  no existe la columna «prorat»
LINE 6: ...acuiniemp, ccp.acupat, ccp.acuinipat, ccp.quirepcon,prorat, 
                                                               ^
Whole query: SELECT ccp.codemp, ccp.codnom, ccp.codper, ccp.codconc, ccp.nomcon, ccp.titcon, ccp.sigcon, ccp.forcon, ccp.glocon, 
		                ccp.acumaxcon, ccp.valmincon, ccp.valmaxcon, ccp.concon, ccp.cueprecon, ccp.cueconcon, 		
						ccp.aplisrcon, ccp.sueintcon, ccp.intprocon, ccp.forpatcon, ccp.cueprepatcon, ccp.cueconpatcon, ccp.titretempcon, 
				        ccp.titretpatcon, ccp.valminpatcon, ccp.valmaxpatcon, ccp.codprov, ccp.cedben, ccp.conprenom, ccp.sueintvaccon, 
						ccp.aplarccon, ccp.aplcon, ccp.valcon, ccp.acuemp,   		
						ccp.acuiniemp, ccp.acupat, ccp.acuinipat, ccp.quirepcon,prorat, 
				        c.codestpro1,c.codestpro2,c.codestpro3,c.codestpro4,c.codestpro5,c.estcla 
				   FROM calculo_conceptospersonal ccp 
				   INNER JOIN sno_concepto c ON c.codemp  = ccp.codemp
				                            AND c.codnom  = ccp.codnom
											AND c.codconc = ccp.codconc
				   WHERE ccp.codemp='0001' 
				     AND ccp.codnom='0200' 
				     AND ccp.codper='0000791565' 
				ORDER BY ccp.codemp, ccp.codnom, ccp.codconc

25/02/2016 10:40:21  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  CLASE->Calcular Nómina MÉTODO->uf_evaluar_conceptopersonal ERROR->Invalid query: ERROR:  no existe la columna «prorat»
LINE 6: ...acuiniemp, ccp.acupat, ccp.acuinipat, ccp.quirepcon,prorat, 
                                                               ^
Whole query: SELECT ccp.codemp, ccp.codnom, ccp.codper, ccp.codconc, ccp.nomcon, ccp.titcon, ccp.sigcon, ccp.forcon, ccp.glocon, 
		                ccp.acumaxcon, ccp.valmincon, ccp.valmaxcon, ccp.concon, ccp.cueprecon, ccp.cueconcon, 		
						ccp.aplisrcon, ccp.sueintcon, ccp.intprocon, ccp.forpatcon, ccp.cueprepatcon, ccp.cueconpatcon, ccp.titretempcon, 
				        ccp.titretpatcon, ccp.valminpatcon, ccp.valmaxpatcon, ccp.codprov, ccp.cedben, ccp.conprenom, ccp.sueintvaccon, 
						ccp.aplarccon, ccp.aplcon, ccp.valcon, ccp.acuemp,   		
						ccp.acuiniemp, ccp.acupat, ccp.acuinipat, ccp.quirepcon,prorat, 
				        c.codestpro1,c.codestpro2,c.codestpro3,c.codestpro4,c.codestpro5,c.estcla 
				   FROM calculo_conceptospersonal ccp 
				   INNER JOIN sno_concepto c ON c.codemp  = ccp.codemp
				                            AND c.codnom  = ccp.codnom
											AND c.codconc = ccp.codconc
				   WHERE ccp.codemp='0001' 
				     AND ccp.codnom='0200' 
				     AND ccp.codper='0000791565' 
				ORDER BY ccp.codemp, ccp.codnom, ccp.codconc

25/02/2016 11:10:34  *****  ERROR DE SISTEMA:   *****  abrahamm  *****  ERROR->Invalid query: ERROR:  no existe la columna sno_personal.habediusu
LINE 2:       sno_personal.habediusu, sno_personal.feccieedi,
              ^
Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, 		sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, 		sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, 		sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, 		sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, 		sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, 		sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, 		sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, 		sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, 		sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper,        sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, 		sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa,        sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin,         sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper,        sno_personal.talpanper,  sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,        sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, 
						sno_personal.habediusu, sno_personal.feccieedi,
				       (SELECT denger FROM srh_gerencia          WHERE srh_gerencia.codemp = sno_personal.codemp            AND srh_gerencia.codger = sno_personal.codger ) AS denger,        (SELECT desorg FROM srh_organigrama          WHERE srh_organigrama.codemp = sno_personal.codemp            AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, 		(SELECT denunivipladin FROM srh_unidadvipladin 		  WHERE srh_unidadvipladin.codemp = sno_personal.codemp 			AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, 		(SELECT dentippersss FROM sno_tipopersonalsss WHERE  sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss,		(SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, 		(SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, 		(SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, 		(SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac   FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia  WHERE sno_personal.codemp='0001'   AND sno_profesion.codemp = sno_personal.codemp    AND sno_profesion.codpro = sno_personal.codpro    AND sigesp_pais.codpai = sno_personal.codpai    AND sigesp_estados.codpai = sno_personal.codpai    AND sigesp_estados.codest = sno_personal.codest    AND sigesp_municipio.codpai = sno_personal.codpai    AND sigesp_municipio.codest = sno_personal.codest    AND sigesp_municipio.codmun = sno_personal.codmun    AND sigesp_parroquia.codpai = sno_personal.codpai    AND sigesp_parroquia.codest = sno_personal.codest    AND sigesp_parroquia.codmun = sno_personal.codmun    AND sigesp_parroquia.codpar = sno_personal.codpar    AND sno_personal.codper ILIKE '%%'    AND sno_personal.cedper ILIKE '%%'   AND sno_personal.nomper ILIKE '%%'    AND sno_personal.apeper ILIKE '%YEPEZ%'   AND sno_personal.numexpper ILIKE '%%'  AND sno_personal.codper IN (SELECT sno_personal.codper FROM  sss_permisos_internos,sno_personal WHERE  sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='abrahamm'  AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper  ) ORDER BY sno_personal.codper 

25/02/2016 11:34:10  *****  ERROR DE SISTEMA:   *****  lleon  *****  No se encontraron resultados

25/02/2016 12:12:45  *****  ERROR DE SISTEMA:   *****  pacosta  *****  ERROR->Invalid query: ERROR:  no existe la columna «cestiksuel»
LINE 1: ...rnom, titrepnom, codorgcestic, informa, racobrnom,cestiksuel...
                                                             ^
Whole query: SELECT codemp, codnom, desnom, tippernom, despernom, anocurnom, fecininom, peractnom, numpernom, tipnom, 		 subnom, racnom, adenom, espnom, ctnom, ctmetnom, diabonvacnom, diareivacnom, diainivacnom, diatopvacnom, 		 diaincvacnom, consulnom, descomnom, codpronom, codbennom, conaponom, cueconnom, notdebnom, numvounom, 		 perresnom, recdocnom, tipdocnom, recdocapo, tipdocapo, conpernom, titrepnom, codorgcestic, informa, racobrnom,cestiksuel, 		 (SELECT count(codperi) FROM sno_periodo  		   WHERE codemp='0001'    		 AND codnom='%%'    		 AND cerper=1) AS total, 		 (SELECT substr(cast(fecdesper as char(10)),6,2) FROM sno_periodo  		   WHERE codemp=sno_nomina.codemp    		 AND codnom=sno_nomina.codnom    		 AND codperi=sno_nomina.peractnom) AS mesactual  FROM sno_nomina   WHERE codemp='0001'     AND codnom ILIKE '%%'     AND desnom ILIKE '%%'  ORDER BY codnom 

25/02/2016 12:14:23  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  no existe la restricción «fk_sep_dt_c_sep_conce_sep_conc» en la relación «sep_dt_concepto»
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 12:16:55  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la columna «numrecdoc» en la relación «sob_valuacion»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 12:18:32  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la columna «numdoccom» en la relación «cxp_dc_spg»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 14:49:06  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_10_2014 ERROR->Invalid query: ERROR:  no existe la restricción «fk_sep_dt_c_sep_conce_sep_conc» en la relación «sep_dt_concepto»
Whole query:   ALTER TABLE sep_conceptos ALTER codconsep TYPE character varying(10);
			   			   ALTER TABLE sep_conceptocargos ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dt_concepto ALTER codconsep TYPE character varying(10);
						   ALTER TABLE sep_dtc_cargos ALTER codconsep TYPE character varying(10);
						   	
							
									   
						    /*ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conceptocargos__sep_conceptos;
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto;
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_concepto__sep_conceptos;*/
							
							ALTER TABLE sep_conceptocargos DROP CONSTRAINT fk_sep_conc_sep_conce_sep_conc;									
							ALTER TABLE sep_dtc_cargos DROP CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c;							
							ALTER TABLE sep_dt_concepto DROP CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc;
							
							UPDATE sep_conceptos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_conceptocargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dtc_cargos SET codconsep=lpad(codconsep,10,'0');
							UPDATE sep_dt_concepto SET codconsep=lpad(codconsep,10,'0');
							
							
							/*ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conceptocargos__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc__sep_dtcon_sep_dt_c FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_concepto__sep_conceptos FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;*/
								  
							ALTER TABLE sep_conceptocargos
							  ADD CONSTRAINT fk_sep_conc_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dtc_cargos
							  ADD CONSTRAINT fk_sep_dtc_cargos__sep_dt_concepto FOREIGN KEY (codemp, numsol, codconsep)
								  REFERENCES sep_dt_concepto (codemp, numsol, codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
							ALTER TABLE sep_dt_concepto
							  ADD CONSTRAINT fk_sep_dt_c_sep_conce_sep_conc FOREIGN KEY (codconsep)
								  REFERENCES sep_conceptos (codconsep) MATCH SIMPLE
								  ON UPDATE RESTRICT ON DELETE RESTRICT;
			   			

25/02/2016 14:50:37  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la columna «numrecdoc» en la relación «sob_valuacion»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 14:53:34  *****  ERROR DE SISTEMA:   *****  pacosta  *****  CLASE->covensol_release MÉTODO->covensol_release_COVENSOL_12_2014 ERROR->Invalid query: ERROR:  no existe la columna «numdoccom» en la relación «cxp_dc_spg»
Whole query:   
			   				ALTER TABLE cxp_sol_dc ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret_op ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_dc_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_cmp_islr ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dt_solicitudes ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE sob_valuacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numfac TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_solicitudes_scg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd_scg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_deducciones ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_cargos ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE cxp_rd_amortizacion ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_historico_rd ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spi ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numrecdoc TYPE character varying(30); 
							ALTER TABLE cxp_dc_spg ALTER numdoccom TYPE character varying(30); 
							ALTER TABLE spi_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spi_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_variacion ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_mensual ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE spg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dtmp_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scg_dt_cmp ALTER documento TYPE character varying(30); 
							ALTER TABLE scb_dt_cmp_ret ALTER numdoc TYPE character varying(30);
							ALTER TABLE scb_dt_cmp_ret_op ALTER numdoc TYPE character varying(30);
			   
			            

25/02/2016 15:49:35  *****  ERROR DE SISTEMA:   *****  avelasquez  *****   ERROR-> La cuenta Contable 1230502121501010001 no existe