用友U861升级到U871出错解决方法|江阴雨辰互联

2023年7月13日发(作者：)

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:U8SOFTAdminSQLFILE8900MainUfdataStructuredata_prv_sa_mix_

错误信息:

-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:U8SOFTAdminSQLFILE8900MainUfdataStructureData_PRV_IM_mix_

错误信息:

-2147217900

列名 'frejectquantity' 无效。屏蔽

13数据库名: UFDATA_005_2011

E:U8SOFTAdminSQLFILE8900MainUfdataStructureData_PRV_ST_mix_

错误信息:

-2147217900

列名 'cbatchproperty1' 无效在 transvouchs cbatchproperty1-cbatchproperty10

,[cciqbookcode]

,[cbMemo]

,[irowno]

,[strowguid]

,[cinvouchtype]

,[cbsourcecodels]

,[cMoLotCode]

字段

14数据库名: UFDATA_005_2011

E:U8SOFTAdminSQLFILE8900MainUfdataStructureData_PRV_ST_mix_

错误信息:

-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:U8SOFTAdminSQLFILE8900MainUfdataStructureData_PRV_ST_mix_ 错误信息:

-2147217900

列名 'cbatchproperty1' 无效。

alter table ufdata_005_ouchs 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:U8SOFTAdminSQLFILE8900MainUfdataStructuredata_prp_im_mix_

错误信息:

-2147217900

列名 'frejectquantity' 无效。屏蔽

17 数据库名: UFDATA_005_2011

E:U8SOFTAdminSQLFILE8900MainUfdataStructureData_PRP_MO_mix_

错误信息:

-2147217900

列名 'OrgQty' 无效。

alter table ufdata_005__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

alter table ufdata_005__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

alter table ufdata_005__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:U8SOFTAdminSQLFILE8900MainUfdatadataNLData_UPDA_PB_mix_

错误信息:

-2147217900

找不到存储过程 'sp_DataPrecision_CASC' 屏蔽

19数据库名: UFDATA_005_2011 E:U8SOFTAdminSQLFILE8900MainUfdatadataDPDATA_DP_PB_MIX_

错误信息:

-2147217900

找不到存储过程 'sp_DataPrecision_CASC'。屏蔽

20数据库名: UFDATA_005_2011

E:U8SOFTAdminSQLFILE10000MainUfdataStructuredata_prv_sa_mix_

错误信息:

-2147217865

对象名 'SA_SaleOrderAscendMain' 无效。

21数据库名: UFDATA_005_2011

E:U8SOFTAdminSQLFILE10000MainUfdataStructureData_PRV_QM_mix_

错误信息:

-2147217900

列名 'IPRINTCOUNT' 不明确。指定mom_COUNT

22数据库名: UFDATA_005_2011

E:U8SOFTAdminSQLFILE10000MainUfdataStructureDATA_PRP_PB_MIX_

错误信息:

-2147217865

对象名 '_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

if (@@error<>0)

begin

set @sErrMsg = N'更新存货档案(需求跟踪方式)失败！'

return -1

cInvSubCode in (select cInvCode from #T)')

end

return 0

end 23数据库名: UFDATA_005_2011

E:U8SOFTAdminSQLFILE10000MainUfdataStructureData_PRP_CA_mix_

错误信息:

-2147217900

列名或所提供值的数目与表定义不匹配。

alter table ufdata_005__batchmxhy_tmp add

[iflag] [bit] NOT NULL

24 数据库名: UFDATA_005_2011

E:U8SOFTAdminSQLFILE10000MainUfdatadataDPDATA_DP_PB_MIX_

错误信息:

-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

)

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:U8SOFTAdminSQLFILE10100MainUfdataStructureData_PRV_EX_mix_

错误信息:

-2147217900

列名 'frejectquantity' 无效。

alter table ufdata_005__ciqbookex add

[cnapeitem] [nvarchar](100) NULL,

[frejectquantity] [decimal](28, 8) NULL

在v_ex_ciqbookex 加frejectquantity

数据库名: UFDATA_004_2011

E:U8SOFTAdminSQLFILE10100MainUfdataStructureDATA_PRV_PB_MIX_

错误信息:

-2147217900

列名 'iBOMExpandUnitType' 不明确。 at Inventory del

861升级报错

into ca_batchmxhy_tmp

发布者：admin，转转请注明出处：http://www.yc00.com/news/1689247799a225674.html

用友U861升级到U871出错解决方法

发表回复

评论列表（0条）

联系我们

400-800-8888

用友U861升级到U871出错解决方法

相关推荐

发表回复

评论列表（0条）

联系我们

400-800-8888