1 列名'OpIssFlag' 无效 在mom_parameter 加字段
2 对象名'ex_ciqinv' 无效 升级前账套无此表,从建表
CREATE TABLE [dbo].[ex_ciqinv](
[id] [int] NOT NULL,
[guid] [nvarchar](60) NOT NULL,
[ivtid] [int] NULL,
[cvouchtype] [nvarchar](100) NULL,
[cciqinvcode] [nvarchar](30) NULL,
[cciqinvname] [nvarchar](60) NULL,
[cciqcode] [nvarchar](30) NULL,
[cciqinvstd] [nvarchar](60) NULL,
[cciqunitcode] [nvarchar](35) NULL,
[iciqinvtype] [int] NULL,
[dbegindate] [datetime] NULL,
[denddate] [datetime] NULL,
[cdefine1] [nvarchar](20) NULL,
[cdefine2] [nvarchar](20) NULL,
[cdefine3] [nvarchar](20) NULL,
[cdefine4] [datetime] NULL,
[cdefine5] [int] NULL,
[cdefine6] [datetime] NULL,
[cdefine7] [float] NULL,
[cdefine8] [nvarchar](4) NULL,
[cdefine9] [nvarchar](8) NULL,
[cdefine10] [nvarchar](60) NULL,
[cdefine11] [nvarchar](120) NULL,
[cdefine12] [nvarchar](120) NULL,
[cdefine13] [nvarchar](120) NULL,
[cdefine14] [nvarchar](120) NULL,
[cdefine15] [int] NULL,
[cdefine16] [float] NULL,
[ufts] [timestamp] NULL,
[cmemos] [nvarchar](2000) NULL
) ON [PRIMARY]
3 列名'ftransferinquantity' 无效 在ex_ciqbookim 加字段
4 列名'cnapeitem' 无效 在ex_ciqbookim加字段
5 列名'fwholequantity' 无效 在ex_ciqbookwaste加字段,然后V_ex_ciqbookwaste加字段
6 列名'frejectquantity' 无效
7数据库名: UFDATA_005_2011
E:\
U8SOFT\Admin\SQLFILE8900\Main\Ufdata\Structure\data_prv_sa_mix_nl.sql
错误信息:
-2147217865
对象名'SA_SaleOrderAscendMain' 无效。
执行如下语句时出错:(屏蔽以下视图)
alter VIEW SA_SaleOrderAscendMain
8 列名ccbcode 无效 在im_bondedbill加字段
9列名'dcbdate' 无效 在im_bondedbill加字段
10列名'cciqinvcode' 无效im_bondedbilldetail加字段
11对象名'ex_ciqinvdetail' 无效
CREATE TABLE [dbo].[ex_ciqinvdetail](
[id] [int] NOT NULL,
[autoid] [int] NOT NULL,
[cinvcode] [nvarchar](60) NULL,
[guids] [nvarchar](60) NOT NULL,
[fciqchangrate] [dbo].[exdecimal] NULL,
[cdefine22] [nvarchar](60) NULL,
[cdefine23] [nvarchar](60) NULL,
[cdefine24] [nvarchar](60) NULL,
[cdefine25] [nvarchar](60) NULL,
[cdefine26] [float] NULL,
[cdefine27] [float] NULL,
[cdefine28] [nvarchar](120) NULL,
[cdefine29] [nvarchar](120) NULL,
[cdefine30] [nvarchar](120) NULL,
[cdefine31] [nvarchar](120) NULL,
[cdefine32] [nvarchar](120) NULL,
[cdefine33] [nvarchar](120) NULL,
[cdefine34] [int] NULL,
[cdefine35] [int] NULL,
[cdefine36] [datetime] NULL,
[cdefine37] [datetime] NULL,
[cfree1] [nvarchar](20) NULL,
[cfree2] [nvarchar](20) NULL,
[cfree3] [nvarchar](20) NULL,
[cfree4] [nvarchar](20) NULL,
[cfree5] [nvarchar](20) NULL,
[cfree6] [nvarchar](20) NULL,
[cfree7] [nvarchar](20) NULL,
[cfree8] [nvarchar](20) NULL,
[cfree9] [nvarchar](20) NULL,
[cfree10] [nvarchar](20) NULL,
[cmemo] [nvarchar](2000) NULL,
[bdefault] [bit] NOT NULL
) ON [PRIMARY]
12数据库名: UFDATA_005_2011
E:\
U8SOFT\Admin\SQLFILE8900\Main\Ufdata\Structure\Data_PRV_IM_mix_NL.sql
错误信息:
-2147217900
列名'frejectquantity' 无效。 屏蔽
13数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE8900\Main\Ufdata\Structure\Data_PRV_ST_mix_NL.sql
错误信息:
-2147217900
列名'cbatchproperty1' 无效 在transvouchs cbatchproperty1-cbatchproperty10
,[cciqbookcode]
,[cbMemo]
,[irowno]
,[strowguid]
,[cinvouchtype]
,[cbsourcecodels]
,[cMoLotCode]
字段
14数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE8900\Main\Ufdata\Structure\Data_PRV_ST_mix_NL.sql
错误信息:
-2147217900
列名'cbatchproperty1' 无效。
alter table ufdata_005_2011.[dbo].[CheckVouchs] add
[cBatchProperty1] [decimal](38, 8) NULL,
[cBatchProperty2] [decimal](38, 8) NULL,
[cBatchProperty3] [decimal](38, 8) NULL,
[cBatchProperty4] [decimal](38, 8) NULL,
[cBatchProperty5] [decimal](38, 8) NULL,
[cBatchProperty6] [nvarchar](120) NULL,
[cBatchProperty7] [nvarchar](120) NULL,
[cBatchProperty8] [nvarchar](120) NULL,
[cBatchProperty9] [nvarchar](120) NULL,
[cBatchProperty10] [datetime] NULL,
[cciqbookcode] [nvarchar](20) NULL,
[cbMemo] [nvarchar](255) NULL,
[cwhpersoncode] [nvarchar](30) NULL,
[cwhpersonname] [nvarchar](50) NULL,
[irowno] [int] NULL,
[cinvouchtype] [nvarchar](2) NULL
15 数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE8900\Main\Ufdata\Structure\Data_PRV_ST_mix_NL.sql
错误信息:
-2147217900
列名'cbatchproperty1' 无效。
alter table ufdata_005_2011.dbo.assemvouchs add
[cBatchProperty1] [decimal](38, 8) NULL,
[cBatchProperty2] [decimal](38, 8) NULL,
[cBatchProperty3] [decimal](38, 8) NULL,
[cBatchProperty4] [decimal](38, 8) NULL,
[cBatchProperty5] [decimal](38, 8) NULL,
[cBatchProperty6] [nvarchar](120) NULL,
[cBatchProperty7] [nvarchar](120) NULL,
[cBatchProperty8] [nvarchar](120) NULL,
[cBatchProperty9] [nvarchar](120) NULL,
[cBatchProperty10] [datetime] NULL,
[cciqbookcode] [nvarchar](20) NULL,
[cbMemo] [nvarchar](255) NULL,
[irowno] [int] NULL,
[cvmivencode] [nvarchar](40) NULL,
[cinvouchtype] [nvarchar](2) NULL,
[cPosition] [nvarchar](40) NULL,
[iGroupNO] [int] NULL
16数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE8900\Main\Ufdata\Structure\data_prp_im_mix_nl.sql
错误信息:
-2147217900
列名'frejectquantity' 无效。 屏蔽
17 数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE8900\Main\Ufdata\Structure\Data_PRP_MO_mix_NL.sql
错误信息:
-2147217900
列名'OrgQty' 无效。
alter table ufdata_005_2011.dbo.mom_orderdetail add
[OrgQty] [dbo].[Udt_QTY] NULL,
[FmFlag] [bit] NULL,
[MinSN] [nvarchar](200) NULL,
[MaxSN] [nvarchar](200) NULL,
[SourceSvcCode] [nvarchar](30) NULL,
[SourceSvcId] [nvarchar](80) NULL,
[SourceSvcDId] [nvarchar](80) NULL,
[BomType] [tinyint] NULL,
[RoutingType] [tinyint] NULL,
[BusFlowId] [int] NULL,
[RunCardFlag] [bit] NULL,
[RequisitionFlag] [bit] NULL,
[AlloVTid] [int] NULL,
[RelsAlloVTid] [int] NULL,
[iPrintCount] [int] NULL
go
alter table ufdata_005_2011.dbo.mom_orderdetailhistory add
[OrgQty] [dbo].[Udt_QTY] NULL,
[FmFlag] [bit] NULL,
[MinSN] [nvarchar](200) NULL,
[MaxSN] [nvarchar](200) NULL,
[SourceSvcCode] [nvarchar](30) NULL,
[SourceSvcId] [nvarchar](80) NULL,
[SourceSvcDId] [nvarchar](80) NULL,
[BomType] [tinyint] NULL,
[RoutingType] [tinyint] NULL,
[BusFlowId] [int] NULL,
[RunCardFlag] [bit] NULL,
[RequisitionFlag] [bit] NULL,
[AlloVTid] [int] NULL,
[RelsAlloVTid] [int] NULL
go
alter table ufdata_005_2011.dbo.mom_moallocate add
[OrgQty] [dbo].[Udt_QTY] NULL,
[OrgAuxQty] [dbo].[Udt_QTY] NULL,
[CostItemCode] [nvarchar](60) NULL,
[CostItemName] [nvarchar](60) NULL,
[RequisitionFlag] [bit] NULL,
[RequisitionQty] [dbo].[Udt_QTY] NULL,
[RequisitionIssQty] [dbo].[Udt_QTY] NULL,
[CostWIPRel] [bit] NULL,
[MoallocateSubId] [uniqueidentifier] NULL
18数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE8900\Main\Ufdata\data\NL\Data_UPDA_PB_mix_NL.sql
错误信息:
-2147217900
找不到存储过程'sp_DataPrecision_CASC' 屏蔽
19数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE8900\Main\Ufdata\data\DP\DATA_DP_PB_MIX_NL.sql
错误信息:
-2147217900
找不到存储过程'sp_DataPrecision_CASC'。屏蔽
20数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\data_prv_sa_mix_nl.sql
错误信息:
-2147217865
对象名'SA_SaleOrderAscendMain' 无效。
21数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\Data_PRV_QM_mix_NL.sql
错误信息:
-2147217900
列名'IPRINTCOUNT' 不明确。指定mom_orderdetail.IPRINTCOUNT
22数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\DATA_PRP_PB_MIX_NL.sql
错误信息:
-2147217865
对象名'dbo.sp_TransferPEtoLP_AA' 无效。
CREATE PROCEDURE [dbo].[sp_TransferPEtoLP_AA](
@iRequireTrackStyle int,
@sErrMsg nvarchar(500) OUTPUT
) AS
begin
declare @return_status int
declare @strSQL nvarchar(4000)
exec ('Update Inventory Set cSRPolicy = ''LP'' ,bSpecialOrder=1,bTrackSaleBill=1 where cInvCode in (select cInvCode from #T)')
if (@@error<>0)
begin
set @sErrMsg = N'更新存货档案(供需政策)失败!'
return -1
end
exec ('Update Inventory_Sub Set iRequireTrackStyle ='+@iRequireTrackStyle+' where cInvSubCode in (select cInvCode from #T)')
if (@@error<>0)
begin
set @sErrMsg = N'更新存货档案(需求跟踪方式)失败!'
return -1
end
return 0
end
23数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\Data_PRP_CA_mix_NL.sql
错误信息:
-2147217900
列名或所提供值的数目与表定义不匹配。
alter table ufdata_005_2011.dbo.ca_batchmxhy_tmp add
[iflag] [bit] NOT NULL
24 数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\data\DP\DATA_DP_PB_MIX_NL.sql
错误信息:
-2147217900
找不到存储过程'sp_DataPrecision_CASC'。
Create Procedure [dbo].[sp_DataPrecision_CASC](@iStrsQuanDecDgt int,@iStrsPriDecDgt int,@iBillPrice int,
@iNumDecDgt int,@iExchRateDecDgt int,@iRateDecDgt int ,@cErrorMsg nvarchar(120) OUTPUT
)
AS
UPDATE voucheritems_base SET numpoint=@iStrsPriDecDgt
WHERE cardnum=N'CA50' and fieldname in (N'fInvStdCost',N'fLaborStdCost',N'fLaborStdCostB',N'fManuCost',N'fManuFixCost',
N'fManuFixCostB',N'fManuVarCost',N'fManuVarCostB',N'fOMCost',N'fOMCostB',N'TotalCost')
if @@ERROR<>0
BEGIN
SET @cErrorMsg=N'升级标准成本浮点位数出现错误'
RETURN -1
END
else
RETURN 0
25 数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10100\Main\Ufdata\Structure\Data_PRV_EX_mix_NL.sql
错误信息:
-2147217900
列名'frejectquantity' 无效。
alter table ufdata_005_2011.dbo.ex_ciqbookex add
[cnapeitem] [nvarchar](100) NULL,
[frejectquantity] [decimal](28, 8) NULL
在v_ex_ciqbookex 加frejectquantity
数据库名: UFDATA_004_2011
E:\U8SOFT\Admin\SQLFILE10100\Main\Ufdata\Structure\DATA_PRV_PB_MIX_NL.sql
错误信息:
-2147217900
列名'iBOMExpandUnitType' 不明确。at Inventory del
861升级报错
into ca_batchmxhy_tmp