Smeta 8.0.0.32.
Возникают ошибки при проверке и ремонте базы данных.
Хотелось бы устранить до перехода на версию 9.
- Код: Выделить всё
[0149384] gbak:cannot commit index FK_A_SMETA_CENLVL_ID
[0149385] gbak: ERROR:violation of FOREIGN KEY constraint "FK_A_SMETA_CENLVL_ID" on table "A_SMETA_CENLVL"
[0149386] gbak: ERROR: Foreign key reference target does not exist
[0149387] gbak: activating and creating deferred index FK_A_SMETA_CENLVL_IDCENLVL
[0149388] gbak: activating and creating deferred index FK_A_S_RES_CENLVL_ID
[0149389] gbak: activating and creating deferred index FK_A_S_RES_CENLVL_IDCENLVL
[0149390] gbak: activating and creating deferred index FK_A_LZ_CENLVL_ID
[0149391] gbak: activating and creating deferred index FK_A_LZ_CENLVL_IDCENLVL
[0149392] gbak: activating and creating deferred index FK_A_S_ETALON_RES_CENLVL_ID
[0149393] gbak: activating and creating deferred index FK_A_S_ETALON_RES_CENLVL_IDCENL
[0149394] gbak: activating and creating deferred index FK_L_SSR_PARAMS2_ID_SELF
[0149395] gbak: activating and creating deferred index FK_L_SSR_CENLVL_ID_REC
[0149396] gbak: activating and creating deferred index FK_L_SSR_TIP_ZATRAT
[0149397] gbak: activating and creating deferred index FK_D_GR_RES_CEN_LEVELS_ID_CEN_L
[0149398] gbak: activating and creating deferred index FK_D_GR_RES_CEN_LEVELS_ID_GRRES
[0149399] gbak: activating and creating deferred index FK_D_GROUPED_RES_SOURCE_CEN
[0149400] gbak: activating and creating deferred index FK_D_GROUPED_RES_UNDO_FK_ID
[0149401] gbak: activating and creating deferred index FK_D_GR_RES_CEN_LEVELS_UNDO_1
[0149402] gbak: activating and creating deferred index FK_A_SMETA_INDLVL_ID
[0149403] gbak:cannot commit index FK_A_SMETA_INDLVL_ID
[0149404] gbak: ERROR:violation of FOREIGN KEY constraint "FK_A_SMETA_INDLVL_ID" on table "A_SMETA_INDLVL"
[0149405] gbak: ERROR: Foreign key reference target does not exist
[0149406] gbak: activating and creating deferred index FK_A_SMETA_INDLVL_IDCENLVL
[0149407] gbak: activating and creating deferred index FK_A_SMETA_INDLVL_DESCR_ID
[0149408] gbak: activating and creating deferred index FK_A_SMETA_INDLVL_DR_IDCENLVL
[0149409] gbak: activating and creating deferred index FK_SM_NORM_VREMENN_IDPARENT
[0149410] gbak: activating and creating deferred index FK_SM_NORM_ZU_VIDRAB_IDPARENT
[0149411] gbak: activating and creating deferred index FK_SM_NORM_ZU_IDVIDRAB
[0149412] gbak: activating and creating deferred index FK_SM_NORM_ZU_CLZONES_IDPARENT
[0149413] gbak: activating and creating deferred index FK_L_SSR_IDVRZUCL
[0149414] gbak: activating and creating deferred index FK_L_SSR_FORMULS_CENLVL_IDCENLV
[0149415] gbak: activating and creating deferred index FK_L_SSR_FORMULS_CENLVL_NM_FRM
[0149416] gbak: activating and creating deferred index FK_M_HR_RECS_1
[0149417] gbak: activating and creating deferred index FK_M_USERS_PARAMS_2_ID
[0149418] gbak: committing metadata
[0149419] gbak:finishing, closing, and going home
[0149420] gbak:Database is not online due to failure to activate one or more indices.
[0149421] gbak:Run gfix -online to bring database online without active indices.
C:\StroySoft\Server\Base\DataSD.ssd
в результате найдены следующие ошибки
Summary of validation errors
Number of record level errors : 1
Number of index page errors : 5
Завершение операции: 31.01.2016 - 02:11:19
Длительность: 00:11:19
Прошу помощи.
