BMXAA6818I - ConfigDB 已針對綱目 dbo 啟動，已連接至資料庫 jdbc:sqlserver://localhost:1433;database=maxdb71;integratedSecurity=false; Wed Jan 07 09:08:31 CST 2026
update maxvars set varvalue = '1' where varname = 'CONFIGURING'
go
commit
go
commit
go
update maxattributecfg set canautonum = 1 where objectname = 'ZZ_DOC_VER_HIS' and attributename = 'ZZ_DOC_VER_HISID' and not exists (select 1 from maxtablecfg where tablename = maxattributecfg.entityname and  uniquecolumnname is not null and uniquecolumnname = maxattributecfg.columnname)
go
update maxviewcolumncfg set changed = 'R' where tablecolumnname is not null  and tablecolumnname != 'ROWSTAMP' and tablecolumnname != 'TENANTID' and not exists  (select * from maxattributecfg where entityname = tablename and columnname =     tablecolumnname and changed != 'R')
go
update maxattributecfg set changed = 'R' where exists  (select * from maxviewcolumncfg where viewname = entityname and viewcolumnname = columnname     and changed = 'R')
go
update maxattributecfg set maxtype = 'BIGINT', length = 19 where changed = 'I'  and maxtype != 'BIGINT'  and objectname in (select objectname from maxobjectcfg where changed = 'I')  and exists (select 1 from maxtablecfg where tablename = maxattributecfg.entityname and  uniquecolumnname is not null and uniquecolumnname = maxattributecfg.columnname)
go
update maxattributecfg set maxtype = 'BIGINT', length = 19 where changed = 'I' and  maxtype != 'BIGINT' and  sameasobject is not null and sameasattribute is not null and  exists (select 1 from maxattributecfg a2 where  a2.attributename = maxattributecfg.sameasattribute  and a2.objectname = maxattributecfg.sameasobject  and a2.maxtype = 'BIGINT' and a2.changed = 'I')
go
commit
go
BMXAA0364I - 取得 meta 資料 Wed Jan 07 09:08:35 CST 2026
BMXAA0349I - 配置表格 Wed Jan 07 09:08:35 CST 2026
BMXAA0345I - 變更表格 ZZ_DOCINFO Wed Jan 07 09:08:35 CST 2026
ALTER TABLE zz_docinfo DISABLE TRIGGER ALL
go
alter table zz_docinfo add revision integer null
go
alter table zz_docinfo add version integer null
go
alter table zz_docinfo add statusby varchar (20) null
go
BMXAA0347I - 建立表格 ZZ_DOC_VER_HIS Wed Jan 07 09:08:35 CST 2026
create table zz_doc_ver_his (
zz_doc_ver_hisid bigint not null,
version integer null,
revision integer null,
changeby varchar (20) null,
changedate datetime null,
memo varchar (50) null,
zz_docinfoid bigint null,
rowstamp timestamp
)
on 'PRIMARY'
go
create unique index zz_doc_ver_his_ndx1 on zz_doc_ver_his(zz_doc_ver_hisid) on 'PRIMARY'
go
insert into maxsyskeys (ixname, colname, colseq, ordering, changed, maxsyskeysid)  values ('ZZ_DOC_VER_HIS_NDX1','ZZ_DOC_VER_HISID',1 , 'A', 'N', 164761)
go
insert into maxsysindexes (name,tbname,uniquerule,changed,clusterrule,storagepartition, required, textsearch, maxsysindexesid)  values ('ZZ_DOC_VER_HIS_NDX1','ZZ_DOC_VER_HIS','U','N',0,'PRIMARY', 0, 0, 154181)
go
commit
go
commit
go
BMXAA0342I - 配置視圖 Wed Jan 07 09:08:36 CST 2026
commit
go
BMXAA0344I - 重新整理屬性 meta 資料 Wed Jan 07 09:08:36 CST 2026
delete from autokey where not exists (select * from maxattributecfg c where c.autokeyname = autokey.autokeyname and c.changed != 'R')
go
delete from l_maxattrcfg where ownerid in (select maxattributeid from maxattributecfg where changed = 'R')
go
delete from maxattributecfg where changed = 'R'
go
delete from maxviewcolumncfg where changed = 'R'
go
delete from maxattribute
go
delete from l_maxattribute
go
insert into maxattribute (objectname, attributename, attributeno, alias, autokeyname, canautonum, classname, columnname, defaultvalue, domainid, eauditenabled, entityname, esigenabled, isldowner, ispositive, length, maxtype, mustbe, required, persistent, primarykeycolseq, remarks, sameasattribute, sameasobject, scale, title, userdefined, searchtype, mlsupported, mlinuse, handlecolumnname, maxattributeid, restricted, localizable, textdirection, complexexpression, extended) 
select objectname, attributename, attributeno, alias, autokeyname, canautonum, classname, columnname, defaultvalue, domainid, eauditenabled, entityname, esigenabled, isldowner, ispositive, length, maxtype, mustbe, required, persistent, primarykeycolseq, remarks, sameasattribute, sameasobject, scale, title, userdefined, searchtype, mlsupported, mlinuse, handlecolumnname, maxattributeid, restricted, localizable, textdirection, complexexpression, extended
 from maxattributecfg
