BMXAA6818I - ConfigDB started for schema MAXIMO, connected to database jdbc:oracle:thin:@//lrlupxa7-scan4.ar.entergy.com:1512/mxeamdev.world Wed May 26 20:11:24 CDT 2021 BEGIN DBMS_SCHEDULER.DISABLE('MAXIMOTSSYNC', force => TRUE); END; ; update maxvars set varvalue = '1' where varname = 'CONFIGURING' ; commit ; commit ; 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') ; update maxattributecfg set changed = 'R' where exists (select * from maxviewcolumncfg where viewname = entityname and viewcolumnname = columnname and changed = 'R') ; 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) ; 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') ; commit ; BMXAA0364I - Getting metadata Wed May 26 20:11:32 CDT 2021 BMXAA0349I - Configuring tables Wed May 26 20:11:34 CDT 2021 BMXAA0345I - Altering table ASSET. Wed May 26 20:11:34 CDT 2021 ALTER TABLE ASSET DISABLE ALL TRIGGERS ; alter table asset add etrratingclass varchar2 (30) null ; alter trigger ASSET_T compile ; alter trigger ASSET_T enable ; BMXAA0345I - Altering table A_ASSET. Wed May 26 20:11:42 CDT 2021 ALTER TABLE A_ASSET DISABLE ALL TRIGGERS ; alter table a_asset add etrratingclass varchar2 (30) null ; alter trigger A_ASSET_T compile ; alter trigger A_ASSET_T enable ; BMXAA0345I - Altering table LOCATIONS. Wed May 26 20:11:45 CDT 2021 ALTER TABLE LOCATIONS DISABLE ALL TRIGGERS ; alter table locations add etrphone number ; update locations set etrphone = 0 where etrphone is null ; alter table LOCATIONS modify etrphone number not null ; alter table locations add etrcable number ; update locations set etrcable = 0 where etrcable is null ; alter table LOCATIONS modify etrcable number not null ; alter table locations add etrlightting number ; update locations set etrlightting = 0 where etrlightting is null ; alter table LOCATIONS modify etrlightting number not null ; alter table locations add etrmicrowave number ; update locations set etrmicrowave = 0 where etrmicrowave is null ; alter table LOCATIONS modify etrmicrowave number not null ; alter table locations add etrsecondary number ; update locations set etrsecondary = 0 where etrsecondary is null ; alter table LOCATIONS modify etrsecondary number not null ; alter table locations add etrunderbuild number ; update locations set etrunderbuild = 0 where etrunderbuild is null ; alter table LOCATIONS modify etrunderbuild number not null ; alter table locations add etrgovernament number ; update locations set etrgovernament = 0 where etrgovernament is null ; alter table LOCATIONS modify etrgovernament number not null ; alter table locations add etrother number ; update locations set etrother = 0 where etrother is null ; alter table LOCATIONS modify etrother number not null ; delete from securityrestrict where objectname = 'LOCATIONS' and attributename = 'ETRRATINGCLASS' ; alter trigger LOCATIONS_T compile ; alter trigger LOCATIONS_T enable ; BMXAA0345I - Altering table MASTERPM. Thu May 27 09:33:55 CDT 2021 ALTER TABLE MASTERPM DISABLE ALL TRIGGERS ; alter table masterpm add etracro varchar2 (20) null ; alter table masterpm add etrsystemkv varchar2 (10) null ; alter trigger MASTERPM_T compile ; alter trigger MASTERPM_T enable ; commit ; BMXAA0342I - Views are being configured. Thu May 27 09:33:57 CDT 2021 create or replace view plustaliasview ( ancestor, assethealth, assetid, assetnum, assetnum1, assettag, assettype, assetuid, autowogen, binnum, budgetcost, calnum, changeby, changedate, children, classstructureid, conditioncode, defaultrepfac, defaultrepfacsiteid, depreciationpending, description, deviceid, devicetype, direction, disabled, enddescription, endmeasure, eq1, eq10, eq11, eq12, eq2, eq23, eq24, eq3, eq4, eq5, eq6, eq7, eq8, eq9, estendoflife, etraerialserialnum, etraliastype, etrallowance, etrapplication, etrassetclass1, etrassetclass2, etrastmbarcode, etravailablestatus, etrchassisserialnum, etrcnvclassstructureid, etrcnventity, etrcnvmetertype, etrcomment, etrcompany, etrcompanyequipmentnumber, etrcompanyname, etrcompanynum, etrcompanynumber, etrcompkey, etrcompnum, etrcontractnum, etrcontrolid, etrcreatedate, etrcreatedby, etrdefworkgroup, etrdiscipline, etrdistrictname, etrdivisionname, etrdloc, etrdotservice, etrdriver, etrdriverposnum, etrengineserialnum, etrfacility, etrfeeder, etrfieldaddress, etrfltarnum, etrgeind, etrgisid, etrgisobjid, etrgisresponse, etrglaccount, etrglactivity, etrglbu, etrgldept, etrglphysicallocation, etrglproduct, etrglproject, etrglresource, etrglvalidationmsg, etrid, etrinstallationtype, etrinstructbookno, etrinvnum, etrisfailed, etrisfat, etrislease, etrisleg, etrissenttopp, etritemnum, etrkey, etrkvasize, etrlabresultsid, etrlastinspdate, etrlasttimeoperated, etrlatitude, etrleased, etrlegacyload, etrlinesegnum, etrlitghold, etrlocaloffice, etrlocalofficecode, etrlongitude, etrmacaddress, etrmaintenancearea, etrmaintoutsrc, etrmaintprov, etrmaterial, etrmeterbarcode, etrmeterstyle, etrmetertype, etrmfgdate, etrmove2loc_np, etrmtnoi, etrmxcreationstate, etrnetwork, etrnotelemtry, etroldcompnum, etropco, etroptemp, etrowner, etrpalletnum, etrphase, etrphysloc, etrplant, etrplantuseonly, etrponum, etrprogram, etrprogramcontrolcode, etrprogramcreatedate, etrprogramid, etrquantity, etrratedkv, etrratingclass, etrreceiveddate, etrrefurb, etrregionname, etrrelnum, etrremarks, etrrephist, etrreplbatchnum, etrrepldunitnum, etrresidval, etrresppartyposnum, etrretirementunit, etrrmanum, etrrplreqactn, etrseqid, etrservteritory, etrshiplinenum, etrshipnum, etrsize, etrstandard, etrstate, etrstatus, etrsubstnname, etrsubtype, etrtaxarea, etrtentclass, etrtitlenum, etrtolltag, etrtown, etrtransserialnum, etruncommandedtrips, etrunitnumber, etrupdateeolrulesid, etrvendemail, etrvinnumber, etrwfrespgroup, etryearlypeakmva, expectedlife, expectedlifedate, externalrefid, failurecode, glaccount, groupname, hasld, hasld3, industryhealthgrade, industryhealthscore, installdate, invcost, isactive, isassetnum, iscalibration, isdefault, islinear, isrunning, itemnum, itemsetid, itemtype, langcode, langcode1, location, lrm, mainthierchy, manufacturer, modelid, moved, mxassetnum, orgid, orgid1, ownersysid, parent, pluscassetdept, pluscclass, pluscduedate, plusciscondesc, plusciscontam, pluscisinhousecal, pluscismte, pluscismteclass, pluscloopnum, plusclploc, pluscmodelnum, pluscoprgeeu, pluscoprgefrom, pluscoprgeto, pluscphyloc, pluscpmextdate, pluscsolution, pluscsumdir, pluscsumeu, pluscsumread, pluscsumspan, pluscsumurv, pluscvendor, plusdboxnum, plusdbusinessunit, plusddemandconst, plusddialcount, plusdequipmenttype, plusdfixedfactor, plusdfulldemand, plusdhavesamplewo, plusdmeterconfig, plusdmeterphase, plusdmetersize, plusdmetertype, plusdmultiplier, plusdneedsamplewo, plusdpalletnum, plusdpressure, plusdpressurewater, plusdprimaryind, plusdregtype, plusdsampledate, plusdsamplinggroup, plusdsamplingid, plusdsupercompress, plusdutilitytype, plussaddresscode, plussfeatureclass, plussisgis, plustacceptwarr, plustacpositionnum, plustalias, plustalias3, plustaliasdesc, plustaliasdesc3, plustassetaliasid, plustaxleconfignum, plustcomp, plustcondition, plustconmemo, plustconpos, plustcontempid, plustdepcost, plustdepexplife, plustdepexplifeuom, plustdepmeter, plustdepmeterstart, plustdepmethod, plustdepperiods, plustdepperiodtype, plustdepsalvageamt, plustdepschedulenum, plustdepstartdate, plustisconsist, plustltres, plustmodel, plustmpres, plustmprevenueaccount, plustpos, plustratetype, plustrepairlimit, plustreportlevel, plustsoldamt, plustsolddate, plustsoldmemo, plustsoldto, plusttotalmprevenue, plustyear, pmnextfaildt, priority, productid, purchaseprice, replacecost, returnedtovendor, rotsuspacct, rowstamp, rowstamp1, saddresscode, sendersysid, serialnum, shiftnum, siteid, siteid1, sourcesysid, startdescription, startmeasure, status, statusdate, templateid, tloamhash, tloampartition, toolcontrolaccount, toolrate, totalcost, totdowntime, totunchargedcost, unchargedcost, usage, vendor, warrantyexpdate, well_maintained, ytdcost) as select asset.ancestor, asset.assethealth, asset.assetid, asset.assetnum, plustassetalias.assetnum, asset.assettag, asset.assettype, asset.assetuid, asset.autowogen, asset.binnum, asset.budgetcost, asset.calnum, asset.changeby, asset.changedate, asset.children, asset.classstructureid, asset.conditioncode, asset.defaultrepfac, asset.defaultrepfacsiteid, asset.depreciationpending, asset.description, asset.deviceid, asset.devicetype, asset.direction, asset.disabled, asset.enddescription, asset.endmeasure, asset.eq1, asset.eq10, asset.eq11, asset.eq12, asset.eq2, asset.eq23, asset.eq24, asset.eq3, asset.eq4, asset.eq5, asset.eq6, asset.eq7, asset.eq8, asset.eq9, asset.estendoflife, asset.etraerialserialnum, plustassetalias.etraliastype, asset.etrallowance, asset.etrapplication, asset.etrassetclass1, asset.etrassetclass2, asset.etrastmbarcode, asset.etravailablestatus, asset.etrchassisserialnum, asset.etrcnvclassstructureid, asset.etrcnventity, asset.etrcnvmetertype, asset.etrcomment, asset.etrcompany, asset.etrcompanyequipmentnumber, asset.etrcompanyname, asset.etrcompanynum, asset.etrcompanynumber, asset.etrcompkey, asset.etrcompnum, asset.etrcontractnum, asset.etrcontrolid, asset.etrcreatedate, asset.etrcreatedby, asset.etrdefworkgroup, asset.etrdiscipline, asset.etrdistrictname, asset.etrdivisionname, asset.etrdloc, asset.etrdotservice, asset.etrdriver, asset.etrdriverposnum, asset.etrengineserialnum, asset.etrfacility, asset.etrfeeder, asset.etrfieldaddress, asset.etrfltarnum, asset.etrgeind, asset.etrgisid, asset.etrgisobjid, asset.etrgisresponse, asset.etrglaccount, asset.etrglactivity, asset.etrglbu, asset.etrgldept, asset.etrglphysicallocation, asset.etrglproduct, asset.etrglproject, asset.etrglresource, asset.etrglvalidationmsg, asset.etrid, asset.etrinstallationtype, asset.etrinstructbookno, asset.etrinvnum, asset.etrisfailed, asset.etrisfat, asset.etrislease, asset.etrisleg, asset.etrissenttopp, asset.etritemnum, asset.etrkey, asset.etrkvasize, asset.etrlabresultsid, asset.etrlastinspdate, asset.etrlasttimeoperated, asset.etrlatitude, asset.etrleased, asset.etrlegacyload, asset.etrlinesegnum, asset.etrlitghold, asset.etrlocaloffice, asset.etrlocalofficecode, asset.etrlongitude, asset.etrmacaddress, asset.etrmaintenancearea, asset.etrmaintoutsrc, asset.etrmaintprov, asset.etrmaterial, asset.etrmeterbarcode, asset.etrmeterstyle, asset.etrmetertype, asset.etrmfgdate, asset.etrmove2loc_np, asset.etrmtnoi, asset.etrmxcreationstate, asset.etrnetwork, asset.etrnotelemtry, asset.etroldcompnum, asset.etropco, asset.etroptemp, asset.etrowner, asset.etrpalletnum, asset.etrphase, asset.etrphysloc, asset.etrplant, asset.etrplantuseonly, asset.etrponum, asset.etrprogram, asset.etrprogramcontrolcode, asset.etrprogramcreatedate, asset.etrprogramid, asset.etrquantity, asset.etrratedkv, asset.etrratingclass, asset.etrreceiveddate, asset.etrrefurb, asset.etrregionname, asset.etrrelnum, asset.etrremarks, asset.etrrephist, asset.etrreplbatchnum, asset.etrrepldunitnum, asset.etrresidval, asset.etrresppartyposnum, asset.etrretirementunit, asset.etrrmanum, asset.etrrplreqactn, asset.etrseqid, asset.etrservteritory, asset.etrshiplinenum, asset.etrshipnum, asset.etrsize, asset.etrstandard, asset.etrstate, asset.etrstatus, asset.etrsubstnname, asset.etrsubtype, asset.etrtaxarea, asset.etrtentclass, asset.etrtitlenum, asset.etrtolltag, asset.etrtown, asset.etrtransserialnum, asset.etruncommandedtrips, asset.etrunitnumber, asset.etrupdateeolrulesid, asset.etrvendemail, asset.etrvinnumber, asset.etrwfrespgroup, asset.etryearlypeakmva, asset.expectedlife, asset.expectedlifedate, asset.externalrefid, asset.failurecode, asset.glaccount, asset.groupname, asset.hasld, plustassetalias.hasld, asset.industryhealthgrade, asset.industryhealthscore, asset.installdate, asset.invcost, plustassetalias.isactive, plustassetalias.isassetnum, asset.iscalibration, plustassetalias.isdefault, asset.islinear, asset.isrunning, asset.itemnum, asset.itemsetid, asset.itemtype, asset.langcode, plustassetalias.langcode, asset.location, asset.lrm, asset.mainthierchy, asset.manufacturer, asset.modelid, asset.moved, asset.mxassetnum, asset.orgid, plustassetalias.orgid, asset.ownersysid, asset.parent, asset.pluscassetdept, asset.pluscclass, asset.pluscduedate, asset.plusciscondesc, asset.plusciscontam, asset.pluscisinhousecal, asset.pluscismte, asset.pluscismteclass, asset.pluscloopnum, asset.plusclploc, asset.pluscmodelnum, asset.pluscoprgeeu, asset.pluscoprgefrom, asset.pluscoprgeto, asset.pluscphyloc, asset.pluscpmextdate, asset.pluscsolution, asset.pluscsumdir, asset.pluscsumeu, asset.pluscsumread, asset.pluscsumspan, asset.pluscsumurv, asset.pluscvendor, asset.plusdboxnum, asset.plusdbusinessunit, asset.plusddemandconst, asset.plusddialcount, asset.plusdequipmenttype, asset.plusdfixedfactor, asset.plusdfulldemand, asset.plusdhavesamplewo, asset.plusdmeterconfig, asset.plusdmeterphase, asset.plusdmetersize, asset.plusdmetertype, asset.plusdmultiplier, asset.plusdneedsamplewo, asset.plusdpalletnum, asset.plusdpressure, asset.plusdpressurewater, asset.plusdprimaryind, asset.plusdregtype, asset.plusdsampledate, asset.plusdsamplinggroup, asset.plusdsamplingid, asset.plusdsupercompress, asset.plusdutilitytype, asset.plussaddresscode, asset.plussfeatureclass, asset.plussisgis, asset.plustacceptwarr, asset.plustacpositionnum, plustassetalias.alias, asset.plustalias, plustassetalias.description, asset.plustaliasdesc, plustassetalias.plustassetaliasid, asset.plustaxleconfignum, asset.plustcomp, asset.plustcondition, asset.plustconmemo, asset.plustconpos, asset.plustcontempid, asset.plustdepcost, asset.plustdepexplife, asset.plustdepexplifeuom, asset.plustdepmeter, asset.plustdepmeterstart, asset.plustdepmethod, asset.plustdepperiods, asset.plustdepperiodtype, asset.plustdepsalvageamt, asset.plustdepschedulenum, asset.plustdepstartdate, asset.plustisconsist, asset.plustltres, asset.plustmodel, asset.plustmpres, asset.plustmprevenueaccount, asset.plustpos, asset.plustratetype, asset.plustrepairlimit, asset.plustreportlevel, asset.plustsoldamt, asset.plustsolddate, asset.plustsoldmemo, asset.plustsoldto, asset.plusttotalmprevenue, asset.plustyear, asset.pmnextfaildt, asset.priority, asset.productid, asset.purchaseprice, asset.replacecost, asset.returnedtovendor, asset.rotsuspacct, asset.rowstamp, plustassetalias.rowstamp, asset.saddresscode, asset.sendersysid, asset.serialnum, asset.shiftnum, asset.siteid, plustassetalias.siteid, asset.sourcesysid, asset.startdescription, asset.startmeasure, asset.status, asset.statusdate, asset.templateid, asset.tloamhash, asset.tloampartition, asset.toolcontrolaccount, asset.toolrate, asset.totalcost, asset.totdowntime, asset.totunchargedcost, asset.unchargedcost, asset.usage, asset.vendor, asset.warrantyexpdate, asset.well_maintained, asset.ytdcost from asset, plustassetalias where plustassetalias.assetnum = asset.assetnum and plustassetalias.siteid = asset.siteid ; grant SELECT on MAXIMO.PLUSTALIASVIEW to MAXIMO_READ ; grant UPDATE on MAXIMO.PLUSTALIASVIEW to MAXIMO_UPDATE ; commit ; commit ; BMXAA0344I - The attribute metadata is being refreshed. Thu May 27 09:34:00 CDT 2021 delete from autokey where not exists (select * from maxattributecfg c where c.autokeyname = autokey.autokeyname and c.changed != 'R') ; delete from l_maxattrcfg where ownerid in (select maxattributeid from maxattributecfg where changed = 'R') ; delete from maxattributecfg where changed = 'R' ; delete from maxviewcolumncfg where changed = 'R' ; delete from maxattribute ; delete from l_maxattribute ; insert into maxattribute (objectname, attributename, attributeno, alias, autokeyname, canautonum, classname, columnname, complexexpression, defaultvalue, domainid, eauditenabled, entityname, esigenabled, extended, handlecolumnname, isldowner, ispositive, length, localizable, maxattributeid, maxtype, mlinuse, mlsupported, mustbe, persistent, primarykeycolseq, remarks, required, restricted, sameasattribute, sameasobject, scale, searchtype, textdirection, title, userdefined) select objectname, attributename, attributeno, alias, autokeyname, canautonum, classname, columnname, complexexpression, defaultvalue, domainid, eauditenabled, entityname, esigenabled, extended, handlecolumnname, isldowner, ispositive, length, localizable, maxattributeid, maxtype, mlinuse, mlsupported, mustbe, persistent, primarykeycolseq, remarks, required, restricted, sameasattribute, sameasobject, scale, searchtype, textdirection, title, userdefined from maxattributecfg ; insert into l_maxattribute (l_maxattributeid, ownerid, langcode, remarks, title) select l_maxattrcfgid, ownerid, langcode, remarks, title from l_maxattrcfg ; update maxattributecfg set changed = 'N' where changed != 'N' ; delete from maxviewcolumn ; insert into maxviewcolumn (viewname, viewcolumnname, maxviewcolumnid, samestorageas, tablecolumnname, tablename) select viewname, viewcolumnname, maxviewcolumnid, samestorageas, tablecolumnname, tablename from maxviewcolumncfg ; update maxviewcolumncfg set changed = 'N' where changed != 'N' ; commit ; BMXAA0343I - Object metadata is being refreshed. Thu May 27 09:34:40 CDT 2021 delete from maxtable ; delete from maxtablecfg where tablename in (select entityname from maxobjectcfg where isview = 0 and changed = 'R') ; delete from maxview ; delete from maxviewcfg where viewname in (select entityname from maxobjectcfg where isview = 1 and changed = 'R') ; delete from maxobject ; delete from l_maxobject ; delete from l_maxobjectcfg where ownerid in (select maxobjectid from maxobjectcfg where changed = 'R') ; delete from maxobjectcfg where changed = 'R' ; update maxobjectcfg set changed = 'N' ; insert into maxobject (objectname, classname, description, eauditenabled, eauditfilter, entityname, esigfilter, extendsobject, imported, isview, persistent, servicename, siteorgtype, userdefined, mainobject, internal, maxobjectid, textdirection, resourcetype, hasld, langcode) select objectname, classname, description, eauditenabled, eauditfilter, entityname, esigfilter, extendsobject, imported, isview, persistent, servicename, siteorgtype, userdefined, mainobject, internal, maxobjectid, textdirection, resourcetype, hasld, langcode from maxobjectcfg ; insert into l_maxobject (l_maxobjectid, ownerid, langcode, description) select l_maxobjectcfgid, ownerid, langcode, description from l_maxobjectcfg ; insert into maxtable (addrowstamp, altixname, contentattribute, eaudittbname, exttablename, isaudittable, islangtable, langcolumnname, langtablename, maxtableid, restoredata, storagepartition, storagetype, tablename, textsearchenabled, trigroot, uniquecolumnname) select addrowstamp, altixname, contentattribute, eaudittbname, exttablename, isaudittable, islangtable, langcolumnname, langtablename, maxtableid, restoredata, storagepartition, storagetype, tablename, textsearchenabled, trigroot, uniquecolumnname from maxtablecfg ; insert into maxview (autoselect, maxviewid, viewfrom, viewname, viewselect, viewwhere) select autoselect, maxviewid, viewfrom, viewname, viewselect, viewwhere from maxviewcfg ; commit ; delete from appfielddefaults where not exists (select * from maxattribute where maxattribute.objectname = appfielddefaults.objectname and maxattribute.attributename = appfielddefaults.attributename) ; commit ; BMXAA0341I - Native indexes are being rebuilt. Thu May 27 09:34:43 CDT 2021 BMXAA0340I - Refreshing index metadata Thu May 27 09:34:43 CDT 2021 commit ; BMXAA0339I - Updating table storage partitions Thu May 27 09:34:43 CDT 2021 update maxtable set storagepartition = (select tablespace_name from user_tables where maxtable.tablename = table_name) ; update maxtablecfg set storagepartition = (select tablespace_name from user_tables where maxtablecfg.tablename = table_name) ; commit ; drop sequence maxviewseq ; create sequence maxviewseq nocycle nomaxvalue start with 173 increment by 1 ; drop sequence maxviewcolumnseq ; create sequence maxviewcolumnseq nocycle nomaxvalue start with 9305 increment by 1 ; drop sequence maxattributeseq ; create sequence maxattributeseq nocycle nomaxvalue start with 107638 increment by 1 ; drop sequence l_maxobjectcfgseq ; create sequence l_maxobjectcfgseq nocycle nomaxvalue start with 1 increment by 1 ; drop sequence maxtablecfgseq ; create sequence maxtablecfgseq nocycle nomaxvalue start with 1974 increment by 1 ; drop sequence l_maxattrcfgseq ; create sequence l_maxattrcfgseq nocycle nomaxvalue start with 1 increment by 1 ; drop sequence maxtableseq ; create sequence maxtableseq nocycle nomaxvalue start with 1974 increment by 1 ; drop sequence l_maxattributeuseq ; create sequence l_maxattributeuseq nocycle nomaxvalue start with 1 increment by 1 ; drop sequence maxobjectcfgseq ; create sequence maxobjectcfgseq nocycle nomaxvalue start with 3259 increment by 1 ; drop sequence maxviewcfgseq ; create sequence maxviewcfgseq nocycle nomaxvalue start with 173 increment by 1 ; drop sequence l_maxobjectuseq ; create sequence l_maxobjectuseq nocycle nomaxvalue start with 1 increment by 1 ; drop sequence maxattributecfgseq ; create sequence maxattributecfgseq nocycle nomaxvalue start with 107638 increment by 1 ; drop sequence maxviewcolumncfgseq ; create sequence maxviewcolumncfgseq nocycle nomaxvalue start with 9305 increment by 1 ; drop sequence maxobjectseq ; create sequence maxobjectseq nocycle nomaxvalue start with 3259 increment by 1 ; update maxsequence set maxreserved = 173 where sequencename = 'MAXVIEWSEQ' ; update maxsequence set maxreserved = 9305 where sequencename = 'MAXVIEWCOLUMNSEQ' ; update maxsequence set maxreserved = 107638 where sequencename = 'MAXATTRIBUTESEQ' ; update maxsequence set maxreserved = 1 where sequencename = 'L_MAXOBJECTCFGSEQ' ; update maxsequence set maxreserved = 1974 where sequencename = 'MAXTABLECFGSEQ' ; update maxsequence set maxreserved = 1 where sequencename = 'L_MAXATTRCFGSEQ' ; update maxsequence set maxreserved = 1974 where sequencename = 'MAXTABLESEQ' ; update maxsequence set maxreserved = 1 where sequencename = 'L_MAXATTRIBUTEUSEQ' ; update maxsequence set maxreserved = 3259 where sequencename = 'MAXOBJECTCFGSEQ' ; update maxsequence set maxreserved = 173 where sequencename = 'MAXVIEWCFGSEQ' ; update maxsequence set maxreserved = 1 where sequencename = 'L_MAXOBJECTUSEQ' ; update maxsequence set maxreserved = 107638 where sequencename = 'MAXATTRIBUTECFGSEQ' ; update maxsequence set maxreserved = 9305 where sequencename = 'MAXVIEWCOLUMNCFGSEQ' ; update maxsequence set maxreserved = 3259 where sequencename = 'MAXOBJECTSEQ' ; update maxvars set varvalue = '382' where varname = 'DBVERSION' ; commit ; update maxvars set varvalue = '5' where varname = 'NUMBEROFTAXCODES' ; commit ; delete from maxattributeskipcopy where maxattributeskipcopyid not in (select maxattributeskipcopyid from maxattributeskipcopy masc, maxattributecfg macfg where masc.attributename = macfg.attributename and masc.objectname = macfg.objectname) ; commit ; BEGIN DBMS_SCHEDULER.ENABLE('MAXIMOTSSYNC'); END; ; commit ; update maxvars set varvalue = '0' where varname = 'CONFIGURING' ; commit ; BMXAA6820I - ConfigDB completed without errors. Thu May 27 09:35:13 CDT 2021