2026-06-23 22:57:33,899 - INFO - Dropping table fOportunidades...
2026-06-23 22:57:33,919 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-23 22:57:48,703 - INFO - Dropping table fAcoesFunil...
2026-06-23 22:57:48,717 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-23 22:58:10,573 - INFO - Dropping table fAtividades...
2026-06-23 22:58:10,584 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-23 22:59:26,655 - INFO - Dropping table fPropostas...
2026-06-23 22:59:26,657 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-23 22:59:27,296 - INFO - Dropping table fVendas...
2026-06-23 22:59:27,298 - INFO - Creating table fVendas from vw_fVendas...
2026-06-23 22:59:27,755 - INFO - Batch 1 completed.
2026-06-23 22:59:27,756 - INFO - All tables refreshed.
2026-06-23 22:59:27,756 - INFO - Synchronization process completed successfully in 140.0853612422943 seconds.
2026-06-23 23:57:08,179 - INFO - Creating tables by calling stored procedure...
2026-06-23 23:57:08,368 - INFO - Tables created successfully via stored procedure.
2026-06-23 23:57:08,372 - INFO - Truncating tables...
2026-06-23 23:57:08,372 - INFO - Truncating table bi_acessos...
2026-06-23 23:57:08,373 - INFO - Truncating table bi_acoes_funil...
2026-06-23 23:57:08,373 - INFO - Truncating table bi_atividades...
2026-06-23 23:57:08,376 - INFO - Truncating table bi_oportunidades...
2026-06-23 23:57:08,376 - INFO - Truncating table bi_propostas...
2026-06-23 23:57:08,377 - INFO - Truncating table bi_vendas...
2026-06-23 23:57:08,377 - INFO - Truncating table bi_utms...
2026-06-23 23:57:08,378 - INFO - Truncation completed.
2026-06-23 23:57:08,378 - INFO - Fetching data from source database...
2026-06-23 23:57:30,026 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-23 23:57:30,027 - INFO - Creating star schema...
2026-06-23 23:57:30,124 - INFO - Star schema created successfully.
2026-06-23 23:57:30,125 - INFO - Refreshing tables (batch mode)...
2026-06-23 23:57:30,125 - INFO - Dropping table dCanais...
2026-06-23 23:57:30,128 - INFO - Creating table dCanais from vw_dCanais...
2026-06-23 23:57:30,145 - INFO - Dropping table dCategorias...
2026-06-23 23:57:30,149 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-23 23:57:30,165 - INFO - Dropping table dConsultores...
2026-06-23 23:57:30,168 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-23 23:57:30,188 - INFO - Dropping table dEmpreendimentos...
2026-06-23 23:57:30,191 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-23 23:57:30,205 - INFO - Dropping table dEstadosCivis...
2026-06-23 23:57:30,208 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-23 23:57:30,224 - INFO - Dropping table dEtapasFunil...
2026-06-23 23:57:30,227 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-23 23:57:30,253 - INFO - Dropping table dFaixasIdade...
2026-06-23 23:57:30,256 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-23 23:57:30,268 - INFO - Dropping table dFechamentoDias...
2026-06-23 23:57:30,270 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-23 23:57:30,283 - INFO - Dropping table dInteresses...
2026-06-23 23:57:30,285 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-23 23:57:30,305 - INFO - Dropping table dMidias...
2026-06-23 23:57:30,308 - INFO - Creating table dMidias from vw_dMidias...
2026-06-23 23:57:30,330 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-23 23:57:30,333 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-23 23:57:30,351 - INFO - Dropping table dProfissoes...
2026-06-23 23:57:30,354 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-23 23:57:30,364 - INFO - Dropping table dQuartos...
2026-06-23 23:57:30,366 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-23 23:57:30,368 - INFO - Dropping table dRegioes...
2026-06-23 23:57:30,370 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-23 23:57:30,396 - INFO - Dropping table dRendas...
2026-06-23 23:57:30,398 - INFO - Creating table dRendas from vw_dRendas...
2026-06-23 23:57:30,409 - INFO - Dropping table dSexos...
2026-06-23 23:57:30,412 - INFO - Creating table dSexos from vw_dSexos...
2026-06-23 23:57:30,433 - INFO - Dropping table dStatus...
2026-06-23 23:57:30,439 - INFO - Creating table dStatus from vw_dStatus...
2026-06-23 23:57:30,457 - INFO - Dropping table dStatusAtividade...
2026-06-23 23:57:30,459 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-23 23:57:30,497 - INFO - Dropping table dStatusProposta...
2026-06-23 23:57:30,499 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-23 23:57:30,503 - INFO - Dropping table dSuites...
2026-06-23 23:57:30,505 - INFO - Creating table dSuites from vw_dSuites...
2026-06-23 23:57:30,507 - INFO - Dropping table dTemperaturas...
2026-06-23 23:57:30,510 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-23 23:57:30,520 - INFO - Dropping table dTipos...
2026-06-23 23:57:30,522 - INFO - Creating table dTipos from vw_dTipos...
2026-06-23 23:57:30,544 - INFO - Dropping table dTiposAtividade...
2026-06-23 23:57:30,547 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-23 23:57:30,576 - INFO - Dropping table dUTMSource...
2026-06-23 23:57:30,578 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-23 23:57:30,627 - INFO - Dropping table dUTMMedium...
2026-06-23 23:57:30,629 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-23 23:57:30,672 - INFO - Dropping table dUTMCampaign...
2026-06-23 23:57:30,674 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-23 23:57:30,711 - INFO - Dropping table dUTMContent...
2026-06-23 23:57:30,713 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-23 23:57:30,750 - INFO - Dropping table dUTMTerm...
2026-06-23 23:57:30,756 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-23 23:57:30,797 - INFO - Dropping table dUnidades...
2026-06-23 23:57:30,799 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-23 23:57:30,813 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-23 23:57:30,815 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-23 23:57:30,819 - INFO - Dropping table dVagas...
2026-06-23 23:57:30,822 - INFO - Creating table dVagas from vw_dVagas...
2026-06-23 23:57:30,826 - INFO - Dropping table fAcessos...
2026-06-23 23:57:30,828 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-23 23:57:30,999 - INFO - Dropping table fOportunidades...
2026-06-23 23:57:31,003 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-23 23:57:43,583 - INFO - Dropping table fAcoesFunil...
2026-06-23 23:57:43,585 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-23 23:58:02,096 - INFO - Dropping table fAtividades...
2026-06-23 23:58:02,114 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-23 23:59:08,276 - INFO - Dropping table fPropostas...
2026-06-23 23:59:08,298 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-23 23:59:08,731 - INFO - Dropping table fVendas...
2026-06-23 23:59:08,734 - INFO - Creating table fVendas from vw_fVendas...
2026-06-23 23:59:09,178 - INFO - Batch 1 completed.
2026-06-23 23:59:09,178 - INFO - All tables refreshed.
2026-06-23 23:59:09,178 - INFO - Synchronization process completed successfully in 120.99934530258179 seconds.
2026-06-24 00:57:07,771 - INFO - Creating tables by calling stored procedure...
2026-06-24 00:57:07,972 - INFO - Tables created successfully via stored procedure.
2026-06-24 00:57:07,983 - INFO - Truncating tables...
2026-06-24 00:57:07,983 - INFO - Truncating table bi_acessos...
2026-06-24 00:57:07,984 - INFO - Truncating table bi_acoes_funil...
2026-06-24 00:57:07,984 - INFO - Truncating table bi_atividades...
2026-06-24 00:57:07,989 - INFO - Truncating table bi_oportunidades...
2026-06-24 00:57:07,990 - INFO - Truncating table bi_propostas...
2026-06-24 00:57:07,990 - INFO - Truncating table bi_vendas...
2026-06-24 00:57:07,991 - INFO - Truncating table bi_utms...
2026-06-24 00:57:07,992 - INFO - Truncation completed.
2026-06-24 00:57:08,065 - INFO - Fetching data from source database...
2026-06-24 00:57:30,115 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 00:57:30,116 - INFO - Creating star schema...
2026-06-24 00:57:30,197 - INFO - Star schema created successfully.
2026-06-24 00:57:30,197 - INFO - Refreshing tables (batch mode)...
2026-06-24 00:57:30,198 - INFO - Dropping table dCanais...
2026-06-24 00:57:30,200 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 00:57:30,212 - INFO - Dropping table dCategorias...
2026-06-24 00:57:30,216 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 00:57:30,228 - INFO - Dropping table dConsultores...
2026-06-24 00:57:30,231 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 00:57:30,250 - INFO - Dropping table dEmpreendimentos...
2026-06-24 00:57:30,253 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 00:57:30,280 - INFO - Dropping table dEstadosCivis...
2026-06-24 00:57:30,282 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 00:57:30,293 - INFO - Dropping table dEtapasFunil...
2026-06-24 00:57:30,295 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 00:57:30,319 - INFO - Dropping table dFaixasIdade...
2026-06-24 00:57:30,323 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 00:57:30,344 - INFO - Dropping table dFechamentoDias...
2026-06-24 00:57:30,346 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 00:57:30,367 - INFO - Dropping table dInteresses...
2026-06-24 00:57:30,369 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 00:57:30,386 - INFO - Dropping table dMidias...
2026-06-24 00:57:30,388 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 00:57:30,401 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 00:57:30,403 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 00:57:30,438 - INFO - Dropping table dProfissoes...
2026-06-24 00:57:30,441 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 00:57:30,464 - INFO - Dropping table dQuartos...
2026-06-24 00:57:30,467 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 00:57:30,472 - INFO - Dropping table dRegioes...
2026-06-24 00:57:30,474 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 00:57:30,494 - INFO - Dropping table dRendas...
2026-06-24 00:57:30,496 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 00:57:30,510 - INFO - Dropping table dSexos...
2026-06-24 00:57:30,512 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 00:57:30,529 - INFO - Dropping table dStatus...
2026-06-24 00:57:30,531 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 00:57:30,546 - INFO - Dropping table dStatusAtividade...
2026-06-24 00:57:30,549 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 00:57:30,578 - INFO - Dropping table dStatusProposta...
2026-06-24 00:57:30,580 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 00:57:30,587 - INFO - Dropping table dSuites...
2026-06-24 00:57:30,589 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 00:57:30,596 - INFO - Dropping table dTemperaturas...
2026-06-24 00:57:30,597 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 00:57:30,611 - INFO - Dropping table dTipos...
2026-06-24 00:57:30,613 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 00:57:30,628 - INFO - Dropping table dTiposAtividade...
2026-06-24 00:57:30,631 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 00:57:30,659 - INFO - Dropping table dUTMSource...
2026-06-24 00:57:30,661 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 00:57:30,701 - INFO - Dropping table dUTMMedium...
2026-06-24 00:57:30,703 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 00:57:30,743 - INFO - Dropping table dUTMCampaign...
2026-06-24 00:57:30,745 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 00:57:30,785 - INFO - Dropping table dUTMContent...
2026-06-24 00:57:30,787 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 00:57:30,825 - INFO - Dropping table dUTMTerm...
2026-06-24 00:57:30,827 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 00:57:30,871 - INFO - Dropping table dUnidades...
2026-06-24 00:57:30,873 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 00:57:30,889 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 00:57:30,892 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 00:57:30,897 - INFO - Dropping table dVagas...
2026-06-24 00:57:30,899 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 00:57:30,911 - INFO - Dropping table fAcessos...
2026-06-24 00:57:30,915 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 00:57:31,078 - INFO - Dropping table fOportunidades...
2026-06-24 00:57:31,081 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 00:57:43,788 - INFO - Dropping table fAcoesFunil...
2026-06-24 00:57:43,791 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 00:58:01,573 - INFO - Dropping table fAtividades...
2026-06-24 00:58:01,577 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 00:59:09,348 - INFO - Dropping table fPropostas...
2026-06-24 00:59:09,350 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 00:59:09,821 - INFO - Dropping table fVendas...
2026-06-24 00:59:09,824 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 00:59:10,206 - INFO - Batch 1 completed.
2026-06-24 00:59:10,206 - INFO - All tables refreshed.
2026-06-24 00:59:10,206 - INFO - Synchronization process completed successfully in 122.43504214286804 seconds.
2026-06-24 01:57:07,875 - INFO - Creating tables by calling stored procedure...
2026-06-24 01:57:08,087 - INFO - Tables created successfully via stored procedure.
2026-06-24 01:57:08,089 - INFO - Truncating tables...
2026-06-24 01:57:08,089 - INFO - Truncating table bi_acessos...
2026-06-24 01:57:08,090 - INFO - Truncating table bi_acoes_funil...
2026-06-24 01:57:08,091 - INFO - Truncating table bi_atividades...
2026-06-24 01:57:08,094 - INFO - Truncating table bi_oportunidades...
2026-06-24 01:57:08,095 - INFO - Truncating table bi_propostas...
2026-06-24 01:57:08,095 - INFO - Truncating table bi_vendas...
2026-06-24 01:57:08,097 - INFO - Truncating table bi_utms...
2026-06-24 01:57:08,097 - INFO - Truncation completed.
2026-06-24 01:57:08,097 - INFO - Fetching data from source database...
2026-06-24 01:57:33,273 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 01:57:33,274 - INFO - Creating star schema...
2026-06-24 01:57:33,388 - INFO - Star schema created successfully.
2026-06-24 01:57:33,388 - INFO - Refreshing tables (batch mode)...
2026-06-24 01:57:33,389 - INFO - Dropping table dCanais...
2026-06-24 01:57:33,391 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 01:57:33,405 - INFO - Dropping table dCategorias...
2026-06-24 01:57:33,408 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 01:57:33,425 - INFO - Dropping table dConsultores...
2026-06-24 01:57:33,428 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 01:57:33,446 - INFO - Dropping table dEmpreendimentos...
2026-06-24 01:57:33,448 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 01:57:33,470 - INFO - Dropping table dEstadosCivis...
2026-06-24 01:57:33,472 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 01:57:33,496 - INFO - Dropping table dEtapasFunil...
2026-06-24 01:57:33,498 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 01:57:33,536 - INFO - Dropping table dFaixasIdade...
2026-06-24 01:57:33,539 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 01:57:33,554 - INFO - Dropping table dFechamentoDias...
2026-06-24 01:57:33,557 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 01:57:33,577 - INFO - Dropping table dInteresses...
2026-06-24 01:57:33,580 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 01:57:33,595 - INFO - Dropping table dMidias...
2026-06-24 01:57:33,597 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 01:57:33,618 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 01:57:33,620 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 01:57:33,647 - INFO - Dropping table dProfissoes...
2026-06-24 01:57:33,648 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 01:57:33,664 - INFO - Dropping table dQuartos...
2026-06-24 01:57:33,667 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 01:57:33,674 - INFO - Dropping table dRegioes...
2026-06-24 01:57:33,676 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 01:57:33,711 - INFO - Dropping table dRendas...
2026-06-24 01:57:33,713 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 01:57:33,726 - INFO - Dropping table dSexos...
2026-06-24 01:57:33,727 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 01:57:33,745 - INFO - Dropping table dStatus...
2026-06-24 01:57:33,747 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 01:57:33,762 - INFO - Dropping table dStatusAtividade...
2026-06-24 01:57:33,764 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 01:57:33,791 - INFO - Dropping table dStatusProposta...
2026-06-24 01:57:33,793 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 01:57:33,798 - INFO - Dropping table dSuites...
2026-06-24 01:57:33,800 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 01:57:33,806 - INFO - Dropping table dTemperaturas...
2026-06-24 01:57:33,807 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 01:57:33,818 - INFO - Dropping table dTipos...
2026-06-24 01:57:33,820 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 01:57:33,835 - INFO - Dropping table dTiposAtividade...
2026-06-24 01:57:33,837 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 01:57:33,877 - INFO - Dropping table dUTMSource...
2026-06-24 01:57:33,879 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 01:57:33,927 - INFO - Dropping table dUTMMedium...
2026-06-24 01:57:33,930 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 01:57:33,983 - INFO - Dropping table dUTMCampaign...
2026-06-24 01:57:33,985 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 01:57:34,043 - INFO - Dropping table dUTMContent...
2026-06-24 01:57:34,045 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 01:57:34,090 - INFO - Dropping table dUTMTerm...
2026-06-24 01:57:34,092 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 01:57:34,147 - INFO - Dropping table dUnidades...
2026-06-24 01:57:34,149 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 01:57:34,164 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 01:57:34,165 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 01:57:34,169 - INFO - Dropping table dVagas...
2026-06-24 01:57:34,171 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 01:57:34,174 - INFO - Dropping table fAcessos...
2026-06-24 01:57:34,177 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 01:57:34,439 - INFO - Dropping table fOportunidades...
2026-06-24 01:57:34,441 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 01:57:49,003 - INFO - Dropping table fAcoesFunil...
2026-06-24 01:57:49,014 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 01:58:09,544 - INFO - Dropping table fAtividades...
2026-06-24 01:58:09,549 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 01:59:20,831 - INFO - Dropping table fPropostas...
2026-06-24 01:59:20,835 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 01:59:21,267 - INFO - Dropping table fVendas...
2026-06-24 01:59:21,271 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 01:59:21,688 - INFO - Batch 1 completed.
2026-06-24 01:59:21,688 - INFO - All tables refreshed.
2026-06-24 01:59:21,688 - INFO - Synchronization process completed successfully in 133.81370162963867 seconds.
2026-06-24 02:57:08,081 - INFO - Creating tables by calling stored procedure...
2026-06-24 02:57:08,287 - INFO - Tables created successfully via stored procedure.
2026-06-24 02:57:08,289 - INFO - Truncating tables...
2026-06-24 02:57:08,290 - INFO - Truncating table bi_acessos...
2026-06-24 02:57:08,290 - INFO - Truncating table bi_acoes_funil...
2026-06-24 02:57:08,291 - INFO - Truncating table bi_atividades...
2026-06-24 02:57:08,367 - INFO - Truncating table bi_oportunidades...
2026-06-24 02:57:08,368 - INFO - Truncating table bi_propostas...
2026-06-24 02:57:08,368 - INFO - Truncating table bi_vendas...
2026-06-24 02:57:08,369 - INFO - Truncating table bi_utms...
2026-06-24 02:57:08,370 - INFO - Truncation completed.
2026-06-24 02:57:08,370 - INFO - Fetching data from source database...
2026-06-24 02:57:30,750 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 02:57:30,751 - INFO - Creating star schema...
2026-06-24 02:57:30,839 - INFO - Star schema created successfully.
2026-06-24 02:57:30,839 - INFO - Refreshing tables (batch mode)...
2026-06-24 02:57:30,839 - INFO - Dropping table dCanais...
2026-06-24 02:57:30,842 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 02:57:30,854 - INFO - Dropping table dCategorias...
2026-06-24 02:57:30,856 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 02:57:30,873 - INFO - Dropping table dConsultores...
2026-06-24 02:57:30,876 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 02:57:30,889 - INFO - Dropping table dEmpreendimentos...
2026-06-24 02:57:30,893 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 02:57:30,907 - INFO - Dropping table dEstadosCivis...
2026-06-24 02:57:30,908 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 02:57:30,924 - INFO - Dropping table dEtapasFunil...
2026-06-24 02:57:30,926 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 02:57:30,964 - INFO - Dropping table dFaixasIdade...
2026-06-24 02:57:30,966 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 02:57:30,989 - INFO - Dropping table dFechamentoDias...
2026-06-24 02:57:30,991 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 02:57:31,005 - INFO - Dropping table dInteresses...
2026-06-24 02:57:31,007 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 02:57:31,021 - INFO - Dropping table dMidias...
2026-06-24 02:57:31,023 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 02:57:31,036 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 02:57:31,038 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 02:57:31,066 - INFO - Dropping table dProfissoes...
2026-06-24 02:57:31,068 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 02:57:31,091 - INFO - Dropping table dQuartos...
2026-06-24 02:57:31,094 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 02:57:31,099 - INFO - Dropping table dRegioes...
2026-06-24 02:57:31,101 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 02:57:31,125 - INFO - Dropping table dRendas...
2026-06-24 02:57:31,127 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 02:57:31,140 - INFO - Dropping table dSexos...
2026-06-24 02:57:31,142 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 02:57:31,158 - INFO - Dropping table dStatus...
2026-06-24 02:57:31,160 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 02:57:31,178 - INFO - Dropping table dStatusAtividade...
2026-06-24 02:57:31,180 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 02:57:31,215 - INFO - Dropping table dStatusProposta...
2026-06-24 02:57:31,218 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 02:57:31,223 - INFO - Dropping table dSuites...
2026-06-24 02:57:31,225 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 02:57:31,230 - INFO - Dropping table dTemperaturas...
2026-06-24 02:57:31,231 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 02:57:31,247 - INFO - Dropping table dTipos...
2026-06-24 02:57:31,249 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 02:57:31,266 - INFO - Dropping table dTiposAtividade...
2026-06-24 02:57:31,269 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 02:57:31,292 - INFO - Dropping table dUTMSource...
2026-06-24 02:57:31,294 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 02:57:31,339 - INFO - Dropping table dUTMMedium...
2026-06-24 02:57:31,341 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 02:57:31,383 - INFO - Dropping table dUTMCampaign...
2026-06-24 02:57:31,385 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 02:57:31,428 - INFO - Dropping table dUTMContent...
2026-06-24 02:57:31,430 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 02:57:31,477 - INFO - Dropping table dUTMTerm...
2026-06-24 02:57:31,479 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 02:57:31,524 - INFO - Dropping table dUnidades...
2026-06-24 02:57:31,527 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 02:57:31,540 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 02:57:31,543 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 02:57:31,547 - INFO - Dropping table dVagas...
2026-06-24 02:57:31,549 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 02:57:31,552 - INFO - Dropping table fAcessos...
2026-06-24 02:57:31,553 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 02:57:31,716 - INFO - Dropping table fOportunidades...
2026-06-24 02:57:31,719 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 02:57:44,316 - INFO - Dropping table fAcoesFunil...
2026-06-24 02:57:44,330 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 02:58:04,074 - INFO - Dropping table fAtividades...
2026-06-24 02:58:04,078 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 02:59:12,913 - INFO - Dropping table fPropostas...
2026-06-24 02:59:12,915 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 02:59:13,322 - INFO - Dropping table fVendas...
2026-06-24 02:59:13,325 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 02:59:13,733 - INFO - Batch 1 completed.
2026-06-24 02:59:13,734 - INFO - All tables refreshed.
2026-06-24 02:59:13,734 - INFO - Synchronization process completed successfully in 125.65245580673218 seconds.
2026-06-24 03:57:07,194 - INFO - Creating tables by calling stored procedure...
2026-06-24 03:57:07,380 - INFO - Tables created successfully via stored procedure.
2026-06-24 03:57:07,384 - INFO - Truncating tables...
2026-06-24 03:57:07,384 - INFO - Truncating table bi_acessos...
2026-06-24 03:57:07,385 - INFO - Truncating table bi_acoes_funil...
2026-06-24 03:57:07,385 - INFO - Truncating table bi_atividades...
2026-06-24 03:57:07,388 - INFO - Truncating table bi_oportunidades...
2026-06-24 03:57:07,388 - INFO - Truncating table bi_propostas...
2026-06-24 03:57:07,389 - INFO - Truncating table bi_vendas...
2026-06-24 03:57:07,389 - INFO - Truncating table bi_utms...
2026-06-24 03:57:07,390 - INFO - Truncation completed.
2026-06-24 03:57:07,390 - INFO - Fetching data from source database...
2026-06-24 03:57:30,838 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 03:57:30,839 - INFO - Creating star schema...
2026-06-24 03:57:30,928 - INFO - Star schema created successfully.
2026-06-24 03:57:30,929 - INFO - Refreshing tables (batch mode)...
2026-06-24 03:57:30,929 - INFO - Dropping table dCanais...
2026-06-24 03:57:30,931 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 03:57:30,944 - INFO - Dropping table dCategorias...
2026-06-24 03:57:30,945 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 03:57:30,957 - INFO - Dropping table dConsultores...
2026-06-24 03:57:30,959 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 03:57:30,973 - INFO - Dropping table dEmpreendimentos...
2026-06-24 03:57:30,975 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 03:57:30,988 - INFO - Dropping table dEstadosCivis...
2026-06-24 03:57:30,991 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 03:57:31,009 - INFO - Dropping table dEtapasFunil...
2026-06-24 03:57:31,011 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 03:57:31,037 - INFO - Dropping table dFaixasIdade...
2026-06-24 03:57:31,039 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 03:57:31,055 - INFO - Dropping table dFechamentoDias...
2026-06-24 03:57:31,057 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 03:57:31,077 - INFO - Dropping table dInteresses...
2026-06-24 03:57:31,079 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 03:57:31,097 - INFO - Dropping table dMidias...
2026-06-24 03:57:31,100 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 03:57:31,116 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 03:57:31,118 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 03:57:31,138 - INFO - Dropping table dProfissoes...
2026-06-24 03:57:31,140 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 03:57:31,161 - INFO - Dropping table dQuartos...
2026-06-24 03:57:31,163 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 03:57:31,167 - INFO - Dropping table dRegioes...
2026-06-24 03:57:31,172 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 03:57:31,199 - INFO - Dropping table dRendas...
2026-06-24 03:57:31,201 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 03:57:31,216 - INFO - Dropping table dSexos...
2026-06-24 03:57:31,221 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 03:57:31,236 - INFO - Dropping table dStatus...
2026-06-24 03:57:31,238 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 03:57:31,249 - INFO - Dropping table dStatusAtividade...
2026-06-24 03:57:31,251 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 03:57:31,275 - INFO - Dropping table dStatusProposta...
2026-06-24 03:57:31,277 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 03:57:31,282 - INFO - Dropping table dSuites...
2026-06-24 03:57:31,285 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 03:57:31,295 - INFO - Dropping table dTemperaturas...
2026-06-24 03:57:31,298 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 03:57:31,313 - INFO - Dropping table dTipos...
2026-06-24 03:57:31,316 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 03:57:31,340 - INFO - Dropping table dTiposAtividade...
2026-06-24 03:57:31,342 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 03:57:31,373 - INFO - Dropping table dUTMSource...
2026-06-24 03:57:31,375 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 03:57:31,417 - INFO - Dropping table dUTMMedium...
2026-06-24 03:57:31,419 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 03:57:31,461 - INFO - Dropping table dUTMCampaign...
2026-06-24 03:57:31,463 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 03:57:31,511 - INFO - Dropping table dUTMContent...
2026-06-24 03:57:31,513 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 03:57:31,579 - INFO - Dropping table dUTMTerm...
2026-06-24 03:57:31,581 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 03:57:31,621 - INFO - Dropping table dUnidades...
2026-06-24 03:57:31,623 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 03:57:31,644 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 03:57:31,647 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 03:57:31,650 - INFO - Dropping table dVagas...
2026-06-24 03:57:31,652 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 03:57:31,657 - INFO - Dropping table fAcessos...
2026-06-24 03:57:31,660 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 03:57:31,857 - INFO - Dropping table fOportunidades...
2026-06-24 03:57:31,863 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 03:57:44,467 - INFO - Dropping table fAcoesFunil...
2026-06-24 03:57:44,470 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 03:58:03,131 - INFO - Dropping table fAtividades...
2026-06-24 03:58:03,134 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 03:59:10,423 - INFO - Dropping table fPropostas...
2026-06-24 03:59:10,425 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 03:59:10,878 - INFO - Dropping table fVendas...
2026-06-24 03:59:10,880 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 03:59:11,417 - INFO - Batch 1 completed.
2026-06-24 03:59:11,417 - INFO - All tables refreshed.
2026-06-24 03:59:11,417 - INFO - Synchronization process completed successfully in 124.22261810302734 seconds.
2026-06-24 04:57:09,003 - INFO - Creating tables by calling stored procedure...
2026-06-24 04:57:09,243 - INFO - Tables created successfully via stored procedure.
2026-06-24 04:57:09,309 - INFO - Truncating tables...
2026-06-24 04:57:09,309 - INFO - Truncating table bi_acessos...
2026-06-24 04:57:09,310 - INFO - Truncating table bi_acoes_funil...
2026-06-24 04:57:09,311 - INFO - Truncating table bi_atividades...
2026-06-24 04:57:09,316 - INFO - Truncating table bi_oportunidades...
2026-06-24 04:57:09,317 - INFO - Truncating table bi_propostas...
2026-06-24 04:57:09,318 - INFO - Truncating table bi_vendas...
2026-06-24 04:57:09,322 - INFO - Truncating table bi_utms...
2026-06-24 04:57:09,329 - INFO - Truncation completed.
2026-06-24 04:57:09,329 - INFO - Fetching data from source database...
2026-06-24 04:57:33,396 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 04:57:33,397 - INFO - Creating star schema...
2026-06-24 04:57:33,517 - INFO - Star schema created successfully.
2026-06-24 04:57:33,517 - INFO - Refreshing tables (batch mode)...
2026-06-24 04:57:33,518 - INFO - Dropping table dCanais...
2026-06-24 04:57:33,522 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 04:57:33,545 - INFO - Dropping table dCategorias...
2026-06-24 04:57:33,549 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 04:57:33,565 - INFO - Dropping table dConsultores...
2026-06-24 04:57:33,569 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 04:57:33,585 - INFO - Dropping table dEmpreendimentos...
2026-06-24 04:57:33,589 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 04:57:33,620 - INFO - Dropping table dEstadosCivis...
2026-06-24 04:57:33,623 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 04:57:33,649 - INFO - Dropping table dEtapasFunil...
2026-06-24 04:57:33,652 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 04:57:33,675 - INFO - Dropping table dFaixasIdade...
2026-06-24 04:57:33,678 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 04:57:33,699 - INFO - Dropping table dFechamentoDias...
2026-06-24 04:57:33,706 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 04:57:33,736 - INFO - Dropping table dInteresses...
2026-06-24 04:57:33,741 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 04:57:33,762 - INFO - Dropping table dMidias...
2026-06-24 04:57:33,766 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 04:57:33,779 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 04:57:33,782 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 04:57:33,803 - INFO - Dropping table dProfissoes...
2026-06-24 04:57:33,808 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 04:57:33,828 - INFO - Dropping table dQuartos...
2026-06-24 04:57:33,836 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 04:57:33,843 - INFO - Dropping table dRegioes...
2026-06-24 04:57:33,846 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 04:57:33,865 - INFO - Dropping table dRendas...
2026-06-24 04:57:33,869 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 04:57:33,882 - INFO - Dropping table dSexos...
2026-06-24 04:57:33,887 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 04:57:33,908 - INFO - Dropping table dStatus...
2026-06-24 04:57:33,914 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 04:57:33,935 - INFO - Dropping table dStatusAtividade...
2026-06-24 04:57:33,941 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 04:57:33,967 - INFO - Dropping table dStatusProposta...
2026-06-24 04:57:33,971 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 04:57:33,976 - INFO - Dropping table dSuites...
2026-06-24 04:57:33,979 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 04:57:33,984 - INFO - Dropping table dTemperaturas...
2026-06-24 04:57:33,987 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 04:57:33,998 - INFO - Dropping table dTipos...
2026-06-24 04:57:34,001 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 04:57:34,033 - INFO - Dropping table dTiposAtividade...
2026-06-24 04:57:34,037 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 04:57:34,081 - INFO - Dropping table dUTMSource...
2026-06-24 04:57:34,086 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 04:57:34,138 - INFO - Dropping table dUTMMedium...
2026-06-24 04:57:34,147 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 04:57:34,202 - INFO - Dropping table dUTMCampaign...
2026-06-24 04:57:34,211 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 04:57:34,269 - INFO - Dropping table dUTMContent...
2026-06-24 04:57:34,273 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 04:57:34,317 - INFO - Dropping table dUTMTerm...
2026-06-24 04:57:34,323 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 04:57:34,372 - INFO - Dropping table dUnidades...
2026-06-24 04:57:34,375 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 04:57:34,394 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 04:57:34,397 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 04:57:34,402 - INFO - Dropping table dVagas...
2026-06-24 04:57:34,412 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 04:57:34,419 - INFO - Dropping table fAcessos...
2026-06-24 04:57:34,427 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 04:57:34,682 - INFO - Dropping table fOportunidades...
2026-06-24 04:57:34,691 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 04:57:48,916 - INFO - Dropping table fAcoesFunil...
2026-06-24 04:57:48,919 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 04:58:10,033 - INFO - Dropping table fAtividades...
2026-06-24 04:58:10,036 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 04:59:21,845 - INFO - Dropping table fPropostas...
2026-06-24 04:59:21,847 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 04:59:22,369 - INFO - Dropping table fVendas...
2026-06-24 04:59:22,373 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 04:59:22,890 - INFO - Batch 1 completed.
2026-06-24 04:59:22,891 - INFO - All tables refreshed.
2026-06-24 04:59:22,891 - INFO - Synchronization process completed successfully in 133.8874237537384 seconds.
2026-06-24 05:57:09,747 - INFO - Creating tables by calling stored procedure...
2026-06-24 05:57:10,074 - INFO - Tables created successfully via stored procedure.
2026-06-24 05:57:10,130 - INFO - Truncating tables...
2026-06-24 05:57:10,130 - INFO - Truncating table bi_acessos...
2026-06-24 05:57:10,143 - INFO - Truncating table bi_acoes_funil...
2026-06-24 05:57:10,144 - INFO - Truncating table bi_atividades...
2026-06-24 05:57:10,145 - INFO - Truncating table bi_oportunidades...
2026-06-24 05:57:10,149 - INFO - Truncating table bi_propostas...
2026-06-24 05:57:10,151 - INFO - Truncating table bi_vendas...
2026-06-24 05:57:10,155 - INFO - Truncating table bi_utms...
2026-06-24 05:57:10,163 - INFO - Truncation completed.
2026-06-24 05:57:10,164 - INFO - Fetching data from source database...
2026-06-24 05:57:37,758 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 05:57:37,759 - INFO - Creating star schema...
2026-06-24 05:57:37,910 - INFO - Star schema created successfully.
2026-06-24 05:57:37,911 - INFO - Refreshing tables (batch mode)...
2026-06-24 05:57:37,911 - INFO - Dropping table dCanais...
2026-06-24 05:57:37,931 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 05:57:37,967 - INFO - Dropping table dCategorias...
2026-06-24 05:57:37,971 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 05:57:37,992 - INFO - Dropping table dConsultores...
2026-06-24 05:57:37,996 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 05:57:38,033 - INFO - Dropping table dEmpreendimentos...
2026-06-24 05:57:38,040 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 05:57:38,067 - INFO - Dropping table dEstadosCivis...
2026-06-24 05:57:38,070 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 05:57:38,087 - INFO - Dropping table dEtapasFunil...
2026-06-24 05:57:38,091 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 05:57:38,135 - INFO - Dropping table dFaixasIdade...
2026-06-24 05:57:38,141 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 05:57:38,172 - INFO - Dropping table dFechamentoDias...
2026-06-24 05:57:38,177 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 05:57:38,203 - INFO - Dropping table dInteresses...
2026-06-24 05:57:38,207 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 05:57:38,253 - INFO - Dropping table dMidias...
2026-06-24 05:57:38,258 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 05:57:38,280 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 05:57:38,284 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 05:57:38,319 - INFO - Dropping table dProfissoes...
2026-06-24 05:57:38,323 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 05:57:38,349 - INFO - Dropping table dQuartos...
2026-06-24 05:57:38,354 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 05:57:38,358 - INFO - Dropping table dRegioes...
2026-06-24 05:57:38,365 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 05:57:38,388 - INFO - Dropping table dRendas...
2026-06-24 05:57:38,393 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 05:57:38,418 - INFO - Dropping table dSexos...
2026-06-24 05:57:38,422 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 05:57:38,470 - INFO - Dropping table dStatus...
2026-06-24 05:57:38,473 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 05:57:38,490 - INFO - Dropping table dStatusAtividade...
2026-06-24 05:57:38,493 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 05:57:38,554 - INFO - Dropping table dStatusProposta...
2026-06-24 05:57:38,558 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 05:57:38,565 - INFO - Dropping table dSuites...
2026-06-24 05:57:38,570 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 05:57:38,575 - INFO - Dropping table dTemperaturas...
2026-06-24 05:57:38,578 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 05:57:38,596 - INFO - Dropping table dTipos...
2026-06-24 05:57:38,599 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 05:57:38,631 - INFO - Dropping table dTiposAtividade...
2026-06-24 05:57:38,642 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 05:57:38,675 - INFO - Dropping table dUTMSource...
2026-06-24 05:57:38,681 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 05:57:38,743 - INFO - Dropping table dUTMMedium...
2026-06-24 05:57:38,747 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 05:57:38,789 - INFO - Dropping table dUTMCampaign...
2026-06-24 05:57:38,792 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 05:57:38,866 - INFO - Dropping table dUTMContent...
2026-06-24 05:57:38,872 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 05:57:38,949 - INFO - Dropping table dUTMTerm...
2026-06-24 05:57:38,956 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 05:57:39,009 - INFO - Dropping table dUnidades...
2026-06-24 05:57:39,013 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 05:57:39,040 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 05:57:39,048 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 05:57:39,054 - INFO - Dropping table dVagas...
2026-06-24 05:57:39,057 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 05:57:39,062 - INFO - Dropping table fAcessos...
2026-06-24 05:57:39,065 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 05:57:39,381 - INFO - Dropping table fOportunidades...
2026-06-24 05:57:39,386 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 05:57:56,645 - INFO - Dropping table fAcoesFunil...
2026-06-24 05:57:56,659 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 05:58:18,678 - INFO - Dropping table fAtividades...
2026-06-24 05:58:18,682 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 05:59:40,260 - INFO - Dropping table fPropostas...
2026-06-24 05:59:40,264 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 05:59:40,665 - INFO - Dropping table fVendas...
2026-06-24 05:59:40,669 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 05:59:41,152 - INFO - Batch 1 completed.
2026-06-24 05:59:41,152 - INFO - All tables refreshed.
2026-06-24 05:59:41,152 - INFO - Synchronization process completed successfully in 151.40551948547363 seconds.
2026-06-24 06:57:10,222 - INFO - Creating tables by calling stored procedure...
2026-06-24 06:57:10,516 - INFO - Tables created successfully via stored procedure.
2026-06-24 06:57:10,525 - INFO - Truncating tables...
2026-06-24 06:57:10,525 - INFO - Truncating table bi_acessos...
2026-06-24 06:57:10,526 - INFO - Truncating table bi_acoes_funil...
2026-06-24 06:57:10,527 - INFO - Truncating table bi_atividades...
2026-06-24 06:57:10,528 - INFO - Truncating table bi_oportunidades...
2026-06-24 06:57:10,529 - INFO - Truncating table bi_propostas...
2026-06-24 06:57:10,531 - INFO - Truncating table bi_vendas...
2026-06-24 06:57:10,535 - INFO - Truncating table bi_utms...
2026-06-24 06:57:10,541 - INFO - Truncation completed.
2026-06-24 06:57:10,542 - INFO - Fetching data from source database...
2026-06-24 06:57:37,188 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 06:57:37,189 - INFO - Creating star schema...
2026-06-24 06:57:37,353 - INFO - Star schema created successfully.
2026-06-24 06:57:37,353 - INFO - Refreshing tables (batch mode)...
2026-06-24 06:57:37,354 - INFO - Dropping table dCanais...
2026-06-24 06:57:37,359 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 06:57:37,372 - INFO - Dropping table dCategorias...
2026-06-24 06:57:37,375 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 06:57:37,393 - INFO - Dropping table dConsultores...
2026-06-24 06:57:37,396 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 06:57:37,423 - INFO - Dropping table dEmpreendimentos...
2026-06-24 06:57:37,427 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 06:57:37,453 - INFO - Dropping table dEstadosCivis...
2026-06-24 06:57:37,458 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 06:57:37,472 - INFO - Dropping table dEtapasFunil...
2026-06-24 06:57:37,480 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 06:57:37,515 - INFO - Dropping table dFaixasIdade...
2026-06-24 06:57:37,521 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 06:57:37,552 - INFO - Dropping table dFechamentoDias...
2026-06-24 06:57:37,555 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 06:57:37,575 - INFO - Dropping table dInteresses...
2026-06-24 06:57:37,579 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 06:57:37,596 - INFO - Dropping table dMidias...
2026-06-24 06:57:37,600 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 06:57:37,658 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 06:57:37,660 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 06:57:37,693 - INFO - Dropping table dProfissoes...
2026-06-24 06:57:37,695 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 06:57:37,719 - INFO - Dropping table dQuartos...
2026-06-24 06:57:37,730 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 06:57:37,743 - INFO - Dropping table dRegioes...
2026-06-24 06:57:37,751 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 06:57:37,778 - INFO - Dropping table dRendas...
2026-06-24 06:57:37,781 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 06:57:37,795 - INFO - Dropping table dSexos...
2026-06-24 06:57:37,798 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 06:57:37,825 - INFO - Dropping table dStatus...
2026-06-24 06:57:37,833 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 06:57:37,857 - INFO - Dropping table dStatusAtividade...
2026-06-24 06:57:37,860 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 06:57:37,903 - INFO - Dropping table dStatusProposta...
2026-06-24 06:57:37,915 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 06:57:37,928 - INFO - Dropping table dSuites...
2026-06-24 06:57:37,942 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 06:57:37,950 - INFO - Dropping table dTemperaturas...
2026-06-24 06:57:37,960 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 06:57:37,973 - INFO - Dropping table dTipos...
2026-06-24 06:57:37,975 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 06:57:37,999 - INFO - Dropping table dTiposAtividade...
2026-06-24 06:57:38,019 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 06:57:38,072 - INFO - Dropping table dUTMSource...
2026-06-24 06:57:38,077 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 06:57:38,148 - INFO - Dropping table dUTMMedium...
2026-06-24 06:57:38,160 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 06:57:38,199 - INFO - Dropping table dUTMCampaign...
2026-06-24 06:57:38,203 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 06:57:38,280 - INFO - Dropping table dUTMContent...
2026-06-24 06:57:38,284 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 06:57:38,372 - INFO - Dropping table dUTMTerm...
2026-06-24 06:57:38,375 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 06:57:38,447 - INFO - Dropping table dUnidades...
2026-06-24 06:57:38,463 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 06:57:38,491 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 06:57:38,494 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 06:57:38,499 - INFO - Dropping table dVagas...
2026-06-24 06:57:38,503 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 06:57:38,518 - INFO - Dropping table fAcessos...
2026-06-24 06:57:38,532 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 06:57:38,897 - INFO - Dropping table fOportunidades...
2026-06-24 06:57:38,900 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 06:57:55,874 - INFO - Dropping table fAcoesFunil...
2026-06-24 06:57:55,885 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 06:58:18,130 - INFO - Dropping table fAtividades...
2026-06-24 06:58:18,134 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 06:59:39,711 - INFO - Dropping table fPropostas...
2026-06-24 06:59:39,726 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 06:59:40,407 - INFO - Dropping table fVendas...
2026-06-24 06:59:40,423 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 06:59:41,021 - INFO - Batch 1 completed.
2026-06-24 06:59:41,021 - INFO - All tables refreshed.
2026-06-24 06:59:41,021 - INFO - Synchronization process completed successfully in 150.79855370521545 seconds.
2026-06-24 07:57:09,912 - INFO - Creating tables by calling stored procedure...
2026-06-24 07:57:10,137 - INFO - Tables created successfully via stored procedure.
2026-06-24 07:57:10,144 - INFO - Truncating tables...
2026-06-24 07:57:10,149 - INFO - Truncating table bi_acessos...
2026-06-24 07:57:10,205 - INFO - Truncating table bi_acoes_funil...
2026-06-24 07:57:10,240 - INFO - Truncating table bi_atividades...
2026-06-24 07:57:10,303 - INFO - Truncating table bi_oportunidades...
2026-06-24 07:57:10,306 - INFO - Truncating table bi_propostas...
2026-06-24 07:57:10,307 - INFO - Truncating table bi_vendas...
2026-06-24 07:57:10,309 - INFO - Truncating table bi_utms...
2026-06-24 07:57:10,310 - INFO - Truncation completed.
2026-06-24 07:57:10,310 - INFO - Fetching data from source database...
2026-06-24 07:57:36,497 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 07:57:36,499 - INFO - Creating star schema...
2026-06-24 07:57:36,668 - INFO - Star schema created successfully.
2026-06-24 07:57:36,668 - INFO - Refreshing tables (batch mode)...
2026-06-24 07:57:36,669 - INFO - Dropping table dCanais...
2026-06-24 07:57:36,673 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 07:57:36,703 - INFO - Dropping table dCategorias...
2026-06-24 07:57:36,710 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 07:57:36,735 - INFO - Dropping table dConsultores...
2026-06-24 07:57:36,742 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 07:57:36,765 - INFO - Dropping table dEmpreendimentos...
2026-06-24 07:57:36,772 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 07:57:36,793 - INFO - Dropping table dEstadosCivis...
2026-06-24 07:57:36,797 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 07:57:36,809 - INFO - Dropping table dEtapasFunil...
2026-06-24 07:57:36,814 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 07:57:36,850 - INFO - Dropping table dFaixasIdade...
2026-06-24 07:57:36,853 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 07:57:36,877 - INFO - Dropping table dFechamentoDias...
2026-06-24 07:57:36,880 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 07:57:36,905 - INFO - Dropping table dInteresses...
2026-06-24 07:57:36,908 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 07:57:36,929 - INFO - Dropping table dMidias...
2026-06-24 07:57:36,932 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 07:57:36,953 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 07:57:36,957 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 07:57:36,976 - INFO - Dropping table dProfissoes...
2026-06-24 07:57:36,980 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 07:57:37,000 - INFO - Dropping table dQuartos...
2026-06-24 07:57:37,003 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 07:57:37,007 - INFO - Dropping table dRegioes...
2026-06-24 07:57:37,010 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 07:57:37,040 - INFO - Dropping table dRendas...
2026-06-24 07:57:37,043 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 07:57:37,061 - INFO - Dropping table dSexos...
2026-06-24 07:57:37,065 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 07:57:37,091 - INFO - Dropping table dStatus...
2026-06-24 07:57:37,098 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 07:57:37,117 - INFO - Dropping table dStatusAtividade...
2026-06-24 07:57:37,129 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 07:57:37,172 - INFO - Dropping table dStatusProposta...
2026-06-24 07:57:37,177 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 07:57:37,184 - INFO - Dropping table dSuites...
2026-06-24 07:57:37,188 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 07:57:37,196 - INFO - Dropping table dTemperaturas...
2026-06-24 07:57:37,204 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 07:57:37,229 - INFO - Dropping table dTipos...
2026-06-24 07:57:37,241 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 07:57:37,271 - INFO - Dropping table dTiposAtividade...
2026-06-24 07:57:37,279 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 07:57:37,323 - INFO - Dropping table dUTMSource...
2026-06-24 07:57:37,328 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 07:57:37,389 - INFO - Dropping table dUTMMedium...
2026-06-24 07:57:37,395 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 07:57:37,457 - INFO - Dropping table dUTMCampaign...
2026-06-24 07:57:37,462 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 07:57:37,524 - INFO - Dropping table dUTMContent...
2026-06-24 07:57:37,529 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 07:57:37,588 - INFO - Dropping table dUTMTerm...
2026-06-24 07:57:37,592 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 07:57:37,645 - INFO - Dropping table dUnidades...
2026-06-24 07:57:37,659 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 07:57:37,690 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 07:57:37,698 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 07:57:37,709 - INFO - Dropping table dVagas...
2026-06-24 07:57:37,712 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 07:57:37,717 - INFO - Dropping table fAcessos...
2026-06-24 07:57:37,725 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 07:57:37,982 - INFO - Dropping table fOportunidades...
2026-06-24 07:57:38,001 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 07:57:53,732 - INFO - Dropping table fAcoesFunil...
2026-06-24 07:57:53,738 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 07:58:15,029 - INFO - Dropping table fAtividades...
2026-06-24 07:58:15,033 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 07:59:28,624 - INFO - Dropping table fPropostas...
2026-06-24 07:59:28,629 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 07:59:29,140 - INFO - Dropping table fVendas...
2026-06-24 07:59:29,144 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 07:59:29,619 - INFO - Batch 1 completed.
2026-06-24 07:59:29,619 - INFO - All tables refreshed.
2026-06-24 07:59:29,619 - INFO - Synchronization process completed successfully in 139.70643258094788 seconds.
2026-06-24 08:57:11,832 - INFO - Creating tables by calling stored procedure...
2026-06-24 08:57:12,225 - INFO - Tables created successfully via stored procedure.
2026-06-24 08:57:12,230 - INFO - Truncating tables...
2026-06-24 08:57:12,231 - INFO - Truncating table bi_acessos...
2026-06-24 08:57:12,233 - INFO - Truncating table bi_acoes_funil...
2026-06-24 08:57:12,234 - INFO - Truncating table bi_atividades...
2026-06-24 08:57:12,236 - INFO - Truncating table bi_oportunidades...
2026-06-24 08:57:12,303 - INFO - Truncating table bi_propostas...
2026-06-24 08:57:12,304 - INFO - Truncating table bi_vendas...
2026-06-24 08:57:12,308 - INFO - Truncating table bi_utms...
2026-06-24 08:57:12,309 - INFO - Truncation completed.
2026-06-24 08:57:12,310 - INFO - Fetching data from source database...
2026-06-24 08:57:36,828 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 08:57:36,829 - INFO - Creating star schema...
2026-06-24 08:57:36,964 - INFO - Star schema created successfully.
2026-06-24 08:57:36,964 - INFO - Refreshing tables (batch mode)...
2026-06-24 08:57:36,964 - INFO - Dropping table dCanais...
2026-06-24 08:57:36,969 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 08:57:36,985 - INFO - Dropping table dCategorias...
2026-06-24 08:57:36,991 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 08:57:37,021 - INFO - Dropping table dConsultores...
2026-06-24 08:57:37,026 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 08:57:37,049 - INFO - Dropping table dEmpreendimentos...
2026-06-24 08:57:37,054 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 08:57:37,079 - INFO - Dropping table dEstadosCivis...
2026-06-24 08:57:37,082 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 08:57:37,107 - INFO - Dropping table dEtapasFunil...
2026-06-24 08:57:37,111 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 08:57:37,152 - INFO - Dropping table dFaixasIdade...
2026-06-24 08:57:37,155 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 08:57:37,179 - INFO - Dropping table dFechamentoDias...
2026-06-24 08:57:37,186 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 08:57:37,209 - INFO - Dropping table dInteresses...
2026-06-24 08:57:37,213 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 08:57:37,239 - INFO - Dropping table dMidias...
2026-06-24 08:57:37,253 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 08:57:37,269 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 08:57:37,272 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 08:57:37,305 - INFO - Dropping table dProfissoes...
2026-06-24 08:57:37,309 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 08:57:37,334 - INFO - Dropping table dQuartos...
2026-06-24 08:57:37,337 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 08:57:37,341 - INFO - Dropping table dRegioes...
2026-06-24 08:57:37,345 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 08:57:37,376 - INFO - Dropping table dRendas...
2026-06-24 08:57:37,379 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 08:57:37,399 - INFO - Dropping table dSexos...
2026-06-24 08:57:37,407 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 08:57:37,430 - INFO - Dropping table dStatus...
2026-06-24 08:57:37,434 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 08:57:37,446 - INFO - Dropping table dStatusAtividade...
2026-06-24 08:57:37,450 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 08:57:37,532 - INFO - Dropping table dStatusProposta...
2026-06-24 08:57:37,538 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 08:57:37,543 - INFO - Dropping table dSuites...
2026-06-24 08:57:37,548 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 08:57:37,552 - INFO - Dropping table dTemperaturas...
2026-06-24 08:57:37,555 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 08:57:37,573 - INFO - Dropping table dTipos...
2026-06-24 08:57:37,577 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 08:57:37,607 - INFO - Dropping table dTiposAtividade...
2026-06-24 08:57:37,612 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 08:57:37,654 - INFO - Dropping table dUTMSource...
2026-06-24 08:57:37,658 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 08:57:37,716 - INFO - Dropping table dUTMMedium...
2026-06-24 08:57:37,721 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 08:57:37,803 - INFO - Dropping table dUTMCampaign...
2026-06-24 08:57:37,807 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 08:57:37,865 - INFO - Dropping table dUTMContent...
2026-06-24 08:57:37,869 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 08:57:37,928 - INFO - Dropping table dUTMTerm...
2026-06-24 08:57:37,932 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 08:57:37,996 - INFO - Dropping table dUnidades...
2026-06-24 08:57:38,001 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 08:57:38,029 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 08:57:38,034 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 08:57:38,046 - INFO - Dropping table dVagas...
2026-06-24 08:57:38,050 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 08:57:38,055 - INFO - Dropping table fAcessos...
2026-06-24 08:57:38,063 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 08:57:38,360 - INFO - Dropping table fOportunidades...
2026-06-24 08:57:38,367 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 08:57:53,497 - INFO - Dropping table fAcoesFunil...
2026-06-24 08:57:53,501 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 08:58:15,306 - INFO - Dropping table fAtividades...
2026-06-24 08:58:15,318 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 08:59:30,527 - INFO - Dropping table fPropostas...
2026-06-24 08:59:30,539 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 08:59:31,105 - INFO - Dropping table fVendas...
2026-06-24 08:59:31,109 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 08:59:31,648 - INFO - Batch 1 completed.
2026-06-24 08:59:31,648 - INFO - All tables refreshed.
2026-06-24 08:59:31,648 - INFO - Synchronization process completed successfully in 139.81547498703003 seconds.
2026-06-24 09:57:09,712 - INFO - Creating tables by calling stored procedure...
2026-06-24 09:57:10,019 - INFO - Tables created successfully via stored procedure.
2026-06-24 09:57:10,021 - INFO - Truncating tables...
2026-06-24 09:57:10,021 - INFO - Truncating table bi_acessos...
2026-06-24 09:57:10,022 - INFO - Truncating table bi_acoes_funil...
2026-06-24 09:57:10,022 - INFO - Truncating table bi_atividades...
2026-06-24 09:57:10,023 - INFO - Truncating table bi_oportunidades...
2026-06-24 09:57:10,024 - INFO - Truncating table bi_propostas...
2026-06-24 09:57:10,026 - INFO - Truncating table bi_vendas...
2026-06-24 09:57:10,026 - INFO - Truncating table bi_utms...
2026-06-24 09:57:10,028 - INFO - Truncation completed.
2026-06-24 09:57:10,028 - INFO - Fetching data from source database...
2026-06-24 09:57:31,912 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 09:57:31,913 - INFO - Creating star schema...
2026-06-24 09:57:32,017 - INFO - Star schema created successfully.
2026-06-24 09:57:32,018 - INFO - Refreshing tables (batch mode)...
2026-06-24 09:57:32,018 - INFO - Dropping table dCanais...
2026-06-24 09:57:32,021 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 09:57:32,034 - INFO - Dropping table dCategorias...
2026-06-24 09:57:32,036 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 09:57:32,049 - INFO - Dropping table dConsultores...
2026-06-24 09:57:32,051 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 09:57:32,064 - INFO - Dropping table dEmpreendimentos...
2026-06-24 09:57:32,067 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 09:57:32,080 - INFO - Dropping table dEstadosCivis...
2026-06-24 09:57:32,084 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 09:57:32,095 - INFO - Dropping table dEtapasFunil...
2026-06-24 09:57:32,099 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 09:57:32,125 - INFO - Dropping table dFaixasIdade...
2026-06-24 09:57:32,129 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 09:57:32,144 - INFO - Dropping table dFechamentoDias...
2026-06-24 09:57:32,147 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 09:57:32,169 - INFO - Dropping table dInteresses...
2026-06-24 09:57:32,172 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 09:57:32,187 - INFO - Dropping table dMidias...
2026-06-24 09:57:32,191 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 09:57:32,210 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 09:57:32,214 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 09:57:32,237 - INFO - Dropping table dProfissoes...
2026-06-24 09:57:32,241 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 09:57:32,257 - INFO - Dropping table dQuartos...
2026-06-24 09:57:32,261 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 09:57:32,265 - INFO - Dropping table dRegioes...
2026-06-24 09:57:32,268 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 09:57:32,287 - INFO - Dropping table dRendas...
2026-06-24 09:57:32,290 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 09:57:32,309 - INFO - Dropping table dSexos...
2026-06-24 09:57:32,312 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 09:57:32,326 - INFO - Dropping table dStatus...
2026-06-24 09:57:32,329 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 09:57:32,345 - INFO - Dropping table dStatusAtividade...
2026-06-24 09:57:32,349 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 09:57:32,379 - INFO - Dropping table dStatusProposta...
2026-06-24 09:57:32,383 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 09:57:32,393 - INFO - Dropping table dSuites...
2026-06-24 09:57:32,396 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 09:57:32,400 - INFO - Dropping table dTemperaturas...
2026-06-24 09:57:32,404 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 09:57:32,422 - INFO - Dropping table dTipos...
2026-06-24 09:57:32,425 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 09:57:32,439 - INFO - Dropping table dTiposAtividade...
2026-06-24 09:57:32,444 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 09:57:32,482 - INFO - Dropping table dUTMSource...
2026-06-24 09:57:32,486 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 09:57:32,527 - INFO - Dropping table dUTMMedium...
2026-06-24 09:57:32,531 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 09:57:32,581 - INFO - Dropping table dUTMCampaign...
2026-06-24 09:57:32,584 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 09:57:32,632 - INFO - Dropping table dUTMContent...
2026-06-24 09:57:32,635 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 09:57:32,675 - INFO - Dropping table dUTMTerm...
2026-06-24 09:57:32,681 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 09:57:32,724 - INFO - Dropping table dUnidades...
2026-06-24 09:57:32,726 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 09:57:32,742 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 09:57:32,745 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 09:57:32,750 - INFO - Dropping table dVagas...
2026-06-24 09:57:32,753 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 09:57:32,759 - INFO - Dropping table fAcessos...
2026-06-24 09:57:32,763 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 09:57:32,959 - INFO - Dropping table fOportunidades...
2026-06-24 09:57:32,967 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 09:57:44,966 - INFO - Dropping table fAcoesFunil...
2026-06-24 09:57:44,970 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 09:58:04,067 - INFO - Dropping table fAtividades...
2026-06-24 09:58:04,071 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 09:59:20,067 - INFO - Dropping table fPropostas...
2026-06-24 09:59:28,489 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 09:59:38,345 - INFO - Dropping table fVendas...
2026-06-24 09:59:44,546 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 09:59:45,091 - INFO - Batch 1 completed.
2026-06-24 09:59:45,091 - INFO - All tables refreshed.
2026-06-24 09:59:45,096 - INFO - Synchronization process completed successfully in 155.379385471344 seconds.
2026-06-24 10:57:08,304 - INFO - Creating tables by calling stored procedure...
2026-06-24 10:57:08,431 - INFO - Tables created successfully via stored procedure.
2026-06-24 10:57:08,433 - INFO - Truncating tables...
2026-06-24 10:57:08,503 - INFO - Truncating table bi_acessos...
2026-06-24 10:57:08,504 - INFO - Truncating table bi_acoes_funil...
2026-06-24 10:57:08,504 - INFO - Truncating table bi_atividades...
2026-06-24 10:57:08,507 - INFO - Truncating table bi_oportunidades...
2026-06-24 10:57:08,508 - INFO - Truncating table bi_propostas...
2026-06-24 10:57:08,508 - INFO - Truncating table bi_vendas...
2026-06-24 10:57:08,509 - INFO - Truncating table bi_utms...
2026-06-24 10:57:08,509 - INFO - Truncation completed.
2026-06-24 10:57:08,509 - INFO - Fetching data from source database...
2026-06-24 10:57:32,642 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 10:57:32,643 - INFO - Creating star schema...
2026-06-24 10:57:32,751 - INFO - Star schema created successfully.
2026-06-24 10:57:32,751 - INFO - Refreshing tables (batch mode)...
2026-06-24 10:57:32,751 - INFO - Dropping table dCanais...
2026-06-24 10:57:32,754 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 10:57:32,766 - INFO - Dropping table dCategorias...
2026-06-24 10:57:32,769 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 10:57:32,781 - INFO - Dropping table dConsultores...
2026-06-24 10:57:32,785 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 10:57:32,800 - INFO - Dropping table dEmpreendimentos...
2026-06-24 10:57:32,804 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 10:57:32,819 - INFO - Dropping table dEstadosCivis...
2026-06-24 10:57:32,824 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 10:57:32,836 - INFO - Dropping table dEtapasFunil...
2026-06-24 10:57:32,843 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 10:57:32,864 - INFO - Dropping table dFaixasIdade...
2026-06-24 10:57:32,869 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 10:57:32,888 - INFO - Dropping table dFechamentoDias...
2026-06-24 10:57:32,891 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 10:57:32,906 - INFO - Dropping table dInteresses...
2026-06-24 10:57:32,911 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 10:57:32,934 - INFO - Dropping table dMidias...
2026-06-24 10:57:32,937 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 10:57:32,956 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 10:57:32,963 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 10:57:32,989 - INFO - Dropping table dProfissoes...
2026-06-24 10:57:32,994 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 10:57:33,008 - INFO - Dropping table dQuartos...
2026-06-24 10:57:33,012 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 10:57:33,016 - INFO - Dropping table dRegioes...
2026-06-24 10:57:33,019 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 10:57:33,055 - INFO - Dropping table dRendas...
2026-06-24 10:57:33,058 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 10:57:33,079 - INFO - Dropping table dSexos...
2026-06-24 10:57:33,084 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 10:57:33,097 - INFO - Dropping table dStatus...
2026-06-24 10:57:33,101 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 10:57:33,117 - INFO - Dropping table dStatusAtividade...
2026-06-24 10:57:33,122 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 10:57:33,158 - INFO - Dropping table dStatusProposta...
2026-06-24 10:57:33,162 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 10:57:33,170 - INFO - Dropping table dSuites...
2026-06-24 10:57:33,174 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 10:57:33,178 - INFO - Dropping table dTemperaturas...
2026-06-24 10:57:33,181 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 10:57:33,198 - INFO - Dropping table dTipos...
2026-06-24 10:57:33,203 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 10:57:33,236 - INFO - Dropping table dTiposAtividade...
2026-06-24 10:57:33,247 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 10:57:33,291 - INFO - Dropping table dUTMSource...
2026-06-24 10:57:33,295 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 10:57:33,355 - INFO - Dropping table dUTMMedium...
2026-06-24 10:57:33,359 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 10:57:33,416 - INFO - Dropping table dUTMCampaign...
2026-06-24 10:57:33,427 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 10:57:33,477 - INFO - Dropping table dUTMContent...
2026-06-24 10:57:33,481 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 10:57:33,545 - INFO - Dropping table dUTMTerm...
2026-06-24 10:57:33,548 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 10:57:33,614 - INFO - Dropping table dUnidades...
2026-06-24 10:57:33,617 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 10:57:33,645 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 10:57:33,648 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 10:57:33,654 - INFO - Dropping table dVagas...
2026-06-24 10:57:33,663 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 10:57:33,667 - INFO - Dropping table fAcessos...
2026-06-24 10:57:33,671 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 10:57:33,872 - INFO - Dropping table fOportunidades...
2026-06-24 10:57:33,879 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 10:57:49,259 - INFO - Dropping table fAcoesFunil...
2026-06-24 10:57:49,263 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 10:58:10,806 - INFO - Dropping table fAtividades...
2026-06-24 10:58:10,811 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 10:59:24,437 - INFO - Dropping table fPropostas...
2026-06-24 10:59:24,506 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 10:59:24,919 - INFO - Dropping table fVendas...
2026-06-24 10:59:24,922 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 10:59:25,295 - INFO - Batch 1 completed.
2026-06-24 10:59:25,295 - INFO - All tables refreshed.
2026-06-24 10:59:25,303 - INFO - Synchronization process completed successfully in 136.99120950698853 seconds.
2026-06-24 11:57:09,236 - INFO - Creating tables by calling stored procedure...
2026-06-24 11:57:09,619 - INFO - Tables created successfully via stored procedure.
2026-06-24 11:57:09,621 - INFO - Truncating tables...
2026-06-24 11:57:09,622 - INFO - Truncating table bi_acessos...
2026-06-24 11:57:09,624 - INFO - Truncating table bi_acoes_funil...
2026-06-24 11:57:09,625 - INFO - Truncating table bi_atividades...
2026-06-24 11:57:09,630 - INFO - Truncating table bi_oportunidades...
2026-06-24 11:57:09,631 - INFO - Truncating table bi_propostas...
2026-06-24 11:57:09,632 - INFO - Truncating table bi_vendas...
2026-06-24 11:57:09,633 - INFO - Truncating table bi_utms...
2026-06-24 11:57:09,634 - INFO - Truncation completed.
2026-06-24 11:57:09,634 - INFO - Fetching data from source database...
2026-06-24 11:57:31,539 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 11:57:31,540 - INFO - Creating star schema...
2026-06-24 11:57:31,661 - INFO - Star schema created successfully.
2026-06-24 11:57:31,661 - INFO - Refreshing tables (batch mode)...
2026-06-24 11:57:31,661 - INFO - Dropping table dCanais...
2026-06-24 11:57:31,664 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 11:57:31,676 - INFO - Dropping table dCategorias...
2026-06-24 11:57:31,679 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 11:57:31,690 - INFO - Dropping table dConsultores...
2026-06-24 11:57:31,692 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 11:57:31,706 - INFO - Dropping table dEmpreendimentos...
2026-06-24 11:57:31,711 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 11:57:31,728 - INFO - Dropping table dEstadosCivis...
2026-06-24 11:57:31,732 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 11:57:31,744 - INFO - Dropping table dEtapasFunil...
2026-06-24 11:57:31,750 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 11:57:31,777 - INFO - Dropping table dFaixasIdade...
2026-06-24 11:57:31,780 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 11:57:31,797 - INFO - Dropping table dFechamentoDias...
2026-06-24 11:57:31,799 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 11:57:31,814 - INFO - Dropping table dInteresses...
2026-06-24 11:57:31,816 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 11:57:31,829 - INFO - Dropping table dMidias...
2026-06-24 11:57:31,832 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 11:57:31,844 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 11:57:31,848 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 11:57:31,867 - INFO - Dropping table dProfissoes...
2026-06-24 11:57:31,870 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 11:57:31,885 - INFO - Dropping table dQuartos...
2026-06-24 11:57:31,888 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 11:57:31,893 - INFO - Dropping table dRegioes...
2026-06-24 11:57:31,895 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 11:57:31,919 - INFO - Dropping table dRendas...
2026-06-24 11:57:31,922 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 11:57:31,937 - INFO - Dropping table dSexos...
2026-06-24 11:57:31,940 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 11:57:31,962 - INFO - Dropping table dStatus...
2026-06-24 11:57:31,965 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 11:57:31,983 - INFO - Dropping table dStatusAtividade...
2026-06-24 11:57:31,988 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 11:57:32,021 - INFO - Dropping table dStatusProposta...
2026-06-24 11:57:32,024 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 11:57:32,027 - INFO - Dropping table dSuites...
2026-06-24 11:57:32,030 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 11:57:32,033 - INFO - Dropping table dTemperaturas...
2026-06-24 11:57:32,035 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 11:57:32,046 - INFO - Dropping table dTipos...
2026-06-24 11:57:32,048 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 11:57:32,064 - INFO - Dropping table dTiposAtividade...
2026-06-24 11:57:32,068 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 11:57:32,093 - INFO - Dropping table dUTMSource...
2026-06-24 11:57:32,097 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 11:57:32,133 - INFO - Dropping table dUTMMedium...
2026-06-24 11:57:32,137 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 11:57:32,177 - INFO - Dropping table dUTMCampaign...
2026-06-24 11:57:32,179 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 11:57:32,214 - INFO - Dropping table dUTMContent...
2026-06-24 11:57:32,218 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 11:57:32,256 - INFO - Dropping table dUTMTerm...
2026-06-24 11:57:32,259 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 11:57:32,309 - INFO - Dropping table dUnidades...
2026-06-24 11:57:32,312 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 11:57:32,330 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 11:57:32,332 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 11:57:32,337 - INFO - Dropping table dVagas...
2026-06-24 11:57:32,339 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 11:57:32,342 - INFO - Dropping table fAcessos...
2026-06-24 11:57:32,345 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 11:57:32,612 - INFO - Dropping table fOportunidades...
2026-06-24 11:57:32,615 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 11:57:45,323 - INFO - Dropping table fAcoesFunil...
2026-06-24 11:57:45,327 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 11:58:04,505 - INFO - Dropping table fAtividades...
2026-06-24 11:58:04,510 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 11:59:11,831 - INFO - Dropping table fPropostas...
2026-06-24 11:59:11,834 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 11:59:12,343 - INFO - Dropping table fVendas...
2026-06-24 11:59:12,346 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 11:59:12,789 - INFO - Batch 1 completed.
2026-06-24 11:59:12,789 - INFO - All tables refreshed.
2026-06-24 11:59:12,789 - INFO - Synchronization process completed successfully in 123.55278754234314 seconds.
2026-06-24 12:57:07,915 - INFO - Creating tables by calling stored procedure...
2026-06-24 12:57:08,140 - INFO - Tables created successfully via stored procedure.
2026-06-24 12:57:08,205 - INFO - Truncating tables...
2026-06-24 12:57:08,205 - INFO - Truncating table bi_acessos...
2026-06-24 12:57:08,206 - INFO - Truncating table bi_acoes_funil...
2026-06-24 12:57:08,207 - INFO - Truncating table bi_atividades...
2026-06-24 12:57:08,207 - INFO - Truncating table bi_oportunidades...
2026-06-24 12:57:08,208 - INFO - Truncating table bi_propostas...
2026-06-24 12:57:08,208 - INFO - Truncating table bi_vendas...
2026-06-24 12:57:08,209 - INFO - Truncating table bi_utms...
2026-06-24 12:57:08,210 - INFO - Truncation completed.
2026-06-24 12:57:08,210 - INFO - Fetching data from source database...
2026-06-24 12:57:34,414 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 12:57:34,415 - INFO - Creating star schema...
2026-06-24 12:57:34,583 - INFO - Star schema created successfully.
2026-06-24 12:57:34,583 - INFO - Refreshing tables (batch mode)...
2026-06-24 12:57:34,583 - INFO - Dropping table dCanais...
2026-06-24 12:57:34,587 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 12:57:34,615 - INFO - Dropping table dCategorias...
2026-06-24 12:57:34,621 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 12:57:34,636 - INFO - Dropping table dConsultores...
2026-06-24 12:57:34,643 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 12:57:34,657 - INFO - Dropping table dEmpreendimentos...
2026-06-24 12:57:34,661 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 12:57:34,675 - INFO - Dropping table dEstadosCivis...
2026-06-24 12:57:34,678 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 12:57:34,691 - INFO - Dropping table dEtapasFunil...
2026-06-24 12:57:34,694 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 12:57:34,727 - INFO - Dropping table dFaixasIdade...
2026-06-24 12:57:34,731 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 12:57:34,749 - INFO - Dropping table dFechamentoDias...
2026-06-24 12:57:34,754 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 12:57:34,769 - INFO - Dropping table dInteresses...
2026-06-24 12:57:34,774 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 12:57:34,787 - INFO - Dropping table dMidias...
2026-06-24 12:57:34,791 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 12:57:34,804 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 12:57:34,811 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 12:57:34,850 - INFO - Dropping table dProfissoes...
2026-06-24 12:57:34,854 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 12:57:34,868 - INFO - Dropping table dQuartos...
2026-06-24 12:57:34,872 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 12:57:34,876 - INFO - Dropping table dRegioes...
2026-06-24 12:57:34,880 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 12:57:34,903 - INFO - Dropping table dRendas...
2026-06-24 12:57:34,907 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 12:57:34,929 - INFO - Dropping table dSexos...
2026-06-24 12:57:34,934 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 12:57:34,967 - INFO - Dropping table dStatus...
2026-06-24 12:57:34,971 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 12:57:34,982 - INFO - Dropping table dStatusAtividade...
2026-06-24 12:57:34,986 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 12:57:35,020 - INFO - Dropping table dStatusProposta...
2026-06-24 12:57:35,032 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 12:57:35,038 - INFO - Dropping table dSuites...
2026-06-24 12:57:35,043 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 12:57:35,047 - INFO - Dropping table dTemperaturas...
2026-06-24 12:57:35,051 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 12:57:35,080 - INFO - Dropping table dTipos...
2026-06-24 12:57:35,086 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 12:57:35,110 - INFO - Dropping table dTiposAtividade...
2026-06-24 12:57:35,114 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 12:57:35,152 - INFO - Dropping table dUTMSource...
2026-06-24 12:57:35,156 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 12:57:35,204 - INFO - Dropping table dUTMMedium...
2026-06-24 12:57:35,208 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 12:57:35,270 - INFO - Dropping table dUTMCampaign...
2026-06-24 12:57:35,273 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 12:57:35,336 - INFO - Dropping table dUTMContent...
2026-06-24 12:57:35,339 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 12:57:35,407 - INFO - Dropping table dUTMTerm...
2026-06-24 12:57:35,410 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 12:57:35,477 - INFO - Dropping table dUnidades...
2026-06-24 12:57:35,480 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 12:57:35,503 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 12:57:35,509 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 12:57:35,514 - INFO - Dropping table dVagas...
2026-06-24 12:57:35,517 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 12:57:35,521 - INFO - Dropping table fAcessos...
2026-06-24 12:57:35,525 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 12:57:35,737 - INFO - Dropping table fOportunidades...
2026-06-24 12:57:35,742 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 12:57:52,271 - INFO - Dropping table fAcoesFunil...
2026-06-24 12:57:52,274 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 12:58:14,634 - INFO - Dropping table fAtividades...
2026-06-24 12:58:14,637 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 12:59:33,705 - INFO - Dropping table fPropostas...
2026-06-24 12:59:33,709 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 12:59:34,211 - INFO - Dropping table fVendas...
2026-06-24 12:59:34,215 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 12:59:34,625 - INFO - Batch 1 completed.
2026-06-24 12:59:34,625 - INFO - All tables refreshed.
2026-06-24 12:59:34,626 - INFO - Synchronization process completed successfully in 146.71098065376282 seconds.
2026-06-24 13:57:09,734 - INFO - Creating tables by calling stored procedure...
2026-06-24 13:57:09,922 - INFO - Tables created successfully via stored procedure.
2026-06-24 13:57:09,924 - INFO - Truncating tables...
2026-06-24 13:57:09,924 - INFO - Truncating table bi_acessos...
2026-06-24 13:57:09,926 - INFO - Truncating table bi_acoes_funil...
2026-06-24 13:57:09,927 - INFO - Truncating table bi_atividades...
2026-06-24 13:57:09,928 - INFO - Truncating table bi_oportunidades...
2026-06-24 13:57:09,929 - INFO - Truncating table bi_propostas...
2026-06-24 13:57:09,929 - INFO - Truncating table bi_vendas...
2026-06-24 13:57:09,929 - INFO - Truncating table bi_utms...
2026-06-24 13:57:09,930 - INFO - Truncation completed.
2026-06-24 13:57:09,931 - INFO - Fetching data from source database...
2026-06-24 13:57:32,542 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 13:57:32,543 - INFO - Creating star schema...
2026-06-24 13:57:32,651 - INFO - Star schema created successfully.
2026-06-24 13:57:32,652 - INFO - Refreshing tables (batch mode)...
2026-06-24 13:57:32,652 - INFO - Dropping table dCanais...
2026-06-24 13:57:32,655 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 13:57:32,667 - INFO - Dropping table dCategorias...
2026-06-24 13:57:32,670 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 13:57:32,681 - INFO - Dropping table dConsultores...
2026-06-24 13:57:32,684 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 13:57:32,697 - INFO - Dropping table dEmpreendimentos...
2026-06-24 13:57:32,703 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 13:57:32,718 - INFO - Dropping table dEstadosCivis...
2026-06-24 13:57:32,721 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 13:57:32,739 - INFO - Dropping table dEtapasFunil...
2026-06-24 13:57:32,745 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 13:57:32,767 - INFO - Dropping table dFaixasIdade...
2026-06-24 13:57:32,770 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 13:57:32,784 - INFO - Dropping table dFechamentoDias...
2026-06-24 13:57:32,787 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 13:57:32,801 - INFO - Dropping table dInteresses...
2026-06-24 13:57:32,804 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 13:57:32,822 - INFO - Dropping table dMidias...
2026-06-24 13:57:32,826 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 13:57:32,841 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 13:57:32,844 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 13:57:32,877 - INFO - Dropping table dProfissoes...
2026-06-24 13:57:32,881 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 13:57:32,897 - INFO - Dropping table dQuartos...
2026-06-24 13:57:32,900 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 13:57:32,903 - INFO - Dropping table dRegioes...
2026-06-24 13:57:32,906 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 13:57:32,927 - INFO - Dropping table dRendas...
2026-06-24 13:57:32,929 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 13:57:32,942 - INFO - Dropping table dSexos...
2026-06-24 13:57:32,946 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 13:57:32,959 - INFO - Dropping table dStatus...
2026-06-24 13:57:32,965 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 13:57:32,978 - INFO - Dropping table dStatusAtividade...
2026-06-24 13:57:32,982 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 13:57:33,010 - INFO - Dropping table dStatusProposta...
2026-06-24 13:57:33,013 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 13:57:33,017 - INFO - Dropping table dSuites...
2026-06-24 13:57:33,019 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 13:57:33,023 - INFO - Dropping table dTemperaturas...
2026-06-24 13:57:33,025 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 13:57:33,038 - INFO - Dropping table dTipos...
2026-06-24 13:57:33,041 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 13:57:33,056 - INFO - Dropping table dTiposAtividade...
2026-06-24 13:57:33,062 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 13:57:33,092 - INFO - Dropping table dUTMSource...
2026-06-24 13:57:33,096 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 13:57:33,136 - INFO - Dropping table dUTMMedium...
2026-06-24 13:57:33,139 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 13:57:33,184 - INFO - Dropping table dUTMCampaign...
2026-06-24 13:57:33,187 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 13:57:33,222 - INFO - Dropping table dUTMContent...
2026-06-24 13:57:33,225 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 13:57:33,262 - INFO - Dropping table dUTMTerm...
2026-06-24 13:57:33,265 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 13:57:33,321 - INFO - Dropping table dUnidades...
2026-06-24 13:57:33,325 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 13:57:33,345 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 13:57:33,349 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 13:57:33,353 - INFO - Dropping table dVagas...
2026-06-24 13:57:33,356 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 13:57:33,360 - INFO - Dropping table fAcessos...
2026-06-24 13:57:33,364 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 13:57:33,537 - INFO - Dropping table fOportunidades...
2026-06-24 13:57:33,541 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 13:57:47,362 - INFO - Dropping table fAcoesFunil...
2026-06-24 13:57:47,385 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 13:58:06,957 - INFO - Dropping table fAtividades...
2026-06-24 13:58:06,968 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 13:59:13,764 - INFO - Dropping table fPropostas...
2026-06-24 13:59:13,767 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 13:59:14,183 - INFO - Dropping table fVendas...
2026-06-24 13:59:14,190 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 13:59:14,610 - INFO - Batch 1 completed.
2026-06-24 13:59:14,610 - INFO - All tables refreshed.
2026-06-24 13:59:14,610 - INFO - Synchronization process completed successfully in 124.87625312805176 seconds.
2026-06-24 14:57:07,534 - INFO - Creating tables by calling stored procedure...
2026-06-24 14:57:07,810 - INFO - Tables created successfully via stored procedure.
2026-06-24 14:57:07,826 - INFO - Truncating tables...
2026-06-24 14:57:07,826 - INFO - Truncating table bi_acessos...
2026-06-24 14:57:07,828 - INFO - Truncating table bi_acoes_funil...
2026-06-24 14:57:07,828 - INFO - Truncating table bi_atividades...
2026-06-24 14:57:07,829 - INFO - Truncating table bi_oportunidades...
2026-06-24 14:57:07,829 - INFO - Truncating table bi_propostas...
2026-06-24 14:57:07,830 - INFO - Truncating table bi_vendas...
2026-06-24 14:57:07,830 - INFO - Truncating table bi_utms...
2026-06-24 14:57:07,904 - INFO - Truncation completed.
2026-06-24 14:57:07,904 - INFO - Fetching data from source database...
2026-06-24 14:57:31,712 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 14:57:31,714 - INFO - Creating star schema...
2026-06-24 14:57:31,836 - INFO - Star schema created successfully.
2026-06-24 14:57:31,836 - INFO - Refreshing tables (batch mode)...
2026-06-24 14:57:31,837 - INFO - Dropping table dCanais...
2026-06-24 14:57:31,840 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 14:57:31,858 - INFO - Dropping table dCategorias...
2026-06-24 14:57:31,863 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 14:57:31,876 - INFO - Dropping table dConsultores...
2026-06-24 14:57:31,880 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 14:57:31,907 - INFO - Dropping table dEmpreendimentos...
2026-06-24 14:57:31,911 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 14:57:31,934 - INFO - Dropping table dEstadosCivis...
2026-06-24 14:57:31,940 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 14:57:31,956 - INFO - Dropping table dEtapasFunil...
2026-06-24 14:57:31,960 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 14:57:31,982 - INFO - Dropping table dFaixasIdade...
2026-06-24 14:57:31,986 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 14:57:32,004 - INFO - Dropping table dFechamentoDias...
2026-06-24 14:57:32,007 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 14:57:32,031 - INFO - Dropping table dInteresses...
2026-06-24 14:57:32,034 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 14:57:32,058 - INFO - Dropping table dMidias...
2026-06-24 14:57:32,062 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 14:57:32,082 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 14:57:32,085 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 14:57:32,117 - INFO - Dropping table dProfissoes...
2026-06-24 14:57:32,120 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 14:57:32,140 - INFO - Dropping table dQuartos...
2026-06-24 14:57:32,143 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 14:57:32,147 - INFO - Dropping table dRegioes...
2026-06-24 14:57:32,150 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 14:57:32,182 - INFO - Dropping table dRendas...
2026-06-24 14:57:32,186 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 14:57:32,206 - INFO - Dropping table dSexos...
2026-06-24 14:57:32,210 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 14:57:32,224 - INFO - Dropping table dStatus...
2026-06-24 14:57:32,230 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 14:57:32,243 - INFO - Dropping table dStatusAtividade...
2026-06-24 14:57:32,246 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 14:57:32,274 - INFO - Dropping table dStatusProposta...
2026-06-24 14:57:32,277 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 14:57:32,281 - INFO - Dropping table dSuites...
2026-06-24 14:57:32,284 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 14:57:32,288 - INFO - Dropping table dTemperaturas...
2026-06-24 14:57:32,291 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 14:57:32,307 - INFO - Dropping table dTipos...
2026-06-24 14:57:32,312 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 14:57:32,336 - INFO - Dropping table dTiposAtividade...
2026-06-24 14:57:32,342 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 14:57:32,378 - INFO - Dropping table dUTMSource...
2026-06-24 14:57:32,383 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 14:57:32,430 - INFO - Dropping table dUTMMedium...
2026-06-24 14:57:32,434 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 14:57:32,487 - INFO - Dropping table dUTMCampaign...
2026-06-24 14:57:32,491 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 14:57:32,540 - INFO - Dropping table dUTMContent...
2026-06-24 14:57:32,550 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 14:57:32,595 - INFO - Dropping table dUTMTerm...
2026-06-24 14:57:32,598 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 14:57:32,650 - INFO - Dropping table dUnidades...
2026-06-24 14:57:32,654 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 14:57:32,668 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 14:57:32,671 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 14:57:32,675 - INFO - Dropping table dVagas...
2026-06-24 14:57:32,678 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 14:57:32,681 - INFO - Dropping table fAcessos...
2026-06-24 14:57:32,685 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 14:57:33,008 - INFO - Dropping table fOportunidades...
2026-06-24 14:57:33,011 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 14:57:47,253 - INFO - Dropping table fAcoesFunil...
2026-06-24 14:57:47,261 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 14:58:08,316 - INFO - Dropping table fAtividades...
2026-06-24 14:58:08,329 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 14:59:20,991 - INFO - Dropping table fPropostas...
2026-06-24 14:59:20,994 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 14:59:21,411 - INFO - Dropping table fVendas...
2026-06-24 14:59:21,414 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 14:59:21,795 - INFO - Batch 1 completed.
2026-06-24 14:59:21,795 - INFO - All tables refreshed.
2026-06-24 14:59:21,795 - INFO - Synchronization process completed successfully in 134.26091742515564 seconds.
2026-06-24 15:57:08,823 - INFO - Creating tables by calling stored procedure...
2026-06-24 15:57:09,030 - INFO - Tables created successfully via stored procedure.
2026-06-24 15:57:09,106 - INFO - Truncating tables...
2026-06-24 15:57:09,107 - INFO - Truncating table bi_acessos...
2026-06-24 15:57:09,107 - INFO - Truncating table bi_acoes_funil...
2026-06-24 15:57:09,108 - INFO - Truncating table bi_atividades...
2026-06-24 15:57:09,112 - INFO - Truncating table bi_oportunidades...
2026-06-24 15:57:09,114 - INFO - Truncating table bi_propostas...
2026-06-24 15:57:09,114 - INFO - Truncating table bi_vendas...
2026-06-24 15:57:09,115 - INFO - Truncating table bi_utms...
2026-06-24 15:57:09,116 - INFO - Truncation completed.
2026-06-24 15:57:09,116 - INFO - Fetching data from source database...
2026-06-24 15:57:30,244 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 15:57:30,245 - INFO - Creating star schema...
2026-06-24 15:57:30,334 - INFO - Star schema created successfully.
2026-06-24 15:57:30,334 - INFO - Refreshing tables (batch mode)...
2026-06-24 15:57:30,334 - INFO - Dropping table dCanais...
2026-06-24 15:57:30,338 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 15:57:30,352 - INFO - Dropping table dCategorias...
2026-06-24 15:57:30,355 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 15:57:30,366 - INFO - Dropping table dConsultores...
2026-06-24 15:57:30,369 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 15:57:30,382 - INFO - Dropping table dEmpreendimentos...
2026-06-24 15:57:30,384 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 15:57:30,409 - INFO - Dropping table dEstadosCivis...
2026-06-24 15:57:30,412 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 15:57:30,423 - INFO - Dropping table dEtapasFunil...
2026-06-24 15:57:30,426 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 15:57:30,446 - INFO - Dropping table dFaixasIdade...
2026-06-24 15:57:30,449 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 15:57:30,462 - INFO - Dropping table dFechamentoDias...
2026-06-24 15:57:30,464 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 15:57:30,483 - INFO - Dropping table dInteresses...
2026-06-24 15:57:30,485 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 15:57:30,499 - INFO - Dropping table dMidias...
2026-06-24 15:57:30,501 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 15:57:30,513 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 15:57:30,517 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 15:57:30,546 - INFO - Dropping table dProfissoes...
2026-06-24 15:57:30,551 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 15:57:30,565 - INFO - Dropping table dQuartos...
2026-06-24 15:57:30,567 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 15:57:30,571 - INFO - Dropping table dRegioes...
2026-06-24 15:57:30,573 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 15:57:30,592 - INFO - Dropping table dRendas...
2026-06-24 15:57:30,595 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 15:57:30,609 - INFO - Dropping table dSexos...
2026-06-24 15:57:30,612 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 15:57:30,624 - INFO - Dropping table dStatus...
2026-06-24 15:57:30,626 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 15:57:30,641 - INFO - Dropping table dStatusAtividade...
2026-06-24 15:57:30,644 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 15:57:30,665 - INFO - Dropping table dStatusProposta...
2026-06-24 15:57:30,670 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 15:57:30,673 - INFO - Dropping table dSuites...
2026-06-24 15:57:30,676 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 15:57:30,679 - INFO - Dropping table dTemperaturas...
2026-06-24 15:57:30,682 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 15:57:30,694 - INFO - Dropping table dTipos...
2026-06-24 15:57:30,696 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 15:57:30,712 - INFO - Dropping table dTiposAtividade...
2026-06-24 15:57:30,716 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 15:57:30,738 - INFO - Dropping table dUTMSource...
2026-06-24 15:57:30,741 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 15:57:30,774 - INFO - Dropping table dUTMMedium...
2026-06-24 15:57:30,777 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 15:57:30,817 - INFO - Dropping table dUTMCampaign...
2026-06-24 15:57:30,819 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 15:57:30,862 - INFO - Dropping table dUTMContent...
2026-06-24 15:57:30,865 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 15:57:30,907 - INFO - Dropping table dUTMTerm...
2026-06-24 15:57:30,910 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 15:57:30,951 - INFO - Dropping table dUnidades...
2026-06-24 15:57:30,954 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 15:57:30,970 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 15:57:30,973 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 15:57:30,976 - INFO - Dropping table dVagas...
2026-06-24 15:57:30,979 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 15:57:30,983 - INFO - Dropping table fAcessos...
2026-06-24 15:57:30,987 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 15:57:31,236 - INFO - Dropping table fOportunidades...
2026-06-24 15:57:31,250 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 15:57:42,584 - INFO - Dropping table fAcoesFunil...
2026-06-24 15:57:42,587 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 15:57:58,433 - INFO - Dropping table fAtividades...
2026-06-24 15:57:58,443 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 15:59:03,968 - INFO - Dropping table fPropostas...
2026-06-24 15:59:03,971 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 15:59:04,353 - INFO - Dropping table fVendas...
2026-06-24 15:59:04,356 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 15:59:04,739 - INFO - Batch 1 completed.
2026-06-24 15:59:04,739 - INFO - All tables refreshed.
2026-06-24 15:59:04,740 - INFO - Synchronization process completed successfully in 115.91691660881042 seconds.
2026-06-24 16:57:07,814 - INFO - Creating tables by calling stored procedure...
2026-06-24 16:57:07,936 - INFO - Tables created successfully via stored procedure.
2026-06-24 16:57:08,005 - INFO - Truncating tables...
2026-06-24 16:57:08,005 - INFO - Truncating table bi_acessos...
2026-06-24 16:57:08,006 - INFO - Truncating table bi_acoes_funil...
2026-06-24 16:57:08,007 - INFO - Truncating table bi_atividades...
2026-06-24 16:57:08,014 - INFO - Truncating table bi_oportunidades...
2026-06-24 16:57:08,015 - INFO - Truncating table bi_propostas...
2026-06-24 16:57:08,015 - INFO - Truncating table bi_vendas...
2026-06-24 16:57:08,015 - INFO - Truncating table bi_utms...
2026-06-24 16:57:08,016 - INFO - Truncation completed.
2026-06-24 16:57:08,016 - INFO - Fetching data from source database...
2026-06-24 16:57:31,862 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 16:57:31,863 - INFO - Creating star schema...
2026-06-24 16:57:31,957 - INFO - Star schema created successfully.
2026-06-24 16:57:31,957 - INFO - Refreshing tables (batch mode)...
2026-06-24 16:57:31,957 - INFO - Dropping table dCanais...
2026-06-24 16:57:31,960 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 16:57:31,978 - INFO - Dropping table dCategorias...
2026-06-24 16:57:31,981 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 16:57:31,995 - INFO - Dropping table dConsultores...
2026-06-24 16:57:31,999 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 16:57:32,011 - INFO - Dropping table dEmpreendimentos...
2026-06-24 16:57:32,016 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 16:57:32,037 - INFO - Dropping table dEstadosCivis...
2026-06-24 16:57:32,040 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 16:57:32,054 - INFO - Dropping table dEtapasFunil...
2026-06-24 16:57:32,058 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 16:57:32,086 - INFO - Dropping table dFaixasIdade...
2026-06-24 16:57:32,090 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 16:57:32,108 - INFO - Dropping table dFechamentoDias...
2026-06-24 16:57:32,114 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 16:57:32,128 - INFO - Dropping table dInteresses...
2026-06-24 16:57:32,132 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 16:57:32,152 - INFO - Dropping table dMidias...
2026-06-24 16:57:32,155 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 16:57:32,167 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 16:57:32,170 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 16:57:32,187 - INFO - Dropping table dProfissoes...
2026-06-24 16:57:32,191 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 16:57:32,202 - INFO - Dropping table dQuartos...
2026-06-24 16:57:32,207 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 16:57:32,214 - INFO - Dropping table dRegioes...
2026-06-24 16:57:32,217 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 16:57:32,237 - INFO - Dropping table dRendas...
2026-06-24 16:57:32,240 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 16:57:32,252 - INFO - Dropping table dSexos...
2026-06-24 16:57:32,254 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 16:57:32,266 - INFO - Dropping table dStatus...
2026-06-24 16:57:32,268 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 16:57:32,279 - INFO - Dropping table dStatusAtividade...
2026-06-24 16:57:32,282 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 16:57:32,312 - INFO - Dropping table dStatusProposta...
2026-06-24 16:57:32,315 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 16:57:32,319 - INFO - Dropping table dSuites...
2026-06-24 16:57:32,322 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 16:57:32,326 - INFO - Dropping table dTemperaturas...
2026-06-24 16:57:32,330 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 16:57:32,349 - INFO - Dropping table dTipos...
2026-06-24 16:57:32,352 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 16:57:32,365 - INFO - Dropping table dTiposAtividade...
2026-06-24 16:57:32,368 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 16:57:32,411 - INFO - Dropping table dUTMSource...
2026-06-24 16:57:32,414 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 16:57:32,458 - INFO - Dropping table dUTMMedium...
2026-06-24 16:57:32,464 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 16:57:32,504 - INFO - Dropping table dUTMCampaign...
2026-06-24 16:57:32,508 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 16:57:32,549 - INFO - Dropping table dUTMContent...
2026-06-24 16:57:32,553 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 16:57:32,614 - INFO - Dropping table dUTMTerm...
2026-06-24 16:57:32,617 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 16:57:32,674 - INFO - Dropping table dUnidades...
2026-06-24 16:57:32,677 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 16:57:32,694 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 16:57:32,697 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 16:57:32,702 - INFO - Dropping table dVagas...
2026-06-24 16:57:32,712 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 16:57:32,717 - INFO - Dropping table fAcessos...
2026-06-24 16:57:32,722 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 16:57:32,987 - INFO - Dropping table fOportunidades...
2026-06-24 16:57:33,002 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 16:57:47,246 - INFO - Dropping table fAcoesFunil...
2026-06-24 16:57:47,252 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 16:58:09,971 - INFO - Dropping table fAtividades...
2026-06-24 16:58:09,975 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 16:59:23,735 - INFO - Dropping table fPropostas...
2026-06-24 16:59:23,738 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 16:59:24,205 - INFO - Dropping table fVendas...
2026-06-24 16:59:24,208 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 16:59:24,831 - INFO - Batch 1 completed.
2026-06-24 16:59:24,831 - INFO - All tables refreshed.
2026-06-24 16:59:24,832 - INFO - Synchronization process completed successfully in 137.0177128314972 seconds.
2026-06-24 17:57:08,225 - INFO - Creating tables by calling stored procedure...
2026-06-24 17:57:08,427 - INFO - Tables created successfully via stored procedure.
2026-06-24 17:57:08,430 - INFO - Truncating tables...
2026-06-24 17:57:08,430 - INFO - Truncating table bi_acessos...
2026-06-24 17:57:08,430 - INFO - Truncating table bi_acoes_funil...
2026-06-24 17:57:08,431 - INFO - Truncating table bi_atividades...
2026-06-24 17:57:08,434 - INFO - Truncating table bi_oportunidades...
2026-06-24 17:57:08,435 - INFO - Truncating table bi_propostas...
2026-06-24 17:57:08,435 - INFO - Truncating table bi_vendas...
2026-06-24 17:57:08,436 - INFO - Truncating table bi_utms...
2026-06-24 17:57:08,504 - INFO - Truncation completed.
2026-06-24 17:57:08,504 - INFO - Fetching data from source database...
2026-06-24 17:57:30,399 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 17:57:30,400 - INFO - Creating star schema...
2026-06-24 17:57:30,505 - INFO - Star schema created successfully.
2026-06-24 17:57:30,505 - INFO - Refreshing tables (batch mode)...
2026-06-24 17:57:30,506 - INFO - Dropping table dCanais...
2026-06-24 17:57:30,509 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 17:57:30,520 - INFO - Dropping table dCategorias...
2026-06-24 17:57:30,526 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 17:57:30,537 - INFO - Dropping table dConsultores...
2026-06-24 17:57:30,541 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 17:57:30,557 - INFO - Dropping table dEmpreendimentos...
2026-06-24 17:57:30,561 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 17:57:30,574 - INFO - Dropping table dEstadosCivis...
2026-06-24 17:57:30,577 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 17:57:30,588 - INFO - Dropping table dEtapasFunil...
2026-06-24 17:57:30,591 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 17:57:30,614 - INFO - Dropping table dFaixasIdade...
2026-06-24 17:57:30,617 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 17:57:30,630 - INFO - Dropping table dFechamentoDias...
2026-06-24 17:57:30,633 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 17:57:30,647 - INFO - Dropping table dInteresses...
2026-06-24 17:57:30,650 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 17:57:30,664 - INFO - Dropping table dMidias...
2026-06-24 17:57:30,669 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 17:57:30,682 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 17:57:30,687 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 17:57:30,705 - INFO - Dropping table dProfissoes...
2026-06-24 17:57:30,709 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 17:57:30,722 - INFO - Dropping table dQuartos...
2026-06-24 17:57:30,726 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 17:57:30,730 - INFO - Dropping table dRegioes...
2026-06-24 17:57:30,733 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 17:57:30,752 - INFO - Dropping table dRendas...
2026-06-24 17:57:30,757 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 17:57:30,772 - INFO - Dropping table dSexos...
2026-06-24 17:57:30,776 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 17:57:30,789 - INFO - Dropping table dStatus...
2026-06-24 17:57:30,793 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 17:57:30,811 - INFO - Dropping table dStatusAtividade...
2026-06-24 17:57:30,815 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 17:57:30,838 - INFO - Dropping table dStatusProposta...
2026-06-24 17:57:30,841 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 17:57:30,845 - INFO - Dropping table dSuites...
2026-06-24 17:57:30,852 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 17:57:30,856 - INFO - Dropping table dTemperaturas...
2026-06-24 17:57:30,860 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 17:57:30,878 - INFO - Dropping table dTipos...
2026-06-24 17:57:30,883 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 17:57:30,902 - INFO - Dropping table dTiposAtividade...
2026-06-24 17:57:30,906 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 17:57:30,934 - INFO - Dropping table dUTMSource...
2026-06-24 17:57:30,938 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 17:57:30,976 - INFO - Dropping table dUTMMedium...
2026-06-24 17:57:30,980 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 17:57:31,023 - INFO - Dropping table dUTMCampaign...
2026-06-24 17:57:31,027 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 17:57:31,068 - INFO - Dropping table dUTMContent...
2026-06-24 17:57:31,072 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 17:57:31,123 - INFO - Dropping table dUTMTerm...
2026-06-24 17:57:31,127 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 17:57:31,170 - INFO - Dropping table dUnidades...
2026-06-24 17:57:31,173 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 17:57:31,187 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 17:57:31,190 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 17:57:31,193 - INFO - Dropping table dVagas...
2026-06-24 17:57:31,196 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 17:57:31,200 - INFO - Dropping table fAcessos...
2026-06-24 17:57:31,203 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 17:57:31,412 - INFO - Dropping table fOportunidades...
2026-06-24 17:57:31,414 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 17:57:43,367 - INFO - Dropping table fAcoesFunil...
2026-06-24 17:57:43,382 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 17:58:02,639 - INFO - Dropping table fAtividades...
2026-06-24 17:58:02,642 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 17:59:09,351 - INFO - Dropping table fPropostas...
2026-06-24 17:59:09,354 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 17:59:09,979 - INFO - Dropping table fVendas...
2026-06-24 17:59:09,983 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 17:59:10,464 - INFO - Batch 1 completed.
2026-06-24 17:59:10,464 - INFO - All tables refreshed.
2026-06-24 17:59:10,464 - INFO - Synchronization process completed successfully in 122.23967552185059 seconds.
2026-06-24 18:57:08,027 - INFO - Creating tables by calling stored procedure...
2026-06-24 18:57:08,233 - INFO - Tables created successfully via stored procedure.
2026-06-24 18:57:08,305 - INFO - Truncating tables...
2026-06-24 18:57:08,305 - INFO - Truncating table bi_acessos...
2026-06-24 18:57:08,306 - INFO - Truncating table bi_acoes_funil...
2026-06-24 18:57:08,306 - INFO - Truncating table bi_atividades...
2026-06-24 18:57:08,310 - INFO - Truncating table bi_oportunidades...
2026-06-24 18:57:08,311 - INFO - Truncating table bi_propostas...
2026-06-24 18:57:08,312 - INFO - Truncating table bi_vendas...
2026-06-24 18:57:08,312 - INFO - Truncating table bi_utms...
2026-06-24 18:57:08,317 - INFO - Truncation completed.
2026-06-24 18:57:08,317 - INFO - Fetching data from source database...
2026-06-24 18:57:32,376 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 18:57:32,377 - INFO - Creating star schema...
2026-06-24 18:57:32,494 - INFO - Star schema created successfully.
2026-06-24 18:57:32,494 - INFO - Refreshing tables (batch mode)...
2026-06-24 18:57:32,494 - INFO - Dropping table dCanais...
2026-06-24 18:57:32,499 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 18:57:32,513 - INFO - Dropping table dCategorias...
2026-06-24 18:57:32,517 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 18:57:32,528 - INFO - Dropping table dConsultores...
2026-06-24 18:57:32,532 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 18:57:32,547 - INFO - Dropping table dEmpreendimentos...
2026-06-24 18:57:32,551 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 18:57:32,564 - INFO - Dropping table dEstadosCivis...
2026-06-24 18:57:32,569 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 18:57:32,588 - INFO - Dropping table dEtapasFunil...
2026-06-24 18:57:32,591 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 18:57:32,623 - INFO - Dropping table dFaixasIdade...
2026-06-24 18:57:32,627 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 18:57:32,643 - INFO - Dropping table dFechamentoDias...
2026-06-24 18:57:32,647 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 18:57:32,660 - INFO - Dropping table dInteresses...
2026-06-24 18:57:32,663 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 18:57:32,676 - INFO - Dropping table dMidias...
2026-06-24 18:57:32,679 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 18:57:32,691 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 18:57:32,694 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 18:57:32,715 - INFO - Dropping table dProfissoes...
2026-06-24 18:57:32,719 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 18:57:32,733 - INFO - Dropping table dQuartos...
2026-06-24 18:57:32,736 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 18:57:32,740 - INFO - Dropping table dRegioes...
2026-06-24 18:57:32,744 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 18:57:32,763 - INFO - Dropping table dRendas...
2026-06-24 18:57:32,765 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 18:57:32,784 - INFO - Dropping table dSexos...
2026-06-24 18:57:32,787 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 18:57:32,808 - INFO - Dropping table dStatus...
2026-06-24 18:57:32,813 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 18:57:32,827 - INFO - Dropping table dStatusAtividade...
2026-06-24 18:57:32,831 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 18:57:32,859 - INFO - Dropping table dStatusProposta...
2026-06-24 18:57:32,862 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 18:57:32,867 - INFO - Dropping table dSuites...
2026-06-24 18:57:32,871 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 18:57:32,874 - INFO - Dropping table dTemperaturas...
2026-06-24 18:57:32,877 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 18:57:32,889 - INFO - Dropping table dTipos...
2026-06-24 18:57:32,892 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 18:57:32,917 - INFO - Dropping table dTiposAtividade...
2026-06-24 18:57:32,923 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 18:57:32,964 - INFO - Dropping table dUTMSource...
2026-06-24 18:57:32,967 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 18:57:33,025 - INFO - Dropping table dUTMMedium...
2026-06-24 18:57:33,030 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 18:57:33,070 - INFO - Dropping table dUTMCampaign...
2026-06-24 18:57:33,074 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 18:57:33,113 - INFO - Dropping table dUTMContent...
2026-06-24 18:57:33,116 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 18:57:33,158 - INFO - Dropping table dUTMTerm...
2026-06-24 18:57:33,161 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 18:57:33,199 - INFO - Dropping table dUnidades...
2026-06-24 18:57:33,203 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 18:57:33,216 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 18:57:33,220 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 18:57:33,224 - INFO - Dropping table dVagas...
2026-06-24 18:57:33,227 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 18:57:33,231 - INFO - Dropping table fAcessos...
2026-06-24 18:57:33,234 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 18:57:33,456 - INFO - Dropping table fOportunidades...
2026-06-24 18:57:33,459 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 18:57:47,582 - INFO - Dropping table fAcoesFunil...
2026-06-24 18:57:47,584 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 18:58:08,810 - INFO - Dropping table fAtividades...
2026-06-24 18:58:08,815 - INFO - Creating table fAtividades from vw_fAtividades...