go
insert into l_maxattribute (l_maxattributeid, ownerid, langcode, remarks, title) 
select l_maxattrcfgid, ownerid, langcode, remarks, title
 from l_maxattrcfg
go
update maxattributecfg set changed = 'N' where changed != 'N'
go
delete from maxviewcolumn
go
insert into maxviewcolumn (viewname, viewcolumnname, samestorageas, tablename, tablecolumnname, maxviewcolumnid) 
select viewname, viewcolumnname, samestorageas, tablename, tablecolumnname, maxviewcolumnid
 from maxviewcolumncfg
go
update maxviewcolumncfg set changed = 'N' where changed != 'N'
go
commit
go
BMXAA0343I - 重新整理物件 meta 資料 Wed Jan 07 09:08:41 CST 2026
delete from maxtable
go
delete from maxtablecfg where tablename in (select entityname from maxobjectcfg where isview = 0 and changed = 'R')
go
delete from maxview
go
delete from maxviewcfg where viewname in (select entityname from maxobjectcfg where isview = 1 and changed = 'R')
go
delete from maxobject
go
delete from l_maxobject
go
delete from l_maxobjectcfg where ownerid in (select maxobjectid from maxobjectcfg where changed = 'R')
go
delete from maxobjectcfg where changed = 'R'
go
update maxobjectcfg set changed = 'N'
go
insert into maxobject (objectname, classname, description, eauditenabled, eauditfilter, entityname, esigfilter, extendsobject, hasld, imported, internal, isview, langcode, mainobject, maxobjectid, persistent, resourcetype, servicename, siteorgtype, textdirection, userdefined) 
select objectname, classname, description, eauditenabled, eauditfilter, entityname, esigfilter, extendsobject, hasld, imported, internal, isview, langcode, mainobject, maxobjectid, persistent, resourcetype, servicename, siteorgtype, textdirection, userdefined
 from maxobjectcfg
go
insert into l_maxobject (l_maxobjectid, ownerid, langcode, description) 
select l_maxobjectcfgid, ownerid, langcode, description
 from l_maxobjectcfg
go
insert into maxtable (tablename, addrowstamp, eaudittbname, isaudittable, restoredata, storagepartition, textsearchenabled, langtablename, langcolumnname, uniquecolumnname, islangtable, maxtableid, altixname, trigroot, contentattribute, storagetype, exttablename) 
select tablename, addrowstamp, eaudittbname, isaudittable, restoredata, storagepartition, textsearchenabled, langtablename, langcolumnname, uniquecolumnname, islangtable, maxtableid, altixname, trigroot, contentattribute, storagetype, exttablename
 from maxtablecfg
go
insert into maxview (viewname, viewselect, viewwhere, autoselect, maxviewid, viewfrom) 
select viewname, viewselect, viewwhere, autoselect, maxviewid, viewfrom
 from maxviewcfg
