在本地计算机无法启动T3产品服务,T3标准版提示未启动产品服务，在系统服务里面启动T3产品服务提示无法启动，是什么情况...

对应版本:用友U8.61

对应产品线：供应链

对应模块：委外管理模块

问题现象:委外倒冲形成的材料出库单,通过委外核销单可以查询出来单据号,但在材料出库单中却找不到该材料出库单,不知道是怎么回事了,导致委外核销单删除时会提示”回写材料出库单”失败,也没办法删除重新核销了。如：20060905042号核销单，其出库单号0000214096找不到了，导致核销后也没办法归集到材料成本，也没办法进行委外结算。我查了数据库，有124条记录有核销单而无材料出库单。selectc.autoid,A.ccodeas核销单号,a.ddateas核销日期,crdbustype,cvouchtype单据类型,crdvouchcode,b.cinvcode,b.iquantity,irdsid收发纪录子表ID,imsquantity核销数量,imsprice核销金额,imsmaterialfee材料费,*fromOM_MatSettleVouchasaleftjoinOM_MatSettleVouchsasbona.msid=b.msidfulljoinrdrecordsasconc.autoid=irdsidwherecvouchtype=“11“andc.autoidisnull--and(ccode=“20060905042“orccode=“20060905046“)

问题原因：可能是由于人为误删除数据库记录或其他未知原因导致部分材料出库单数据丢失。

