u63.2升级到U890的问题

lzm0731 · 发表于 2010-8-31 20:52:21

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

您需要登录才可以下载或查看，没有账号？注册账号

×

数据库名: UFDATA_001_2008
D:\U8SOFT\Admin\SQLFILE8610\Main\Ufdata\data\NL\Data_Data_QM_mix_NL.sql
错误信息:
-2147217873
违反了 PRIMARY KEY 约束 'PK_VoucherPrefabricate'。不能在对象 'dbo.VoucherPrefabricate' 中插入重复键。
执行如下语句时出错:

insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM01', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM02', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM03', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM04', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM05', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM06', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM07', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM08', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM09', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM10', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM11', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM12', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM13', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM14', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM15', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM16', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM17', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM18', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM19', '手工输入', 5, 0, '','',null,null,null,null,null)
insert into VoucherPrefabricate ( CardNumber, cContent, iContentType, iPurpose, cSourceTableName, cFieldName,cArchName, cArchFieldName, cArchclsFieldName, cKeyWord, cKeyWordNameField)
values( 'QM20', '手工输入', 5, 0, '','',null,null,null,null,null)
出现问题时，是在从U860升级到U861的过程中出现，我把该表中所有记录全部手工删后再升级，问题依旧，请问该如何处理？

lzm0731 · 发表于 2010-9-1 16:27:52

自已顶一下

firstking · 发表于 2010-9-1 21:57:05

建议LZ通U6输出到U8工具先转换数据然后再引入890直接升级报错的可能性会少些

yuanfentaikong · 发表于 2011-5-18 16:10:07

唉顶一下

DOG_Cry · 发表于 2012-9-22 10:02:56

问题来了。我也是这样的问题。

fairyfox · 发表于 2012-12-10 09:33:05

各位大侠最后怎么解决的？

账号		自动登录	找回密码
密码			注册账号

初学者课程：T3自学\|T6自学\|U8自学	软件下载｜课件下载｜工具下载	资料：通资料\|U8资料\|NC\|培训\|年结	积分规则 \| 使用常见问题Q&A
知识库:U8 \| 通 \| NC \| U9 \| OA \| 政务	U8\|U9\|NCC\|NC65\|NC65客开\|NCC客开	新手必读 \| 任务 \| 快速增金币	用友QQ群[微信群]

[求助] u63.2升级到U890的问题

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

相关帖子