Large Tables Data Cleanup - Storage Management/Large Tables Data Cleanup/4-MainScriptKeepOnly_TransactionPick.SQL #493
Description
Getting error when running script - Error while processing Table INVENTSUM
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : INVENTCOSTTRANSVARIANCE totalspace : 3618848768 Rowcounts : 27562836 Rowsize : 131 BatchSize : 9078
Table : WHSLOADLINE totalspace : 3482935296 Rowcounts : 2979232 Rowsize : 1169 BatchSize : 4781
ALTER INDEX [I_8175RELEASETOWAREHOUSEIDX] ON [dbo].[WHSLOADLINE] DISABLE;ALTER INDEX [I_8175INVENTTRANSIDIDX] ON [dbo].[WHSLOADLINE] DISABLE;ALTER INDEX [I_8175ORDERNUMIDX] ON [dbo].[WHSLOADLINE] DISABLE;ALTER INDEX [I_8175SHIPMENTIDIDX] ON [dbo].[WHSLOADLINE] DISABLE;ALTER INDEX [dboWHSLOADLINE5106532A-50E5-49BD-968A-CD5E5799FAA6] ON [dbo].[WHSLOADLINE] DISABLE;ALTER INDEX [dboWHSLOADLINE1E13680D-4400-4E4A-9097-09E66C30A0E3] ON [dbo].[WHSLOADLINE] DISABLE;ALTER INDEX [_dta_dams_index_WHSLOADLINE_624_878170424__K34_K35_K36] ON [dbo].[WHSLOADLINE] DISABLE;ALTER INDEX [_dta_dams_index_WHSLOADLINE_624_878170424__K35_K34_K1_K24_K27_K10_K4] ON [dbo].[WHSLOADLINE] DISABLE;ALTER INDEX [I_8175NMBEXPLICLINEIDX] ON [dbo].[WHSLOADLINE] DISABLE;
Error while processing Table WHSLOADLINE
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'WHSLOADLINE') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : SPLCOOPERWHSDIMTRACKINGSUM totalspace : 3333177344 Rowcounts : 4583838 Rowsize : 727 BatchSize : 5988
Table : TAXTRANSGENERALJOURNALACCOUNTENTRY totalspace : 3266576384 Rowcounts : 11436028 Rowsize : 285 BatchSize : 8010
Table : SPLCOOPERINTERFACESALESHEADER totalspace : 3257081856 Rowcounts : 2409341 Rowsize : 1351 BatchSize : 4415
ALTER INDEX [I_22161ORDERNUMBERIDX] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [I_22161SALESIDIDX] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [dboSPLCOOPERINTERFACESALESHEADER2CBF36E5-C7F0-43CF-AD3D-6AB79B081445] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [dboSPLCOOPERINTERFACESALESHEADER1A9C29F7-5FA1-44EF-ADFF-D5F0982ACD1B] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [I_22161STATUSDTPIDX] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [nci_wi_SPLCOOPERINTERFACESALESHEADER_5BD2A1FA4338FBF325EF64D0F6BF778A] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [nci_wi_SPLCOOPERINTERFACESALESHEADER_C957C8D064C86313F793D21D0B986FE6] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [_dta_index_SPLCOOPERINTERFACESALESHEADER_624_292763988__K16_K15_K17_2_18] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [_dta_dams_index_SPLCOOPERINTERFACESALESHEADER_624_292763988__K17_K16_K15_2_5_18] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [_dta_dams_index_SPLCOOPERINTERFACESALESHEADER_624_292763988__K16_K22_K15_K17_K21_2_8_18] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;ALTER INDEX [_dta_dams_index_SPLCOOPERINTERFACESALESHEADER_624_292763988__K16_K17_K15_2_18_28_29_32_33_42_46] ON [dbo].[SPLCOOPERINTERFACESALESHEADER] DISABLE;
Error while processing Table SPLCOOPERINTERFACESALESHEADER
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'SPLCOOPERINTERFACESALESHEADER') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : LEDGERENTRYJOURNAL totalspace : 3224035328 Rowcounts : 19885813 Rowsize : 162 BatchSize : 8841
Table : SOURCEDOCUMENTLINE totalspace : 3223740416 Rowcounts : 5548192 Rowsize : 581 BatchSize : 6533
ALTER INDEX [I_801PARENTSOURCEDOCUMENTLINEIDX] ON [dbo].[SOURCEDOCUMENTLINE] DISABLE;ALTER INDEX [I_801SOURCEDOCUMENTHEADERIDX] ON [dbo].[SOURCEDOCUMENTLINE] DISABLE;ALTER INDEX [I_801SOURCEDOCUMENTHEADERTYPEENUMIDX] ON [dbo].[SOURCEDOCUMENTLINE] DISABLE;ALTER INDEX [I_801SOURCEDOCUMENTHEADERRELATIONTYPEIDX] ON [dbo].[SOURCEDOCUMENTLINE] DISABLE;ALTER INDEX [I_801SOURCERELATIONACCOUNTINGSTATUSIDX] ON [dbo].[SOURCEDOCUMENTLINE] DISABLE;ALTER INDEX [dboSOURCEDOCUMENTLINE6133D746-233A-4788-95AA-B7B96FD99F20] ON [dbo].[SOURCEDOCUMENTLINE] DISABLE;
Error while processing Table SOURCEDOCUMENTLINE
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'SOURCEDOCUMENTLINE') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : WHSWORKTRANS totalspace : 3194855424 Rowcounts : 9829781 Rowsize : 325 BatchSize : 7772
ALTER INDEX [I_18097WORKIDLINENUM] ON [dbo].[WHSWORKTRANS] DISABLE;ALTER INDEX [I_18097INVENTDIMIDWORKIDIDX] ON [dbo].[WHSWORKTRANS] DISABLE;ALTER INDEX [dboWHSWORKTRANSE71C7C15-FDED-49DF-8C85-43F0ADABCDE7] ON [dbo].[WHSWORKTRANS] DISABLE;ALTER INDEX [dboWHSWORKTRANS65BDA9A4-186D-4459-BE95-484EED800F6A] ON [dbo].[WHSWORKTRANS] DISABLE;ALTER INDEX [I_18097TARGETLICENSEPLATEWORKIDLINENUMIDX] ON [dbo].[WHSWORKTRANS] DISABLE;
Error while processing Table WHSWORKTRANS
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'WHSWORKTRANS') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : CUSTPACKINGSLIPJOUR totalspace : 3004719104 Rowcounts : 1560776 Rowsize : 1925 BatchSize : 3555
ALTER INDEX [I_16831HCMWORKERIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831VOUCHERDATEIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831CUSTINDEX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831PARMIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831SALESIDDATEIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831PACKINGSLIPIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831SPLCOOPERCREATEDDATETIMEIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831DELIVERYPOSTALADDRESSIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831INVOICEPOSTALADDRESSIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [WDMI_1536776582_PERF_IDX_RC_132392_UI_95_USe_531_USc_0_AUC_1_TS_20200922165948_72624B0C] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [WDMI_1536776582_PERF_IDX_RC_168243_UI_94_USe_514_USc_0_AUC_1_TS_20201123202211_338197D7] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831ILDELIVERYDATEIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [I_16831PACKINGSLIPFORSALEIDX] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [_dta_index_CUSTPACKINGSLIPJOUR_128_1536776582__K38_K11_K51_K68_K69_K70_K1_71] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [_dta_index_CUSTPACKINGSLIPJOUR_128_1536776582__K68_K51_K69_K70_11] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [dboCUSTPACKINGSLIPJOUR3BD7D6CA-A460-466E-95CD-0C644B7A130C] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [dboCUSTPACKINGSLIPJOURDC863031-41B3-46C0-A6FD-CAC68D8F6D64] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [_dta_index_CUSTPACKINGSLIPJOUR_128_1536776582__K68_K69_K51_11_70] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [_dta_index_CUSTPACKINGSLIPJOUR_128_1536776582__K69_K68_K51_11] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [_dta_index_CUSTPACKINGSLIPJOUR_128_1536776582__K69_K51_K68_11] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [nci_wi_CUSTPACKINGSLIPJOUR_CABAFBD6EF5512313FC9233C772E39C3] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [nci_wi_CUSTPACKINGSLIPJOUR_123BF84B9CA100A53BE42FAF6B663F69] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [dboCUSTPACKINGSLIPJOURE5E0CC69-D843-4DB4-84C1-961F817F8270] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [dboCUSTPACKINGSLIPJOUR95EE4492-3BB4-413F-AF22-7EE5EF7FE972] ON [dbo].[CUSTPACKINGSLIPJOUR] DISABLE;ALTER INDEX [IX_CUSTPACKINGSLIPJOUR_PACKINGSLIPID] ON [ax].[CUSTPACKINGSLIPJOUR] DISABLE;
Error while processing Table CUSTPACKINGSLIPJOUR
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'CUSTPACKINGSLIPJOUR') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : INVENTTRANSORIGINPRODBOM totalspace : 2909093888 Rowcounts : 22021249 Rowsize : 132 BatchSize : 9070
Table : SPLCOOPERWHSCLOSEDWORKSALESPATIENTLOCATION totalspace : 2782609408 Rowcounts : 2976639 Rowsize : 934 BatchSize : 5355
Table : INVENTSERIAL totalspace : 2764365824 Rowcounts : 4916694 Rowsize : 562 BatchSize : 6611
Table : INVENTTRANSORIGINASSEMBLYCOMPONENT totalspace : 2688368640 Rowcounts : 22615634 Rowsize : 118 BatchSize : 9181
Table : MARKUPTRANS totalspace : 2661187584 Rowcounts : 1683495 Rowsize : 1580 BatchSize : 4026
ALTER INDEX [I_15369MARKUPTRANSIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369INTERCOMPANYREFIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369CUSTINVOICELINEIDREFIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369BANKLCIMPORTCHARGEALLOCATION_SAIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369SOURCEDOCUMENTLINE] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369ORIGTABLERECIDIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369MODULECODEIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369VOUCHERTRANSDATEIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369SPLCOOPERIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369ORIGRECIDIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [WDMI_376440465_PERF_IDX_RC_67786_UI_99_USe_315161_USc_0_AUC_1_TS_20201124082406_9323321D] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [_dta_index_MARKUPTRANS_128_376440465__K74_K44_K70_K75_K65_K66_K28_2] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [dboMARKUPTRANSFCE26404-EED1-4D75-997E-651FBA65D08C] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [dboMARKUPTRANSC04EC5CD-ED3D-4868-A3A7-7723EF555A4B] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369ITEMBASEPRICERECIDIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [ndx_ATune_KEEPSOURCEDOCUMENTLINETRANSTABLEIDDATAAREAIDPARTITION] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369SPLCOOPERCUSTPACKINGSLIPJOURIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369MARKUPTRANSPERFIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [dboMARKUPTRANS01FDF243-39AD-41C3-B6A3-D7E55A50F6B8] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [dboMARKUPTRANSE52A4AFC-BEEB-4C6C-96A1-4798918FECAB] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369GPLMARKUPAUTOIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369NMBSHIPMENTLANEIDX] ON [dbo].[MARKUPTRANS] DISABLE;ALTER INDEX [I_15369SPLCOOPERSHIPMENTIDX] ON [dbo].[MARKUPTRANS] DISABLE;
Error while processing Table MARKUPTRANS
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'MARKUPTRANS') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : PRODPARMUPDATE totalspace : 2637225984 Rowcounts : 18317819 Rowsize : 143 BatchSize : 8985
Table : INVENTVALUEREPORTTMPLINE totalspace : 2569011200 Rowcounts : 3852045 Rowsize : 666 BatchSize : 6204
ALTER INDEX [I_19341RESOURCEIDDX] ON [dbo].[INVENTVALUEREPORTTMPLINE] DISABLE;ALTER INDEX [I_19341TRANSACTIONIDIDX] ON [dbo].[INVENTVALUEREPORTTMPLINE] DISABLE;ALTER INDEX [CreatedTrxId_INVENTVALUEREPORTTMPLINE_IDX] ON [dbo].[INVENTVALUEREPORTTMPLINE] DISABLE;ALTER INDEX [I_19341CREATEDTRANSACTIONIDIDX] ON [dbo].[INVENTVALUEREPORTTMPLINE] DISABLE;ALTER INDEX [dboINVENTVALUEREPORTTMPLINEEB3CB114-6BE7-450D-9F5C-042F1170D747] ON [dbo].[INVENTVALUEREPORTTMPLINE] DISABLE;ALTER INDEX [dboINVENTVALUEREPORTTMPLINE1010B010-5C52-43C7-ADC3-FD7590BFEA0D] ON [dbo].[INVENTVALUEREPORTTMPLINE] DISABLE;
Error while processing Table INVENTVALUEREPORTTMPLINE
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'INVENTVALUEREPORTTMPLINE') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : ACCOUNTINGDISTRIBUTION totalspace : 2492710912 Rowcounts : 3462432 Rowsize : 719 BatchSize : 6015
ALTER INDEX [I_12784PARENTDISTRIBUTIONIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784SOURCEDOCUMENTHEADERIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784ACCOUNTINGEVENTIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784SOURCEDOCUMENTLINEIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784FINALIZEACCOUNTINGEVENT] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784SOURCEDOCUMENTLINEACCOUNTINGEVENTIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784ACCOUNTINGLEGALENTITYIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784REFERENCEROLESOURCEDOCUMENTLINEIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784LEDGERDIMENSIONIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784REFERENCEDISTRIBUTIONIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [I_12784ACCOUNTINGDATEIDX] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;ALTER INDEX [dboACCOUNTINGDISTRIBUTION5FA3CB48-D479-46B9-AF29-FE90AD9919AE] ON [dbo].[ACCOUNTINGDISTRIBUTION] DISABLE;
Error while processing Table ACCOUNTINGDISTRIBUTION
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'ACCOUNTINGDISTRIBUTION') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : WHSDIMTRACKING totalspace : 2473820160 Rowcounts : 6374621 Rowsize : 388 BatchSize : 7426
Table : PRODPARMHISTORICALCOST totalspace : 2473132032 Rowcounts : 9364423 Rowsize : 264 BatchSize : 8141
Table : PRODJOURNALPROD totalspace : 2427658240 Rowcounts : 6503379 Rowsize : 373 BatchSize : 7505
ALTER INDEX [dboPRODJOURNALPRODE7739DA1-D962-4841-B9CD-3B9459970DEF] ON [dbo].[PRODJOURNALPROD] DISABLE;ALTER INDEX [dboPRODJOURNALPRODCEDB4EC6-B9B4-43EE-B1E9-E581269946C7] ON [dbo].[PRODJOURNALPROD] DISABLE;
Error while processing Table PRODJOURNALPROD
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'PRODJOURNALPROD') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : MCRPRICEHISTORYREF totalspace : 2413756416 Rowcounts : 12370972 Rowsize : 195 BatchSize : 8601
Table : MCRSALESLINE totalspace : 2303295488 Rowcounts : 7182341 Rowsize : 320 BatchSize : 7801
Table : INVENTTRANSORIGINTRANSFER totalspace : 2278252544 Rowcounts : 10575109 Rowsize : 215 BatchSize : 8463
Table : DOCUREF totalspace : 2239438848 Rowcounts : 1873218 Rowsize : 1195 BatchSize : 4725
ALTER INDEX [I_11932DIRPERSONIDX] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [I_11932TYPEIDX] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [I_11932REFBUSRELIDX] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [I_11932VALUEIDX] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [I_11932DOCUMENTIDIDX] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [I_11932REFAUTHORIDX] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [I_11932REFCONTACTIDX] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [I_11932MODIFIEDDATETIMEIDX] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [nci_wi_DOCUREF_A77425E23EB11329979A068DAB8E6650] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [dboDOCUREFC03BE206-42D1-49BF-B198-D78CA02B1E17] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [ndx_ATune_REFRECIDREFTABLEIDPARTITION] ON [dbo].[DOCUREF] DISABLE;ALTER INDEX [I_11932REFTABLDIDIDX] ON [dbo].[DOCUREF] DISABLE;
Error while processing Table DOCUREF
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'DOCUREF') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : SPLCOOPERINTERFACESALESLINE totalspace : 2210168832 Rowcounts : 4257833 Rowsize : 519 BatchSize : 6795
ALTER INDEX [I_22212TRANSIDIDX] ON [dbo].[SPLCOOPERINTERFACESALESLINE] DISABLE;ALTER INDEX [I_22212HEADERINTERNALSTRIDX] ON [dbo].[SPLCOOPERINTERFACESALESLINE] DISABLE;ALTER INDEX [dboSPLCOOPERINTERFACESALESLINE2E4C378D-C8A1-4F53-883C-38781AD95104] ON [dbo].[SPLCOOPERINTERFACESALESLINE] DISABLE;ALTER INDEX [dboSPLCOOPERINTERFACESALESLINEECF8956C-3A02-4532-A38F-E7A60AAAACCC] ON [dbo].[SPLCOOPERINTERFACESALESLINE] DISABLE;ALTER INDEX [nci_wi_SPLCOOPERINTERFACESALESLINE_1787E72F9F33DDE99D089A98AC535FF0] ON [dbo].[SPLCOOPERINTERFACESALESLINE] DISABLE;ALTER INDEX [_dta_index_SPLCOOPERINTERFACESALESLINE_624_1108766895__K17_K16_K18_1] ON [dbo].[SPLCOOPERINTERFACESALESLINE] DISABLE;
Error while processing Table SPLCOOPERINTERFACESALESLINE
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'SPLCOOPERINTERFACESALESLINE') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : PURCHLINE totalspace : 2163490816 Rowcounts : 859077 Rowsize : 2518 BatchSize : 2960
ALTER INDEX [I_10684RBOPACKAGEIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684STATUSITEMIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684AGREEMENTLINEIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684TAX1099FIELDSIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684PURCHIDLINENUMIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684PURCHSTATUSIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684PURCHSTATUSANDQUANTITIESIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684CFOPTABLE_BRIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684INVENTDIMIDIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684ENTASSETPROJIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684DELIVERYPOSTALADDRESSIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684PURCHSTATUSINVENTIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684PURCHSTATUSANDDELIVERY] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684ITMIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [dboPURCHLINEC9B5D26F-4A5E-47BC-B2E7-BFE6937CC93B] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [dboPURCHLINEAAF52882-0F77-406A-B4BB-C6E69434EC24] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684PURCHSTATUSPROJIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684SPLCOOPERINVENTREFTRANSIDX] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [dboPURCHLINEC54ADA5C-C4C0-4B9E-B890-DD8C97B8B858] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [dboPURCHLINE4B61B868-45F8-4A20-8CE3-64BDCE36B391] ON [dbo].[PURCHLINE] DISABLE;ALTER INDEX [I_10684SUBCONLINENUMBERIDX] ON [dbo].[PURCHLINE] DISABLE;
Error while processing Table PURCHLINE
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'PURCHLINE') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : SALESPARMSUBTABLE totalspace : 2143756288 Rowcounts : 4317786 Rowsize : 496 BatchSize : 6898
ALTER INDEX [nci_wi_SALESPARMSUBTABLE_71AB82EF4047A0523195B2A6EB456F8E] ON [dbo].[SALESPARMSUBTABLE] DISABLE;ALTER INDEX [dboSALESPARMSUBTABLED801C427-A295-46CB-ABE9-9B4B985DB67F] ON [dbo].[SALESPARMSUBTABLE] DISABLE;ALTER INDEX [dboSALESPARMSUBTABLE691850E7-BF99-4CB6-BC80-DE50BA5E4B17] ON [dbo].[SALESPARMSUBTABLE] DISABLE;
Error while processing Table SALESPARMSUBTABLE
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'SALESPARMSUBTABLE') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : LEDGERJOURNALTRANS totalspace : 2086559744 Rowcounts : 802220 Rowsize : 2600 BatchSize : 2893
ALTER INDEX [I_14311PAYMINSTRUCTIONIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311BANKAGREEMENTEXT_RUIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311FURTHERPOSTINGRECIDIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311MCRPAYMORDERID] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311BANKRESPWORKERID_RUIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311JOURNALLINEVISIBLEIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311OFFSETACCOUNTAGREEMENT_RUIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311DIMENSIONATTRIBUTEVALUECOMBINATIONIDX1] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311PAYMREFERENCEIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311TAX1099FIELDSIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311JOURNALBALANCEIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311APPROVERIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311POOLRECID] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311DIRECTDEBITMANDATEIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311DIMENSIONATTRIBUTEVALUECOMBINATIONIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311DIMENSIONATTRIBUTEVALUESETIDX1] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311VENDTRANSIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311BANKCURRENCYTRANSFERLOG_RUIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311REVRECIDIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311MCRINVOICE] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311NUMVOUCHERIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311ACCOUNTAGREEMENT_RUIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311PLTAXDUETABLEIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311LEDGERVOUCHERTYPE_CNIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311BUDGETSOURCEIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311VOUCHERTRANSDATE] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311DIMENSIONATTRIBUTEVALUESETIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311VENDINVOICEDECLARATION_ISIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311REVRECDEFERREDLINEIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311CUSTOMERTRANSIDIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311SALESORDERIDIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311VOUCHERVOUCHERTYPE_CNIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311ILPREPAYMENTWHTREFIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311ITMCOSTIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [dboLEDGERJOURNALTRANS122EFC20-C422-4B9F-8B8F-1E11C74446E4] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [dboLEDGERJOURNALTRANS1D4BA681-919C-4EBC-B6E7-3A7F25F2091C] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311SUBBILLRENEWALLINE] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311SUBBILLESCALATIONTABLE] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311ILPROFORMA] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311ITMCOSTTRANSIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [dboLEDGERJOURNALTRANS59C83F95-D6E4-4FD9-9EFA-F72981737907] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [dboLEDGERJOURNALTRANSC327D45D-D483-4009-BC08-9D8851C2825E] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;ALTER INDEX [I_14311ILBRIDGETVOUCHERIDX] ON [dbo].[LEDGERJOURNALTRANS] DISABLE;
Error while processing Table LEDGERJOURNALTRANS
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'LEDGERJOURNALTRANS') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : CUSTTRANS totalspace : 2020147200 Rowcounts : 1020235 Rowsize : 1980 BatchSize : 3490
ALTER INDEX [I_12356VOUCHERDATEIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356BILLOFEXCHANGEIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356FK_DIMENSIONATTRIBUTEVALUESET_CUSTTRANS] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356CLOSEDDATEACCOUNTNUM] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356INVOICEACCOUNTIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356PAYMIDDATEIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356CUSTBILLINGCLASSIFICATIONIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [CreatedTrxId_CUSTTRANS_IDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356COMPANYACCOUNT] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356INVOICEACCOUNTDATEVOUCHER] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356RETAILTRANSACTIONIDIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356MCRPAYMORDERIDIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356PAYMREFERENCEIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356MCRPAYMORDERIDINVOICEIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356PAYPREDACCOUNTAMOUNTMST] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356INVOICETRANSFILTERIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356PAYPREDDATEFULLYPAID] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [dboCUSTTRANS6F0D0EF1-939B-492F-8A32-CA8791F67B86] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [dboCUSTTRANS5A5F7592-FFB3-44E7-B0F3-D7D98E4FEBD5] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [I_12356ACCOUNTINGEVENTIDX] ON [dbo].[CUSTTRANS] DISABLE;ALTER INDEX [_dta_dams_index_CUSTTRANS_624_2130366904__K3_K83_K82_K81_K24_K16] ON [dbo].[CUSTTRANS] DISABLE;
Error while processing Table CUSTTRANS
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'CUSTTRANS') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Table : SPLCOOPERWHSSHIPMENTLICENCEPLATE totalspace : 1890230272 Rowcounts : 4261782 Rowsize : 443 BatchSize : 7147
Table : WMSORDER totalspace : 1807261696 Rowcounts : 5202173 Rowsize : 347 BatchSize : 7648
ALTER INDEX [I_10553STATUSIDX] ON [dbo].[WMSORDER] DISABLE;ALTER INDEX [I_10553INVENTTRANSIDX] ON [dbo].[WMSORDER] DISABLE;ALTER INDEX [dboWMSORDER9070EF60-3512-4E82-9769-1690BC5103F9] ON [dbo].[WMSORDER] DISABLE;ALTER INDEX [dboWMSORDER97428ACF-FFA4-4B46-AFB6-21A2971DFE42] ON [dbo].[WMSORDER] DISABLE;
Error while processing Table WMSORDER
Msg 1223, Level 16, State 1, Procedure sys.xp_userlock, Line 1 [Batch Start Line 0]
Cannot release the application lock (Database Principal: 'public', Resource: 'WMSORDER') because it is not currently held.
Msg 3930, Level 16, State 1, Line 182
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
rebuild index table BATCHHISTORY
Rebuilding indexes for table: BATCHHISTORY
ALTER INDEX [I_15276BATCHJOB] ON [dbo].[BATCHHISTORY] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_15276BATCHJOBHISTORY] ON [dbo].[BATCHHISTORY] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_15276BATCH] ON [dbo].[BATCHHISTORY] REBUILD WITH (MAXDOP = 16);
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Duration for table BATCHHISTORY: 0 seconds
rebuild index table INVENTSUM
Rebuilding indexes for table: INVENTSUM
ALTER INDEX [I_10670RESERVATIONIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670CLOSEDITEMDIMIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670CLOSEDQTYIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670DIMIDIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670DIMIDCLOSEDQTYIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670QTYWMSLOCATIONPHYSINVENTIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670LPQTYPHYSINVENTIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670QTYINVENTSERIALIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670QTYINVENTBATCHIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670LOCATIONIDIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670INVENTPROFILEIDX_RU] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);ALTER INDEX [I_10670SPLCOOPERINJOEPIDX] ON [dbo].[INVENTSUM] REBUILD WITH (MAXDOP = 16);
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
ENABLE TRIGGER [INVENTSUMINSERTTRIGGER] ON [dbo].[INVENTSUM];ENABLE TRIGGER [INVENTSUMUPDATETRIGGER] ON [dbo].[INVENTSUM];
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3930, Level 16, State 1, Line 1
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Duration for table INVENTSUM: 0 seconds
rebuild index table WHSLOADLINE
Rebuilding indexes for table: WHSLOADLINE