go
commit
go
delete from appfielddefaults where not exists  (select * from maxattribute where maxattribute.objectname = appfielddefaults.objectname and  		maxattribute.attributename = appfielddefaults.attributename)
go
commit
go
BMXAA0341I - 重建原生索引 Wed Jan 07 09:08:41 CST 2026
BMXAA0340I - 重新整理索引 meta 資料 Wed Jan 07 09:08:41 CST 2026
commit
go
BMXAA0339I - 更新表格儲存體分割區 Wed Jan 07 09:08:41 CST 2026
update maxtable set storagepartition =  (select sysfilegroups.groupname 	from dbo.sysindexes, sysobjects, sysfilegroups 	where dbo.sysindexes.id = sysobjects.id and  	sysobjects.name = lower(maxtable.tablename) and  	sysobjects.type = 'U' and  	dbo.sysindexes.groupid = sysfilegroups.groupid and  	dbo.sysindexes.indid <= 1 ) 
go
update maxtablecfg set storagepartition =  (select sysfilegroups.groupname 	from dbo.sysindexes, sysobjects, sysfilegroups 	where dbo.sysindexes.id = sysobjects.id and  	sysobjects.name = lower(maxtablecfg.tablename) and  	sysobjects.type = 'U' and  	dbo.sysindexes.groupid = sysfilegroups.groupid and  	dbo.sysindexes.indid <= 1 ) 
go
commit
go
commit
go
sp_indexoption 'zz_doc_ver_his.zz_doc_ver_his_ndx1', 'AllowPageLocks', FALSE
go
update maxsequence set maxreserved = 59164 where sequencename = 'MAXTABLECFGSEQ'
go
update maxsequence set maxreserved = 36725 where sequencename = 'MAXVIEWCOLUMNSEQ'
go
update maxsequence set maxreserved = 59164 where sequencename = 'MAXTABLESEQ'
go
update maxsequence set maxreserved = 1986 where sequencename = 'MAXVIEWCFGSEQ'
go
update maxsequence set maxreserved = 1 where sequencename = 'L_MAXATTRCFGSEQ'
go
update maxsequence set maxreserved = 36725 where sequencename = 'MAXVIEWCOLUMNCFGSEQ'
go
update maxsequence set maxreserved = 1 where sequencename = 'L_MAXATTRIBUTEUSEQ'
go
update maxsequence set maxreserved = 76860 where sequencename = 'MAXOBJECTCFGSEQ'
go
update maxsequence set maxreserved = 1 where sequencename = 'L_MAXOBJECTCFGSEQ'
go
update maxsequence set maxreserved = 1986 where sequencename = 'MAXVIEWSEQ'
go
update maxsequence set maxreserved = 76860 where sequencename = 'MAXOBJECTSEQ'
go
update maxsequence set maxreserved = 280090 where sequencename = 'MAXATTRIBUTESEQ'
go
update maxsequence set maxreserved = 1 where sequencename = 'L_MAXOBJECTUSEQ'
go
update maxsequence set maxreserved = 280090 where sequencename = 'MAXATTRIBUTECFGSEQ'
go
update maxvars set varvalue = '878' where varname = 'DBVERSION'
go
commit
go
update maxvars set varvalue = '5' where varname = 'NUMBEROFTAXCODES'
go
commit
go
delete from maxattributeskipcopy where maxattributeskipcopyid not in (select maxattributeskipcopyid from maxattributeskipcopy masc, maxattributecfg macfg where masc.attributename = macfg.attributename and masc.objectname = macfg.objectname)
go
commit
go
commit
go
sp_fulltext_catalog 'textcatalog', 'start_full'
go
BMXAA0337I - 請確定已建立這些新表格 ZZ_DOC_VER_HIS 的索引 Wed Jan 07 09:08:42 CST 2026
update maxvars set varvalue = '0' where varname = 'CONFIGURING'
go
commit
go
BMXAA6820I - ConfigDB 已完成，而且沒發生錯誤。 Wed Jan 07 09:08:42 CST 2026