注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

mylotustips的博客

IBM Lotus协作产品家族经验分享

 
 
 

日志

 
 
关于我

欢迎大家使用SR向IBM800提交问题http://www.ibm.com/support/servicerequest 可以随时查看问题状态,上传文件

网易考拉推荐
GACHA精选

predbxfer55.sql fails due to Primary Key violation  

2016-11-08 18:21:52|  分类: 默认分类 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

Environment:

Old DB2 10.1 on Windows Server 2012 Connections DB Schema 5.5

New DB2 10.5 on Redhat Linux 6.6 5 Connections DB Schema 5.5

Background:

The environment had been upgraded from 4.0 to 5.0, then upgraded to 5.5.

In the past customer facing some problem with Connections 5.5, they

cannot apply CR1 successfully.

Problem:

Customer is currently planning to migrate Connections DB2 database using

side-by-side option.

http://www.ibm.com/support/knowledgecenter/zh/SSYGQH_5.5.0/admin/migrate/t_migrate_db2__side_by_side.html

When removing database restrictions by running:

db2 -td@ -vf predbxfer55.sql

Getting some error with Files, Wikis and PNS

 

[10/27/16 12:51:35.453 CST] Processing table -{ APP->APP }-

[10/27/16 12:51:35.453 CST] SELECT * FROM "FILES"."APP"

[10/27/16 12:51:35.828 CST] INSERT INTO "FILES"."APP"

("ID","APP_EXTERNAL_ID","LIBRARY_ID","ORG_ID") VALUES( ?, ?, ?, ? )

 

[10/27/16 12:51:35.828 CST] Transferring table --{ FILES.APP}-- to

table --{FILES.APP }--

[10/27/16 12:51:36.047 CST] doing the check invalid pk for where clause

for column: ID

[10/27/16 12:51:36.047 CST] PKs: [ID]

[10/27/16 12:51:36.047 CST] Using PKs for this where clause has been

turned OFF

[10/27/16 12:51:36.047 CST] row {0} COMMIT completed: Table Frequency

(250)

[10/27/16 12:51:36.078 CST] Nested Exceptions:

[10/27/16 12:51:36.078 CST]

com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for

batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,

SQLERRMC=1;FILES.APP, DRIVER=3.67.27

 

[10/27/16 12:51:36.094 CST] error.executing.transfer

err.dbtransfer.exception.labelclass

com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.67.27]

Batch failure. The batch was submitted, but at least one exception

occurred on an individual member of the batch.

Use getNextException() to retrieve the exceptions for specific batched

elements

ERRORCODE=-4229, SQLSTATE=null

com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.67.27]

Batch failure. The batch was submitted, but at least one exception

occurred on an individual member of the batch.

Use getNextException() to retrieve the exceptions for specific batched

elements

ERRORCODE=-4229, SQLSTATE=null

at com.ibm.db2.jcc.am.gd.a(gd.java:477)

at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:412)

at com.ibm.db2.jcc.am.to.a(to.java:5059)

at com.ibm.db2.jcc.am.to.c(to.java:4650)

at com.ibm.db2.jcc.am.to.executeBatch(to.java:2920)

at

com.ibm.wps.config.db.transfer.DefaultTableHandler.execute(DefaultTableH

andler.java:145)

at

com.ibm.wps.config.db.transfer.TransferEngine.execute(TransferEngine.jav

a:70)

at

com.ibm.wps.config.db.transfer.CmdLineTransfer.execute(CmdLineTransfer.j

ava:96)

at

com.ibm.wps.config.db.transfer.CmdLineTransfer.main(CmdLineTransfer.java

:43)

Cause:

Delete the record in specified table as indicated in the output.

During inserting to target db, primary key violation error due

to record is not unique in ID table.

Troubleshooting:

Exported content of tables from olddb and newdb:

db2 export to files.app.txt of ixf messages filemessage.txt select *

from files.app

db2 export to wikis.app.txt of ixf messages wikimessage.txt select *

from wikis.app

db2 export to pns.apps.txt of ixf messages pnsmessage.txt select *

from pns.apps

Solution:

Delete the record in specified tables (as indicated in the output) from targetdb.

Run the predbxfer55.sql again.

  评论这张
 
阅读(92)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017