U870升级U810.1报错

shuixiang

我是从U870直接升级到U810.1的，现在升级到10.0的时候报错了，提示“ 资源池 'internal' 没有足够的系统内存来运行此查询。”  以前也没遇见过这样的问题，不知道在哪里修改这个内存，有没有知道的提示下，谢谢。

shuixiang

数据库名: UFDATA_001_2007
D:\U8SOFT\Admin\SQLFILE10100\Main\Ufdata\Structure\Data_PRV_AP_mix_NL.sql
错误信息:
-2147217900
SQL Server 数据库引擎的实例此时无法获得 LOCK 资源。请在活动用户较少时重新运行该语句。请询问数据库管理员，检查此实例的锁定和内存配置，或检查是否有长时间运行的事务。

执行如下语句时出错:

CREATE VIEW [AP_V_CMExecuteRP]
AS
SELECT M.cExecID,M.cStageCode,CM_Stage.cStageName,
C.strBisectionUnit as cDwCode,--Vendor.cVenName AS cDWName,Vendor.cVenAbbName AS cDwAbbName,   
(case Upper(C.strSource) when N'C' then CT.cCusName when N'V' then VD.cVenName end) as cDWName,   
(case Upper(C.strSource) when N'C' then CT.cCusAbbName when N'V' then VD.cVenAbbName end) as cDwAbbName,     
M.cDepCode as cDeptCode,Department.cDepName,M.cPersonCode as cPerson,Person.cPersonName,
(case Upper(C.strSource) when N'C' then CT.iid when N'V' then VD.iid end) As cAuthID,
M.dtProduceDate AS dVouchDate, M.cProducer AS cOperator, M.cAuditor as cCheckMan, M.dtAuditDate AS dCheckDate,
C.strContractKind as cContractKind,C.strContractType AS cContractType,CM_Type.cTypeName AS cContractTypeName, C.strContractID AS cContractID,C.strContractName AS cContractName,C.strContractOrderDate AS dSignDate,
C.strCurrency AS cExch_Name, M.decExchangeRate AS iExchRate,   
(case when dgatheringdate is null then M.dtAuditDate + IsNull(PayCondition.iPayCreDays, 0) else dgatheringdate end) AS dExpireDate,M.cPayConditionCode as cPayCode,PayCondition.cPayName,
M.cDefine1, M.cDefine2, M.cDefine3, M.cDefine4, M.cDefine5, M.cDefine6, M.cDefine7, M.cDefine8,     
M.cDefine9, M.cDefine10, M.cDefine11, M.cDefine12, M.cDefine13, M.cDefine14, M.cDefine15, M.cDefine16,  
convert(money,m.cTimeStamp) as ufts, M.bQcBill,   
M.cGatheringPlanCode,M.dCreditStart,M.iCreditPeriod,M.dGatheringDate,M.bCredit,
cDigest,iAmount_f,iAmount,iAmount_s,(isnull(iRPMoney,0)+isnull(iBalMoney,0)) as iRPMoney,(isnull(iNatRPMoney,0)+isnull(iNatBalMoney,0)) as iNatRPMoney,
(iAmount_f-isnull(iRPMoney,0)-isnull(iBalMoney,0)) as iRAmount_f,(iAmount-isnull(iNatRPMoney,0)-isnull(iNatBalMoney,0)) as iRAmount
FROM CM_ExecuteBill M
INNER JOIN V_CM_Contract C ON M.cContractID=C.strContractID
INNER JOIN CM_Type ON CM_Type.cTypeCode = C.strContractType
-- INNER JOIN CM_Contract_Main cm ON cm.strContractID = C.strContractID
LEFT JOIN CM_Stage ON CM_Stage.cStageCode=M.cStageCode
LEFT JOIN Customer CT ON C.strBisectionUnit=CT.cCusCode
LEFT JOIN Vendor VD ON C.strBisectionUnit = VD.cVenCode LEFT JOIN Department     
ON M.cDepCode = Department.cDepCode LEFT JOIN Person     
ON M.cPersonCode = Person.cPersonCode LEFT JOIN PayCondition     
ON M.cPayConditionCode = PayCondition.cPayCode
INNER JOIN (
  select cExecID,max(cRemark) AS cDigest,sum(decRateMoney) as iAmount_f,sum(decRateBenBiMoney) as iAmount,sum(decCount) As iAmount_s,
  sum(iRPMoney) as iRPMoney,sum(iNatRPMoney) as iNatRPMoney
  from CM_ExecuteBills group by cExecID) Ms
ON Ms.cExecID = M.cExecID   
LEFT JOIN (
  select CBs.cExecID,sum(CBD.decMoney) as iBalMoney,sum(CBD.decRMB) as iNatBalMoney
  from CM_BalanceDetail CBD inner join CM_Balances CBs on CBs.BalancesGuid=CBD.BalancesGuid
  where isnull(CBD.cExecID,'') = '' group by CBs.cExecID) CMB  
ON CMB.cExecID = M.cExecID
WHERE isnull(cAuditor,'')<>'' and iAmount_f<>(isnull(iRPMoney,0)+isnull(iBalMoney,0))

我只是一个过客

太复杂了，不懂。。升级有风险。