2026-06-23 17:57:08,987 - INFO - Truncating table bi_propostas...
2026-06-23 17:57:09,065 - INFO - Truncating table bi_vendas...
2026-06-23 17:57:09,066 - INFO - Truncating table bi_utms...
2026-06-23 17:57:09,067 - INFO - Truncation completed.
2026-06-23 17:57:09,067 - INFO - Fetching data from source database...
2026-06-23 17:57:38,322 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-23 17:57:38,325 - INFO - Creating star schema...
2026-06-23 17:57:38,429 - INFO - Star schema created successfully.
2026-06-23 17:57:38,429 - INFO - Refreshing tables (batch mode)...
2026-06-23 17:57:38,430 - INFO - Dropping table dCanais...
2026-06-23 17:57:38,434 - INFO - Creating table dCanais from vw_dCanais...
2026-06-23 17:57:38,455 - INFO - Dropping table dCategorias...
2026-06-23 17:57:38,459 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-23 17:57:38,482 - INFO - Dropping table dConsultores...
2026-06-23 17:57:38,499 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-23 17:57:38,517 - INFO - Dropping table dEmpreendimentos...
2026-06-23 17:57:38,520 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-23 17:57:38,539 - INFO - Dropping table dEstadosCivis...
2026-06-23 17:57:38,542 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-23 17:57:38,558 - INFO - Dropping table dEtapasFunil...
2026-06-23 17:57:38,562 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-23 17:57:38,592 - INFO - Dropping table dFaixasIdade...
2026-06-23 17:57:38,597 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-23 17:57:38,616 - INFO - Dropping table dFechamentoDias...
2026-06-23 17:57:38,619 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-23 17:57:38,644 - INFO - Dropping table dInteresses...
2026-06-23 17:57:38,648 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-23 17:57:38,668 - INFO - Dropping table dMidias...
2026-06-23 17:57:38,671 - INFO - Creating table dMidias from vw_dMidias...
2026-06-23 17:57:38,685 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-23 17:57:38,690 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-23 17:57:38,718 - INFO - Dropping table dProfissoes...
2026-06-23 17:57:38,725 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-23 17:57:38,752 - INFO - Dropping table dQuartos...
2026-06-23 17:57:38,756 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-23 17:57:38,763 - INFO - Dropping table dRegioes...
2026-06-23 17:57:38,767 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-23 17:57:38,797 - INFO - Dropping table dRendas...
2026-06-23 17:57:38,802 - INFO - Creating table dRendas from vw_dRendas...
2026-06-23 17:57:38,817 - INFO - Dropping table dSexos...
2026-06-23 17:57:38,821 - INFO - Creating table dSexos from vw_dSexos...
2026-06-23 17:57:38,838 - INFO - Dropping table dStatus...
2026-06-23 17:57:38,842 - INFO - Creating table dStatus from vw_dStatus...
2026-06-23 17:57:38,857 - INFO - Dropping table dStatusAtividade...
2026-06-23 17:57:38,861 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-23 17:57:38,911 - INFO - Dropping table dStatusProposta...
2026-06-23 17:57:38,915 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-23 17:57:38,923 - INFO - Dropping table dSuites...
2026-06-23 17:57:38,926 - INFO - Creating table dSuites from vw_dSuites...
2026-06-23 17:57:38,932 - INFO - Dropping table dTemperaturas...
2026-06-23 17:57:38,936 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-23 17:57:38,959 - INFO - Dropping table dTipos...
2026-06-23 17:57:38,963 - INFO - Creating table dTipos from vw_dTipos...
2026-06-23 17:57:38,979 - INFO - Dropping table dTiposAtividade...
2026-06-23 17:57:38,983 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-23 17:57:39,020 - INFO - Dropping table dUTMSource...
2026-06-23 17:57:39,024 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-23 17:57:39,094 - INFO - Dropping table dUTMMedium...
2026-06-23 17:57:39,097 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-23 17:57:39,185 - INFO - Dropping table dUTMCampaign...
2026-06-23 17:57:39,188 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-23 17:57:39,287 - INFO - Dropping table dUTMContent...
2026-06-23 17:57:39,291 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-23 17:57:39,373 - INFO - Dropping table dUTMTerm...
2026-06-23 17:57:39,379 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-23 17:57:39,441 - INFO - Dropping table dUnidades...
2026-06-23 17:57:39,444 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-23 17:57:39,476 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-23 17:57:39,480 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-23 17:57:39,485 - INFO - Dropping table dVagas...
2026-06-23 17:57:39,489 - INFO - Creating table dVagas from vw_dVagas...
2026-06-23 17:57:39,494 - INFO - Dropping table fAcessos...
2026-06-23 17:57:39,500 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-23 17:57:39,910 - INFO - Dropping table fOportunidades...
2026-06-23 17:57:39,928 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-23 17:58:10,179 - INFO - Dropping table fAcoesFunil...
2026-06-23 17:58:10,183 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-23 17:58:43,868 - INFO - Dropping table fAtividades...
2026-06-23 17:58:43,879 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-23 18:00:13,519 - INFO - Dropping table fPropostas...
2026-06-23 18:00:13,523 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-23 18:00:14,460 - INFO - Dropping table fVendas...
2026-06-23 18:00:14,465 - INFO - Creating table fVendas from vw_fVendas...
2026-06-23 18:00:15,207 - INFO - Batch 1 completed.
2026-06-23 18:00:15,207 - INFO - All tables refreshed.
2026-06-23 18:00:15,207 - INFO - Synchronization process completed successfully in 186.54042530059814 seconds.
2026-06-23 18:57:08,098 - INFO - Creating tables by calling stored procedure...
2026-06-23 18:57:08,380 - INFO - Tables created successfully via stored procedure.
2026-06-23 18:57:08,388 - INFO - Truncating tables...
2026-06-23 18:57:08,388 - INFO - Truncating table bi_acessos...
2026-06-23 18:57:08,389 - INFO - Truncating table bi_acoes_funil...
2026-06-23 18:57:08,389 - INFO - Truncating table bi_atividades...
2026-06-23 18:57:08,391 - INFO - Truncating table bi_oportunidades...
2026-06-23 18:57:08,391 - INFO - Truncating table bi_propostas...
2026-06-23 18:57:08,392 - INFO - Truncating table bi_vendas...
2026-06-23 18:57:08,392 - INFO - Truncating table bi_utms...
2026-06-23 18:57:08,393 - INFO - Truncation completed.
2026-06-23 18:57:08,393 - INFO - Fetching data from source database...
2026-06-23 18:57:39,176 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-23 18:57:39,179 - INFO - Creating star schema...
2026-06-23 18:57:39,305 - INFO - Star schema created successfully.
2026-06-23 18:57:39,305 - INFO - Refreshing tables (batch mode)...
2026-06-23 18:57:39,305 - INFO - Dropping table dCanais...
2026-06-23 18:57:39,310 - INFO - Creating table dCanais from vw_dCanais...
2026-06-23 18:57:39,334 - INFO - Dropping table dCategorias...
2026-06-23 18:57:39,341 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-23 18:57:39,359 - INFO - Dropping table dConsultores...
2026-06-23 18:57:39,364 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-23 18:57:39,384 - INFO - Dropping table dEmpreendimentos...
2026-06-23 18:57:39,388 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-23 18:57:39,409 - INFO - Dropping table dEstadosCivis...
2026-06-23 18:57:39,412 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-23 18:57:39,434 - INFO - Dropping table dEtapasFunil...
2026-06-23 18:57:39,441 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-23 18:57:39,474 - INFO - Dropping table dFaixasIdade...
2026-06-23 18:57:39,478 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-23 18:57:39,501 - INFO - Dropping table dFechamentoDias...
2026-06-23 18:57:39,505 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-23 18:57:39,521 - INFO - Dropping table dInteresses...
2026-06-23 18:57:39,526 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-23 18:57:39,544 - INFO - Dropping table dMidias...
2026-06-23 18:57:39,548 - INFO - Creating table dMidias from vw_dMidias...
2026-06-23 18:57:39,573 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-23 18:57:39,578 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-23 18:57:39,610 - INFO - Dropping table dProfissoes...
2026-06-23 18:57:39,615 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-23 18:57:39,634 - INFO - Dropping table dQuartos...
2026-06-23 18:57:39,638 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-23 18:57:39,647 - INFO - Dropping table dRegioes...
2026-06-23 18:57:39,654 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-23 18:57:39,690 - INFO - Dropping table dRendas...
2026-06-23 18:57:39,695 - INFO - Creating table dRendas from vw_dRendas...
2026-06-23 18:57:39,710 - INFO - Dropping table dSexos...
2026-06-23 18:57:39,715 - INFO - Creating table dSexos from vw_dSexos...
2026-06-23 18:57:39,740 - INFO - Dropping table dStatus...
2026-06-23 18:57:39,744 - INFO - Creating table dStatus from vw_dStatus...
2026-06-23 18:57:39,761 - INFO - Dropping table dStatusAtividade...
2026-06-23 18:57:39,766 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-23 18:57:39,808 - INFO - Dropping table dStatusProposta...
2026-06-23 18:57:39,812 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-23 18:57:39,817 - INFO - Dropping table dSuites...
2026-06-23 18:57:39,827 - INFO - Creating table dSuites from vw_dSuites...
2026-06-23 18:57:39,831 - INFO - Dropping table dTemperaturas...
2026-06-23 18:57:39,836 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-23 18:57:39,856 - INFO - Dropping table dTipos...
2026-06-23 18:57:39,860 - INFO - Creating table dTipos from vw_dTipos...
2026-06-23 18:57:39,891 - INFO - Dropping table dTiposAtividade...
2026-06-23 18:57:39,895 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-23 18:57:39,945 - INFO - Dropping table dUTMSource...
2026-06-23 18:57:39,950 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-23 18:57:40,050 - INFO - Dropping table dUTMMedium...
2026-06-23 18:57:40,055 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-23 18:57:40,143 - INFO - Dropping table dUTMCampaign...
2026-06-23 18:57:40,146 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-23 18:57:40,228 - INFO - Dropping table dUTMContent...
2026-06-23 18:57:40,230 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-23 18:57:40,304 - INFO - Dropping table dUTMTerm...
2026-06-23 18:57:40,308 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-23 18:57:40,392 - INFO - Dropping table dUnidades...
2026-06-23 18:57:40,396 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-23 18:57:40,427 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-23 18:57:40,431 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-23 18:57:40,437 - INFO - Dropping table dVagas...
2026-06-23 18:57:40,439 - INFO - Creating table dVagas from vw_dVagas...
2026-06-23 18:57:40,443 - INFO - Dropping table fAcessos...
2026-06-23 18:57:40,446 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-23 18:57:40,748 - INFO - Dropping table fOportunidades...
2026-06-23 18:57:40,753 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-23 18:58:13,801 - INFO - Dropping table fAcoesFunil...
2026-06-23 18:58:13,806 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-23 18:58:47,220 - INFO - Dropping table fAtividades...
2026-06-23 18:58:47,223 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-23 19:00:12,487 - INFO - Dropping table fPropostas...
2026-06-23 19:00:12,491 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-23 19:00:13,196 - INFO - Dropping table fVendas...
2026-06-23 19:00:13,200 - INFO - Creating table fVendas from vw_fVendas...
2026-06-23 19:00:13,773 - INFO - Batch 1 completed.
2026-06-23 19:00:13,773 - INFO - All tables refreshed.
2026-06-23 19:00:13,773 - INFO - Synchronization process completed successfully in 185.67472290992737 seconds.
2026-06-23 19:57:08,182 - INFO - Creating tables by calling stored procedure...
2026-06-23 19:57:08,389 - INFO - Tables created successfully via stored procedure.
2026-06-23 19:57:08,466 - INFO - Truncating tables...
2026-06-23 19:57:08,466 - INFO - Truncating table bi_acessos...
2026-06-23 19:57:08,477 - INFO - Truncating table bi_acoes_funil...
2026-06-23 19:57:08,478 - INFO - Truncating table bi_atividades...
2026-06-23 19:57:08,489 - INFO - Truncating table bi_oportunidades...
2026-06-23 19:57:08,490 - INFO - Truncating table bi_propostas...
2026-06-23 19:57:08,491 - INFO - Truncating table bi_vendas...
2026-06-23 19:57:08,491 - INFO - Truncating table bi_utms...
2026-06-23 19:57:08,493 - INFO - Truncation completed.
2026-06-23 19:57:08,493 - INFO - Fetching data from source database...
2026-06-23 19:57:35,686 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-23 19:57:35,687 - INFO - Creating star schema...
2026-06-23 19:57:35,765 - INFO - Star schema created successfully.
2026-06-23 19:57:35,765 - INFO - Refreshing tables (batch mode)...
2026-06-23 19:57:35,765 - INFO - Dropping table dCanais...
2026-06-23 19:57:35,767 - INFO - Creating table dCanais from vw_dCanais...
2026-06-23 19:57:35,781 - INFO - Dropping table dCategorias...
2026-06-23 19:57:35,785 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-23 19:57:35,805 - INFO - Dropping table dConsultores...
2026-06-23 19:57:35,808 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-23 19:57:35,838 - INFO - Dropping table dEmpreendimentos...
2026-06-23 19:57:35,841 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-23 19:57:35,859 - INFO - Dropping table dEstadosCivis...
2026-06-23 19:57:35,862 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-23 19:57:35,875 - INFO - Dropping table dEtapasFunil...
2026-06-23 19:57:35,878 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-23 19:57:35,918 - INFO - Dropping table dFaixasIdade...
2026-06-23 19:57:35,921 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-23 19:57:35,947 - INFO - Dropping table dFechamentoDias...
2026-06-23 19:57:35,950 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-23 19:57:35,979 - INFO - Dropping table dInteresses...
2026-06-23 19:57:35,983 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-23 19:57:36,009 - INFO - Dropping table dMidias...
2026-06-23 19:57:36,013 - INFO - Creating table dMidias from vw_dMidias...
2026-06-23 19:57:36,038 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-23 19:57:36,041 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-23 19:57:36,056 - INFO - Dropping table dProfissoes...
2026-06-23 19:57:36,059 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-23 19:57:36,072 - INFO - Dropping table dQuartos...
2026-06-23 19:57:36,075 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-23 19:57:36,079 - INFO - Dropping table dRegioes...
2026-06-23 19:57:36,082 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-23 19:57:36,110 - INFO - Dropping table dRendas...
2026-06-23 19:57:36,113 - INFO - Creating table dRendas from vw_dRendas...
2026-06-23 19:57:36,125 - INFO - Dropping table dSexos...
2026-06-23 19:57:36,129 - INFO - Creating table dSexos from vw_dSexos...
2026-06-23 19:57:36,142 - INFO - Dropping table dStatus...
2026-06-23 19:57:36,146 - INFO - Creating table dStatus from vw_dStatus...
2026-06-23 19:57:36,163 - INFO - Dropping table dStatusAtividade...
2026-06-23 19:57:36,167 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-23 19:57:36,199 - INFO - Dropping table dStatusProposta...
2026-06-23 19:57:36,202 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-23 19:57:36,207 - INFO - Dropping table dSuites...
2026-06-23 19:57:36,210 - INFO - Creating table dSuites from vw_dSuites...
2026-06-23 19:57:36,214 - INFO - Dropping table dTemperaturas...
2026-06-23 19:57:36,218 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-23 19:57:36,231 - INFO - Dropping table dTipos...
2026-06-23 19:57:36,235 - INFO - Creating table dTipos from vw_dTipos...
2026-06-23 19:57:36,254 - INFO - Dropping table dTiposAtividade...
2026-06-23 19:57:36,258 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-23 19:57:36,292 - INFO - Dropping table dUTMSource...
2026-06-23 19:57:36,294 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-23 19:57:36,357 - INFO - Dropping table dUTMMedium...
2026-06-23 19:57:36,360 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-23 19:57:36,425 - INFO - Dropping table dUTMCampaign...
2026-06-23 19:57:36,431 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-23 19:57:36,508 - INFO - Dropping table dUTMContent...
2026-06-23 19:57:36,513 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-23 19:57:36,581 - INFO - Dropping table dUTMTerm...
2026-06-23 19:57:36,588 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-23 19:57:36,671 - INFO - Dropping table dUnidades...
2026-06-23 19:57:36,674 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-23 19:57:36,690 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-23 19:57:36,693 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-23 19:57:36,698 - INFO - Dropping table dVagas...
2026-06-23 19:57:36,701 - INFO - Creating table dVagas from vw_dVagas...
2026-06-23 19:57:36,705 - INFO - Dropping table fAcessos...
2026-06-23 19:57:36,708 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-23 19:57:36,998 - INFO - Dropping table fOportunidades...
2026-06-23 19:57:37,001 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-23 19:58:05,171 - INFO - Dropping table fAcoesFunil...
2026-06-23 19:58:05,182 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-23 19:58:34,832 - INFO - Dropping table fAtividades...
2026-06-23 19:58:34,840 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-23 19:59:46,698 - INFO - Dropping table fPropostas...
2026-06-23 19:59:46,700 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-23 19:59:47,411 - INFO - Dropping table fVendas...
2026-06-23 19:59:47,413 - INFO - Creating table fVendas from vw_fVendas...
2026-06-23 19:59:47,928 - INFO - Batch 1 completed.
2026-06-23 19:59:47,928 - INFO - All tables refreshed.
2026-06-23 19:59:47,928 - INFO - Synchronization process completed successfully in 159.74638724327087 seconds.
2026-06-23 20:57:07,568 - INFO - Creating tables by calling stored procedure...
2026-06-23 20:57:07,691 - INFO - Tables created successfully via stored procedure.
2026-06-23 20:57:07,766 - INFO - Truncating tables...
2026-06-23 20:57:07,767 - INFO - Truncating table bi_acessos...
2026-06-23 20:57:07,768 - INFO - Truncating table bi_acoes_funil...
2026-06-23 20:57:07,769 - INFO - Truncating table bi_atividades...
2026-06-23 20:57:07,776 - INFO - Truncating table bi_oportunidades...
2026-06-23 20:57:07,777 - INFO - Truncating table bi_propostas...
2026-06-23 20:57:07,778 - INFO - Truncating table bi_vendas...
2026-06-23 20:57:07,778 - INFO - Truncating table bi_utms...
2026-06-23 20:57:07,780 - INFO - Truncation completed.
2026-06-23 20:57:07,780 - INFO - Fetching data from source database...
2026-06-23 20:57:36,992 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-23 20:57:36,994 - INFO - Creating star schema...
2026-06-23 20:57:37,081 - INFO - Star schema created successfully.
2026-06-23 20:57:37,081 - INFO - Refreshing tables (batch mode)...
2026-06-23 20:57:37,082 - INFO - Dropping table dCanais...
2026-06-23 20:57:37,085 - INFO - Creating table dCanais from vw_dCanais...
2026-06-23 20:57:37,100 - INFO - Dropping table dCategorias...
2026-06-23 20:57:37,102 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-23 20:57:37,117 - INFO - Dropping table dConsultores...
2026-06-23 20:57:37,119 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-23 20:57:37,137 - INFO - Dropping table dEmpreendimentos...
2026-06-23 20:57:37,140 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-23 20:57:37,159 - INFO - Dropping table dEstadosCivis...
2026-06-23 20:57:37,161 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-23 20:57:37,186 - INFO - Dropping table dEtapasFunil...
2026-06-23 20:57:37,191 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-23 20:57:37,243 - INFO - Dropping table dFaixasIdade...
2026-06-23 20:57:37,251 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-23 20:57:37,270 - INFO - Dropping table dFechamentoDias...
2026-06-23 20:57:37,273 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-23 20:57:37,310 - INFO - Dropping table dInteresses...
2026-06-23 20:57:37,313 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-23 20:57:37,329 - INFO - Dropping table dMidias...
2026-06-23 20:57:37,331 - INFO - Creating table dMidias from vw_dMidias...
2026-06-23 20:57:37,345 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-23 20:57:37,349 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-23 20:57:37,365 - INFO - Dropping table dProfissoes...
2026-06-23 20:57:37,369 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-23 20:57:37,383 - INFO - Dropping table dQuartos...
2026-06-23 20:57:37,387 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-23 20:57:37,392 - INFO - Dropping table dRegioes...
2026-06-23 20:57:37,394 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-23 20:57:37,422 - INFO - Dropping table dRendas...
2026-06-23 20:57:37,425 - INFO - Creating table dRendas from vw_dRendas...
2026-06-23 20:57:37,443 - INFO - Dropping table dSexos...
2026-06-23 20:57:37,446 - INFO - Creating table dSexos from vw_dSexos...
2026-06-23 20:57:37,466 - INFO - Dropping table dStatus...
2026-06-23 20:57:37,469 - INFO - Creating table dStatus from vw_dStatus...
2026-06-23 20:57:37,483 - INFO - Dropping table dStatusAtividade...
2026-06-23 20:57:37,487 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-23 20:57:37,534 - INFO - Dropping table dStatusProposta...
2026-06-23 20:57:37,536 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-23 20:57:37,541 - INFO - Dropping table dSuites...
2026-06-23 20:57:37,544 - INFO - Creating table dSuites from vw_dSuites...
2026-06-23 20:57:37,548 - INFO - Dropping table dTemperaturas...
2026-06-23 20:57:37,551 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-23 20:57:37,565 - INFO - Dropping table dTipos...
2026-06-23 20:57:37,569 - INFO - Creating table dTipos from vw_dTipos...
2026-06-23 20:57:37,587 - INFO - Dropping table dTiposAtividade...
2026-06-23 20:57:37,591 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-23 20:57:37,622 - INFO - Dropping table dUTMSource...
2026-06-23 20:57:37,626 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-23 20:57:37,715 - INFO - Dropping table dUTMMedium...
2026-06-23 20:57:37,718 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-23 20:57:37,807 - INFO - Dropping table dUTMCampaign...
2026-06-23 20:57:37,810 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-23 20:57:37,914 - INFO - Dropping table dUTMContent...
2026-06-23 20:57:37,918 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-23 20:57:38,020 - INFO - Dropping table dUTMTerm...
2026-06-23 20:57:38,023 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-23 20:57:38,118 - INFO - Dropping table dUnidades...
2026-06-23 20:57:38,121 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-23 20:57:38,145 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-23 20:57:38,155 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-23 20:57:38,161 - INFO - Dropping table dVagas...
2026-06-23 20:57:38,164 - INFO - Creating table dVagas from vw_dVagas...
2026-06-23 20:57:38,169 - INFO - Dropping table fAcessos...
2026-06-23 20:57:38,171 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-23 20:57:38,550 - INFO - Dropping table fOportunidades...
2026-06-23 20:57:38,558 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-23 20:58:11,256 - INFO - Dropping table fAcoesFunil...
2026-06-23 20:58:11,260 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-23 20:58:45,147 - INFO - Dropping table fAtividades...
2026-06-23 20:58:45,153 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-23 21:00:12,154 - INFO - Dropping table fPropostas...
2026-06-23 21:00:12,158 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-23 21:00:12,764 - INFO - Dropping table fVendas...
2026-06-23 21:00:12,766 - INFO - Creating table fVendas from vw_fVendas...
2026-06-23 21:00:13,403 - INFO - Batch 1 completed.
2026-06-23 21:00:13,403 - INFO - All tables refreshed.
2026-06-23 21:00:13,403 - INFO - Synchronization process completed successfully in 185.83455157279968 seconds.
2026-06-23 21:57:07,784 - INFO - Creating tables by calling stored procedure...
2026-06-23 21:57:07,993 - INFO - Tables created successfully via stored procedure.
2026-06-23 21:57:07,995 - INFO - Truncating tables...
2026-06-23 21:57:07,995 - INFO - Truncating table bi_acessos...
2026-06-23 21:57:08,066 - INFO - Truncating table bi_acoes_funil...
2026-06-23 21:57:08,067 - INFO - Truncating table bi_atividades...
2026-06-23 21:57:08,073 - INFO - Truncating table bi_oportunidades...
2026-06-23 21:57:08,074 - INFO - Truncating table bi_propostas...
2026-06-23 21:57:08,074 - INFO - Truncating table bi_vendas...
2026-06-23 21:57:08,074 - INFO - Truncating table bi_utms...
2026-06-23 21:57:08,075 - INFO - Truncation completed.
2026-06-23 21:57:08,075 - INFO - Fetching data from source database...
2026-06-23 21:57:34,853 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-23 21:57:34,856 - INFO - Creating star schema...
2026-06-23 21:57:34,958 - INFO - Star schema created successfully.
2026-06-23 21:57:34,958 - INFO - Refreshing tables (batch mode)...
2026-06-23 21:57:34,958 - INFO - Dropping table dCanais...
2026-06-23 21:57:34,961 - INFO - Creating table dCanais from vw_dCanais...
2026-06-23 21:57:34,980 - INFO - Dropping table dCategorias...
2026-06-23 21:57:34,982 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-23 21:57:35,002 - INFO - Dropping table dConsultores...
2026-06-23 21:57:35,004 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-23 21:57:35,026 - INFO - Dropping table dEmpreendimentos...
2026-06-23 21:57:35,028 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-23 21:57:35,049 - INFO - Dropping table dEstadosCivis...
2026-06-23 21:57:35,052 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-23 21:57:35,069 - INFO - Dropping table dEtapasFunil...
2026-06-23 21:57:35,072 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-23 21:57:35,109 - INFO - Dropping table dFaixasIdade...
2026-06-23 21:57:35,111 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-23 21:57:35,132 - INFO - Dropping table dFechamentoDias...
2026-06-23 21:57:35,134 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-23 21:57:35,157 - INFO - Dropping table dInteresses...
2026-06-23 21:57:35,159 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-23 21:57:35,183 - INFO - Dropping table dMidias...
2026-06-23 21:57:35,187 - INFO - Creating table dMidias from vw_dMidias...
2026-06-23 21:57:35,209 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-23 21:57:35,211 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-23 21:57:35,228 - INFO - Dropping table dProfissoes...
2026-06-23 21:57:35,232 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-23 21:57:35,251 - INFO - Dropping table dQuartos...
2026-06-23 21:57:35,253 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-23 21:57:35,257 - INFO - Dropping table dRegioes...
2026-06-23 21:57:35,258 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-23 21:57:35,288 - INFO - Dropping table dRendas...
2026-06-23 21:57:35,289 - INFO - Creating table dRendas from vw_dRendas...
2026-06-23 21:57:35,311 - INFO - Dropping table dSexos...
2026-06-23 21:57:35,314 - INFO - Creating table dSexos from vw_dSexos...
2026-06-23 21:57:35,330 - INFO - Dropping table dStatus...
2026-06-23 21:57:35,333 - INFO - Creating table dStatus from vw_dStatus...
2026-06-23 21:57:35,347 - INFO - Dropping table dStatusAtividade...
2026-06-23 21:57:35,350 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-23 21:57:35,397 - INFO - Dropping table dStatusProposta...
2026-06-23 21:57:35,399 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-23 21:57:35,402 - INFO - Dropping table dSuites...
2026-06-23 21:57:35,404 - INFO - Creating table dSuites from vw_dSuites...
2026-06-23 21:57:35,408 - INFO - Dropping table dTemperaturas...
2026-06-23 21:57:35,411 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-23 21:57:35,423 - INFO - Dropping table dTipos...
2026-06-23 21:57:35,427 - INFO - Creating table dTipos from vw_dTipos...
2026-06-23 21:57:35,443 - INFO - Dropping table dTiposAtividade...
2026-06-23 21:57:35,446 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-23 21:57:35,476 - INFO - Dropping table dUTMSource...
2026-06-23 21:57:35,478 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-23 21:57:35,543 - INFO - Dropping table dUTMMedium...
2026-06-23 21:57:35,544 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-23 21:57:35,621 - INFO - Dropping table dUTMCampaign...
2026-06-23 21:57:35,629 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-23 21:57:35,718 - INFO - Dropping table dUTMContent...
2026-06-23 21:57:35,721 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-23 21:57:35,786 - INFO - Dropping table dUTMTerm...
2026-06-23 21:57:35,788 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-23 21:57:35,855 - INFO - Dropping table dUnidades...
2026-06-23 21:57:35,861 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-23 21:57:35,879 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-23 21:57:35,883 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-23 21:57:35,893 - INFO - Dropping table dVagas...
2026-06-23 21:57:35,895 - INFO - Creating table dVagas from vw_dVagas...
2026-06-23 21:57:35,900 - INFO - Dropping table fAcessos...
2026-06-23 21:57:35,902 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-23 21:57:36,130 - INFO - Dropping table fOportunidades...
2026-06-23 21:57:36,134 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-23 21:58:04,470 - INFO - Dropping table fAcoesFunil...
2026-06-23 21:58:04,472 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-23 21:58:35,473 - INFO - Dropping table fAtividades...
2026-06-23 21:58:35,476 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-23 21:59:47,849 - INFO - Dropping table fPropostas...
2026-06-23 21:59:47,851 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-23 21:59:48,402 - INFO - Dropping table fVendas...
2026-06-23 21:59:48,404 - INFO - Creating table fVendas from vw_fVendas...
2026-06-23 21:59:48,932 - INFO - Batch 1 completed.
2026-06-23 21:59:48,932 - INFO - All tables refreshed.
2026-06-23 21:59:48,932 - INFO - Synchronization process completed successfully in 161.1477599143982 seconds.
2026-06-23 22:57:07,792 - INFO - Creating tables by calling stored procedure...
2026-06-23 22:57:08,083 - INFO - Tables created successfully via stored procedure.
2026-06-23 22:57:08,166 - INFO - Truncating tables...
2026-06-23 22:57:08,166 - INFO - Truncating table bi_acessos...
2026-06-23 22:57:08,167 - INFO - Truncating table bi_acoes_funil...
2026-06-23 22:57:08,168 - INFO - Truncating table bi_atividades...
2026-06-23 22:57:08,175 - INFO - Truncating table bi_oportunidades...
2026-06-23 22:57:08,177 - INFO - Truncating table bi_propostas...
2026-06-23 22:57:08,177 - INFO - Truncating table bi_vendas...
2026-06-23 22:57:08,177 - INFO - Truncating table bi_utms...
2026-06-23 22:57:08,178 - INFO - Truncation completed.
2026-06-23 22:57:08,178 - INFO - Fetching data from source database...
2026-06-23 22:57:37,832 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-23 22:57:37,834 - INFO - Creating star schema...
2026-06-23 22:57:37,953 - INFO - Star schema created successfully.
2026-06-23 22:57:37,953 - INFO - Refreshing tables (batch mode)...
2026-06-23 22:57:37,954 - INFO - Dropping table dCanais...
2026-06-23 22:57:37,956 - INFO - Creating table dCanais from vw_dCanais...
2026-06-23 22:57:37,978 - INFO - Dropping table dCategorias...
2026-06-23 22:57:37,981 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-23 22:57:37,995 - INFO - Dropping table dConsultores...
2026-06-23 22:57:37,997 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-23 22:57:38,014 - INFO - Dropping table dEmpreendimentos...
2026-06-23 22:57:38,016 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-23 22:57:38,033 - INFO - Dropping table dEstadosCivis...
2026-06-23 22:57:38,034 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-23 22:57:38,050 - INFO - Dropping table dEtapasFunil...
2026-06-23 22:57:38,054 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-23 22:57:38,080 - INFO - Dropping table dFaixasIdade...
2026-06-23 22:57:38,083 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-23 22:57:38,108 - INFO - Dropping table dFechamentoDias...
2026-06-23 22:57:38,111 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-23 22:57:38,134 - INFO - Dropping table dInteresses...
2026-06-23 22:57:38,137 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-23 22:57:38,152 - INFO - Dropping table dMidias...
2026-06-23 22:57:38,155 - INFO - Creating table dMidias from vw_dMidias...
2026-06-23 22:57:38,170 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-23 22:57:38,173 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-23 22:57:38,191 - INFO - Dropping table dProfissoes...
2026-06-23 22:57:38,194 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-23 22:57:38,215 - INFO - Dropping table dQuartos...
2026-06-23 22:57:38,218 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-23 22:57:38,223 - INFO - Dropping table dRegioes...
2026-06-23 22:57:38,225 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-23 22:57:38,253 - INFO - Dropping table dRendas...
2026-06-23 22:57:38,255 - INFO - Creating table dRendas from vw_dRendas...
2026-06-23 22:57:38,268 - INFO - Dropping table dSexos...
2026-06-23 22:57:38,271 - INFO - Creating table dSexos from vw_dSexos...
2026-06-23 22:57:38,290 - INFO - Dropping table dStatus...
2026-06-23 22:57:38,293 - INFO - Creating table dStatus from vw_dStatus...
2026-06-23 22:57:38,306 - INFO - Dropping table dStatusAtividade...
2026-06-23 22:57:38,309 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-23 22:57:38,349 - INFO - Dropping table dStatusProposta...
2026-06-23 22:57:38,353 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-23 22:57:38,358 - INFO - Dropping table dSuites...
2026-06-23 22:57:38,361 - INFO - Creating table dSuites from vw_dSuites...
2026-06-23 22:57:38,365 - INFO - Dropping table dTemperaturas...
2026-06-23 22:57:38,367 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-23 22:57:38,382 - INFO - Dropping table dTipos...
2026-06-23 22:57:38,385 - INFO - Creating table dTipos from vw_dTipos...
2026-06-23 22:57:38,401 - INFO - Dropping table dTiposAtividade...
2026-06-23 22:57:38,404 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-23 22:57:38,435 - INFO - Dropping table dUTMSource...
2026-06-23 22:57:38,438 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-23 22:57:38,503 - INFO - Dropping table dUTMMedium...
2026-06-23 22:57:38,505 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-23 22:57:38,584 - INFO - Dropping table dUTMCampaign...
2026-06-23 22:57:38,587 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-23 22:57:38,661 - INFO - Dropping table dUTMContent...
2026-06-23 22:57:38,664 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-23 22:57:38,786 - INFO - Dropping table dUTMTerm...
2026-06-23 22:57:38,790 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-23 22:57:38,865 - INFO - Dropping table dUnidades...
2026-06-23 22:57:38,867 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-23 22:57:38,886 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-23 22:57:38,888 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-23 22:57:38,893 - INFO - Dropping table dVagas...
2026-06-23 22:57:38,897 - INFO - Creating table dVagas from vw_dVagas...
2026-06-23 22:57:38,901 - INFO - Dropping table fAcessos...
2026-06-23 22:57:38,904 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-23 22:57:39,224 - INFO - Dropping table fOportunidades...
2026-06-23 22:57:39,228 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-23 22:58:10,363 - INFO - Dropping table fAcoesFunil...
2026-06-23 22:58:10,373 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-23 22:58:43,953 - INFO - Dropping table fAtividades...
2026-06-23 22:58:43,956 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-23 23:00:07,348 - INFO - Dropping table fPropostas...
2026-06-23 23:00:07,351 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-23 23:00:08,038 - INFO - Dropping table fVendas...
2026-06-23 23:00:08,040 - INFO - Creating table fVendas from vw_fVendas...
2026-06-23 23:00:08,673 - INFO - Batch 1 completed.
2026-06-23 23:00:08,674 - INFO - All tables refreshed.
2026-06-23 23:00:08,674 - INFO - Synchronization process completed successfully in 180.881667137146 seconds.
2026-06-23 23:57:07,494 - INFO - Creating tables by calling stored procedure...
2026-06-23 23:57:07,686 - INFO - Tables created successfully via stored procedure.
2026-06-23 23:57:07,690 - INFO - Truncating tables...
2026-06-23 23:57:07,690 - INFO - Truncating table bi_acessos...
2026-06-23 23:57:07,691 - INFO - Truncating table bi_acoes_funil...
2026-06-23 23:57:07,766 - INFO - Truncating table bi_atividades...
2026-06-23 23:57:07,775 - INFO - Truncating table bi_oportunidades...
2026-06-23 23:57:07,777 - INFO - Truncating table bi_propostas...
2026-06-23 23:57:07,777 - INFO - Truncating table bi_vendas...
2026-06-23 23:57:07,778 - INFO - Truncating table bi_utms...
2026-06-23 23:57:07,779 - INFO - Truncation completed.
2026-06-23 23:57:07,779 - INFO - Fetching data from source database...
2026-06-23 23:57:34,358 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-23 23:57:34,359 - INFO - Creating star schema...
2026-06-23 23:57:34,438 - INFO - Star schema created successfully.
2026-06-23 23:57:34,439 - INFO - Refreshing tables (batch mode)...
2026-06-23 23:57:34,439 - INFO - Dropping table dCanais...
2026-06-23 23:57:34,441 - INFO - Creating table dCanais from vw_dCanais...
2026-06-23 23:57:34,468 - INFO - Dropping table dCategorias...
2026-06-23 23:57:34,471 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-23 23:57:34,485 - INFO - Dropping table dConsultores...
2026-06-23 23:57:34,487 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-23 23:57:34,511 - INFO - Dropping table dEmpreendimentos...
2026-06-23 23:57:34,513 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-23 23:57:34,529 - INFO - Dropping table dEstadosCivis...
2026-06-23 23:57:34,531 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-23 23:57:34,544 - INFO - Dropping table dEtapasFunil...
2026-06-23 23:57:34,546 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-23 23:57:34,575 - INFO - Dropping table dFaixasIdade...
2026-06-23 23:57:34,577 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-23 23:57:34,601 - INFO - Dropping table dFechamentoDias...
2026-06-23 23:57:34,604 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-23 23:57:34,622 - INFO - Dropping table dInteresses...
2026-06-23 23:57:34,624 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-23 23:57:34,644 - INFO - Dropping table dMidias...
2026-06-23 23:57:34,646 - INFO - Creating table dMidias from vw_dMidias...
2026-06-23 23:57:34,662 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-23 23:57:34,664 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-23 23:57:34,679 - INFO - Dropping table dProfissoes...
2026-06-23 23:57:34,680 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-23 23:57:34,696 - INFO - Dropping table dQuartos...
2026-06-23 23:57:34,699 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-23 23:57:34,703 - INFO - Dropping table dRegioes...
2026-06-23 23:57:34,705 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-23 23:57:34,727 - INFO - Dropping table dRendas...
2026-06-23 23:57:34,730 - INFO - Creating table dRendas from vw_dRendas...
2026-06-23 23:57:34,743 - INFO - Dropping table dSexos...
2026-06-23 23:57:34,746 - INFO - Creating table dSexos from vw_dSexos...
2026-06-23 23:57:34,759 - INFO - Dropping table dStatus...
2026-06-23 23:57:34,761 - INFO - Creating table dStatus from vw_dStatus...
2026-06-23 23:57:34,774 - INFO - Dropping table dStatusAtividade...
2026-06-23 23:57:34,776 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-23 23:57:34,808 - INFO - Dropping table dStatusProposta...
2026-06-23 23:57:34,810 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-23 23:57:34,814 - INFO - Dropping table dSuites...
2026-06-23 23:57:34,817 - INFO - Creating table dSuites from vw_dSuites...
2026-06-23 23:57:34,821 - INFO - Dropping table dTemperaturas...
2026-06-23 23:57:34,823 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-23 23:57:34,838 - INFO - Dropping table dTipos...
2026-06-23 23:57:34,839 - INFO - Creating table dTipos from vw_dTipos...
2026-06-23 23:57:34,857 - INFO - Dropping table dTiposAtividade...
2026-06-23 23:57:34,858 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-23 23:57:34,889 - INFO - Dropping table dUTMSource...
2026-06-23 23:57:34,891 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-23 23:57:34,949 - INFO - Dropping table dUTMMedium...
2026-06-23 23:57:34,951 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-23 23:57:35,024 - INFO - Dropping table dUTMCampaign...
2026-06-23 23:57:35,026 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-23 23:57:35,117 - INFO - Dropping table dUTMContent...
2026-06-23 23:57:35,121 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-23 23:57:35,213 - INFO - Dropping table dUTMTerm...
2026-06-23 23:57:35,215 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-23 23:57:35,290 - INFO - Dropping table dUnidades...
2026-06-23 23:57:35,292 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-23 23:57:35,314 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-23 23:57:35,316 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-23 23:57:35,321 - INFO - Dropping table dVagas...
2026-06-23 23:57:35,322 - INFO - Creating table dVagas from vw_dVagas...
2026-06-23 23:57:35,326 - INFO - Dropping table fAcessos...
2026-06-23 23:57:35,328 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-23 23:57:35,546 - INFO - Dropping table fOportunidades...
2026-06-23 23:57:35,551 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-23 23:58:02,565 - INFO - Dropping table fAcoesFunil...
2026-06-23 23:58:02,572 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-23 23:58:31,812 - INFO - Dropping table fAtividades...
2026-06-23 23:58:31,815 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-23 23:59:44,097 - INFO - Dropping table fPropostas...
2026-06-23 23:59:44,099 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-23 23:59:44,660 - INFO - Dropping table fVendas...
2026-06-23 23:59:44,661 - INFO - Creating table fVendas from vw_fVendas...
2026-06-23 23:59:45,197 - INFO - Batch 1 completed.
2026-06-23 23:59:45,198 - INFO - All tables refreshed.
2026-06-23 23:59:45,198 - INFO - Synchronization process completed successfully in 157.70320415496826 seconds.
2026-06-24 00:57:07,894 - INFO - Creating tables by calling stored procedure...
2026-06-24 00:57:08,183 - INFO - Tables created successfully via stored procedure.
2026-06-24 00:57:08,191 - INFO - Truncating tables...
2026-06-24 00:57:08,191 - INFO - Truncating table bi_acessos...
2026-06-24 00:57:08,192 - INFO - Truncating table bi_acoes_funil...
2026-06-24 00:57:08,192 - INFO - Truncating table bi_atividades...
2026-06-24 00:57:08,200 - INFO - Truncating table bi_oportunidades...
2026-06-24 00:57:08,265 - INFO - Truncating table bi_propostas...
2026-06-24 00:57:08,265 - INFO - Truncating table bi_vendas...
2026-06-24 00:57:08,266 - INFO - Truncating table bi_utms...
2026-06-24 00:57:08,267 - INFO - Truncation completed.
2026-06-24 00:57:08,267 - INFO - Fetching data from source database...
2026-06-24 00:57:34,564 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 00:57:34,566 - INFO - Creating star schema...
2026-06-24 00:57:34,647 - INFO - Star schema created successfully.
2026-06-24 00:57:34,647 - INFO - Refreshing tables (batch mode)...
2026-06-24 00:57:34,647 - INFO - Dropping table dCanais...
2026-06-24 00:57:34,656 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 00:57:34,671 - INFO - Dropping table dCategorias...
2026-06-24 00:57:34,673 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 00:57:34,687 - INFO - Dropping table dConsultores...
2026-06-24 00:57:34,689 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 00:57:34,715 - INFO - Dropping table dEmpreendimentos...
2026-06-24 00:57:34,718 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 00:57:34,741 - INFO - Dropping table dEstadosCivis...
2026-06-24 00:57:34,744 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 00:57:34,765 - INFO - Dropping table dEtapasFunil...
2026-06-24 00:57:34,767 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 00:57:34,802 - INFO - Dropping table dFaixasIdade...
2026-06-24 00:57:34,804 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 00:57:34,820 - INFO - Dropping table dFechamentoDias...
2026-06-24 00:57:34,821 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 00:57:34,849 - INFO - Dropping table dInteresses...
2026-06-24 00:57:34,851 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 00:57:34,866 - INFO - Dropping table dMidias...
2026-06-24 00:57:34,869 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 00:57:34,903 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 00:57:34,906 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 00:57:34,927 - INFO - Dropping table dProfissoes...
2026-06-24 00:57:34,931 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 00:57:34,952 - INFO - Dropping table dQuartos...
2026-06-24 00:57:34,956 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 00:57:34,960 - INFO - Dropping table dRegioes...
2026-06-24 00:57:34,963 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 00:57:34,987 - INFO - Dropping table dRendas...
2026-06-24 00:57:34,989 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 00:57:35,006 - INFO - Dropping table dSexos...
2026-06-24 00:57:35,008 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 00:57:35,030 - INFO - Dropping table dStatus...
2026-06-24 00:57:35,032 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 00:57:35,050 - INFO - Dropping table dStatusAtividade...
2026-06-24 00:57:35,052 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 00:57:35,091 - INFO - Dropping table dStatusProposta...
2026-06-24 00:57:35,093 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 00:57:35,098 - INFO - Dropping table dSuites...
2026-06-24 00:57:35,100 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 00:57:35,105 - INFO - Dropping table dTemperaturas...
2026-06-24 00:57:35,108 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 00:57:35,126 - INFO - Dropping table dTipos...
2026-06-24 00:57:35,129 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 00:57:35,144 - INFO - Dropping table dTiposAtividade...
2026-06-24 00:57:35,146 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 00:57:35,175 - INFO - Dropping table dUTMSource...
2026-06-24 00:57:35,177 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 00:57:35,252 - INFO - Dropping table dUTMMedium...
2026-06-24 00:57:35,254 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 00:57:35,318 - INFO - Dropping table dUTMCampaign...
2026-06-24 00:57:35,320 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 00:57:35,383 - INFO - Dropping table dUTMContent...
2026-06-24 00:57:35,385 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 00:57:35,471 - INFO - Dropping table dUTMTerm...
2026-06-24 00:57:35,472 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 00:57:35,556 - INFO - Dropping table dUnidades...
2026-06-24 00:57:35,561 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 00:57:35,586 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 00:57:35,588 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 00:57:35,594 - INFO - Dropping table dVagas...
2026-06-24 00:57:35,595 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 00:57:35,599 - INFO - Dropping table fAcessos...
2026-06-24 00:57:35,601 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 00:57:35,917 - INFO - Dropping table fOportunidades...
2026-06-24 00:57:35,919 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 00:58:03,046 - INFO - Dropping table fAcoesFunil...
2026-06-24 00:58:03,050 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 00:58:32,860 - INFO - Dropping table fAtividades...
2026-06-24 00:58:32,864 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 00:59:42,810 - INFO - Dropping table fPropostas...
2026-06-24 00:59:42,812 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 00:59:43,553 - INFO - Dropping table fVendas...
2026-06-24 00:59:43,555 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 00:59:44,093 - INFO - Batch 1 completed.
2026-06-24 00:59:44,093 - INFO - All tables refreshed.
2026-06-24 00:59:44,093 - INFO - Synchronization process completed successfully in 156.1990897655487 seconds.
2026-06-24 01:57:07,591 - INFO - Creating tables by calling stored procedure...
2026-06-24 01:57:07,790 - INFO - Tables created successfully via stored procedure.
2026-06-24 01:57:07,792 - INFO - Truncating tables...
2026-06-24 01:57:07,792 - INFO - Truncating table bi_acessos...
2026-06-24 01:57:07,794 - INFO - Truncating table bi_acoes_funil...
2026-06-24 01:57:07,796 - INFO - Truncating table bi_atividades...
2026-06-24 01:57:07,882 - INFO - Truncating table bi_oportunidades...
2026-06-24 01:57:07,884 - INFO - Truncating table bi_propostas...
2026-06-24 01:57:07,885 - INFO - Truncating table bi_vendas...
2026-06-24 01:57:07,885 - INFO - Truncating table bi_utms...
2026-06-24 01:57:07,887 - INFO - Truncation completed.
2026-06-24 01:57:07,887 - INFO - Fetching data from source database...
2026-06-24 01:57:38,326 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 01:57:38,328 - INFO - Creating star schema...
2026-06-24 01:57:38,428 - INFO - Star schema created successfully.
2026-06-24 01:57:38,428 - INFO - Refreshing tables (batch mode)...
2026-06-24 01:57:38,428 - INFO - Dropping table dCanais...
2026-06-24 01:57:38,430 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 01:57:38,456 - INFO - Dropping table dCategorias...
2026-06-24 01:57:38,458 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 01:57:38,487 - INFO - Dropping table dConsultores...
2026-06-24 01:57:38,492 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 01:57:38,523 - INFO - Dropping table dEmpreendimentos...
2026-06-24 01:57:38,526 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 01:57:38,549 - INFO - Dropping table dEstadosCivis...
2026-06-24 01:57:38,552 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 01:57:38,580 - INFO - Dropping table dEtapasFunil...
2026-06-24 01:57:38,584 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 01:57:38,634 - INFO - Dropping table dFaixasIdade...
2026-06-24 01:57:38,636 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 01:57:38,666 - INFO - Dropping table dFechamentoDias...
2026-06-24 01:57:38,672 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 01:57:38,698 - INFO - Dropping table dInteresses...
2026-06-24 01:57:38,703 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 01:57:38,721 - INFO - Dropping table dMidias...
2026-06-24 01:57:38,725 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 01:57:38,750 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 01:57:38,754 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 01:57:38,769 - INFO - Dropping table dProfissoes...
2026-06-24 01:57:38,772 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 01:57:38,795 - INFO - Dropping table dQuartos...
2026-06-24 01:57:38,797 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 01:57:38,803 - INFO - Dropping table dRegioes...
2026-06-24 01:57:38,805 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 01:57:38,847 - INFO - Dropping table dRendas...
2026-06-24 01:57:38,850 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 01:57:38,867 - INFO - Dropping table dSexos...
2026-06-24 01:57:38,871 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 01:57:38,886 - INFO - Dropping table dStatus...
2026-06-24 01:57:38,888 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 01:57:38,904 - INFO - Dropping table dStatusAtividade...
2026-06-24 01:57:38,906 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 01:57:38,967 - INFO - Dropping table dStatusProposta...
2026-06-24 01:57:38,970 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 01:57:38,976 - INFO - Dropping table dSuites...
2026-06-24 01:57:38,980 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 01:57:38,984 - INFO - Dropping table dTemperaturas...
2026-06-24 01:57:38,986 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 01:57:39,001 - INFO - Dropping table dTipos...
2026-06-24 01:57:39,004 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 01:57:39,027 - INFO - Dropping table dTiposAtividade...
2026-06-24 01:57:39,029 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 01:57:39,061 - INFO - Dropping table dUTMSource...
2026-06-24 01:57:39,064 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 01:57:39,142 - INFO - Dropping table dUTMMedium...
2026-06-24 01:57:39,145 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 01:57:39,235 - INFO - Dropping table dUTMCampaign...
2026-06-24 01:57:39,238 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 01:57:39,347 - INFO - Dropping table dUTMContent...
2026-06-24 01:57:39,352 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 01:57:39,456 - INFO - Dropping table dUTMTerm...
2026-06-24 01:57:39,459 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 01:57:39,534 - INFO - Dropping table dUnidades...
2026-06-24 01:57:39,537 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 01:57:39,570 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 01:57:39,572 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 01:57:39,578 - INFO - Dropping table dVagas...
2026-06-24 01:57:39,580 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 01:57:39,584 - INFO - Dropping table fAcessos...
2026-06-24 01:57:39,587 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 01:57:39,916 - INFO - Dropping table fOportunidades...
2026-06-24 01:57:39,919 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 01:58:09,928 - INFO - Dropping table fAcoesFunil...
2026-06-24 01:58:09,930 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 01:58:42,240 - INFO - Dropping table fAtividades...
2026-06-24 01:58:42,244 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 01:59:54,666 - INFO - Dropping table fPropostas...
2026-06-24 01:59:54,668 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 01:59:55,227 - INFO - Dropping table fVendas...
2026-06-24 01:59:55,229 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 01:59:55,775 - INFO - Batch 1 completed.
2026-06-24 01:59:55,775 - INFO - All tables refreshed.
2026-06-24 01:59:55,775 - INFO - Synchronization process completed successfully in 168.18465280532837 seconds.
2026-06-24 02:57:08,188 - INFO - Creating tables by calling stored procedure...
2026-06-24 02:57:08,393 - INFO - Tables created successfully via stored procedure.
2026-06-24 02:57:08,396 - INFO - Truncating tables...
2026-06-24 02:57:08,396 - INFO - Truncating table bi_acessos...
2026-06-24 02:57:08,396 - INFO - Truncating table bi_acoes_funil...
2026-06-24 02:57:08,397 - INFO - Truncating table bi_atividades...
2026-06-24 02:57:08,404 - INFO - Truncating table bi_oportunidades...
2026-06-24 02:57:08,405 - INFO - Truncating table bi_propostas...
2026-06-24 02:57:08,405 - INFO - Truncating table bi_vendas...
2026-06-24 02:57:08,405 - INFO - Truncating table bi_utms...
2026-06-24 02:57:08,406 - INFO - Truncation completed.
2026-06-24 02:57:08,406 - INFO - Fetching data from source database...
2026-06-24 02:57:35,254 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 02:57:35,256 - INFO - Creating star schema...
2026-06-24 02:57:35,343 - INFO - Star schema created successfully.
2026-06-24 02:57:35,343 - INFO - Refreshing tables (batch mode)...
2026-06-24 02:57:35,344 - INFO - Dropping table dCanais...
2026-06-24 02:57:35,345 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 02:57:35,359 - INFO - Dropping table dCategorias...
2026-06-24 02:57:35,361 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 02:57:35,375 - INFO - Dropping table dConsultores...
2026-06-24 02:57:35,378 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 02:57:35,415 - INFO - Dropping table dEmpreendimentos...
2026-06-24 02:57:35,418 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 02:57:35,441 - INFO - Dropping table dEstadosCivis...
2026-06-24 02:57:35,444 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 02:57:35,465 - INFO - Dropping table dEtapasFunil...
2026-06-24 02:57:35,466 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 02:57:35,503 - INFO - Dropping table dFaixasIdade...
2026-06-24 02:57:35,506 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 02:57:35,523 - INFO - Dropping table dFechamentoDias...
2026-06-24 02:57:35,525 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 02:57:35,551 - INFO - Dropping table dInteresses...
2026-06-24 02:57:35,554 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 02:57:35,580 - INFO - Dropping table dMidias...
2026-06-24 02:57:35,584 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 02:57:35,609 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 02:57:35,611 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 02:57:35,630 - INFO - Dropping table dProfissoes...
2026-06-24 02:57:35,632 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 02:57:35,645 - INFO - Dropping table dQuartos...
2026-06-24 02:57:35,647 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 02:57:35,652 - INFO - Dropping table dRegioes...
2026-06-24 02:57:35,655 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 02:57:35,679 - INFO - Dropping table dRendas...
2026-06-24 02:57:35,681 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 02:57:35,705 - INFO - Dropping table dSexos...
2026-06-24 02:57:35,706 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 02:57:35,727 - INFO - Dropping table dStatus...
2026-06-24 02:57:35,729 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 02:57:35,744 - INFO - Dropping table dStatusAtividade...
2026-06-24 02:57:35,747 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 02:57:35,783 - INFO - Dropping table dStatusProposta...
2026-06-24 02:57:35,786 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 02:57:35,791 - INFO - Dropping table dSuites...
2026-06-24 02:57:35,793 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 02:57:35,797 - INFO - Dropping table dTemperaturas...
2026-06-24 02:57:35,799 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 02:57:35,811 - INFO - Dropping table dTipos...
2026-06-24 02:57:35,813 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 02:57:35,834 - INFO - Dropping table dTiposAtividade...
2026-06-24 02:57:35,837 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 02:57:35,875 - INFO - Dropping table dUTMSource...
2026-06-24 02:57:35,878 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 02:57:35,961 - INFO - Dropping table dUTMMedium...
2026-06-24 02:57:35,965 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 02:57:36,027 - INFO - Dropping table dUTMCampaign...
2026-06-24 02:57:36,029 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 02:57:36,107 - INFO - Dropping table dUTMContent...
2026-06-24 02:57:36,109 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 02:57:36,205 - INFO - Dropping table dUTMTerm...
2026-06-24 02:57:36,208 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 02:57:36,286 - INFO - Dropping table dUnidades...
2026-06-24 02:57:36,288 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 02:57:36,313 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 02:57:36,316 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 02:57:36,321 - INFO - Dropping table dVagas...
2026-06-24 02:57:36,323 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 02:57:36,327 - INFO - Dropping table fAcessos...
2026-06-24 02:57:36,330 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 02:57:36,660 - INFO - Dropping table fOportunidades...
2026-06-24 02:57:36,674 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 02:58:05,797 - INFO - Dropping table fAcoesFunil...
2026-06-24 02:58:05,806 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 02:58:35,329 - INFO - Dropping table fAtividades...
2026-06-24 02:58:35,333 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 02:59:48,607 - INFO - Dropping table fPropostas...
2026-06-24 02:59:48,610 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 02:59:49,164 - INFO - Dropping table fVendas...
2026-06-24 02:59:49,165 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 02:59:49,726 - INFO - Batch 1 completed.
2026-06-24 02:59:49,726 - INFO - All tables refreshed.
2026-06-24 02:59:49,726 - INFO - Synchronization process completed successfully in 161.5380346775055 seconds.
2026-06-24 03:57:07,774 - INFO - Creating tables by calling stored procedure...
2026-06-24 03:57:07,968 - INFO - Tables created successfully via stored procedure.
2026-06-24 03:57:07,970 - INFO - Truncating tables...
2026-06-24 03:57:07,970 - INFO - Truncating table bi_acessos...
2026-06-24 03:57:07,971 - INFO - Truncating table bi_acoes_funil...
2026-06-24 03:57:07,972 - INFO - Truncating table bi_atividades...
2026-06-24 03:57:07,980 - INFO - Truncating table bi_oportunidades...
2026-06-24 03:57:07,981 - INFO - Truncating table bi_propostas...
2026-06-24 03:57:07,982 - INFO - Truncating table bi_vendas...
2026-06-24 03:57:07,983 - INFO - Truncating table bi_utms...
2026-06-24 03:57:07,984 - INFO - Truncation completed.
2026-06-24 03:57:07,984 - INFO - Fetching data from source database...
2026-06-24 03:57:35,451 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 03:57:35,453 - INFO - Creating star schema...
2026-06-24 03:57:35,537 - INFO - Star schema created successfully.
2026-06-24 03:57:35,537 - INFO - Refreshing tables (batch mode)...
2026-06-24 03:57:35,538 - INFO - Dropping table dCanais...
2026-06-24 03:57:35,542 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 03:57:35,559 - INFO - Dropping table dCategorias...
2026-06-24 03:57:35,563 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 03:57:35,592 - INFO - Dropping table dConsultores...
2026-06-24 03:57:35,595 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 03:57:35,613 - INFO - Dropping table dEmpreendimentos...
2026-06-24 03:57:35,616 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 03:57:35,639 - INFO - Dropping table dEstadosCivis...
2026-06-24 03:57:35,644 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 03:57:35,665 - INFO - Dropping table dEtapasFunil...
2026-06-24 03:57:35,668 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 03:57:35,706 - INFO - Dropping table dFaixasIdade...
2026-06-24 03:57:35,709 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 03:57:35,729 - INFO - Dropping table dFechamentoDias...
2026-06-24 03:57:35,733 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 03:57:35,765 - INFO - Dropping table dInteresses...
2026-06-24 03:57:35,769 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 03:57:35,790 - INFO - Dropping table dMidias...
2026-06-24 03:57:35,792 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 03:57:35,816 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 03:57:35,819 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 03:57:35,845 - INFO - Dropping table dProfissoes...
2026-06-24 03:57:35,848 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 03:57:35,862 - INFO - Dropping table dQuartos...
2026-06-24 03:57:35,865 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 03:57:35,870 - INFO - Dropping table dRegioes...
2026-06-24 03:57:35,873 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 03:57:35,906 - INFO - Dropping table dRendas...
2026-06-24 03:57:35,910 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 03:57:35,932 - INFO - Dropping table dSexos...
2026-06-24 03:57:35,934 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 03:57:35,953 - INFO - Dropping table dStatus...
2026-06-24 03:57:35,956 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 03:57:35,971 - INFO - Dropping table dStatusAtividade...
2026-06-24 03:57:35,974 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 03:57:36,026 - INFO - Dropping table dStatusProposta...
2026-06-24 03:57:36,029 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 03:57:36,034 - INFO - Dropping table dSuites...
2026-06-24 03:57:36,037 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 03:57:36,046 - INFO - Dropping table dTemperaturas...
2026-06-24 03:57:36,048 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 03:57:36,064 - INFO - Dropping table dTipos...
2026-06-24 03:57:36,069 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 03:57:36,091 - INFO - Dropping table dTiposAtividade...
2026-06-24 03:57:36,093 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 03:57:36,125 - INFO - Dropping table dUTMSource...
2026-06-24 03:57:36,128 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 03:57:36,197 - INFO - Dropping table dUTMMedium...
2026-06-24 03:57:36,199 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 03:57:36,281 - INFO - Dropping table dUTMCampaign...
2026-06-24 03:57:36,283 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 03:57:36,361 - INFO - Dropping table dUTMContent...
2026-06-24 03:57:36,364 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 03:57:36,429 - INFO - Dropping table dUTMTerm...
2026-06-24 03:57:36,431 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 03:57:36,511 - INFO - Dropping table dUnidades...
2026-06-24 03:57:36,513 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 03:57:36,533 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 03:57:36,535 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 03:57:36,539 - INFO - Dropping table dVagas...
2026-06-24 03:57:36,541 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 03:57:36,552 - INFO - Dropping table fAcessos...
2026-06-24 03:57:36,557 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 03:57:36,899 - INFO - Dropping table fOportunidades...
2026-06-24 03:57:36,905 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 03:58:05,929 - INFO - Dropping table fAcoesFunil...
2026-06-24 03:58:05,934 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 03:58:35,823 - INFO - Dropping table fAtividades...
2026-06-24 03:58:35,829 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 03:59:49,359 - INFO - Dropping table fPropostas...
2026-06-24 03:59:49,361 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 03:59:49,940 - INFO - Dropping table fVendas...
2026-06-24 03:59:49,942 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 03:59:50,532 - INFO - Batch 1 completed.
2026-06-24 03:59:50,532 - INFO - All tables refreshed.
2026-06-24 03:59:50,532 - INFO - Synchronization process completed successfully in 162.75779962539673 seconds.
2026-06-24 04:57:09,038 - INFO - Creating tables by calling stored procedure...
2026-06-24 04:57:09,236 - INFO - Tables created successfully via stored procedure.
2026-06-24 04:57:09,238 - INFO - Truncating tables...
2026-06-24 04:57:09,238 - INFO - Truncating table bi_acessos...
2026-06-24 04:57:09,239 - INFO - Truncating table bi_acoes_funil...
2026-06-24 04:57:09,239 - INFO - Truncating table bi_atividades...
2026-06-24 04:57:09,247 - INFO - Truncating table bi_oportunidades...
2026-06-24 04:57:09,250 - INFO - Truncating table bi_propostas...
2026-06-24 04:57:09,316 - INFO - Truncating table bi_vendas...
2026-06-24 04:57:09,317 - INFO - Truncating table bi_utms...
2026-06-24 04:57:09,319 - INFO - Truncation completed.
2026-06-24 04:57:09,319 - INFO - Fetching data from source database...
2026-06-24 04:57:39,337 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 04:57:39,340 - INFO - Creating star schema...
2026-06-24 04:57:39,448 - INFO - Star schema created successfully.
2026-06-24 04:57:39,448 - INFO - Refreshing tables (batch mode)...
2026-06-24 04:57:39,449 - INFO - Dropping table dCanais...
2026-06-24 04:57:39,456 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 04:57:39,475 - INFO - Dropping table dCategorias...
2026-06-24 04:57:39,479 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 04:57:39,498 - INFO - Dropping table dConsultores...
2026-06-24 04:57:39,501 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 04:57:39,529 - INFO - Dropping table dEmpreendimentos...
2026-06-24 04:57:39,532 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 04:57:39,553 - INFO - Dropping table dEstadosCivis...
2026-06-24 04:57:39,557 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 04:57:39,577 - INFO - Dropping table dEtapasFunil...
2026-06-24 04:57:39,582 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 04:57:39,608 - INFO - Dropping table dFaixasIdade...
2026-06-24 04:57:39,612 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 04:57:39,635 - INFO - Dropping table dFechamentoDias...
2026-06-24 04:57:39,639 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 04:57:39,661 - INFO - Dropping table dInteresses...
2026-06-24 04:57:39,664 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 04:57:39,684 - INFO - Dropping table dMidias...
2026-06-24 04:57:39,688 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 04:57:39,710 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 04:57:39,717 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 04:57:39,735 - INFO - Dropping table dProfissoes...
2026-06-24 04:57:39,739 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 04:57:39,760 - INFO - Dropping table dQuartos...
2026-06-24 04:57:39,767 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 04:57:39,773 - INFO - Dropping table dRegioes...
2026-06-24 04:57:39,775 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 04:57:39,814 - INFO - Dropping table dRendas...
2026-06-24 04:57:39,818 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 04:57:39,835 - INFO - Dropping table dSexos...
2026-06-24 04:57:39,840 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 04:57:39,869 - INFO - Dropping table dStatus...
2026-06-24 04:57:39,873 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 04:57:39,894 - INFO - Dropping table dStatusAtividade...
2026-06-24 04:57:39,897 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 04:57:39,935 - INFO - Dropping table dStatusProposta...
2026-06-24 04:57:39,939 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 04:57:39,945 - INFO - Dropping table dSuites...
2026-06-24 04:57:39,950 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 04:57:39,955 - INFO - Dropping table dTemperaturas...
2026-06-24 04:57:39,959 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 04:57:39,981 - INFO - Dropping table dTipos...
2026-06-24 04:57:39,986 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 04:57:40,021 - INFO - Dropping table dTiposAtividade...
2026-06-24 04:57:40,028 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 04:57:40,081 - INFO - Dropping table dUTMSource...
2026-06-24 04:57:40,087 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 04:57:40,165 - INFO - Dropping table dUTMMedium...
2026-06-24 04:57:40,168 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 04:57:40,241 - INFO - Dropping table dUTMCampaign...
2026-06-24 04:57:40,246 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 04:57:40,331 - INFO - Dropping table dUTMContent...
2026-06-24 04:57:40,334 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 04:57:40,438 - INFO - Dropping table dUTMTerm...
2026-06-24 04:57:40,442 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 04:57:40,513 - INFO - Dropping table dUnidades...
2026-06-24 04:57:40,517 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 04:57:40,534 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 04:57:40,541 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 04:57:40,547 - INFO - Dropping table dVagas...
2026-06-24 04:57:40,552 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 04:57:40,555 - INFO - Dropping table fAcessos...
2026-06-24 04:57:40,558 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 04:57:40,824 - INFO - Dropping table fOportunidades...
2026-06-24 04:57:40,834 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 04:58:11,661 - INFO - Dropping table fAcoesFunil...
2026-06-24 04:58:11,665 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 04:58:44,802 - INFO - Dropping table fAtividades...
2026-06-24 04:58:44,806 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 05:00:00,781 - INFO - Dropping table fPropostas...
2026-06-24 05:00:00,785 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 05:00:01,407 - INFO - Dropping table fVendas...
2026-06-24 05:00:01,410 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 05:00:03,782 - INFO - Batch 1 completed.
2026-06-24 05:00:03,782 - INFO - All tables refreshed.
2026-06-24 05:00:03,782 - INFO - Synchronization process completed successfully in 174.74426889419556 seconds.
2026-06-24 05:57:09,642 - INFO - Creating tables by calling stored procedure...
2026-06-24 05:57:09,926 - INFO - Tables created successfully via stored procedure.
2026-06-24 05:57:10,003 - INFO - Truncating tables...
2026-06-24 05:57:10,004 - INFO - Truncating table bi_acessos...
2026-06-24 05:57:10,018 - INFO - Truncating table bi_acoes_funil...
2026-06-24 05:57:10,019 - INFO - Truncating table bi_atividades...
2026-06-24 05:57:10,021 - INFO - Truncating table bi_oportunidades...
2026-06-24 05:57:10,033 - INFO - Truncating table bi_propostas...
2026-06-24 05:57:10,034 - INFO - Truncating table bi_vendas...
2026-06-24 05:57:10,037 - INFO - Truncating table bi_utms...
2026-06-24 05:57:10,048 - INFO - Truncation completed.
2026-06-24 05:57:10,048 - INFO - Fetching data from source database...
2026-06-24 05:57:45,384 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 05:57:45,385 - INFO - Creating star schema...
2026-06-24 05:57:45,596 - INFO - Star schema created successfully.
2026-06-24 05:57:45,596 - INFO - Refreshing tables (batch mode)...
2026-06-24 05:57:45,596 - INFO - Dropping table dCanais...
2026-06-24 05:57:45,600 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 05:57:45,628 - INFO - Dropping table dCategorias...
2026-06-24 05:57:45,636 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 05:57:45,672 - INFO - Dropping table dConsultores...
2026-06-24 05:57:45,677 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 05:57:45,714 - INFO - Dropping table dEmpreendimentos...
2026-06-24 05:57:45,727 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 05:57:45,765 - INFO - Dropping table dEstadosCivis...
2026-06-24 05:57:45,773 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 05:57:45,796 - INFO - Dropping table dEtapasFunil...
2026-06-24 05:57:45,803 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 05:57:45,878 - INFO - Dropping table dFaixasIdade...
2026-06-24 05:57:45,882 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 05:57:45,907 - INFO - Dropping table dFechamentoDias...
2026-06-24 05:57:45,927 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 05:57:45,971 - INFO - Dropping table dInteresses...
2026-06-24 05:57:45,976 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 05:57:45,996 - INFO - Dropping table dMidias...
2026-06-24 05:57:46,000 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 05:57:46,050 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 05:57:46,054 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 05:57:46,075 - INFO - Dropping table dProfissoes...
2026-06-24 05:57:46,079 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 05:57:46,101 - INFO - Dropping table dQuartos...
2026-06-24 05:57:46,111 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 05:57:46,121 - INFO - Dropping table dRegioes...
2026-06-24 05:57:46,129 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 05:57:46,176 - INFO - Dropping table dRendas...
2026-06-24 05:57:46,181 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 05:57:46,206 - INFO - Dropping table dSexos...
2026-06-24 05:57:46,214 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 05:57:46,260 - INFO - Dropping table dStatus...
2026-06-24 05:57:46,264 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 05:57:46,276 - INFO - Dropping table dStatusAtividade...
2026-06-24 05:57:46,279 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 05:57:46,336 - INFO - Dropping table dStatusProposta...
2026-06-24 05:57:46,341 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 05:57:46,350 - INFO - Dropping table dSuites...
2026-06-24 05:57:46,354 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 05:57:46,359 - INFO - Dropping table dTemperaturas...
2026-06-24 05:57:46,364 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 05:57:46,377 - INFO - Dropping table dTipos...
2026-06-24 05:57:46,381 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 05:57:46,417 - INFO - Dropping table dTiposAtividade...
2026-06-24 05:57:46,422 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 05:57:46,463 - INFO - Dropping table dUTMSource...
2026-06-24 05:57:46,468 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 05:57:46,557 - INFO - Dropping table dUTMMedium...
2026-06-24 05:57:46,562 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 05:57:46,665 - INFO - Dropping table dUTMCampaign...
2026-06-24 05:57:46,668 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 05:57:46,770 - INFO - Dropping table dUTMContent...
2026-06-24 05:57:46,774 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 05:57:46,875 - INFO - Dropping table dUTMTerm...
2026-06-24 05:57:46,879 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 05:57:46,991 - INFO - Dropping table dUnidades...
2026-06-24 05:57:46,995 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 05:57:47,023 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 05:57:47,035 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 05:57:47,047 - INFO - Dropping table dVagas...
2026-06-24 05:57:47,052 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 05:57:47,056 - INFO - Dropping table fAcessos...
2026-06-24 05:57:47,064 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 05:57:47,488 - INFO - Dropping table fOportunidades...
2026-06-24 05:57:47,495 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 05:58:20,837 - INFO - Dropping table fAcoesFunil...
2026-06-24 05:58:20,849 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 05:58:54,451 - INFO - Dropping table fAtividades...
2026-06-24 05:58:54,455 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 06:00:27,816 - INFO - Dropping table fPropostas...
2026-06-24 06:00:27,820 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 06:00:28,537 - INFO - Dropping table fVendas...
2026-06-24 06:00:28,541 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 06:00:29,197 - INFO - Batch 1 completed.
2026-06-24 06:00:29,198 - INFO - All tables refreshed.
2026-06-24 06:00:29,198 - INFO - Synchronization process completed successfully in 199.55607390403748 seconds.
2026-06-24 06:57:10,139 - INFO - Creating tables by calling stored procedure...
2026-06-24 06:57:10,351 - INFO - Tables created successfully via stored procedure.
2026-06-24 06:57:10,419 - INFO - Truncating tables...
2026-06-24 06:57:10,425 - INFO - Truncating table bi_acessos...
2026-06-24 06:57:10,428 - INFO - Truncating table bi_acoes_funil...
2026-06-24 06:57:10,434 - INFO - Truncating table bi_atividades...
2026-06-24 06:57:10,436 - INFO - Truncating table bi_oportunidades...
2026-06-24 06:57:10,440 - INFO - Truncating table bi_propostas...
2026-06-24 06:57:10,441 - INFO - Truncating table bi_vendas...
2026-06-24 06:57:10,445 - INFO - Truncating table bi_utms...
2026-06-24 06:57:10,447 - INFO - Truncation completed.
2026-06-24 06:57:10,454 - INFO - Fetching data from source database...
2026-06-24 06:57:44,205 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 06:57:44,208 - INFO - Creating star schema...
2026-06-24 06:57:44,400 - INFO - Star schema created successfully.
2026-06-24 06:57:44,401 - INFO - Refreshing tables (batch mode)...
2026-06-24 06:57:44,401 - INFO - Dropping table dCanais...
2026-06-24 06:57:44,420 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 06:57:44,458 - INFO - Dropping table dCategorias...
2026-06-24 06:57:44,462 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 06:57:44,478 - INFO - Dropping table dConsultores...
2026-06-24 06:57:44,484 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 06:57:44,547 - INFO - Dropping table dEmpreendimentos...
2026-06-24 06:57:44,555 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 06:57:44,583 - INFO - Dropping table dEstadosCivis...
2026-06-24 06:57:44,592 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 06:57:44,627 - INFO - Dropping table dEtapasFunil...
2026-06-24 06:57:44,650 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 06:57:44,691 - INFO - Dropping table dFaixasIdade...
2026-06-24 06:57:44,694 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 06:57:44,728 - INFO - Dropping table dFechamentoDias...
2026-06-24 06:57:44,745 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 06:57:44,772 - INFO - Dropping table dInteresses...
2026-06-24 06:57:44,775 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 06:57:44,792 - INFO - Dropping table dMidias...
2026-06-24 06:57:44,795 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 06:57:44,824 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 06:57:44,830 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 06:57:44,861 - INFO - Dropping table dProfissoes...
2026-06-24 06:57:44,864 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 06:57:44,878 - INFO - Dropping table dQuartos...
2026-06-24 06:57:44,881 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 06:57:44,885 - INFO - Dropping table dRegioes...
2026-06-24 06:57:44,888 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 06:57:44,932 - INFO - Dropping table dRendas...
2026-06-24 06:57:44,938 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 06:57:44,965 - INFO - Dropping table dSexos...
2026-06-24 06:57:44,968 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 06:57:44,985 - INFO - Dropping table dStatus...
2026-06-24 06:57:44,990 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 06:57:45,013 - INFO - Dropping table dStatusAtividade...
2026-06-24 06:57:45,020 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 06:57:45,067 - INFO - Dropping table dStatusProposta...
2026-06-24 06:57:45,075 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 06:57:45,080 - INFO - Dropping table dSuites...
2026-06-24 06:57:45,083 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 06:57:45,089 - INFO - Dropping table dTemperaturas...
2026-06-24 06:57:45,092 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 06:57:45,136 - INFO - Dropping table dTipos...
2026-06-24 06:57:45,156 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 06:57:45,174 - INFO - Dropping table dTiposAtividade...
2026-06-24 06:57:45,178 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 06:57:45,227 - INFO - Dropping table dUTMSource...
2026-06-24 06:57:45,244 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 06:57:45,322 - INFO - Dropping table dUTMMedium...
2026-06-24 06:57:45,325 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 06:57:45,440 - INFO - Dropping table dUTMCampaign...
2026-06-24 06:57:45,452 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 06:57:45,569 - INFO - Dropping table dUTMContent...
2026-06-24 06:57:45,571 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 06:57:45,663 - INFO - Dropping table dUTMTerm...
2026-06-24 06:57:45,666 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 06:57:45,792 - INFO - Dropping table dUnidades...
2026-06-24 06:57:45,795 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 06:57:45,832 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 06:57:45,853 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 06:57:45,860 - INFO - Dropping table dVagas...
2026-06-24 06:57:45,863 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 06:57:45,868 - INFO - Dropping table fAcessos...
2026-06-24 06:57:45,871 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 06:57:46,401 - INFO - Dropping table fOportunidades...
2026-06-24 06:57:46,410 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 06:58:19,734 - INFO - Dropping table fAcoesFunil...
2026-06-24 06:58:19,739 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 06:58:55,102 - INFO - Dropping table fAtividades...
2026-06-24 06:58:55,110 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 07:00:25,113 - INFO - Dropping table fPropostas...
2026-06-24 07:00:25,117 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 07:00:25,764 - INFO - Dropping table fVendas...
2026-06-24 07:00:25,768 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 07:00:26,386 - INFO - Batch 1 completed.
2026-06-24 07:00:26,386 - INFO - All tables refreshed.
2026-06-24 07:00:26,386 - INFO - Synchronization process completed successfully in 196.24691081047058 seconds.
2026-06-24 07:57:10,109 - INFO - Creating tables by calling stored procedure...
2026-06-24 07:57:10,317 - INFO - Tables created successfully via stored procedure.
2026-06-24 07:57:10,319 - INFO - Truncating tables...
2026-06-24 07:57:10,320 - INFO - Truncating table bi_acessos...
2026-06-24 07:57:10,322 - INFO - Truncating table bi_acoes_funil...
2026-06-24 07:57:10,323 - INFO - Truncating table bi_atividades...
2026-06-24 07:57:10,327 - INFO - Truncating table bi_oportunidades...
2026-06-24 07:57:10,330 - INFO - Truncating table bi_propostas...
2026-06-24 07:57:10,331 - INFO - Truncating table bi_vendas...
2026-06-24 07:57:10,331 - INFO - Truncating table bi_utms...
2026-06-24 07:57:10,333 - INFO - Truncation completed.
2026-06-24 07:57:10,333 - INFO - Fetching data from source database...
2026-06-24 07:57:41,626 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 07:57:41,629 - INFO - Creating star schema...
2026-06-24 07:57:41,775 - INFO - Star schema created successfully.
2026-06-24 07:57:41,775 - INFO - Refreshing tables (batch mode)...
2026-06-24 07:57:41,776 - INFO - Dropping table dCanais...
2026-06-24 07:57:41,781 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 07:57:41,802 - INFO - Dropping table dCategorias...
2026-06-24 07:57:41,806 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 07:57:41,819 - INFO - Dropping table dConsultores...
2026-06-24 07:57:41,823 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 07:57:41,840 - INFO - Dropping table dEmpreendimentos...
2026-06-24 07:57:41,843 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 07:57:41,860 - INFO - Dropping table dEstadosCivis...
2026-06-24 07:57:41,864 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 07:57:41,880 - INFO - Dropping table dEtapasFunil...
2026-06-24 07:57:41,900 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 07:57:41,951 - INFO - Dropping table dFaixasIdade...
2026-06-24 07:57:41,959 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 07:57:41,986 - INFO - Dropping table dFechamentoDias...
2026-06-24 07:57:41,996 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 07:57:42,032 - INFO - Dropping table dInteresses...
2026-06-24 07:57:42,038 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 07:57:42,064 - INFO - Dropping table dMidias...
2026-06-24 07:57:42,068 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 07:57:42,093 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 07:57:42,104 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 07:57:42,134 - INFO - Dropping table dProfissoes...
2026-06-24 07:57:42,138 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 07:57:42,154 - INFO - Dropping table dQuartos...
2026-06-24 07:57:42,161 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 07:57:42,172 - INFO - Dropping table dRegioes...
2026-06-24 07:57:42,180 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 07:57:42,232 - INFO - Dropping table dRendas...
2026-06-24 07:57:42,236 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 07:57:42,257 - INFO - Dropping table dSexos...
2026-06-24 07:57:42,266 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 07:57:42,292 - INFO - Dropping table dStatus...
2026-06-24 07:57:42,300 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 07:57:42,315 - INFO - Dropping table dStatusAtividade...
2026-06-24 07:57:42,327 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 07:57:42,386 - INFO - Dropping table dStatusProposta...
2026-06-24 07:57:42,397 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 07:57:42,406 - INFO - Dropping table dSuites...
2026-06-24 07:57:42,414 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 07:57:42,422 - INFO - Dropping table dTemperaturas...
2026-06-24 07:57:42,432 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 07:57:42,456 - INFO - Dropping table dTipos...
2026-06-24 07:57:42,461 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 07:57:42,476 - INFO - Dropping table dTiposAtividade...
2026-06-24 07:57:42,479 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 07:57:42,531 - INFO - Dropping table dUTMSource...
2026-06-24 07:57:42,535 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 07:57:42,624 - INFO - Dropping table dUTMMedium...
2026-06-24 07:57:42,628 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 07:57:42,738 - INFO - Dropping table dUTMCampaign...
2026-06-24 07:57:42,755 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 07:57:42,862 - INFO - Dropping table dUTMContent...
2026-06-24 07:57:42,869 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 07:57:42,978 - INFO - Dropping table dUTMTerm...
2026-06-24 07:57:42,982 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 07:57:43,112 - INFO - Dropping table dUnidades...
2026-06-24 07:57:43,122 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 07:57:43,148 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 07:57:43,161 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 07:57:43,169 - INFO - Dropping table dVagas...
2026-06-24 07:57:43,177 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 07:57:43,186 - INFO - Dropping table fAcessos...
2026-06-24 07:57:43,192 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 07:57:43,500 - INFO - Dropping table fOportunidades...
2026-06-24 07:57:43,505 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 07:58:14,880 - INFO - Dropping table fAcoesFunil...
2026-06-24 07:58:14,890 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 07:58:47,825 - INFO - Dropping table fAtividades...
2026-06-24 07:58:47,834 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 08:00:11,088 - INFO - Dropping table fPropostas...
2026-06-24 08:00:11,092 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 08:00:11,834 - INFO - Dropping table fVendas...
2026-06-24 08:00:11,844 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 08:00:12,585 - INFO - Batch 1 completed.
2026-06-24 08:00:12,585 - INFO - All tables refreshed.
2026-06-24 08:00:12,585 - INFO - Synchronization process completed successfully in 182.47582077980042 seconds.
2026-06-24 08:57:12,015 - INFO - Creating tables by calling stored procedure...
2026-06-24 08:57:12,310 - INFO - Tables created successfully via stored procedure.
2026-06-24 08:57:12,312 - INFO - Truncating tables...
2026-06-24 08:57:12,312 - INFO - Truncating table bi_acessos...
2026-06-24 08:57:12,315 - INFO - Truncating table bi_acoes_funil...
2026-06-24 08:57:12,316 - INFO - Truncating table bi_atividades...
2026-06-24 08:57:12,318 - INFO - Truncating table bi_oportunidades...
2026-06-24 08:57:12,320 - INFO - Truncating table bi_propostas...
2026-06-24 08:57:12,321 - INFO - Truncating table bi_vendas...
2026-06-24 08:57:12,322 - INFO - Truncating table bi_utms...
2026-06-24 08:57:12,323 - INFO - Truncation completed.
2026-06-24 08:57:12,323 - INFO - Fetching data from source database...
2026-06-24 08:57:42,958 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 08:57:42,961 - INFO - Creating star schema...
2026-06-24 08:57:43,099 - INFO - Star schema created successfully.
2026-06-24 08:57:43,099 - INFO - Refreshing tables (batch mode)...
2026-06-24 08:57:43,099 - INFO - Dropping table dCanais...
2026-06-24 08:57:43,104 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 08:57:43,121 - INFO - Dropping table dCategorias...
2026-06-24 08:57:43,125 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 08:57:43,140 - INFO - Dropping table dConsultores...
2026-06-24 08:57:43,144 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 08:57:43,167 - INFO - Dropping table dEmpreendimentos...
2026-06-24 08:57:43,178 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 08:57:43,201 - INFO - Dropping table dEstadosCivis...
2026-06-24 08:57:43,205 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 08:57:43,221 - INFO - Dropping table dEtapasFunil...
2026-06-24 08:57:43,225 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 08:57:43,272 - INFO - Dropping table dFaixasIdade...
2026-06-24 08:57:43,276 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 08:57:43,304 - INFO - Dropping table dFechamentoDias...
2026-06-24 08:57:43,308 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 08:57:43,332 - INFO - Dropping table dInteresses...
2026-06-24 08:57:43,336 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 08:57:43,360 - INFO - Dropping table dMidias...
2026-06-24 08:57:43,367 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 08:57:43,382 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 08:57:43,386 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 08:57:43,403 - INFO - Dropping table dProfissoes...
2026-06-24 08:57:43,407 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 08:57:43,421 - INFO - Dropping table dQuartos...
2026-06-24 08:57:43,426 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 08:57:43,431 - INFO - Dropping table dRegioes...
2026-06-24 08:57:43,435 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 08:57:43,458 - INFO - Dropping table dRendas...
2026-06-24 08:57:43,462 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 08:57:43,483 - INFO - Dropping table dSexos...
2026-06-24 08:57:43,488 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 08:57:43,506 - INFO - Dropping table dStatus...
2026-06-24 08:57:43,510 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 08:57:43,527 - INFO - Dropping table dStatusAtividade...
2026-06-24 08:57:43,531 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 08:57:43,649 - INFO - Dropping table dStatusProposta...
2026-06-24 08:57:43,659 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 08:57:43,664 - INFO - Dropping table dSuites...
2026-06-24 08:57:43,668 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 08:57:43,674 - INFO - Dropping table dTemperaturas...
2026-06-24 08:57:43,678 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 08:57:43,708 - INFO - Dropping table dTipos...
2026-06-24 08:57:43,712 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 08:57:43,741 - INFO - Dropping table dTiposAtividade...
2026-06-24 08:57:43,745 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 08:57:43,795 - INFO - Dropping table dUTMSource...
2026-06-24 08:57:43,798 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 08:57:43,871 - INFO - Dropping table dUTMMedium...
2026-06-24 08:57:43,874 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 08:57:43,944 - INFO - Dropping table dUTMCampaign...
2026-06-24 08:57:43,948 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 08:57:44,053 - INFO - Dropping table dUTMContent...
2026-06-24 08:57:44,057 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 08:57:44,174 - INFO - Dropping table dUTMTerm...
2026-06-24 08:57:44,179 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 08:57:44,273 - INFO - Dropping table dUnidades...
2026-06-24 08:57:44,277 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 08:57:44,302 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 08:57:44,305 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 08:57:44,311 - INFO - Dropping table dVagas...
2026-06-24 08:57:44,315 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 08:57:44,319 - INFO - Dropping table fAcessos...
2026-06-24 08:57:44,323 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 08:57:44,713 - INFO - Dropping table fOportunidades...
2026-06-24 08:57:44,718 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 08:58:16,180 - INFO - Dropping table fAcoesFunil...
2026-06-24 08:58:16,185 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 08:58:50,002 - INFO - Dropping table fAtividades...
2026-06-24 08:58:50,018 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 09:00:12,181 - INFO - Dropping table fPropostas...
2026-06-24 09:00:12,215 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 09:00:12,828 - INFO - Dropping table fVendas...
2026-06-24 09:00:12,835 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 09:00:13,386 - INFO - Batch 1 completed.
2026-06-24 09:00:13,386 - INFO - All tables refreshed.
2026-06-24 09:00:13,386 - INFO - Synchronization process completed successfully in 181.37025260925293 seconds.
2026-06-24 09:57:09,715 - INFO - Creating tables by calling stored procedure...
2026-06-24 09:57:10,016 - INFO - Tables created successfully via stored procedure.
2026-06-24 09:57:10,022 - INFO - Truncating tables...
2026-06-24 09:57:10,022 - INFO - Truncating table bi_acessos...
2026-06-24 09:57:10,023 - INFO - Truncating table bi_acoes_funil...
2026-06-24 09:57:10,024 - INFO - Truncating table bi_atividades...
2026-06-24 09:57:10,026 - INFO - Truncating table bi_oportunidades...
2026-06-24 09:57:10,027 - INFO - Truncating table bi_propostas...
2026-06-24 09:57:10,028 - INFO - Truncating table bi_vendas...
2026-06-24 09:57:10,029 - INFO - Truncating table bi_utms...
2026-06-24 09:57:10,030 - INFO - Truncation completed.
2026-06-24 09:57:10,030 - INFO - Fetching data from source database...
2026-06-24 09:57:36,800 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 09:57:36,802 - INFO - Creating star schema...
2026-06-24 09:57:36,914 - INFO - Star schema created successfully.
2026-06-24 09:57:36,914 - INFO - Refreshing tables (batch mode)...
2026-06-24 09:57:36,914 - INFO - Dropping table dCanais...
2026-06-24 09:57:36,918 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 09:57:36,938 - INFO - Dropping table dCategorias...
2026-06-24 09:57:36,942 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 09:57:36,963 - INFO - Dropping table dConsultores...
2026-06-24 09:57:36,967 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 09:57:36,989 - INFO - Dropping table dEmpreendimentos...
2026-06-24 09:57:36,992 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 09:57:37,016 - INFO - Dropping table dEstadosCivis...
2026-06-24 09:57:37,019 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 09:57:37,036 - INFO - Dropping table dEtapasFunil...
2026-06-24 09:57:37,040 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 09:57:37,073 - INFO - Dropping table dFaixasIdade...
2026-06-24 09:57:37,080 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 09:57:37,106 - INFO - Dropping table dFechamentoDias...
2026-06-24 09:57:37,110 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 09:57:37,130 - INFO - Dropping table dInteresses...
2026-06-24 09:57:37,134 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 09:57:37,153 - INFO - Dropping table dMidias...
2026-06-24 09:57:37,157 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 09:57:37,173 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 09:57:37,177 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 09:57:37,199 - INFO - Dropping table dProfissoes...
2026-06-24 09:57:37,202 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 09:57:37,222 - INFO - Dropping table dQuartos...
2026-06-24 09:57:37,226 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 09:57:37,232 - INFO - Dropping table dRegioes...
2026-06-24 09:57:37,236 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 09:57:37,260 - INFO - Dropping table dRendas...
2026-06-24 09:57:37,264 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 09:57:37,278 - INFO - Dropping table dSexos...
2026-06-24 09:57:37,283 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 09:57:37,297 - INFO - Dropping table dStatus...
2026-06-24 09:57:37,300 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 09:57:37,313 - INFO - Dropping table dStatusAtividade...
2026-06-24 09:57:37,317 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 09:57:37,350 - INFO - Dropping table dStatusProposta...
2026-06-24 09:57:37,356 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 09:57:37,360 - INFO - Dropping table dSuites...
2026-06-24 09:57:37,365 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 09:57:37,370 - INFO - Dropping table dTemperaturas...
2026-06-24 09:57:37,373 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 09:57:37,388 - INFO - Dropping table dTipos...
2026-06-24 09:57:37,391 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 09:57:37,405 - INFO - Dropping table dTiposAtividade...
2026-06-24 09:57:37,409 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 09:57:37,458 - INFO - Dropping table dUTMSource...
2026-06-24 09:57:37,461 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 09:57:37,525 - INFO - Dropping table dUTMMedium...
2026-06-24 09:57:37,532 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 09:57:37,603 - INFO - Dropping table dUTMCampaign...
2026-06-24 09:57:37,608 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 09:57:37,676 - INFO - Dropping table dUTMContent...
2026-06-24 09:57:37,680 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 09:57:37,762 - INFO - Dropping table dUTMTerm...
2026-06-24 09:57:37,766 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 09:57:37,838 - INFO - Dropping table dUnidades...
2026-06-24 09:57:37,841 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 09:57:37,856 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 09:57:37,859 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 09:57:37,864 - INFO - Dropping table dVagas...
2026-06-24 09:57:37,867 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 09:57:37,872 - INFO - Dropping table fAcessos...
2026-06-24 09:57:37,875 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 09:57:38,133 - INFO - Dropping table fOportunidades...
2026-06-24 09:57:38,140 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 09:58:06,105 - INFO - Dropping table fAcoesFunil...
2026-06-24 09:58:06,114 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 09:58:35,641 - INFO - Dropping table fAtividades...
2026-06-24 09:58:35,645 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 09:59:44,887 - INFO - Dropping table fPropostas...
2026-06-24 09:59:44,890 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 09:59:45,651 - INFO - Dropping table fVendas...
2026-06-24 09:59:45,658 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 09:59:46,182 - INFO - Batch 1 completed.
2026-06-24 09:59:46,184 - INFO - All tables refreshed.
2026-06-24 09:59:46,197 - INFO - Synchronization process completed successfully in 156.48209762573242 seconds.
2026-06-24 10:57:07,812 - INFO - Creating tables by calling stored procedure...
2026-06-24 10:57:08,028 - INFO - Tables created successfully via stored procedure.
2026-06-24 10:57:08,031 - INFO - Truncating tables...
2026-06-24 10:57:08,031 - INFO - Truncating table bi_acessos...
2026-06-24 10:57:08,032 - INFO - Truncating table bi_acoes_funil...
2026-06-24 10:57:08,033 - INFO - Truncating table bi_atividades...
2026-06-24 10:57:08,038 - INFO - Truncating table bi_oportunidades...
2026-06-24 10:57:08,039 - INFO - Truncating table bi_propostas...
2026-06-24 10:57:08,040 - INFO - Truncating table bi_vendas...
2026-06-24 10:57:08,106 - INFO - Truncating table bi_utms...
2026-06-24 10:57:08,109 - INFO - Truncation completed.
2026-06-24 10:57:08,109 - INFO - Fetching data from source database...
2026-06-24 10:57:37,966 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 10:57:37,969 - INFO - Creating star schema...
2026-06-24 10:57:38,102 - INFO - Star schema created successfully.
2026-06-24 10:57:38,102 - INFO - Refreshing tables (batch mode)...
2026-06-24 10:57:38,103 - INFO - Dropping table dCanais...
2026-06-24 10:57:38,106 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 10:57:38,130 - INFO - Dropping table dCategorias...
2026-06-24 10:57:38,134 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 10:57:38,153 - INFO - Dropping table dConsultores...
2026-06-24 10:57:38,157 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 10:57:38,181 - INFO - Dropping table dEmpreendimentos...
2026-06-24 10:57:38,185 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 10:57:38,213 - INFO - Dropping table dEstadosCivis...
2026-06-24 10:57:38,225 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 10:57:38,246 - INFO - Dropping table dEtapasFunil...
2026-06-24 10:57:38,250 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 10:57:38,282 - INFO - Dropping table dFaixasIdade...
2026-06-24 10:57:38,285 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 10:57:38,314 - INFO - Dropping table dFechamentoDias...
2026-06-24 10:57:38,317 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 10:57:38,343 - INFO - Dropping table dInteresses...
2026-06-24 10:57:38,348 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 10:57:38,370 - INFO - Dropping table dMidias...
2026-06-24 10:57:38,379 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 10:57:38,393 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 10:57:38,398 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 10:57:38,424 - INFO - Dropping table dProfissoes...
2026-06-24 10:57:38,427 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 10:57:38,451 - INFO - Dropping table dQuartos...
2026-06-24 10:57:38,455 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 10:57:38,460 - INFO - Dropping table dRegioes...
2026-06-24 10:57:38,468 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 10:57:38,509 - INFO - Dropping table dRendas...
2026-06-24 10:57:38,514 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 10:57:38,535 - INFO - Dropping table dSexos...
2026-06-24 10:57:38,539 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 10:57:38,558 - INFO - Dropping table dStatus...
2026-06-24 10:57:38,562 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 10:57:38,586 - INFO - Dropping table dStatusAtividade...
2026-06-24 10:57:38,590 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 10:57:38,645 - INFO - Dropping table dStatusProposta...
2026-06-24 10:57:38,648 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 10:57:38,654 - INFO - Dropping table dSuites...
2026-06-24 10:57:38,656 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 10:57:38,661 - INFO - Dropping table dTemperaturas...
2026-06-24 10:57:38,667 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 10:57:38,682 - INFO - Dropping table dTipos...
2026-06-24 10:57:38,686 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 10:57:38,721 - INFO - Dropping table dTiposAtividade...
2026-06-24 10:57:38,729 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 10:57:38,783 - INFO - Dropping table dUTMSource...
2026-06-24 10:57:38,796 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 10:57:38,876 - INFO - Dropping table dUTMMedium...
2026-06-24 10:57:38,879 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 10:57:38,964 - INFO - Dropping table dUTMCampaign...
2026-06-24 10:57:38,967 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 10:57:39,073 - INFO - Dropping table dUTMContent...
2026-06-24 10:57:39,076 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 10:57:39,179 - INFO - Dropping table dUTMTerm...
2026-06-24 10:57:39,187 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 10:57:39,299 - INFO - Dropping table dUnidades...
2026-06-24 10:57:39,303 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 10:57:39,341 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 10:57:39,345 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 10:57:39,351 - INFO - Dropping table dVagas...
2026-06-24 10:57:39,355 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 10:57:39,365 - INFO - Dropping table fAcessos...
2026-06-24 10:57:39,369 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 10:57:39,790 - INFO - Dropping table fOportunidades...
2026-06-24 10:57:39,793 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 10:58:10,734 - INFO - Dropping table fAcoesFunil...
2026-06-24 10:58:10,737 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 10:58:43,898 - INFO - Dropping table fAtividades...
2026-06-24 10:58:43,907 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 11:00:00,576 - INFO - Dropping table fPropostas...
2026-06-24 11:00:00,580 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 11:00:01,506 - INFO - Dropping table fVendas...
2026-06-24 11:00:01,521 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 11:00:03,446 - INFO - Batch 1 completed.
2026-06-24 11:00:03,446 - INFO - All tables refreshed.
2026-06-24 11:00:03,446 - INFO - Synchronization process completed successfully in 175.6337652206421 seconds.
2026-06-24 11:57:09,114 - INFO - Creating tables by calling stored procedure...
2026-06-24 11:57:09,417 - INFO - Tables created successfully via stored procedure.
2026-06-24 11:57:09,420 - INFO - Truncating tables...
2026-06-24 11:57:09,420 - INFO - Truncating table bi_acessos...
2026-06-24 11:57:09,428 - INFO - Truncating table bi_acoes_funil...
2026-06-24 11:57:09,429 - INFO - Truncating table bi_atividades...
2026-06-24 11:57:09,435 - INFO - Truncating table bi_oportunidades...
2026-06-24 11:57:09,436 - INFO - Truncating table bi_propostas...
2026-06-24 11:57:09,504 - INFO - Truncating table bi_vendas...
2026-06-24 11:57:09,505 - INFO - Truncating table bi_utms...
2026-06-24 11:57:09,506 - INFO - Truncation completed.
2026-06-24 11:57:09,506 - INFO - Fetching data from source database...
2026-06-24 11:57:36,274 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 11:57:36,276 - INFO - Creating star schema...
2026-06-24 11:57:36,394 - INFO - Star schema created successfully.
2026-06-24 11:57:36,395 - INFO - Refreshing tables (batch mode)...
2026-06-24 11:57:36,395 - INFO - Dropping table dCanais...
2026-06-24 11:57:36,398 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 11:57:36,414 - INFO - Dropping table dCategorias...
2026-06-24 11:57:36,417 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 11:57:36,439 - INFO - Dropping table dConsultores...
2026-06-24 11:57:36,443 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 11:57:36,469 - INFO - Dropping table dEmpreendimentos...
2026-06-24 11:57:36,473 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 11:57:36,493 - INFO - Dropping table dEstadosCivis...
2026-06-24 11:57:36,496 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 11:57:36,517 - INFO - Dropping table dEtapasFunil...
2026-06-24 11:57:36,520 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 11:57:36,549 - INFO - Dropping table dFaixasIdade...
2026-06-24 11:57:36,553 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 11:57:36,569 - INFO - Dropping table dFechamentoDias...
2026-06-24 11:57:36,573 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 11:57:36,590 - INFO - Dropping table dInteresses...
2026-06-24 11:57:36,594 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 11:57:36,611 - INFO - Dropping table dMidias...
2026-06-24 11:57:36,614 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 11:57:36,645 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 11:57:36,649 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 11:57:36,666 - INFO - Dropping table dProfissoes...
2026-06-24 11:57:36,669 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 11:57:36,689 - INFO - Dropping table dQuartos...
2026-06-24 11:57:36,692 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 11:57:36,695 - INFO - Dropping table dRegioes...
2026-06-24 11:57:36,697 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 11:57:36,718 - INFO - Dropping table dRendas...
2026-06-24 11:57:36,721 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 11:57:36,734 - INFO - Dropping table dSexos...
2026-06-24 11:57:36,737 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 11:57:36,754 - INFO - Dropping table dStatus...
2026-06-24 11:57:36,759 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 11:57:36,772 - INFO - Dropping table dStatusAtividade...
2026-06-24 11:57:36,776 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 11:57:36,815 - INFO - Dropping table dStatusProposta...
2026-06-24 11:57:36,819 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 11:57:36,825 - INFO - Dropping table dSuites...
2026-06-24 11:57:36,828 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 11:57:36,832 - INFO - Dropping table dTemperaturas...
2026-06-24 11:57:36,835 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 11:57:36,854 - INFO - Dropping table dTipos...
2026-06-24 11:57:36,858 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 11:57:36,874 - INFO - Dropping table dTiposAtividade...
2026-06-24 11:57:36,877 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 11:57:36,905 - INFO - Dropping table dUTMSource...
2026-06-24 11:57:36,908 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 11:57:36,980 - INFO - Dropping table dUTMMedium...
2026-06-24 11:57:36,987 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 11:57:37,057 - INFO - Dropping table dUTMCampaign...
2026-06-24 11:57:37,059 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 11:57:37,120 - INFO - Dropping table dUTMContent...
2026-06-24 11:57:37,123 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 11:57:37,186 - INFO - Dropping table dUTMTerm...
2026-06-24 11:57:37,189 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 11:57:37,290 - INFO - Dropping table dUnidades...
2026-06-24 11:57:37,294 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 11:57:37,308 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 11:57:37,312 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 11:57:37,317 - INFO - Dropping table dVagas...
2026-06-24 11:57:37,320 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 11:57:37,323 - INFO - Dropping table fAcessos...
2026-06-24 11:57:37,325 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 11:57:37,620 - INFO - Dropping table fOportunidades...
2026-06-24 11:57:37,632 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 11:58:04,796 - INFO - Dropping table fAcoesFunil...
2026-06-24 11:58:04,799 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 11:58:34,981 - INFO - Dropping table fAtividades...
2026-06-24 11:58:34,983 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 11:59:47,330 - INFO - Dropping table fPropostas...
2026-06-24 11:59:47,333 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 11:59:48,071 - INFO - Dropping table fVendas...
2026-06-24 11:59:48,074 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 11:59:48,746 - INFO - Batch 1 completed.
2026-06-24 11:59:48,746 - INFO - All tables refreshed.
2026-06-24 11:59:48,746 - INFO - Synchronization process completed successfully in 159.63171076774597 seconds.
2026-06-24 12:57:07,713 - INFO - Creating tables by calling stored procedure...
2026-06-24 12:57:07,921 - INFO - Tables created successfully via stored procedure.
2026-06-24 12:57:07,924 - INFO - Truncating tables...
2026-06-24 12:57:07,924 - INFO - Truncating table bi_acessos...
2026-06-24 12:57:07,925 - INFO - Truncating table bi_acoes_funil...
2026-06-24 12:57:07,926 - INFO - Truncating table bi_atividades...
2026-06-24 12:57:07,927 - INFO - Truncating table bi_oportunidades...
2026-06-24 12:57:07,927 - INFO - Truncating table bi_propostas...
2026-06-24 12:57:07,928 - INFO - Truncating table bi_vendas...
2026-06-24 12:57:07,930 - INFO - Truncating table bi_utms...
2026-06-24 12:57:07,934 - INFO - Truncation completed.
2026-06-24 12:57:07,934 - INFO - Fetching data from source database...
2026-06-24 12:57:39,323 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 12:57:39,326 - INFO - Creating star schema...
2026-06-24 12:57:39,471 - INFO - Star schema created successfully.
2026-06-24 12:57:39,471 - INFO - Refreshing tables (batch mode)...
2026-06-24 12:57:39,472 - INFO - Dropping table dCanais...
2026-06-24 12:57:39,475 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 12:57:39,491 - INFO - Dropping table dCategorias...
2026-06-24 12:57:39,496 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 12:57:39,518 - INFO - Dropping table dConsultores...
2026-06-24 12:57:39,523 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 12:57:39,560 - INFO - Dropping table dEmpreendimentos...
2026-06-24 12:57:39,563 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 12:57:39,592 - INFO - Dropping table dEstadosCivis...
2026-06-24 12:57:39,607 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 12:57:39,636 - INFO - Dropping table dEtapasFunil...
2026-06-24 12:57:39,644 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 12:57:39,703 - INFO - Dropping table dFaixasIdade...
2026-06-24 12:57:39,716 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 12:57:39,746 - INFO - Dropping table dFechamentoDias...
2026-06-24 12:57:39,749 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 12:57:39,779 - INFO - Dropping table dInteresses...
2026-06-24 12:57:39,787 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 12:57:39,817 - INFO - Dropping table dMidias...
2026-06-24 12:57:39,822 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 12:57:39,875 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 12:57:39,879 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 12:57:39,906 - INFO - Dropping table dProfissoes...
2026-06-24 12:57:39,911 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 12:57:39,937 - INFO - Dropping table dQuartos...
2026-06-24 12:57:39,944 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 12:57:39,960 - INFO - Dropping table dRegioes...
2026-06-24 12:57:39,970 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 12:57:40,037 - INFO - Dropping table dRendas...
2026-06-24 12:57:40,046 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 12:57:40,094 - INFO - Dropping table dSexos...
2026-06-24 12:57:40,103 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 12:57:40,135 - INFO - Dropping table dStatus...
2026-06-24 12:57:40,140 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 12:57:40,155 - INFO - Dropping table dStatusAtividade...
2026-06-24 12:57:40,168 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 12:57:40,222 - INFO - Dropping table dStatusProposta...
2026-06-24 12:57:40,227 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 12:57:40,253 - INFO - Dropping table dSuites...
2026-06-24 12:57:40,270 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 12:57:40,292 - INFO - Dropping table dTemperaturas...
2026-06-24 12:57:40,295 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 12:57:40,320 - INFO - Dropping table dTipos...
2026-06-24 12:57:40,332 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 12:57:40,361 - INFO - Dropping table dTiposAtividade...
2026-06-24 12:57:40,366 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 12:57:40,424 - INFO - Dropping table dUTMSource...
2026-06-24 12:57:40,433 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 12:57:40,527 - INFO - Dropping table dUTMMedium...
2026-06-24 12:57:40,533 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 12:57:40,633 - INFO - Dropping table dUTMCampaign...
2026-06-24 12:57:40,638 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 12:57:40,725 - INFO - Dropping table dUTMContent...
2026-06-24 12:57:40,729 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 12:57:40,817 - INFO - Dropping table dUTMTerm...
2026-06-24 12:57:40,822 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 12:57:40,915 - INFO - Dropping table dUnidades...
2026-06-24 12:57:40,925 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 12:57:40,952 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 12:57:40,958 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 12:57:40,969 - INFO - Dropping table dVagas...
2026-06-24 12:57:40,973 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 12:57:40,979 - INFO - Dropping table fAcessos...
2026-06-24 12:57:40,983 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 12:57:41,389 - INFO - Dropping table fOportunidades...
2026-06-24 12:57:41,393 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 12:58:13,913 - INFO - Dropping table fAcoesFunil...
2026-06-24 12:58:13,918 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 12:58:48,105 - INFO - Dropping table fAtividades...
2026-06-24 12:58:48,119 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 13:00:19,097 - INFO - Dropping table fPropostas...
2026-06-24 13:00:19,101 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 13:00:19,842 - INFO - Dropping table fVendas...
2026-06-24 13:00:19,846 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 13:00:20,454 - INFO - Batch 1 completed.
2026-06-24 13:00:20,454 - INFO - All tables refreshed.
2026-06-24 13:00:20,454 - INFO - Synchronization process completed successfully in 192.74130845069885 seconds.
2026-06-24 13:57:09,830 - INFO - Creating tables by calling stored procedure...
2026-06-24 13:57:10,111 - INFO - Tables created successfully via stored procedure.
2026-06-24 13:57:10,118 - INFO - Truncating tables...
2026-06-24 13:57:10,118 - INFO - Truncating table bi_acessos...
2026-06-24 13:57:10,122 - INFO - Truncating table bi_acoes_funil...
2026-06-24 13:57:10,123 - INFO - Truncating table bi_atividades...
2026-06-24 13:57:10,124 - INFO - Truncating table bi_oportunidades...
2026-06-24 13:57:10,125 - INFO - Truncating table bi_propostas...
2026-06-24 13:57:10,126 - INFO - Truncating table bi_vendas...
2026-06-24 13:57:10,126 - INFO - Truncating table bi_utms...
2026-06-24 13:57:10,127 - INFO - Truncation completed.
2026-06-24 13:57:10,127 - INFO - Fetching data from source database...
2026-06-24 13:57:37,607 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 13:57:37,609 - INFO - Creating star schema...
2026-06-24 13:57:37,745 - INFO - Star schema created successfully.
2026-06-24 13:57:37,745 - INFO - Refreshing tables (batch mode)...
2026-06-24 13:57:37,746 - INFO - Dropping table dCanais...
2026-06-24 13:57:37,750 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 13:57:37,766 - INFO - Dropping table dCategorias...
2026-06-24 13:57:37,770 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 13:57:37,788 - INFO - Dropping table dConsultores...
2026-06-24 13:57:37,793 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 13:57:37,820 - INFO - Dropping table dEmpreendimentos...
2026-06-24 13:57:37,829 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 13:57:37,851 - INFO - Dropping table dEstadosCivis...
2026-06-24 13:57:37,854 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 13:57:37,869 - INFO - Dropping table dEtapasFunil...
2026-06-24 13:57:37,873 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 13:57:37,909 - INFO - Dropping table dFaixasIdade...
2026-06-24 13:57:37,913 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 13:57:37,933 - INFO - Dropping table dFechamentoDias...
2026-06-24 13:57:37,937 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 13:57:37,969 - INFO - Dropping table dInteresses...
2026-06-24 13:57:37,972 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 13:57:37,997 - INFO - Dropping table dMidias...
2026-06-24 13:57:38,003 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 13:57:38,019 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 13:57:38,023 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 13:57:38,039 - INFO - Dropping table dProfissoes...
2026-06-24 13:57:38,042 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 13:57:38,057 - INFO - Dropping table dQuartos...
2026-06-24 13:57:38,060 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 13:57:38,065 - INFO - Dropping table dRegioes...
2026-06-24 13:57:38,068 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 13:57:38,090 - INFO - Dropping table dRendas...
2026-06-24 13:57:38,099 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 13:57:38,115 - INFO - Dropping table dSexos...
2026-06-24 13:57:38,119 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 13:57:38,134 - INFO - Dropping table dStatus...
2026-06-24 13:57:38,137 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 13:57:38,150 - INFO - Dropping table dStatusAtividade...
2026-06-24 13:57:38,153 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 13:57:38,199 - INFO - Dropping table dStatusProposta...
2026-06-24 13:57:38,203 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 13:57:38,208 - INFO - Dropping table dSuites...
2026-06-24 13:57:38,212 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 13:57:38,218 - INFO - Dropping table dTemperaturas...
2026-06-24 13:57:38,222 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 13:57:38,238 - INFO - Dropping table dTipos...
2026-06-24 13:57:38,242 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 13:57:38,258 - INFO - Dropping table dTiposAtividade...
2026-06-24 13:57:38,261 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 13:57:38,295 - INFO - Dropping table dUTMSource...
2026-06-24 13:57:38,298 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 13:57:38,401 - INFO - Dropping table dUTMMedium...
2026-06-24 13:57:38,406 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 13:57:38,494 - INFO - Dropping table dUTMCampaign...
2026-06-24 13:57:38,499 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 13:57:38,573 - INFO - Dropping table dUTMContent...
2026-06-24 13:57:38,577 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 13:57:38,658 - INFO - Dropping table dUTMTerm...
2026-06-24 13:57:38,662 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 13:57:38,731 - INFO - Dropping table dUnidades...
2026-06-24 13:57:38,734 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 13:57:38,750 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 13:57:38,755 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 13:57:38,759 - INFO - Dropping table dVagas...
2026-06-24 13:57:38,763 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 13:57:38,767 - INFO - Dropping table fAcessos...
2026-06-24 13:57:38,771 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 13:57:39,067 - INFO - Dropping table fOportunidades...
2026-06-24 13:57:39,071 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 13:58:07,246 - INFO - Dropping table fAcoesFunil...
2026-06-24 13:58:07,249 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 13:58:37,179 - INFO - Dropping table fAtividades...
2026-06-24 13:58:37,183 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 13:59:50,250 - INFO - Dropping table fPropostas...
2026-06-24 13:59:50,255 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 13:59:50,935 - INFO - Dropping table fVendas...
2026-06-24 13:59:50,939 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 13:59:51,487 - INFO - Batch 1 completed.
2026-06-24 13:59:51,487 - INFO - All tables refreshed.
2026-06-24 13:59:51,487 - INFO - Synchronization process completed successfully in 161.65724515914917 seconds.
2026-06-24 14:57:07,529 - INFO - Creating tables by calling stored procedure...
2026-06-24 14:57:07,717 - INFO - Tables created successfully via stored procedure.
2026-06-24 14:57:07,720 - INFO - Truncating tables...
2026-06-24 14:57:07,720 - INFO - Truncating table bi_acessos...
2026-06-24 14:57:07,721 - INFO - Truncating table bi_acoes_funil...
2026-06-24 14:57:07,722 - INFO - Truncating table bi_atividades...
2026-06-24 14:57:07,722 - INFO - Truncating table bi_oportunidades...
2026-06-24 14:57:07,723 - INFO - Truncating table bi_propostas...
2026-06-24 14:57:07,723 - INFO - Truncating table bi_vendas...
2026-06-24 14:57:07,724 - INFO - Truncating table bi_utms...
2026-06-24 14:57:07,725 - INFO - Truncation completed.
2026-06-24 14:57:07,725 - INFO - Fetching data from source database...
2026-06-24 14:57:36,715 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 14:57:36,717 - INFO - Creating star schema...
2026-06-24 14:57:36,822 - INFO - Star schema created successfully.
2026-06-24 14:57:36,822 - INFO - Refreshing tables (batch mode)...
2026-06-24 14:57:36,823 - INFO - Dropping table dCanais...
2026-06-24 14:57:36,827 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 14:57:36,841 - INFO - Dropping table dCategorias...
2026-06-24 14:57:36,845 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 14:57:36,860 - INFO - Dropping table dConsultores...
2026-06-24 14:57:36,865 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 14:57:36,883 - INFO - Dropping table dEmpreendimentos...
2026-06-24 14:57:36,886 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 14:57:36,903 - INFO - Dropping table dEstadosCivis...
2026-06-24 14:57:36,907 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 14:57:36,931 - INFO - Dropping table dEtapasFunil...
2026-06-24 14:57:36,936 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 14:57:36,965 - INFO - Dropping table dFaixasIdade...
2026-06-24 14:57:36,969 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 14:57:36,987 - INFO - Dropping table dFechamentoDias...
2026-06-24 14:57:36,993 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 14:57:37,015 - INFO - Dropping table dInteresses...
2026-06-24 14:57:37,019 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 14:57:37,041 - INFO - Dropping table dMidias...
2026-06-24 14:57:37,045 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 14:57:37,072 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 14:57:37,076 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 14:57:37,106 - INFO - Dropping table dProfissoes...
2026-06-24 14:57:37,110 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 14:57:37,132 - INFO - Dropping table dQuartos...
2026-06-24 14:57:37,135 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 14:57:37,143 - INFO - Dropping table dRegioes...
2026-06-24 14:57:37,146 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 14:57:37,168 - INFO - Dropping table dRendas...
2026-06-24 14:57:37,171 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 14:57:37,193 - INFO - Dropping table dSexos...
2026-06-24 14:57:37,198 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 14:57:37,213 - INFO - Dropping table dStatus...
2026-06-24 14:57:37,217 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 14:57:37,256 - INFO - Dropping table dStatusAtividade...
2026-06-24 14:57:37,261 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 14:57:37,320 - INFO - Dropping table dStatusProposta...
2026-06-24 14:57:37,323 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 14:57:37,329 - INFO - Dropping table dSuites...
2026-06-24 14:57:37,333 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 14:57:37,339 - INFO - Dropping table dTemperaturas...
2026-06-24 14:57:37,343 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 14:57:37,362 - INFO - Dropping table dTipos...
2026-06-24 14:57:37,367 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 14:57:37,387 - INFO - Dropping table dTiposAtividade...
2026-06-24 14:57:37,394 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 14:57:37,426 - INFO - Dropping table dUTMSource...
2026-06-24 14:57:37,431 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 14:57:37,517 - INFO - Dropping table dUTMMedium...
2026-06-24 14:57:37,520 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 14:57:37,610 - INFO - Dropping table dUTMCampaign...
2026-06-24 14:57:37,614 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 14:57:37,687 - INFO - Dropping table dUTMContent...
2026-06-24 14:57:37,689 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 14:57:37,776 - INFO - Dropping table dUTMTerm...
2026-06-24 14:57:37,780 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 14:57:37,875 - INFO - Dropping table dUnidades...
2026-06-24 14:57:37,880 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 14:57:37,897 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 14:57:37,901 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 14:57:37,906 - INFO - Dropping table dVagas...
2026-06-24 14:57:37,909 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 14:57:37,913 - INFO - Dropping table fAcessos...
2026-06-24 14:57:37,916 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 14:57:38,357 - INFO - Dropping table fOportunidades...
2026-06-24 14:57:38,364 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 14:58:08,931 - INFO - Dropping table fAcoesFunil...
2026-06-24 14:58:08,936 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 14:58:41,806 - INFO - Dropping table fAtividades...
2026-06-24 14:58:41,812 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 14:59:59,729 - INFO - Dropping table fPropostas...
2026-06-24 14:59:59,734 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 15:00:00,389 - INFO - Dropping table fVendas...
2026-06-24 15:00:00,394 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 15:00:00,940 - INFO - Batch 1 completed.
2026-06-24 15:00:00,940 - INFO - All tables refreshed.
2026-06-24 15:00:00,940 - INFO - Synchronization process completed successfully in 173.41088557243347 seconds.
2026-06-24 15:57:08,739 - INFO - Creating tables by calling stored procedure...
2026-06-24 15:57:09,010 - INFO - Tables created successfully via stored procedure.
2026-06-24 15:57:09,013 - INFO - Truncating tables...
2026-06-24 15:57:09,013 - INFO - Truncating table bi_acessos...
2026-06-24 15:57:09,014 - INFO - Truncating table bi_acoes_funil...
2026-06-24 15:57:09,015 - INFO - Truncating table bi_atividades...
2026-06-24 15:57:09,023 - INFO - Truncating table bi_oportunidades...
2026-06-24 15:57:09,024 - INFO - Truncating table bi_propostas...
2026-06-24 15:57:09,025 - INFO - Truncating table bi_vendas...
2026-06-24 15:57:09,025 - INFO - Truncating table bi_utms...
2026-06-24 15:57:09,026 - INFO - Truncation completed.
2026-06-24 15:57:09,027 - INFO - Fetching data from source database...
2026-06-24 15:57:34,433 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 15:57:34,435 - INFO - Creating star schema...
2026-06-24 15:57:34,557 - INFO - Star schema created successfully.
2026-06-24 15:57:34,557 - INFO - Refreshing tables (batch mode)...
2026-06-24 15:57:34,557 - INFO - Dropping table dCanais...
2026-06-24 15:57:34,561 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 15:57:34,579 - INFO - Dropping table dCategorias...
2026-06-24 15:57:34,583 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 15:57:34,604 - INFO - Dropping table dConsultores...
2026-06-24 15:57:34,608 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 15:57:34,625 - INFO - Dropping table dEmpreendimentos...
2026-06-24 15:57:34,628 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 15:57:34,644 - INFO - Dropping table dEstadosCivis...
2026-06-24 15:57:34,647 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 15:57:34,662 - INFO - Dropping table dEtapasFunil...
2026-06-24 15:57:34,666 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 15:57:34,697 - INFO - Dropping table dFaixasIdade...
2026-06-24 15:57:34,700 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 15:57:34,722 - INFO - Dropping table dFechamentoDias...
2026-06-24 15:57:34,725 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 15:57:34,741 - INFO - Dropping table dInteresses...
2026-06-24 15:57:34,744 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 15:57:34,758 - INFO - Dropping table dMidias...
2026-06-24 15:57:34,762 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 15:57:34,780 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 15:57:34,783 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 15:57:34,798 - INFO - Dropping table dProfissoes...
2026-06-24 15:57:34,802 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 15:57:34,821 - INFO - Dropping table dQuartos...
2026-06-24 15:57:34,825 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 15:57:34,830 - INFO - Dropping table dRegioes...
2026-06-24 15:57:34,833 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 15:57:34,857 - INFO - Dropping table dRendas...
2026-06-24 15:57:34,860 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 15:57:34,877 - INFO - Dropping table dSexos...
2026-06-24 15:57:34,880 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 15:57:34,896 - INFO - Dropping table dStatus...
2026-06-24 15:57:34,900 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 15:57:34,915 - INFO - Dropping table dStatusAtividade...
2026-06-24 15:57:34,918 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 15:57:34,963 - INFO - Dropping table dStatusProposta...
2026-06-24 15:57:34,966 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 15:57:34,972 - INFO - Dropping table dSuites...
2026-06-24 15:57:34,975 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 15:57:34,980 - INFO - Dropping table dTemperaturas...
2026-06-24 15:57:34,983 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 15:57:35,005 - INFO - Dropping table dTipos...
2026-06-24 15:57:35,007 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 15:57:35,023 - INFO - Dropping table dTiposAtividade...
2026-06-24 15:57:35,026 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 15:57:35,053 - INFO - Dropping table dUTMSource...
2026-06-24 15:57:35,056 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 15:57:35,132 - INFO - Dropping table dUTMMedium...
2026-06-24 15:57:35,134 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 15:57:35,204 - INFO - Dropping table dUTMCampaign...
2026-06-24 15:57:35,207 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 15:57:35,302 - INFO - Dropping table dUTMContent...
2026-06-24 15:57:35,305 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 15:57:35,367 - INFO - Dropping table dUTMTerm...
2026-06-24 15:57:35,370 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 15:57:35,433 - INFO - Dropping table dUnidades...
2026-06-24 15:57:35,436 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 15:57:35,451 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 15:57:35,454 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 15:57:35,459 - INFO - Dropping table dVagas...
2026-06-24 15:57:35,461 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 15:57:35,465 - INFO - Dropping table fAcessos...
2026-06-24 15:57:35,466 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 15:57:35,695 - INFO - Dropping table fOportunidades...
2026-06-24 15:57:35,700 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 15:58:00,456 - INFO - Dropping table fAcoesFunil...
2026-06-24 15:58:00,458 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 15:58:30,198 - INFO - Dropping table fAtividades...
2026-06-24 15:58:30,201 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 15:59:37,329 - INFO - Dropping table fPropostas...
2026-06-24 15:59:37,332 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 15:59:37,883 - INFO - Dropping table fVendas...
2026-06-24 15:59:37,886 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 15:59:38,456 - INFO - Batch 1 completed.
2026-06-24 15:59:38,456 - INFO - All tables refreshed.
2026-06-24 15:59:38,456 - INFO - Synchronization process completed successfully in 149.71678018569946 seconds.
2026-06-24 16:57:08,521 - INFO - Creating tables by calling stored procedure...
2026-06-24 16:57:08,711 - INFO - Tables created successfully via stored procedure.
2026-06-24 16:57:08,713 - INFO - Truncating tables...
2026-06-24 16:57:08,713 - INFO - Truncating table bi_acessos...
2026-06-24 16:57:08,715 - INFO - Truncating table bi_acoes_funil...
2026-06-24 16:57:08,716 - INFO - Truncating table bi_atividades...
2026-06-24 16:57:08,728 - INFO - Truncating table bi_oportunidades...
2026-06-24 16:57:08,729 - INFO - Truncating table bi_propostas...
2026-06-24 16:57:08,729 - INFO - Truncating table bi_vendas...
2026-06-24 16:57:08,730 - INFO - Truncating table bi_utms...
2026-06-24 16:57:08,731 - INFO - Truncation completed.
2026-06-24 16:57:08,731 - INFO - Fetching data from source database...
2026-06-24 16:57:37,671 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 16:57:37,673 - INFO - Creating star schema...
2026-06-24 16:57:37,812 - INFO - Star schema created successfully.
2026-06-24 16:57:37,812 - INFO - Refreshing tables (batch mode)...
2026-06-24 16:57:37,812 - INFO - Dropping table dCanais...
2026-06-24 16:57:37,815 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 16:57:37,839 - INFO - Dropping table dCategorias...
2026-06-24 16:57:37,848 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 16:57:37,873 - INFO - Dropping table dConsultores...
2026-06-24 16:57:37,876 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 16:57:37,905 - INFO - Dropping table dEmpreendimentos...
2026-06-24 16:57:37,908 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 16:57:37,938 - INFO - Dropping table dEstadosCivis...
2026-06-24 16:57:37,941 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 16:57:37,966 - INFO - Dropping table dEtapasFunil...
2026-06-24 16:57:37,975 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 16:57:38,021 - INFO - Dropping table dFaixasIdade...
2026-06-24 16:57:38,024 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 16:57:38,040 - INFO - Dropping table dFechamentoDias...
2026-06-24 16:57:38,043 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 16:57:38,059 - INFO - Dropping table dInteresses...
2026-06-24 16:57:38,063 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 16:57:38,081 - INFO - Dropping table dMidias...
2026-06-24 16:57:38,085 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 16:57:38,101 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 16:57:38,107 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 16:57:38,138 - INFO - Dropping table dProfissoes...
2026-06-24 16:57:38,142 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 16:57:38,166 - INFO - Dropping table dQuartos...
2026-06-24 16:57:38,168 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 16:57:38,173 - INFO - Dropping table dRegioes...
2026-06-24 16:57:38,177 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 16:57:38,203 - INFO - Dropping table dRendas...
2026-06-24 16:57:38,206 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 16:57:38,232 - INFO - Dropping table dSexos...
2026-06-24 16:57:38,240 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 16:57:38,255 - INFO - Dropping table dStatus...
2026-06-24 16:57:38,263 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 16:57:38,286 - INFO - Dropping table dStatusAtividade...
2026-06-24 16:57:38,290 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 16:57:38,362 - INFO - Dropping table dStatusProposta...
2026-06-24 16:57:38,366 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 16:57:38,372 - INFO - Dropping table dSuites...
2026-06-24 16:57:38,375 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 16:57:38,389 - INFO - Dropping table dTemperaturas...
2026-06-24 16:57:38,393 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 16:57:38,421 - INFO - Dropping table dTipos...
2026-06-24 16:57:38,424 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 16:57:38,457 - INFO - Dropping table dTiposAtividade...
2026-06-24 16:57:38,460 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 16:57:38,516 - INFO - Dropping table dUTMSource...
2026-06-24 16:57:38,519 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 16:57:38,609 - INFO - Dropping table dUTMMedium...
2026-06-24 16:57:38,613 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 16:57:38,690 - INFO - Dropping table dUTMCampaign...
2026-06-24 16:57:38,693 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 16:57:38,773 - INFO - Dropping table dUTMContent...
2026-06-24 16:57:38,776 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 16:57:38,874 - INFO - Dropping table dUTMTerm...
2026-06-24 16:57:38,877 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 16:57:38,969 - INFO - Dropping table dUnidades...
2026-06-24 16:57:38,972 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 16:57:38,990 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 16:57:38,993 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 16:57:38,999 - INFO - Dropping table dVagas...
2026-06-24 16:57:39,003 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 16:57:39,009 - INFO - Dropping table fAcessos...
2026-06-24 16:57:39,013 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 16:57:39,251 - INFO - Dropping table fOportunidades...
2026-06-24 16:57:39,260 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 16:58:10,814 - INFO - Dropping table fAcoesFunil...
2026-06-24 16:58:10,817 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 16:58:43,551 - INFO - Dropping table fAtividades...
2026-06-24 16:58:43,554 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 17:00:03,609 - INFO - Dropping table fPropostas...
2026-06-24 17:00:03,654 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 17:00:05,606 - INFO - Dropping table fVendas...
2026-06-24 17:00:05,612 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 17:00:06,421 - INFO - Batch 1 completed.
2026-06-24 17:00:06,421 - INFO - All tables refreshed.
2026-06-24 17:00:06,421 - INFO - Synchronization process completed successfully in 177.89968943595886 seconds.
2026-06-24 17:57:08,330 - INFO - Creating tables by calling stored procedure...
2026-06-24 17:57:08,526 - INFO - Tables created successfully via stored procedure.
2026-06-24 17:57:08,528 - INFO - Truncating tables...
2026-06-24 17:57:08,528 - INFO - Truncating table bi_acessos...
2026-06-24 17:57:08,529 - INFO - Truncating table bi_acoes_funil...
2026-06-24 17:57:08,603 - INFO - Truncating table bi_atividades...
2026-06-24 17:57:08,609 - INFO - Truncating table bi_oportunidades...
2026-06-24 17:57:08,612 - INFO - Truncating table bi_propostas...
2026-06-24 17:57:08,613 - INFO - Truncating table bi_vendas...
2026-06-24 17:57:08,613 - INFO - Truncating table bi_utms...
2026-06-24 17:57:08,614 - INFO - Truncation completed.
2026-06-24 17:57:08,614 - INFO - Fetching data from source database...
2026-06-24 17:57:34,911 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 17:57:34,912 - INFO - Creating star schema...
2026-06-24 17:57:34,990 - INFO - Star schema created successfully.
2026-06-24 17:57:34,990 - INFO - Refreshing tables (batch mode)...
2026-06-24 17:57:34,991 - INFO - Dropping table dCanais...
2026-06-24 17:57:34,994 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 17:57:35,018 - INFO - Dropping table dCategorias...
2026-06-24 17:57:35,032 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 17:57:35,059 - INFO - Dropping table dConsultores...
2026-06-24 17:57:35,061 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 17:57:35,088 - INFO - Dropping table dEmpreendimentos...
2026-06-24 17:57:35,091 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 17:57:35,106 - INFO - Dropping table dEstadosCivis...
2026-06-24 17:57:35,109 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 17:57:35,122 - INFO - Dropping table dEtapasFunil...
2026-06-24 17:57:35,125 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 17:57:35,150 - INFO - Dropping table dFaixasIdade...
2026-06-24 17:57:35,155 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 17:57:35,173 - INFO - Dropping table dFechamentoDias...
2026-06-24 17:57:35,177 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 17:57:35,193 - INFO - Dropping table dInteresses...
2026-06-24 17:57:35,199 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 17:57:35,213 - INFO - Dropping table dMidias...
2026-06-24 17:57:35,217 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 17:57:35,237 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 17:57:35,239 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 17:57:35,255 - INFO - Dropping table dProfissoes...
2026-06-24 17:57:35,258 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 17:57:35,276 - INFO - Dropping table dQuartos...
2026-06-24 17:57:35,279 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 17:57:35,285 - INFO - Dropping table dRegioes...
2026-06-24 17:57:35,288 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 17:57:35,309 - INFO - Dropping table dRendas...
2026-06-24 17:57:35,313 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 17:57:35,329 - INFO - Dropping table dSexos...
2026-06-24 17:57:35,333 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 17:57:35,346 - INFO - Dropping table dStatus...
2026-06-24 17:57:35,349 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 17:57:35,361 - INFO - Dropping table dStatusAtividade...
2026-06-24 17:57:35,364 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 17:57:35,410 - INFO - Dropping table dStatusProposta...
2026-06-24 17:57:35,414 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 17:57:35,418 - INFO - Dropping table dSuites...
2026-06-24 17:57:35,424 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 17:57:35,429 - INFO - Dropping table dTemperaturas...
2026-06-24 17:57:35,432 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 17:57:35,452 - INFO - Dropping table dTipos...
2026-06-24 17:57:35,455 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 17:57:35,469 - INFO - Dropping table dTiposAtividade...
2026-06-24 17:57:35,473 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 17:57:35,503 - INFO - Dropping table dUTMSource...
2026-06-24 17:57:35,508 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 17:57:35,570 - INFO - Dropping table dUTMMedium...
2026-06-24 17:57:35,575 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 17:57:35,642 - INFO - Dropping table dUTMCampaign...
2026-06-24 17:57:35,646 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 17:57:35,747 - INFO - Dropping table dUTMContent...
2026-06-24 17:57:35,750 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 17:57:35,853 - INFO - Dropping table dUTMTerm...
2026-06-24 17:57:35,856 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 17:57:35,936 - INFO - Dropping table dUnidades...
2026-06-24 17:57:35,941 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 17:57:35,956 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 17:57:35,962 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 17:57:35,968 - INFO - Dropping table dVagas...
2026-06-24 17:57:35,971 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 17:57:35,975 - INFO - Dropping table fAcessos...
2026-06-24 17:57:35,978 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 17:57:36,189 - INFO - Dropping table fOportunidades...
2026-06-24 17:57:36,192 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 17:58:02,592 - INFO - Dropping table fAcoesFunil...
2026-06-24 17:58:02,595 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 17:58:33,473 - INFO - Dropping table fAtividades...
2026-06-24 17:58:33,476 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 17:59:43,798 - INFO - Dropping table fPropostas...
2026-06-24 17:59:43,801 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 17:59:44,338 - INFO - Dropping table fVendas...
2026-06-24 17:59:44,341 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 17:59:44,975 - INFO - Batch 1 completed.
2026-06-24 17:59:44,975 - INFO - All tables refreshed.
2026-06-24 17:59:44,975 - INFO - Synchronization process completed successfully in 156.6451780796051 seconds.
2026-06-24 18:57:08,739 - INFO - Creating tables by calling stored procedure...
2026-06-24 18:57:08,917 - INFO - Tables created successfully via stored procedure.
2026-06-24 18:57:08,919 - INFO - Truncating tables...
2026-06-24 18:57:08,919 - INFO - Truncating table bi_acessos...
2026-06-24 18:57:08,920 - INFO - Truncating table bi_acoes_funil...
2026-06-24 18:57:08,921 - INFO - Truncating table bi_atividades...
2026-06-24 18:57:08,928 - INFO - Truncating table bi_oportunidades...
2026-06-24 18:57:08,929 - INFO - Truncating table bi_propostas...
2026-06-24 18:57:08,929 - INFO - Truncating table bi_vendas...
2026-06-24 18:57:08,930 - INFO - Truncating table bi_utms...
2026-06-24 18:57:08,931 - INFO - Truncation completed.
2026-06-24 18:57:08,931 - INFO - Fetching data from source database...
2026-06-24 18:57:37,613 - INFO - Data fetched and processed. Records inserted into target tables.
2026-06-24 18:57:37,615 - INFO - Creating star schema...
2026-06-24 18:57:37,732 - INFO - Star schema created successfully.
2026-06-24 18:57:37,732 - INFO - Refreshing tables (batch mode)...
2026-06-24 18:57:37,732 - INFO - Dropping table dCanais...
2026-06-24 18:57:37,736 - INFO - Creating table dCanais from vw_dCanais...
2026-06-24 18:57:37,751 - INFO - Dropping table dCategorias...
2026-06-24 18:57:37,754 - INFO - Creating table dCategorias from vw_dCategorias...
2026-06-24 18:57:37,769 - INFO - Dropping table dConsultores...
2026-06-24 18:57:37,772 - INFO - Creating table dConsultores from vw_dConsultores...
2026-06-24 18:57:37,789 - INFO - Dropping table dEmpreendimentos...
2026-06-24 18:57:37,792 - INFO - Creating table dEmpreendimentos from vw_dEmpreendimentos...
2026-06-24 18:57:37,818 - INFO - Dropping table dEstadosCivis...
2026-06-24 18:57:37,822 - INFO - Creating table dEstadosCivis from vw_dEstadosCivis...
2026-06-24 18:57:37,855 - INFO - Dropping table dEtapasFunil...
2026-06-24 18:57:37,859 - INFO - Creating table dEtapasFunil from vw_dEtapasFunil...
2026-06-24 18:57:37,902 - INFO - Dropping table dFaixasIdade...
2026-06-24 18:57:37,906 - INFO - Creating table dFaixasIdade from vw_dFaixasIdade...
2026-06-24 18:57:37,923 - INFO - Dropping table dFechamentoDias...
2026-06-24 18:57:37,926 - INFO - Creating table dFechamentoDias from vw_dFechamentoDias...
2026-06-24 18:57:37,942 - INFO - Dropping table dInteresses...
2026-06-24 18:57:37,945 - INFO - Creating table dInteresses from vw_dInteresses...
2026-06-24 18:57:37,965 - INFO - Dropping table dMidias...
2026-06-24 18:57:37,968 - INFO - Creating table dMidias from vw_dMidias...
2026-06-24 18:57:37,982 - INFO - Dropping table dMotivosPerdaPausa...
2026-06-24 18:57:37,987 - INFO - Creating table dMotivosPerdaPausa from vw_dMotivosPerdaPausa...
2026-06-24 18:57:38,012 - INFO - Dropping table dProfissoes...
2026-06-24 18:57:38,017 - INFO - Creating table dProfissoes from vw_dProfissoes...
2026-06-24 18:57:38,034 - INFO - Dropping table dQuartos...
2026-06-24 18:57:38,040 - INFO - Creating table dQuartos from vw_dQuartos...
2026-06-24 18:57:38,046 - INFO - Dropping table dRegioes...
2026-06-24 18:57:38,049 - INFO - Creating table dRegioes from vw_dRegioes...
2026-06-24 18:57:38,077 - INFO - Dropping table dRendas...
2026-06-24 18:57:38,081 - INFO - Creating table dRendas from vw_dRendas...
2026-06-24 18:57:38,102 - INFO - Dropping table dSexos...
2026-06-24 18:57:38,107 - INFO - Creating table dSexos from vw_dSexos...
2026-06-24 18:57:38,122 - INFO - Dropping table dStatus...
2026-06-24 18:57:38,126 - INFO - Creating table dStatus from vw_dStatus...
2026-06-24 18:57:38,144 - INFO - Dropping table dStatusAtividade...
2026-06-24 18:57:38,149 - INFO - Creating table dStatusAtividade from vw_dStatusAtividade...
2026-06-24 18:57:38,198 - INFO - Dropping table dStatusProposta...
2026-06-24 18:57:38,202 - INFO - Creating table dStatusProposta from vw_dStatusProposta...
2026-06-24 18:57:38,207 - INFO - Dropping table dSuites...
2026-06-24 18:57:38,211 - INFO - Creating table dSuites from vw_dSuites...
2026-06-24 18:57:38,215 - INFO - Dropping table dTemperaturas...
2026-06-24 18:57:38,222 - INFO - Creating table dTemperaturas from vw_dTemperaturas...
2026-06-24 18:57:38,247 - INFO - Dropping table dTipos...
2026-06-24 18:57:38,253 - INFO - Creating table dTipos from vw_dTipos...
2026-06-24 18:57:38,281 - INFO - Dropping table dTiposAtividade...
2026-06-24 18:57:38,285 - INFO - Creating table dTiposAtividade from vw_dTiposAtividade...
2026-06-24 18:57:38,333 - INFO - Dropping table dUTMSource...
2026-06-24 18:57:38,337 - INFO - Creating table dUTMSource from vw_dUTMSource...
2026-06-24 18:57:38,400 - INFO - Dropping table dUTMMedium...
2026-06-24 18:57:38,404 - INFO - Creating table dUTMMedium from vw_dUTMMedium...
2026-06-24 18:57:38,473 - INFO - Dropping table dUTMCampaign...
2026-06-24 18:57:38,477 - INFO - Creating table dUTMCampaign from vw_dUTMCampaign...
2026-06-24 18:57:38,562 - INFO - Dropping table dUTMContent...
2026-06-24 18:57:38,567 - INFO - Creating table dUTMContent from vw_dUTMContent...
2026-06-24 18:57:38,676 - INFO - Dropping table dUTMTerm...
2026-06-24 18:57:38,681 - INFO - Creating table dUTMTerm from vw_dUTMTerm...
2026-06-24 18:57:38,770 - INFO - Dropping table dUnidades...
2026-06-24 18:57:38,774 - INFO - Creating table dUnidades from vw_dUnidades...
2026-06-24 18:57:38,795 - INFO - Dropping table dUnidadesEmpreendimento...
2026-06-24 18:57:38,799 - INFO - Creating table dUnidadesEmpreendimento from vw_dUnidadesEmpreendimento...
2026-06-24 18:57:38,804 - INFO - Dropping table dVagas...
2026-06-24 18:57:38,807 - INFO - Creating table dVagas from vw_dVagas...
2026-06-24 18:57:38,811 - INFO - Dropping table fAcessos...
2026-06-24 18:57:38,814 - INFO - Creating table fAcessos from vw_fAcessos...
2026-06-24 18:57:39,159 - INFO - Dropping table fOportunidades...
2026-06-24 18:57:39,164 - INFO - Creating table fOportunidades from vw_fOportunidades...
2026-06-24 18:58:09,187 - INFO - Dropping table fAcoesFunil...
2026-06-24 18:58:09,191 - INFO - Creating table fAcoesFunil from vw_fAcoesFunil...
2026-06-24 18:58:41,885 - INFO - Dropping table fAtividades...
2026-06-24 18:58:41,890 - INFO - Creating table fAtividades from vw_fAtividades...
2026-06-24 18:59:58,245 - INFO - Dropping table fPropostas...
2026-06-24 18:59:58,248 - INFO - Creating table fPropostas from vw_fPropostas...
2026-06-24 18:59:58,835 - INFO - Dropping table fVendas...
2026-06-24 18:59:58,839 - INFO - Creating table fVendas from vw_fVendas...
2026-06-24 18:59:59,462 - INFO - Batch 1 completed.
2026-06-24 18:59:59,462 - INFO - All tables refreshed.
2026-06-24 18:59:59,462 - INFO - Synchronization process completed successfully in 170.7231204509735 seconds.