解决方案：请参照如下步骤，从用户备份帐套中还原已丢失的材料出库单记录：--需要补充的rdrecord主表记录：createviewrdasselectdistincta.*fromrdrecordainnerjoinrdrecordsbona.id=b.idwhereb.autoidin(selectirdsidfromUFDATA_222_2006..OM_MatSettleVouchasaleftjoinUFDATA_222_2006..OM_MatSettleVouchsasbona.msid=b.msidfulljoinUFDATA_222_2006..rdrecordsasconc.autoid=irdsidwherecvouchtype=’11’andc.autoidisnull)go--需要补充的rdrecords子表记录：createviewrdsasselectdistinctb.*fromrdrecordainnerjoinrdrecordsbona.id=b.idwhereb.autoidin(selectirdsidfromUFDATA_222_2006..OM_MatSettleVouchasaleftjoinUFDATA_222_2006..OM_MatSettleVouchsasbona.msid=b.msidfulljoinUFDATA_222_2006..rdrecordsasconc.autoid=irdsidwherecvouchtype=’11’andc.autoidisnull)go--补充主表：INSERTINTO[UFDATA_222_2006].[dbo].[RdRecord]([ID],[bRdFlag],[cVouchType],[cBusType],[cSource],[cBusCode],[cWhCode],[dDate],[cCode],[cRdCode],[cDepCode],[cPersonCode],[cPTCode],[cSTCode],[cCusCode],[cVenCode],[cOrderCode],[cARVCode],[cBillCode],[cDLCode],[cProBatch],[cHandler],[cMemo],[bTransFlag],[cAccounter],[cMaker],[iNetLock],[cDefine1],[cDefine2],[cDefine3],[cDefine4],[cDefine5],[cDefine6],[cDefine7],[cDefine8],[cDefine9],[cDefine10],[dKeepDate],[dVeriDate],[bpufirst],[biafirst],[iMQuantity],[dARVDate],[cChkCode],[dChkDate],[cChkPerson],[VT_ID],[bIsSTQc],[cDefine11],[cDefine12],[cDefine13],[cDefine14],[cDefine15],[cDefine16],[cPsPcode],[cMPoCode],[gspcheck],[ipurorderid],[ipurarriveid],[iproorderid],[iarriveid],[isalebillid],[iTaxRate],[iExchRate],[cExch_Name],[cShipAddress],[bOMFirst],[iDiscountTaxType])selectID,bRdFlag,cVouchType,cBusType,cSource,cBusCode,cWhCode,dDate,cCode,cRdCode,cDepCode,cPersonCode,cPTCode,cSTCode,cCusCode,cVenCode,cOrderCode,cARVCode,cBillCode,cDLCode,cProBatch,cHandler,’shujutiaozheng’,bTransFlag,cAccounter,cMaker,iNetLock,cDefine1,cDefine2,cDefine3,cDefine4,cDefine5,cDefine6,cDefine7,cDefine8,cDefine9,cDefine10,dKeepDate,dVeriDate,bpufirst,biafirst,iMQuantity,dARVDate,cChkCode,dChkDate,cChkPerson,VT_ID,bIsSTQc,cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16,cPsPcode,cMPoCode,gspcheck,ipurorderid,ipurarriveid,iproorderid,iarriveid,isalebillid,iTaxRate,iExchRate,cExch_Name,cShipAddress,bOMFirst,iDiscountTaxTypefromrd--补充子表：INSERTINTO[UFDATA_222_2006].[dbo].[RdRecords]([AutoID],[ID],[cInvCode],[iNum],[iQuantity],[iUnitCost],[iPrice],[iAPrice],[iPUnitCost],[iPPrice],[cBatch],[cObjCode],[cVouchCode],[cFree1],[cFree2],[iFlag],[dSDate],[iTax],[iSQuantity],[iSNum],[iMoney],[iSOutQuantity],[iSOutNum],[iFNum],[iFQuantity],[dVDate],[iTrIds],[cPosition],[cDefine22],[cDefine23],[cDefine24],[cDefine25],[cDefine26],[cDefine27],[cItem_class],[cItemCode],[iPOsID],[fACost],[iDLsID],[iSBsID],[iSendQuantity],[iSendNum],[cName],[cItemCName],[iEnsID],[cFree3],[cFree4],[cFree5],[cFree6],[cFree7],[cFree8],[cFree9],[cFree10],[cBarCode],[iNQuantity],[iNNum],[cAssUnit],[dMadeDate],[iMassDate],[cDefine28],[cDefine29],[cDefine30],[cDefine31],[cDefine32],[cDefine33],[cDefine34],[cDefine35],[cDefine36],[cDefine37],[iMPoIds],[iCheckIds],[cBVencode],[cInVouchCode],[bGsp],[cGspState],[iArrsId],[cCheckCode],[iCheckIdBaks],[cRejectCode],[iRejectIds],[cCheckPersonCode],[dCheckDate],[iOriTaxCost],[iOriCost],[iOriMoney],[iOriTaxPrice],[ioriSum],[iTaxRate],[iTaxPrice],[iSum],[bTaxCost],[cPOID],[cMassUnit],[cMoLotCode],[iRefundInspectFlag],[iMaterialFee],[iProcessCost],[iProcessFee],[dMSDate],[iSMaterialFee],[iSProcessFee],[iOMoDID],[iSoDID],[strContractId],[strCode],[bFilled],[bChecked],[bRelated],[iOMoMID],[cmworkcentercode],[iMatSettleState],[iBillSettleCount],[iSoType],[iEqDID],[cVendorCode])selectAutoID,ID,cInvCode,iNum,iQuantity,iUnitCost,iPrice,iAPrice,iPUnitCost,iPPrice,cBatch,cObjCode,cVouchCode,cFree1,cFree2,iFlag,dSDate,iTax,iSQuantity,iSNum,iMoney,iSOutQuantity,iSOutNum,iFNum,iFQuantity,dVDate,iTrIds,cPosition,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cItem_class,cItemCode,iPOsID,fACost,iDLsID,iSBsID,iSendQuantity,iSendNum,cName,cItemCName,iEnsID,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,cBarCode,iNQuantity,iNNum,cAssUnit,dMadeDate,iMassDate,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,iMPoIds,iCheckIds,cBVencode,cInVouchCode,bGsp,cGspState,iArrsId,cCheckCode,iCheckIdBaks,cRejectCode,iRejectIds,cCheckPersonCode,dCheckDate,iOriTaxCost,iOriCost,iOriMoney,iOriTaxPrice,ioriSum,iTaxRate,iTaxPrice,iSum,bTaxCost,cPOID,cMassUnit,cMoLotCode,iRefundInspectFlag,iMaterialFee,iProcessCost,iProcessFee,dMSDate,iSMaterialFee,iSProcessFee,iOMoDID,iSoDID,strContractId,strCode,bFilled,bChecked,bRelated,iOMoMID,cmworkcentercode,iMatSettleState,iBillSettleCount,iSoType,iEqDID,cVendorCodefromrds缺0000215614材料出库单的记录通过如下脚本即可得知0000215614采购入库单及其到冲的材料出库单都没有记帐：select*fromia_subsidiarywhereidin(selectirdsidfromOM_MatSettleVouchasaleftjoinOM_MatSettleVouchsasbona.msid=b.msidwherea.ccodebetween’20061005056’and’20061005061’)--处理0000215614单据的方法：--1、删除该采购入库单对应的核销单：deletefromOM_MatSettleVouchswheremsidin(selectb.msidfromOM_MatSettleVouchasaleftjoinOM_MatSettleVouchsasbona.msid=b.msidwherea.ccodebetween’20061005056’and’20061005061’)deletefromOM_MatSettleVouchwhereccodebetween’20061005056’and’20061005061’--2、通过如下语句删除该采购入库单的结算标志，然后在软件中删除该采购入库单:updatebsetimatsettlestate=0fromrdrecordainnerjoinrdrecordsbona.id=b.idwherea.ccode=’单据号’andcvouchtype=’01’--3、参照执行如下语句，还原委外订单、材料耗用表中材料出库数量为0：-查询委外订单主updateom_modetailssetiMaterialSendQty=0wheremoid=(selectmoidfromOM_MOMainwhereccode=’委外订单号’)updateom_momaterialssetisendqty=0wheremoid=(selectmoidfromOM_MOMainwhereccode=’委外’订单号’)--4、重新录入或参照生成该采购入库单并进行核销即可；--删除临时视图dropviewrd,rds【注意事项】注意将客户数据做好备份！导入数据后核对一下数据，检查报表及业务操作是否正常，有问题早点发现早点解决。