Data capture errors during upgrade or export

Flash (Alert)


Abstract

GSR0424E and GSR7003E errors in the temporary database used to capture data from WebSphere Service Registry and Repository during upgrade or export

Content

During an upgrade, promotion or export, you see the following errors:

[20/04/09 20:00:24:968 BST] 0000000a I UOW=null source=com.ibm.sr.upgrade.tool.UpgradeTool org=null prod=null component=null thread=[P=22968:O=0:CT]
          > GSR7031I: Capturing bsrURI: e87fe9e8-79d0-40da.baac.fb598bfbac7d. Type: com.ibm.serviceregistry.sdo.impl.PolicyExpressionImpl, name: LTPA_RAMP_default_WSSecurity.
[20/04/09 20:00:25:078 BST] 0000000a I UOW=null source=com.ibm.sr.upgrade.tool.UpgradeTool org=null prod=null component=null thread=[P=22968:O=0:CT]

          > GSR7002E: An exception occurred: GSR0424E: A Problem has occurred with the temporary database used to capture and load into WSRR
com.ibm.serviceregistry.exception.movedata.MoveDataSQLException: GSR0424E: A Problem has occurred with the temporary database used to capture and load into WSRR
at com.ibm.sr.api.impl.MoveDataDBImpl.addMetadata(MoveDataDBImpl.java:513)

at...

  > GSR7003E: Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: A truncation error was encountered trying to shrink VARCHAR ''<wsp:Policy Name="LTPA_RAMP_default_WSSecurity" xmlns:sp="ht&'' to length 4000.
ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '<wsp:Policy Name="LTPA_RAMP_default_WSSecurity" xmlns:sp="ht&' to length 4000.

.....


Solution
The solution is to apply APAR IZ49797, which is available in WebSphere Service Registry and Repository V6.2.0 Fix Pack 3.

This fix is recommended as preventive maintenance before upgrading from 6.2.0.x to 6.3.


Product Alias/Synonym

WSRR

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Service Registry and Repository
Upgrade

Software version:

6.2, 6.2.0.1, 6.2.0.2, 6.2.0.3, 6.2.0.4

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Linux pSeries, Linux zSeries, Linux/x86, Solaris, Windows, z/OS

Reference #:

1390728

Modified date:

2010-05-13

Translate my page

Machine Translation

Content navigation