Consultor Eletrônico



Kbase 47764: Erro Oracle carga menu Datasul 11
Autor   Marco Aurelio Scheidt - CAT
Acesso   Público
Publicação   01/07/2014
Ambiente:
Datasul 11.5.9
Oracle

Erro:
2014-07-01 14:10:17,084 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select distinct applicatio0_.nom_aplicat_dtsul_menu as col_0_0_, moduledata2_.des_modul_dtsul as col_1_0_, moduledata2_.nom_dir_modul_flex as col_2_0_, lower(moduledata2_.cod_modul_dtsul) as col_3_0_, programdat4_.des_prog_dtsul as col_4_0_, programdat4_.nom_prog_menu_verbal as col_5_0_, programdat4_.cod_prog_dtsul as col_6_0_, programdat4_.nom_prog_ext as col_7_0_, programdat4_.idi_interfac as col_8_0_, programdat4_.idi_dtsul as col_9_0_, programdat4_.idi_categ_prog_dtsul as col_10_0_, programdat4_.log_reg_padr as col_11_0_, applicatio0_.cod_grp_aplicat_dtsul as col_12_0_, programdat4_.idi_tip_prog_dtsul as col_13_0_, programdat4_.log_gera_log_exec as col_14_0_ from aplicat_dtsul applicatio0_, sist_dtsul systemdata1_, modul_dtsul moduledata2_, procedimento procedimen3_, prog_dtsul programdat4_, prog_dtsul_segur programdat5_ where applicatio0_.cod_grp_aplicat_dtsul='RHU' and systemdata1_.cod_aplicat_dtsul=applicatio0_.cod_aplicat_dtsul and moduledata2_.cod_sist_dtsul=systemdata1_.cod_sist_dtsul and procedimen3_.cod_modul_dtsul=moduledata2_.cod_modul_dtsul and programdat4_.cod_proced=procedimen3_.cod_proced and programdat5_.cod_prog_dtsul=programdat4_.cod_prog_dtsul and programdat4_.idi_tip_prog_dtsul=1 and moduledata2_.cod_modul_dtsul='MFP' and (programdat5_.cod_grp_usuar in (? , ? , ?)) and programdat4_.log_visualiz_menu=1 and programdat4_.nom_prog_menu_verbal<>' ' and (programdat4_.idi_interfac<>4 or programdat4_.idi_categ_prog_dtsul<>1) order by programdat4_.nom_prog_menu_verbal]
java.sql.SQLException: ORA-01652: não é possível estender o segmento temp. em 128 no tablespace TEMP2

Causa:
Ao fazer a carga do menu gera o erro de estouro da TEMP do Oracle "ORA-01652"

Solução:
Aplicar o pacote liberado pelo Menna de performance de menu (detalhes com o Framework).